honeysql supports function calls by joining args with commas, e.g.
=> (hsql/format #sql/call [:foo :bar :baz])
["foo(bar, baz)"]
However sql functions have more syntax, for example group_concat(a order by
b separator ',')
So #sql/call doesn't work. I tried implementing a clause format for
group_concat:
=> (hsql/format {:group_concat [:value {:order :ordering :separator
#sql/call [:chr 9]}]})
["GROUP_CONCAT(value order by ordering separator chr(9))"]
However this doesn't work inside a select:
=> (hsql/format {:select {:group_concat [:value {:order :ordering
:separator #sql/call [:chr 9]}]} :from [:foo]})
["SELECT group_concat AS value AS ( ) FROM foo"]
Is there any solution besides dropping to raw sql?
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
---
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to clojure+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
