Fork me on GitHub
#sql
<
2016-09-27
>
bja14:09:34

in order to get back to clojure types, you're going to need a table-specific handler (barring some naming convention for table/column names)

bja14:09:12

I don't think you want to use jdbc/insert! at all. You probably need to use jdbc/exec! or jdbc/query if you're using honeysql.

donaldball14:09:10

If you want to get the generated keys without using jdbc/insert!, I seem to recall you wind up having to call jdbc/db-do-prepared with the right args, I always have to crib from an older project

richiardiandrea17:09:42

I usually use jdbc/query for these kind of things indeed, I am just surprised that insert! sees jsonb (standard type) but doesn't see keyword (my custom type)...anyways I solved by transforming the result returned by the query

richiardiandrea17:09:33

the type is not actually a type but an alias and this is maybe why it is not passing through jdbc/result-set-read-column