co.gaiwan.oak.lib.db — co.gaiwan/oak 0.5.227-rc

Convenience functions for next.jdbc/honeysql

Default to returning kebab-cased qualified maps.

execute! clj

(execute! ds qry)

execute-honey! clj

(execute-honey! ds qry)

insert! clj

(insert! ds table key-map)

munge-response clj

(munge-response o)

table-cols clj

(table-cols conn table-name)

table-names clj

(table-names conn)

update! clj

(update! ds {:keys [update set where]})

Perform a UPDATE query, sets updated_at

with-transaction clj macro

(with-transaction [sym transactable opts] & body)

Given a transactable object, gets a connection and binds it to sym, then executes the body in that context, committing any changes if the body completes successfully, otherwise rolling back any changes made.

Like with-open, if with-transaction creates a new Connection object, it will automatically close it for you.

If you are working with default options via with-options, you might want to use with-transaction+options instead.

The options map supports:

• :isolation -- :none, :read-committed, :read-uncommitted, :repeatable-read, :serializable,
• :read-only -- true / false (true will make the Connection readonly),
• :rollback-only -- true / false (true will make the transaction rollback, even if it would otherwise succeed).