libpg-clj.core — ai.z7/libpg-clj 0.1.1

add-time-label clj macro

(add-time-label p label)

Adds a UUID v1 timestamp label to a map.

Example: (add-time-label {:name "test"} :created-at) ;=> {:name "test" :created-at #uuid "..."}

close-pool clj

(close-pool pool)

Closes a connection pool, releasing all resources.

Parameters: pool - A ConnectionPool created by make-pool

Can also use (.close pool) or (with-open [pool (make-pool config)] ...).

convert-enum clj

(convert-enum tk T p)

Converts a field in map p to a [value type] pair for enum casting.

Parameters: tk - The key to convert in the map T - A type map where (get T tk) returns the enum type name p - The map containing the value to convert

Returns the map with tk's value converted to [value type] format, or the original map if tk is not present.

drop-fields clj macro

(drop-fields p & fields)

Removes specified fields from a map. Convenience wrapper around dissoc.

Example: (drop-fields {:a 1 :b 2 :c 3} :a :c) ;=> {:b 2}

explain-enum clj

(explain-enum conn name)

Retrieves all possible values for a PostgreSQL enum type.

Parameters: conn - Database connection or pool name - The enum type name as a string

Returns a vector of enum values as strings.

h-cast clj macro

(h-cast value type)

Creates a HoneySQL cast expression.

Example: (h-cast :my-field :integer) ;=> Generates SQL: my_field::integer

jdbc-exec clj

(jdbc-exec conn query & [_])

Executes a JDBC query and returns the first result.

Parameters: conn - Database connection or pool query - SQL query vector [sql & params]

Returns the first element of the execute! result (typically row count).

json-agg clj

(json-agg inner-select)

Wraps a subquery with JSON aggregation.

Creates a query that aggregates all rows from inner-select into a JSON array.

Parameters: inner-select - A HoneySQL query map

Example: (json-agg {:select [:id :name] :from [:users]}) ;=> {:select [(call :json_agg :x)] :from [[{...} :x]]}

json> clj

(json> field path)

(json> field path type)

JSONB path accessor returning JSON (preserves type).

Uses -> for single key access, #> for path (vector) access.

Parameters: field - The JSONB column name path - Key (keyword) or path (vector of keywords) type - Optional: cast result to this type

Examples: (json> :data :name) ; data::jsonb->'name' (json> :data [:user :name]) ; data::jsonb#>'{user,name}' (json> :data :age :integer) ; (data::jsonb->'age')::integer

json>> clj

(json>> field path)

(json>> field path type)

JSONB path accessor returning text (always string).

Uses ->> for single key access, #>> for path (vector) access.

Parameters: field - The JSONB column name path - Key (keyword) or path (vector of keywords) type - Optional: cast result to this type

Examples: (json>> :data :name) ; data::jsonb->>'name' (json>> :data [:user :name]) ; data::jsonb#>>'{user,name}' (json>> :data :age :integer) ; (data::jsonb->>'age')::integer

kw->pgenum clj

(kw->pgenum kw)

Converts a namespaced keyword to a PostgreSQL enum PGobject.

The keyword namespace becomes the enum type (with - replaced by _), and the keyword name becomes the enum value.

Example: (kw->pgenum :user-status/active) ;=> PGobject with type="user_status" value="active"

make-pool clj

(make-pool config)

Creates a c3p0 connection pool for PostgreSQL.

Config map keys: :classname - JDBC driver class (e.g., "org.postgresql.Driver") :subprotocol - Database subprotocol (e.g., "postgresql") :subname - Database subname (e.g., "//localhost:5432/mydb") :user - Database username :password - Database password :min-pool - Minimum/initial pool size :max-pool - Maximum pool size :prepare-threshold - PreparedStatement threshold (default 0)

Returns a ConnectionPool record (implements Closeable) with :datasource key, suitable for use with clojure.java.jdbc and with-open.

Example: (with-open [pool (make-pool config)] (jdbc/query pool ["SELECT 1"]))

total clj

A raw SQL expression for counting total rows using a window function. Useful for pagination queries to get total count alongside results.

Usage in HoneySQL: {:select [:id :name total] :from [:users]}