next.jdbc.protocols — seancorfield/next.jdbc 1.0.0

This is the extensible core of the next generation java.jdbc library.

• Sourceable -- for producing javax.sql.DataSource objects,
• Connectable -- for producing new java.sql.Connection objects,
• Executable -- for executing SQL operations,
• Preparable -- for producing new java.sql.PreparedStatement objects,
• Transactable -- for executing SQL operations transactionally.

Connectable clj protocol

Protocol for producing a new JDBC connection that should be closed when you are finished with it.

Implementations are provided for DataSource, PreparedStatement, and Object, on the assumption that an Object can be turned into a DataSource.

get-connection clj

(get-connection this opts)

Produce a new java.sql.Connection for use with with-open.

Executable clj protocol

Protocol for executing SQL operations.

Implementations are provided for Connection, DataSource, PreparedStatement, and Object, on the assumption that an Object can be turned into a DataSource and therefore used to get a Connection.

-execute clj

(-execute this sql-params opts)

Produce a 'reducible' that, when reduced, executes the SQL and processes the rows of the ResultSet directly.

-execute-all clj

(-execute-all this sql-params opts)

Executes the SQL and produces (by default) a vector of fully-realized, datafiable hash maps from the ResultSet.

-execute-one clj

(-execute-one this sql-params opts)

Executes the SQL and produces the first row of the ResultSet as a fully-realized, datafiable hash map (by default).

Preparable clj protocol

Protocol for producing a new java.sql.PreparedStatement that should be closed after use. Can be used by Executable functions.

Implementation is provided for Connection only.

prepare clj

(prepare this sql-params opts)

Produce a new java.sql.PreparedStatement for use with with-open.

Sourceable clj protocol

Protocol for producing a javax.sql.DataSource.

Implementations are provided for strings, hash maps (db-spec structures), and also a DataSource (which just returns itself).

Extension via metadata is supported.

get-datasource clj

(get-datasource this)

Produce a javax.sql.DataSource.

Transactable clj protocol

Protocol for running SQL operations in a transaction.

Implementations are provided for Connection, DataSource, and Object (on the assumption that an Object can be turned into a DataSource).

-transact clj

(-transact this body-fn opts)

Run the body-fn inside a transaction.