Clojurians Log v2

Assuming you're using next.jdbc, you need to instruct it how to deal with arrays and Clojure types, from there you should be able to just pass them in and read them out, it's been a while though so there might be some adjustments required. https://github.com/nomnom-insights/nomnom.utility-belt.sql/blob/2a4cac52ecb5224f3ebbb6a59c5e9148c68ca8b2/src/utility_belt/sql/conv.clj#L33-L72

@lukaszkorecki Isn't this a Q about HugSQL parameter substitution?

Yeah, it is but from what I remember once you set it up I think It Just Works ™️

What I do remember that it wasn't entirely working in all cases, moving off array types to jsonb was easier, more flexible and worked better with HugSQL, I use HoneySQL now so there's also that

what I’m looking for is indeed the inline functionality of honeysql

(sql/format {:update :table, :set {:array_column, [:|| :array_column [:inline :?value]]}}, {:params {:value "{m}"}})

^^ that generates the exact statement that I want:

["UPDATE table SET array_column = array_column || '{m}'"]

You can use PG array[] syntax:

update table set array_column = array_column || array[:element]

which also works if you have multiple elements in a seq/vec and want to use the value list parameter type:

update table set array_column = array_column || array[:v*:elements]

sqlvec examples of this:

(hug/sqlvec "select '{\"a\",\"b\"}' || array[:element]" {:element "c"})

["select '{\"a\",\"b\"}' || array[?]" "c"]

(hug/sqlvec "select '{\"a\",\"b\"}' || array[:v*:elements]" {:elements ["c","d"]})

["select '{\"a\",\"b\"}' || array[?,?]" "c" "d"]

thanks @curtis.summers - i’ve also tried that, i just couldn’t figure out how to pass a single char

but maybe array[:element::char] would work

it actually did 😄

update table set array_column = array_column || array[:element::"char"]

thanks @lukaszkorecki @seancorfield @curtis.summers