The cl-dbi Reference Manual

Table of Contents

Next: , Previous: , Up: (dir)   [Contents][Index]

The cl-dbi Reference Manual

This is the cl-dbi Reference Manual, version 0.1, generated automatically by Declt version 2.3 "Robert April" on Tue Feb 20 07:59:21 2018 GMT+0.


Next: , Previous: , Up: Top   [Contents][Index]

1 Introduction

CL-DBI - Database independent interface for Common Lisp

Build Status

Usage

Connecting and executing a query

(defvar *connection*
  (dbi:connect :mysql
               :database-name "test"
               :username "nobody"
               :password "1234"))

(let* ((query (dbi:prepare *connection*
                           "SELECT * FROM somewhere WHERE flag = ? OR updated_at > ?"))
       (result (dbi:execute query 0 "2011-11-01")))
  (loop for row = (dbi:fetch result)
     while row
     ;; process "row".
       ))

Using dbi:with-connection to ensure connections are closed

(dbi:with-connection (conn :sqlite3 :database-name "/home/fukamachi/test.db")
  (let* ((query (dbi:prepare conn "SELECT * FROM People"))
         (result (dbi:execute query)))
    (loop for row = (dbi:fetch result)
       while row
       do (format t "~A~%" row))))

Description

CL-DBI provides the same interface for multiple SQL databases. You need not learn the API of each database.

This library is especially convenient when you want to use different databases in different environments. For example, you may use MySQL as a production database, but use SQLite3 on your development system. To switch database backends you need only change the arguments to dbi:connect.

Databases

Installation

This library will be available on Quicklisp when ready for use.

API

User-Level API

Driver-Level API

Creating a new driver

Create a subclass of <dbi-driver> and implement following methods.

These methods can be overriden if needed.

Dependencies

Author

Copyright

Copyright (c) 2011 Eitaro Fukamachi (e.arrows@gmail.com)

License

Licensed under the LLGPL License.


Next: , Previous: , Up: Top   [Contents][Index]

2 Systems

The main system appears first, followed by any subsystem dependency.


Next: , Previous: , Up: Systems   [Contents][Index]

2.1 cl-dbi

Author

Eitaro Fukamachi

License

LLGPL

Version

0.1

Dependency

dbi (system)

Source

cl-dbi.asd (file)


Previous: , Up: Systems   [Contents][Index]

2.2 dbi

Author

Eitaro Fukamachi

License

LLGPL

Description

Database independent interface for Common Lisp

Long Description

# CL-DBI - Database independent interface for Common Lisp

[![Build Status](https://travis-ci.org/fukamachi/cl-dbi.svg?branch=master)](https://travis-ci.org/fukamachi/cl-dbi)

## Usage

### Connecting and executing a query

“‘common-lisp
(defvar *connection*
(dbi:connect :mysql
:database-name "test"
:username "nobody"
:password "1234"))

(let* ((query (dbi:prepare *connection*
"SELECT * FROM somewhere WHERE flag = ? OR updated_at > ?"))
(result (dbi:execute query 0 "2011-11-01")))
(loop for row = (dbi:fetch result)
while row
;; process "row".
))
“‘

### Using ‘dbi:with-connection‘ to ensure connections are closed

“‘common-lisp
(dbi:with-connection (conn :sqlite3 :database-name "/home/fukamachi/test.db")
(let* ((query (dbi:prepare conn "SELECT * FROM People"))
(result (dbi:execute query)))
(loop for row = (dbi:fetch result)
while row
do (format t "~A~%" row))))
“‘

## Description

CL-DBI provides the same interface for multiple SQL databases. You need not learn the API of each database.

This library is especially convenient when you want to use different databases in different environments. For example, you may use MySQL as a production database, but use SQLite3 on your development system. To switch database backends you need only change the arguments to ‘dbi:connect‘.

## Databases

* SQLite3
* PostgreSQL
* MySQL

## Installation

This library will be available on Quicklisp when ready for use.

## API

### User-Level API

* connect [driver-name &amp; params] =&gt; &lt;dbi-connection&gt;
* connect-cached [driver-name &amp; params] =&gt; &lt;dbi-connection&gt;
* disconnect [&lt;dbi-connection&gt;] =&gt; T or NIL
* prepare [conn sql] =&gt; &lt;dbi-query&gt;
* execute [query &amp; params] =&gt; something
* fetch [result] =&gt; a row data as plist
* fetch-all [result] =&gt; a list of all row data
* do-sql [conn sql &amp; params]
* list-all-drivers [] =&gt; (&lt;dbi-driver&gt; ..)
* find-driver [driver-name] =&gt; &lt;dbi-driver&gt;
* with-transaction [conn]
* begin-transaction [conn]
* commit [conn]
* rollback [conn]
* ping [conn] =&gt; T or NIL
* row-count [conn] =&gt a number of rows modified by the last executed INSERT/UPDATE/DELETE
* with-connection [connection-variable-name &body body]

### Driver-Level API

* &lt;dbi-driver&gt;
* &lt;dbi-connection&gt;
* make-connection [driver params]
* disconnect [&lt;dbi-connection&gt;] =&gt; T or NIL
* prepare [conn sql] =&gt; &lt;dbi-query&gt;
* fetch-using-connection [conn result] =&gt; a row data as plist
* do-sql [conn sql &amp; params]
* execute-using-connection =&gt; something
* escape-sql =&gt; string
* begin-transaction [conn]
* commit [conn]
* rollback [conn]
* ping [conn] =&gt; T or NIL
* row-count [conn] =&gt a number of rows modified by the last executed INSERT/UPDATE/DELETE

## Creating a new driver

Create a subclass of &lt;dbi-driver&gt; and implement following methods.

* make-connection
* disconnect [&lt;dbi-connection&gt;] =&gt; T or NIL
* execute-using-connection

These methods can be overriden if needed.

* prepare
* fetch-using-connection
* do-sql
* escape-sql

## Dependencies

* cl-annot
* CL-Syntax
* SPLIT-SEQUENCE
* closer-mop

## Author

* Eitaro Fukamachi (e.arrows@gmail.com)

## Copyright

Copyright (c) 2011 Eitaro Fukamachi (e.arrows@gmail.com)

# License

Licensed under the LLGPL License.

Version

0.1

Dependencies
Source

dbi.asd (file)

Component

src (module)


Next: , Previous: , Up: Top   [Contents][Index]

3 Modules

Modules are listed depth-first from the system components tree.


Previous: , Up: Modules   [Contents][Index]

3.1 dbi/src

Parent

dbi (system)

Location

src/

Components

Next: , Previous: , Up: Top   [Contents][Index]

4 Files

Files are sorted by type and then listed depth-first from the systems components trees.


Previous: , Up: Files   [Contents][Index]

4.1 Lisp


Next: , Previous: , Up: Lisp files   [Contents][Index]

4.1.1 cl-dbi.asd

Location

cl-dbi.asd

Systems

cl-dbi (system)

Packages

cl-dbi-asd


Next: , Previous: , Up: Lisp files   [Contents][Index]

4.1.2 dbi.asd

Location

dbi.asd

Systems

dbi (system)

Packages

dbi-asd


Next: , Previous: , Up: Lisp files   [Contents][Index]

4.1.3 dbi/src/dbi.lisp

Dependency

driver.lisp (file)

Parent

src (module)

Location

src/dbi.lisp

Packages

dbi

Exported Definitions
Internal Definitions

Next: , Previous: , Up: Lisp files   [Contents][Index]

4.1.4 dbi/src/driver.lisp

Dependency

error.lisp (file)

Parent

src (module)

Location

src/driver.lisp

Packages

dbi.driver

Exported Definitions
Internal Definitions

Previous: , Up: Lisp files   [Contents][Index]

4.1.5 dbi/src/error.lisp

Parent

src (module)

Location

src/error.lisp

Packages

dbi.error

Exported Definitions

Next: , Previous: , Up: Top   [Contents][Index]

5 Packages

Packages are listed by definition order.


Next: , Previous: , Up: Packages   [Contents][Index]

5.1 cl-dbi-asd

Source

cl-dbi.asd

Use List

Next: , Previous: , Up: Packages   [Contents][Index]

5.2 dbi-asd

Source

dbi.asd

Use List

Next: , Previous: , Up: Packages   [Contents][Index]

5.3 dbi

Source

dbi.lisp (file)

Nickname

cl-dbi

Use List
Exported Definitions
Internal Definitions

Next: , Previous: , Up: Packages   [Contents][Index]

5.4 dbi.driver

Source

driver.lisp (file)

Use List
Exported Definitions
Internal Definitions

Previous: , Up: Packages   [Contents][Index]

5.5 dbi.error

Source

error.lisp (file)

Use List

common-lisp

Used By List

dbi

Exported Definitions

Next: , Previous: , Up: Top   [Contents][Index]

6 Definitions

Definitions are sorted by export status, category, package, and then by lexicographic order.


Next: , Previous: , Up: Definitions   [Contents][Index]

6.1 Exported definitions


Next: , Previous: , Up: Exported definitions   [Contents][Index]

6.1.1 Special variables

Special Variable: *current-savepoint*
Package

dbi.driver

Source

driver.lisp (file)


Next: , Previous: , Up: Exported definitions   [Contents][Index]

6.1.2 Macros

Macro: with-connection (CONN-SYM &rest REST) &body BODY
Package

dbi

Source

dbi.lisp (file)

Macro: with-savepoint CONN &body BODY
Package

dbi

Source

dbi.lisp (file)

Macro: with-transaction CONN &body BODY

Start a transaction and commit at the end of this block. If the evaluation ‘body‘ is interrupted, the transaction is rolled back automatically.

Package

dbi

Source

dbi.lisp (file)


Next: , Previous: , Up: Exported definitions   [Contents][Index]

6.1.3 Functions

Function: connect DRIVER-NAME &rest PARAMS &key DATABASE-NAME &allow-other-keys

Open a connection to the database which corresponds to ‘driver-name‘.

Package

dbi

Source

dbi.lisp (file)

Function: connect-cached &rest CONNECT-ARGS
Package

dbi

Source

dbi.lisp (file)

Function: find-driver DRIVER-NAME

Find a driver class named as ‘driver-name‘.
‘driver-name‘ is a string designer.
Driver should be named like ’<DBD-SOMETHING>’ for a database ’something’.

Package

dbi.driver

Source

driver.lisp (file)

Function: list-all-drivers ()

Return a list of direct subclasses for ‘<dbi-driver>‘.

Package

dbi.driver

Source

driver.lisp (file)


Next: , Previous: , Up: Exported definitions   [Contents][Index]

6.1.4 Generic functions

Generic Function: begin-transaction CONN

Start a transaction.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: begin-transaction (CONN <dbi-connection>) around

Turn ‘auto-commit‘ off automatically before starting a transaction.

Method: begin-transaction (CONN <dbi-connection>)
Generic Function: commit CONN

Commit changes and end the current transaction.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: commit (CONN <dbi-connection>)
Method: commit (CONN <dbi-connection>) around
Generic Function: connection-database-name OBJECT
Generic Function: (setf connection-database-name) NEW-VALUE OBJECT
Package

dbi.driver

Methods
Method: connection-database-name (<DBI-CONNECTION> <dbi-connection>)

automatically generated reader method

Source

driver.lisp (file)

Method: (setf connection-database-name) NEW-VALUE (<DBI-CONNECTION> <dbi-connection>)

automatically generated writer method

Source

driver.lisp (file)

Generic Function: connection-driver-type CONN
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: connection-driver-type (CONN <dbi-connection>)
Generic Function: connection-handle OBJECT
Generic Function: (setf connection-handle) NEW-VALUE OBJECT
Package

dbi.driver

Methods
Method: connection-handle (<DBI-CONNECTION> <dbi-connection>)

automatically generated reader method

Source

driver.lisp (file)

Method: (setf connection-handle) NEW-VALUE (<DBI-CONNECTION> <dbi-connection>)

automatically generated writer method

Source

driver.lisp (file)

Generic Function: disconnect CONN
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: disconnect (CONN <dbi-connection>)
Generic Function: do-sql CONN SQL &rest PARAMS

Do preparation and execution at once. This method may be overrided by subclasses.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: do-sql (CONN <dbi-connection>) (SQL string) &rest PARAMS
Generic Function: escape-sql CONN SQL

Return escaped ‘sql‘.
This method may be overrided by subclasses when needed.
For example, in case of MySQL and PostgreSQL, backslashes must be escaped by doubling it.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: escape-sql (CONN <dbi-connection>) (SQL string)
Generic Function: execute QUERY &rest PARAMS

Execute ‘query‘ with ‘params‘ and return the results.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: execute (QUERY <dbi-query>) &rest PARAMS
Generic Function: execute-using-connection CONN QUERY PARAMS

Execute ‘query‘ in ‘conn‘.
This method must be implemented in each drivers.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: execute-using-connection (CONN <dbi-connection>) (QUERY <dbi-query>) PARAMS
Generic Function: fetch QUERY

Fetch the first row from ‘query‘ which is returned by ‘execute‘.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: fetch (QUERY <dbi-query>)
Generic Function: fetch-all QUERY

Fetch all rest rows from ‘query‘.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: fetch-all (QUERY <dbi-query>)
Generic Function: fetch-using-connection CONN QUERY
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: fetch-using-connection (CONN <dbi-connection>) (QUERY <dbi-query>)
Generic Function: make-connection DRIVER &key

Create a instance of ‘<dbi-connection>‘ for the ‘driver‘. This method must be implemented in each drivers.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: make-connection (DRIVER <dbi-driver>) &key
Generic Function: ping CONN

Check if the database server is still running and the connection to it is still working.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: ping (CONN <dbi-connection>)
Generic Function: prepare CONN SQL &key QUERY-CLASS
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: prepare (CONN <dbi-connection>) (SQL string) &key QUERY-CLASS

Preparing executing SQL statement and returns a instance of ‘<dbi-query>‘. This method may be overrided by subclasses.

Generic Function: query-connection OBJECT
Generic Function: (setf query-connection) NEW-VALUE OBJECT
Package

dbi.driver

Methods
Method: query-connection (<DBI-QUERY> <dbi-query>)

automatically generated reader method

Source

driver.lisp (file)

Method: (setf query-connection) NEW-VALUE (<DBI-QUERY> <dbi-query>)

automatically generated writer method

Source

driver.lisp (file)

Generic Function: query-prepared OBJECT
Generic Function: (setf query-prepared) NEW-VALUE OBJECT
Package

dbi.driver

Methods
Method: query-prepared (<DBI-QUERY> <dbi-query>)

automatically generated reader method

Source

driver.lisp (file)

Method: (setf query-prepared) NEW-VALUE (<DBI-QUERY> <dbi-query>)

automatically generated writer method

Source

driver.lisp (file)

Generic Function: query-sql OBJECT
Generic Function: (setf query-sql) NEW-VALUE OBJECT
Package

dbi.driver

Methods
Method: query-sql (<DBI-QUERY> <dbi-query>)

automatically generated reader method

Source

driver.lisp (file)

Method: (setf query-sql) NEW-VALUE (<DBI-QUERY> <dbi-query>)

automatically generated writer method

Source

driver.lisp (file)

Generic Function: release-savepoint CONN &optional IDENTIFIER
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: release-savepoint (CONN <dbi-connection>) &optional IDENTIFIER
Generic Function: rollback CONN

Rollback all changes and end the current transaction.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: rollback (CONN <dbi-connection>)
Method: rollback (CONN <dbi-connection>) around
Generic Function: rollback-savepoint CONN &optional IDENTIFIER
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: rollback-savepoint (CONN <dbi-connection>) &optional IDENTIFIER
Generic Function: row-count CONN

Return the number of counts modified by the last executed INSERT/UPDATE/DELETE query.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: row-count (CONN <dbi-connection>)
Generic Function: savepoint CONN IDENTIFIER
Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: savepoint (CONN <dbi-connection>) IDENTIFIER

Next: , Previous: , Up: Exported definitions   [Contents][Index]

6.1.5 Conditions

Condition: <dbi-data-error> ()

Exception for errors due to problems with the processed
data such as division for zero, numeric value out of range, etc.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Condition: <dbi-database-error> ()

Exception for errors related to the database.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-error> (condition)

Direct subclasses
Direct slots
Slot: message
Initargs

:message

Slot: error-code
Initargs

:error-code

Condition: <dbi-error> ()

Base class of all other error exceptions. Use this to catch all DBI errors.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

simple-error (condition)

Direct subclasses
Condition: <dbi-integrity-error> ()

Exception raised when the relational integrity of the database is affected, e.g. a foreign key check fails.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Condition: <dbi-interface-error> ()

Exception for errors related to the DBI interface rather than the database itself.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-error> (condition)

Direct subclasses

<dbi-unimplemented-error> (condition)

Condition: <dbi-internal-error> ()

Exception raised when the database encounters an internal error, e.g. the cursor is not valid anymore, the transaction is out of sync.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Condition: <dbi-notsupported-error> ()

Exception raised if e.g. commit() is called for a database which do not support transactions.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Direct slots
Slot: method-name
Initargs

:method-name

Condition: <dbi-operational-error> ()

Exception for errors related to the database’s operation which are not necessarily under the control of the programmer. This includes such things as unexpected disconnect, datasource name not found, transaction could not be processed, a memory allocation error occured during processing, etc.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Condition: <dbi-programming-error> ()

Exception raised for programming errors, e.g. table not found or already exists, syntax error in SQL statement, wrong number of parameters specified, etc.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-database-error> (condition)

Condition: <dbi-unimplemented-error> ()

Exception raised if the DBD driver has not specified a mandatory method.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

<dbi-interface-error> (condition)

Direct slots
Slot: method-name
Initargs

:method-name

Condition: <dbi-warning> ()

For important warnings like data truncation, etc.

Package

dbi.error

Source

error.lisp (file)

Direct superclasses

simple-warning (condition)


Previous: , Up: Exported definitions   [Contents][Index]

6.1.6 Classes

Class: <dbi-connection> ()

Base class for managing DB connection.

Package

dbi.driver

Source

driver.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: auto-commit
Type

boolean

Initargs

:auto-commit

Initform

t

Slot: database-name
Initargs

:database-name

Readers

connection-database-name (generic function)

Writers

(setf connection-database-name) (generic function)

Slot: %handle
Initargs

:handle

Readers

connection-handle (generic function)

Writers

(setf connection-handle) (generic function)

Class: <dbi-driver> ()

Base class for DB driver.

Package

dbi.driver

Source

driver.lisp (file)

Direct superclasses

standard-object (class)

Direct methods

make-connection (method)

Class: <dbi-query> ()

Class that represents a prepared DB query.

Package

dbi.driver

Source

driver.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: connection
Type

dbi.driver:<dbi-connection>

Initargs

:connection

Readers

query-connection (generic function)

Writers

(setf query-connection) (generic function)

Slot: sql
Type

string

Initargs

:sql

Readers

query-sql (generic function)

Writers

(setf query-sql) (generic function)

Slot: prepared
Initargs

:prepared

Readers

query-prepared (generic function)

Writers

(setf query-prepared) (generic function)


Previous: , Up: Definitions   [Contents][Index]

6.2 Internal definitions


Next: , Previous: , Up: Internal definitions   [Contents][Index]

6.2.1 Special variables

Special Variable: *in-transaction*
Package

dbi

Source

dbi.lisp (file)

Special Variable: *in-transaction*
Package

dbi.driver

Source

driver.lisp (file)

Special Variable: *threads-connection-pool*
Package

dbi

Source

dbi.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

6.2.2 Macros

Macro: %with-transaction CONN &body BODY
Package

dbi

Source

dbi.lisp (file)


Next: , Previous: , Up: Internal definitions   [Contents][Index]

6.2.3 Functions

Function: cleanup-connection-pool ()
Package

dbi

Source

dbi.lisp (file)

Function: generate-random-savepoint ()
Package

dbi

Source

dbi.lisp (file)

Function: get-connection-pool ()
Package

dbi

Source

dbi.lisp (file)

Function: load-driver DRIVER-NAME
Package

dbi

Source

dbi.lisp (file)

Function: make-connection-pool ()
Package

dbi

Source

dbi.lisp (file)

Function: make-threads-connection-pool ()
Package

dbi

Source

dbi.lisp (file)


Previous: , Up: Internal definitions   [Contents][Index]

6.2.4 Generic functions

Generic Function: prepare-sql CONN SQL

Create a function that takes parameters, binds them into a query and returns SQL as a string.

Package

dbi.driver

Source

driver.lisp (file)

Methods
Method: prepare-sql (CONN <dbi-connection>) (SQL string)

Previous: , Up: Top   [Contents][Index]

Appendix A Indexes


Next: , Previous: , Up: Indexes   [Contents][Index]

A.1 Concepts

Jump to:   C   D   F   L   M  
Index Entry  Section

C
cl-dbi.asd: The cl-dbi<dot>asd file

D
dbi.asd: The dbi<dot>asd file
dbi/src: The dbi/src module
dbi/src/dbi.lisp: The dbi/src/dbi<dot>lisp file
dbi/src/driver.lisp: The dbi/src/driver<dot>lisp file
dbi/src/error.lisp: The dbi/src/error<dot>lisp file

F
File, Lisp, cl-dbi.asd: The cl-dbi<dot>asd file
File, Lisp, dbi.asd: The dbi<dot>asd file
File, Lisp, dbi/src/dbi.lisp: The dbi/src/dbi<dot>lisp file
File, Lisp, dbi/src/driver.lisp: The dbi/src/driver<dot>lisp file
File, Lisp, dbi/src/error.lisp: The dbi/src/error<dot>lisp file

L
Lisp File, cl-dbi.asd: The cl-dbi<dot>asd file
Lisp File, dbi.asd: The dbi<dot>asd file
Lisp File, dbi/src/dbi.lisp: The dbi/src/dbi<dot>lisp file
Lisp File, dbi/src/driver.lisp: The dbi/src/driver<dot>lisp file
Lisp File, dbi/src/error.lisp: The dbi/src/error<dot>lisp file

M
Module, dbi/src: The dbi/src module

Jump to:   C   D   F   L   M  

Next: , Previous: , Up: Indexes   [Contents][Index]

A.2 Functions

Jump to:   %   (  
B   C   D   E   F   G   L   M   P   Q   R   S   W  
Index Entry  Section

%
%with-transaction: Internal macros

(
(setf connection-database-name): Exported generic functions
(setf connection-database-name): Exported generic functions
(setf connection-handle): Exported generic functions
(setf connection-handle): Exported generic functions
(setf query-connection): Exported generic functions
(setf query-connection): Exported generic functions
(setf query-prepared): Exported generic functions
(setf query-prepared): Exported generic functions
(setf query-sql): Exported generic functions
(setf query-sql): Exported generic functions

B
begin-transaction: Exported generic functions
begin-transaction: Exported generic functions
begin-transaction: Exported generic functions

C
cleanup-connection-pool: Internal functions
commit: Exported generic functions
commit: Exported generic functions
commit: Exported generic functions
connect: Exported functions
connect-cached: Exported functions
connection-database-name: Exported generic functions
connection-database-name: Exported generic functions
connection-driver-type: Exported generic functions
connection-driver-type: Exported generic functions
connection-handle: Exported generic functions
connection-handle: Exported generic functions

D
disconnect: Exported generic functions
disconnect: Exported generic functions
do-sql: Exported generic functions
do-sql: Exported generic functions

E
escape-sql: Exported generic functions
escape-sql: Exported generic functions
execute: Exported generic functions
execute: Exported generic functions
execute-using-connection: Exported generic functions
execute-using-connection: Exported generic functions

F
fetch: Exported generic functions
fetch: Exported generic functions
fetch-all: Exported generic functions
fetch-all: Exported generic functions
fetch-using-connection: Exported generic functions
fetch-using-connection: Exported generic functions
find-driver: Exported functions
Function, cleanup-connection-pool: Internal functions
Function, connect: Exported functions
Function, connect-cached: Exported functions
Function, find-driver: Exported functions
Function, generate-random-savepoint: Internal functions
Function, get-connection-pool: Internal functions
Function, list-all-drivers: Exported functions
Function, load-driver: Internal functions
Function, make-connection-pool: Internal functions
Function, make-threads-connection-pool: Internal functions

G
generate-random-savepoint: Internal functions
Generic Function, (setf connection-database-name): Exported generic functions
Generic Function, (setf connection-handle): Exported generic functions
Generic Function, (setf query-connection): Exported generic functions
Generic Function, (setf query-prepared): Exported generic functions
Generic Function, (setf query-sql): Exported generic functions
Generic Function, begin-transaction: Exported generic functions
Generic Function, commit: Exported generic functions
Generic Function, connection-database-name: Exported generic functions
Generic Function, connection-driver-type: Exported generic functions
Generic Function, connection-handle: Exported generic functions
Generic Function, disconnect: Exported generic functions
Generic Function, do-sql: Exported generic functions
Generic Function, escape-sql: Exported generic functions
Generic Function, execute: Exported generic functions
Generic Function, execute-using-connection: Exported generic functions
Generic Function, fetch: Exported generic functions
Generic Function, fetch-all: Exported generic functions
Generic Function, fetch-using-connection: Exported generic functions
Generic Function, make-connection: Exported generic functions
Generic Function, ping: Exported generic functions
Generic Function, prepare: Exported generic functions
Generic Function, prepare-sql: Internal generic functions
Generic Function, query-connection: Exported generic functions
Generic Function, query-prepared: Exported generic functions
Generic Function, query-sql: Exported generic functions
Generic Function, release-savepoint: Exported generic functions
Generic Function, rollback: Exported generic functions
Generic Function, rollback-savepoint: Exported generic functions
Generic Function, row-count: Exported generic functions
Generic Function, savepoint: Exported generic functions
get-connection-pool: Internal functions

L
list-all-drivers: Exported functions
load-driver: Internal functions

M
Macro, %with-transaction: Internal macros
Macro, with-connection: Exported macros
Macro, with-savepoint: Exported macros
Macro, with-transaction: Exported macros
make-connection: Exported generic functions
make-connection: Exported generic functions
make-connection-pool: Internal functions
make-threads-connection-pool: Internal functions
Method, (setf connection-database-name): Exported generic functions
Method, (setf connection-handle): Exported generic functions
Method, (setf query-connection): Exported generic functions
Method, (setf query-prepared): Exported generic functions
Method, (setf query-sql): Exported generic functions
Method, begin-transaction: Exported generic functions
Method, begin-transaction: Exported generic functions
Method, commit: Exported generic functions
Method, commit: Exported generic functions
Method, connection-database-name: Exported generic functions
Method, connection-driver-type: Exported generic functions
Method, connection-handle: Exported generic functions
Method, disconnect: Exported generic functions
Method, do-sql: Exported generic functions
Method, escape-sql: Exported generic functions
Method, execute: Exported generic functions
Method, execute-using-connection: Exported generic functions
Method, fetch: Exported generic functions
Method, fetch-all: Exported generic functions
Method, fetch-using-connection: Exported generic functions
Method, make-connection: Exported generic functions
Method, ping: Exported generic functions
Method, prepare: Exported generic functions
Method, prepare-sql: Internal generic functions
Method, query-connection: Exported generic functions
Method, query-prepared: Exported generic functions
Method, query-sql: Exported generic functions
Method, release-savepoint: Exported generic functions
Method, rollback: Exported generic functions
Method, rollback: Exported generic functions
Method, rollback-savepoint: Exported generic functions
Method, row-count: Exported generic functions
Method, savepoint: Exported generic functions

P
ping: Exported generic functions
ping: Exported generic functions
prepare: Exported generic functions
prepare: Exported generic functions
prepare-sql: Internal generic functions
prepare-sql: Internal generic functions

Q
query-connection: Exported generic functions
query-connection: Exported generic functions
query-prepared: Exported generic functions
query-prepared: Exported generic functions
query-sql: Exported generic functions
query-sql: Exported generic functions

R
release-savepoint: Exported generic functions
release-savepoint: Exported generic functions
rollback: Exported generic functions
rollback: Exported generic functions
rollback: Exported generic functions
rollback-savepoint: Exported generic functions
rollback-savepoint: Exported generic functions
row-count: Exported generic functions
row-count: Exported generic functions

S
savepoint: Exported generic functions
savepoint: Exported generic functions

W
with-connection: Exported macros
with-savepoint: Exported macros
with-transaction: Exported macros

Jump to:   %   (  
B   C   D   E   F   G   L   M   P   Q   R   S   W  

Next: , Previous: , Up: Indexes   [Contents][Index]

A.3 Variables

Jump to:   %   *  
A   C   D   E   M   P   S  
Index Entry  Section

%
%handle: Exported classes

*
*current-savepoint*: Exported special variables
*in-transaction*: Internal special variables
*in-transaction*: Internal special variables
*threads-connection-pool*: Internal special variables

A
auto-commit: Exported classes

C
connection: Exported classes

D
database-name: Exported classes

E
error-code: Exported conditions

M
message: Exported conditions
method-name: Exported conditions
method-name: Exported conditions

P
prepared: Exported classes

S
Slot, %handle: Exported classes
Slot, auto-commit: Exported classes
Slot, connection: Exported classes
Slot, database-name: Exported classes
Slot, error-code: Exported conditions
Slot, message: Exported conditions
Slot, method-name: Exported conditions
Slot, method-name: Exported conditions
Slot, prepared: Exported classes
Slot, sql: Exported classes
Special Variable, *current-savepoint*: Exported special variables
Special Variable, *in-transaction*: Internal special variables
Special Variable, *in-transaction*: Internal special variables
Special Variable, *threads-connection-pool*: Internal special variables
sql: Exported classes

Jump to:   %   *  
A   C   D   E   M   P   S  

Previous: , Up: Indexes   [Contents][Index]

A.4 Data types

Jump to:   <  
C   D   P   S  
Index Entry  Section

<
<dbi-connection>: Exported classes
<dbi-data-error>: Exported conditions
<dbi-database-error>: Exported conditions
<dbi-driver>: Exported classes
<dbi-error>: Exported conditions
<dbi-integrity-error>: Exported conditions
<dbi-interface-error>: Exported conditions
<dbi-internal-error>: Exported conditions
<dbi-notsupported-error>: Exported conditions
<dbi-operational-error>: Exported conditions
<dbi-programming-error>: Exported conditions
<dbi-query>: Exported classes
<dbi-unimplemented-error>: Exported conditions
<dbi-warning>: Exported conditions

C
cl-dbi: The cl-dbi system
cl-dbi-asd: The cl-dbi-asd package
Class, <dbi-connection>: Exported classes
Class, <dbi-driver>: Exported classes
Class, <dbi-query>: Exported classes
Condition, <dbi-data-error>: Exported conditions
Condition, <dbi-database-error>: Exported conditions
Condition, <dbi-error>: Exported conditions
Condition, <dbi-integrity-error>: Exported conditions
Condition, <dbi-interface-error>: Exported conditions
Condition, <dbi-internal-error>: Exported conditions
Condition, <dbi-notsupported-error>: Exported conditions
Condition, <dbi-operational-error>: Exported conditions
Condition, <dbi-programming-error>: Exported conditions
Condition, <dbi-unimplemented-error>: Exported conditions
Condition, <dbi-warning>: Exported conditions

D
dbi: The dbi system
dbi: The dbi package
dbi-asd: The dbi-asd package
dbi.driver: The dbi<dot>driver package
dbi.error: The dbi<dot>error package

P
Package, cl-dbi-asd: The cl-dbi-asd package
Package, dbi: The dbi package
Package, dbi-asd: The dbi-asd package
Package, dbi.driver: The dbi<dot>driver package
Package, dbi.error: The dbi<dot>error package

S
System, cl-dbi: The cl-dbi system
System, dbi: The dbi system

Jump to:   <  
C   D   P   S