Added clojure-mode, syntax highlighting, and permalinks to https://www.john-shaffer.com/honeysql/

e.g., https://www.john-shaffer.com/honeysql/?q=%7B%3Aupdate%20%3Afoos%0A%20%3Aset%20%7B%3Ais-default%20%5B%3Anullif%20%5B%3A%3D%20%3Aid%20%22dsr-000%22%5D%20false%5D%7D%7D&opt=%7B%3Apretty%20true%7D

I'd like to add multiple versions in a dropdown (once it's relevant), so the permalinks will stay perma

@jshaffer2112 Is this something you're planning to keep online and maintain now? Just wondering whether to add it to the docs since I think it's a great resource!

Yes, I'll keep it maintained. It'd be nice to have it in the docs

I use it all the time

Cool. I've made a note to remind me to add it to the docs. Thank you!

[honeysql-postgres.helpers :as psqlh]

(defn upsert!
  [table record constraint-name where-clause]
  (-> (insert-into table)
      (values [record])
      (where* where-clause)
      (psqlh/upsert (-> (psqlh/on-conflict-constraint constraint-name)
                        (psqlh/do-update-set :id
                                             :tag)
                        ))
      sql/format)
  )

{:id "abcdef", :tag {:ab "hello" :bc "world"}}

I tried replacing :id :tag with (keys record)

but it didnt help

This is the input format for psqlh/do-update-set

(defhelper do-update-set [m args]
  (assoc m :do-update-set (sqlh/collify args)))

(keys record) => (:id :tag)

@aditi.mishra That's for the nilenso library?

I suspect you could do something like (assoc :do-update-set (into [] (keys record))) depending on exactly what that do-update-set helper uses as the underlying key...