The sqlite Reference Manual

Table of Contents

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

The sqlite Reference Manual

This is the sqlite Reference Manual, version 0.1.6, generated automatically by Declt version 2.4 "Will Decker" on Wed Jun 20 11:24:18 2018 GMT+0.


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

1 Systems

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


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

1.1 sqlite

Author

Kalyanov Dmitry <Kalyanov.Dmitry@gmail.com>

License

Public Domain

Version

0.1.6

Dependencies
Source

sqlite.asd (file)

Components

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

2 Files

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


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

2.1 Lisp


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

2.1.1 sqlite.asd

Location

sqlite.asd

Systems

sqlite (system)


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

2.1.2 sqlite/sqlite-ffi.lisp

Parent

sqlite (system)

Location

sqlite-ffi.lisp

Packages

sqlite-ffi

Exported Definitions
Internal Definitions

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

2.1.3 sqlite/cache.lisp

Parent

sqlite (system)

Location

cache.lisp

Packages

sqlite.cache

Exported Definitions
Internal Definitions

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

2.1.4 sqlite/sqlite.lisp

Dependencies
Parent

sqlite (system)

Location

sqlite.lisp

Packages

sqlite

Exported Definitions
Internal Definitions

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

3 Packages

Packages are listed by definition order.


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

3.1 sqlite-ffi

Source

sqlite-ffi.lisp (file)

Use List
Exported Definitions
Internal Definitions

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

3.2 sqlite.cache

Source

cache.lisp (file)

Use List
Exported Definitions
Internal Definitions

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

3.3 sqlite

Source

sqlite.lisp (file)

Use List
Exported Definitions
Internal Definitions

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

4 Definitions

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


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

4.1 Exported definitions


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

4.1.1 Macros

Macro: with-open-database (DB PATH &key BUSY-TIMEOUT) &body BODY
Package

sqlite

Source

sqlite.lisp (file)

Macro: with-transaction DB &body BODY

Wraps the BODY inside the transaction.

Package

sqlite

Source

sqlite.lisp (file)


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

4.1.2 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 (file)

Function: clear-statement-bindings STATEMENT

Sets all binding values to NULL.

Package

sqlite

Source

sqlite.lisp (file)

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 (file)

Function: destructor-static ()
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: destructor-transient ()
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: disconnect HANDLE

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

Package

sqlite

Source

sqlite.lisp (file)

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 (file)

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 (file)

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 (file)

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 (file)

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 (file)

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 (file)

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 (file)

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 (file)

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 (file)

Function: get-from-cache CACHE ID
Package

sqlite.cache

Source

cache.lisp (file)

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 (file)

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 (file)

Function: purge-cache CACHE
Package

sqlite.cache

Source

cache.lisp (file)

Function: put-to-cache CACHE ID OBJECT
Package

sqlite.cache

Source

cache.lisp (file)

Function: reset-statement STATEMENT

Resets the STATEMENT and prepare it to be called again.

Package

sqlite

Source

sqlite.lisp (file)

Function: set-busy-timeout DB MILLISECONDS

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

Package

sqlite

Source

sqlite.lisp (file)

Function: sqlite-error ERROR-CODE MESSAGE &key STATEMENT DB-HANDLE SQL-TEXT
Package

sqlite

Source

sqlite.lisp (file)

Function: sqlite3-bind-blob STATEMENT PARAMETER-INDEX VALUE BYTES-COUNT DESTRUCTOR
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-double STATEMENT PARAMETER-INDEX VALUE
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-int64 STATEMENT PARAMETER-INDEX VALUE
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-null STATEMENT PARAMETER-INDEX
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-parameter-count STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-parameter-index STATEMENT NAME
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-parameter-name STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-bind-text STATEMENT PARAMETER-INDEX VALUE OCTETS-COUNT DESTRUCTOR
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-busy-timeout DB MS
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-clear-bindings STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-close DB
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-blob STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-bytes STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-count STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-double STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-int64 STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-name STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-text STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-column-type STATEMENT COLUMN-NUMBER
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-errmsg DB
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-finalize STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-last-insert-rowid DB
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-open FILENAME DB
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-prepare DB SQL SQL-LENGTH-BYTES STMT TAIL
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-reset STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Function: sqlite3-step STATEMENT
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

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 (file)

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 (file)


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

4.1.3 Generic functions

Generic Function: sqlite-error-code CONDITION
Package

sqlite

Methods
Method: sqlite-error-code (CONDITION sqlite-error)
Source

sqlite.lisp (file)

Generic Function: sqlite-error-db-handle CONDITION
Package

sqlite

Methods
Method: sqlite-error-db-handle (CONDITION sqlite-error)
Source

sqlite.lisp (file)

Generic Function: sqlite-error-message CONDITION
Package

sqlite

Methods
Method: sqlite-error-message (CONDITION sqlite-error)
Source

sqlite.lisp (file)

Generic Function: sqlite-error-sql CONDITION
Package

sqlite

Methods
Method: sqlite-error-sql (CONDITION sqlite-error)
Source

sqlite.lisp (file)

Generic Function: statement-bind-parameter-names OBJECT
Package

sqlite

Methods
Method: statement-bind-parameter-names (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Generic Function: statement-column-names OBJECT
Package

sqlite

Methods
Method: statement-column-names (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)


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

4.1.4 Conditions

Condition: sqlite-constraint-error ()
Package

sqlite

Source

sqlite.lisp (file)

Direct superclasses

sqlite-error (condition)

Condition: sqlite-error ()
Package

sqlite

Source

sqlite.lisp (file)

Direct superclasses

simple-error (condition)

Direct subclasses

sqlite-constraint-error (condition)

Direct methods
Direct slots
Slot: handle
Initargs

:db-handle

Initform

(quote nil)

Readers

sqlite-error-db-handle (generic function)

Slot: error-code
Initargs

:error-code

Initform

(quote nil)

Readers

sqlite-error-code (generic function)

Slot: error-msg
Initargs

:error-msg

Initform

(quote nil)

Readers

sqlite-error-message (generic function)

Slot: statement
Initargs

:statement

Initform

(quote nil)

Readers

sqlite-error-statement (generic function)

Slot: sql
Initargs

:sql

Initform

(quote nil)

Readers

sqlite-error-sql (generic function)


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

4.1.5 Classes

Class: mru-cache ()
Package

sqlite.cache

Source

cache.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: objects-table
Initform

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

Readers

objects-table (generic function)

Writers

(setf objects-table) (generic function)

Slot: last-access-time-table
Initform

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

Readers

last-access-time-table (generic function)

Writers

(setf last-access-time-table) (generic function)

Slot: total-cached
Type

fixnum

Initform

0

Readers

total-cached (generic function)

Writers

(setf total-cached) (generic function)

Slot: cache-size
Type

fixnum

Initargs

:cache-size

Initform

100

Readers

cache-size (generic function)

Writers

(setf cache-size) (generic function)

Slot: destructor
Initargs

:destructor

Initform

(function identity)

Readers

destructor (generic function)

Writers

(setf destructor) (generic function)

Class: sqlite-handle ()

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

Package

sqlite

Source

sqlite.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: handle
Readers

handle (generic function)

Writers

(setf handle) (generic function)

Slot: database-path
Readers

database-path (generic function)

Writers

(setf database-path) (generic function)

Slot: cache
Readers

cache (generic function)

Writers

(setf cache) (generic function)

Slot: statements
Readers

sqlite-handle-statements (generic function)

Writers

(setf sqlite-handle-statements) (generic function)

Class: sqlite-statement ()

Class that represents the prepared statement.

Package

sqlite

Source

sqlite.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: db
Initargs

:db

Readers

db (generic function)

Slot: handle
Readers

handle (generic function)

Writers

(setf handle) (generic function)

Slot: sql
Initargs

:sql

Readers

sql (generic function)

Slot: columns-count
Readers

resultset-columns-count (generic function)

Writers

(setf resultset-columns-count) (generic function)

Slot: columns-names
Readers
Writers

(setf resultset-columns-names) (generic function)

Slot: parameters-count
Readers

parameters-count (generic function)

Writers

(setf parameters-count) (generic function)

Slot: parameters-names
Readers
Writers

(setf parameters-names) (generic function)


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

4.2 Internal definitions


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

4.2.1 Constants

Constant: destructor-transient-address
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)


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

4.2.2 Macros

Macro: clause-for-in-sqlite-query-on-database-1 &key (FOR VARS) (IN-SQLITE-QUERY QUERY-EXPRESSION) (ON-DATABASE DB) (WITH-PARAMETERS PARAMETERS) GENERATE
Package

sqlite

Source

sqlite.lisp (file)

Macro: clause-for-in-sqlite-query/named-on-database-2 &key (FOR VARS) (IN-SQLITE-QUERY/NAMED QUERY-EXPRESSION) (ON-DATABASE DB) (WITH-PARAMETERS PARAMETERS) GENERATE
Package

sqlite

Source

sqlite.lisp (file)

Macro: clause-for-on-sqlite-statement-3 &key (FOR VARS) (ON-SQLITE-STATEMENT STATEMENT) GENERATE
Package

sqlite

Source

sqlite.lisp (file)

Macro: with-prepared-statement STATEMENT-VAR (DB SQL PARAMETERS-VAR) &body BODY
Package

sqlite

Source

sqlite.lisp (file)

Macro: with-prepared-statement/named STATEMENT-VAR (DB SQL PARAMETERS-VAR) &body BODY
Package

sqlite

Source

sqlite.lisp (file)


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

4.2.3 Functions

Function: pop-from-cache CACHE
Package

sqlite.cache

Source

cache.lisp (file)

Function: really-finalize-statement STATEMENT
Package

sqlite

Source

sqlite.lisp (file)

Function: remove-empty-objects-stacks CACHE
Package

sqlite.cache

Source

cache.lisp (file)

Function: statement-parameter-index STATEMENT PARAMETER-NAME
Package

sqlite

Source

sqlite.lisp (file)


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

4.2.4 Generic functions

Generic Function: cache OBJECT
Generic Function: (setf cache) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: cache (SQLITE-HANDLE sqlite-handle)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf cache) NEW-VALUE (SQLITE-HANDLE sqlite-handle)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: cache-size OBJECT
Generic Function: (setf cache-size) NEW-VALUE OBJECT
Package

sqlite.cache

Methods
Method: cache-size (MRU-CACHE mru-cache)

automatically generated reader method

Source

cache.lisp (file)

Method: (setf cache-size) NEW-VALUE (MRU-CACHE mru-cache)

automatically generated writer method

Source

cache.lisp (file)

Generic Function: database-path OBJECT
Generic Function: (setf database-path) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: database-path (SQLITE-HANDLE sqlite-handle)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf database-path) NEW-VALUE (SQLITE-HANDLE sqlite-handle)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: db OBJECT
Package

sqlite

Methods
Method: db (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Generic Function: destructor OBJECT
Generic Function: (setf destructor) NEW-VALUE OBJECT
Package

sqlite.cache

Methods
Method: destructor (MRU-CACHE mru-cache)

automatically generated reader method

Source

cache.lisp (file)

Method: (setf destructor) NEW-VALUE (MRU-CACHE mru-cache)

automatically generated writer method

Source

cache.lisp (file)

Generic Function: handle OBJECT
Generic Function: (setf handle) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: handle (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf handle) NEW-VALUE (SQLITE-STATEMENT sqlite-statement)

automatically generated writer method

Source

sqlite.lisp (file)

Method: handle (SQLITE-HANDLE sqlite-handle)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf handle) NEW-VALUE (SQLITE-HANDLE sqlite-handle)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: last-access-time-table OBJECT
Generic Function: (setf last-access-time-table) NEW-VALUE OBJECT
Package

sqlite.cache

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

automatically generated reader method

Source

cache.lisp (file)

Method: (setf last-access-time-table) NEW-VALUE (MRU-CACHE mru-cache)

automatically generated writer method

Source

cache.lisp (file)

Generic Function: objects-table OBJECT
Generic Function: (setf objects-table) NEW-VALUE OBJECT
Package

sqlite.cache

Methods
Method: objects-table (MRU-CACHE mru-cache)

automatically generated reader method

Source

cache.lisp (file)

Method: (setf objects-table) NEW-VALUE (MRU-CACHE mru-cache)

automatically generated writer method

Source

cache.lisp (file)

Generic Function: parameters-count OBJECT
Generic Function: (setf parameters-count) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: parameters-count (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf parameters-count) NEW-VALUE (SQLITE-STATEMENT sqlite-statement)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: parameters-names OBJECT
Generic Function: (setf parameters-names) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: parameters-names (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf parameters-names) NEW-VALUE (SQLITE-STATEMENT sqlite-statement)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: resultset-columns-count OBJECT
Generic Function: (setf resultset-columns-count) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: resultset-columns-count (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf resultset-columns-count) NEW-VALUE (SQLITE-STATEMENT sqlite-statement)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: resultset-columns-names OBJECT
Generic Function: (setf resultset-columns-names) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: resultset-columns-names (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf resultset-columns-names) NEW-VALUE (SQLITE-STATEMENT sqlite-statement)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: sql OBJECT
Package

sqlite

Methods
Method: sql (SQLITE-STATEMENT sqlite-statement)

automatically generated reader method

Source

sqlite.lisp (file)

Generic Function: sqlite-error-statement CONDITION
Package

sqlite

Methods
Method: sqlite-error-statement (CONDITION sqlite-error)
Source

sqlite.lisp (file)

Generic Function: sqlite-handle-statements OBJECT
Generic Function: (setf sqlite-handle-statements) NEW-VALUE OBJECT
Package

sqlite

Methods
Method: sqlite-handle-statements (SQLITE-HANDLE sqlite-handle)

automatically generated reader method

Source

sqlite.lisp (file)

Method: (setf sqlite-handle-statements) NEW-VALUE (SQLITE-HANDLE sqlite-handle)

automatically generated writer method

Source

sqlite.lisp (file)

Generic Function: total-cached OBJECT
Generic Function: (setf total-cached) NEW-VALUE OBJECT
Package

sqlite.cache

Methods
Method: total-cached (MRU-CACHE mru-cache)

automatically generated reader method

Source

cache.lisp (file)

Method: (setf total-cached) NEW-VALUE (MRU-CACHE mru-cache)

automatically generated writer method

Source

cache.lisp (file)


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

4.2.5 Classes

Class: sqlite3-stmt-tclass ()
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Direct superclasses
  • translatable-foreign-type (class)
  • foreign-struct-type (class)
Class: sqlite3-tclass ()
Package

sqlite-ffi

Source

sqlite-ffi.lisp (file)

Direct superclasses
  • translatable-foreign-type (class)
  • foreign-struct-type (class)

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

Appendix A Indexes


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

A.1 Concepts

Jump to:   F   L   S  
Index Entry  Section

F
File, Lisp, sqlite.asd: The sqlite<dot>asd file
File, Lisp, sqlite/cache.lisp: The sqlite/cache<dot>lisp file
File, Lisp, sqlite/sqlite-ffi.lisp: The sqlite/sqlite-ffi<dot>lisp file
File, Lisp, sqlite/sqlite.lisp: The sqlite/sqlite<dot>lisp file

L
Lisp File, sqlite.asd: The sqlite<dot>asd file
Lisp File, sqlite/cache.lisp: The sqlite/cache<dot>lisp file
Lisp File, sqlite/sqlite-ffi.lisp: The sqlite/sqlite-ffi<dot>lisp file
Lisp File, sqlite/sqlite.lisp: The sqlite/sqlite<dot>lisp file

S
sqlite.asd: The sqlite<dot>asd file
sqlite/cache.lisp: The sqlite/cache<dot>lisp file
sqlite/sqlite-ffi.lisp: The sqlite/sqlite-ffi<dot>lisp file
sqlite/sqlite.lisp: The sqlite/sqlite<dot>lisp file

Jump to:   F   L   S  

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

A.2 Functions

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

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

B
bind-parameter: Exported functions

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

D
database-path: Internal generic functions
database-path: Internal generic functions
db: Internal generic functions
db: Internal generic functions
destructor: Internal generic functions
destructor: Internal generic functions
destructor-static: Exported functions
destructor-transient: Exported functions
disconnect: Exported functions

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

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

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

H
handle: Internal generic functions
handle: Internal generic functions
handle: Internal generic functions

L
last-access-time-table: Internal generic functions
last-access-time-table: Internal generic functions
last-insert-rowid: Exported functions

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

O
objects-table: Internal generic functions
objects-table: Internal generic functions

P
parameters-count: Internal generic functions
parameters-count: Internal generic functions
parameters-names: Internal generic functions
parameters-names: Internal generic functions
pop-from-cache: Internal functions
prepare-statement: Exported functions
purge-cache: Exported functions
put-to-cache: Exported functions

R
really-finalize-statement: Internal functions
remove-empty-objects-stacks: Internal functions
reset-statement: Exported functions
resultset-columns-count: Internal generic functions
resultset-columns-count: Internal generic functions
resultset-columns-names: Internal generic functions
resultset-columns-names: Internal generic functions

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

T
total-cached: Internal generic functions
total-cached: Internal generic functions

W
with-open-database: Exported macros
with-prepared-statement: Internal macros
with-prepared-statement/named: Internal macros
with-transaction: Exported macros

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

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

A.3 Variables

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

C
cache: Exported classes
cache-size: Exported classes
columns-count: Exported classes
columns-names: Exported classes
Constant, destructor-transient-address: Internal constants

D
database-path: Exported classes
db: Exported classes
destructor: Exported classes
destructor-transient-address: Internal constants

E
error-code: Exported conditions
error-msg: Exported conditions

H
handle: Exported conditions
handle: Exported classes
handle: Exported classes

L
last-access-time-table: Exported classes

O
objects-table: Exported classes

P
parameters-count: Exported classes
parameters-names: Exported classes

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

T
total-cached: Exported classes

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

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

A.4 Data types

Jump to:   C   M   P   S  
Index Entry  Section

C
Class, mru-cache: Exported classes
Class, sqlite-handle: Exported classes
Class, sqlite-statement: Exported classes
Class, sqlite3-stmt-tclass: Internal classes
Class, sqlite3-tclass: Internal classes
Condition, sqlite-constraint-error: Exported conditions
Condition, sqlite-error: Exported conditions

M
mru-cache: Exported classes

P
Package, sqlite: The sqlite package
Package, sqlite-ffi: The sqlite-ffi package
Package, sqlite.cache: The sqlite<dot>cache package

S
sqlite: The sqlite system
sqlite: The sqlite package
sqlite-constraint-error: Exported conditions
sqlite-error: Exported conditions
sqlite-ffi: The sqlite-ffi package
sqlite-handle: Exported classes
sqlite-statement: Exported classes
sqlite.cache: The sqlite<dot>cache package
sqlite3-stmt-tclass: Internal classes
sqlite3-tclass: Internal classes
System, sqlite: The sqlite system

Jump to:   C   M   P   S