sql-file.sql-util — com.mschaef/sql-file 0.4.11

columnar-result clj

(columnar-result query-result)

Return a sequence consisting of the values from a result set composed of scalar (single column) rows.

query-all clj

(query-all db-connection query-spec)

Query, returning a sequence of all rows in a given result set.

query-column clj

(query-column db-connection query-spec)

Issue a query for a result set containing a single column and return a sequence of those values.

query-first clj

(query-first db-connection query-spec)

Issue a query and return the first row of the result set, or nil if the result set is empty.

query-scalar clj

(query-scalar db-connection query-spec)

(query-scalar db-connection query-spec default)

Issue a database query and return the scalar result, if there is one. Return the specified default otherwise.

query-scalar-required clj

(query-scalar-required db-connection query-spec)

Issue a database query and return the scalar result if there is one. Throws an exception in the event the query does not return a result.

scalar-result clj

(scalar-result query-result)

(scalar-result query-result default)

Return a scalar value from the given query result set, or the default value if the result set is empty. This can return nil in the event the result set contains a row, but the column value is null.