Imports

Types

func add[T: sqlite.DbConn | postgres.DbConn](pool: var Pool; dbConn: T): Add a connection to the pool.

Use to return a borrowed connection to the pool.
func close(pool: var Pool): Close the pool by closing and removing all its connetions.
func defaultSize(pool: Pool): Natural
proc newPool[T: postgres.DbConn](defaultSize: Positive; getDbProc = postgres.getDb; poolExhaustedPolicy = pepRaise): Pool[T]: Create a Postgres connection pool of the given size.

poolExhaustedPolicy defines how the pool reacts when a connection is requested but the pool has no connection available:

pepRaise (default) means throw PoolExhaustedError

pepExtend means “add another connection to the pool.”
proc newPool[T: sqlite.DbConn](defaultSize: Positive; getDbProc = sqlite.getDb; poolExhaustedPolicy = pepRaise): Pool[T]: Create an SQLite connection pool of the given size.

poolExhaustedPolicy defines how the pool reacts when a connection is requested but the pool has no connection available:

pepRaise (default) means throw PoolExhaustedError

pepExtend means “add another connection to the pool.”
proc pop[T: sqlite.DbConn | postgres.DbConn](pool: var Pool[T]): T: Take a connection from the pool.

If you're calling this manually, don't forget to add it back!
func reset(pool: var Pool): Reset pool size to defaultSize by closing and removing extra connections.
func size(pool: Pool): Natural

template withDb(pool: var Pool; body: untyped): untyped: Wrapper for DB operations.

Takes a DbConn from a pool as db variable, runs your code in a try block, and returns connection to the pool afterward.