org.clojars.punit-naik.sql-batcher — org.clojars.punit-naik/sql-batcher 1.0.0

build-select-query clj

(build-select-query query pkey-column)

execute! clj

(execute! db-spec query pkey-column pkey-batch)

Executes the update/delete query Returns the number of rows processed

get-pkey-batch clj

(get-pkey-batch db-spec select-query offset limit pkey-column)

join-clause clj

(join-clause query)

primary-key-column clj

(primary-key-column query)

Assumes the primary key column to be <table-name>_id

remove-trailing-semicolon clj

(remove-trailing-semicolon s)

Removes semi-colon from the end of a string

set-clause clj

Gets the set column names and their values from the update query

start-batch-processing! clj

(start-batch-processing! db-spec query batch-size & [pkey-column])

table-name clj

(table-name query)

Gets the name of the table from the large update/delete query

update-or-delete-op clj

(update-or-delete-op query)

Checks if the large query is doing an update or delete operation

where-clause clj

(where-clause query)

Extracts where clause from the large update/delete query

where-in-clause clj

(where-in-clause column-name values)