pickdict.database — org.clojars.hector/pickdict 0.2.0

Database connection and basic operations

batch-insert clj

(batch-insert db table-name records)

Insert multiple records in a batch

build-count-sql clj

(build-count-sql table-name)

Build a COUNT SQL statement

build-create-table-sql clj

(build-create-table-sql table-name columns)

Build CREATE TABLE SQL statement

build-delete-sql clj

(build-delete-sql table-name)

Build a DELETE SQL statement

build-drop-table-sql clj

(build-drop-table-sql table-name)

Build DROP TABLE SQL statement

build-insert-sql clj

(build-insert-sql table-name columns)

Build an INSERT SQL statement

build-select-sql clj

(build-select-sql table-name & {:keys [where limit offset]})

Build a SELECT SQL statement

build-table-exists-sql clj

(build-table-exists-sql)

Build SQL to check if table exists

build-table-info-sql clj

(build-table-info-sql table-name)

Build SQL to get table information

build-update-sql clj

(build-update-sql table-name columns)

Build an UPDATE SQL statement

count-records clj

(count-records db table-name)

Count records in a table

create-table clj

(create-table db table-name columns)

Create a table with given columns

default-db clj

delete-record clj

(delete-record db table-name id)

Delete a record by ID

drop-table clj

(drop-table db table-name)

Drop a table from the database

execute-command clj

(execute-command db sql params)

Execute a SQL command and return success status

execute-query clj

(execute-query db sql params)

Execute a SQL query and return results

extract-generated-id clj

(extract-generated-id insert-result)

Extract the generated ID from insert result

find-all clj

(find-all db table-name)

Find all records in a table

find-by-criteria clj

(find-by-criteria db table-name criteria)

Find records by criteria

find-by-id clj

(find-by-id db table-name id)

Find a record by ID

get-table-columns clj

(get-table-columns db table-name)

Get column names for a table

insert-record clj

(insert-record db table-name record)

Insert a record and return the generated ID

safe-db-operation clj

(safe-db-operation operation error-message)

Execute database operation with proper error handling

table-exists? clj

(table-exists? db table-name)

Check if a table exists in the database

transaction clj

(transaction db operations)

Execute operations within a database transaction

try-db-operation clj

(try-db-operation operation error-message)

Execute database operation, returning nil on error

update-record clj

(update-record db table-name id updates)

Update a record by ID