honeysql 2024-02-26 | Slack Archive

FABRICIO18:02:56

Hello guys... i have a doubt with a query... sorry if this is not the place to ask this kind of things... the query is the following...

(defn candidate-users-with-setting-query
  [candidate-id setting-name roles]
  (let [query (get-candidate-followers-query candidate-id)]
    (cond-> query
      (seq roles) (sqlh/merge-where (sql/raw "u.role IN ('admin', 'user')")))))

roles arg is a collection of strings like ("admin" "user") and i want to use it directly like [:in :u.role roles] instead of using sql/raw so i don't have to build the raw string. The vector sintax doesn't work because role column is an enum type. Is there a way to cast the collection or make it work that way? Thanks in advance...

p-himik18:02:42

> The vector sintax doesn't work because role column is an enum type. The two things aren't related. Preparing parameters doesn't work with enums. So you either gotta inline the values in or use casting. For inlining, just wrap each value in [:inline ...]. For casting, you can use [:cast ... :the_enum].

p-himik18:02:05

Of course, inlining should be avoided if you need caching or if the data comes from an unsafe place.

2024-02-26

Channels