honeysql 2022-09-07 | Slack Archive

Is there a way to set the honeysql checking mode globally you can for the dialect and quoting options?

Not currently. Feel free to create a GH issue about it!

hello all, how do I convert this to helper?

{:with [[:ce {:insert-into  ...}
to:
(sqlh/with 
       (sqlh/insert-into ...)) ?

Are you looking for this result?

user=> (-> (with [:ce (insert-into :table)]) (sql/format))
["WITH ce AS (INSERT INTO table)"]
user=>

thank you Sean, I'll try that

what is that [:ce stuff?

I copied it from your code @U0YJJPFRA

{:with [[:ce {:insert-into  ...}

The :with clause takes a sequence of pairs as a value. The helper takes any number of pairs. That's typically how all helpers work.

oh ok. It's information for with and not an operator, I got it, thank you again

It's like this:

user=> (-> (select :a [:b :c] [[:+ :d :e] :f]) (from :table) (sql/format))
["SELECT a, b AS c, d + e AS f FROM table"]
user=>

Compare with the raw data structure:

user=> (-> (select :a [:b :c] [[:+ :d :e] :f]) (from :table))
{:select [:a [:b :c] [[:+ :d :e] :f]], :from [:table]}
user=>

yes, undertood

2022-09-07