fx.jdbc.sql — io.github.conjurernix/fx.jdbc 0.0.1-alpha6

Convenience CRUD combinators wrapping next.jdbc.sql into effectful operations.

delete!> clj

(delete!> table where-params)

(delete!> a b c)

(delete!> connectable table where-params opts)

Executes a SQL DELETE removing rows satisfying where-params. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

find-by-keys!> clj

(find-by-keys!> table map-of-cols)

(find-by-keys!> a b c)

(find-by-keys!> connectable table map-of-cols opts)

Queries rows matching the specified column key-value map. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

get-by-id!> clj

(get-by-id!> table id)

(get-by-id!> a b c)

(get-by-id!> a b c d)

(get-by-id!> connectable table id pk-col opts)

Retrieves a single row by primary key id. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

insert!> clj

(insert!> table row-map)

(insert!> a b c)

(insert!> connectable table row-map opts)

Executes a SQL INSERT for a single row map. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

insert-multi!> clj

(insert-multi!> table rows)

(insert-multi!> a b c)

(insert-multi!> a b c d)

(insert-multi!> connectable table cols rows opts)

Executes a batch SQL INSERT for multiple rows. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

query!> clj

(query!> sql-params)

(query!> a b)

(query!> connectable sql-params opts)

Executes a SQL query returning a vector of maps. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.

update!> clj

(update!> table map-of-cols where-params)

(update!> a b c d)

(update!> connectable table map-of-cols where-params opts)

Executes a SQL UPDATE modifying map-of-cols for rows satisfying where-params. Supports explicit connectable or context-resolved ::fx-jdbc/connection / ::fx-jdbc/datasource.