Common Lisp Package: DB-CLSQL

README:

FUNCTION

Private

SQL-TEST-AND-CONSTRUCT (SPEC)

Entry function for making SQL data store controllers

Undocumented

ARRAY-INDEX-IF (P A)

CONNECTION-OK-P-CON (CON)

CREATE-KEYVALUE-TABLE (SC)

CREATE-VERSION-TABLE (SC)

FORM-SLOT-KEY (OID NAME)

GET-NUMBER (CLCN KEY VALUE SC)

INSURE-THREAD-TABLE-LOCK

KEYVALUE-TABLE-EXISTS (CON)

MY-GENERIC-AT-MOST (A B)

MY-GENERIC-LESS-THAN (A B)

QUERY-USES-PK (CON)

SQL-ADD-TO-CLCN (CLCN KEY VALUE SC &KEY (INSERT-ONLY NIL))

SQL-ADD-TO-ROOT (KEY VALUE SC)

SQL-DUMP-CLCN (CLCN SC)

SQL-FROM-CLCN-EXISTSP (CLCN KEY SC)

SQL-FROM-CLCN-KEY-AND-VALUE-EXISTSP (CLCN KEY VALUE SC)

SQL-FROM-ROOT-EXISTSP (KEY SC)

SQL-GET-FROM-CLCN (CLCN KEY SC)

SQL-GET-FROM-CLCN-CNT (CLCN KEY SC)

SQL-GET-FROM-CLCN-NTH (CLCN KEY SC N)

SQL-GET-FROM-ROOT (KEY SC)

SQL-REMOVE-FROM-CLCN (CLCN KEY SC)

SQL-REMOVE-FROM-ROOT (KEY SC)

SQL-REMOVE-KEY-AND-VALUE-FROM-CLCN (CLCN KEY VALUE SC)

SQL-REMOVE-ONE-FROM-CLCN (CLCN KEY SC)

SQL-REMOVE-ONE-KEY-AND-VALUE-FROM-CLCN (CLCN KEY VALUE SC)

SQL-STORE-SPEC-P (SPEC)

SQLITE3-HARMLESS-READ (SC)

THREAD-HASH

VERSION-TABLE-EXISTS (CON)

GENERIC-FUNCTION

Private

Undocumented

BUILD-BTREE-INDEX (SC &KEY PRIMARY KEY-FORM)

CONNECTION-OK-P (SC)

CONNECTION-REALLY-OK-P (SC)

CONTROLLER-DB (SC)

CONTROLLER-STATUS (SC)

CURSOR-CURRENT-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-FIRST-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-INIT (CURSOR)

CURSOR-LAST-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-NEXT-DUP-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-NEXT-NODUP-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-NEXT-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-PREV-NODUP-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-PREV-X (CURSOR &KEY (RETURNPK NIL))

CURSOR-UN-INIT (CURSOR &KEY (RETURNPK NIL))

GET-CURRENT-KEY (CURSOR)

GET-CURRENT-VALUE (CURSOR)

HAS-KEY-VALUE (CURSOR)

HAS-KEY-VALUE-SCND (CURSOR &KEY (RETURNPK NIL))

RECONNECT-CONTROLLER (SC)

SUPPORTS-SEQUENCE (SC)

SLOT-ACCESSOR

Private

Undocumented

CONTROLLER-DB-TABLE (OBJECT)

SETFCONTROLLER-DB-TABLE (NEW-VALUE OBJECT)

DP-NMBR (OBJECT)

SETFDP-NMBR (NEW-VALUE OBJECT)

DUP-BTREES-OF (OBJECT)

SETFDUP-BTREES-OF (NEW-VALUE OBJECT)

INDICES (OBJECT)

SETFINDICES (NEW-VALUE OBJECT)

INDICES-CACHE (OBJECT)

SETFINDICES-CACHE (NEW-VALUE OBJECT)

SQL-CRSR-CK (OBJECT)

SETFSQL-CRSR-CK (NEW-VALUE OBJECT)

SQL-CRSR-KS (OBJECT)

SETFSQL-CRSR-KS (NEW-VALUE OBJECT)

USES-PK-OF (OBJECT)

SETFUSES-PK-OF (NEW-VALUE OBJECT)

VARIABLE

Private

Undocumented

*THREAD-TABLE-LOCK*

CLASS

Private

SQL-BTREE

A SQL implementation of a BTree

SQL-BTREE-INDEX

A SQL-based BTree supports secondary indices.

SQL-CURSOR

A SQL cursor for traversing (primary) BTrees.

SQL-DUP-BTREE

A SQL implementation of a duplicate-BTree

SQL-DUP-CURSOR

A SQL cursor for traversing duplciate-BTrees.

SQL-INDEXED-BTREE

A SQL-based BTree that supports secondary indices.

SQL-SECONDARY-CURSOR

Cursor for traversing bdb secondary indices.

SQL-STORE-CONTROLLER

Class of objects responsible for the book-keeping of holding DB handles, the cache, table creation, counters, locks, the root (for garbage collection,) et cetera. This is the Postgresql-specific subclass of store-controller.