The sqlite Reference Manual

This is the sqlite Reference Manual, version 0.2.1, generated automatically by Declt version 4.0 beta 2 "William Riker" on Wed May 15 04:30:37 2024 GMT+0.

Table of Contents


1 Systems

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


1.1 sqlite

CL-SQLITE package is an interface to the SQLite embedded relational database engine.

Maintainer

Jacek Złydach <>

Author

Kalyanov Dmitry <>

Home Page

https://common-lisp.net/project/cl-sqlite/

Source Control

(GIT git@github.com:TeMPOraL/cl-sqlite.git)

Bug Tracker

https://github.com/TeMPOraL/cl-sqlite/issues

License

Public Domain

Version

0.2.1

Dependencies
  • iterate (system).
  • cffi (system).
Source

sqlite.asd.

Child Components

2 Files

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


2.1 Lisp


2.1.1 sqlite/sqlite.asd

Source

sqlite.asd.

Parent Component

sqlite (system).

ASDF Systems

sqlite.


2.1.2 sqlite/sqlite-ffi.lisp

Source

sqlite.asd.

Parent Component

sqlite (system).

Packages

sqlite-ffi.

Public Interface
Internals

2.1.3 sqlite/cache.lisp

Source

sqlite.asd.

Parent Component

sqlite (system).

Packages

sqlite.cache.

Public Interface
Internals

2.1.4 sqlite/sqlite.lisp

Dependencies
Source

sqlite.asd.

Parent Component

sqlite (system).

Packages

sqlite.

Public Interface
Internals

3 Packages

Packages are listed by definition order.


3.1 sqlite-ffi

Source

sqlite-ffi.lisp.

Use List
  • cffi.
  • common-lisp.
Public Interface
Internals

3.2 sqlite

Source

sqlite.lisp.

Use List
  • common-lisp.
  • iterate.
Public Interface
Internals

3.3 sqlite.cache

Source

cache.lisp.

Use List
  • common-lisp.
  • iterate.
Public Interface
Internals

4 Definitions

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


4.1 Public Interface


4.1.1 Macros

Macro: with-open-database ((db path &key busy-timeout) &body body)
Package

sqlite.

Source

sqlite.lisp.

Macro: with-transaction (db &body body)

Wraps the BODY inside the transaction.

Package

sqlite.

Source

sqlite.lisp.


4.1.2 Ordinary functions

Function: bind-parameter (statement parameter value)

Sets the PARAMETER-th parameter in STATEMENT to the VALUE.
PARAMETER may be parameter index (starting from 1) or parameters name.
Supported types:
* NULL. Passed as NULL
* INTEGER. Passed as an 64-bit integer
* STRING. Passed as a string
* FLOAT. Passed as a double
* (VECTOR (UNSIGNED-BYTE 8)) and VECTOR that contains integers in range [0,256). Passed as a BLOB

Package

sqlite.

Source

sqlite.lisp.

Function: clear-statement-bindings (statement)

Sets all binding values to NULL.

Package

sqlite.

Source

sqlite.lisp.

Function: connect (database-path &key busy-timeout)

Connect to the sqlite database at the given DATABASE-PATH. Returns the SQLITE-HANDLE connected to the database. Use DISCONNECT to disconnect.
Operations will wait for locked databases for up to BUSY-TIMEOUT milliseconds; if BUSY-TIMEOUT is NIL, then operations on locked databases will fail immediately.

Package

sqlite.

Source

sqlite.lisp.

Function: destructor-static ()
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: destructor-transient ()
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: disconnect (handle)

Disconnects the given HANDLE from the database. All further operations on the handle are invalid.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-non-query (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns nothing.

Example:

(execute-non-query db "insert into users (user_name, real_name) values (?, ?)" "joe" "Joe the User")

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-non-query/named (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns nothing.

PARAMETERS is a list of alternating parameter names and values.

Example:

(execute-non-query db "insert into users (user_name, real_name) values (:name, :real_name)" ":name" "joe" ":real_name" "Joe the User")

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-one-row-m-v (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the first row as multiple values.

Example:
(execute-one-row-m-v db "select id, user_name, real_name from users where id = ?" 1)
=>
(values 1 "joe" "Joe the User")

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-one-row-m-v/named (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the first row as multiple values.

PARAMETERS is a list of alternating parameters names and values.

Example:
(execute-one-row-m-v db "select id, user_name, real_name from users where id = :id" ":id" 1)
=>
(values 1 "joe" "Joe the User")

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-single (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the first column of the first row as single value.

Example:
(execute-single db "select user_name from users where id = ?" 1)
=>
"joe"

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-single/named (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the first column of the first row as single value.

PARAMETERS is a list of alternating parameters names and values.

Example:
(execute-single db "select user_name from users where id = :id" ":id" 1)
=>
"joe"

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-to-list (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the results as list of lists.

Example:

(execute-to-list db "select id, user_name, real_name from users where user_name = ?" "joe")
=>
((1 "joe" "Joe the User")
(2 "joe" "Another Joe"))

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: execute-to-list/named (db sql &rest parameters)

Executes the query SQL to the database DB with given PARAMETERS. Returns the results as list of lists.

PARAMETERS is a list of alternating parameters names and values.

Example:

(execute-to-list db "select id, user_name, real_name from users where user_name = :user_name" ":user_name" "joe") =>
((1 "joe" "Joe the User")
(2 "joe" "Another Joe"))

See BIND-PARAMETER for the list of supported parameter types.

Package

sqlite.

Source

sqlite.lisp.

Function: finalize-statement (statement)

Finalizes the statement and signals that associated resources may be released. Note: does not immediately release resources because statements are cached.

Package

sqlite.

Source

sqlite.lisp.

Function: get-from-cache (cache id)
Package

sqlite.cache.

Source

cache.lisp.

Function: last-insert-rowid (db)

Returns the auto-generated ID of the last inserted row on the database connection DB.

Package

sqlite.

Source

sqlite.lisp.

Function: prepare-statement (db sql)

Prepare the statement to the DB that will execute the commands that are in SQL.

Returns the SQLITE-STATEMENT.

SQL must contain exactly one statement.
SQL may have some positional (not named) parameters specified with question marks.

Example:

select name from users where id = ?

Package

sqlite.

Source

sqlite.lisp.

Function: purge-cache (cache)
Package

sqlite.cache.

Source

cache.lisp.

Function: put-to-cache (cache id object)
Package

sqlite.cache.

Source

cache.lisp.

Function: reset-statement (statement)

Resets the STATEMENT and prepare it to be called again.

Package

sqlite.

Source

sqlite.lisp.

Function: set-busy-timeout (db milliseconds)

Sets the maximum amount of time to wait for a locked database.

Package

sqlite.

Source

sqlite.lisp.

Function: sqlite-error (error-code message &key statement db-handle sql-text)
Package

sqlite.

Source

sqlite.lisp.

Function: sqlite3-bind-blob (statement parameter-index value bytes-count destructor)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-double (statement parameter-index value)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-int64 (statement parameter-index value)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-null (statement parameter-index)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-parameter-count (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-parameter-index (statement name)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-parameter-name (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-bind-text (statement parameter-index value octets-count destructor)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-busy-timeout (db ms)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-clear-bindings (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-close (db)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-blob (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-bytes (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-count (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-double (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-int64 (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-name (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-text (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-column-type (statement column-number)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-errmsg (db)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-finalize (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-last-insert-rowid (db)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-open (filename db)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-prepare (db sql sql-length-bytes stmt tail)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-reset (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: sqlite3-step (statement)
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Function: statement-column-value (statement column-number)

Returns the COLUMN-NUMBER-th column’s value of the current row of the STATEMENT. Columns are numbered from zero. Returns:
* NIL for NULL
* INTEGER for integers
* DOUBLE-FLOAT for floats
* STRING for text
* (SIMPLE-ARRAY (UNSIGNED-BYTE 8)) for BLOBs

Package

sqlite.

Source

sqlite.lisp.

Function: step-statement (statement)

Steps to the next row of the resultset of STATEMENT.
Returns T is successfully advanced to the next row and NIL if there are no more rows.

Package

sqlite.

Source

sqlite.lisp.


4.1.3 Generic functions

Generic Reader: sqlite-error-code (condition)
Package

sqlite.

Methods
Reader Method: sqlite-error-code ((condition sqlite-error))
Source

sqlite.lisp.

Target Slot

error-code.

Generic Reader: sqlite-error-db-handle (condition)
Package

sqlite.

Methods
Reader Method: sqlite-error-db-handle ((condition sqlite-error))
Source

sqlite.lisp.

Target Slot

handle.

Generic Reader: sqlite-error-message (condition)
Package

sqlite.

Methods
Reader Method: sqlite-error-message ((condition sqlite-error))
Source

sqlite.lisp.

Target Slot

error-msg.

Generic Reader: sqlite-error-sql (condition)
Package

sqlite.

Methods
Reader Method: sqlite-error-sql ((condition sqlite-error))
Source

sqlite.lisp.

Target Slot

sql.

Generic Reader: statement-bind-parameter-names (object)
Package

sqlite.

Methods
Reader Method: statement-bind-parameter-names ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

parameters-names.

Generic Reader: statement-column-names (object)
Package

sqlite.

Methods
Reader Method: statement-column-names ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

columns-names.


4.1.4 Standalone methods

Method: initialize-instance :after ((object sqlite-handle) &key database-path &allow-other-keys)
Source

sqlite.lisp.

Method: initialize-instance :after ((object sqlite-statement) &key &allow-other-keys)
Source

sqlite.lisp.

Method: print-object :after ((obj sqlite-error) stream)
Source

sqlite.lisp.


4.1.5 Conditions

Condition: sqlite-constraint-error
Package

sqlite.

Source

sqlite.lisp.

Direct superclasses

sqlite-error.

Condition: sqlite-error
Package

sqlite.

Source

sqlite.lisp.

Direct superclasses

simple-error.

Direct subclasses

sqlite-constraint-error.

Direct methods
Direct slots
Slot: handle
Initform

(quote nil)

Initargs

:db-handle

Readers

sqlite-error-db-handle.

Writers

This slot is read-only.

Slot: error-code
Initform

(quote nil)

Initargs

:error-code

Readers

sqlite-error-code.

Writers

This slot is read-only.

Slot: error-msg
Initform

(quote nil)

Initargs

:error-msg

Readers

sqlite-error-message.

Writers

This slot is read-only.

Slot: statement
Initform

(quote nil)

Initargs

:statement

Readers

sqlite-error-statement.

Writers

This slot is read-only.

Slot: sql
Initform

(quote nil)

Initargs

:sql

Readers

sqlite-error-sql.

Writers

This slot is read-only.


4.1.6 Classes

Class: mru-cache
Package

sqlite.cache.

Source

cache.lisp.

Direct methods
Direct slots
Slot: objects-table
Initform

(make-hash-table :test (quote equal))

Readers

objects-table.

Writers

(setf objects-table).

Slot: last-access-time-table
Initform

(make-hash-table :test (quote equal))

Readers

last-access-time-table.

Writers

(setf last-access-time-table).

Slot: total-cached
Type

fixnum

Initform

0

Readers

total-cached.

Writers

(setf total-cached).

Slot: cache-size
Type

fixnum

Initform

100

Initargs

:cache-size

Readers

cache-size.

Writers

(setf cache-size).

Slot: destructor
Initform

(function identity)

Initargs

:destructor

Readers

destructor.

Writers

(setf destructor).

Class: sqlite-handle

Class that encapsulates the connection to the database. Use connect and disconnect.

Package

sqlite.

Source

sqlite.lisp.

Direct methods
Direct slots
Slot: handle
Readers

handle.

Writers

(setf handle).

Slot: database-path
Readers

database-path.

Writers

(setf database-path).

Slot: cache
Readers

cache.

Writers

(setf cache).

Slot: statements
Readers

sqlite-handle-statements.

Writers

(setf sqlite-handle-statements).

Class: sqlite-statement

Class that represents the prepared statement.

Package

sqlite.

Source

sqlite.lisp.

Direct methods
Direct slots
Slot: db
Initargs

:db

Readers

db.

Writers

This slot is read-only.

Slot: handle
Readers

handle.

Writers

(setf handle).

Slot: sql
Initargs

:sql

Readers

sql.

Writers

This slot is read-only.

Slot: columns-count
Readers

resultset-columns-count.

Writers

(setf resultset-columns-count).

Slot: columns-names
Readers
Writers

(setf resultset-columns-names).

Slot: parameters-count
Readers

parameters-count.

Writers

(setf parameters-count).

Slot: parameters-names
Readers
Writers

(setf parameters-names).


4.2 Internals


4.2.1 Constants

Constant: destructor-transient-address
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.


4.2.2 Macros

Macro: clause-for-in-sqlite-query-on-database-1 (&key for in-sqlite-query on-database with-parameters generate)
Package

sqlite.

Source

sqlite.lisp.

Macro: clause-for-in-sqlite-query/named-on-database-2 (&key for in-sqlite-query/named on-database with-parameters generate)
Package

sqlite.

Source

sqlite.lisp.

Macro: clause-for-on-sqlite-statement-3 (&key for on-sqlite-statement generate)
Package

sqlite.

Source

sqlite.lisp.

Macro: with-prepared-statement (statement-var (db sql parameters-var) &body body)
Package

sqlite.

Source

sqlite.lisp.

Macro: with-prepared-statement/named (statement-var (db sql parameters-var) &body body)
Package

sqlite.

Source

sqlite.lisp.


4.2.3 Ordinary functions

Function: pop-from-cache (cache)
Package

sqlite.cache.

Source

cache.lisp.

Function: really-finalize-statement (statement)
Package

sqlite.

Source

sqlite.lisp.

Function: remove-empty-objects-stacks (cache)
Package

sqlite.cache.

Source

cache.lisp.

Function: statement-parameter-index (statement parameter-name)
Package

sqlite.

Source

sqlite.lisp.


4.2.4 Generic functions

Generic Reader: cache (object)
Package

sqlite.

Methods
Reader Method: cache ((sqlite-handle sqlite-handle))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

cache.

Generic Writer: (setf cache) (object)
Package

sqlite.

Methods
Writer Method: (setf cache) ((sqlite-handle sqlite-handle))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

cache.

Generic Reader: cache-size (object)
Package

sqlite.cache.

Methods
Reader Method: cache-size ((mru-cache mru-cache))

automatically generated reader method

Source

cache.lisp.

Target Slot

cache-size.

Generic Writer: (setf cache-size) (object)
Package

sqlite.cache.

Methods
Writer Method: (setf cache-size) ((mru-cache mru-cache))

automatically generated writer method

Source

cache.lisp.

Target Slot

cache-size.

Generic Reader: database-path (object)
Package

sqlite.

Methods
Reader Method: database-path ((sqlite-handle sqlite-handle))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

database-path.

Generic Writer: (setf database-path) (object)
Package

sqlite.

Methods
Writer Method: (setf database-path) ((sqlite-handle sqlite-handle))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

database-path.

Generic Reader: db (object)
Package

sqlite.

Methods
Reader Method: db ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

db.

Generic Reader: destructor (object)
Package

sqlite.cache.

Methods
Reader Method: destructor ((mru-cache mru-cache))

automatically generated reader method

Source

cache.lisp.

Target Slot

destructor.

Generic Writer: (setf destructor) (object)
Package

sqlite.cache.

Methods
Writer Method: (setf destructor) ((mru-cache mru-cache))

automatically generated writer method

Source

cache.lisp.

Target Slot

destructor.

Generic Reader: handle (object)
Package

sqlite.

Methods
Reader Method: handle ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

handle.

Reader Method: handle ((sqlite-handle sqlite-handle))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

handle.

Generic Writer: (setf handle) (object)
Package

sqlite.

Methods
Writer Method: (setf handle) ((sqlite-statement sqlite-statement))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

handle.

Writer Method: (setf handle) ((sqlite-handle sqlite-handle))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

handle.

Generic Reader: last-access-time-table (object)
Package

sqlite.cache.

Methods
Reader Method: last-access-time-table ((mru-cache mru-cache))

automatically generated reader method

Source

cache.lisp.

Target Slot

last-access-time-table.

Generic Writer: (setf last-access-time-table) (object)
Package

sqlite.cache.

Methods
Writer Method: (setf last-access-time-table) ((mru-cache mru-cache))

automatically generated writer method

Source

cache.lisp.

Target Slot

last-access-time-table.

Generic Reader: objects-table (object)
Package

sqlite.cache.

Methods
Reader Method: objects-table ((mru-cache mru-cache))

automatically generated reader method

Source

cache.lisp.

Target Slot

objects-table.

Generic Writer: (setf objects-table) (object)
Package

sqlite.cache.

Methods
Writer Method: (setf objects-table) ((mru-cache mru-cache))

automatically generated writer method

Source

cache.lisp.

Target Slot

objects-table.

Generic Reader: parameters-count (object)
Package

sqlite.

Methods
Reader Method: parameters-count ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

parameters-count.

Generic Writer: (setf parameters-count) (object)
Package

sqlite.

Methods
Writer Method: (setf parameters-count) ((sqlite-statement sqlite-statement))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

parameters-count.

Generic Reader: parameters-names (object)
Package

sqlite.

Methods
Reader Method: parameters-names ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

parameters-names.

Generic Writer: (setf parameters-names) (object)
Package

sqlite.

Methods
Writer Method: (setf parameters-names) ((sqlite-statement sqlite-statement))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

parameters-names.

Generic Reader: resultset-columns-count (object)
Package

sqlite.

Methods
Reader Method: resultset-columns-count ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

columns-count.

Generic Writer: (setf resultset-columns-count) (object)
Package

sqlite.

Methods
Writer Method: (setf resultset-columns-count) ((sqlite-statement sqlite-statement))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

columns-count.

Generic Reader: resultset-columns-names (object)
Package

sqlite.

Methods
Reader Method: resultset-columns-names ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

columns-names.

Generic Writer: (setf resultset-columns-names) (object)
Package

sqlite.

Methods
Writer Method: (setf resultset-columns-names) ((sqlite-statement sqlite-statement))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

columns-names.

Generic Reader: sql (object)
Package

sqlite.

Methods
Reader Method: sql ((sqlite-statement sqlite-statement))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

sql.

Generic Reader: sqlite-error-statement (condition)
Package

sqlite.

Methods
Reader Method: sqlite-error-statement ((condition sqlite-error))
Source

sqlite.lisp.

Target Slot

statement.

Generic Reader: sqlite-handle-statements (object)
Package

sqlite.

Methods
Reader Method: sqlite-handle-statements ((sqlite-handle sqlite-handle))

automatically generated reader method

Source

sqlite.lisp.

Target Slot

statements.

Generic Writer: (setf sqlite-handle-statements) (object)
Package

sqlite.

Methods
Writer Method: (setf sqlite-handle-statements) ((sqlite-handle sqlite-handle))

automatically generated writer method

Source

sqlite.lisp.

Target Slot

statements.

Generic Reader: total-cached (object)
Package

sqlite.cache.

Methods
Reader Method: total-cached ((mru-cache mru-cache))

automatically generated reader method

Source

cache.lisp.

Target Slot

total-cached.

Generic Writer: (setf total-cached) (object)
Package

sqlite.cache.

Methods
Writer Method: (setf total-cached) ((mru-cache mru-cache))

automatically generated writer method

Source

cache.lisp.

Target Slot

total-cached.


4.2.5 Classes

Class: sqlite3-stmt-tclass
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Direct superclasses
  • foreign-struct-type.
  • translatable-foreign-type.
Class: sqlite3-tclass
Package

sqlite-ffi.

Source

sqlite-ffi.lisp.

Direct superclasses
  • foreign-struct-type.
  • translatable-foreign-type.

Appendix A Indexes


A.1 Concepts


A.2 Functions

Jump to:   (  
B   C   D   E   F   G   H   I   L   M   O   P   R   S   T   W  
Index Entry  Section

(
(setf cache): Private generic functions
(setf cache): Private generic functions
(setf cache-size): Private generic functions
(setf cache-size): Private generic functions
(setf database-path): Private generic functions
(setf database-path): Private generic functions
(setf destructor): Private generic functions
(setf destructor): Private generic functions
(setf handle): Private generic functions
(setf handle): Private generic functions
(setf handle): Private generic functions
(setf last-access-time-table): Private generic functions
(setf last-access-time-table): Private generic functions
(setf objects-table): Private generic functions
(setf objects-table): Private generic functions
(setf parameters-count): Private generic functions
(setf parameters-count): Private generic functions
(setf parameters-names): Private generic functions
(setf parameters-names): Private generic functions
(setf resultset-columns-count): Private generic functions
(setf resultset-columns-count): Private generic functions
(setf resultset-columns-names): Private generic functions
(setf resultset-columns-names): Private generic functions
(setf sqlite-handle-statements): Private generic functions
(setf sqlite-handle-statements): Private generic functions
(setf total-cached): Private generic functions
(setf total-cached): Private generic functions

B
bind-parameter: Public ordinary functions

C
cache: Private generic functions
cache: Private generic functions
cache-size: Private generic functions
cache-size: Private generic functions
clause-for-in-sqlite-query-on-database-1: Private macros
clause-for-in-sqlite-query/named-on-database-2: Private macros
clause-for-on-sqlite-statement-3: Private macros
clear-statement-bindings: Public ordinary functions
connect: Public ordinary functions

D
database-path: Private generic functions
database-path: Private generic functions
db: Private generic functions
db: Private generic functions
destructor: Private generic functions
destructor: Private generic functions
destructor-static: Public ordinary functions
destructor-transient: Public ordinary functions
disconnect: Public ordinary functions

E
execute-non-query: Public ordinary functions
execute-non-query/named: Public ordinary functions
execute-one-row-m-v: Public ordinary functions
execute-one-row-m-v/named: Public ordinary functions
execute-single: Public ordinary functions
execute-single/named: Public ordinary functions
execute-to-list: Public ordinary functions
execute-to-list/named: Public ordinary functions

F
finalize-statement: Public ordinary functions
Function, bind-parameter: Public ordinary functions
Function, clear-statement-bindings: Public ordinary functions
Function, connect: Public ordinary functions
Function, destructor-static: Public ordinary functions
Function, destructor-transient: Public ordinary functions
Function, disconnect: Public ordinary functions
Function, execute-non-query: Public ordinary functions
Function, execute-non-query/named: Public ordinary functions
Function, execute-one-row-m-v: Public ordinary functions
Function, execute-one-row-m-v/named: Public ordinary functions
Function, execute-single: Public ordinary functions
Function, execute-single/named: Public ordinary functions
Function, execute-to-list: Public ordinary functions
Function, execute-to-list/named: Public ordinary functions
Function, finalize-statement: Public ordinary functions
Function, get-from-cache: Public ordinary functions
Function, last-insert-rowid: Public ordinary functions
Function, pop-from-cache: Private ordinary functions
Function, prepare-statement: Public ordinary functions
Function, purge-cache: Public ordinary functions
Function, put-to-cache: Public ordinary functions
Function, really-finalize-statement: Private ordinary functions
Function, remove-empty-objects-stacks: Private ordinary functions
Function, reset-statement: Public ordinary functions
Function, set-busy-timeout: Public ordinary functions
Function, sqlite-error: Public ordinary functions
Function, sqlite3-bind-blob: Public ordinary functions
Function, sqlite3-bind-double: Public ordinary functions
Function, sqlite3-bind-int64: Public ordinary functions
Function, sqlite3-bind-null: Public ordinary functions
Function, sqlite3-bind-parameter-count: Public ordinary functions
Function, sqlite3-bind-parameter-index: Public ordinary functions
Function, sqlite3-bind-parameter-name: Public ordinary functions
Function, sqlite3-bind-text: Public ordinary functions
Function, sqlite3-busy-timeout: Public ordinary functions
Function, sqlite3-clear-bindings: Public ordinary functions
Function, sqlite3-close: Public ordinary functions
Function, sqlite3-column-blob: Public ordinary functions
Function, sqlite3-column-bytes: Public ordinary functions
Function, sqlite3-column-count: Public ordinary functions
Function, sqlite3-column-double: Public ordinary functions
Function, sqlite3-column-int64: Public ordinary functions
Function, sqlite3-column-name: Public ordinary functions
Function, sqlite3-column-text: Public ordinary functions
Function, sqlite3-column-type: Public ordinary functions
Function, sqlite3-errmsg: Public ordinary functions
Function, sqlite3-finalize: Public ordinary functions
Function, sqlite3-last-insert-rowid: Public ordinary functions
Function, sqlite3-open: Public ordinary functions
Function, sqlite3-prepare: Public ordinary functions
Function, sqlite3-reset: Public ordinary functions
Function, sqlite3-step: Public ordinary functions
Function, statement-column-value: Public ordinary functions
Function, statement-parameter-index: Private ordinary functions
Function, step-statement: Public ordinary functions

G
Generic Function, (setf cache): Private generic functions
Generic Function, (setf cache-size): Private generic functions
Generic Function, (setf database-path): Private generic functions
Generic Function, (setf destructor): Private generic functions
Generic Function, (setf handle): Private generic functions
Generic Function, (setf last-access-time-table): Private generic functions
Generic Function, (setf objects-table): Private generic functions
Generic Function, (setf parameters-count): Private generic functions
Generic Function, (setf parameters-names): Private generic functions
Generic Function, (setf resultset-columns-count): Private generic functions
Generic Function, (setf resultset-columns-names): Private generic functions
Generic Function, (setf sqlite-handle-statements): Private generic functions
Generic Function, (setf total-cached): Private generic functions
Generic Function, cache: Private generic functions
Generic Function, cache-size: Private generic functions
Generic Function, database-path: Private generic functions
Generic Function, db: Private generic functions
Generic Function, destructor: Private generic functions
Generic Function, handle: Private generic functions
Generic Function, last-access-time-table: Private generic functions
Generic Function, objects-table: Private generic functions
Generic Function, parameters-count: Private generic functions
Generic Function, parameters-names: Private generic functions
Generic Function, resultset-columns-count: Private generic functions
Generic Function, resultset-columns-names: Private generic functions
Generic Function, sql: Private generic functions
Generic Function, sqlite-error-code: Public generic functions
Generic Function, sqlite-error-db-handle: Public generic functions
Generic Function, sqlite-error-message: Public generic functions
Generic Function, sqlite-error-sql: Public generic functions
Generic Function, sqlite-error-statement: Private generic functions
Generic Function, sqlite-handle-statements: Private generic functions
Generic Function, statement-bind-parameter-names: Public generic functions
Generic Function, statement-column-names: Public generic functions
Generic Function, total-cached: Private generic functions
get-from-cache: Public ordinary functions

H
handle: Private generic functions
handle: Private generic functions
handle: Private generic functions

I
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods

L
last-access-time-table: Private generic functions
last-access-time-table: Private generic functions
last-insert-rowid: Public ordinary functions

M
Macro, clause-for-in-sqlite-query-on-database-1: Private macros
Macro, clause-for-in-sqlite-query/named-on-database-2: Private macros
Macro, clause-for-on-sqlite-statement-3: Private macros
Macro, with-open-database: Public macros
Macro, with-prepared-statement: Private macros
Macro, with-prepared-statement/named: Private macros
Macro, with-transaction: Public macros
Method, (setf cache): Private generic functions
Method, (setf cache-size): Private generic functions
Method, (setf database-path): Private generic functions
Method, (setf destructor): Private generic functions
Method, (setf handle): Private generic functions
Method, (setf handle): Private generic functions
Method, (setf last-access-time-table): Private generic functions
Method, (setf objects-table): Private generic functions
Method, (setf parameters-count): Private generic functions
Method, (setf parameters-names): Private generic functions
Method, (setf resultset-columns-count): Private generic functions
Method, (setf resultset-columns-names): Private generic functions
Method, (setf sqlite-handle-statements): Private generic functions
Method, (setf total-cached): Private generic functions
Method, cache: Private generic functions
Method, cache-size: Private generic functions
Method, database-path: Private generic functions
Method, db: Private generic functions
Method, destructor: Private generic functions
Method, handle: Private generic functions
Method, handle: Private generic functions
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, last-access-time-table: Private generic functions
Method, objects-table: Private generic functions
Method, parameters-count: Private generic functions
Method, parameters-names: Private generic functions
Method, print-object: Public standalone methods
Method, resultset-columns-count: Private generic functions
Method, resultset-columns-names: Private generic functions
Method, sql: Private generic functions
Method, sqlite-error-code: Public generic functions
Method, sqlite-error-db-handle: Public generic functions
Method, sqlite-error-message: Public generic functions
Method, sqlite-error-sql: Public generic functions
Method, sqlite-error-statement: Private generic functions
Method, sqlite-handle-statements: Private generic functions
Method, statement-bind-parameter-names: Public generic functions
Method, statement-column-names: Public generic functions
Method, total-cached: Private generic functions

O
objects-table: Private generic functions
objects-table: Private generic functions

P
parameters-count: Private generic functions
parameters-count: Private generic functions
parameters-names: Private generic functions
parameters-names: Private generic functions
pop-from-cache: Private ordinary functions
prepare-statement: Public ordinary functions
print-object: Public standalone methods
purge-cache: Public ordinary functions
put-to-cache: Public ordinary functions

R
really-finalize-statement: Private ordinary functions
remove-empty-objects-stacks: Private ordinary functions
reset-statement: Public ordinary functions
resultset-columns-count: Private generic functions
resultset-columns-count: Private generic functions
resultset-columns-names: Private generic functions
resultset-columns-names: Private generic functions

S
set-busy-timeout: Public ordinary functions
sql: Private generic functions
sql: Private generic functions
sqlite-error: Public ordinary functions
sqlite-error-code: Public generic functions
sqlite-error-code: Public generic functions
sqlite-error-db-handle: Public generic functions
sqlite-error-db-handle: Public generic functions
sqlite-error-message: Public generic functions
sqlite-error-message: Public generic functions
sqlite-error-sql: Public generic functions
sqlite-error-sql: Public generic functions
sqlite-error-statement: Private generic functions
sqlite-error-statement: Private generic functions
sqlite-handle-statements: Private generic functions
sqlite-handle-statements: Private generic functions
sqlite3-bind-blob: Public ordinary functions
sqlite3-bind-double: Public ordinary functions
sqlite3-bind-int64: Public ordinary functions
sqlite3-bind-null: Public ordinary functions
sqlite3-bind-parameter-count: Public ordinary functions
sqlite3-bind-parameter-index: Public ordinary functions
sqlite3-bind-parameter-name: Public ordinary functions
sqlite3-bind-text: Public ordinary functions
sqlite3-busy-timeout: Public ordinary functions
sqlite3-clear-bindings: Public ordinary functions
sqlite3-close: Public ordinary functions
sqlite3-column-blob: Public ordinary functions
sqlite3-column-bytes: Public ordinary functions
sqlite3-column-count: Public ordinary functions
sqlite3-column-double: Public ordinary functions
sqlite3-column-int64: Public ordinary functions
sqlite3-column-name: Public ordinary functions
sqlite3-column-text: Public ordinary functions
sqlite3-column-type: Public ordinary functions
sqlite3-errmsg: Public ordinary functions
sqlite3-finalize: Public ordinary functions
sqlite3-last-insert-rowid: Public ordinary functions
sqlite3-open: Public ordinary functions
sqlite3-prepare: Public ordinary functions
sqlite3-reset: Public ordinary functions
sqlite3-step: Public ordinary functions
statement-bind-parameter-names: Public generic functions
statement-bind-parameter-names: Public generic functions
statement-column-names: Public generic functions
statement-column-names: Public generic functions
statement-column-value: Public ordinary functions
statement-parameter-index: Private ordinary functions
step-statement: Public ordinary functions

T
total-cached: Private generic functions
total-cached: Private generic functions

W
with-open-database: Public macros
with-prepared-statement: Private macros
with-prepared-statement/named: Private macros
with-transaction: Public macros


A.3 Variables

Jump to:   C   D   E   H   L   O   P   S   T  
Index Entry  Section

C
cache: Public classes
cache-size: Public classes
columns-count: Public classes
columns-names: Public classes
Constant, destructor-transient-address: Private constants

D
database-path: Public classes
db: Public classes
destructor: Public classes
destructor-transient-address: Private constants

E
error-code: Public conditions
error-msg: Public conditions

H
handle: Public conditions
handle: Public classes
handle: Public classes

L
last-access-time-table: Public classes

O
objects-table: Public classes

P
parameters-count: Public classes
parameters-names: Public classes

S
Slot, cache: Public classes
Slot, cache-size: Public classes
Slot, columns-count: Public classes
Slot, columns-names: Public classes
Slot, database-path: Public classes
Slot, db: Public classes
Slot, destructor: Public classes
Slot, error-code: Public conditions
Slot, error-msg: Public conditions
Slot, handle: Public conditions
Slot, handle: Public classes
Slot, handle: Public classes
Slot, last-access-time-table: Public classes
Slot, objects-table: Public classes
Slot, parameters-count: Public classes
Slot, parameters-names: Public classes
Slot, sql: Public conditions
Slot, sql: Public classes
Slot, statement: Public conditions
Slot, statements: Public classes
Slot, total-cached: Public classes
sql: Public conditions
sql: Public classes
statement: Public conditions
statements: Public classes

T
total-cached: Public classes