This is the trivial-pooled-database Reference Manual, version 0.1.11, generated automatically by Declt version 4.0 beta 2 "William Riker" on Sun Dec 15 07:57:06 2024 GMT+0.
The main system appears first, followed by any subsystem dependency.
trivial-pooled-databaseA DB multi-threaded connection pool.
Eric Diethelm <ediethelm@yahoo.com>
MIT
0.1.11
trivial-utilities (system).
trivial-object-lock (system).
log4cl (system).
bordeaux-threads (system).
iterate (system).
cl-dbi (system).
parse-number (system).
package.lisp (file).
trivial-pooled-database.lisp (file).
Files are sorted by type and then listed depth-first from the systems components trees.
trivial-pooled-database/trivial-pooled-database.asdtrivial-pooled-database/package.lisptrivial-pooled-database/trivial-pooled-database.lisptrivial-pooled-database/trivial-pooled-database.asdtrivial-pooled-database (system).
trivial-pooled-database/package.lisptrivial-pooled-database (system).
trivial-pooled-database/trivial-pooled-database.lisptrivial-pooled-database (system).
execute (function).
execute-function (function).
initialize-connection-pool (function).
insert (function).
pool-initialized-p (function).
select (function).
shutdown-connection-pool (function).
update (function).
within-transaction (macro).
acquire-connection (function).
check-connection-and-reconnect-if-necessary (function).
connect (function).
connected-p (reader method).
(setf connected-p) (writer method).
connection-parameters (class).
connection-pool (class).
dbi-connection (reader method).
(setf dbi-connection) (writer method).
dbi-connection-proxy (reader method).
(setf dbi-connection-proxy) (writer method).
dbi-connection-proxy (class).
dbi-pooled-connection (reader method).
(setf dbi-pooled-connection) (writer method).
dbi-pooled-connection (class).
disconnect (function).
get-connection-pool (function).
host (reader method).
owner-thread (reader method).
(setf owner-thread) (writer method).
parameters (reader method).
password (reader method).
pool (reader method).
release-connection (function).
schema (reader method).
semaphore (reader method).
semaphore (reader method).
(setf semaphore) (writer method).
set-connection-pool (function).
username (reader method).
with-connection (macro).
Packages are listed by definition order.
trivial-pooled-databasetrivial-pooled-database provides a multi-threaded DB connection pool.
common-lisp.
execute (function).
execute-function (function).
initialize-connection-pool (function).
insert (function).
pool-initialized-p (function).
select (function).
shutdown-connection-pool (function).
update (function).
within-transaction (macro).
acquire-connection (function).
check-connection-and-reconnect-if-necessary (function).
connect (function).
connected-p (generic reader).
(setf connected-p) (generic writer).
connection-parameters (class).
connection-pool (class).
dbi-connection (generic reader).
(setf dbi-connection) (generic writer).
dbi-connection-proxy (generic reader).
(setf dbi-connection-proxy) (generic writer).
dbi-connection-proxy (class).
dbi-pooled-connection (generic reader).
(setf dbi-pooled-connection) (generic writer).
dbi-pooled-connection (class).
disconnect (function).
get-connection-pool (function).
host (generic reader).
owner-thread (generic reader).
(setf owner-thread) (generic writer).
parameters (generic reader).
password (generic reader).
pool (generic reader).
release-connection (function).
schema (generic reader).
semaphore (generic reader).
(setf semaphore) (generic writer).
set-connection-pool (function).
username (generic reader).
with-connection (macro).
Definitions are sorted by export status, category, package, and then by lexicographic order.
Execute all statements in **BODY** within a DB transaction using a single connection. NOTE: Does nothing at the moment; implementation missing!
Allows for execution of a freely defined SQL command *CMD*.
Executes a DB stored function identified by *FN-NAME* with the given *PARAMETERS* (if any) and returns it’s value.
Initialize the connection pool by providing access credentials to the database and additionaly pool size information.
*USER* - user name
*PWD* - user password
*SCHEMA* - database schema to use
*HOST* - database host name or IP address
*INITIAL-POOL-SIZE* - the number of connections to be created at initialization
*MAX-POOL-SIZE* - Maximal number of connections allowed
Inserts a new entry into the database *TABLE* assigning each element in *VALUES* to its corresponding *FIELD*.
Selects all entries from *TABLE* matching the *WHERE* clause returning the *FIELDS* (might be ’*’ to select all fields of the table). Optionally *LIMIT* indicates the maximum number of entries to return and *ORDER-BY* defines the ordering of the result.
Disconnects all database connections and shuts down the connection pool.
Updates an entry of the table *TABLE* matching the *WHERE* clause. Each element in *VALUES* is assigned to its corresponding *FIELD*.
Allows for safe acquisition and release of a pooled connection. In BODY a connection named be the symbol CONNECTION can be used.
dbi-pooled-connection)) ¶automatically generated reader method
dbi-pooled-connection)) ¶automatically generated writer method
dbi-connection-proxy)) ¶automatically generated reader method
dbi-connection-proxy)) ¶automatically generated writer method
dbi-pooled-connection)) ¶automatically generated reader method
dbi-pooled-connection)) ¶automatically generated writer method
dbi-connection-proxy)) ¶automatically generated reader method
dbi-connection-proxy)) ¶automatically generated writer method
connection-parameters)) ¶automatically generated reader method
host.
dbi-pooled-connection)) ¶automatically generated reader method
dbi-pooled-connection)) ¶automatically generated writer method
dbi-pooled-connection)) ¶automatically generated reader method
connection-parameters)) ¶automatically generated reader method
connection-pool)) ¶automatically generated reader method
connection-parameters)) ¶automatically generated reader method
connection-pool)) ¶automatically generated reader method
dbi-pooled-connection)) ¶automatically generated reader method
dbi-pooled-connection)) ¶automatically generated writer method
connection-parameters)) ¶automatically generated reader method
string
""
:username
This slot is read-only.
string
""
:password
This slot is read-only.
string
""
:schema
This slot is read-only.
bordeaux-threads:semaphore
(error "this instance needs an explicit semaphore initialization")
:semaphore
This slot is read-only.
trivial-pooled-database::dbi-connection-proxy
(make-instance (quote trivial-pooled-database::dbi-connection-proxy))
(bordeaux-threads:make-semaphore :count 1)
boolean
trivial-pooled-database::connection-parameters
:parameters
This slot is read-only.
| Jump to: | (
A C D E F G H I M O P R S U W |
|---|
| Jump to: | (
A C D E F G H I M O P R S U W |
|---|
| Jump to: | C D H O P S U |
|---|
| Jump to: | C D H O P S U |
|---|
| Jump to: | C D F P S T |
|---|
| Jump to: | C D F P S T |
|---|