sql-file.middleware — com.mschaef/sql-file 0.6.3

A current database connection for a body of code, opened only when something first uses it.

with-db-connection (and wrap-db-connection, for a Ring-style handler) makes a database available to its body without opening a connection. The connection is opened the first time current-db-connection is called (by a query, a transaction, or anything else that needs it), kept for the rest of the body, and closed (returned to its pool, for a pooled database) when the body ends. A body that never uses the database never opens a connection.

*db* clj

call-with-db-connection clj

(call-with-db-connection db-connection f)

Call f with db-connection (a db-spec, such as a pool from sql-file.core/open-pool) available as the current database. A connection is opened only if f uses it, and is closed when f returns or throws. A db-spec that already has an open :connection is used as it is, and left open.

call-with-db-transaction clj

(call-with-db-transaction fn)

current-db-connection clj

(current-db-connection)

The current database, as a db-spec with an open :connection, connecting first if this is its first use. Fails if there is no current database.

db clj

(db)

with-db-connection clj macro

(with-db-connection db-connection & body)

with-db-transaction clj macro

(with-db-transaction & body)

wrap-db-connection clj

(wrap-db-connection app db-connection)

Ring-style middleware: run each request with db-connection as the current database (see call-with-db-connection). Requests that don't use the database don't open a connection.