mdr2.db

Persistence for productions

delete!

(delete! {:keys (id)})(delete! {:keys (id)} {:keys [connection]})

Remove the production with the given id

find

(find {:keys (id)})(find {:keys (id)} {:keys [connection]})

Return production for given id

find-all

(find-all)(find-all {} {:keys [connection]})

Return all productions

find-all-in-production

(find-all-in-production)(find-all-in-production {} {:keys [connection]})

Return all productions

find-archived

(find-archived {:keys (id)})(find-archived {:keys (id)} {:keys [connection]})

Return archived production for given id

find-archived-by-library-signature

(find-archived-by-library-signature {:keys (library_signature)})(find-archived-by-library-signature {:keys (library_signature)} {:keys [connection]})

Return the archived productions for given library_signature

find-archived-by-productnumber

(find-archived-by-productnumber {:keys (product_number)})(find-archived-by-productnumber {:keys (product_number)} {:keys [connection]})

Return the production for given product_number

find-archived-by-title-or-creator

(find-archived-by-title-or-creator {:keys (term)})(find-archived-by-title-or-creator {:keys (term)} {:keys [connection]})

Return the archived productions for given title or creator

find-archived-by-year

(find-archived-by-year {:keys (year)})(find-archived-by-year {:keys (year)} {:keys [connection]})

Return archived production for given year

find-archived-by-year-month

(find-archived-by-year-month {:keys (month year)})(find-archived-by-year-month {:keys (month year)} {:keys [connection]})

Return archived production for given year and month

find-by-productnumber

(find-by-productnumber {:keys (product_number)})(find-by-productnumber {:keys (product_number)} {:keys [connection]})

Return the production for given product_number

find-by-state

(find-by-state {:keys (state)})(find-by-state {:keys (state)} {:keys [connection]})

Return the production for given state

find-production-type

(find-production-type {:keys (id)})(find-production-type {:keys (id)} {:keys [connection]})

Return the production type for given id

find-state

(find-state {:keys (id)})(find-state {:keys (id)} {:keys [connection]})

Return the state for given id

find-user

(find-user {:keys (id)})(find-user {:keys (id)} {:keys [connection]})

Return the user with the given id

find-user-roles

(find-user-roles {:keys (id)})(find-user-roles {:keys (id)} {:keys [connection]})

Return all roles for the user with the given id

get-generated-key

(get-generated-key result)

Get the generated key from an insert! result. Returns nil if the result is not from an insert

get-user

(get-user username)

Return the user with the given username

insert!

(insert! production)

Insert the given production

update!

(update! {:keys [library_number product_number id], :as production})

Update the production with the given id, product_number or library_number