e85th.commons.sql — e85th/commons 0.1.29

as-clj-identifier clj

(as-clj-identifier s)

as-sql-identifier clj

(as-sql-identifier s)

clojurize-returned-row clj

(clojurize-returned-row data)

default-batch-size clj

delete! clj

(delete! db table where-clause)

Delete. (sql/delete! (:db system) :schema.table-name ["id = ?" 42])

execute-update clj

(execute-update cn sql)

Returns number of rows affected

execute-with-cn clj

(execute-with-cn cn sql)

execute-wo-txn! clj

(execute-wo-txn! db sql)

Executes statement outside of any implicit transactions. Useful in executing vacuum for example.

idealize-row clj

Removes all entries from input map where the value is nil.

idealize-rs clj

Returns a result set standardized by idealize-row

insert! clj

(insert! db table row)

(insert! db table row user-id)

Returns the inserted row as a map. When user-id is specified, created-by and updated-by fields will be assocd into the row.

insert-multi! clj

(insert-multi! db table rows)

(insert-multi! db table rows batch-size)

Batch inserts

insert-multi-with-audits! clj

(insert-multi-with-audits! db table rows user-id)

(insert-multi-with-audits! db table rows user-id batch-size)

Batch insert with audits.

insert-multi-with-create-audits! clj

(insert-multi-with-create-audits! db table rows user-id)

(insert-multi-with-create-audits! db table rows user-id batch-size)

Batch insert with create audits.

insert-with-create-audits! clj

(insert-with-create-audits! db table row user-id)

Adds in keys :created-by to the row and calls insert!

new-connection-pool clj

(new-connection-pool ds-opts)

Makes a new connection pool with a :datasource key. See hikari for the keys in the ds-opts map.

query clj

(query db sql-and-params)

Returns a seq of maps representing the result set. (sql/query* (:db system) ["select * from schema.table where id = ?" 12])

query1 clj

(query1 db sql-and-params)

Same as query, but removes keys with nil value. Similar to Datomic, helps with spec, so you don't have (optional) keys where the values are nilable.

truncate-table! clj

(truncate-table! db table)

unique-violation? clj

(unique-violation? ex)

Postgres unique violation for the exception? https://www.postgresql.org/docs/current/static/errcodes-appendix.html

update! clj

(update! db table row where-clause)

(update! db table row where-clause user-id)

(update! db table row where-clause user-id optimistic?)

Returns count of rows updated. (sql/update! (:db system) :schema.table-name {:first-name "Mary"} ["id = ?" 42])