magnet.sql-utils — magnet/sql-utils 0.4.12

coll->jdbc-array clj

(coll->jdbc-array coll type-name)

coll->pg-jsonb clj

(coll->pg-jsonb c)

Convert coll c into a Postgresql jsonb compatible object.

instant->sql-timestamp clj

(instant->sql-timestamp instant)

Convert clojure.java-time/Instant instant into a SQL Timestamp

json->pg-jsonb clj

(json->pg-jsonb json)

Convert json string into a Postgresql jsonb compatible object. In order to persist JSON into Postgresql we need to wrap the json into a PGObject and set the "jsonb" type on it. See https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/util/PGobject.html

keyword->pg-enum clj

(keyword->pg-enum kw enum-type)

Convert keyword kw into a Postgresql enum-type enum compatible object. enum-type is a string holding the name of the Postgresql enum type.

map->pg-jsonb clj

(map->pg-jsonb m)

Convert map m into a Postgresql jsonb compatible object.

pg-enum->keyword clj

(pg-enum->keyword pg-enum enum-type)

Convert pg-enum from enum-type compatible value into a keyword. enum-type is a string holding the name of the Postgresql enum type. pg-enum must be either a PGobject of enum-type type or a string[1]. Otherwise, it asserts.

[1] This is because some versions of Postgresql or Postgresql client driver return enums as PGobjects and other as plain strings

pg-json->coll clj

(pg-json->coll pg-json)

Convert PostgreSQL Object pg-object into a Clojure collection.

sql-delete! clj

(sql-delete! db-spec logger table where-clause)

FIXME: document this function

sql-execute! clj

(sql-execute! db-spec logger sql-statement)

FIXME: document this function

sql-insert! clj

(sql-insert! db-spec logger table cols values)

FIXME: document this function

sql-insert-multi! clj

(sql-insert-multi! db-spec logger table cols values)

FIXME: document this function

sql-query clj

(sql-query db-spec logger sql-statement)

FIXME: document this function

sql-update! clj

(sql-update! db-spec logger table set-map where-clause)

FIXME: document this function

sql-update-or-insert! clj

(sql-update-or-insert! db-spec logger table set-map where-clause)

FIXME: document this function