next.jdbc.result-set — seancorfield/next.jdbc 1.0.0

An implementation of ResultSet handling functions.

Defines the following protocols:

• DatafiableRow -- for turning a row into something datafiable
• ReadableColumn -- to read column values by label or index
• RowBuilder -- for materializing a row
• ResultSetBuilder -- for materializing a result set

Also provides the default implemenations for Executable and the default datafy/nav behavior for rows from a result set.

as-arrays clj

(as-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of column names followed by vectors of row values.

as-lower-arrays clj

(as-lower-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of lower-case column names followed by vectors of row values.

as-lower-maps clj

(as-lower-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows, with lower-case keys.

as-maps clj

(as-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows.

This is the default :builder-fn option.

as-modified-arrays clj

(as-modified-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of modified column names followed by vectors of row values.

Requires both the :qualifier-fn and :label-fn options.

as-modified-maps clj

(as-modified-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows, with modified keys.

Requires both the :qualifier-fn and :label-fn options.

as-unqualified-arrays clj

(as-unqualified-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of simple column names followed by vectors of row values.

as-unqualified-lower-arrays clj

(as-unqualified-lower-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of simple, lower-case column names followed by vectors of row values.

as-unqualified-lower-maps clj

(as-unqualified-lower-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows, with simple, lower-case keys.

as-unqualified-maps clj

(as-unqualified-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows, with simple keys.

as-unqualified-modified-arrays clj

(as-unqualified-modified-arrays rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces a vector of simple, modified column names followed by vectors of row values.

Requires the :label-fn option.

as-unqualified-modified-maps clj

(as-unqualified-modified-maps rs opts)

Given a ResultSet and options, return a RowBuilder / ResultSetBuilder that produces bare vectors of hash map rows, with simple, modified keys.

Requires the :label-fn option.

datafiable-result-set clj

(datafiable-result-set rs connectable opts)

Given a ResultSet, a connectable, and an options hash map, return a fully realized, datafiable result set per the :builder-fn option passed in. If no :builder-fn option is provided, as-maps is used as the default.

This can be used to process regular result sets or metadata result sets.

DatafiableRow clj protocol

Protocol for making rows datafiable and therefore navigable.

The default implementation just adds metadata so that datafy can be called on the row, which will produce something that nav can be called on, to lazily navigate through foreign key relationships into other tables.

If datafiable-row is called when reducing the result set produced by next.jdbc/plan, the row is fully-realized from the ResultSet first.

datafiable-row clj

(datafiable-row this connectable opts)

Produce a datafiable representation of a row from a ResultSet.

get-column-names clj

(get-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of column names, each qualified by the table from which it came.

get-lower-column-names clj

(get-lower-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of lower-case column names, each qualified by the table from which it came.

get-modified-column-names clj

(get-modified-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of modified column names, each qualified by the table from which it came.

Requires both the :qualifier-fn and :label-fn options.

get-unqualified-column-names clj

(get-unqualified-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of unqualified column names.

get-unqualified-lower-column-names clj

(get-unqualified-lower-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of unqualified column names.

get-unqualified-modified-column-names clj

(get-unqualified-modified-column-names rsmeta opts)

Given ResultSetMetaData, return a vector of unqualified modified column names.

Requires the :label-fn option.

ReadableColumn clj protocol

Protocol for reading objects from the java.sql.ResultSet. Default implementations (for Object and nil) return the argument, and the Boolean implementation ensures a canonicalized true/false value, but it can be extended to provide custom behavior for special types.

read-column-by-index clj

(read-column-by-index val rsmeta idx)

Function for transforming values after reading them via a column index.

read-column-by-label clj

(read-column-by-label val label)

Function for transforming values after reading them via a column label.

ResultSetBuilder clj protocol

Protocol for building result sets in various representations.

Default implementations for building vectors of hash maps and vectors of column names and row values: MapResultSetBuilder & ArrayResultSetBuilder

->rs clj

(->rs _)

Called to create the basis of the result set.

rs! clj

(rs! _ rs)

Called to finalize the result set once it is complete.

with-row clj

(with-row _ rs row)

Called with the result set and the row to be added.

RowBuilder clj protocol

Protocol for building rows in various representations.

The default implementation for building hash maps: MapResultSetBuilder

->row clj

(->row _)

Called once per row to create the basis of each row.

column-count clj

(column-count _)

Return the number of columns in each row.

row! clj

(row! _ row)

Called once per row to finalize each row once it is complete.

with-column clj

(with-column _ row i)

Called with the row and the index of the column to be added; this is expected to read the column value from the ResultSet!