The clsql Reference Manual

This is the clsql Reference Manual, version 6.4, generated automatically by Declt version 4.0 beta 2 "William Riker" on Mon Feb 26 16:02:37 2024 GMT+0.

Table of Contents


1 Introduction


2 Systems

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


2.1 clsql

Common Lisp SQL Interface library

Maintainer

Kevin M. Rosenberg <>

Author

Kevin Rosenberg <>

License

Lessor Lisp General Public License

Long Description

A Common Lisp interface to SQL RDBMS based on
the Xanalys CommonSQL interface for Lispworks. It provides low-level database interfaces as well as a functional and an object oriented interface.

Version

6.4

Source

clsql.asd.

Child Component

sql (module).


3 Modules

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


3.1 clsql/sql

Source

clsql.asd.

Parent Component

clsql (system).

Child Components

3.2 clsql/sql/base

Source

clsql.asd.

Parent Component

sql (module).

Child Components

3.3 clsql/sql/database

Dependency

base (module).

Source

clsql.asd.

Parent Component

sql (module).

Child Components

3.4 clsql/sql/syntax

Dependency

database (module).

Source

clsql.asd.

Parent Component

sql (module).

Child Components

3.5 clsql/sql/functional

Dependency

syntax (module).

Source

clsql.asd.

Parent Component

sql (module).

Child Components

3.6 clsql/sql/object

Dependency

functional (module).

Source

clsql.asd.

Parent Component

sql (module).

Child Components

3.7 clsql/sql/generic

Dependency

functional (module).

Source

clsql.asd.

Parent Component

sql (module).

Child Components

4 Files

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


4.1 Lisp


4.1.1 clsql/clsql.asd

Source

clsql.asd.

Parent Component

clsql (system).

ASDF Systems

clsql.

Packages

clsql-system.


4.1.2 clsql/sql/base/cmucl-compat.lisp

Source

clsql.asd.

Parent Component

base (module).

Packages

cmucl-compat.

Public Interface

4.1.3 clsql/sql/base/package.lisp

Source

clsql.asd.

Parent Component

base (module).

Packages

4.1.4 clsql/sql/base/kmr-mop.lisp

Dependency

package.lisp (file).

Source

clsql.asd.

Parent Component

base (module).

Internals

4.1.5 clsql/sql/base/base-classes.lisp

Dependency

package.lisp (file).

Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.6 clsql/sql/base/conditions.lisp

Dependency

base-classes.lisp (file).

Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.7 clsql/sql/base/db-interface.lisp

Dependency

conditions.lisp (file).

Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.8 clsql/sql/base/decimals.lisp

Dependencies
Source

clsql.asd.

Parent Component

base (module).

Packages

decimals.

Public Interface
Internals

4.1.9 clsql/sql/base/utils.lisp

Dependencies
Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.10 clsql/sql/base/time.lisp

Dependencies
Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.11 clsql/sql/base/generics.lisp

Dependency

package.lisp (file).

Source

clsql.asd.

Parent Component

base (module).

Public Interface
Internals

4.1.12 clsql/sql/database/initialize.lisp

Source

clsql.asd.

Parent Component

database (module).

Public Interface

4.1.13 clsql/sql/database/database.lisp

Dependency

initialize.lisp (file).

Source

clsql.asd.

Parent Component

database (module).

Public Interface
Internals

4.1.14 clsql/sql/database/recording.lisp

Dependency

database.lisp (file).

Source

clsql.asd.

Parent Component

database (module).

Public Interface
Internals

4.1.15 clsql/sql/database/pool.lisp

Dependency

database.lisp (file).

Source

clsql.asd.

Parent Component

database (module).

Public Interface
Internals

4.1.16 clsql/sql/syntax/expressions.lisp

Source

clsql.asd.

Parent Component

syntax (module).

Public Interface
Internals

4.1.17 clsql/sql/syntax/operations.lisp

Dependency

expressions.lisp (file).

Source

clsql.asd.

Parent Component

syntax (module).

Public Interface
Internals

4.1.18 clsql/sql/syntax/syntax.lisp

Dependency

operations.lisp (file).

Source

clsql.asd.

Parent Component

syntax (module).

Public Interface
Internals

4.1.19 clsql/sql/functional/fdml.lisp

Source

clsql.asd.

Parent Component

functional (module).

Public Interface
Internals

4.1.20 clsql/sql/functional/transaction.lisp

Dependency

fdml.lisp (file).

Source

clsql.asd.

Parent Component

functional (module).

Public Interface
Internals

4.1.21 clsql/sql/functional/loop-extension.lisp

Dependency

fdml.lisp (file).

Source

clsql.asd.

Parent Component

functional (module).

Packages

ansi-loop.

Internals

4.1.22 clsql/sql/functional/fddl.lisp

Dependency

fdml.lisp (file).

Source

clsql.asd.

Parent Component

functional (module).

Public Interface
Internals

%table-exists-p (method).


4.1.23 clsql/sql/object/metaclasses.lisp

Source

clsql.asd.

Parent Component

object (module).

Public Interface
Internals

4.1.24 clsql/sql/object/ooddl.lisp

Dependency

metaclasses.lisp (file).

Source

clsql.asd.

Parent Component

object (module).

Public Interface
Internals

4.1.25 clsql/sql/object/oodml.lisp

Dependency

ooddl.lisp (file).

Source

clsql.asd.

Parent Component

object (module).

Public Interface
Internals

4.1.26 clsql/sql/generic/generic-postgresql.lisp

Source

clsql.asd.

Parent Component

generic (module).

Public Interface
Internals

4.1.27 clsql/sql/generic/generic-odbc.lisp

Source

clsql.asd.

Parent Component

generic (module).

Public Interface
Internals

4.1.28 clsql/sql/generic/sequences.lisp

Source

clsql.asd.

Parent Component

generic (module).

Public Interface
Internals

4.1.29 clsql/sql/generic/command-object.lisp

Source

clsql.asd.

Parent Component

generic (module).

Public Interface

5 Packages

Packages are listed by definition order.


5.1 cmucl-compat

Source

cmucl-compat.lisp.

Use List

common-lisp.

Public Interface

5.2 ansi-loop

Source

loop-extension.lisp.

Internals

loop-gentemp (function).


5.3 clsql-sys

This is the INTERNAL SQL-Interface package of CLSQL.

Source

package.lisp.

Use List
  • common-lisp.
  • sb-mop.
Public Interface
Internals

5.4 clsql-user

This is the user package with CLSQL symbols.

Source

package.lisp.

Use List

common-lisp.


5.5 decimals

Source

decimals.lisp.

Use List

common-lisp.

Public Interface
Internals

5.6 clsql

This is the user package with CLSQL symbols.

Source

package.lisp.

Use List

common-lisp.


5.7 clsql-system

Source

clsql.asd.

Use List
  • asdf/interface.
  • common-lisp.

6 Definitions

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


6.1 Public Interface


6.1.1 Special variables

Special Variable: *backend-warning-behavior*

Action to perform on warning messages from backend. Default is to :warn. May also be set to :error to signal an error
or :ignore/nil to silently ignore the warning.

Package

clsql-sys.

Source

conditions.lisp.

Special Variable: *cache-table-queries-default*

Specifies the default behaivour for caching of attribute types. Meaningful values are t, nil and :flush as described for the action argument to CACHE-TABLE-QUERIES.

Package

clsql-sys.

Source

fddl.lisp.

Special Variable: *connect-if-exists*

Default value for the if-exists keyword argument in calls to CONNECT. Meaningful values are :new, :warn-new, :error, :warn-old and :old.

Package

clsql-sys.

Source

database.lisp.

Special Variable: *db-auto-sync*

A non-nil value means that creating View Class instances or setting their slots automatically creates/updates the corresponding records in the underlying database.

Package

clsql-sys.

Source

ooddl.lisp.

Special Variable: *db-pool-max-free-connections*

Threshold of free-connections in the pool before we disconnect a database rather than returning it to the pool. NIL for no limit. This is really a heuristic that should, on avg keep the free connections about this size.

Package

clsql-sys.

Source

pool.lisp.

Special Variable: *default-caching*

Controls whether SELECT caches objects by default. The CommonSQL specification states caching is on by default.

Package

clsql-sys.

Source

oodml.lisp.

Special Variable: *default-database*

Specifies the default database to be used.

Package

clsql-sys.

Source

database.lisp.

Special Variable: *default-database-type*

Designates the default database type which is initialised by the function INITIALISE-DATABASE-TYPE.

Package

clsql-sys.

Source

initialize.lisp.

Special Variable: *default-string-length*

The length of a string which does not have a user-specified length.

Package

clsql-sys.

Source

ooddl.lisp.

Special Variable: *default-update-objects-max-len*

The default value to use for the MAX-LEN keyword argument to UPDATE-OBJECT-JOINS.

Package

clsql-sys.

Source

oodml.lisp.

Special Variable: *foreign-library-search-paths*

A list of pathnames denoting directories where CLSQL will look for foreign libraries (in addition to the default places).

Package

clsql-sys.

Source

db-interface.lisp.

Special Variable: *initialized-database-types*

A list of database types which have currently been initialised by calling INITIALIZE-DATABASE-TYPE.

Package

clsql-sys.

Source

initialize.lisp.

Special Variable: *loaded-database-types*

Contains a list of database types which have been defined/loaded.

Package

clsql-sys.

Source

initialize.lisp.

Special Variable: *old-sequence-names*

Should CLSQL use its old sequence naming scheme _CLSQL_SEQ_{table} instead of the current scheme {table}_CLSQL_SEQ

Package

clsql-sys.

Source

sequences.lisp.


6.1.2 Macros

Macro: check-connection-spec (connection-spec database-type template)

Check the connection specification against the provided template, and signal an sql-user-error if they don’t match. This function is called by database backends.

Package

clsql-sys.

Source

database.lisp.

Macro: def-view-class (class supers slots &rest cl-options)

Creates a View Class called CLASS whose slots SLOTS can map onto the attributes of a table in a database. If SUPERS is nil then the superclass of CLASS will be STANDARD-DB-OBJECT, otherwise SUPERS is a list of superclasses for CLASS which must include STANDARD-DB-OBJECT or a descendent of this class. The syntax of DEFCLASS is extended through the addition of a class option :base-table which defines the database table onto which the View Class maps and which defaults to CLASS. The DEFCLASS syntax is also extended through additional slot
options. The :db-kind slot option specifies the kind of DB mapping which is performed for this slot and defaults to :base which indicates that the slot maps to an ordinary column of the database table. A :db-kind value of :key indicates that this slot is a special kind of :base slot which maps onto a column which is one of the unique keys for the database table, the value :join indicates this slot represents a join onto another View Class which contains View Class objects, and the value :virtual indicates a standard CLOS slot which does not map onto columns of the database table. If a slot is specified with :db-kind :join, the slot option :db-info contains a list which specifies the nature of the join. For slots of :db-kind :base or :key,
the :type slot option has a special interpretation such that Lisp types, such as string, integer and float are automatically converted into appropriate SQL types for the column onto which the slot maps. This behaviour may be over-ridden using
the :db-type slot option which is a string specifying the vendor-specific database type for this slot’s column definition in the database. The :column slot option specifies the name of the SQL column which the slot maps onto, if :db-kind is
not :virtual, and defaults to the slot name. The :void-value slot option specifies the value to store if the SQL value is NULL and defaults to NIL. The :db-constraints slot option is a string representing an SQL table constraint expression or a list of such strings.

Package

clsql-sys.

Source

ooddl.lisp.

Macro: define-decimal-formatter (name &body keyword-arguments)

Define a decimal number formatter function to use with the ‘~/‘
directive of ‘cl:format‘. The valid format is this:

(define-decimal-formatter name
(:keyword form)
...)

_Name_ is the symbol that names the function. _Keyword_ must be a valid keyword argument for the ‘format-decimal-number‘ function (see its documentation for more information). _Form_ is evaluated and the value
is used with the _keyword_ argument. Macro’s side effect is that global function _name_ is defined. It can be used with the ‘~/‘ directive of ‘cl:format‘ function.

Examples:

(define-decimal-formatter my-formatter
(:round-magnitude -6)
(:decimal-separator ",")
(:integer-group-separator " ")
(:integer-minimum-width 4)
(:fractional-group-separator " ")
(:fractional-minimum-width 10)
(:show-trailing-zeros t))
=> MY-FORMATTER

(format nil "~/my-formatter/" 10/6)
=> " 1,666 667 "

(format nil "~/my-formatter/" 100/8)
=> " 12,500 000 "

The ‘~/‘ directive function call can optionally take up to three arguments to override the defaults:

~round-magnitude,integer-minimum-width,fractional-minimum-width/FUNCTION/

For example:

(format nil "~-2,3,4/my-formatter/" 10/6)
=> " 1,67 "

Package

decimals.

Source

decimals.lisp.

Macro: disable-sql-reader-syntax ()

Turns off the SQL reader syntax setting the syntax state such that if the syntax is subsequently enabled, RESTORE-SQL-READER-SYNTAX-STATE will disable it again.

Package

clsql-sys.

Source

syntax.lisp.

Macro: do-query (((&rest args) query-expression &key database result-types) &body body)

Repeatedly executes BODY within a binding of ARGS on the fields of each row selected by the SQL query QUERY-EXPRESSION, which may be a string or a symbolic SQL expression, in DATABASE which defaults to *DEFAULT-DATABASE*. The values returned by the execution of BODY are returned. RESULT-TYPES is a list of symbols which specifies the lisp type for each field returned by QUERY-EXPRESSION. If RESULT-TYPES is nil all results are returned as strings whereas the default value of :auto means that the lisp types are automatically computed for each field.

Package

clsql-sys.

Source

fdml.lisp.

Macro: enable-sql-reader-syntax ()

Turns on the SQL reader syntax setting the syntax state such that if the syntax is subsequently disabled, RESTORE-SQL-READER-SYNTAX-STATE will enable it again.

Package

clsql-sys.

Source

syntax.lisp.

Macro: file-enable-sql-reader-syntax ()

Turns on the SQL reader syntax for the rest of the file. The CL spec says that when finished loading a file the original *readtable* is restored. clhs COMPILE-FILE

Package

clsql-sys.

Source

syntax.lisp.

Macro: in (obj &rest choices)
Package

clsql-sys.

Source

utils.lisp.

Macro: locally-disable-sql-reader-syntax ()

Turns off the SQL reader syntax without changing the syntax state such that RESTORE-SQL-READER-SYNTAX-STATE will re-establish the current syntax state.

Package

clsql-sys.

Source

syntax.lisp.

Macro: locally-enable-sql-reader-syntax ()

Turns on the SQL reader syntax without changing the syntax state such that RESTORE-SQL-READER-SYNTAX-STATE will re-establish the current syntax state.

Package

clsql-sys.

Source

syntax.lisp.

Macro: restore-sql-reader-syntax-state ()

Enables the SQL reader syntax if ENABLE-SQL-READER-SYNTAX has been called more recently than DISABLE-SQL-READER-SYNTAX and otherwise disables the SQL reader syntax. By default, the SQL reader syntax is disabled.

Package

clsql-sys.

Source

syntax.lisp.

Macro: shrink-vector (vec len)
Package

cmucl-compat.

Source

cmucl-compat.lisp.

Macro: with-database ((db-var connection-spec &key make-default pool if-exists database-type encoding) &body body)

Evaluate the body in an environment, where DB-VAR is bound to the database connection given by CONNECTION-SPEC and CONNECT-ARGS. The connection is automatically closed or released to the pool on exit from the body. MAKE-DEFAULT has a default value of NIL.

Package

clsql-sys.

Source

database.lisp.

Macro: with-default-database ((database) &rest body)

Perform BODY with DATABASE bound as *default-database*.

Package

clsql-sys.

Source

database.lisp.

Macro: with-process-lock ((lock desc) &body body)
Package

clsql-sys.

Source

utils.lisp.

Macro: with-transaction ((&key database) &body body)

Starts a transaction in the database specified by DATABASE, which is *DEFAULT-DATABASE* by default, and executes BODY within that transaction. If BODY aborts or throws, DATABASE is rolled back and otherwise the transaction is committed.

Package

clsql-sys.

Source

transaction.lisp.

Macro: without-interrupts (&body body)
Package

clsql-sys.

Source

utils.lisp.


6.1.3 Ordinary functions

Function: add-sql-stream (stream &key type database)

Adds the supplied stream STREAM (or T for *standard-output*) as a component of the recording broadcast stream for the SQL recording type specified by TYPE on DATABASE which defaults to *DEFAULT-DATABASE*. TYPE must be one of :commands, :results, or :both, defaulting to :commands, depending on whether the stream is to be added for recording SQL commands, results or both.

Package

clsql-sys.

Source

recording.lisp.

Function: add-transaction-commit-hook (commit-hook &key database)

Adds COMMIT-HOOK, which should a designator for a function with no required arguments, to the list of hooks run when COMMIT is called on DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

transaction.lisp.

Function: add-transaction-rollback-hook (rollback-hook &key database)

Adds ROLLBACK-HOOK, which should a designator for a function with no required arguments, to the list of hooks run when ROLLBACK is called on DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

transaction.lisp.

Function: attribute-type (attribute table &key owner database)

Returns a keyword representing the vendor-specific field type of the supplied attribute ATTRIBUTE in the table specified by TABLE in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that the attribute specified by ATTRIBUTE, if it exists, must be user owned else nil is returned. If OWNER is a string denoting a user name, the attribute, if it exists, must be owned by OWNER else nil is returned, whereas if OWNER is :all then the attribute, if it exists, will be returned regardless of its owner.

Package

clsql-sys.

Source

fddl.lisp.

Function: bind-parameter (prepared-stmt position value)

Sets the value of a parameter is in prepared statement.

Package

clsql-sys.

Source

fdml.lisp.

Function: cache-table-queries (table &key action database)

Controls the caching of attribute type information on the table specified by TABLE in DATABASE which defaults to *DEFAULT-DATABASE*. ACTION specifies the caching behaviour to adopt. If its value is t then attribute type information is cached whereas if its value is nil then attribute type information is not cached. If ACTION is :flush then all existing type information in the cache for TABLE is removed, but caching is still enabled. TABLE may be a string representing a table for which the caching action is to be taken while the caching action is applied to all tables if TABLE is t. Alternativly, when TABLE is :default, the default caching action specified by *CACHE-TABLE-QUERIES-DEFAULT* is applied to all table for which a caching action has not been explicitly set.

Package

clsql-sys.

Source

fddl.lisp.

Function: command-object (expression &optional parameters prepared-name)
Package

clsql-sys.

Source

command-object.lisp.

Function: command-output (control-string &rest args)
Package

clsql-sys.

Source

utils.lisp.

Function: commit (&key database)

If DATABASE, which defaults to *DEFAULT-DATABASE*, is currently within the scope of a transaction, commits changes made since the transaction began.

Package

clsql-sys.

Source

transaction.lisp.

Function: connect (connection-spec &key if-exists make-default pool database-type encoding)

Connects to a database of the supplied DATABASE-TYPE which defaults to *DEFAULT-DATABASE-TYPE*, using the type-specific connection specification CONNECTION-SPEC. The value of IF-EXISTS, which defaults to *CONNECT-IF-EXISTS*, determines what happens if a connection to the database specified by CONNECTION-SPEC is already established. A value of :new means create a new connection. A value of :warn-new means warn the user and create a new connect. A value of :warn-old means warn the user and use the old connection. A value of :error means fail, notifying the user. A value of :old means return the old connection. MAKE-DEFAULT is t by default which means that *DEFAULT-DATABASE* is set to the new connection, otherwise *DEFAULT-DATABASE* is not changed. If POOL is t the connection will be taken from the general pool, if POOL is a CONN-POOL object the connection will be taken from this pool.

Package

clsql-sys.

Source

database.lisp.

Function: connected-databases ()

Returns the list of active database objects.

Package

clsql-sys.

Source

database.lisp.

Function: convert-to-db-default-case (str database)
Package

clsql-sys.

Source

utils.lisp.

Function: create-database (connection-spec &key database-type)

This function creates a database in the database system specified by DATABASE-TYPE.

Package

clsql-sys.

Source

database.lisp.

Function: create-index (name &key on unique attributes database)

Creates an index called NAME on the table specified by ON in DATABASE which default to *DEFAULT-DATABASE*. The table attributes to use in constructing the index NAME are specified by ATTRIBUTES. The UNIQUE argument is nil by default but if it has a non-nil value then the indexed attributes must have unique values.

Package

clsql-sys.

Source

fddl.lisp.

Function: create-large-object (&key database)

Creates a new large object in the database and returns the object identifier

Package

clsql-sys.

Source

fdml.lisp.

Function: create-sequence (name &key database)

Creates a sequence called NAME in DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

fddl.lisp.

Function: create-table (name description &key database constraints transactions)

Creates a table called NAME, which may be a string, symbol or SQL table identifier, in DATABASE which defaults to *DEFAULT-DATABASE*. DESCRIPTION is a list whose elements are lists containing the attribute names, types, and other constraints such as not-null or primary-key for each column in the table. CONSTRAINTS is a string representing an SQL table constraint expression or a list of such strings. With MySQL databases, if TRANSACTIONS is t an InnoDB table is created which supports transactions.

Package

clsql-sys.

Source

fddl.lisp.

Function: create-view (name &key as column-list with-check-option database)

Creates a view called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. The view is created using the query AS and the columns of the view may be specified using the COLUMN-LIST parameter. The WITH-CHECK-OPTION is nil by default but if it has a non-nil value, then all insert/update commands on the view are checked to ensure that the new data satisfy the query AS.

Package

clsql-sys.

Source

fddl.lisp.

Function: create-view-from-class (view-class-name &key database transactions)

Creates a table as defined by the View Class VIEW-CLASS-NAME in DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

ooddl.lisp.

Function: current-day ()
Package

clsql-sys.

Source

time.lisp.

Function: current-month ()
Package

clsql-sys.

Source

time.lisp.

Function: current-year ()
Package

clsql-sys.

Source

time.lisp.

Function: date+ (date &rest durations)

Add each DURATION to DATE, returning a new date value.
Note that (barring daylight saving time) 12h + 12h will result in a new day, but doing
it as separate calculations will not, as the time is chopped to a date before being returned.

Package

clsql-sys.

Source

time.lisp.

Function: date- (date &rest durations)

Subtract each DURATION to DATE, returning a new date value.
Note that (barring daylight saving time) 12h + 12h will result in a new day, but doing
it as separate calculations will not, as the time is chopped to a date before being returned.

Package

clsql-sys.

Source

time.lisp.

Function: date-compare (date-a date-b)
Package

clsql-sys.

Source

time.lisp.

Function: date-difference (date1 date2)

Returns a DURATION representing the difference between TIME1 and TIME2.

Package

clsql-sys.

Source

time.lisp.

Function: date-dow (date)
Package

clsql-sys.

Source

time.lisp.

Function: date-element (date element)
Package

clsql-sys.

Source

time.lisp.

Function: date-max (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: date-min (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Reader: date-mjd (instance)
Writer: (setf date-mjd) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

mjd.

Function: date-p (object)
Package

clsql-sys.

Source

time.lisp.

Function: date-ymd (date)
Package

clsql-sys.

Source

time.lisp.

Function: date< (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: date<= (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: date= (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: date> (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: date>= (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: db-datestring (date)
Package

clsql-sys.

Source

time.lisp.

Function: db-timestring (time &key stream)

return the string to store the given time in the database

Package

clsql-sys.

Source

time.lisp.

Function: decode-date (date)

returns the decoded date as multiple values: day month year integer day-of-week

Package

clsql-sys.

Source

time.lisp.

Function: decode-time (time)

returns the decoded time as multiple values: usec, second, minute, hour, day, month, year, integer day-of-week

Package

clsql-sys.

Source

time.lisp.

Function: delete-large-object (object-id &key database)

Deletes the large object in the database

Package

clsql-sys.

Source

fdml.lisp.

Function: delete-records (&key from where database)

Deletes records satisfying the SQL expression WHERE from the table specified by FROM in DATABASE specifies a database which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

fdml.lisp.

Function: delete-sql-stream (stream &key type database)

Removes the supplied stream STREAM from the recording broadcast stream for the SQL recording type specified by TYPE on DATABASE which defaults to *DEFAULT-DATABASE*. TYPE must be one
of :commands, :results, or :both, defaulting to :commands, depending on whether the stream is to be added for recording SQL commands, results or both.

Package

clsql-sys.

Source

recording.lisp.

Function: destroy-database (connection-spec &key database-type)

This function destroys a database in the database system specified by DATABASE-TYPE.

Package

clsql-sys.

Source

database.lisp.

Function: disconnect (&key database error)

Closes the connection to DATABASE and resets *DEFAULT-DATABASE* if that database was disconnected. If DATABASE is a database instance, this object is closed. If DATABASE is a string, then a connected database whose name matches DATABASE is sought in the list of connected databases. If no matching database is found and ERROR and DATABASE are both non-nil an error is signaled, otherwise nil is returned. If the database is from a pool it will be released to this pool.

Package

clsql-sys.

Source

database.lisp.

Function: disconnect-pooled (&optional clear)

Disconnects all connections in the pool. When clear, also deletes the pool objects.

Package

clsql-sys.

Source

pool.lisp.

Function: drop-index (name &key if-does-not-exist on database)

Drops the index called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. If the index does not exist and IF-DOES-NOT-EXIST is :ignore then DROP-INDEX returns nil whereas an error is signalled if IF-DOES-NOT-EXIST is :error. The argument ON allows the optional specification of a table to drop the index from.

Package

clsql-sys.

Source

fddl.lisp.

Function: drop-sequence (name &key if-does-not-exist database)

Drops the sequence called NAME from DATABASE which defaults to *DEFAULT-DATABASE*. If the sequence does not exist and IF-DOES-NOT-EXIST is :ignore then DROP-SEQUENCE returns nil whereas an error is signalled if IF-DOES-NOT-EXIST is :error.

Package

clsql-sys.

Source

fddl.lisp.

Function: drop-table (name &key if-does-not-exist database owner)

Drops the table called NAME from DATABASE which defaults to *DEFAULT-DATABASE*. If the table does not exist and IF-DOES-NOT-EXIST is :ignore then DROP-TABLE returns nil whereas an error is signalled if IF-DOES-NOT-EXIST is :error.

Package

clsql-sys.

Source

fddl.lisp.

Function: drop-view (name &key if-does-not-exist database)

Drops the view called NAME from DATABASE which defaults to *DEFAULT-DATABASE*. If the view does not exist and IF-DOES-NOT-EXIST is :ignore then DROP-VIEW returns nil whereas an error is signalled if IF-DOES-NOT-EXIST is :error.

Package

clsql-sys.

Source

fddl.lisp.

Function: drop-view-from-class (view-class-name &key database owner)

Removes a table defined by the View Class VIEW-CLASS-NAME from DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

ooddl.lisp.

Function: duration+ (time &rest durations)

Add each DURATION to TIME, returning a new wall-time value.

Package

clsql-sys.

Source

time.lisp.

Reader: duration-day (instance)
Writer: (setf duration-day) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

day.

Reader: duration-hour (instance)
Writer: (setf duration-hour) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

hour.

Reader: duration-minute (instance)
Writer: (setf duration-minute) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

minute.

Reader: duration-month (instance)
Writer: (setf duration-month) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

month.

Function: duration-reduce (duration precision &optional round)
Package

clsql-sys.

Source

time.lisp.

Reader: duration-second (instance)
Writer: (setf duration-second) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

second.

Function: duration-timestring (duration)
Package

clsql-sys.

Source

time.lisp.

Reader: duration-year (instance)
Writer: (setf duration-year) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

year.

Function: duration< (duration-a duration-b)
Package

clsql-sys.

Source

time.lisp.

Function: duration<= (duration-a duration-b)
Package

clsql-sys.

Source

time.lisp.

Function: duration= (duration-a duration-b)
Package

clsql-sys.

Source

time.lisp.

Function: duration> (x y)
Package

clsql-sys.

Source

time.lisp.

Function: duration>= (x y)
Package

clsql-sys.

Source

time.lisp.

Function: encoding (db)
Package

clsql-sys.

Source

database.lisp.

Function: (setf encoding) (db)
Package

clsql-sys.

Source

database.lisp.

Function: ensure-keyword (name)

Returns keyword for a name.

Package

clsql-sys.

Source

utils.lisp.

Function: extract-roman (string)
Package

clsql-sys.

Source

time.lisp.

Function: find-database (database &key errorp db-type)

Returns the connected databases of type DB-TYPE whose names match the string DATABASE. If DATABASE is a database object, it is returned. If DB-TYPE is nil all databases matching the string DATABASE are considered. If no matching databases are found and ERRORP is nil then nil is returned. If ERRORP is nil and one or more matching databases are found, then the most recently connected database is returned as a first value and the number of matching databases is returned as a second value. If no, or more than one, matching databases are found and ERRORP is true, an error is signalled.

Package

clsql-sys.

Source

database.lisp.

Function: float-to-sql-string (num)

Convert exponent character for SQL

Package

clsql-sys.

Source

utils.lisp.

Function: format-date (stream date &key format date-separator internal-separator)

produces on stream the datestring corresponding to the date with the given options

Package

clsql-sys.

Source

time.lisp.

Function: format-decimal-number (number &key round-magnitude rounder decimal-separator integer-group-separator integer-group-digits integer-minimum-width integer-pad-char fractional-group-separator fractional-group-digits fractional-minimum-width fractional-pad-char show-trailing-zeros positive-sign negative-sign zero-sign)

Apply specified decimal number formatting rules to _number_ and return a formatted string.

The second return value is (almost) the same formatted string divided into four strings. It’s a list of four strings: sign, integer part, decimal separator and fractional part. Formatting arguments _integer-minimum-width_ and _fractional-minimum-width_ do not apply to the second return value. Everything else does.

_Number_ must be of type ‘real‘. This function uses ‘rational‘ types internally. If the given _number_ is a ‘float‘ it is first turned into ‘rational‘ by calling ‘cl:rational‘.

Formatting rules are specified with keyword arguments, as described below. The default value is in parentheses.

* ‘round-magnitude (0)‘

This is the order of magnitude used for rounding. The value must be an integer and it is interpreted as a power of 10.

* ‘show-trailing-zeros (nil)‘

If the value is non-nil print all trailing zeros in fractional part. Examples:

(format-decimal-number 1/5 :round-magnitude -3 :show-trailing-zeros nil)
=> "0.2"

(format-decimal-number 1/5 :round-magnitude -3 :show-trailing-zeros t)
=> "0.200"

* ‘rounder (#’round-half-away-from-zero)‘

The value must be a function (or a symbol naming a function). It is used to round the number to the specified round magnitude. The function must work like ‘cl:truncate‘, ‘cl:floor‘, ‘cl:ceiling‘ and ‘cl:round‘, that is, take two arguments, a number and a divisor, and return the quotient as the first value.

This package introduces another rounding function, ‘round-half-away-from-zero‘, which is used by default. See its documentation for more information.

* ‘decimal-separator (#\.)‘

If the value is non-nil the ‘princ‘ output of the value will be added between integer and fractional parts. Probably the most useful types are ‘character‘ and ‘string‘.

* ‘integer-group-separator (nil)‘
* ‘fractional-group-separator (nil)‘

If the value is non-nil the digits in integer or fractional parts are put in groups. The ‘princ‘ output of the value will be added between digit groups.

* ‘integer-group-digits (3)‘
* ‘fractional-group-digits (3)‘

The value is a positive integer defining the number of digits in groups.

* ‘integer-minimum-width (0)‘
* ‘fractional-minimum-width (0)‘

Format integer or fractional part using minimum of this amount of characters, possibly using some padding characters (see below). _positive-sign_, _negative-sign_ or _zero-sign_ (see below) is included when calculating the width of the integer part. Similarly _decimal-separator_ is included when calculating the width of the fractional part.

* ‘integer-pad-char (#\Space)‘
* ‘fractional-pad-char (#\Space)‘

The value is the padding character which is used to fill _integer-minimum-width_ or _fractional-minimum-width_.

* ‘positive-sign (nil)‘
* ‘negative-sign (#\-)‘
* ‘zero-sign (nil)‘

If values are non-nil these are used as the leading sign for positive, negative and zero numbers. The ‘princ‘ output of the value is used.

Package

decimals.

Source

decimals.lisp.

Function: format-duration (stream duration &key precision)
Package

clsql-sys.

Source

time.lisp.

Function: format-time (stream time &key format date-separator time-separator internal-separator)

produces on stream the timestring corresponding to the wall-time with the given options

Package

clsql-sys.

Source

time.lisp.

Function: free-prepared-sql (prepared-stmt)

Delete the objects associated with a prepared statement.

Package

clsql-sys.

Source

fdml.lisp.

Function: get-date ()

Returns a date for today

Package

clsql-sys.

Source

time.lisp.

Function: get-time ()

Return a pair: (GREGORIAN DAY . TIME-OF-DAY)

Package

clsql-sys.

Source

time.lisp.

Function: getenv (var)

Return the value of the environment variable.

Package

clsql-sys.

Source

utils.lisp.

Function: gregorian-to-mjd (month day year)
Package

clsql-sys.

Source

time.lisp.

Function: in-transaction-p (&key database)

A predicate to test whether DATABASE, which defaults to *DEFAULT-DATABASE*, is currently within the scope of a transaction.

Package

clsql-sys.

Source

transaction.lisp.

Function: index-exists-p (name &key owner database)

Tests for the existence of an SQL index called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only indexes owned by users are examined. If OWNER is a string denoting a user name, only indexes owned by OWNER are examined. If OWNER is :all then all indexes are examined.

Package

clsql-sys.

Source

fddl.lisp.

Function: initialize-database-type (&key database-type)

Initializes the supplied DATABASE-TYPE, if it is not already initialized, as indicated by *INITIALIZED-DATABASE-TYPES* and returns DATABASE-TYPE. *DEFAULT-DATABASE-TYPE* is set to DATABASE-TYPE and, if DATABASE-TYPE has not been initialised, it is added to *INITIALIZED-DATABASE-TYPES*.

Package

clsql-sys.

Source

initialize.lisp.

Function: insert-records (&key into attributes values av-pairs query database)

Inserts records into the table specified by INTO in DATABASE
which defaults to *DEFAULT-DATABASE*. There are five ways of
specifying the values inserted into each row.

In the first VALUES contains a list of values to insert and ATTRIBUTES, AV-PAIRS and QUERY are nil. This can be used when values are supplied for all attributes in INTO.

In the second, ATTRIBUTES is a list of column names, VALUES is a corresponding list of values and AV-PAIRS and QUERY are nil.

In the third, ATTRIBUTES, VALUES and QUERY are nil and AV-PAIRS is a list of (attribute value) pairs, or attribute-value-pair objects.

In the fourth, VALUES, AV-PAIRS and ATTRIBUTES are nil and QUERY is a symbolic SQL query expression in which the selected columns also exist in INTO.

In the fifth method, VALUES and AV-PAIRS are nil and ATTRIBUTES is a list of column names and QUERY is a symbolic SQL query expression which returns values for the specified columns.

Package

clsql-sys.

Source

fdml.lisp.

Function: interval-clear (list time)
Package

clsql-sys.

Source

time.lisp.

Reader: interval-contained (instance)
Writer: (setf interval-contained) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

contained.

Reader: interval-data (instance)
Writer: (setf interval-data) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

data.

Function: interval-edit (list time start end &optional tag)

Attempts to modify the most deeply nested interval in list which begins at time. If no changes are made, returns nil.

Package

clsql-sys.

Source

time.lisp.

Reader: interval-end (instance)
Writer: (setf interval-end) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

end.

Function: interval-match (list time)

Return the index of the first interval in list containing time

Package

clsql-sys.

Source

time.lisp.

Function: interval-push (interval-list interval &optional container-rule)
Package

clsql-sys.

Source

time.lisp.

Function: interval-relation (x y)

Compare the relationship of node x to node y. Returns either :contained :contains :follows :overlaps or :precedes.

Package

clsql-sys.

Source

time.lisp.

Reader: interval-start (instance)
Writer: (setf interval-start) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

start.

Reader: interval-type (instance)
Writer: (setf interval-type) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

type.

Function: is-database-open (database)
Package

clsql-sys.

Source

database.lisp.

Function: iso-timestring (time &key stream)
Package

clsql-sys.

Source

time.lisp.

Function: list-attribute-types (table &key owner database)

Returns a list containing information about the SQL types of each of the attributes in the table specified by TABLE in DATABASE which has a default value of *DEFAULT-DATABASE*. OWNER is nil by default which means that only attributes owned by users are listed. If OWNER is a string denoting a user name, only attributes owned by OWNER are listed. If OWNER is :all then all attributes are listed. The elements of the returned list are lists where the first element is the name of the attribute, the second element is its SQL type, the third is the type precision, the fourth is the scale of the attribute and the fifth is 1 if the attribute accepts null values and otherwise 0.

Package

clsql-sys.

Source

fddl.lisp.

Function: list-attributes (name &key owner database)

Returns a list of strings representing the attributes of table NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only attributes owned by users are listed. If OWNER is a string denoting a user name, only attributes owned by OWNER are listed. If OWNER is :all then all attributes are listed.

Package

clsql-sys.

Source

fddl.lisp.

Function: list-classes (&key test root-class database)

Returns a list of all the View Classes which are connected to DATABASE, which defaults to *DEFAULT-DATABASE*, and which descend from the class ROOT-CLASS and which satisfy the function TEST. By default ROOT-CLASS is STANDARD-DB-OBJECT and TEST is IDENTITY.

Package

clsql-sys.

Source

ooddl.lisp.

Function: list-databases (connection-spec &key database-type)

This function returns a list of databases existing in the database system specified by DATABASE-TYPE.

Package

clsql-sys.

Source

database.lisp.

Function: list-indexes (&key owner database on)

Returns a list of strings representing index names in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only indexes owned by users are listed. If OWNER is a string denoting a user name, only indexes owned by OWNER are listed. If OWNER is :all then all indexes are listed. The keyword argument ON limits the results to indexes on the specified tables. Meaningful values for ON are nil (the default) which means that all tables are considered, a string, symbol or SQL expression representing a table name in DATABASE or a list of such table identifiers.

Package

clsql-sys.

Source

fddl.lisp.

Function: list-sequences (&key owner database)

Returns a list of strings representing sequence names in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only sequences owned by users are listed. If OWNER is a string denoting a user name, only sequences owned by OWNER are listed. If OWNER is :all then all sequences are listed.

Package

clsql-sys.

Source

fddl.lisp.

Function: list-sql-streams (&key type database)

Returns the list of component streams for the broadcast stream recording SQL commands sent to and/or results returned from DATABASE which defaults to *DEFAULT-DATABASE*. TYPE must be one of :commands, :results, or :both, defaulting to :commands, and determines whether the listed streams contain those recording SQL commands, results or both.

Package

clsql-sys.

Source

recording.lisp.

Function: list-tables (&key owner database)

Returns a list of strings representing table names in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only tables owned by users are listed. If OWNER is a string denoting a user name, only tables owned by OWNER are listed. If OWNER is :all then all tables are listed.

Package

clsql-sys.

Source

fddl.lisp.

Function: list-views (&key owner database)

Returns a list of strings representing view names in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only views owned by users are listed. If OWNER is a string denoting a user name, only views owned by OWNER are listed. If OWNER is :all then all views are listed.

Package

clsql-sys.

Source

fddl.lisp.

Function: make-date (&key year month day hour minute second usec offset)
Package

clsql-sys.

Source

time.lisp.

Function: make-duration (&key year month day hour minute second usec)
Package

clsql-sys.

Source

time.lisp.

Function: make-interval (&key start end name contained type data)
Package

clsql-sys.

Source

time.lisp.

Function: make-process-lock (name)
Package

clsql-sys.

Source

utils.lisp.

Function: make-sequence-of-type (type length)

Returns a sequence of the given TYPE and LENGTH.

Package

cmucl-compat.

Source

cmucl-compat.lisp.

Function: make-time (&key year month day hour minute second usec offset)
Package

clsql-sys.

Source

time.lisp.

Function: map-query (output-type-spec function query-expression &key database result-types)

Map the function FUNCTION over the attribute values of each row selected by the SQL query QUERY-EXPRESSION, which may be a string or a symbolic SQL expression, in DATABASE which defaults to *DEFAULT-DATABASE*. The results of the function are collected as specified in OUTPUT-TYPE-SPEC and returned like in
MAP. RESULT-TYPES is a list of symbols which specifies the lisp type for each field returned by QUERY-EXPRESSION. If RESULT-TYPES is nil all results are returned as strings whereas the default value of :auto means that the lisp types are automatically computed for each field.

Package

clsql-sys.

Source

fdml.lisp.

Function: merged-time (day time-of-day)
Package

clsql-sys.

Source

time.lisp.

Function: mjd-to-gregorian (mjd)
Package

clsql-sys.

Source

time.lisp.

Function: month-name (month-index)
Package

clsql-sys.

Source

time.lisp.

Function: number-to-sql-string (num)
Package

clsql-sys.

Source

utils.lisp.

Function: parse-date-time (string)

parses date like 08/08/01, 8.8.2001, eg

Package

clsql-sys.

Source

time.lisp.

Function: parse-datestring (datestring &key start end junk-allowed)

parse a ISO 8601 timestring and return the corresponding date.
Will throw a hissy fit if the date string is a duration. Will ignore any precision beyond day (hour/min/sec/usec).

Package

clsql-sys.

Source

time.lisp.

Function: parse-decimal-number (string &key decimal-separator positive-sign negative-sign start end)

Examine _string_ (or its substring from _start_ to _end_) for a decimal number. Assume that the decimal number is exact and return it as a rational number.

Rules for parsing: First all leading and trailing ‘#\Space‘ characters are stripped. The resulting string may start with a _positive-sign_ or a _negative-sign_ character. The latter causes this function to assume a negative number. The following characters in the string must include one or more digit characters and it may include one _decimal-separator_ character which separates integer and fractional parts. All other characters are illegal. If these rules are not met a ‘decimal-parse-error‘ condition is signaled.

Examples:

(parse-decimal-number "0.2") => 1/5
(parse-decimal-number ".2") => 1/5
(parse-decimal-number "+3.") => 3
(parse-decimal-number " -7 ") => -7

(parse-decimal-number "−12,345"
:decimal-separator #\,
:negative-sign #\−)
=> -2469/200

Package

decimals.

Source

decimals.lisp.

Function: parse-timestring (timestring &key start end junk-allowed)

parse a timestring and return the corresponding wall-time. If the timestring starts with P, read a duration; otherwise read an ISO 8601 formatted date string.

Package

clsql-sys.

Source

time.lisp.

Function: parse-yearstring (string)
Package

clsql-sys.

Source

time.lisp.

Function: prepare-sql (sql-stmt types &key database result-types field-names)

Prepares a SQL statement for execution. TYPES contains a list of types corresponding to the input parameters. Returns a prepared-statement object.

A type can be
:int
:double
:null
(:blob n)
(:string n)

Package

clsql-sys.

Source

fdml.lisp.

Function: print-date (time &optional style)
Package

clsql-sys.

Source

time.lisp.

Function: print-query (query-exp &key titles formats sizes stream database)

Prints a tabular report of the results returned by the SQL query QUERY-EXP, which may be a symbolic SQL expression or a string, in DATABASE which defaults to *DEFAULT-DATABASE*. The report is printed onto STREAM which has a default value of t which means that *STANDARD-OUTPUT* is used. The TITLE argument, which defaults to nil, allows the specification of a list of strings to use as column titles in the tabular output. SIZES accepts a list of column sizes, one for each column selected by QUERY-EXP, to use in formatting the tabular report. The default value of t means that minimum sizes are computed. FORMATS is a list of format strings to be used for printing each column selected by QUERY-EXP. The default value of FORMATS is t meaning that ~A is used to format all columns or ~VA if column sizes are used.

Package

clsql-sys.

Source

fdml.lisp.

Function: probe-database (connection-spec &key database-type)

This function tests for the existence of a database in the database system specified by DATABASE-TYPE.

Package

clsql-sys.

Source

database.lisp.

Function: push-library-path (path)

Adds the pathspec PATH (which should denote a directory) to the list *FOREIGN-LIBRARY-SEARCH-PATHS*.

Package

clsql-sys.

Source

db-interface.lisp.

Function: read-instance-from-stream (stream)
Package

clsql-sys.

Source

oodml.lisp.

Function: read-large-object (object-id &key database)

Reads the large object content

Package

clsql-sys.

Source

fdml.lisp.

Function: reconnect (&key database error force)

Reconnects DATABASE which defaults to *DEFAULT-DATABASE* to the underlying database management system. On success, t is returned and the variable *DEFAULT-DATABASE* is set to the newly reconnected database. If DATABASE is a database instance, this object is closed. If DATABASE is a string, then a connected database whose name matches DATABASE is sought in the list of connected databases. If no matching database is found and ERROR and DATABASE are both non-nil an error is signaled, otherwise nil is returned. When the current database connection cannot be closed, if FORCE is non-nil, as it is by default, the connection is closed and errors are suppressed. If force is nil and the database connection cannot be closed, an error is signalled.

Package

clsql-sys.

Source

database.lisp.

Function: reload-database-types ()

Reloads any foreign code for the loaded database types after a dump.

Package

clsql-sys.

Source

initialize.lisp.

Function: required-argument ()
Package

cmucl-compat.

Source

cmucl-compat.lisp.

Function: reset-command-object (co)

Resets the command object to have no name and to be unprepared
(This is useful if you want to run a command against a second database)

Package

clsql-sys.

Source

command-object.lisp.

Function: result-type-or-lose (type nil-ok)
Package

cmucl-compat.

Source

cmucl-compat.lisp.

Function: roll (date &key year month day second hour minute usec destructive)
Package

clsql-sys.

Source

time.lisp.

Function: roll-to (date size position)
Package

clsql-sys.

Source

time.lisp.

Function: rollback (&key database)

If DATABASE, which defaults to *DEFAULT-DATABASE*, is currently within the scope of a transaction, rolls back changes made since the transaction began.

Package

clsql-sys.

Source

transaction.lisp.

Function: round-half-away-from-zero (number &optional divisor)

Divide _number_ by _divisor_ and round the result to the nearest integer. If the result is half-way between two integers round away from zero. Two values are returned: quotient and remainder.

This is similar to ‘cl:round‘ function except that ‘cl:round‘ rounds to an even integer when number is exactly between two integers. Examples:

(round-half-away-from-zero 3/2) => 2, -1/2
(round 3/2) => 2, -1/2

(round-half-away-from-zero 5/2) => 3, -1/2
(round 5/2) => 2, 1/2

Package

decimals.

Source

decimals.lisp.

Function: run-prepared-sql (prepared-stmt)

Execute the prepared sql statment. All input parameters must be bound.

Package

clsql-sys.

Source

fdml.lisp.

Function: select (&rest select-all-args)

Executes a query on DATABASE, which has a default value of *DEFAULT-DATABASE*, specified by the SQL expressions supplied using the remaining arguments in SELECT-ALL-ARGS. The SELECT argument can be used to generate queries in both functional and object oriented contexts.

In the functional case, the required arguments specify the columns selected by the query and may be symbolic SQL expressions or strings representing attribute identifiers. Type modified identifiers indicate that the values selected from the specified column are converted to the specified lisp type. The keyword arguments ALL, DISTINCT, FROM, GROUP-by, HAVING, ORDER-BY, SET-OPERATION and WHERE are used to specify, using the symbolic SQL syntax, the corresponding components of the SQL query generated by the call to SELECT. RESULT-TYPES is a list of symbols which specifies the lisp type for each field returned by the query. If RESULT-TYPES is nil all results are returned as strings whereas the default value of :auto means that the lisp types are automatically computed for each field. FIELD-NAMES is t by default which means that the second value returned is a list of strings representing the columns selected by the query. If FIELD-NAMES is nil, the list of column names is not returned as a second value.

In the object oriented case, the required arguments to SELECT are symbols denoting View Classes which specify the database tables to query. In this case, SELECT returns a list of View Class instances whose slots are set from the attribute values of the records in the specified table. Slot-value is a legal operator which can be employed as part of the symbolic SQL syntax used in the WHERE keyword argument to SELECT. REFRESH is nil by default which means that the View Class instances returned are retrieved from a cache if an equivalent call to SELECT has previously been issued. If REFRESH is true, the View Class instances returned are updated as necessary from the database and the generic function INSTANCE-REFRESHED is called to perform any necessary operations on the updated instances.

In both object oriented and functional contexts, FLATP has a default value of nil which means that the results are returned as a list of lists. If FLATP is t and only one result is returned for each record selected in the query, the results are returned as elements of a list.

Package

clsql-sys.

Source

oodml.lisp.

Function: sequence-exists-p (name &key owner database)

Tests for the existence of an SQL sequence called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only sequences owned by users are examined. If OWNER is a string denoting a user name, only sequences owned by OWNER are examined. If OWNER is :all then all sequences are examined.

Package

clsql-sys.

Source

fddl.lisp.

Function: sequence-last (name &key database)

Return the last value allocated in the sequence called NAME in DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

fddl.lisp.

Function: sequence-next (name &key database)

Increment and return the next value in the sequence called NAME in DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

fddl.lisp.

Function: set-autocommit (value &key database)

Turns autocommit off for DATABASE if VALUE is NIL, and otherwise turns it on. Returns the old value of autocommit flag. For RDBMS (such as Oracle) which don’t automatically commit changes, turning autocommit on has the effect of explicitly committing changes made whenever SQL statements are executed. Autocommit is turned on by default.

Package

clsql-sys.

Source

transaction.lisp.

Function: set-sequence-position (name position &key database)

Explicitly set the the position of the sequence called NAME in DATABASE, which defaults to *DEFAULT-DATABASE*, to POSITION which is returned.

Package

clsql-sys.

Source

fddl.lisp.

Function: sql (&rest args)

Returns an SQL string generated from the expressions ARGS. The expressions are translated into SQL strings and then concatenated with a single space delimiting each expression. An error of type SQL-USER-ERROR is signalled if any element in ARGS is not of the supported types (a symbol, string, number or symbolic SQL expression) or a list or vector containing only these supported types.

Package

clsql-sys.

Source

syntax.lisp.

Function: sql-* (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-+ (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-- (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-/ (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-< (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-<= (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-<> (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-= (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-== (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-> (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql->= (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-all (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-and (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-any (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-avg (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-between (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-coalesce (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-concat (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-concat-op (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-count (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-distinct (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-escape (identifier)

Change hyphens to underscores, ensure string

Package

clsql-sys.

Source

utils.lisp.

Function: sql-escape-quotes (s)

Escape quotes for SQL string writing

Package

clsql-sys.

Source

utils.lisp.

Function: sql-except (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-exists (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-expression (&key string table alias attribute type)

Returns an SQL expression constructed from the supplied arguments which may be combined as follows: ATTRIBUTE and TYPE; ATTRIBUTE; ALIAS or TABLE and ATTRIBUTE and TYPE; ALIAS or TABLE and ATTRIBUTE; TABLE, ATTRIBUTE and TYPE; TABLE and ATTRIBUTE; TABLE and ALIAS; TABLE; and STRING. An error of type SQL-USER-ERROR is signalled if an unsupported combination of keyword arguments is specified.

Package

clsql-sys.

Source

syntax.lisp.

Function: sql-function (&rest args)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-group-by (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-having (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-in (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-intersect (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-is (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-like (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-limit (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-max (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-min (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-minus (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-not (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-not-null (&optional not-null-thing)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-null (&optional not-null-thing)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-nvl (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-operation (operator &rest args)

Returns an SQL expression constructed from the supplied symbol OPERATOR representing an SQL operator or function and its arguments ARGS. An error of type SQL-USER-ERROR is signalled if OPERATOR is not a symbol representing a supported SQL operator. If OPERATOR is passed the symbol FUNCTION then the first value in ARGS must be a string representing a valid SQL function and the remaining values in ARGS its arguments as strings.

Package

clsql-sys.

Source

syntax.lisp.

Function: sql-operator (operator)

Returns the Lisp symbol corresponding to the SQL operator represented by the symbol OPERATOR. If OPERATOR does not represent a supported SQL operator or is not a symbol, nil is returned.

Package

clsql-sys.

Source

syntax.lisp.

Function: sql-or (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-order-by (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-query (&rest args)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-recording-p (&key type database)

Predicate to test whether the SQL recording specified by TYPE
is currently enabled for DATABASE which defaults to *DEFAULT-DATABASE*. TYPE may be one of :commands, :results, :both or :either, defaulting to :commands, otherwise nil is returned.

Package

clsql-sys.

Source

recording.lisp.

Function: sql-slot-value (classname slot &optional value database)
Package

clsql-sys.

Source

oodml.lisp.

Function: sql-some (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-stream (&key type database)

Returns the broadcast stream used for recording SQL commands sent to or results returned from DATABASE which defaults to *DEFAULT-DATABASE*. TYPE must be one of :commands or :results, defaulting to :commands, and determines whether the stream returned is that used for recording SQL commands or results.

Package

clsql-sys.

Source

recording.lisp.

Function: sql-substr (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-substring (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-sum (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-the (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-union (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-uplike (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-userenv (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-view-class (classname &optional database)
Package

clsql-sys.

Source

oodml.lisp.

Function: start-sql-recording (&key type database)

Starts recording of SQL commands sent to and/or results returned from DATABASE which defaults to *DEFAULT-DATABASE*. The SQL is output on one or more broadcast streams, initially just *STANDARD-OUTPUT*, and the functions ADD-SQL-STREAM and DELETE-SQL-STREAM may be used to add or delete command or result recording streams. The default value of TYPE is :commands which means that SQL commands sent to DATABASE are recorded. If TYPE is :results then SQL results returned from DATABASE are recorded. Both commands and results may be recorded by passing TYPE value of :both.

Package

clsql-sys.

Source

recording.lisp.

Function: start-transaction (&key database)

Starts a transaction block on DATABASE which defaults to *DEFAULT-DATABASE* and which continues until ROLLBACK or COMMIT are called.

Package

clsql-sys.

Source

transaction.lisp.

Function: status (&optional full)

Prints information about the currently connected databases to *STANDARD-OUTPUT*. The argument FULL is nil by default and a value of t means that more detailed information about each database is printed.

Package

clsql-sys.

Source

database.lisp.

Function: stop-sql-recording (&key type database)

Stops recording of SQL commands sent to and/or results returned from DATABASE which defaults to *DEFAULT-DATABASE*. The default value of TYPE is :commands which means that SQL commands sent to DATABASE will no longer be recorded. If TYPE is :results then SQL results returned from DATABASE will no longer be recorded. Recording may be stopped for both commands and results by passing TYPE value of :both.

Package

clsql-sys.

Source

recording.lisp.

Function: symbol-name-default-case (str)
Package

clsql-sys.

Source

utils.lisp.

Function: table-exists-p (name &key owner database)

Tests for the existence of an SQL table called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only tables owned by users are examined. If OWNER is a string denoting a user name, only tables owned by OWNER are examined. If OWNER is :all then all tables are examined.

Package

clsql-sys.

Source

fddl.lisp.

Function: time+ (time &rest durations)

Add each DURATION to TIME, returning a new wall-time value.

Package

clsql-sys.

Source

time.lisp.

Function: time- (time &rest durations)

Subtract each DURATION from TIME, returning a new wall-time value.

Package

clsql-sys.

Source

time.lisp.

Function: time-compare (time-a time-b)
Package

clsql-sys.

Source

time.lisp.

Function: time-difference (time1 time2)

Returns a DURATION representing the difference between TIME1 and TIME2.

Package

clsql-sys.

Source

time.lisp.

Function: time-dow (time)

Return the 0 indexed Day of the week starting with Sunday

Package

clsql-sys.

Source

time.lisp.

Function: time-element (time element)
Package

clsql-sys.

Source

time.lisp.

Function: time-max (number &rest more-numbers)

Returns the greatest of its arguments.

Package

clsql-sys.

Source

time.lisp.

Function: time-min (number &rest more-numbers)

Returns the least of its arguments.

Package

clsql-sys.

Source

time.lisp.

Reader: time-mjd (instance)
Writer: (setf time-mjd) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

mjd.

Function: time-ymd (time)
Package

clsql-sys.

Source

time.lisp.

Function: time< (number &rest more-numbers)

Returns T if its arguments are in strictly increasing order, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: time<= (number &rest more-numbers)

Returns T if arguments are in strictly non-decreasing order, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: time= (number &rest more-numbers)

Returns T if all of its arguments are numerically equal, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: time> (number &rest more-numbers)

Returns T if its arguments are in strictly decreasing order, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: time>= (number &rest more-numbers)

Returns T if arguments are in strictly non-increasing order, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: truncate-database (&key database)

Drops all tables, views, indexes and sequences in DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

fddl.lisp.

Function: update-objects-joins (objects &key slots force-p class-name max-len)

Updates from the records of the appropriate database tables the join slots specified by SLOTS in the supplied list of View Class instances OBJECTS.

A simpler method of causing a join-slot to be requeried is to set it to unbound, then request it again. This function has efficiency gains where join-objects are shared among the ‘objects‘ (querying all join-objects, then attaching them appropriately to each of the ‘objects‘)

SLOTS can be one of:

* :immediate (DEFAULT) - refresh join slots created with :retrieval :immediate * :deferred - refresh join slots created with :retrieval :deferred
* :all,t - refresh all join slots regardless of :retrieval
* list of symbols - which explicit slots to refresh
* a single symobl - what slot to refresh

CLASS-NAME is used to specify the View Class of all instance in OBJECTS and default to nil which means that the class of the first instance in OBJECTS is used.

FORCE-P is t by default which means that all join slots are updated whereas a value of nil means that only unbound join slots are updated.

MAX-LEN defaults to *DEFAULT-UPDATE-OBJECTS-MAX-LEN* When non-nil this is essentially a batch size for the max number of objects to query from the database at a time. If we need more than max-len we loop till we have all the objects

Package

clsql-sys.

Source

oodml.lisp.

Function: update-records (table &key attributes values av-pairs where database)

Updates the attribute values of existing records satsifying the SQL expression WHERE in the table specified by TABLE in DATABASE which defaults to *DEFAULT-DATABASE*. There are three ways of specifying the values to update for each row. In the first, VALUES contains a list of values to use in the update and ATTRIBUTES and AV-PAIRS are nil. This can be used when values are supplied for all attributes in TABLE. In the second, ATTRIBUTES is a list of column names, VALUES is a corresponding list of values and AV-PAIRS is nil. In the third, ATTRIBUTES and VALUES are nil and AV-PAIRS is an alist of (attribute value) pairs.

Package

clsql-sys.

Source

fdml.lisp.

Function: utime->time (utime)

Return a pair: (GREGORIAN DAY . TIME-OF-DAY)

Package

clsql-sys.

Source

time.lisp.

Function: view-exists-p (name &key owner database)

Tests for the existence of an SQL view called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default which means that only views owned by users are examined. If OWNER is a string denoting a user name, only views owned by OWNER are examined. If OWNER is :all then all views are examined.

Package

clsql-sys.

Source

fddl.lisp.

Function: week-containing (time)
Package

clsql-sys.

Source

time.lisp.

Function: write-instance-to-stream (obj stream)

Writes an instance to a stream where it can be later be read.
NOTE: an error will occur if a slot holds a value which can not be written readably.

Package

clsql-sys.

Source

oodml.lisp.

Function: write-large-object (object-id data &key database)

Writes data to the large object

Package

clsql-sys.

Source

fdml.lisp.


6.1.4 Generic functions

Generic Reader: attribute-cache (object)
Generic Writer: (setf attribute-cache) (object)
Package

clsql-sys.

Methods
Reader Method: attribute-cache ((database database))
Writer Method: (setf attribute-cache) ((database database))

Internal cache of table attributes. It is keyed by table-name. Values
are a list of ACTION specified for table and any cached value of list-attributes-types.

Source

base-classes.lisp.

Target Slot

attribute-cache.

Generic Reader: bad-component (condition)
Package

clsql-sys.

Methods
Reader Method: bad-component ((condition iso-8601-syntax-error))
Source

time.lisp.

Target Slot

bad-component.

Generic Reader: command-recording-stream (object)
Package

clsql-sys.

Methods
Reader Method: command-recording-stream ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

command-recording-stream.

Generic Writer: (setf command-recording-stream) (object)
Package

clsql-sys.

Methods
Writer Method: (setf command-recording-stream) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

command-recording-stream.

Generic Reader: conn-pool (object)
Package

clsql-sys.

Methods
Reader Method: conn-pool ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

conn-pool.

Generic Writer: (setf conn-pool) (object)
Package

clsql-sys.

Methods
Writer Method: (setf conn-pool) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

conn-pool.

Generic Reader: connection-spec (object)
Package

clsql-sys.

Methods
Reader Method: connection-spec ((conn-pool conn-pool))

automatically generated reader method

Source

pool.lisp.

Target Slot

connection-spec.

Reader Method: connection-spec ((database database))

Required to use connection pool.

Source

base-classes.lisp.

Target Slot

connection-spec.

Generic Writer: (setf connection-spec) (object)
Package

clsql-sys.

Methods
Writer Method: (setf connection-spec) ((conn-pool conn-pool))

automatically generated writer method

Source

pool.lisp.

Target Slot

connection-spec.

Generic Reader: database (condition)
Generic Writer: (setf database) (condition)
Package

clsql-sys.

Methods
Reader Method: database ((condition sql-value-conversion-error))
Writer Method: (setf database) ((condition sql-value-conversion-error))
Source

conditions.lisp.

Target Slot

database.

Reader Method: database ((postgresql-stmt postgresql-stmt))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

database.

Generic Function: database-acquire-from-conn-pool (database)

Acquire a database connection from the pool. This
is a chance to test the connection for validity before returning it to the user. If this function returns NIL or throws an error that database connection is considered bad and we make a new one.

Database objects have a chance to specialize, otherwise the default method uses the database-underlying-type and tries to do something appropriate.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-acquire-from-conn-pool (database)
Source

pool.lisp.

Generic Function: database-attribute-type (attribute table database &key owner)

Return the type of ATTRIBUTE in TABLE. Returns multiple values of TYPE_NAME (keyword) PRECISION SCALE NULLABLE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-attribute-type ((attribute %database-identifier) (table %database-identifier) (database generic-odbc-database) &key owner)
Source

generic-odbc.lisp.

Method: database-attribute-type ((attribute %database-identifier) (table %database-identifier) (database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-attribute-type (attribute table (database database) &key owner)
Method: database-attribute-type (attribute table database &key owner)
Generic Reader: database-autocommit (object)
Package

clsql-sys.

Methods
Reader Method: database-autocommit ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

autocommit.

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

clsql-sys.

Methods
Writer Method: (setf database-autocommit) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

autocommit.

Generic Function: database-bind-parameter (prepared-stmt position value)

Bind a parameter for a prepared statement.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-bind-parameter ((stmt postgresql-stmt) position value)
Source

generic-postgresql.lisp.

Method: database-bind-parameter (pstmt position value)
Generic Function: database-connect (connection-spec database-type)

Internal generic implementation of connect.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-create (connection-spec type)

Creates a database, returns T if successfull or signals an error.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-create-large-object (database)

Creates a new large object in the database and returns the object identifier

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-create-sequence (name database)

Create a sequence in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-create-sequence (sequence-name database)
Source

sequences.lisp.

Method: database-create-sequence (sequence-name (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Generic Function: database-delete-large-object (object-id database)

Deletes the large object in the database

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-destroy (connection-spec type)

Destroys (drops) a database, returns T if successfull or signals an error if unable to destory.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-disconnect (database)

Internal generic implementation of disconnect.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-disconnect ((database generic-odbc-database))
Source

generic-odbc.lisp.

Method: database-disconnect :before ((database database))
Method: database-disconnect (database)
Generic Function: database-drop-sequence (name database)

Drop a sequence from DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-drop-sequence (sequence-name database)
Source

sequences.lisp.

Method: database-drop-sequence (sequence-name (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Generic Function: database-dump-result-set (result-set database)

Dumps the received result-set.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-dump-result-set (result-set (database generic-odbc-database))
Source

generic-odbc.lisp.

Method: database-dump-result-set :before (result-set (database database))
Method: database-dump-result-set (result-set database)
Method: database-dump-result-set (result-set (database database))
Generic Function: database-execute-command (sql-expression database)

Internal generic implementation of execute-command.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-execute-command (sql-expression (database generic-odbc-database))
Source

generic-odbc.lisp.

Method: database-execute-command :before (sql-expression (database database))
Method: database-execute-command (sql-expression database)
Method: database-execute-command (sql-expression (database database))
Generic Function: database-free-prepared (prepared-stmt)

Free the resources of a prepared statement.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-free-prepared (pstmt)
Generic Function: database-get-type-specifier (type args database db-underlying-type)

Return the type SQL type specifier as a string, for the given lisp type and parameters.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-get-type-specifier ((type symbol) args database (db-type (eql :mssql)))

Special database types for MSSQL backends

Source

generic-odbc.lisp.

Method: database-get-type-specifier ((type symbol) args database (db-type (eql :postgresql)))

Special database types for POSTGRESQL backends

Source

generic-postgresql.lisp.

Method: database-get-type-specifier ((type symbol) args database db-type)
Source

oodml.lisp.

Method: database-get-type-specifier ((type string) args database db-type)

Pass through the literal type as defined in the type string

Source

oodml.lisp.

Generic Function: database-initialize-database-type (database-type)

The internal generic implementation of initialize-database-type.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-last-auto-increment-id (database table column)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-last-auto-increment-id ((database generic-odbc-database) table column)
Source

generic-odbc.lisp.

Method: database-last-auto-increment-id ((database generic-postgresql-database) table column)
Source

generic-postgresql.lisp.

Generic Function: database-list (connection-spec type)

Lists all databases found for TYPE. May signal an error if unable to communicate with database server.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list (connection-spec (type (eql :postgresql-socket)))
Source

generic-postgresql.lisp.

Method: database-list (connection-spec (type (eql :postgresql)))
Source

generic-postgresql.lisp.

Method: database-list (spec type)
Generic Function: database-list-attributes (table database &key owner)

List all attributes in TABLE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-attributes ((table %database-identifier) (database generic-odbc-database) &key owner)
Source

generic-odbc.lisp.

Method: database-list-attributes ((table %database-identifier) (database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-list-attributes (table (database database) &key owner)
Method: database-list-attributes (table database &key owner)
Generic Function: database-list-indexes (database &key owner)

List all indexes in the DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-indexes ((database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-list-indexes ((database database) &key owner)
Method: database-list-indexes (database &key owner)
Generic Function: database-list-sequences (database &key owner)

List all sequences in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-sequences (database &key owner)
Source

sequences.lisp.

Method: database-list-sequences ((database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Generic Function: database-list-table-indexes (table database &key owner)

List all indexes for a table in the DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-table-indexes (table (database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-list-table-indexes (table (database database) &key owner)
Method: database-list-table-indexes (table database &key owner)
Generic Function: database-list-tables (database &key owner)

List all tables in the given database

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-tables ((database generic-odbc-database) &key owner)

Since ODBC doesn’t expose the owner we use that parameter to filter on schema since that’s what tends to be exposed. Some DBs like mssql 2000 conflate the two so at least there it works nicely.

Source

generic-odbc.lisp.

Method: database-list-tables ((database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-list-tables ((database database) &key owner)
Method: database-list-tables (database &key owner)
Generic Function: database-list-tables-and-sequences (database &key owner)

List all tables in the given database, may include seqeneces

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-tables-and-sequences (database &key owner)
Method: database-list-tables-and-sequences ((database database) &key owner)
Generic Function: database-list-views (database &key owner)

List all views in the DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-list-views ((database generic-odbc-database) &key owner)

Since ODBC doesn’t expose the owner we use that parameter to filter on schema since that’s what tends to be exposed. Some DBs like mssql 2000 conflate the two so at least there it works nicely.

Source

generic-odbc.lisp.

Method: database-list-views ((database generic-postgresql-database) &key owner)
Source

generic-postgresql.lisp.

Method: database-list-views ((database database) &key owner)
Method: database-list-views (database &key owner)
Generic Reader: database-name (object)

Returns the name of a database.

Package

clsql-sys.

Methods
Reader Method: database-name ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

name.

Generic Function: database-name-from-spec (connection-spec database-type)

Returns the name of the database that would be created if connect was called with the connection-spec.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-output-sql-as-type (type val database db-type)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-output-sql-as-type (type val database db-type)
Source

oodml.lisp.

Generic Function: database-prepare (stmt types database result-types field-names)

Prepare a statement for later execution.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-prepare (sql-stmt types (database generic-postgresql-database) result-types field-names)
Source

generic-postgresql.lisp.

Method: database-prepare (stmt types database result-types field-names)
Method: database-prepare (stmt types (database database) result-types field-names)
Generic Function: database-probe (connection-spec type)

Probes for the existence of a database, returns T if database found or NIL if not found. May signal an error if unable to communicate with database server.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-probe (spec type)
Generic Function: database-query (query-expression database result-types field-names)

Internal generic implementation of query.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-query (query-expression (database generic-odbc-database) result-types field-names)
Source

generic-odbc.lisp.

Method: database-query :before (query-expression (database database) result-set field-names)
Method: database-query (query-expression database result-types field-names)
Method: database-query (query-expression (database database) result-types field-names)
Generic Function: database-query-result-set (query-expression database &key full-set result-types)

Internal generic implementation of query mapping. Starts the query specified by query-expression on the given database and returns a result-set to be used with database-store-next-row and database-dump-result-set to access the returned data. The second value is the number of columns in the result-set, if there are any. If full-set is true, the number of rows in the result-set is returned as a third value, if this is possible (otherwise nil is returned for the third value). This might have memory and resource usage implications, since many databases will require the query to be executed in full to answer this question. If the query produced no results then nil is returned for all values that would have been returned otherwise. If an error occurs during query execution, the function should signal a sql-database-data-error.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-query-result-set ((query-expression string) (database generic-odbc-database) &key full-set result-types)
Source

generic-odbc.lisp.

Method: database-query-result-set ((expr %sql-expression) database &key full-set result-types)
Source

fdml.lisp.

Method: database-query-result-set :before (expr (database database) &key full-set result-types)
Method: database-query-result-set (query-expression database &key full-set result-types)
Method: database-query-result-set (query-expression (database database) &key full-set result-types)
Generic Function: database-read-large-object (object-id database)

Reads the large object content

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-reconnect (database)

Internal generic implementation of reconnect.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-reconnect (database)
Generic Function: database-release-to-conn-pool (database)

Chance for the database to cleanup before it is returned to the connection pool.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-release-to-conn-pool (database)
Source

pool.lisp.

Generic Function: database-run-prepared (prepared-stmt)

Execute a prepared statement.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-run-prepared ((stmt postgresql-stmt))
Source

generic-postgresql.lisp.

Method: database-run-prepared (pstmt)
Generic Function: database-sequence-last (name database)

Select the last value in sequence NAME in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-sequence-last (sequence-name database)
Source

sequences.lisp.

Method: database-sequence-last (sequence-name (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Generic Function: database-sequence-next (name database)

Increment a sequence in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-sequence-next (sequence-name database)
Source

sequences.lisp.

Method: database-sequence-next (sequence-name (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Generic Function: database-set-sequence-position (name position database)

Set the position of the sequence called NAME in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-set-sequence-position (sequence-name position database)
Source

sequences.lisp.

Method: database-set-sequence-position (name (position integer) (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Generic Reader: database-state (object)
Package

clsql-sys.

Methods
Reader Method: database-state ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

state.

Generic Function: database-store-next-row (result-set database list)

Returns t and stores the next row in the result set in list or returns nil when result-set is finished.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-store-next-row (result-set (database generic-odbc-database) list)
Source

generic-odbc.lisp.

Method: database-store-next-row :before (result-set (database database) list)
Method: database-store-next-row (result-set database list)
Method: database-store-next-row (result-set (database database) list)
Generic Reader: database-type (object)
Package

clsql-sys.

Methods
Reader Method: database-type ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

database-type.

Generic Function: database-type-library-loaded (database-type)

The internal generic implementation for checking if database type library loaded successfully.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: database-type-load-foreign (database-type)

The internal generic implementation of reload-database-types.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-type-load-foreign :after (database-type)
Source

initialize.lisp.

Method: database-type-load-foreign (x)
Source

initialize.lisp.

Generic Function: database-underlying-type (database)

Returns the type of the underlying database. For ODBC, needs to query ODBC driver.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-underlying-type (database)
Generic Function: database-write-large-object (object-id data database)

Writes data to the large object

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: db-backend-has-create/destroy-db? (db-type)

T [default] if backend can destroy and create databases.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-backend-has-create/destroy-db? (db-type)
Generic Function: db-type-default-case (db-type)

:upper [default] if means identifiers mapped to UPPER case SQL like CommonSQL API. However, Postgresql maps identifiers to lower case, so PostgreSQL uses a value of :lower for this result.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-default-case ((db-type (eql :postgresql)))
Source

generic-postgresql.lisp.

Method: db-type-default-case (db-type)
Generic Function: db-type-has-auto-increment? (db-type)

NIL [default] if database-type supports auto-incrementing columns.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-auto-increment? ((db-underlying-type (eql :mssql)))
Source

generic-odbc.lisp.

Method: db-type-has-auto-increment? ((db-type (eql :postgresql)))
Source

generic-postgresql.lisp.

Method: db-type-has-auto-increment? (db-type)
Generic Function: db-type-has-bigint? (db-type)

T [default] if database-type supports bigint.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-bigint? (db-type)
Generic Function: db-type-has-boolean-where? (db-type)

T [default] if database-type supports boolean WHERE clause, such as ’WHERE MARRIED’.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-boolean-where? ((db-type (eql :mssql)))
Source

generic-odbc.lisp.

Method: db-type-has-boolean-where? (db-type)
Generic Function: db-type-has-except? (db-type)

T [default] if database-type supports EXCEPT.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-except? ((db-type (eql :mssql)))
Source

generic-odbc.lisp.

Method: db-type-has-except? (db-type)
Generic Function: db-type-has-fancy-math? (db-type)

NIL [default] if database-type does not have fancy math.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-fancy-math? ((db-type (eql :postgresql)))
Source

generic-postgresql.lisp.

Method: db-type-has-fancy-math? (db-type)
Generic Function: db-type-has-intersect? (db-type)

T [default] if database-type supports INTERSECT.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-intersect? ((db-type (eql :mssql)))
Source

generic-odbc.lisp.

Method: db-type-has-intersect? (db-type)
Generic Function: db-type-has-prepared-stmt? (db-type)

T if database backend supports prepared statements.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-prepared-stmt? ((db-type (eql :postgresql-socket)))
Source

generic-postgresql.lisp.

Method: db-type-has-prepared-stmt? ((db-type (eql :postgresql)))
Source

generic-postgresql.lisp.

Method: db-type-has-prepared-stmt? (db-type)
Generic Function: db-type-has-subqueries? (db-type)

T [default] if database-type supports views.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-subqueries? (db-type)
Generic Function: db-type-has-union? (db-type)

T [default] if database-type supports boolean UNION.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-union? (db-type)
Generic Function: db-type-has-views? (db-type)

T [default] if database-type supports views.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-has-views? (db-type)
Generic Function: db-type-transaction-capable? (db database)

T [default] if database can supports transactions.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-transaction-capable? (db database)
Generic Function: db-type-use-column-on-drop-index? (db-type)

NIL [default] if database-type does not use column name on DROP INDEX.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-use-column-on-drop-index? (db-type)
Generic Function: db-type-use-fully-qualified-column-on-drop-index? (db-type)

NIL [default] if database-type does not require fully qualified column name on DROP INDEX.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: db-type-use-fully-qualified-column-on-drop-index? ((db-type (eql :mssql)))
Source

generic-odbc.lisp.

Method: db-type-use-fully-qualified-column-on-drop-index? (db-type)
Generic Function: delete-instance-records (object &key database)

Deletes the records represented by OBJECT in the appropriate table of the database associated with OBJECT. If OBJECT is not yet associated with a database, an error is signalled.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: delete-instance-records ((instance standard-db-object) &key database)

Removes the records associated with a given instance (as determined by key-qualifier-for-instance)

TODO: Doesnt handle normalized classes at all afaict

Source

oodml.lisp.

Generic Function: execute-command (expression &key database)

Executes the SQL command EXPRESSION, which may be an SQL expression or a string representing any SQL statement apart from a query, on the supplied DATABASE which defaults to *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: execute-command ((expr %sql-expression) &key database)
Source

fdml.lisp.

Method: execute-command ((sql-expression string) &key database)
Source

fdml.lisp.

Generic Reader: expression (object)
Generic Writer: (setf expression) (object)
Package

clsql-sys.

Methods
Reader Method: expression ((command-object command-object))
Writer Method: (setf expression) ((command-object command-object))

query that refers to parameters using "$1", "$2", "$n". These match positions in the parameters list.

Source

command-object.lisp.

Target Slot

expression.

Generic Function: filter-select-list (view-class select-list database)

Gives fine grained control over sql to be executed and mapped to slots called with a dummy instance (so that class precedence can be used)

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: filter-select-list ((c standard-db-object) (sl select-list) database)
Source

oodml.lisp.

Generic Reader: has-been-prepared (object)
Generic Writer: (setf has-been-prepared) (object)
Package

clsql-sys.

Methods
Reader Method: has-been-prepared ((command-object command-object))
Writer Method: (setf has-been-prepared) ((command-object command-object))

Have we already prepared this command object?

Source

command-object.lisp.

Target Slot

has-been-prepared.

Generic Function: instance-refreshed (object)

Provides a hook which is called within an object oriented call to SELECT with a non-nil value of REFRESH when the View Class instance OBJECT has been updated from the database. A method specialised on STANDARD-DB-OBJECT is provided which has no effects. Methods specialised on particular View Classes can be used to specify any operations that need to be made on View Classes instances which have been updated in calls to SELECT.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: instance-refreshed ((instance standard-db-object))
Source

oodml.lisp.

Generic Reader: join-slots (object)
Package

clsql-sys.

Methods
Reader Method: join-slots ((select-list select-list))

automatically generated reader method

Source

oodml.lisp.

Target Slot

join-slots.

Generic Writer: (setf join-slots) (object)
Package

clsql-sys.

Methods
Writer Method: (setf join-slots) ((select-list select-list))

automatically generated writer method

Source

oodml.lisp.

Target Slot

join-slots.

Generic Reader: joins (object)
Package

clsql-sys.

Methods
Reader Method: joins ((select-list select-list))

automatically generated reader method

Source

oodml.lisp.

Target Slot

joins.

Generic Writer: (setf joins) (object)
Package

clsql-sys.

Methods
Writer Method: (setf joins) ((select-list select-list))

automatically generated writer method

Source

oodml.lisp.

Target Slot

joins.

Generic Function: midnight (self)
Package

clsql-sys.

Source

time.lisp.

Methods
Method: midnight ((self wall-time))

truncate hours, minutes and seconds

Generic Reader: parameters (object)
Package

clsql-sys.

Methods
Reader Method: parameters ((command-object command-object))

list of parameters

Source

command-object.lisp.

Target Slot

parameters.

Generic Writer: (setf parameters) (object)
Package

clsql-sys.

Methods
Writer Method: (setf parameters) ((o command-object))

This causes the semantics to match cl-sql instead of cl-postgresql

Source

command-object.lisp.

Target Slot

parameters.

Generic Function: prepare-sql-parameter (sql-parameter)

This method is responsible for formatting parameters
as the database expects them (eg: :false is nil, nil is :null, dates are iso8601 strings)

Package

clsql-sys.

Source

command-object.lisp.

Methods
Method: prepare-sql-parameter (sql-parameter)
Generic Reader: prepared-name (object)
Generic Writer: (setf prepared-name) (object)
Package

clsql-sys.

Methods
Reader Method: prepared-name ((command-object command-object))
Writer Method: (setf prepared-name) ((command-object command-object))

If we want this to be a prepared statement, give it a name to identify it to this session

Source

command-object.lisp.

Target Slot

prepared-name.

Generic Function: query (query-expression &key database result-types flatp field-names)

Executes the SQL query expression QUERY-EXPRESSION, which may be an SQL expression or a string, on the supplied DATABASE which defaults to *DEFAULT-DATABASE*. RESULT-TYPES is a list of symbols which specifies the lisp type for each field returned by QUERY-EXPRESSION. If RESULT-TYPES is nil all results are returned as strings whereas the default value of :auto means that the lisp types are automatically computed for each field. FIELD-NAMES is t by default which means that the second value returned is a list of strings representing the columns selected by QUERY-EXPRESSION. If FIELD-NAMES is nil, the list of column names is not returned as a second value. FLATP has a default value of nil which means that the results are returned as a list of lists. If FLATP is t and only one result is returned for each record selected by QUERY-EXPRESSION, the results are returned as elements of a list.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: query ((expr sql-object-query) &key database result-types flatp field-names)
Source

fdml.lisp.

Method: query ((expr %sql-expression) &key database result-types flatp field-names)
Source

fdml.lisp.

Method: query ((query-expression string) &key database result-types flatp field-names)
Source

fdml.lisp.

Generic Function: read-sql-value (val type database db-type)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: read-sql-value (val type database db-type)

read a sql value, from :around read-eval is disabled read numbers in base 10

Source

oodml.lisp.

Method: read-sql-value :around (val type database db-type)
Source

oodml.lisp.

Generic Reader: record-caches (object)
Package

clsql-sys.

Methods
Reader Method: record-caches ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

record-caches.

Generic Writer: (setf record-caches) (object)
Package

clsql-sys.

Methods
Writer Method: (setf record-caches) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

record-caches.

Generic Reader: result-recording-stream (object)
Package

clsql-sys.

Methods
Reader Method: result-recording-stream ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

result-recording-stream.

Generic Writer: (setf result-recording-stream) (object)
Package

clsql-sys.

Methods
Writer Method: (setf result-recording-stream) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

result-recording-stream.

Generic Reader: select-list (object)
Package

clsql-sys.

Methods
Reader Method: select-list ((select-list select-list))

automatically generated reader method

Source

oodml.lisp.

Target Slot

select-list.

Generic Writer: (setf select-list) (object)
Package

clsql-sys.

Methods
Writer Method: (setf select-list) ((select-list select-list))

automatically generated writer method

Source

oodml.lisp.

Target Slot

select-list.

Generic Reader: slot-list (object)
Package

clsql-sys.

Methods
Reader Method: slot-list ((select-list select-list))

automatically generated reader method

Source

oodml.lisp.

Target Slot

slot-list.

Generic Writer: (setf slot-list) (object)
Package

clsql-sys.

Methods
Writer Method: (setf slot-list) ((select-list select-list))

automatically generated writer method

Source

oodml.lisp.

Target Slot

slot-list.

Generic Reader: sql-error-connection-spec (condition)
Package

clsql-sys.

Methods
Reader Method: sql-error-connection-spec ((condition sql-connection-error))
Source

conditions.lisp.

Target Slot

connection-spec.

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

clsql-sys.

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

conditions.lisp.

Target Slot

database.

Generic Reader: sql-error-database-message (condition)
Package

clsql-sys.

Methods
Reader Method: sql-error-database-message ((condition sql-database-error))
Source

conditions.lisp.

Target Slot

database-message.

Generic Reader: sql-error-database-type (condition)
Package

clsql-sys.

Methods
Reader Method: sql-error-database-type ((condition sql-connection-error))
Source

conditions.lisp.

Target Slot

database-type.

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

clsql-sys.

Methods
Reader Method: sql-error-error-id ((condition sql-database-error))
Source

conditions.lisp.

Target Slot

error-id.

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

clsql-sys.

Methods
Reader Method: sql-error-expression ((condition sql-database-data-error))
Source

conditions.lisp.

Target Slot

expression.

Generic Reader: sql-error-secondary-error-id (condition)
Package

clsql-sys.

Methods
Reader Method: sql-error-secondary-error-id ((condition sql-database-error))
Source

conditions.lisp.

Target Slot

secondary-error-id.

Generic Reader: sql-user-error-message (condition)
Package

clsql-sys.

Methods
Reader Method: sql-user-error-message ((condition sql-user-error))
Source

conditions.lisp.

Target Slot

message.

Generic Reader: sql-warning-database (condition)
Package

clsql-sys.

Methods
Reader Method: sql-warning-database ((condition sql-database-warning))
Source

conditions.lisp.

Target Slot

database.

Generic Reader: transaction (object)
Package

clsql-sys.

Methods
Reader Method: transaction ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

transaction.

Generic Writer: (setf transaction) (object)
Package

clsql-sys.

Methods
Writer Method: (setf transaction) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

transaction.

Generic Reader: transaction-level (object)
Package

clsql-sys.

Methods
Reader Method: transaction-level ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

transaction-level.

Generic Writer: (setf transaction-level) (object)
Package

clsql-sys.

Methods
Writer Method: (setf transaction-level) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

transaction-level.

Generic Function: update-instance-from-records (object &key database)

Updates the slot values of the View Class instance OBJECT using the attribute values of the appropriate table of DATABASE which defaults to the database associated with OBJECT or, if OBJECT is not associated with a database, *DEFAULT-DATABASE*. Join slots are updated but instances of the class on which the join is made are not updated.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-instance-from-records ((instance standard-db-object) &key database)

Updates a database object with the current values stored in the database

TODO: Should this update immediate join slots similar to build-objects? Can we just call build-objects?, update-objects-joins?

Source

oodml.lisp.

Generic Function: update-record-from-slot (object slot &key database)

Updates the value stored in the column represented by the slot, specified by the CLOS slot name SLOT, of View Class instance OBJECT. DATABASE defaults to *DEFAULT-DATABASE* and specifies the database in which the update is made only if OBJECT is not associated with a database. In this case, a record is created in DATABASE and the attribute represented by SLOT is initialised from the value of the supplied slots with other attributes having default values. Furthermore, OBJECT becomes associated with DATABASE.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-record-from-slot ((obj standard-db-object) slot &key database)

just call update-records-from-slots which now handles this.

This function is only here to maintain backwards compatibility in the public api

Source

oodml.lisp.

Generic Function: update-record-from-slots (object slots &key database)

Updates the values stored in the columns represented by the slots, specified by the CLOS slot names SLOTS, of View Class instance OBJECT. DATABASE defaults to *DEFAULT-DATABASE* and specifies the database in which the update is made only if OBJECT is not associated with a database. In this case, a record is created in the appropriate table of DATABASE and the attributes represented by SLOTS are initialised from the values of the supplied slots with other attributes having default
values. Furthermore, OBJECT becomes associated with DATABASE.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-record-from-slots ((obj standard-db-object) slots &key database)

For a given list of slots, update all records associated with those slots and classes.

Generally this will update the single record associated with this object, but for normalized classes might update as many records as there are inheritances

Source

oodml.lisp.

Generic Function: update-records-from-instance (object &key database)

Using an instance of a View Class, OBJECT, update the table that stores its instance data. DATABASE defaults to *DEFAULT-DATABASE* and specifies the database in which the update is made only if OBJECT is not associated with a database. In this case, a record is created in the appropriate table of DATABASE using values from the slot values of OBJECT, and OBJECT becomes associated with DATABASE.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-records-from-instance ((obj standard-db-object) &key database)

Updates the records in the database associated with this object if view-database slot on the object is nil then the object is assumed to be new and is inserted

Source

oodml.lisp.

Generic Function: update-slot-from-record (object slot &key database)

Updates the slot value, specified by the CLOS slot name SLOT, of the View Class instance OBJECT using the attribute values of the appropriate table of DATABASE which defaults to the database associated with OBJECT or, if OBJECT is not associated with a database, *DEFAULT-DATABASE*. Join slots are updated but instances of the class on which the join is made are not updated.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-slot-from-record ((instance standard-db-object) slot &key database)

Pulls the value of a given slot form the database and stores that in the appropriate slot on instance

Source

oodml.lisp.

Generic Function: view-table (object)
Package

clsql-sys.

Methods
Method: view-table ((o select-list))
Source

oodml.lisp.

Method: view-table ((o class-and-slots))

get the view-table of the view-class of o

Source

oodml.lisp.

Reader Method: view-table ((standard-db-class standard-db-class))

automatically generated reader method

Source

metaclasses.lisp.

Target Slot

view-table.

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

clsql-sys.

Methods
Writer Method: (setf view-table) ((standard-db-class standard-db-class))

automatically generated writer method

Source

metaclasses.lisp.

Target Slot

view-table.


6.1.5 Standalone methods

Method: compute-effective-slot-definition ((class standard-db-class) slot-name direct-slots)
Package

sb-mop.

Source

metaclasses.lisp.

Method: compute-slots ((class standard-db-class))

Need to sort order of class slots so they are the same across implementations.

Package

sb-mop.

Source

metaclasses.lisp.

Method: direct-slot-definition-class ((class standard-db-class) &rest initargs)
Package

sb-mop.

Source

metaclasses.lisp.

Method: effective-slot-definition-class ((class standard-db-class) &rest initargs)
Package

sb-mop.

Source

metaclasses.lisp.

Method: finalize-inheritance :after ((class standard-db-class))
Package

sb-mop.

Source

metaclasses.lisp.

Method: initialize-instance ((object standard-db-object) &rest all-keys &key &allow-other-keys)
Source

ooddl.lisp.

Method: initialize-instance :after ((o command-object) &key &allow-other-keys)
Source

command-object.lisp.

Method: initialize-instance :after ((db generic-odbc-database) &rest all-keys)
Source

generic-odbc.lisp.

Method: initialize-instance :around ((class standard-db-class) &rest all-keys &key direct-superclasses base-table qualifier normalizedp &allow-other-keys)
Source

metaclasses.lisp.

Method: initialize-instance :after ((obj view-class-direct-slot-definition) &key &allow-other-keys)
Source

metaclasses.lisp.

Method: initialize-instance :around ((obj view-class-direct-slot-definition) &rest initargs &key db-constraints db-kind type &allow-other-keys)
Source

metaclasses.lisp.

Method: make-load-form ((sql sql-ident-table) &optional environment)
Source

expressions.lisp.

Method: make-load-form ((self sql-relational-exp) &optional environment)
Source

expressions.lisp.

Method: make-load-form ((sql sql-ident-attribute) &optional environment)
Source

expressions.lisp.

Method: make-load-form ((sql sql) &optional environment)
Source

expressions.lisp.

Method: make-load-form ((sql sql-ident) &optional environment)
Source

expressions.lisp.

Method: print-object ((object date) stream)
Source

time.lisp.

Method: print-object ((object wall-time) stream)
Source

time.lisp.

Method: print-object ((object duration) stream)
Source

time.lisp.

Method: print-object ((ident sql) stream)
Source

expressions.lisp.

Method: print-object ((object database) stream)
Source

base-classes.lisp.

Method: print-object ((self %sql-expression) stream)
Source

expressions.lisp.

Method: reinitialize-instance :around ((class standard-db-class) &rest all-keys &key base-table normalizedp direct-superclasses qualifier &allow-other-keys)
Source

metaclasses.lisp.

Method: slot-unbound (class (obj generic-postgresql-database) (slot (eql clsql-sys::has-table-pg_roles)))
Source

generic-postgresql.lisp.

Method: (setf slot-value-using-class) ((class standard-db-class) instance slot-def)

Handle auto syncing values to the database if *db-auto-sync* is t

Package

sb-mop.

Source

ooddl.lisp.

Method: slot-value-using-class ((class standard-db-class) instance slot-def)

When a slot is unbound but should contain a join object or a value from a normalized view-class, then retrieve and set those slots, so the value can be returned

Package

sb-mop.

Source

ooddl.lisp.

Method: validate-superclass ((class standard-db-class) (superclass standard-class))
Package

sb-mop.

Source

metaclasses.lisp.


6.1.6 Conditions

Condition: decimal-parse-error

Function ‘parse-decimal-number‘ signals this condition when it couldn’t parse a decimal number from string.

Package

decimals.

Source

decimals.lisp.

Direct superclasses

parse-error.

Condition: sql-condition
Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

condition.

Direct subclasses
Condition: sql-connection-error

Used to signal an error in connecting to a database.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-database-error.

Direct subclasses
Direct methods
Direct slots
Slot: database-type
Initform

(quote nil)

Initargs

:database-type

Readers

sql-error-database-type.

Writers

This slot is read-only.

Slot: connection-spec
Initform

(quote nil)

Initargs

:connection-spec

Readers

sql-error-connection-spec.

Writers

This slot is read-only.

Condition: sql-database-data-error

Used to signal an error with the SQL data passed to a database.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-database-error.

Direct methods

sql-error-expression.

Direct slots
Slot: expression
Initargs

:expression, nil

Readers

sql-error-expression.

Writers

This slot is read-only.

Condition: sql-database-error

Used to signal an error in a CLSQL database interface.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-error.

Direct subclasses
Direct methods
Direct slots
Slot: error-id
Initform

(quote nil)

Initargs

:error-id

Readers

sql-error-error-id.

Writers

This slot is read-only.

Slot: secondary-error-id
Initform

(quote nil)

Initargs

:secondary-error-id

Readers

sql-error-secondary-error-id.

Writers

This slot is read-only.

Slot: database-message
Initform

(quote nil)

Initargs

:message

Readers

sql-error-database-message.

Writers

This slot is read-only.

Slot: database
Initform

(quote nil)

Initargs

:database

Readers

sql-error-database.

Writers

This slot is read-only.

Condition: sql-database-warning
Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-warning.

Direct methods

sql-warning-database.

Direct slots
Slot: database
Initargs

:database

Readers

sql-warning-database.

Writers

This slot is read-only.

Condition: sql-error
Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses
Direct subclasses
Condition: sql-fatal-error

Used to signal an error when the database connection is no longer usable.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-connection-error.

Condition: sql-temporary-error

Used to signal an error when the database
cannot currently process a valid interaction because, for example, it is still executing another command possibly issued by another user.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-database-error.

Condition: sql-timeout-error

Used to signal an error when the database times out while processing some operation.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-connection-error.

Condition: sql-user-error

Used to signal lisp errors inside CLSQL.

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-error.

Direct subclasses
Direct methods

sql-user-error-message.

Direct slots
Slot: message
Initform

(quote "unspecified error")

Initargs

:message

Readers

sql-user-error-message.

Writers

This slot is read-only.

Condition: sql-warning
Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses
Direct subclasses

sql-database-warning.

Direct methods

sql-warning-message.

Direct slots
Slot: message
Initform

(quote nil)

Initargs

:message

Readers

sql-warning-message.

Writers

This slot is read-only.


6.1.7 Structures

Structure: date
Package

clsql-sys.

Source

time.lisp.

Direct superclasses

structure-object.

Direct methods
Direct slots
Slot: mjd
Type

fixnum

Initform

0

Readers

date-mjd.

Writers

(setf date-mjd).

Structure: duration
Package

clsql-sys.

Source

time.lisp.

Direct superclasses

structure-object.

Direct methods
Direct slots
Slot: year
Type

fixnum

Initform

0

Readers

duration-year.

Writers

(setf duration-year).

Slot: month
Type

fixnum

Initform

0

Readers

duration-month.

Writers

(setf duration-month).

Slot: day
Type

fixnum

Initform

0

Readers

duration-day.

Writers

(setf duration-day).

Slot: hour
Type

fixnum

Initform

0

Readers

duration-hour.

Writers

(setf duration-hour).

Slot: second
Package

common-lisp.

Type

fixnum

Initform

0

Readers

duration-second.

Writers

(setf duration-second).

Slot: minute
Type

fixnum

Initform

0

Readers

duration-minute.

Writers

(setf duration-minute).

Slot: usec
Type

fixnum

Initform

0

Readers

duration-usec.

Writers

(setf duration-usec).

Structure: wall-time
Package

clsql-sys.

Source

time.lisp.

Direct superclasses

structure-object.

Direct methods
Direct slots
Slot: mjd
Type

fixnum

Initform

0

Readers

time-mjd.

Writers

(setf time-mjd).

Slot: second
Package

common-lisp.

Type

fixnum

Initform

0

Readers

time-second.

Writers

(setf time-second).

Slot: usec
Type

fixnum

Initform

0

Readers

time-usec.

Writers

(setf time-usec).


6.1.8 Classes

Class: command-object
Package

clsql-sys.

Source

command-object.lisp.

Direct methods
Direct slots
Slot: expression

query that refers to parameters using "$1", "$2", "$n". These match positions in the parameters list.

Initargs

:expression

Readers

expression.

Writers

(setf expression).

Slot: parameters

list of parameters

Initargs

:parameters

Readers

parameters.

Writers

(setf parameters).

Slot: prepared-name

If we want this to be a prepared statement, give it a name to identify it to this session

Initform

""

Initargs

:prepared-name

Readers

prepared-name.

Writers

(setf prepared-name).

Slot: has-been-prepared

Have we already prepared this command object?

Initargs

:has-been-prepared

Readers

has-been-prepared.

Writers

(setf has-been-prepared).

Class: conn-pool
Package

clsql-sys.

Source

pool.lisp.

Direct methods
Direct slots
Slot: connection-spec
Initargs

:connection-spec

Readers

connection-spec.

Writers

(setf connection-spec).

Slot: database-type
Initargs

:pool-database-type

Readers

pool-database-type.

Writers

(setf pool-database-type).

Slot: free-connections
Readers

free-connections.

Writers

(setf free-connections).

Slot: all-connections
Readers

all-connections.

Writers

(setf all-connections).

Slot: lock
Initform

(clsql-sys:make-process-lock "connection pool")

Readers

conn-pool-lock.

Writers

(setf conn-pool-lock).

Class: database

This class is the supertype of all databases handled by CLSQL.

Package

clsql-sys.

Source

base-classes.lisp.

Direct subclasses
Direct methods
Direct slots
Slot: name
Initargs

:name

Readers

database-name.

Writers

This slot is read-only.

Slot: connection-spec

Required to use connection pool.

Initargs

:connection-spec

Readers

connection-spec.

Writers

This slot is read-only.

Slot: database-type
Initform

:unknown

Initargs

:database-type

Readers

database-type.

Writers

This slot is read-only.

Slot: encoding

External format character encoding.

Initargs

:encoding

Slot: state
Initform

:closed

Readers

database-state.

Writers

This slot is read-only.

Slot: autocommit
Initform

t

Readers

database-autocommit.

Writers

(setf database-autocommit).

Slot: command-recording-stream
Readers

command-recording-stream.

Writers

(setf command-recording-stream).

Slot: result-recording-stream
Readers

result-recording-stream.

Writers

(setf result-recording-stream).

Slot: record-caches
Readers

record-caches.

Writers

(setf record-caches).

Slot: view-classes
Readers

database-view-classes.

Writers

(setf database-view-classes).

Slot: transaction-level
Initform

0

Readers

transaction-level.

Writers

(setf transaction-level).

Slot: transaction
Readers

transaction.

Writers

(setf transaction).

Slot: conn-pool
Initargs

:conn-pool

Readers

conn-pool.

Writers

(setf conn-pool).

Slot: attribute-cache

Internal cache of table attributes. It is keyed by table-name. Values
are a list of ACTION specified for table and any cached value of list-attributes-types.

Initform

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

Readers

attribute-cache.

Writers

(setf attribute-cache).

Class: generic-odbc-database

Encapsulate same behavior across odbc and aodbc backends.

Package

clsql-sys.

Source

generic-odbc.lisp.

Direct superclasses

database.

Direct methods
Direct slots
Slot: dbi-package
Initargs

:dbi-package

Readers

dbi-package.

Writers

This slot is read-only.

Slot: odbc-conn
Initargs

:odbc-conn

Readers

odbc-conn.

Writers

(setf odbc-conn).

Slot: disconnect-fn
Readers

disconnect-fn.

Writers

This slot is read-only.

Slot: sql-fn
Readers

sql-fn.

Writers

This slot is read-only.

Slot: close-query-fn
Readers

close-query-fn.

Writers

This slot is read-only.

Slot: fetch-row
Readers

fetch-row-fn.

Writers

This slot is read-only.

Slot: list-all-database-tables-fn
Readers

list-all-database-tables-fn.

Writers

This slot is read-only.

Slot: list-all-table-columns-fn
Readers

list-all-table-columns-fn.

Writers

This slot is read-only.

Slot: odbc-db-type
Initargs

:odbc-db-type

Readers

database-odbc-db-type.

Writers

(setf database-odbc-db-type).

Class: generic-postgresql-database

Encapsulate same behavior across postgresql and postgresql-socket backends.

Package

clsql-sys.

Source

generic-postgresql.lisp.

Direct superclasses

database.

Direct methods
Direct slots
Slot: has-table-pg_roles
Type

boolean

Readers

has-table-pg_roles.

Writers

This slot is read-only.

Class: select-list

Collects the classes, slots and their respective sql representations
so that update-instance-from-recors, find-all, build-objects can share this info and calculate it once. Joins are select-lists for each immediate join-slot but only if make-select-list is called with do-joins-p

Package

clsql-sys.

Source

oodml.lisp.

Direct methods
Direct slots
Slot: view-class
Initargs

:view-class

Readers

view-class.

Writers

(setf view-class).

Slot: select-list
Initargs

:select-list

Readers

select-list.

Writers

(setf select-list).

Slot: slot-list
Initargs

:slot-list

Readers

slot-list.

Writers

(setf slot-list).

Slot: joins
Initargs

:joins

Readers

joins.

Writers

(setf joins).

Slot: join-slots
Initargs

:join-slots

Readers

join-slots.

Writers

(setf join-slots).

Class: sql

A literal SQL expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods
Direct slots
Slot: text
Initform

""

Initargs

:string

Class: sql-assignment-exp

An SQL Assignment expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-relational-exp.

Direct methods

output-sql.

Class: sql-between-exp

An SQL between expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-function-exp.

Direct methods

output-sql.

Class: sql-function-exp

An SQL function expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct subclasses

sql-between-exp.

Direct methods
Direct slots
Slot: name
Initargs

:name

Slot: args
Initargs

:args

Class: sql-ident

An SQL identifer.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct subclasses
Direct methods
Direct slots
Slot: name
Initform

clsql-sys::+null-string+

Initargs

:name

Class: sql-ident-attribute

An SQL Attribute identifier.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-ident.

Direct methods
Direct slots
Slot: qualifier
Initform

clsql-sys::+null-string+

Initargs

:qualifier

Slot: type
Package

common-lisp.

Initform

clsql-sys::+null-string+

Initargs

:type

Class: sql-ident-table

An SQL table identifier.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-ident.

Direct methods
Direct slots
Slot: alias
Initargs

:table-alias

Class: sql-object-query
Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods
Direct slots
Slot: objects
Initargs

:objects

Slot: flatp
Initargs

:flatp

Slot: exp
Package

common-lisp.

Initargs

:exp

Slot: refresh
Initargs

:refresh

Class: sql-query

An SQL SELECT query.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods
Direct slots
Slot: selections
Initargs

:selections

Slot: all
Initargs

:all

Slot: flatp
Initargs

:flatp

Slot: set-operation
Initargs

:set-operation

Slot: distinct
Initargs

:distinct

Slot: from
Initargs

:from

Slot: where
Initargs

:where

Slot: group-by
Initargs

:group-by

Slot: having
Initargs

:having

Slot: limit
Initargs

:limit

Slot: offset
Initargs

:offset

Slot: order-by
Initargs

:order-by

Slot: inner-join
Initargs

:inner-join

Slot: on
Initargs

:on

Class: sql-query-modifier-exp

An SQL query modifier expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: modifier
Initargs

:modifier

Slot: components
Initargs

:components

Class: sql-relational-exp

An SQL relational expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct subclasses
Direct methods
Direct slots
Slot: operator
Initargs

:operator

Slot: sub-expressions
Initargs

:sub-expressions

Class: sql-set-exp

An SQL set expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods
Direct slots
Slot: operator
Initargs

:operator

Slot: sub-expressions
Initargs

:sub-expressions

Class: sql-typecast-exp

An SQL typecast expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-value-exp.

Direct methods
Class: sql-upcase-like

An SQL ’like’ that upcases its arguments.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

sql-relational-exp.

Direct methods

output-sql.

Class: sql-value-exp

An SQL value expression.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct subclasses

sql-typecast-exp.

Direct methods
Direct slots
Slot: modifier
Initargs

:modifier

Slot: components
Initargs

:components

Class: standard-db-object

Superclass for all CLSQL View Classes.

Package

clsql-sys.

Source

ooddl.lisp.

Direct methods
Direct slots
Slot: view-database
Initargs

:view-database

Readers

view-database.

Writers

This slot is read-only.

Class: transaction
Package

clsql-sys.

Source

transaction.lisp.

Direct methods
Direct slots
Slot: commit-hooks
Readers

commit-hooks.

Writers

(setf commit-hooks).

Slot: rollback-hooks
Readers

rollback-hooks.

Writers

(setf rollback-hooks).

Slot: previous-autocommit
Initargs

:previous-autocommit

Readers

previous-autocommit.

Writers

This slot is read-only.

Slot: status

nil or :committed

Readers

transaction-status.

Writers

(setf transaction-status).


6.1.9 Types

Type: bigint ()

An integer larger than a 32-bit integer, this width may vary by SQL implementation.

Package

clsql-sys.

Source

oodml.lisp.

Type: generalized-boolean ()

A type which outputs a SQL boolean value, though any lisp type can be stored in the slot.

Package

clsql-sys.

Source

oodml.lisp.

Type: mediumint ()

An integer smaller than a 32-bit integer, but may be larger than a smallint. This width may vary by SQL implementation.

Package

clsql-sys.

Source

oodml.lisp.

Type: smallint ()

An integer smaller than a 32-bit integer. this width may vary by SQL implementation.

Package

clsql-sys.

Source

oodml.lisp.

Type: tinyint ()

An 8-bit integer, this width may vary by SQL implementation.

Package

clsql-sys.

Source

oodml.lisp.

Type: universal-time ()

A positive integer as returned by GET-UNIVERSAL-TIME.

Package

clsql-sys.

Source

oodml.lisp.

Type: varchar (&optional size)

A variable length string for the SQL varchar type.

Package

clsql-sys.

Source

oodml.lisp.


6.2 Internals


6.2.1 Special variables

Special Variable: *connected-databases*

List of active database objects.

Package

clsql-sys.

Source

database.lisp.

Special Variable: *day-keywords*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *day-names*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *db-deserializing*
Package

clsql-sys.

Source

ooddl.lisp.

Special Variable: *db-info-lambda-list*
Package

clsql-sys.

Source

metaclasses.lisp.

Special Variable: *db-initializing*
Package

clsql-sys.

Source

ooddl.lisp.

Special Variable: *db-pool*
Package

clsql-sys.

Source

pool.lisp.

Special Variable: *db-pool-lock*
Package

clsql-sys.

Source

pool.lisp.

Special Variable: *default-encoding*
Package

clsql-sys.

Source

database.lisp.

Special Variable: *in-subselect*
Package

clsql-sys.

Source

expressions.lisp.

Special Variable: *iso-8601-duration-delimiters*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *month-keywords*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *month-names*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *next-prepared-id-num*
Package

clsql-sys.

Source

generic-postgresql.lisp.

Special Variable: *original-readtable*
Package

clsql-sys.

Source

syntax.lisp.

Special Variable: *output-hash*

For caching generated SQL strings, set to NIL to disable.

Package

clsql-sys.

Source

expressions.lisp.

Special Variable: *restore-sql-reader-syntax*
Package

clsql-sys.

Source

syntax.lisp.

Special Variable: *roman-digits*
Package

clsql-sys.

Source

time.lisp.

Special Variable: *select-arguments*
Package

clsql-sys.

Source

expressions.lisp.

Special Variable: *sql-macro-close-char*
Package

clsql-sys.

Source

syntax.lisp.

Special Variable: *sql-macro-open-char*
Package

clsql-sys.

Source

syntax.lisp.

Special Variable: *sql-op-table*
Package

clsql-sys.

Source

operations.lisp.

Special Variable: *sql-stream*

stream which accumulates SQL output

Package

clsql-sys.

Source

expressions.lisp.

Special Variable: +auto-increment-names+
Package

clsql-sys.

Source

expressions.lisp.

Special Variable: +empty-string+
Package

clsql-sys.

Source

expressions.lisp.

Special Variable: +extra-class-options+
Package

clsql-sys.

Source

metaclasses.lisp.

Special Variable: +extra-slot-options+
Package

clsql-sys.

Source

metaclasses.lisp.

Special Variable: +no-slot-value+
Package

clsql-sys.

Source

oodml.lisp.

Special Variable: +null-string+
Package

clsql-sys.

Source

expressions.lisp.

Special Variable: +whitespace-chars+

List of whitespace characters for this lisp implementation.

Package

clsql-sys.

Source

utils.lisp.


6.2.2 Macros

Macro: defaulting (&rest place-value-plist)

for places and values (as an &rest plist) if place-n is null set it to value-n

Package

clsql-sys.

Source

utils.lisp.

Macro: defsql (function definition-keys &body body)
Package

clsql-sys.

Source

operations.lisp.

Macro: for-each-row (((&rest fields) &key from order-by where distinct limit) &body body)
Package

clsql-sys.

Source

fdml.lisp.

Macro: make-weak-hash-table (&rest args)

Creates a weak hash table for use in a cache.

Package

clsql-sys.

Source

utils.lisp.

Macro: pop-n (place &optional n)

pops n items off of a list in place and returns their values in a new list

if n > the length of the list in place, then we return the full list, setting the place to nil

Package

clsql-sys.

Source

utils.lisp.

Macro: process-class-option (metaclass slot-name &optional required)
Package

clsql-sys.

Source

kmr-mop.lisp.

Macro: process-slot-option (metaclass slot-name)
Package

clsql-sys.

Source

kmr-mop.lisp.

Macro: wrap-time-for-date (time-func &key result-func)
Package

clsql-sys.

Source

time.lisp.


6.2.3 Ordinary functions

Function: %clsql-subclauses (clauses)

a helper for dealing with lists of sql clauses

Package

clsql-sys.

Source

expressions.lisp.

Function: %command-output (control-string &rest args)

Interpolate ARGS into CONTROL-STRING as if by FORMAT, and synchronously execute the result using a Bourne-compatible shell, returns (VALUES string-output error-output exit-status)

Package

clsql-sys.

Source

utils.lisp.

Function: %convert-db-info-to-hash (slot-def)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: %database-list-* (database type owner)

Internal function used by database-list-tables and database-list-views

Package

clsql-sys.

Source

generic-odbc.lisp.

Function: %disable-sql-reader-syntax ()
Package

clsql-sys.

Source

syntax.lisp.

Function: %enable-sql-reader-syntax ()
Package

clsql-sys.

Source

syntax.lisp.

Function: %get-int (v)
Package

clsql-sys.

Source

utils.lisp.

Function: %make-database-identifier (inp &optional database)

We want to quote an identifier if it came to us as a string or if it has special characters in it.

Package

clsql-sys.

Source

expressions.lisp.

Function: %make-date (&key mjd)
Package

clsql-sys.

Source

time.lisp.

Function: %make-duration (&key year month day hour second minute usec)
Package

clsql-sys.

Source

time.lisp.

Function: %make-wall-time (&key mjd second usec)
Package

clsql-sys.

Source

time.lisp.

Function: %object-joins-from-list (object slot joins force-p)

Given a list of objects that we are trying to join to, pull the correct ones for this object

Package

clsql-sys.

Source

oodml.lisp.

Function: %pool-force-disconnect (database)

Force disconnection of a connection from the pool.

Package

clsql-sys.

Source

pool.lisp.

Function: %print-date (date stream depth)
Package

clsql-sys.

Source

time.lisp.

Function: %print-duration (duration stream depth)
Package

clsql-sys.

Source

time.lisp.

Function: %print-wall-time (time stream depth)
Package

clsql-sys.

Source

time.lisp.

Function: %seq-name-key ()
Package

clsql-sys.

Source

sequences.lisp.

Function: %sequence-name-to-table (sequence-name database)
Package

clsql-sys.

Source

sequences.lisp.

Function: %svuc-slot-name (slot)
Package

clsql-sys.

Source

kmr-mop.lisp.

Function: %svuc-slot-object (slot class)
Package

clsql-sys.

Source

kmr-mop.lisp.

Function: %table-name-to-sequence-name (table-name)
Package

clsql-sys.

Source

sequences.lisp.

Function: %tables-for-query (classes from where inner-joins)

Given lists of classes froms wheres and inner-join compile a list of tables that should appear in the FROM section of the query.

This includes any immediate join classes from each of the classes

Package

clsql-sys.

Source

oodml.lisp.

Function: %time< (x y)
Package

clsql-sys.

Source

time.lisp.

Function: %time<= (x y)
Package

clsql-sys.

Source

time.lisp.

Function: %time= (x y)
Package

clsql-sys.

Source

time.lisp.

Function: %time> (x y)
Package

clsql-sys.

Source

time.lisp.

Function: %time>= (x y)
Package

clsql-sys.

Source

time.lisp.

Function: %uninstall-class (self &key database owner)
Package

clsql-sys.

Source

ooddl.lisp.

Function: %update-objects-joins-slot-defs (class slot-names)

Get the slot definitions for the joins slots specified as slot-names if slot-names is :immediate, :deferred or (or :all t) return all of that type of slot definitions

Package

clsql-sys.

Source

oodml.lisp.

Function: %write-operator (operator database)
Package

clsql-sys.

Source

expressions.lisp.

Function: acquire-from-pool (connection-spec database-type &optional pool encoding)

Try to find a working database connection in the pool or create a new one if needed. This performs 1 query against the DB to ensure it’s still valid. When possible (postgres, mssql) that query will be a reset command to put the connection back into its default state.

Package

clsql-sys.

Source

pool.lisp.

Function: all-home-keys-have-values-p (object slot-def)

Do all of the home-keys have values ?

Package

clsql-sys.

Source

oodml.lisp.

Function: all-immediate-join-classes-for (classes)

returns a list of all join-classes needed for a list of classes

Package

clsql-sys.

Source

oodml.lisp.

Function: base-db-class (classname)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: binding-to-param (binding)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: build-objects (select-lists row database &optional existing-instances)

Used by find-all to build objects.

THIS NEEDS TO MATCH THE ORDER OF FULL-SELECT-LIST

TODO: this caching scheme seems bad for a number of reasons
* order is not guaranteed so references being held by one object
might change to represent a different database row (seems HIGHLY suspect)
* also join objects are overwritten rather than refreshed

TODO: the way we handle immediate joins seems only valid if it is a single object. I suspect that making a :set :immediate join column would result in an invalid number of objects returned from the database, because there would be multiple rows per object, but we would return an object per row

Package

clsql-sys.

Source

oodml.lisp.

Function: check-slot-type (slotdef val)
Package

clsql-sys.

Source

oodml.lisp.

Function: clear-conn-pool (pool)

Be careful this function will disconnect connections without regard to whether another thread is actively using them.

Package

clsql-sys.

Source

pool.lisp.

Function: clsql-and (&rest clauses)

Correctly creates a sql ’and’ expression for the clauses ignores any nil clauses
returns a single child expression if there is only one returns an ’and’ expression if there are many returns nil if there are no children

Package

clsql-sys.

Source

expressions.lisp.

Function: clsql-ands (clauses)

Correctly creates a sql ’and’ expression for the clauses ignores any nil clauses
returns a single child expression if there is only one returns an ’and’ expression if there are many returns nil if there are no children

Package

clsql-sys.

Source

expressions.lisp.

Function: clsql-or (&rest clauses)

Correctly creates a sql ’or’ expression for the clauses ignores any nil clauses
returns a single child expression if there is only one returns an ’or’ expression if there are many returns nil if there are no children

Package

clsql-sys.

Source

expressions.lisp.

Function: clsql-ors (clauses)

Correctly creates a sql ’or’ expression for the clauses ignores any nil clauses
returns a single child expression if there is only one returns an ’or’ expression if there are many returns nil if there are no children

Package

clsql-sys.

Source

expressions.lisp.

Function: clsql-type->postgresql-type (type)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: combine-database-identifiers (ids &optional database)

Create a new database identifier by combining parts in a reasonable way

Package

clsql-sys.

Source

expressions.lisp.

Function: compute-column-name (arg)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: compute-lisp-type-from-specified-type (specified-type db-constraints)

Computes the Lisp type for a user-specified type.

Package

clsql-sys.

Source

metaclasses.lisp.

Function: compute-records-cache-key (targets qualifiers)
Package

clsql-sys.

Source

oodml.lisp.

Function: copy-date (instance)
Package

clsql-sys.

Source

time.lisp.

Function: copy-duration (instance)
Package

clsql-sys.

Source

time.lisp.

Function: copy-interval (instance)
Package

clsql-sys.

Source

time.lisp.

Function: copy-odbc-result-set (instance)
Package

clsql-sys.

Source

generic-odbc.lisp.

Function: copy-time (time)
Package

clsql-sys.

Source

time.lisp.

Function: copy-wall-time (instance)
Package

clsql-sys.

Source

time.lisp.

Function: database-identifier-equal (i1 i2 &optional database)
Package

clsql-sys.

Source

expressions.lisp.

Function: database-list-objects-of-type (database type owner)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: date->time (date)

Returns a walltime for the given date

Package

clsql-sys.

Source

time.lisp.

Function: date/= (number &rest more-numbers)
Package

clsql-sys.

Source

time.lisp.

Function: day-name (day-index)
Package

clsql-sys.

Source

time.lisp.

Function: day-of-year (year month day &key careful)

the day number within the year of the date DATE. For example, 1987 1 1 returns 1

Package

clsql-sys.

Source

time.lisp.

Function: days-in-month (month year &key careful)

the number of days in MONTH of YEAR, observing Gregorian leap year rules

Package

clsql-sys.

Source

time.lisp.

Function: db-ancestors (classname)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: db-value-from-slot (slotdef val database)
Package

clsql-sys.

Source

oodml.lisp.

Function: decimal-round-split (number &key round-magnitude rounder positive-sign negative-sign zero-sign)
Package

decimals.

Source

decimals.lisp.

Function: delete-at-index (idx list)
Package

clsql-sys.

Source

time.lisp.

Function: delimited-string-to-list (string &optional separator skip-terminal)

Split a string with delimiter, from KMRCL.

Package

clsql-sys.

Source

utils.lisp.

Function: delist-if-single (x)

if this is a single item in a list return it

Package

clsql-sys.

Source

utils.lisp.

Function: delistify (list)

Some MOPs, like openmcl 0.14.2, cons attribute values in a list.

Package

clsql-sys.

Source

metaclasses.lisp.

Function: delistify-dsd (list)

Some MOPs, like openmcl 0.14.2, cons attribute values in a list.

Package

clsql-sys.

Source

expressions.lisp.

Function: dequote (it)
Package

clsql-sys.

Source

utils.lisp.

Function: describe-db-layout (class)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: direct-normalized-slot-p (class slot-name)

Is this a normalized class and if so is the slot one of our direct slots?

Package

clsql-sys.

Source

metaclasses.lisp.

Function: divide-into-groups (string &key separator from-end group-digits)
Package

decimals.

Source

decimals.lisp.

Function: duration- (duration &rest durations)

Subtract each DURATION from TIME, returning a new duration value.

Package

clsql-sys.

Source

time.lisp.

Function: duration-p (object)
Package

clsql-sys.

Source

time.lisp.

Reader: duration-usec (instance)
Writer: (setf duration-usec) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

usec.

Function: easy-slot-value (obj slot)

like slot-value except it accepts slot-names or defs and returns nil when the slot is unbound

Package

clsql-sys.

Source

utils.lisp.

Function: (setf easy-slot-value) (obj slot)

like slot-value except it accepts slot-names or defs

Package

clsql-sys.

Source

utils.lisp.

Function: error-converting-value (val type &optional database)
Package

clsql-sys.

Source

conditions.lisp.

Function: escaped-database-identifier (name &optional database find-class-p)
Package

clsql-sys.

Source

expressions.lisp.

Function: fault-join-slot (class object slot-def)
Package

clsql-sys.

Source

oodml.lisp.

Function: fault-join-slot-raw (class object slot-def)
Package

clsql-sys.

Source

oodml.lisp.

Function: fault-join-target-slot (class object slot-def)
Package

clsql-sys.

Source

oodml.lisp.

Function: field-names (field-forms)

Return a list of field name strings from a fields form

Package

clsql-sys.

Source

fdml.lisp.

Function: filter-plist (plist &rest keys-to-remove)

Returns a copy of the given plist with indicated key-value pairs removed. keys are searched with #’MEMBER

Package

clsql-sys.

Source

utils.lisp.

Function: find-all (view-classes &rest args &key all set-operation distinct from where group-by having order-by offset limit refresh flatp result-types inner-join on database instances parameters)

Called by SELECT to generate object query results when the
View Classes VIEW-CLASSES are passed as arguments to SELECT.

TODO: the caching scheme of passing in instances and overwriting their values seems bad for a number of reasons
* order is not guaranteed so references being held by one object
might change to represent a different database row (seems HIGHLY suspect)

TODO: the way we handle immediate joins seems only valid if it is a single object. I suspect that making a :set :immediate join column would result in an invalid number of objects returned from the database, because there would be multiple objects returned from the database

Package

clsql-sys.

Source

oodml.lisp.

Function: find-normalized-key (obj)

Find the first / primary key of a normalized object

Package

clsql-sys.

Source

oodml.lisp.

Function: find-or-create-connection-pool (connection-spec database-type)

Find connection pool in hash table, creates a new connection pool if not found

Package

clsql-sys.

Source

pool.lisp.

Function: find-slot-by-name (class slot-name &optional direct? recurse?)

Looks up a direct-slot-definition by name

Package

clsql-sys.

Source

kmr-mop.lisp.

Function: find-slot-if (class predicate &optional direct? recurse?)

Looks up a direct-slot-definition by name

Package

clsql-sys.

Source

kmr-mop.lisp.

Function: find-standard-db-class (name)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: from-names (from)

Return a list of field name strings from a fields form

Package

clsql-sys.

Source

fdml.lisp.

Function: full-select-list (select-lists)

Returns a list of sql-ref of things to select for the given classes

THIS NEEDS TO MATCH THE ORDER OF build-objects

Package

clsql-sys.

Source

oodml.lisp.

Function: generate-attribute-reference (vclass slotdef &optional database)

Turns key class and slot-def into a sql-expression representing the table and column it comes from

used by things like make-select-list, update-slot-from-record

Package

clsql-sys.

Source

oodml.lisp.

Function: generate-sql-reference (&rest arglist)
Package

clsql-sys.

Source

syntax.lisp.

Function: get-join-slots (class &optional retrieval-method)

Returns list of join slots for a class.

if a retrieval method is specified only return slots of that type if the retrieval method is T, nil or :all return all join slots

Package

clsql-sys.

Source

oodml.lisp.

Function: get-joined-objects (objects slotdef &key force-p batch-size)

Given a list of objects and a join slot-def get the objects that need to be joined to the input objects

we will query in batches as large as batch-size

Package

clsql-sys.

Source

oodml.lisp.

Function: get-keywords (keys list)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: has-table (name database)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: hork-integers (input)
Package

clsql-sys.

Source

time.lisp.

Function: immediate-join-slots (class)
Package

clsql-sys.

Source

oodml.lisp.

Function: insert-at-index (idx list elt)
Package

clsql-sys.

Source

time.lisp.

Reader: interval-name (instance)
Writer: (setf interval-name) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

name.

Function: interval-p (object)
Package

clsql-sys.

Source

time.lisp.

Function: iso-8601-delimiter (elt)
Package

clsql-sys.

Source

time.lisp.

Function: iso-8601-duration-subseq (string end)
Package

clsql-sys.

Source

time.lisp.

Function: iso-datestring (date)
Package

clsql-sys.

Source

time.lisp.

Function: join-qualifier (class object slot-def)

Builds the join where clause based on the keys of the join slot and values of the object

Package

clsql-sys.

Source

oodml.lisp.

Function: join-slot-class (slot-def)

Get the join class for a given join slot

Package

clsql-sys.

Source

metaclasses.lisp.

Function: join-slot-class-name (slot-def)

get the join class name for a given join slot

Package

clsql-sys.

Source

metaclasses.lisp.

Function: join-slot-info-value (slot-def key)

Get the join-slot db-info value associated with a key

Package

clsql-sys.

Source

metaclasses.lisp.

Function: join-slot-p (slot-def)

takes a slot def and returns whether or not it is a join slot

Package

clsql-sys.

Source

metaclasses.lisp.

Function: join-slot-qualifier (class join-slot)

Creates a sql-expression expressing the join between the home-key on the table and its respective key on the joined-to-table

Package

clsql-sys.

Source

oodml.lisp.

Function: join-slot-retrieval-method (slot-def)

if this is a join slot return the retrieval param in the db-info

Package

clsql-sys.

Source

metaclasses.lisp.

Function: key-or-base-slot-p (slot-def)

takes a slot def and returns whether or not it is a key

Package

clsql-sys.

Source

metaclasses.lisp.

Function: key-qualifier-for-instance (obj &key database this-class)

Generate a boolean sql-expression that identifies an object by its keys

Package

clsql-sys.

Source

oodml.lisp.

Function: key-slot-p (slot-def)

takes a slot def and returns whether or not it is a key

Package

clsql-sys.

Source

metaclasses.lisp.

Function: keyslots-for-class (class)
Package

clsql-sys.

Source

ooddl.lisp.

Function: leap-days-in-days (days)
Package

clsql-sys.

Source

time.lisp.

Function: leap-year? (year)

t if YEAR is a leap yeap in the Gregorian calendar

Package

clsql-sys.

Source

time.lisp.

Function: lisp->sql-name (field)
Package

clsql-sys.

Source

fdml.lisp.

Function: listify (x)
Package

clsql-sys.

Source

expressions.lisp.

Function: loop-gentemp (&optional pref)
Package

ansi-loop.

Source

loop-extension.lisp.

Function: loop-record-iteration-path (variable data-type prep-phrases)
Package

clsql-sys.

Source

loop-extension.lisp.

Function: make-attribute-value-pair (slot-def value database)
Package

clsql-sys.

Source

fdml.lisp.

Function: make-class-and-slots (c &optional s)

Create a new class-and-slots object

Package

clsql-sys.

Source

oodml.lisp.

Function: make-constraints-description (constraint-list database)
Package

clsql-sys.

Source

expressions.lisp.

Function: make-odbc-result-set (&key query types full-set)
Package

clsql-sys.

Source

generic-odbc.lisp.

Function: make-query (&rest args)
Package

clsql-sys.

Source

expressions.lisp.

Function: make-select-list (class-and-slots &key do-joins-p database)

Make a select-list for the current class (or class-and-slots) object.

Package

clsql-sys.

Source

oodml.lisp.

Function: make-sql-insert (&key into attrs vals av-pairs subquery)
Package

clsql-sys.

Source

fdml.lisp.

Function: map-query-for-effect (function query-expression database result-types)
Package

clsql-sys.

Source

fdml.lisp.

Function: map-query-to-list (function query-expression database result-types)
Package

clsql-sys.

Source

fdml.lisp.

Function: map-query-to-simple (output-type-spec function query-expression database result-types)
Package

clsql-sys.

Source

fdml.lisp.

Function: mark-transaction-committed (database)
Package

clsql-sys.

Source

transaction.lisp.

Function: maybe-error-converting-value (new val type &optional database)
Package

clsql-sys.

Source

conditions.lisp.

Function: next-prepared-id ()
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: normalized-key-value (obj)

Normalized classes share a single key for all their key slots

Package

clsql-sys.

Source

oodml.lisp.

Function: not-direct-normalized-slot-p (class slot-name)

Is this a normalized class and if so is the slot not one of our direct slots?

Package

clsql-sys.

Source

metaclasses.lisp.

Function: number-string-to-fractional (string)
Package

decimals.

Source

decimals.lisp.

Function: number-string-to-integer (string)
Package

decimals.

Source

decimals.lisp.

Reader: odbc-result-set-full-set (instance)
Writer: (setf odbc-result-set-full-set) (instance)
Package

clsql-sys.

Source

generic-odbc.lisp.

Target Slot

full-set.

Function: odbc-result-set-p (object)
Package

clsql-sys.

Source

generic-odbc.lisp.

Reader: odbc-result-set-query (instance)
Writer: (setf odbc-result-set-query) (instance)
Package

clsql-sys.

Source

generic-odbc.lisp.

Target Slot

query.

Reader: odbc-result-set-types (instance)
Writer: (setf odbc-result-set-types) (instance)
Package

clsql-sys.

Source

generic-odbc.lisp.

Target Slot

types.

Function: order-by-strings (order-by)
Package

clsql-sys.

Source

fdml.lisp.

Function: ordered-class-direct-slots (class)

Gets an ordered list of direct class slots

Package

clsql-sys.

Source

kmr-mop.lisp.

Function: ordered-class-slots (class)
Package

clsql-sys.

Source

kmr-mop.lisp.

Function: ordinal-day (day-keyword)

Return the zero-based day number for the given DAY keyword.

Package

clsql-sys.

Source

time.lisp.

Function: ordinal-month (month-keyword)

Return the zero-based month number for the given MONTH keyword.

Package

clsql-sys.

Source

time.lisp.

Function: output-sql-where-clause (where database)

ensure that we do not output a "where" sql keyword when we will not output a clause. Also sets *in-subselect* to use SQL parentheticals as needed.

Package

clsql-sys.

Source

expressions.lisp.

Function: owner-clause (owner)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: parse-db-info (db-info-list)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: parse-integer-insensitively (string)
Package

clsql-sys.

Source

time.lisp.

Function: parse-iso-8601-duration (string)

return a wall-time from a duration string

Package

clsql-sys.

Source

time.lisp.

Function: parse-iso-8601-time (string)

return the wall-time corresponding to the given ISO 8601 datestring

Package

clsql-sys.

Source

time.lisp.

Function: position-char (char string start max)

From KMRCL.

Package

clsql-sys.

Source

utils.lisp.

Function: postgresql-database-list (connection-spec type)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: prepared-sql-to-postgresql-sql (sql)
Package

clsql-sys.

Source

generic-postgresql.lisp.

Function: pretty-time (hour minute)
Package

clsql-sys.

Source

time.lisp.

Function: print-readable-symbol (in)
Package

clsql-sys.

Source

oodml.lisp.

Function: query-arg-p (sym)
Package

clsql-sys.

Source

expressions.lisp.

Function: query-get-selections (select-args)

Return two values: the list of select-args up to the first keyword, uninclusive, and the args from that keyword to the end.

Package

clsql-sys.

Source

expressions.lisp.

Function: query-string (fields from where distinct order-by limit)
Package

clsql-sys.

Source

fdml.lisp.

Function: read-decimal-value (string)
Package

clsql-sys.

Source

utils.lisp.

Function: read-stream-to-string (in)
Package

clsql-sys.

Source

utils.lisp.

Function: record-sql-command (expr database)
Package

clsql-sys.

Source

recording.lisp.

Function: record-sql-result (res database)
Package

clsql-sys.

Source

recording.lisp.

Function: records-cache-results (targets qualifiers database)
Package

clsql-sys.

Source

oodml.lisp.

Function: (setf records-cache-results) (targets qualifiers database)
Package

clsql-sys.

Source

oodml.lisp.

Function: register-metaclass (class slots)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: release-to-pool (database &optional pool)

Release a database connection to the pool. The backend will have a chance to do cleanup.

Package

clsql-sys.

Source

pool.lisp.

Function: remove-keyword-arg (arglist akey)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: replace-all (string part replacement &key test stream)

Returns a new string in which all the occurences of the part
is replaced with replacement. [FROM http://cl-cookbook.sourceforge.net/strings.html#manip]

Package

clsql-sys.

Source

utils.lisp.

Function: replace-at-index (idx list elt)
Package

clsql-sys.

Source

time.lisp.

Function: replace-string (string1 search-string replace-string &key test)

Search within string1 for search-string, replace with replace-string, non-destructively.

Package

clsql-sys.

Source

time.lisp.

Function: replaced-string-length (str repl-alist)
Package

clsql-sys.

Source

utils.lisp.

Function: restrict-intervals (list start end)
Package

clsql-sys.

Source

time.lisp.

Function: select-reference-equal (r1 r2)

determines if two sql select references are equal using database identifier equal

Package

clsql-sys.

Source

oodml.lisp.

Function: set-view-table-slot (class base-table)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: signal-closed-database-error (database)
Package

clsql-sys.

Source

conditions.lisp.

Function: signal-database-too-strange (message)
Package

clsql-sys.

Source

conditions.lisp.

Function: signal-no-database-error (database)
Package

clsql-sys.

Source

conditions.lisp.

Function: slot-has-default-p (slot)

returns nil if the slot does not have a default constraint

Package

clsql-sys.

Source

metaclasses.lisp.

Function: slotdef-for-slot-with-class (slot class)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: slotdefs-for-slots-with-class (slots class)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: slots-for-possibly-normalized-class (class)

Get the slots for this class, if normalized this is only the direct slots otherwiese its all the slots

Package

clsql-sys.

Source

metaclasses.lisp.

Function: sort-interval-list (list)
Package

clsql-sys.

Source

time.lisp.

Function: special-cased-symbol-p (sym)

Should the symbols case be preserved, or should we convert to default casing

Package

clsql-sys.

Source

expressions.lisp.

Function: special-char-p (s)

Check if a string has any special characters

Package

clsql-sys.

Source

expressions.lisp.

Function: sql-e-string (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-lower (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: sql-output (sql-expr &optional database)

Top-level call for generating SQL strings. Returns an SQL string appropriate for DATABASE which corresponds to the supplied lisp expression SQL-EXPR.

Package

clsql-sys.

Source

expressions.lisp.

Function: sql-reader-open (stream char)
Package

clsql-sys.

Source

syntax.lisp.

Function: sql-upper (&rest rest)
Package

clsql-sys.

Source

operations.lisp.

Function: string-align (string width &key side char)
Package

decimals.

Source

decimals.lisp.

Function: string-to-list-connection-spec (str)
Package

clsql-sys.

Source

utils.lisp.

Function: substitute-char-string (procstr match-char subst-str)

Substitutes a string for a single matching character of a string

Package

clsql-sys.

Source

utils.lisp.

Function: substitute-chars-strings (str repl-alist)

Replace all instances of a chars with a string. repl-alist is an assoc list of characters and replacement strings.

Package

clsql-sys.

Source

utils.lisp.

Function: substitute-string-for-char (procstr match-char subst-str)

Substitutes a string for a single matching character of a string

Package

clsql-sys.

Source

utils.lisp.

Function: syntax-parse-iso-8601 (string)
Package

clsql-sys.

Source

time.lisp.

Function: table-name-from-arg (arg)
Package

clsql-sys.

Source

metaclasses.lisp.

Function: time->date (time)

Returns a date for the given wall time (obvious loss in resolution)

Package

clsql-sys.

Source

time.lisp.

Function: time-hms (time)
Package

clsql-sys.

Source

time.lisp.

Function: time-meridian (hours)
Package

clsql-sys.

Source

time.lisp.

Reader: time-second (instance)
Writer: (setf time-second) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

second.

Reader: time-usec (instance)
Writer: (setf time-usec) (instance)
Package

clsql-sys.

Source

time.lisp.

Target Slot

usec.

Function: time/= (number &rest more-numbers)

Returns T if no two of its arguments are numerically equal, NIL otherwise.

Package

clsql-sys.

Source

time.lisp.

Function: to-attributes-and-values (av-pairs)
Package

clsql-sys.

Source

fdml.lisp.

Function: to-class (it)
Package

clsql-sys.

Source

utils.lisp.

Function: to-class-name (o)
Package

clsql-sys.

Source

utils.lisp.

Function: to-slot-name (slot)

try to turn what we got representing the slot into a slot name

Package

clsql-sys.

Source

utils.lisp.

Function: unescaped-database-identifier (name &optional database find-class-p)
Package

clsql-sys.

Source

expressions.lisp.

Function: update-auto-increments-keys (class obj database)

handle pulling any autoincrement values into the object Also handles normalized key chaining

Package

clsql-sys.

Source

oodml.lisp.

Function: update-fault-join-normalized-slot (class object slot-def)
Package

clsql-sys.

Source

oodml.lisp.

Function: valid-gregorian-date-p (date)

t if DATE (year month day) exists in the Gregorian calendar

Package

clsql-sys.

Source

time.lisp.

Function: valid-month-p (month)

t if MONTH exists in the Gregorian calendar

Package

clsql-sys.

Source

time.lisp.

Function: wall-time-p (object)
Package

clsql-sys.

Source

time.lisp.

Function: where-strings (where)
Package

clsql-sys.

Source

fdml.lisp.


6.2.4 Generic functions

Generic Function: %install-class (class database &key transactions)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: %install-class ((self standard-db-class) database &key transactions)
Source

ooddl.lisp.

Generic Function: %table-exists-p (name database &key owner)
Package

clsql-sys.

Methods
Method: %table-exists-p (name database &key owner)
Source

fddl.lisp.

Generic Function: %update-instance-helper (class-and-slots obj database)
Package

clsql-sys.

Methods
Method: %update-instance-helper (class-and-slots obj database)

A function to help us update a given table (based on class-and-slots) with values from an object

Source

oodml.lisp.

Generic Reader: all-connections (object)
Package

clsql-sys.

Methods
Reader Method: all-connections ((conn-pool conn-pool))

automatically generated reader method

Source

pool.lisp.

Target Slot

all-connections.

Generic Writer: (setf all-connections) (object)
Package

clsql-sys.

Methods
Writer Method: (setf all-connections) ((conn-pool conn-pool))

automatically generated writer method

Source

pool.lisp.

Target Slot

all-connections.

Generic Reader: attribute (object)
Package

clsql-sys.

Methods
Reader Method: attribute ((attribute-value-pair attribute-value-pair))

automatically generated reader method

Source

fdml.lisp.

Target Slot

attribute.

Generic Writer: (setf attribute) (object)
Package

clsql-sys.

Methods
Writer Method: (setf attribute) ((attribute-value-pair attribute-value-pair))

automatically generated writer method

Source

fdml.lisp.

Target Slot

attribute.

Generic Function: attribute-references (o)
Package

clsql-sys.

Methods
Method: attribute-references ((o class-and-slots))

build sql-ident-attributes for a given class-and-slots

Source

oodml.lisp.

Generic Function: attribute-value-pairs (def o database)
Package

clsql-sys.

Methods
Method: attribute-value-pairs ((def class-and-slots) (o standard-db-object) database)

for a given class-and-slots and object, create the sql-expression & value pairs that need to be sent to the database

Source

oodml.lisp.

Generic Function: auto-increment-column-p (slotdef &optional database)
Package

clsql-sys.

Methods
Method: auto-increment-column-p (slotdef &optional database)
Source

ooddl.lisp.

Generic Function: auto-increment-sequence-name (class slotdef database)

The sequence name to create for this autoincremnt column on this class if returns nil, there is no associated sequence

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: auto-increment-sequence-name (table column (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Method: auto-increment-sequence-name :around (class slot database)
Generic Reader: bindings (object)
Package

clsql-sys.

Methods
Reader Method: bindings ((postgresql-stmt postgresql-stmt))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

bindings.

Generic Function: choose-database-for-instance (object &optional database)

Used by the oodml functions to select which
database object to use. Chooses the database associated with the object primarily, falls back to the database provided as an argument or the *DEFAULT-DATABASE*.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: choose-database-for-instance ((obj standard-db-object) &optional database)

Determine which database connection to use for a standard-db-object. Errs if none is available.

Source

oodml.lisp.

Generic Reader: close-query-fn (object)
Package

clsql-sys.

Methods
Reader Method: close-query-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

close-query-fn.

Generic Function: collect-table-refs (sql)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: collect-table-refs ((sql sql-query))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-set-exp))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-function-exp))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-typecast-exp))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-value-exp))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-relational-exp))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-ident-table))
Source

expressions.lisp.

Method: collect-table-refs ((sql sql-ident-attribute))
Source

expressions.lisp.

Method: collect-table-refs ((sql list))
Source

expressions.lisp.

Method: collect-table-refs (sql)
Source

expressions.lisp.

Generic Reader: commit-hooks (object)
Package

clsql-sys.

Methods
Reader Method: commit-hooks ((transaction transaction))

automatically generated reader method

Source

transaction.lisp.

Target Slot

commit-hooks.

Generic Writer: (setf commit-hooks) (object)
Package

clsql-sys.

Methods
Writer Method: (setf commit-hooks) ((transaction transaction))

automatically generated writer method

Source

transaction.lisp.

Target Slot

commit-hooks.

Generic Reader: conn-pool-lock (object)
Package

clsql-sys.

Methods
Reader Method: conn-pool-lock ((conn-pool conn-pool))

automatically generated reader method

Source

pool.lisp.

Target Slot

lock.

Generic Writer: (setf conn-pool-lock) (object)
Package

clsql-sys.

Methods
Writer Method: (setf conn-pool-lock) ((conn-pool conn-pool))

automatically generated writer method

Source

pool.lisp.

Target Slot

lock.

Generic Function: database-abort-transaction (database)

Abort current transaction in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-abort-transaction ((database database))
Source

transaction.lisp.

Method: database-abort-transaction :before ((database database))
Method: database-abort-transaction (database)
Generic Function: database-add-attribute (table attribute database)

Add the attribute to the table.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-add-attribute (table attribute (database database))
Method: database-add-attribute (table attribute database)
Generic Function: database-add-autoincrement-sequence (class database)

If a database needs to add a sequence for its
autoincrement to work, this is where it should go. Default is that it doesnt so just return nil

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-add-autoincrement-sequence ((self standard-db-class) (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Method: database-add-autoincrement-sequence (class database)
Generic Function: database-commit-transaction (database)

Commit current transaction in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-commit-transaction ((database database))
Source

transaction.lisp.

Method: database-commit-transaction :before ((database database))
Method: database-commit-transaction (database)
Generic Function: database-constraint-statement (constraints database)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-constraint-statement (constraint-list database)
Source

expressions.lisp.

Generic Function: database-generate-column-definition (class slotdef database)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-generate-column-definition (class slotdef (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Method: database-generate-column-definition (class slotdef database)
Source

ooddl.lisp.

Generic Function: database-identifier (name &optional database find-class-p)
Package

clsql-sys.

Methods
Method: database-identifier ((name view-class-slot-definition-mixin) &optional database find-class-p)
Source

metaclasses.lisp.

Method: database-identifier ((name standard-db-class) &optional database find-class-p)

the majority of this function is in expressions.lisp
this is here to make loading be less painful (try-recompiles) in SBCL

Source

metaclasses.lisp.

Method: database-identifier (name &optional database find-class-p)

A function that takes whatever you give it, recursively coerces it,
and returns a database-identifier.

(escaped-database-identifiers *any-reasonable-object*) should be called to produce a string that is safe to splice directly into sql strings.

This function should NOT throw errors when database is nil

find-class-p should be T if we want to search for classes
and check their use their view table. Should be used
on symbols we are sure indicate tables

;; metaclasses has further typecases of this, so that it will
;; load less painfully (try-recompiles) in SBCL

Source

expressions.lisp.

Generic Function: database-last-autoincrement-id (database table column)

Many databases have the notion of an auto-increment
id; i.e. a sequence implicitly on a table. This function should return that ID.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Reader: database-odbc-db-type (object)
Package

clsql-sys.

Methods
Reader Method: database-odbc-db-type ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

odbc-db-type.

Generic Writer: (setf database-odbc-db-type) (object)
Package

clsql-sys.

Methods
Writer Method: (setf database-odbc-db-type) ((generic-odbc-database generic-odbc-database))

automatically generated writer method

Source

generic-odbc.lisp.

Target Slot

odbc-db-type.

Generic Function: database-output-sql (expr database)

Returns an SQL string appropriate for DATABASE
and corresponding to the lisp expression
EXPR. DATABASE-OUTPUT-SQL is called by OUTPUT-SQL when no more specific method exists for EXPR.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-output-sql ((tee (eql t)) (database generic-odbc-database))
Source

generic-odbc.lisp.

Method: database-output-sql (thing database)
Source

expressions.lisp.

Method: database-output-sql ((self duration) database)
Source

expressions.lisp.

Method: database-output-sql ((self date) database)
Source

expressions.lisp.

Method: database-output-sql ((self wall-time) database)
Source

expressions.lisp.

Method: database-output-sql ((arg vector) database)
Source

expressions.lisp.

Method: database-output-sql ((arg list) database)
Source

expressions.lisp.

Method: database-output-sql ((num number) database)
Source

expressions.lisp.

Method: database-output-sql ((tee (eql t)) database)
Source

expressions.lisp.

Method: database-output-sql ((sym symbol) database)
Source

expressions.lisp.

Method: database-output-sql ((str string) database)
Source

expressions.lisp.

Generic Function: database-pkey-constraint (class database)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-pkey-constraint ((class standard-db-class) database)
Source

ooddl.lisp.

Generic Function: database-remove-autoincrement-sequence (class database)

If a database needs to add a sequence for its
autoincrement to work, this is where it should go. Default is that it doesnt so just return nil

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-remove-autoincrement-sequence ((table standard-db-class) (database generic-postgresql-database))
Source

generic-postgresql.lisp.

Method: database-remove-autoincrement-sequence (class database)
Generic Function: database-rename-attribute (table oldatt newname database)

Rename the attribute in the table to NEWNAME.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-rename-attribute (table oldatt newname (database database))
Method: database-rename-attribute (table oldatt newname database)
Generic Function: database-start-transaction (database)

Start a transaction in DATABASE.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-start-transaction ((database database))
Source

transaction.lisp.

Method: database-start-transaction :before ((database database))
Method: database-start-transaction (database)
Generic Function: database-translate-constraint (constraint database)

Given a column constraint returns its
database-specific name. For example, auto-increment constraints can have different names in different database engines.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: database-translate-constraint (constraint database)
Source

expressions.lisp.

Generic Function: database-truncate (database)

Remove all data from database.

Package

clsql-sys.

Source

db-interface.lisp.

Methods
Method: database-truncate (database)
Generic Reader: database-view-classes (object)
Package

clsql-sys.

Methods
Reader Method: database-view-classes ((database database))

automatically generated reader method

Source

base-classes.lisp.

Target Slot

view-classes.

Generic Writer: (setf database-view-classes) (object)
Package

clsql-sys.

Methods
Writer Method: (setf database-view-classes) ((database database))

automatically generated writer method

Source

base-classes.lisp.

Target Slot

view-classes.

Generic Reader: db-value (object)
Package

clsql-sys.

Methods
Reader Method: db-value ((attribute-value-pair attribute-value-pair))

automatically generated reader method

Source

fdml.lisp.

Target Slot

db-value.

Generic Writer: (setf db-value) (object)
Package

clsql-sys.

Methods
Writer Method: (setf db-value) ((attribute-value-pair attribute-value-pair))

automatically generated writer method

Source

fdml.lisp.

Target Slot

db-value.

Generic Reader: dbi-package (object)
Package

clsql-sys.

Methods
Reader Method: dbi-package ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

dbi-package.

Generic Reader: disconnect-fn (object)
Package

clsql-sys.

Methods
Reader Method: disconnect-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

disconnect-fn.

Generic Function: escaped (object)
Package

clsql-sys.

Methods
Method: escaped ((it null))
Source

expressions.lisp.

Reader Method: escaped ((%database-identifier %database-identifier))

automatically generated reader method

Source

expressions.lisp.

Target Slot

escaped.

Generic Writer: (setf escaped) (object)
Package

clsql-sys.

Methods
Writer Method: (setf escaped) ((%database-identifier %database-identifier))

automatically generated writer method

Source

expressions.lisp.

Target Slot

escaped.

Generic Reader: expected-type (condition)
Generic Writer: (setf expected-type) (condition)
Package

clsql-sys.

Methods
Reader Method: expected-type ((condition sql-value-conversion-error))
Writer Method: (setf expected-type) ((condition sql-value-conversion-error))
Source

conditions.lisp.

Target Slot

expected-type.

Generic Reader: fetch-row-fn (object)
Package

clsql-sys.

Methods
Reader Method: fetch-row-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

fetch-row.

Generic Reader: free-connections (object)
Package

clsql-sys.

Methods
Reader Method: free-connections ((conn-pool conn-pool))

automatically generated reader method

Source

pool.lisp.

Target Slot

free-connections.

Generic Writer: (setf free-connections) (object)
Package

clsql-sys.

Methods
Writer Method: (setf free-connections) ((conn-pool conn-pool))

automatically generated writer method

Source

pool.lisp.

Target Slot

free-connections.

Generic Function: get-slot-value-from-record (instance slot &key database)
Package

clsql-sys.

Methods
Method: get-slot-value-from-record ((instance standard-db-object) slot &key database)
Source

oodml.lisp.

Generic Function: get-slot-values-from-view (obj slotdeflist values)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: get-slot-values-from-view (obj slotdeflist values)

Used to copy values from the database into the object used by things like find-all and select

Source

oodml.lisp.

Generic Reader: has-table-pg_roles (object)
Package

clsql-sys.

Methods
Reader Method: has-table-pg_roles ((generic-postgresql-database generic-postgresql-database))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

has-table-pg_roles.

Generic Reader: id (object)
Package

clsql-sys.

Methods
Reader Method: id ((postgresql-stmt postgresql-stmt))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

id.

Generic Reader: key-slots (object)
Package

clsql-sys.

Methods
Reader Method: key-slots ((standard-db-class standard-db-class))

automatically generated reader method

Source

metaclasses.lisp.

Target Slot

key-slots.

Generic Writer: (setf key-slots) (object)
Package

clsql-sys.

Methods
Writer Method: (setf key-slots) ((standard-db-class standard-db-class))

automatically generated writer method

Source

metaclasses.lisp.

Target Slot

key-slots.

Generic Function: key-value-from-db (slotdef value database)
Package

clsql-sys.

Source

generics.lisp.

Methods
Method: key-value-from-db (slotdef value database)

TODO: is this deprecated? there are no uses anywhere in clsql

Source

oodml.lisp.

Generic Reader: list-all-database-tables-fn (object)
Package

clsql-sys.

Methods
Reader Method: list-all-database-tables-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

list-all-database-tables-fn.

Generic Reader: list-all-table-columns-fn (object)
Package

clsql-sys.

Methods
Reader Method: list-all-table-columns-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

list-all-table-columns-fn.

Generic Reader: normalizedp (object)
Package

clsql-sys.

Methods
Reader Method: normalizedp ((standard-db-class standard-db-class))

automatically generated reader method

Source

metaclasses.lisp.

Target Slot

normalizedp.

Generic Writer: (setf normalizedp) (object)
Package

clsql-sys.

Methods
Writer Method: (setf normalizedp) ((standard-db-class standard-db-class))

automatically generated writer method

Source

metaclasses.lisp.

Target Slot

normalizedp.

Generic Reader: object-definition (object)
Package

clsql-sys.

Methods
Reader Method: object-definition ((standard-db-class standard-db-class))

automatically generated reader method

Source

metaclasses.lisp.

Target Slot

definition.

Generic Writer: (setf object-definition) (object)
Package

clsql-sys.

Methods
Writer Method: (setf object-definition) ((standard-db-class standard-db-class))

automatically generated writer method

Source

metaclasses.lisp.

Target Slot

definition.

Generic Reader: odbc-conn (object)
Package

clsql-sys.

Methods
Reader Method: odbc-conn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

odbc-conn.

Generic Writer: (setf odbc-conn) (object)
Package

clsql-sys.

Methods
Writer Method: (setf odbc-conn) ((generic-odbc-database generic-odbc-database))

automatically generated writer method

Source

generic-odbc.lisp.

Target Slot

odbc-conn.

Generic Function: oid (object)

Return the unique ID of a database object.

Package

clsql-sys.

Source

db-interface.lisp.

Generic Function: output-sql (expr database)

Writes an SQL string appropriate for DATABASE
and corresponding to the lisp expression EXPR to *SQL-STREAM*. The function SQL-OUTPUT is a top-level call for generating SQL strings which initialises *SQL-STREAM*, calls OUTPUT-SQL and reads the generated SQL string from *SQL-STREAM*.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: output-sql ((exp sql-escape-string-exp) database)
Source

expressions.lisp.

Method: output-sql ((stmt sql-create-view) database)
Source

expressions.lisp.

Method: output-sql ((stmt sql-create-table) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-update) database)
Source

expressions.lisp.

Method: output-sql ((stmt sql-delete) database)
Source

expressions.lisp.

Method: output-sql ((ins sql-insert) database)
Source

expressions.lisp.

Method: output-sql ((query sql-object-query) database)
Source

expressions.lisp.

Method: output-sql ((query sql-query) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-set-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-query-modifier-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-between-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-function-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-typecast-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-value-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-assignment-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-upcase-like) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-relational-exp) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-ident-attribute) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-ident-table) database)
Source

expressions.lisp.

Method: output-sql ((expr sql-ident) database)
Source

expressions.lisp.

Method: output-sql ((expr %database-identifier) database)
Source

expressions.lisp.

Method: output-sql ((expr sql) database)
Source

expressions.lisp.

Method: output-sql ((expr %sql-expression) database)
Source

expressions.lisp.

Method: output-sql :around (sql database)
Source

expressions.lisp.

Method: output-sql (expr database)
Source

expressions.lisp.

Generic Function: output-sql-hash-key (expr database)

Returns a list (or other object suitable for
use as the key of an EQUAL hash table) which uniquely identifies the arguments EXPR and DATABASE.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: output-sql-hash-key ((arg vector) database)
Source

expressions.lisp.

Method: output-sql-hash-key ((expr sql-ident-table) database)
Source

expressions.lisp.

Method: output-sql-hash-key ((expr sql-ident-attribute) database)
Source

expressions.lisp.

Method: output-sql-hash-key (expr database)
Source

expressions.lisp.

Generic Reader: pool-database-type (object)
Package

clsql-sys.

Methods
Reader Method: pool-database-type ((conn-pool conn-pool))

automatically generated reader method

Source

pool.lisp.

Target Slot

database-type.

Generic Writer: (setf pool-database-type) (object)
Package

clsql-sys.

Methods
Writer Method: (setf pool-database-type) ((conn-pool conn-pool))

automatically generated writer method

Source

pool.lisp.

Target Slot

database-type.

Generic Reader: previous-autocommit (object)
Package

clsql-sys.

Methods
Reader Method: previous-autocommit ((transaction transaction))

automatically generated reader method

Source

transaction.lisp.

Target Slot

previous-autocommit.

Generic Function: primary-key-slot-values (obj &key class slots)
Package

clsql-sys.

Methods
Method: primary-key-slot-values ((obj standard-db-object) &key class slots)

Returns the values of all key-slots for a given class

Source

oodml.lisp.

Generic Reader: result-types (object)
Package

clsql-sys.

Methods
Reader Method: result-types ((postgresql-stmt postgresql-stmt))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

result-types.

Generic Reader: rollback-hooks (object)
Package

clsql-sys.

Methods
Reader Method: rollback-hooks ((transaction transaction))

automatically generated reader method

Source

transaction.lisp.

Target Slot

rollback-hooks.

Generic Writer: (setf rollback-hooks) (object)
Package

clsql-sys.

Methods
Writer Method: (setf rollback-hooks) ((transaction transaction))

automatically generated writer method

Source

transaction.lisp.

Target Slot

rollback-hooks.

Generic Function: select-table-sql-expr (table)
Package

clsql-sys.

Methods
Method: select-table-sql-expr (table)

Turns an object representing a table into the :from part of the sql expression that will be executed

Source

oodml.lisp.

Generic Reader: slot-defs (object)
Package

clsql-sys.

Methods
Reader Method: slot-defs ((class-and-slots class-and-slots))

automatically generated reader method

Source

oodml.lisp.

Target Slot

slot-defs.

Generic Writer: (setf slot-defs) (object)
Package

clsql-sys.

Methods
Writer Method: (setf slot-defs) ((class-and-slots class-and-slots))

automatically generated writer method

Source

oodml.lisp.

Target Slot

slot-defs.

Generic Reader: specified-type (object)
Generic Writer: (setf specified-type) (object)
Package

clsql-sys.

Methods
Reader Method: specified-type ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf specified-type) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

Internal slot storing the :type specified by user.

Source

metaclasses.lisp.

Target Slot

specified-type.

Generic Reader: sql-fn (object)
Package

clsql-sys.

Methods
Reader Method: sql-fn ((generic-odbc-database generic-odbc-database))

automatically generated reader method

Source

generic-odbc.lisp.

Target Slot

sql-fn.

Generic Function: sql-table (o)
Package

clsql-sys.

Methods
Method: sql-table ((o select-list))
Source

oodml.lisp.

Generic Reader: sql-warning-message (condition)
Package

clsql-sys.

Methods
Reader Method: sql-warning-message ((condition sql-warning))
Source

conditions.lisp.

Target Slot

message.

Generic Reader: stmt-field-names (object)
Package

clsql-sys.

Methods
Reader Method: stmt-field-names ((postgresql-stmt postgresql-stmt))

automatically generated reader method

Source

generic-postgresql.lisp.

Target Slot

field-names.

Generic Writer: (setf stmt-field-names) (object)
Package

clsql-sys.

Methods
Writer Method: (setf stmt-field-names) ((postgresql-stmt postgresql-stmt))

automatically generated writer method

Source

generic-postgresql.lisp.

Target Slot

field-names.

Generic Function: to-string (val &rest keys)
Package

clsql-sys.

Source

time.lisp.

Methods
Method: to-string ((time wall-time) &rest keys)
Generic Reader: transaction-status (object)
Generic Writer: (setf transaction-status) (object)
Package

clsql-sys.

Methods
Reader Method: transaction-status ((transaction transaction))
Writer Method: (setf transaction-status) ((transaction transaction))

nil or :committed

Source

transaction.lisp.

Target Slot

status.

Generic Function: unescaped (object)
Package

clsql-sys.

Methods
Method: unescaped ((it null))
Source

expressions.lisp.

Reader Method: unescaped ((%database-identifier %database-identifier))

automatically generated reader method

Source

expressions.lisp.

Target Slot

unescaped.

Generic Writer: (setf unescaped) (object)
Package

clsql-sys.

Methods
Writer Method: (setf unescaped) ((%database-identifier %database-identifier))

automatically generated writer method

Source

expressions.lisp.

Target Slot

unescaped.

Generic Function: update-slot-default-values (obj classes-and-slots)
Package

clsql-sys.

Methods
Method: update-slot-default-values ((obj standard-db-object) classes-and-slots)

Makes sure that if a class has unfilled slots that claim to have a default, that we retrieve those defaults from the database

TODO: use update-slots-from-record (doesnt exist) instead to batch this!

Source

oodml.lisp.

Generic Function: update-slot-from-db (instance slotdef val)
Package

clsql-sys.

Source

generics.lisp.

Generic Function: update-slot-from-db-value (instance slotdef value)
Package

clsql-sys.

Methods
Method: update-slot-from-db-value ((instance standard-db-object) slotdef value)

This gets a value from the database and turns it itno a lisp value based on the slot’s slot-db-reader or baring that read-sql-value

Source

oodml.lisp.

Generic Function: update-slot-with-null (instance slotdef)

Called to update a slot when its column has a NULL
value. If nulls are allowed for the column, the slot’s value will be nil, otherwise its value will be set to the result of calling DATABASE-NULL-VALUE on the type of the slot.

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: update-slot-with-null ((object standard-db-object) slotdef)

sets a slot to the void value of the slot-def (usually nil)

Source

oodml.lisp.

Generic Reader: value (condition)
Generic Writer: (setf value) (condition)
Package

clsql-sys.

Methods
Reader Method: value ((condition sql-value-conversion-error))
Writer Method: (setf value) ((condition sql-value-conversion-error))
Source

conditions.lisp.

Target Slot

value.

Generic Reader: view-class (object)
Package

clsql-sys.

Methods
Reader Method: view-class ((select-list select-list))

automatically generated reader method

Source

oodml.lisp.

Target Slot

view-class.

Reader Method: view-class ((class-and-slots class-and-slots))

automatically generated reader method

Source

oodml.lisp.

Target Slot

view-class.

Generic Writer: (setf view-class) (object)
Package

clsql-sys.

Methods
Writer Method: (setf view-class) ((select-list select-list))

automatically generated writer method

Source

oodml.lisp.

Target Slot

view-class.

Writer Method: (setf view-class) ((class-and-slots class-and-slots))

automatically generated writer method

Source

oodml.lisp.

Target Slot

view-class.

Generic Reader: view-class-qualifier (object)
Package

clsql-sys.

Methods
Reader Method: view-class-qualifier ((standard-db-class standard-db-class))

automatically generated reader method

Source

metaclasses.lisp.

Target Slot

class-qualifier.

Generic Writer: (setf view-class-qualifier) (object)
Package

clsql-sys.

Methods
Writer Method: (setf view-class-qualifier) ((standard-db-class standard-db-class))

automatically generated writer method

Source

metaclasses.lisp.

Target Slot

class-qualifier.

Generic Reader: view-class-slot-autoincrement-sequence (object)
Generic Writer: (setf view-class-slot-autoincrement-sequence) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-autoincrement-sequence ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-autoincrement-sequence) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

A string naming the (possibly automatically generated) sequence for a slot with an :auto-increment constraint.

Source

metaclasses.lisp.

Target Slot

autoincrement-sequence.

Generic Reader: view-class-slot-column (object)
Generic Writer: (setf view-class-slot-column) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-column ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-column) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

The name of the SQL column this slot is stored in. Defaults to the slot name.

Source

metaclasses.lisp.

Target Slot

column.

Generic Reader: view-class-slot-db-constraints (object)
Generic Writer: (setf view-class-slot-db-constraints) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-constraints ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-constraints) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

A keyword symbol representing a single SQL column constraint or list of such symbols.

Source

metaclasses.lisp.

Target Slot

db-constraints.

Generic Reader: view-class-slot-db-info (object)
Generic Writer: (setf view-class-slot-db-info) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-info ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-info) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

Description of the join.

Source

metaclasses.lisp.

Target Slot

db-info.

Generic Reader: view-class-slot-db-kind (object)
Generic Writer: (setf view-class-slot-db-kind) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-kind ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-kind) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

The kind of DB mapping which is performed for this slot. :base indicates the slot maps to an ordinary column of the DB view. :key indicates that this slot corresponds to part of the unique keys for this view, :join indicates ... and :virtual indicates that this slot is an ordinary CLOS slot. Defaults to :base.

Source

metaclasses.lisp.

Target Slot

db-kind.

Generic Reader: view-class-slot-db-reader (object)
Generic Writer: (setf view-class-slot-db-reader) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-reader ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-reader) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

If a string, then when reading values from the DB, the string will be used for a format string, with the only value being the value from the database. The resulting string will be used as the slot value. If a function then it will take one argument, the value from the database, and return the value that should be put into the slot.

Source

metaclasses.lisp.

Target Slot

db-reader.

Generic Reader: view-class-slot-db-type (object)
Generic Writer: (setf view-class-slot-db-type) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-type ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-type) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

A string which will be used as the type specifier for this slots column definition in the database.

Source

metaclasses.lisp.

Target Slot

db-type.

Generic Reader: view-class-slot-db-writer (object)
Generic Writer: (setf view-class-slot-db-writer) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-db-writer ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-db-writer) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

If a string, then when reading values from the slot for the DB, the string will be used for a format string, with the only value being the value of the slot. The resulting string will be used as the column value in the DB. If a function then it will take one argument, the value of the slot, and return the value that should be put into the database.

Source

metaclasses.lisp.

Target Slot

db-writer.

Generic Reader: view-class-slot-void-value (object)
Generic Writer: (setf view-class-slot-void-value) (object)
Package

clsql-sys.

Methods
Reader Method: view-class-slot-void-value ((view-class-slot-definition-mixin view-class-slot-definition-mixin))
Writer Method: (setf view-class-slot-void-value) ((view-class-slot-definition-mixin view-class-slot-definition-mixin))

Value to store if the SQL value is NULL. Default is NIL.

Source

metaclasses.lisp.

Target Slot

void-value.

Generic Function: view-classes-and-slots-by-name (obj slots-to-match)
Package

clsql-sys.

Methods
Method: view-classes-and-slots-by-name ((obj standard-db-object) slots-to-match)

If it’s normalized, find the class that actually contains the slot that’s tied to the db,

otherwise just search the current class

Source

oodml.lisp.

Generic Function: view-classes-and-storable-slots (view-class &key to-database-p)

A method that collects all the classes and storable slots
that need to be read from or written to the database.
to-database-p should be T if we are writing this object to the database and nil when we are reading this object from the database

Package

clsql-sys.

Source

generics.lisp.

Methods
Method: view-classes-and-storable-slots (class &key to-database-p)

Get a list of all the tables we need to update and the slots on them

for non normalized classes we return the class and all its storable slots

for normalized classes we return a list of direct slots and the class they came from for each normalized view class

to-database-p is provided so that we can read / write different data to the database in different circumstances
(specifically clsql-helper:dirty-db-slots-mixin which only updates slots that have changed )

Source

oodml.lisp.

Generic Reader: view-database (object)
Package

clsql-sys.

Methods
Reader Method: view-database ((standard-db-object standard-db-object))

automatically generated reader method

Source

ooddl.lisp.

Target Slot

view-database.

Generic Function: view-table-exp (o)
Package

clsql-sys.

Methods
Method: view-table-exp ((o standard-db-class))
Source

oodml.lisp.

Method: view-table-exp ((o class-and-slots))
Source

oodml.lisp.


6.2.5 Conditions

Condition: database-too-strange

Used to signal cases where CLSQL is going to fail at mapping your database correctly

Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

sql-user-error.

Condition: iso-8601-syntax-error
Package

clsql-sys.

Source

time.lisp.

Direct superclasses

sql-user-error.

Direct methods

bad-component.

Direct slots
Slot: bad-component
Initargs

:bad-component

Readers

bad-component.

Writers

This slot is read-only.

Condition: sql-value-conversion-error
Package

clsql-sys.

Source

conditions.lisp.

Direct superclasses

error.

Direct methods
Direct slots
Slot: expected-type
Initform

(quote nil)

Initargs

:expected-type

Readers

expected-type.

Writers

(setf expected-type).

Slot: value
Initform

(quote nil)

Initargs

:value

Readers

value.

Writers

(setf value).

Slot: database
Initform

(quote nil)

Initargs

:database

Readers

database.

Writers

(setf database).


6.2.6 Structures

Structure: interval
Package

clsql-sys.

Source

time.lisp.

Direct superclasses

structure-object.

Direct slots
Slot: start
Readers

interval-start.

Writers

(setf interval-start).

Slot: end
Readers

interval-end.

Writers

(setf interval-end).

Slot: name
Readers

interval-name.

Writers

(setf interval-name).

Slot: contained
Readers

interval-contained.

Writers

(setf interval-contained).

Slot: type
Package

common-lisp.

Readers

interval-type.

Writers

(setf interval-type).

Slot: data
Readers

interval-data.

Writers

(setf interval-data).

Structure: odbc-result-set
Package

clsql-sys.

Source

generic-odbc.lisp.

Direct superclasses

structure-object.

Direct slots
Slot: query
Readers

odbc-result-set-query.

Writers

(setf odbc-result-set-query).

Slot: types
Readers

odbc-result-set-types.

Writers

(setf odbc-result-set-types).

Slot: full-set
Type

boolean

Readers

odbc-result-set-full-set.

Writers

(setf odbc-result-set-full-set).


6.2.7 Classes

Class: %database-identifier

A database identifier represents a string/symbol ready to be spliced
into a sql string. It keeps references to both the escaped and unescaped versions so that unescaped versions can be compared to the results of list-tables/views/attributes etc. It also allows you to be sure that an identifier is escaped only once.

(escaped-database-identifiers *any-reasonable-object*) should be called to produce a string that is safe to splice directly into sql strings.

(unescaped-database-identifier *any-reasonable-object*) is generally what you pass to it with the exception that symbols have been clsql-sys:sql-escape which converts to a string and changes - to _ (so that unescaped can be compared to the results of eg: list-tables)

Package

clsql-sys.

Source

expressions.lisp.

Direct methods
Direct slots
Slot: escaped
Initargs

:escaped

Readers

escaped.

Writers

(setf escaped).

Slot: unescaped
Initargs

:unescaped

Readers

unescaped.

Writers

(setf unescaped).

Class: %slot-order-test-class
Package

clsql-sys.

Source

kmr-mop.lisp.

Direct slots
Slot: a
Slot: b
Class: %sql-expression
Package

clsql-sys.

Source

expressions.lisp.

Direct subclasses
Direct methods
Class: attribute-value-pair

Represents an attribute-sql-expression and its value, used to pass to insert/update. Was previously a two list

Package

clsql-sys.

Source

fdml.lisp.

Direct methods
Direct slots
Slot: attribute
Initargs

:attribute

Readers

attribute.

Writers

(setf attribute).

Slot: db-value
Initargs

:db-value

Readers

db-value.

Writers

(setf db-value).

Class: class-and-slots

A helper class to keep track of which slot-defs from a
table need to be updated, a normalized class might have many of these because each of its parent classes might represent some other table and we need to match which slots came from which parent class/table

Package

clsql-sys.

Source

oodml.lisp.

Direct methods
Direct slots
Slot: view-class
Initargs

:view-class

Readers

view-class.

Writers

(setf view-class).

Slot: slot-defs
Initargs

:slot-defs

Readers

slot-defs.

Writers

(setf slot-defs).

Class: generic-database

Encapsulate same behavior across backends.

Package

clsql-sys.

Source

sequences.lisp.

Direct superclasses

database.

Class: postgresql-stmt
Package

clsql-sys.

Source

generic-postgresql.lisp.

Direct methods
Direct slots
Slot: database
Initargs

:database

Readers

database.

Writers

This slot is read-only.

Slot: id
Initargs

:id

Readers

id.

Writers

This slot is read-only.

Slot: bindings
Initargs

:bindings

Readers

bindings.

Writers

This slot is read-only.

Slot: field-names
Initargs

:field-names

Readers

stmt-field-names.

Writers

(setf stmt-field-names).

Slot: result-types
Initargs

:result-types

Readers

result-types.

Writers

This slot is read-only.

Class: sql-create-table

An SQL CREATE TABLE statement.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: name
Initargs

:name

Slot: columns
Initargs

:columns

Slot: modifiers
Initargs

:modifiers

Slot: transactions
Initargs

:transactions

Class: sql-create-view

An SQL CREATE VIEW statement.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: name
Initargs

:name

Slot: column-list
Initargs

:column-list

Slot: query
Initargs

:query

Slot: with-check-option
Initargs

:with-check-option

Class: sql-delete

An SQL DELETE statement.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: from
Initargs

:from

Slot: where
Initargs

:where

Class: sql-escape-string-exp

An escaped string string expression (postgresql E’stuff’) .

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: string
Package

common-lisp.

Initargs

:string

Class: sql-insert

An SQL INSERT statement.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: into
Initargs

:into

Slot: attributes
Initargs

:attributes

Slot: values
Package

common-lisp.

Initargs

:values

Slot: query
Initargs

:query

Class: sql-update

An SQL UPDATE statement.

Package

clsql-sys.

Source

expressions.lisp.

Direct superclasses

%sql-expression.

Direct methods

output-sql.

Direct slots
Slot: table
Initargs

:table

Slot: attributes
Initargs

:attributes

Slot: values
Package

common-lisp.

Initargs

:values

Slot: where
Initargs

:where

Class: standard-db-class

Metaclass for all CLSQL View Classes.

Package

clsql-sys.

Source

metaclasses.lisp.

Direct superclasses

standard-class.

Direct methods
Direct slots
Slot: view-table
Initargs

:view-table

Readers

view-table.

Writers

(setf view-table).

Slot: definition
Initargs

:definition

Readers

object-definition.

Writers

(setf object-definition).

Slot: key-slots
Readers

key-slots.

Writers

(setf key-slots).

Slot: normalizedp
Readers

normalizedp.

Writers

(setf normalizedp).

Slot: class-qualifier
Initargs

:qualifier

Readers

view-class-qualifier.

Writers

(setf view-class-qualifier).

Class: view-class-direct-slot-definition
Package

clsql-sys.

Source

metaclasses.lisp.

Direct superclasses
Direct methods
Class: view-class-effective-slot-definition
Package

clsql-sys.

Source

metaclasses.lisp.

Direct superclasses
Class: view-class-slot-definition-mixin
Package

clsql-sys.

Source

metaclasses.lisp.

Direct subclasses
Direct methods
Direct slots
Slot: column

The name of the SQL column this slot is stored in. Defaults to the slot name.

Initargs

:column

Readers

view-class-slot-column.

Writers

(setf view-class-slot-column).

Slot: db-kind

The kind of DB mapping which is performed for this slot. :base indicates the slot maps to an ordinary column of the DB view. :key indicates that this slot corresponds to part of the unique keys for this view, :join indicates ... and :virtual indicates that this slot is an ordinary CLOS slot. Defaults to :base.

Type

keyword

Initform

:base

Initargs

:db-kind

Readers

view-class-slot-db-kind.

Writers

(setf view-class-slot-db-kind).

Slot: db-reader

If a string, then when reading values from the DB, the string will be used for a format string, with the only value being the value from the database. The resulting string will be used as the slot value. If a function then it will take one argument, the value from the database, and return the value that should be put into the slot.

Initargs

:db-reader

Readers

view-class-slot-db-reader.

Writers

(setf view-class-slot-db-reader).

Slot: db-writer

If a string, then when reading values from the slot for the DB, the string will be used for a format string, with the only value being the value of the slot. The resulting string will be used as the column value in the DB. If a function then it will take one argument, the value of the slot, and return the value that should be put into the database.

Initargs

:db-writer

Readers

view-class-slot-db-writer.

Writers

(setf view-class-slot-db-writer).

Slot: db-type

A string which will be used as the type specifier for this slots column definition in the database.

Initargs

:db-type

Readers

view-class-slot-db-type.

Writers

(setf view-class-slot-db-type).

Slot: db-constraints

A keyword symbol representing a single SQL column constraint or list of such symbols.

Initargs

:db-constraints

Readers

view-class-slot-db-constraints.

Writers

(setf view-class-slot-db-constraints).

Slot: void-value

Value to store if the SQL value is NULL. Default is NIL.

Initargs

:void-value

Readers

view-class-slot-void-value.

Writers

(setf view-class-slot-void-value).

Slot: db-info

Description of the join.

Initargs

:db-info

Readers

view-class-slot-db-info.

Writers

(setf view-class-slot-db-info).

Slot: specified-type

Internal slot storing the :type specified by user.

Initargs

clsql-sys::specified-type

Readers

specified-type.

Writers

(setf specified-type).

Slot: autoincrement-sequence

A string naming the (possibly automatically generated) sequence for a slot with an :auto-increment constraint.

Initargs

:autoincrement-sequence

Readers

view-class-slot-autoincrement-sequence.

Writers

(setf view-class-slot-autoincrement-sequence).


Appendix A Indexes


A.1 Concepts


A.2 Functions

Jump to:   %   (  
A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W  
Index Entry  Section

%
%clsql-subclauses: Private ordinary functions
%command-output: Private ordinary functions
%convert-db-info-to-hash: Private ordinary functions
%database-list-*: Private ordinary functions
%disable-sql-reader-syntax: Private ordinary functions
%enable-sql-reader-syntax: Private ordinary functions
%get-int: Private ordinary functions
%install-class: Private generic functions
%install-class: Private generic functions
%make-database-identifier: Private ordinary functions
%make-date: Private ordinary functions
%make-duration: Private ordinary functions
%make-wall-time: Private ordinary functions
%object-joins-from-list: Private ordinary functions
%pool-force-disconnect: Private ordinary functions
%print-date: Private ordinary functions
%print-duration: Private ordinary functions
%print-wall-time: Private ordinary functions
%seq-name-key: Private ordinary functions
%sequence-name-to-table: Private ordinary functions
%svuc-slot-name: Private ordinary functions
%svuc-slot-object: Private ordinary functions
%table-exists-p: Private generic functions
%table-exists-p: Private generic functions
%table-name-to-sequence-name: Private ordinary functions
%tables-for-query: Private ordinary functions
%time<: Private ordinary functions
%time<=: Private ordinary functions
%time=: Private ordinary functions
%time>: Private ordinary functions
%time>=: Private ordinary functions
%uninstall-class: Private ordinary functions
%update-instance-helper: Private generic functions
%update-instance-helper: Private generic functions
%update-objects-joins-slot-defs: Private ordinary functions
%write-operator: Private ordinary functions

(
(setf all-connections): Private generic functions
(setf all-connections): Private generic functions
(setf attribute): Private generic functions
(setf attribute): Private generic functions
(setf attribute-cache): Public generic functions
(setf attribute-cache): Public generic functions
(setf command-recording-stream): Public generic functions
(setf command-recording-stream): Public generic functions
(setf commit-hooks): Private generic functions
(setf commit-hooks): Private generic functions
(setf conn-pool): Public generic functions
(setf conn-pool): Public generic functions
(setf conn-pool-lock): Private generic functions
(setf conn-pool-lock): Private generic functions
(setf connection-spec): Public generic functions
(setf connection-spec): Public generic functions
(setf database): Public generic functions
(setf database): Public generic functions
(setf database-autocommit): Public generic functions
(setf database-autocommit): Public generic functions
(setf database-odbc-db-type): Private generic functions
(setf database-odbc-db-type): Private generic functions
(setf database-view-classes): Private generic functions
(setf database-view-classes): Private generic functions
(setf date-mjd): Public ordinary functions
(setf db-value): Private generic functions
(setf db-value): Private generic functions
(setf duration-day): Public ordinary functions
(setf duration-hour): Public ordinary functions
(setf duration-minute): Public ordinary functions
(setf duration-month): Public ordinary functions
(setf duration-second): Public ordinary functions
(setf duration-usec): Private ordinary functions
(setf duration-year): Public ordinary functions
(setf easy-slot-value): Private ordinary functions
(setf encoding): Public ordinary functions
(setf escaped): Private generic functions
(setf escaped): Private generic functions
(setf expected-type): Private generic functions
(setf expected-type): Private generic functions
(setf expression): Public generic functions
(setf expression): Public generic functions
(setf free-connections): Private generic functions
(setf free-connections): Private generic functions
(setf has-been-prepared): Public generic functions
(setf has-been-prepared): Public generic functions
(setf interval-contained): Public ordinary functions
(setf interval-data): Public ordinary functions
(setf interval-end): Public ordinary functions
(setf interval-name): Private ordinary functions
(setf interval-start): Public ordinary functions
(setf interval-type): Public ordinary functions
(setf join-slots): Public generic functions
(setf join-slots): Public generic functions
(setf joins): Public generic functions
(setf joins): Public generic functions
(setf key-slots): Private generic functions
(setf key-slots): Private generic functions
(setf normalizedp): Private generic functions
(setf normalizedp): Private generic functions
(setf object-definition): Private generic functions
(setf object-definition): Private generic functions
(setf odbc-conn): Private generic functions
(setf odbc-conn): Private generic functions
(setf odbc-result-set-full-set): Private ordinary functions
(setf odbc-result-set-query): Private ordinary functions
(setf odbc-result-set-types): Private ordinary functions
(setf parameters): Public generic functions
(setf parameters): Public generic functions
(setf pool-database-type): Private generic functions
(setf pool-database-type): Private generic functions
(setf prepared-name): Public generic functions
(setf prepared-name): Public generic functions
(setf record-caches): Public generic functions
(setf record-caches): Public generic functions
(setf records-cache-results): Private ordinary functions
(setf result-recording-stream): Public generic functions
(setf result-recording-stream): Public generic functions
(setf rollback-hooks): Private generic functions
(setf rollback-hooks): Private generic functions
(setf select-list): Public generic functions
(setf select-list): Public generic functions
(setf slot-defs): Private generic functions
(setf slot-defs): Private generic functions
(setf slot-list): Public generic functions
(setf slot-list): Public generic functions
(setf slot-value-using-class): Public standalone methods
(setf specified-type): Private generic functions
(setf specified-type): Private generic functions
(setf stmt-field-names): Private generic functions
(setf stmt-field-names): Private generic functions
(setf time-mjd): Public ordinary functions
(setf time-second): Private ordinary functions
(setf time-usec): Private ordinary functions
(setf transaction): Public generic functions
(setf transaction): Public generic functions
(setf transaction-level): Public generic functions
(setf transaction-level): Public generic functions
(setf transaction-status): Private generic functions
(setf transaction-status): Private generic functions
(setf unescaped): Private generic functions
(setf unescaped): Private generic functions
(setf value): Private generic functions
(setf value): Private generic functions
(setf view-class): Private generic functions
(setf view-class): Private generic functions
(setf view-class): Private generic functions
(setf view-class-qualifier): Private generic functions
(setf view-class-qualifier): Private generic functions
(setf view-class-slot-autoincrement-sequence): Private generic functions
(setf view-class-slot-autoincrement-sequence): Private generic functions
(setf view-class-slot-column): Private generic functions
(setf view-class-slot-column): Private generic functions
(setf view-class-slot-db-constraints): Private generic functions
(setf view-class-slot-db-constraints): Private generic functions
(setf view-class-slot-db-info): Private generic functions
(setf view-class-slot-db-info): Private generic functions
(setf view-class-slot-db-kind): Private generic functions
(setf view-class-slot-db-kind): Private generic functions
(setf view-class-slot-db-reader): Private generic functions
(setf view-class-slot-db-reader): Private generic functions
(setf view-class-slot-db-type): Private generic functions
(setf view-class-slot-db-type): Private generic functions
(setf view-class-slot-db-writer): Private generic functions
(setf view-class-slot-db-writer): Private generic functions
(setf view-class-slot-void-value): Private generic functions
(setf view-class-slot-void-value): Private generic functions
(setf view-table): Public generic functions
(setf view-table): Public generic functions

A
acquire-from-pool: Private ordinary functions
add-sql-stream: Public ordinary functions
add-transaction-commit-hook: Public ordinary functions
add-transaction-rollback-hook: Public ordinary functions
all-connections: Private generic functions
all-connections: Private generic functions
all-home-keys-have-values-p: Private ordinary functions
all-immediate-join-classes-for: Private ordinary functions
attribute: Private generic functions
attribute: Private generic functions
attribute-cache: Public generic functions
attribute-cache: Public generic functions
attribute-references: Private generic functions
attribute-references: Private generic functions
attribute-type: Public ordinary functions
attribute-value-pairs: Private generic functions
attribute-value-pairs: Private generic functions
auto-increment-column-p: Private generic functions
auto-increment-column-p: Private generic functions
auto-increment-sequence-name: Private generic functions
auto-increment-sequence-name: Private generic functions
auto-increment-sequence-name: Private generic functions

B
bad-component: Public generic functions
bad-component: Public generic functions
base-db-class: Private ordinary functions
bind-parameter: Public ordinary functions
binding-to-param: Private ordinary functions
bindings: Private generic functions
bindings: Private generic functions
build-objects: Private ordinary functions

C
cache-table-queries: Public ordinary functions
check-connection-spec: Public macros
check-slot-type: Private ordinary functions
choose-database-for-instance: Private generic functions
choose-database-for-instance: Private generic functions
clear-conn-pool: Private ordinary functions
close-query-fn: Private generic functions
close-query-fn: Private generic functions
clsql-and: Private ordinary functions
clsql-ands: Private ordinary functions
clsql-or: Private ordinary functions
clsql-ors: Private ordinary functions
clsql-type->postgresql-type: Private ordinary functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
collect-table-refs: Private generic functions
combine-database-identifiers: Private ordinary functions
command-object: Public ordinary functions
command-output: Public ordinary functions
command-recording-stream: Public generic functions
command-recording-stream: Public generic functions
commit: Public ordinary functions
commit-hooks: Private generic functions
commit-hooks: Private generic functions
compute-column-name: Private ordinary functions
compute-effective-slot-definition: Public standalone methods
compute-lisp-type-from-specified-type: Private ordinary functions
compute-records-cache-key: Private ordinary functions
compute-slots: Public standalone methods
conn-pool: Public generic functions
conn-pool: Public generic functions
conn-pool-lock: Private generic functions
conn-pool-lock: Private generic functions
connect: Public ordinary functions
connected-databases: Public ordinary functions
connection-spec: Public generic functions
connection-spec: Public generic functions
connection-spec: Public generic functions
convert-to-db-default-case: Public ordinary functions
copy-date: Private ordinary functions
copy-duration: Private ordinary functions
copy-interval: Private ordinary functions
copy-odbc-result-set: Private ordinary functions
copy-time: Private ordinary functions
copy-wall-time: Private ordinary functions
create-database: Public ordinary functions
create-index: Public ordinary functions
create-large-object: Public ordinary functions
create-sequence: Public ordinary functions
create-table: Public ordinary functions
create-view: Public ordinary functions
create-view-from-class: Public ordinary functions
current-day: Public ordinary functions
current-month: Public ordinary functions
current-year: Public ordinary functions

D
database: Public generic functions
database: Public generic functions
database: Public generic functions
database-abort-transaction: Private generic functions
database-abort-transaction: Private generic functions
database-abort-transaction: Private generic functions
database-abort-transaction: Private generic functions
database-acquire-from-conn-pool: Public generic functions
database-acquire-from-conn-pool: Public generic functions
database-add-attribute: Private generic functions
database-add-attribute: Private generic functions
database-add-attribute: Private generic functions
database-add-autoincrement-sequence: Private generic functions
database-add-autoincrement-sequence: Private generic functions
database-add-autoincrement-sequence: Private generic functions
database-attribute-type: Public generic functions
database-attribute-type: Public generic functions
database-attribute-type: Public generic functions
database-attribute-type: Public generic functions
database-attribute-type: Public generic functions
database-autocommit: Public generic functions
database-autocommit: Public generic functions
database-bind-parameter: Public generic functions
database-bind-parameter: Public generic functions
database-bind-parameter: Public generic functions
database-commit-transaction: Private generic functions
database-commit-transaction: Private generic functions
database-commit-transaction: Private generic functions
database-commit-transaction: Private generic functions
database-connect: Public generic functions
database-constraint-statement: Private generic functions
database-constraint-statement: Private generic functions
database-create: Public generic functions
database-create-large-object: Public generic functions
database-create-sequence: Public generic functions
database-create-sequence: Public generic functions
database-create-sequence: Public generic functions
database-delete-large-object: Public generic functions
database-destroy: Public generic functions
database-disconnect: Public generic functions
database-disconnect: Public generic functions
database-disconnect: Public generic functions
database-disconnect: Public generic functions
database-drop-sequence: Public generic functions
database-drop-sequence: Public generic functions
database-drop-sequence: Public generic functions
database-dump-result-set: Public generic functions
database-dump-result-set: Public generic functions
database-dump-result-set: Public generic functions
database-dump-result-set: Public generic functions
database-dump-result-set: Public generic functions
database-execute-command: Public generic functions
database-execute-command: Public generic functions
database-execute-command: Public generic functions
database-execute-command: Public generic functions
database-execute-command: Public generic functions
database-free-prepared: Public generic functions
database-free-prepared: Public generic functions
database-generate-column-definition: Private generic functions
database-generate-column-definition: Private generic functions
database-generate-column-definition: Private generic functions
database-get-type-specifier: Public generic functions
database-get-type-specifier: Public generic functions
database-get-type-specifier: Public generic functions
database-get-type-specifier: Public generic functions
database-get-type-specifier: Public generic functions
database-identifier: Private generic functions
database-identifier: Private generic functions
database-identifier: Private generic functions
database-identifier: Private generic functions
database-identifier-equal: Private ordinary functions
database-initialize-database-type: Public generic functions
database-last-auto-increment-id: Public generic functions
database-last-auto-increment-id: Public generic functions
database-last-auto-increment-id: Public generic functions
database-last-autoincrement-id: Private generic functions
database-list: Public generic functions
database-list: Public generic functions
database-list: Public generic functions
database-list: Public generic functions
database-list-attributes: Public generic functions
database-list-attributes: Public generic functions
database-list-attributes: Public generic functions
database-list-attributes: Public generic functions
database-list-attributes: Public generic functions
database-list-indexes: Public generic functions
database-list-indexes: Public generic functions
database-list-indexes: Public generic functions
database-list-indexes: Public generic functions
database-list-objects-of-type: Private ordinary functions
database-list-sequences: Public generic functions
database-list-sequences: Public generic functions
database-list-sequences: Public generic functions
database-list-table-indexes: Public generic functions
database-list-table-indexes: Public generic functions
database-list-table-indexes: Public generic functions
database-list-table-indexes: Public generic functions
database-list-tables: Public generic functions
database-list-tables: Public generic functions
database-list-tables: Public generic functions
database-list-tables: Public generic functions
database-list-tables: Public generic functions
database-list-tables-and-sequences: Public generic functions
database-list-tables-and-sequences: Public generic functions
database-list-tables-and-sequences: Public generic functions
database-list-views: Public generic functions
database-list-views: Public generic functions
database-list-views: Public generic functions
database-list-views: Public generic functions
database-list-views: Public generic functions
database-name: Public generic functions
database-name: Public generic functions
database-name-from-spec: Public generic functions
database-odbc-db-type: Private generic functions
database-odbc-db-type: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql: Private generic functions
database-output-sql-as-type: Public generic functions
database-output-sql-as-type: Public generic functions
database-pkey-constraint: Private generic functions
database-pkey-constraint: Private generic functions
database-prepare: Public generic functions
database-prepare: Public generic functions
database-prepare: Public generic functions
database-prepare: Public generic functions
database-probe: Public generic functions
database-probe: Public generic functions
database-query: Public generic functions
database-query: Public generic functions
database-query: Public generic functions
database-query: Public generic functions
database-query: Public generic functions
database-query-result-set: Public generic functions
database-query-result-set: Public generic functions
database-query-result-set: Public generic functions
database-query-result-set: Public generic functions
database-query-result-set: Public generic functions
database-query-result-set: Public generic functions
database-read-large-object: Public generic functions
database-reconnect: Public generic functions
database-reconnect: Public generic functions
database-release-to-conn-pool: Public generic functions
database-release-to-conn-pool: Public generic functions
database-remove-autoincrement-sequence: Private generic functions
database-remove-autoincrement-sequence: Private generic functions
database-remove-autoincrement-sequence: Private generic functions
database-rename-attribute: Private generic functions
database-rename-attribute: Private generic functions
database-rename-attribute: Private generic functions
database-run-prepared: Public generic functions
database-run-prepared: Public generic functions
database-run-prepared: Public generic functions
database-sequence-last: Public generic functions
database-sequence-last: Public generic functions
database-sequence-last: Public generic functions
database-sequence-next: Public generic functions
database-sequence-next: Public generic functions
database-sequence-next: Public generic functions
database-set-sequence-position: Public generic functions
database-set-sequence-position: Public generic functions
database-set-sequence-position: Public generic functions
database-start-transaction: Private generic functions
database-start-transaction: Private generic functions
database-start-transaction: Private generic functions
database-start-transaction: Private generic functions
database-state: Public generic functions
database-state: Public generic functions
database-store-next-row: Public generic functions
database-store-next-row: Public generic functions
database-store-next-row: Public generic functions
database-store-next-row: Public generic functions
database-store-next-row: Public generic functions
database-translate-constraint: Private generic functions
database-translate-constraint: Private generic functions
database-truncate: Private generic functions
database-truncate: Private generic functions
database-type: Public generic functions
database-type: Public generic functions
database-type-library-loaded: Public generic functions
database-type-load-foreign: Public generic functions
database-type-load-foreign: Public generic functions
database-type-load-foreign: Public generic functions
database-underlying-type: Public generic functions
database-underlying-type: Public generic functions
database-view-classes: Private generic functions
database-view-classes: Private generic functions
database-write-large-object: Public generic functions
date+: Public ordinary functions
date-: Public ordinary functions
date->time: Private ordinary functions
date-compare: Public ordinary functions
date-difference: Public ordinary functions
date-dow: Public ordinary functions
date-element: Public ordinary functions
date-max: Public ordinary functions
date-min: Public ordinary functions
date-mjd: Public ordinary functions
date-p: Public ordinary functions
date-ymd: Public ordinary functions
date/=: Private ordinary functions
date<: Public ordinary functions
date<=: Public ordinary functions
date=: Public ordinary functions
date>: Public ordinary functions
date>=: Public ordinary functions
day-name: Private ordinary functions
day-of-year: Private ordinary functions
days-in-month: Private ordinary functions
db-ancestors: Private ordinary functions
db-backend-has-create/destroy-db?: Public generic functions
db-backend-has-create/destroy-db?: Public generic functions
db-datestring: Public ordinary functions
db-timestring: Public ordinary functions
db-type-default-case: Public generic functions
db-type-default-case: Public generic functions
db-type-default-case: Public generic functions
db-type-has-auto-increment?: Public generic functions
db-type-has-auto-increment?: Public generic functions
db-type-has-auto-increment?: Public generic functions
db-type-has-auto-increment?: Public generic functions
db-type-has-bigint?: Public generic functions
db-type-has-bigint?: Public generic functions
db-type-has-boolean-where?: Public generic functions
db-type-has-boolean-where?: Public generic functions
db-type-has-boolean-where?: Public generic functions
db-type-has-except?: Public generic functions
db-type-has-except?: Public generic functions
db-type-has-except?: Public generic functions
db-type-has-fancy-math?: Public generic functions
db-type-has-fancy-math?: Public generic functions
db-type-has-fancy-math?: Public generic functions
db-type-has-intersect?: Public generic functions
db-type-has-intersect?: Public generic functions
db-type-has-intersect?: Public generic functions
db-type-has-prepared-stmt?: Public generic functions
db-type-has-prepared-stmt?: Public generic functions
db-type-has-prepared-stmt?: Public generic functions
db-type-has-prepared-stmt?: Public generic functions
db-type-has-subqueries?: Public generic functions
db-type-has-subqueries?: Public generic functions
db-type-has-union?: Public generic functions
db-type-has-union?: Public generic functions
db-type-has-views?: Public generic functions
db-type-has-views?: Public generic functions
db-type-transaction-capable?: Public generic functions
db-type-transaction-capable?: Public generic functions
db-type-use-column-on-drop-index?: Public generic functions
db-type-use-column-on-drop-index?: Public generic functions
db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
db-value: Private generic functions
db-value: Private generic functions
db-value-from-slot: Private ordinary functions
dbi-package: Private generic functions
dbi-package: Private generic functions
decimal-round-split: Private ordinary functions
decode-date: Public ordinary functions
decode-time: Public ordinary functions
def-view-class: Public macros
defaulting: Private macros
define-decimal-formatter: Public macros
defsql: Private macros
delete-at-index: Private ordinary functions
delete-instance-records: Public generic functions
delete-instance-records: Public generic functions
delete-large-object: Public ordinary functions
delete-records: Public ordinary functions
delete-sql-stream: Public ordinary functions
delimited-string-to-list: Private ordinary functions
delist-if-single: Private ordinary functions
delistify: Private ordinary functions
delistify-dsd: Private ordinary functions
dequote: Private ordinary functions
describe-db-layout: Private ordinary functions
destroy-database: Public ordinary functions
direct-normalized-slot-p: Private ordinary functions
direct-slot-definition-class: Public standalone methods
disable-sql-reader-syntax: Public macros
disconnect: Public ordinary functions
disconnect-fn: Private generic functions
disconnect-fn: Private generic functions
disconnect-pooled: Public ordinary functions
divide-into-groups: Private ordinary functions
do-query: Public macros
drop-index: Public ordinary functions
drop-sequence: Public ordinary functions
drop-table: Public ordinary functions
drop-view: Public ordinary functions
drop-view-from-class: Public ordinary functions
duration+: Public ordinary functions
duration-: Private ordinary functions
duration-day: Public ordinary functions
duration-hour: Public ordinary functions
duration-minute: Public ordinary functions
duration-month: Public ordinary functions
duration-p: Private ordinary functions
duration-reduce: Public ordinary functions
duration-second: Public ordinary functions
duration-timestring: Public ordinary functions
duration-usec: Private ordinary functions
duration-year: Public ordinary functions
duration<: Public ordinary functions
duration<=: Public ordinary functions
duration=: Public ordinary functions
duration>: Public ordinary functions
duration>=: Public ordinary functions

E
easy-slot-value: Private ordinary functions
effective-slot-definition-class: Public standalone methods
enable-sql-reader-syntax: Public macros
encoding: Public ordinary functions
ensure-keyword: Public ordinary functions
error-converting-value: Private ordinary functions
escaped: Private generic functions
escaped: Private generic functions
escaped: Private generic functions
escaped-database-identifier: Private ordinary functions
execute-command: Public generic functions
execute-command: Public generic functions
execute-command: Public generic functions
expected-type: Private generic functions
expected-type: Private generic functions
expression: Public generic functions
expression: Public generic functions
extract-roman: Public ordinary functions

F
fault-join-slot: Private ordinary functions
fault-join-slot-raw: Private ordinary functions
fault-join-target-slot: Private ordinary functions
fetch-row-fn: Private generic functions
fetch-row-fn: Private generic functions
field-names: Private ordinary functions
file-enable-sql-reader-syntax: Public macros
filter-plist: Private ordinary functions
filter-select-list: Public generic functions
filter-select-list: Public generic functions
finalize-inheritance: Public standalone methods
find-all: Private ordinary functions
find-database: Public ordinary functions
find-normalized-key: Private ordinary functions
find-or-create-connection-pool: Private ordinary functions
find-slot-by-name: Private ordinary functions
find-slot-if: Private ordinary functions
find-standard-db-class: Private ordinary functions
float-to-sql-string: Public ordinary functions
for-each-row: Private macros
format-date: Public ordinary functions
format-decimal-number: Public ordinary functions
format-duration: Public ordinary functions
format-time: Public ordinary functions
free-connections: Private generic functions
free-connections: Private generic functions
free-prepared-sql: Public ordinary functions
from-names: Private ordinary functions
full-select-list: Private ordinary functions
Function, %clsql-subclauses: Private ordinary functions
Function, %command-output: Private ordinary functions
Function, %convert-db-info-to-hash: Private ordinary functions
Function, %database-list-*: Private ordinary functions
Function, %disable-sql-reader-syntax: Private ordinary functions
Function, %enable-sql-reader-syntax: Private ordinary functions
Function, %get-int: Private ordinary functions
Function, %make-database-identifier: Private ordinary functions
Function, %make-date: Private ordinary functions
Function, %make-duration: Private ordinary functions
Function, %make-wall-time: Private ordinary functions
Function, %object-joins-from-list: Private ordinary functions
Function, %pool-force-disconnect: Private ordinary functions
Function, %print-date: Private ordinary functions
Function, %print-duration: Private ordinary functions
Function, %print-wall-time: Private ordinary functions
Function, %seq-name-key: Private ordinary functions
Function, %sequence-name-to-table: Private ordinary functions
Function, %svuc-slot-name: Private ordinary functions
Function, %svuc-slot-object: Private ordinary functions
Function, %table-name-to-sequence-name: Private ordinary functions
Function, %tables-for-query: Private ordinary functions
Function, %time<: Private ordinary functions
Function, %time<=: Private ordinary functions
Function, %time=: Private ordinary functions
Function, %time>: Private ordinary functions
Function, %time>=: Private ordinary functions
Function, %uninstall-class: Private ordinary functions
Function, %update-objects-joins-slot-defs: Private ordinary functions
Function, %write-operator: Private ordinary functions
Function, (setf date-mjd): Public ordinary functions
Function, (setf duration-day): Public ordinary functions
Function, (setf duration-hour): Public ordinary functions
Function, (setf duration-minute): Public ordinary functions
Function, (setf duration-month): Public ordinary functions
Function, (setf duration-second): Public ordinary functions
Function, (setf duration-usec): Private ordinary functions
Function, (setf duration-year): Public ordinary functions
Function, (setf easy-slot-value): Private ordinary functions
Function, (setf encoding): Public ordinary functions
Function, (setf interval-contained): Public ordinary functions
Function, (setf interval-data): Public ordinary functions
Function, (setf interval-end): Public ordinary functions
Function, (setf interval-name): Private ordinary functions
Function, (setf interval-start): Public ordinary functions
Function, (setf interval-type): Public ordinary functions
Function, (setf odbc-result-set-full-set): Private ordinary functions
Function, (setf odbc-result-set-query): Private ordinary functions
Function, (setf odbc-result-set-types): Private ordinary functions
Function, (setf records-cache-results): Private ordinary functions
Function, (setf time-mjd): Public ordinary functions
Function, (setf time-second): Private ordinary functions
Function, (setf time-usec): Private ordinary functions
Function, acquire-from-pool: Private ordinary functions
Function, add-sql-stream: Public ordinary functions
Function, add-transaction-commit-hook: Public ordinary functions
Function, add-transaction-rollback-hook: Public ordinary functions
Function, all-home-keys-have-values-p: Private ordinary functions
Function, all-immediate-join-classes-for: Private ordinary functions
Function, attribute-type: Public ordinary functions
Function, base-db-class: Private ordinary functions
Function, bind-parameter: Public ordinary functions
Function, binding-to-param: Private ordinary functions
Function, build-objects: Private ordinary functions
Function, cache-table-queries: Public ordinary functions
Function, check-slot-type: Private ordinary functions
Function, clear-conn-pool: Private ordinary functions
Function, clsql-and: Private ordinary functions
Function, clsql-ands: Private ordinary functions
Function, clsql-or: Private ordinary functions
Function, clsql-ors: Private ordinary functions
Function, clsql-type->postgresql-type: Private ordinary functions
Function, combine-database-identifiers: Private ordinary functions
Function, command-object: Public ordinary functions
Function, command-output: Public ordinary functions
Function, commit: Public ordinary functions
Function, compute-column-name: Private ordinary functions
Function, compute-lisp-type-from-specified-type: Private ordinary functions
Function, compute-records-cache-key: Private ordinary functions
Function, connect: Public ordinary functions
Function, connected-databases: Public ordinary functions
Function, convert-to-db-default-case: Public ordinary functions
Function, copy-date: Private ordinary functions
Function, copy-duration: Private ordinary functions
Function, copy-interval: Private ordinary functions
Function, copy-odbc-result-set: Private ordinary functions
Function, copy-time: Private ordinary functions
Function, copy-wall-time: Private ordinary functions
Function, create-database: Public ordinary functions
Function, create-index: Public ordinary functions
Function, create-large-object: Public ordinary functions
Function, create-sequence: Public ordinary functions
Function, create-table: Public ordinary functions
Function, create-view: Public ordinary functions
Function, create-view-from-class: Public ordinary functions
Function, current-day: Public ordinary functions
Function, current-month: Public ordinary functions
Function, current-year: Public ordinary functions
Function, database-identifier-equal: Private ordinary functions
Function, database-list-objects-of-type: Private ordinary functions
Function, date+: Public ordinary functions
Function, date-: Public ordinary functions
Function, date->time: Private ordinary functions
Function, date-compare: Public ordinary functions
Function, date-difference: Public ordinary functions
Function, date-dow: Public ordinary functions
Function, date-element: Public ordinary functions
Function, date-max: Public ordinary functions
Function, date-min: Public ordinary functions
Function, date-mjd: Public ordinary functions
Function, date-p: Public ordinary functions
Function, date-ymd: Public ordinary functions
Function, date/=: Private ordinary functions
Function, date<: Public ordinary functions
Function, date<=: Public ordinary functions
Function, date=: Public ordinary functions
Function, date>: Public ordinary functions
Function, date>=: Public ordinary functions
Function, day-name: Private ordinary functions
Function, day-of-year: Private ordinary functions
Function, days-in-month: Private ordinary functions
Function, db-ancestors: Private ordinary functions
Function, db-datestring: Public ordinary functions
Function, db-timestring: Public ordinary functions
Function, db-value-from-slot: Private ordinary functions
Function, decimal-round-split: Private ordinary functions
Function, decode-date: Public ordinary functions
Function, decode-time: Public ordinary functions
Function, delete-at-index: Private ordinary functions
Function, delete-large-object: Public ordinary functions
Function, delete-records: Public ordinary functions
Function, delete-sql-stream: Public ordinary functions
Function, delimited-string-to-list: Private ordinary functions
Function, delist-if-single: Private ordinary functions
Function, delistify: Private ordinary functions
Function, delistify-dsd: Private ordinary functions
Function, dequote: Private ordinary functions
Function, describe-db-layout: Private ordinary functions
Function, destroy-database: Public ordinary functions
Function, direct-normalized-slot-p: Private ordinary functions
Function, disconnect: Public ordinary functions
Function, disconnect-pooled: Public ordinary functions
Function, divide-into-groups: Private ordinary functions
Function, drop-index: Public ordinary functions
Function, drop-sequence: Public ordinary functions
Function, drop-table: Public ordinary functions
Function, drop-view: Public ordinary functions
Function, drop-view-from-class: Public ordinary functions
Function, duration+: Public ordinary functions
Function, duration-: Private ordinary functions
Function, duration-day: Public ordinary functions
Function, duration-hour: Public ordinary functions
Function, duration-minute: Public ordinary functions
Function, duration-month: Public ordinary functions
Function, duration-p: Private ordinary functions
Function, duration-reduce: Public ordinary functions
Function, duration-second: Public ordinary functions
Function, duration-timestring: Public ordinary functions
Function, duration-usec: Private ordinary functions
Function, duration-year: Public ordinary functions
Function, duration<: Public ordinary functions
Function, duration<=: Public ordinary functions
Function, duration=: Public ordinary functions
Function, duration>: Public ordinary functions
Function, duration>=: Public ordinary functions
Function, easy-slot-value: Private ordinary functions
Function, encoding: Public ordinary functions
Function, ensure-keyword: Public ordinary functions
Function, error-converting-value: Private ordinary functions
Function, escaped-database-identifier: Private ordinary functions
Function, extract-roman: Public ordinary functions
Function, fault-join-slot: Private ordinary functions
Function, fault-join-slot-raw: Private ordinary functions
Function, fault-join-target-slot: Private ordinary functions
Function, field-names: Private ordinary functions
Function, filter-plist: Private ordinary functions
Function, find-all: Private ordinary functions
Function, find-database: Public ordinary functions
Function, find-normalized-key: Private ordinary functions
Function, find-or-create-connection-pool: Private ordinary functions
Function, find-slot-by-name: Private ordinary functions
Function, find-slot-if: Private ordinary functions
Function, find-standard-db-class: Private ordinary functions
Function, float-to-sql-string: Public ordinary functions
Function, format-date: Public ordinary functions
Function, format-decimal-number: Public ordinary functions
Function, format-duration: Public ordinary functions
Function, format-time: Public ordinary functions
Function, free-prepared-sql: Public ordinary functions
Function, from-names: Private ordinary functions
Function, full-select-list: Private ordinary functions
Function, generate-attribute-reference: Private ordinary functions
Function, generate-sql-reference: Private ordinary functions
Function, get-date: Public ordinary functions
Function, get-join-slots: Private ordinary functions
Function, get-joined-objects: Private ordinary functions
Function, get-keywords: Private ordinary functions
Function, get-time: Public ordinary functions
Function, getenv: Public ordinary functions
Function, gregorian-to-mjd: Public ordinary functions
Function, has-table: Private ordinary functions
Function, hork-integers: Private ordinary functions
Function, immediate-join-slots: Private ordinary functions
Function, in-transaction-p: Public ordinary functions
Function, index-exists-p: Public ordinary functions
Function, initialize-database-type: Public ordinary functions
Function, insert-at-index: Private ordinary functions
Function, insert-records: Public ordinary functions
Function, interval-clear: Public ordinary functions
Function, interval-contained: Public ordinary functions
Function, interval-data: Public ordinary functions
Function, interval-edit: Public ordinary functions
Function, interval-end: Public ordinary functions
Function, interval-match: Public ordinary functions
Function, interval-name: Private ordinary functions
Function, interval-p: Private ordinary functions
Function, interval-push: Public ordinary functions
Function, interval-relation: Public ordinary functions
Function, interval-start: Public ordinary functions
Function, interval-type: Public ordinary functions
Function, is-database-open: Public ordinary functions
Function, iso-8601-delimiter: Private ordinary functions
Function, iso-8601-duration-subseq: Private ordinary functions
Function, iso-datestring: Private ordinary functions
Function, iso-timestring: Public ordinary functions
Function, join-qualifier: Private ordinary functions
Function, join-slot-class: Private ordinary functions
Function, join-slot-class-name: Private ordinary functions
Function, join-slot-info-value: Private ordinary functions
Function, join-slot-p: Private ordinary functions
Function, join-slot-qualifier: Private ordinary functions
Function, join-slot-retrieval-method: Private ordinary functions
Function, key-or-base-slot-p: Private ordinary functions
Function, key-qualifier-for-instance: Private ordinary functions
Function, key-slot-p: Private ordinary functions
Function, keyslots-for-class: Private ordinary functions
Function, leap-days-in-days: Private ordinary functions
Function, leap-year?: Private ordinary functions
Function, lisp->sql-name: Private ordinary functions
Function, list-attribute-types: Public ordinary functions
Function, list-attributes: Public ordinary functions
Function, list-classes: Public ordinary functions
Function, list-databases: Public ordinary functions
Function, list-indexes: Public ordinary functions
Function, list-sequences: Public ordinary functions
Function, list-sql-streams: Public ordinary functions
Function, list-tables: Public ordinary functions
Function, list-views: Public ordinary functions
Function, listify: Private ordinary functions
Function, loop-gentemp: Private ordinary functions
Function, loop-record-iteration-path: Private ordinary functions
Function, make-attribute-value-pair: Private ordinary functions
Function, make-class-and-slots: Private ordinary functions
Function, make-constraints-description: Private ordinary functions
Function, make-date: Public ordinary functions
Function, make-duration: Public ordinary functions
Function, make-interval: Public ordinary functions
Function, make-odbc-result-set: Private ordinary functions
Function, make-process-lock: Public ordinary functions
Function, make-query: Private ordinary functions
Function, make-select-list: Private ordinary functions
Function, make-sequence-of-type: Public ordinary functions
Function, make-sql-insert: Private ordinary functions
Function, make-time: Public ordinary functions
Function, map-query: Public ordinary functions
Function, map-query-for-effect: Private ordinary functions
Function, map-query-to-list: Private ordinary functions
Function, map-query-to-simple: Private ordinary functions
Function, mark-transaction-committed: Private ordinary functions
Function, maybe-error-converting-value: Private ordinary functions
Function, merged-time: Public ordinary functions
Function, mjd-to-gregorian: Public ordinary functions
Function, month-name: Public ordinary functions
Function, next-prepared-id: Private ordinary functions
Function, normalized-key-value: Private ordinary functions
Function, not-direct-normalized-slot-p: Private ordinary functions
Function, number-string-to-fractional: Private ordinary functions
Function, number-string-to-integer: Private ordinary functions
Function, number-to-sql-string: Public ordinary functions
Function, odbc-result-set-full-set: Private ordinary functions
Function, odbc-result-set-p: Private ordinary functions
Function, odbc-result-set-query: Private ordinary functions
Function, odbc-result-set-types: Private ordinary functions
Function, order-by-strings: Private ordinary functions
Function, ordered-class-direct-slots: Private ordinary functions
Function, ordered-class-slots: Private ordinary functions
Function, ordinal-day: Private ordinary functions
Function, ordinal-month: Private ordinary functions
Function, output-sql-where-clause: Private ordinary functions
Function, owner-clause: Private ordinary functions
Function, parse-date-time: Public ordinary functions
Function, parse-datestring: Public ordinary functions
Function, parse-db-info: Private ordinary functions
Function, parse-decimal-number: Public ordinary functions
Function, parse-integer-insensitively: Private ordinary functions
Function, parse-iso-8601-duration: Private ordinary functions
Function, parse-iso-8601-time: Private ordinary functions
Function, parse-timestring: Public ordinary functions
Function, parse-yearstring: Public ordinary functions
Function, position-char: Private ordinary functions
Function, postgresql-database-list: Private ordinary functions
Function, prepare-sql: Public ordinary functions
Function, prepared-sql-to-postgresql-sql: Private ordinary functions
Function, pretty-time: Private ordinary functions
Function, print-date: Public ordinary functions
Function, print-query: Public ordinary functions
Function, print-readable-symbol: Private ordinary functions
Function, probe-database: Public ordinary functions
Function, push-library-path: Public ordinary functions
Function, query-arg-p: Private ordinary functions
Function, query-get-selections: Private ordinary functions
Function, query-string: Private ordinary functions
Function, read-decimal-value: Private ordinary functions
Function, read-instance-from-stream: Public ordinary functions
Function, read-large-object: Public ordinary functions
Function, read-stream-to-string: Private ordinary functions
Function, reconnect: Public ordinary functions
Function, record-sql-command: Private ordinary functions
Function, record-sql-result: Private ordinary functions
Function, records-cache-results: Private ordinary functions
Function, register-metaclass: Private ordinary functions
Function, release-to-pool: Private ordinary functions
Function, reload-database-types: Public ordinary functions
Function, remove-keyword-arg: Private ordinary functions
Function, replace-all: Private ordinary functions
Function, replace-at-index: Private ordinary functions
Function, replace-string: Private ordinary functions
Function, replaced-string-length: Private ordinary functions
Function, required-argument: Public ordinary functions
Function, reset-command-object: Public ordinary functions
Function, restrict-intervals: Private ordinary functions
Function, result-type-or-lose: Public ordinary functions
Function, roll: Public ordinary functions
Function, roll-to: Public ordinary functions
Function, rollback: Public ordinary functions
Function, round-half-away-from-zero: Public ordinary functions
Function, run-prepared-sql: Public ordinary functions
Function, select: Public ordinary functions
Function, select-reference-equal: Private ordinary functions
Function, sequence-exists-p: Public ordinary functions
Function, sequence-last: Public ordinary functions
Function, sequence-next: Public ordinary functions
Function, set-autocommit: Public ordinary functions
Function, set-sequence-position: Public ordinary functions
Function, set-view-table-slot: Private ordinary functions
Function, signal-closed-database-error: Private ordinary functions
Function, signal-database-too-strange: Private ordinary functions
Function, signal-no-database-error: Private ordinary functions
Function, slot-has-default-p: Private ordinary functions
Function, slotdef-for-slot-with-class: Private ordinary functions
Function, slotdefs-for-slots-with-class: Private ordinary functions
Function, slots-for-possibly-normalized-class: Private ordinary functions
Function, sort-interval-list: Private ordinary functions
Function, special-cased-symbol-p: Private ordinary functions
Function, special-char-p: Private ordinary functions
Function, sql: Public ordinary functions
Function, sql-*: Public ordinary functions
Function, sql-+: Public ordinary functions
Function, sql--: Public ordinary functions
Function, sql-/: Public ordinary functions
Function, sql-<: Public ordinary functions
Function, sql-<=: Public ordinary functions
Function, sql-<>: Public ordinary functions
Function, sql-=: Public ordinary functions
Function, sql-==: Public ordinary functions
Function, sql->: Public ordinary functions
Function, sql->=: Public ordinary functions
Function, sql-all: Public ordinary functions
Function, sql-and: Public ordinary functions
Function, sql-any: Public ordinary functions
Function, sql-avg: Public ordinary functions
Function, sql-between: Public ordinary functions
Function, sql-coalesce: Public ordinary functions
Function, sql-concat: Public ordinary functions
Function, sql-concat-op: Public ordinary functions
Function, sql-count: Public ordinary functions
Function, sql-distinct: Public ordinary functions
Function, sql-e-string: Private ordinary functions
Function, sql-escape: Public ordinary functions
Function, sql-escape-quotes: Public ordinary functions
Function, sql-except: Public ordinary functions
Function, sql-exists: Public ordinary functions
Function, sql-expression: Public ordinary functions
Function, sql-function: Public ordinary functions
Function, sql-group-by: Public ordinary functions
Function, sql-having: Public ordinary functions
Function, sql-in: Public ordinary functions
Function, sql-intersect: Public ordinary functions
Function, sql-is: Public ordinary functions
Function, sql-like: Public ordinary functions
Function, sql-limit: Public ordinary functions
Function, sql-lower: Private ordinary functions
Function, sql-max: Public ordinary functions
Function, sql-min: Public ordinary functions
Function, sql-minus: Public ordinary functions
Function, sql-not: Public ordinary functions
Function, sql-not-null: Public ordinary functions
Function, sql-null: Public ordinary functions
Function, sql-nvl: Public ordinary functions
Function, sql-operation: Public ordinary functions
Function, sql-operator: Public ordinary functions
Function, sql-or: Public ordinary functions
Function, sql-order-by: Public ordinary functions
Function, sql-output: Private ordinary functions
Function, sql-query: Public ordinary functions
Function, sql-reader-open: Private ordinary functions
Function, sql-recording-p: Public ordinary functions
Function, sql-slot-value: Public ordinary functions
Function, sql-some: Public ordinary functions
Function, sql-stream: Public ordinary functions
Function, sql-substr: Public ordinary functions
Function, sql-substring: Public ordinary functions
Function, sql-sum: Public ordinary functions
Function, sql-the: Public ordinary functions
Function, sql-union: Public ordinary functions
Function, sql-uplike: Public ordinary functions
Function, sql-upper: Private ordinary functions
Function, sql-userenv: Public ordinary functions
Function, sql-view-class: Public ordinary functions
Function, start-sql-recording: Public ordinary functions
Function, start-transaction: Public ordinary functions
Function, status: Public ordinary functions
Function, stop-sql-recording: Public ordinary functions
Function, string-align: Private ordinary functions
Function, string-to-list-connection-spec: Private ordinary functions
Function, substitute-char-string: Private ordinary functions
Function, substitute-chars-strings: Private ordinary functions
Function, substitute-string-for-char: Private ordinary functions
Function, symbol-name-default-case: Public ordinary functions
Function, syntax-parse-iso-8601: Private ordinary functions
Function, table-exists-p: Public ordinary functions
Function, table-name-from-arg: Private ordinary functions
Function, time+: Public ordinary functions
Function, time-: Public ordinary functions
Function, time->date: Private ordinary functions
Function, time-compare: Public ordinary functions
Function, time-difference: Public ordinary functions
Function, time-dow: Public ordinary functions
Function, time-element: Public ordinary functions
Function, time-hms: Private ordinary functions
Function, time-max: Public ordinary functions
Function, time-meridian: Private ordinary functions
Function, time-min: Public ordinary functions
Function, time-mjd: Public ordinary functions
Function, time-second: Private ordinary functions
Function, time-usec: Private ordinary functions
Function, time-ymd: Public ordinary functions
Function, time/=: Private ordinary functions
Function, time<: Public ordinary functions
Function, time<=: Public ordinary functions
Function, time=: Public ordinary functions
Function, time>: Public ordinary functions
Function, time>=: Public ordinary functions
Function, to-attributes-and-values: Private ordinary functions
Function, to-class: Private ordinary functions
Function, to-class-name: Private ordinary functions
Function, to-slot-name: Private ordinary functions
Function, truncate-database: Public ordinary functions
Function, unescaped-database-identifier: Private ordinary functions
Function, update-auto-increments-keys: Private ordinary functions
Function, update-fault-join-normalized-slot: Private ordinary functions
Function, update-objects-joins: Public ordinary functions
Function, update-records: Public ordinary functions
Function, utime->time: Public ordinary functions
Function, valid-gregorian-date-p: Private ordinary functions
Function, valid-month-p: Private ordinary functions
Function, view-exists-p: Public ordinary functions
Function, wall-time-p: Private ordinary functions
Function, week-containing: Public ordinary functions
Function, where-strings: Private ordinary functions
Function, write-instance-to-stream: Public ordinary functions
Function, write-large-object: Public ordinary functions

G
generate-attribute-reference: Private ordinary functions
generate-sql-reference: Private ordinary functions
Generic Function, %install-class: Private generic functions
Generic Function, %table-exists-p: Private generic functions
Generic Function, %update-instance-helper: Private generic functions
Generic Function, (setf all-connections): Private generic functions
Generic Function, (setf attribute): Private generic functions
Generic Function, (setf attribute-cache): Public generic functions
Generic Function, (setf command-recording-stream): Public generic functions
Generic Function, (setf commit-hooks): Private generic functions
Generic Function, (setf conn-pool): Public generic functions
Generic Function, (setf conn-pool-lock): Private generic functions
Generic Function, (setf connection-spec): Public generic functions
Generic Function, (setf database): Public generic functions
Generic Function, (setf database-autocommit): Public generic functions
Generic Function, (setf database-odbc-db-type): Private generic functions
Generic Function, (setf database-view-classes): Private generic functions
Generic Function, (setf db-value): Private generic functions
Generic Function, (setf escaped): Private generic functions
Generic Function, (setf expected-type): Private generic functions
Generic Function, (setf expression): Public generic functions
Generic Function, (setf free-connections): Private generic functions
Generic Function, (setf has-been-prepared): Public generic functions
Generic Function, (setf join-slots): Public generic functions
Generic Function, (setf joins): Public generic functions
Generic Function, (setf key-slots): Private generic functions
Generic Function, (setf normalizedp): Private generic functions
Generic Function, (setf object-definition): Private generic functions
Generic Function, (setf odbc-conn): Private generic functions
Generic Function, (setf parameters): Public generic functions
Generic Function, (setf pool-database-type): Private generic functions
Generic Function, (setf prepared-name): Public generic functions
Generic Function, (setf record-caches): Public generic functions
Generic Function, (setf result-recording-stream): Public generic functions
Generic Function, (setf rollback-hooks): Private generic functions
Generic Function, (setf select-list): Public generic functions
Generic Function, (setf slot-defs): Private generic functions
Generic Function, (setf slot-list): Public generic functions
Generic Function, (setf specified-type): Private generic functions
Generic Function, (setf stmt-field-names): Private generic functions
Generic Function, (setf transaction): Public generic functions
Generic Function, (setf transaction-level): Public generic functions
Generic Function, (setf transaction-status): Private generic functions
Generic Function, (setf unescaped): Private generic functions
Generic Function, (setf value): Private generic functions
Generic Function, (setf view-class): Private generic functions
Generic Function, (setf view-class-qualifier): Private generic functions
Generic Function, (setf view-class-slot-autoincrement-sequence): Private generic functions
Generic Function, (setf view-class-slot-column): Private generic functions
Generic Function, (setf view-class-slot-db-constraints): Private generic functions
Generic Function, (setf view-class-slot-db-info): Private generic functions
Generic Function, (setf view-class-slot-db-kind): Private generic functions
Generic Function, (setf view-class-slot-db-reader): Private generic functions
Generic Function, (setf view-class-slot-db-type): Private generic functions
Generic Function, (setf view-class-slot-db-writer): Private generic functions
Generic Function, (setf view-class-slot-void-value): Private generic functions
Generic Function, (setf view-table): Public generic functions
Generic Function, all-connections: Private generic functions
Generic Function, attribute: Private generic functions
Generic Function, attribute-cache: Public generic functions
Generic Function, attribute-references: Private generic functions
Generic Function, attribute-value-pairs: Private generic functions
Generic Function, auto-increment-column-p: Private generic functions
Generic Function, auto-increment-sequence-name: Private generic functions
Generic Function, bad-component: Public generic functions
Generic Function, bindings: Private generic functions
Generic Function, choose-database-for-instance: Private generic functions
Generic Function, close-query-fn: Private generic functions
Generic Function, collect-table-refs: Private generic functions
Generic Function, command-recording-stream: Public generic functions
Generic Function, commit-hooks: Private generic functions
Generic Function, conn-pool: Public generic functions
Generic Function, conn-pool-lock: Private generic functions
Generic Function, connection-spec: Public generic functions
Generic Function, database: Public generic functions
Generic Function, database-abort-transaction: Private generic functions
Generic Function, database-acquire-from-conn-pool: Public generic functions
Generic Function, database-add-attribute: Private generic functions
Generic Function, database-add-autoincrement-sequence: Private generic functions
Generic Function, database-attribute-type: Public generic functions
Generic Function, database-autocommit: Public generic functions
Generic Function, database-bind-parameter: Public generic functions
Generic Function, database-commit-transaction: Private generic functions
Generic Function, database-connect: Public generic functions
Generic Function, database-constraint-statement: Private generic functions
Generic Function, database-create: Public generic functions
Generic Function, database-create-large-object: Public generic functions
Generic Function, database-create-sequence: Public generic functions
Generic Function, database-delete-large-object: Public generic functions
Generic Function, database-destroy: Public generic functions
Generic Function, database-disconnect: Public generic functions
Generic Function, database-drop-sequence: Public generic functions
Generic Function, database-dump-result-set: Public generic functions
Generic Function, database-execute-command: Public generic functions
Generic Function, database-free-prepared: Public generic functions
Generic Function, database-generate-column-definition: Private generic functions
Generic Function, database-get-type-specifier: Public generic functions
Generic Function, database-identifier: Private generic functions
Generic Function, database-initialize-database-type: Public generic functions
Generic Function, database-last-auto-increment-id: Public generic functions
Generic Function, database-last-autoincrement-id: Private generic functions
Generic Function, database-list: Public generic functions
Generic Function, database-list-attributes: Public generic functions
Generic Function, database-list-indexes: Public generic functions
Generic Function, database-list-sequences: Public generic functions
Generic Function, database-list-table-indexes: Public generic functions
Generic Function, database-list-tables: Public generic functions
Generic Function, database-list-tables-and-sequences: Public generic functions
Generic Function, database-list-views: Public generic functions
Generic Function, database-name: Public generic functions
Generic Function, database-name-from-spec: Public generic functions
Generic Function, database-odbc-db-type: Private generic functions
Generic Function, database-output-sql: Private generic functions
Generic Function, database-output-sql-as-type: Public generic functions
Generic Function, database-pkey-constraint: Private generic functions
Generic Function, database-prepare: Public generic functions
Generic Function, database-probe: Public generic functions
Generic Function, database-query: Public generic functions
Generic Function, database-query-result-set: Public generic functions
Generic Function, database-read-large-object: Public generic functions
Generic Function, database-reconnect: Public generic functions
Generic Function, database-release-to-conn-pool: Public generic functions
Generic Function, database-remove-autoincrement-sequence: Private generic functions
Generic Function, database-rename-attribute: Private generic functions
Generic Function, database-run-prepared: Public generic functions
Generic Function, database-sequence-last: Public generic functions
Generic Function, database-sequence-next: Public generic functions
Generic Function, database-set-sequence-position: Public generic functions
Generic Function, database-start-transaction: Private generic functions
Generic Function, database-state: Public generic functions
Generic Function, database-store-next-row: Public generic functions
Generic Function, database-translate-constraint: Private generic functions
Generic Function, database-truncate: Private generic functions
Generic Function, database-type: Public generic functions
Generic Function, database-type-library-loaded: Public generic functions
Generic Function, database-type-load-foreign: Public generic functions
Generic Function, database-underlying-type: Public generic functions
Generic Function, database-view-classes: Private generic functions
Generic Function, database-write-large-object: Public generic functions
Generic Function, db-backend-has-create/destroy-db?: Public generic functions
Generic Function, db-type-default-case: Public generic functions
Generic Function, db-type-has-auto-increment?: Public generic functions
Generic Function, db-type-has-bigint?: Public generic functions
Generic Function, db-type-has-boolean-where?: Public generic functions
Generic Function, db-type-has-except?: Public generic functions
Generic Function, db-type-has-fancy-math?: Public generic functions
Generic Function, db-type-has-intersect?: Public generic functions
Generic Function, db-type-has-prepared-stmt?: Public generic functions
Generic Function, db-type-has-subqueries?: Public generic functions
Generic Function, db-type-has-union?: Public generic functions
Generic Function, db-type-has-views?: Public generic functions
Generic Function, db-type-transaction-capable?: Public generic functions
Generic Function, db-type-use-column-on-drop-index?: Public generic functions
Generic Function, db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
Generic Function, db-value: Private generic functions
Generic Function, dbi-package: Private generic functions
Generic Function, delete-instance-records: Public generic functions
Generic Function, disconnect-fn: Private generic functions
Generic Function, escaped: Private generic functions
Generic Function, execute-command: Public generic functions
Generic Function, expected-type: Private generic functions
Generic Function, expression: Public generic functions
Generic Function, fetch-row-fn: Private generic functions
Generic Function, filter-select-list: Public generic functions
Generic Function, free-connections: Private generic functions
Generic Function, get-slot-value-from-record: Private generic functions
Generic Function, get-slot-values-from-view: Private generic functions
Generic Function, has-been-prepared: Public generic functions
Generic Function, has-table-pg_roles: Private generic functions
Generic Function, id: Private generic functions
Generic Function, instance-refreshed: Public generic functions
Generic Function, join-slots: Public generic functions
Generic Function, joins: Public generic functions
Generic Function, key-slots: Private generic functions
Generic Function, key-value-from-db: Private generic functions
Generic Function, list-all-database-tables-fn: Private generic functions
Generic Function, list-all-table-columns-fn: Private generic functions
Generic Function, midnight: Public generic functions
Generic Function, normalizedp: Private generic functions
Generic Function, object-definition: Private generic functions
Generic Function, odbc-conn: Private generic functions
Generic Function, oid: Private generic functions
Generic Function, output-sql: Private generic functions
Generic Function, output-sql-hash-key: Private generic functions
Generic Function, parameters: Public generic functions
Generic Function, pool-database-type: Private generic functions
Generic Function, prepare-sql-parameter: Public generic functions
Generic Function, prepared-name: Public generic functions
Generic Function, previous-autocommit: Private generic functions
Generic Function, primary-key-slot-values: Private generic functions
Generic Function, query: Public generic functions
Generic Function, read-sql-value: Public generic functions
Generic Function, record-caches: Public generic functions
Generic Function, result-recording-stream: Public generic functions
Generic Function, result-types: Private generic functions
Generic Function, rollback-hooks: Private generic functions
Generic Function, select-list: Public generic functions
Generic Function, select-table-sql-expr: Private generic functions
Generic Function, slot-defs: Private generic functions
Generic Function, slot-list: Public generic functions
Generic Function, specified-type: Private generic functions
Generic Function, sql-error-connection-spec: Public generic functions
Generic Function, sql-error-database: Public generic functions
Generic Function, sql-error-database-message: Public generic functions
Generic Function, sql-error-database-type: Public generic functions
Generic Function, sql-error-error-id: Public generic functions
Generic Function, sql-error-expression: Public generic functions
Generic Function, sql-error-secondary-error-id: Public generic functions
Generic Function, sql-fn: Private generic functions
Generic Function, sql-table: Private generic functions
Generic Function, sql-user-error-message: Public generic functions
Generic Function, sql-warning-database: Public generic functions
Generic Function, sql-warning-message: Private generic functions
Generic Function, stmt-field-names: Private generic functions
Generic Function, to-string: Private generic functions
Generic Function, transaction: Public generic functions
Generic Function, transaction-level: Public generic functions
Generic Function, transaction-status: Private generic functions
Generic Function, unescaped: Private generic functions
Generic Function, update-instance-from-records: Public generic functions
Generic Function, update-record-from-slot: Public generic functions
Generic Function, update-record-from-slots: Public generic functions
Generic Function, update-records-from-instance: Public generic functions
Generic Function, update-slot-default-values: Private generic functions
Generic Function, update-slot-from-db: Private generic functions
Generic Function, update-slot-from-db-value: Private generic functions
Generic Function, update-slot-from-record: Public generic functions
Generic Function, update-slot-with-null: Private generic functions
Generic Function, value: Private generic functions
Generic Function, view-class: Private generic functions
Generic Function, view-class-qualifier: Private generic functions
Generic Function, view-class-slot-autoincrement-sequence: Private generic functions
Generic Function, view-class-slot-column: Private generic functions
Generic Function, view-class-slot-db-constraints: Private generic functions
Generic Function, view-class-slot-db-info: Private generic functions
Generic Function, view-class-slot-db-kind: Private generic functions
Generic Function, view-class-slot-db-reader: Private generic functions
Generic Function, view-class-slot-db-type: Private generic functions
Generic Function, view-class-slot-db-writer: Private generic functions
Generic Function, view-class-slot-void-value: Private generic functions
Generic Function, view-classes-and-slots-by-name: Private generic functions
Generic Function, view-classes-and-storable-slots: Private generic functions
Generic Function, view-database: Private generic functions
Generic Function, view-table: Public generic functions
Generic Function, view-table-exp: Private generic functions
get-date: Public ordinary functions
get-join-slots: Private ordinary functions
get-joined-objects: Private ordinary functions
get-keywords: Private ordinary functions
get-slot-value-from-record: Private generic functions
get-slot-value-from-record: Private generic functions
get-slot-values-from-view: Private generic functions
get-slot-values-from-view: Private generic functions
get-time: Public ordinary functions
getenv: Public ordinary functions
gregorian-to-mjd: Public ordinary functions

H
has-been-prepared: Public generic functions
has-been-prepared: Public generic functions
has-table: Private ordinary functions
has-table-pg_roles: Private generic functions
has-table-pg_roles: Private generic functions
hork-integers: Private ordinary functions

I
id: Private generic functions
id: Private generic functions
immediate-join-slots: Private ordinary functions
in: Public macros
in-transaction-p: Public ordinary functions
index-exists-p: Public ordinary functions
initialize-database-type: Public ordinary functions
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods
initialize-instance: Public standalone methods
insert-at-index: Private ordinary functions
insert-records: Public ordinary functions
instance-refreshed: Public generic functions
instance-refreshed: Public generic functions
interval-clear: Public ordinary functions
interval-contained: Public ordinary functions
interval-data: Public ordinary functions
interval-edit: Public ordinary functions
interval-end: Public ordinary functions
interval-match: Public ordinary functions
interval-name: Private ordinary functions
interval-p: Private ordinary functions
interval-push: Public ordinary functions
interval-relation: Public ordinary functions
interval-start: Public ordinary functions
interval-type: Public ordinary functions
is-database-open: Public ordinary functions
iso-8601-delimiter: Private ordinary functions
iso-8601-duration-subseq: Private ordinary functions
iso-datestring: Private ordinary functions
iso-timestring: Public ordinary functions

J
join-qualifier: Private ordinary functions
join-slot-class: Private ordinary functions
join-slot-class-name: Private ordinary functions
join-slot-info-value: Private ordinary functions
join-slot-p: Private ordinary functions
join-slot-qualifier: Private ordinary functions
join-slot-retrieval-method: Private ordinary functions
join-slots: Public generic functions
join-slots: Public generic functions
joins: Public generic functions
joins: Public generic functions

K
key-or-base-slot-p: Private ordinary functions
key-qualifier-for-instance: Private ordinary functions
key-slot-p: Private ordinary functions
key-slots: Private generic functions
key-slots: Private generic functions
key-value-from-db: Private generic functions
key-value-from-db: Private generic functions
keyslots-for-class: Private ordinary functions

L
leap-days-in-days: Private ordinary functions
leap-year?: Private ordinary functions
lisp->sql-name: Private ordinary functions
list-all-database-tables-fn: Private generic functions
list-all-database-tables-fn: Private generic functions
list-all-table-columns-fn: Private generic functions
list-all-table-columns-fn: Private generic functions
list-attribute-types: Public ordinary functions
list-attributes: Public ordinary functions
list-classes: Public ordinary functions
list-databases: Public ordinary functions
list-indexes: Public ordinary functions
list-sequences: Public ordinary functions
list-sql-streams: Public ordinary functions
list-tables: Public ordinary functions
list-views: Public ordinary functions
listify: Private ordinary functions
locally-disable-sql-reader-syntax: Public macros
locally-enable-sql-reader-syntax: Public macros
loop-gentemp: Private ordinary functions
loop-record-iteration-path: Private ordinary functions

M
Macro, check-connection-spec: Public macros
Macro, def-view-class: Public macros
Macro, defaulting: Private macros
Macro, define-decimal-formatter: Public macros
Macro, defsql: Private macros
Macro, disable-sql-reader-syntax: Public macros
Macro, do-query: Public macros
Macro, enable-sql-reader-syntax: Public macros
Macro, file-enable-sql-reader-syntax: Public macros
Macro, for-each-row: Private macros
Macro, in: Public macros
Macro, locally-disable-sql-reader-syntax: Public macros
Macro, locally-enable-sql-reader-syntax: Public macros
Macro, make-weak-hash-table: Private macros
Macro, pop-n: Private macros
Macro, process-class-option: Private macros
Macro, process-slot-option: Private macros
Macro, restore-sql-reader-syntax-state: Public macros
Macro, shrink-vector: Public macros
Macro, with-database: Public macros
Macro, with-default-database: Public macros
Macro, with-process-lock: Public macros
Macro, with-transaction: Public macros
Macro, without-interrupts: Public macros
Macro, wrap-time-for-date: Private macros
make-attribute-value-pair: Private ordinary functions
make-class-and-slots: Private ordinary functions
make-constraints-description: Private ordinary functions
make-date: Public ordinary functions
make-duration: Public ordinary functions
make-interval: Public ordinary functions
make-load-form: Public standalone methods
make-load-form: Public standalone methods
make-load-form: Public standalone methods
make-load-form: Public standalone methods
make-load-form: Public standalone methods
make-odbc-result-set: Private ordinary functions
make-process-lock: Public ordinary functions
make-query: Private ordinary functions
make-select-list: Private ordinary functions
make-sequence-of-type: Public ordinary functions
make-sql-insert: Private ordinary functions
make-time: Public ordinary functions
make-weak-hash-table: Private macros
map-query: Public ordinary functions
map-query-for-effect: Private ordinary functions
map-query-to-list: Private ordinary functions
map-query-to-simple: Private ordinary functions
mark-transaction-committed: Private ordinary functions
maybe-error-converting-value: Private ordinary functions
merged-time: Public ordinary functions
Method, %install-class: Private generic functions
Method, %table-exists-p: Private generic functions
Method, %update-instance-helper: Private generic functions
Method, (setf all-connections): Private generic functions
Method, (setf attribute): Private generic functions
Method, (setf attribute-cache): Public generic functions
Method, (setf command-recording-stream): Public generic functions
Method, (setf commit-hooks): Private generic functions
Method, (setf conn-pool): Public generic functions
Method, (setf conn-pool-lock): Private generic functions
Method, (setf connection-spec): Public generic functions
Method, (setf database): Public generic functions
Method, (setf database-autocommit): Public generic functions
Method, (setf database-odbc-db-type): Private generic functions
Method, (setf database-view-classes): Private generic functions
Method, (setf db-value): Private generic functions
Method, (setf escaped): Private generic functions
Method, (setf expected-type): Private generic functions
Method, (setf expression): Public generic functions
Method, (setf free-connections): Private generic functions
Method, (setf has-been-prepared): Public generic functions
Method, (setf join-slots): Public generic functions
Method, (setf joins): Public generic functions
Method, (setf key-slots): Private generic functions
Method, (setf normalizedp): Private generic functions
Method, (setf object-definition): Private generic functions
Method, (setf odbc-conn): Private generic functions
Method, (setf parameters): Public generic functions
Method, (setf pool-database-type): Private generic functions
Method, (setf prepared-name): Public generic functions
Method, (setf record-caches): Public generic functions
Method, (setf result-recording-stream): Public generic functions
Method, (setf rollback-hooks): Private generic functions
Method, (setf select-list): Public generic functions
Method, (setf slot-defs): Private generic functions
Method, (setf slot-list): Public generic functions
Method, (setf slot-value-using-class): Public standalone methods
Method, (setf specified-type): Private generic functions
Method, (setf stmt-field-names): Private generic functions
Method, (setf transaction): Public generic functions
Method, (setf transaction-level): Public generic functions
Method, (setf transaction-status): Private generic functions
Method, (setf unescaped): Private generic functions
Method, (setf value): Private generic functions
Method, (setf view-class): Private generic functions
Method, (setf view-class): Private generic functions
Method, (setf view-class-qualifier): Private generic functions
Method, (setf view-class-slot-autoincrement-sequence): Private generic functions
Method, (setf view-class-slot-column): Private generic functions
Method, (setf view-class-slot-db-constraints): Private generic functions
Method, (setf view-class-slot-db-info): Private generic functions
Method, (setf view-class-slot-db-kind): Private generic functions
Method, (setf view-class-slot-db-reader): Private generic functions
Method, (setf view-class-slot-db-type): Private generic functions
Method, (setf view-class-slot-db-writer): Private generic functions
Method, (setf view-class-slot-void-value): Private generic functions
Method, (setf view-table): Public generic functions
Method, all-connections: Private generic functions
Method, attribute: Private generic functions
Method, attribute-cache: Public generic functions
Method, attribute-references: Private generic functions
Method, attribute-value-pairs: Private generic functions
Method, auto-increment-column-p: Private generic functions
Method, auto-increment-sequence-name: Private generic functions
Method, auto-increment-sequence-name: Private generic functions
Method, bad-component: Public generic functions
Method, bindings: Private generic functions
Method, choose-database-for-instance: Private generic functions
Method, close-query-fn: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, collect-table-refs: Private generic functions
Method, command-recording-stream: Public generic functions
Method, commit-hooks: Private generic functions
Method, compute-effective-slot-definition: Public standalone methods
Method, compute-slots: Public standalone methods
Method, conn-pool: Public generic functions
Method, conn-pool-lock: Private generic functions
Method, connection-spec: Public generic functions
Method, connection-spec: Public generic functions
Method, database: Public generic functions
Method, database: Public generic functions
Method, database-abort-transaction: Private generic functions
Method, database-abort-transaction: Private generic functions
Method, database-abort-transaction: Private generic functions
Method, database-acquire-from-conn-pool: Public generic functions
Method, database-add-attribute: Private generic functions
Method, database-add-attribute: Private generic functions
Method, database-add-autoincrement-sequence: Private generic functions
Method, database-add-autoincrement-sequence: Private generic functions
Method, database-attribute-type: Public generic functions
Method, database-attribute-type: Public generic functions
Method, database-attribute-type: Public generic functions
Method, database-attribute-type: Public generic functions
Method, database-autocommit: Public generic functions
Method, database-bind-parameter: Public generic functions
Method, database-bind-parameter: Public generic functions
Method, database-commit-transaction: Private generic functions
Method, database-commit-transaction: Private generic functions
Method, database-commit-transaction: Private generic functions
Method, database-constraint-statement: Private generic functions
Method, database-create-sequence: Public generic functions
Method, database-create-sequence: Public generic functions
Method, database-disconnect: Public generic functions
Method, database-disconnect: Public generic functions
Method, database-disconnect: Public generic functions
Method, database-drop-sequence: Public generic functions
Method, database-drop-sequence: Public generic functions
Method, database-dump-result-set: Public generic functions
Method, database-dump-result-set: Public generic functions
Method, database-dump-result-set: Public generic functions
Method, database-dump-result-set: Public generic functions
Method, database-execute-command: Public generic functions
Method, database-execute-command: Public generic functions
Method, database-execute-command: Public generic functions
Method, database-execute-command: Public generic functions
Method, database-free-prepared: Public generic functions
Method, database-generate-column-definition: Private generic functions
Method, database-generate-column-definition: Private generic functions
Method, database-get-type-specifier: Public generic functions
Method, database-get-type-specifier: Public generic functions
Method, database-get-type-specifier: Public generic functions
Method, database-get-type-specifier: Public generic functions
Method, database-identifier: Private generic functions
Method, database-identifier: Private generic functions
Method, database-identifier: Private generic functions
Method, database-last-auto-increment-id: Public generic functions
Method, database-last-auto-increment-id: Public generic functions
Method, database-list: Public generic functions
Method, database-list: Public generic functions
Method, database-list: Public generic functions
Method, database-list-attributes: Public generic functions
Method, database-list-attributes: Public generic functions
Method, database-list-attributes: Public generic functions
Method, database-list-attributes: Public generic functions
Method, database-list-indexes: Public generic functions
Method, database-list-indexes: Public generic functions
Method, database-list-indexes: Public generic functions
Method, database-list-sequences: Public generic functions
Method, database-list-sequences: Public generic functions
Method, database-list-table-indexes: Public generic functions
Method, database-list-table-indexes: Public generic functions
Method, database-list-table-indexes: Public generic functions
Method, database-list-tables: Public generic functions
Method, database-list-tables: Public generic functions
Method, database-list-tables: Public generic functions
Method, database-list-tables: Public generic functions
Method, database-list-tables-and-sequences: Public generic functions
Method, database-list-tables-and-sequences: Public generic functions
Method, database-list-views: Public generic functions
Method, database-list-views: Public generic functions
Method, database-list-views: Public generic functions
Method, database-list-views: Public generic functions
Method, database-name: Public generic functions
Method, database-odbc-db-type: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql: Private generic functions
Method, database-output-sql-as-type: Public generic functions
Method, database-pkey-constraint: Private generic functions
Method, database-prepare: Public generic functions
Method, database-prepare: Public generic functions
Method, database-prepare: Public generic functions
Method, database-probe: Public generic functions
Method, database-query: Public generic functions
Method, database-query: Public generic functions
Method, database-query: Public generic functions
Method, database-query: Public generic functions
Method, database-query-result-set: Public generic functions
Method, database-query-result-set: Public generic functions
Method, database-query-result-set: Public generic functions
Method, database-query-result-set: Public generic functions
Method, database-query-result-set: Public generic functions
Method, database-reconnect: Public generic functions
Method, database-release-to-conn-pool: Public generic functions
Method, database-remove-autoincrement-sequence: Private generic functions
Method, database-remove-autoincrement-sequence: Private generic functions
Method, database-rename-attribute: Private generic functions
Method, database-rename-attribute: Private generic functions
Method, database-run-prepared: Public generic functions
Method, database-run-prepared: Public generic functions
Method, database-sequence-last: Public generic functions
Method, database-sequence-last: Public generic functions
Method, database-sequence-next: Public generic functions
Method, database-sequence-next: Public generic functions
Method, database-set-sequence-position: Public generic functions
Method, database-set-sequence-position: Public generic functions
Method, database-start-transaction: Private generic functions
Method, database-start-transaction: Private generic functions
Method, database-start-transaction: Private generic functions
Method, database-state: Public generic functions
Method, database-store-next-row: Public generic functions
Method, database-store-next-row: Public generic functions
Method, database-store-next-row: Public generic functions
Method, database-store-next-row: Public generic functions
Method, database-translate-constraint: Private generic functions
Method, database-truncate: Private generic functions
Method, database-type: Public generic functions
Method, database-type-load-foreign: Public generic functions
Method, database-type-load-foreign: Public generic functions
Method, database-underlying-type: Public generic functions
Method, database-view-classes: Private generic functions
Method, db-backend-has-create/destroy-db?: Public generic functions
Method, db-type-default-case: Public generic functions
Method, db-type-default-case: Public generic functions
Method, db-type-has-auto-increment?: Public generic functions
Method, db-type-has-auto-increment?: Public generic functions
Method, db-type-has-auto-increment?: Public generic functions
Method, db-type-has-bigint?: Public generic functions
Method, db-type-has-boolean-where?: Public generic functions
Method, db-type-has-boolean-where?: Public generic functions
Method, db-type-has-except?: Public generic functions
Method, db-type-has-except?: Public generic functions
Method, db-type-has-fancy-math?: Public generic functions
Method, db-type-has-fancy-math?: Public generic functions
Method, db-type-has-intersect?: Public generic functions
Method, db-type-has-intersect?: Public generic functions
Method, db-type-has-prepared-stmt?: Public generic functions
Method, db-type-has-prepared-stmt?: Public generic functions
Method, db-type-has-prepared-stmt?: Public generic functions
Method, db-type-has-subqueries?: Public generic functions
Method, db-type-has-union?: Public generic functions
Method, db-type-has-views?: Public generic functions
Method, db-type-transaction-capable?: Public generic functions
Method, db-type-use-column-on-drop-index?: Public generic functions
Method, db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
Method, db-type-use-fully-qualified-column-on-drop-index?: Public generic functions
Method, db-value: Private generic functions
Method, dbi-package: Private generic functions
Method, delete-instance-records: Public generic functions
Method, direct-slot-definition-class: Public standalone methods
Method, disconnect-fn: Private generic functions
Method, effective-slot-definition-class: Public standalone methods
Method, escaped: Private generic functions
Method, escaped: Private generic functions
Method, execute-command: Public generic functions
Method, execute-command: Public generic functions
Method, expected-type: Private generic functions
Method, expression: Public generic functions
Method, fetch-row-fn: Private generic functions
Method, filter-select-list: Public generic functions
Method, finalize-inheritance: Public standalone methods
Method, free-connections: Private generic functions
Method, get-slot-value-from-record: Private generic functions
Method, get-slot-values-from-view: Private generic functions
Method, has-been-prepared: Public generic functions
Method, has-table-pg_roles: Private generic functions
Method, id: Private generic functions
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, initialize-instance: Public standalone methods
Method, instance-refreshed: Public generic functions
Method, join-slots: Public generic functions
Method, joins: Public generic functions
Method, key-slots: Private generic functions
Method, key-value-from-db: Private generic functions
Method, list-all-database-tables-fn: Private generic functions
Method, list-all-table-columns-fn: Private generic functions
Method, make-load-form: Public standalone methods
Method, make-load-form: Public standalone methods
Method, make-load-form: Public standalone methods
Method, make-load-form: Public standalone methods
Method, make-load-form: Public standalone methods
Method, midnight: Public generic functions
Method, normalizedp: Private generic functions
Method, object-definition: Private generic functions
Method, odbc-conn: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql: Private generic functions
Method, output-sql-hash-key: Private generic functions
Method, output-sql-hash-key: Private generic functions
Method, output-sql-hash-key: Private generic functions
Method, output-sql-hash-key: Private generic functions
Method, parameters: Public generic functions
Method, pool-database-type: Private generic functions
Method, prepare-sql-parameter: Public generic functions
Method, prepared-name: Public generic functions
Method, previous-autocommit: Private generic functions
Method, primary-key-slot-values: Private generic functions
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, print-object: Public standalone methods
Method, query: Public generic functions
Method, query: Public generic functions
Method, query: Public generic functions
Method, read-sql-value: Public generic functions
Method, read-sql-value: Public generic functions
Method, record-caches: Public generic functions
Method, reinitialize-instance: Public standalone methods
Method, result-recording-stream: Public generic functions
Method, result-types: Private generic functions
Method, rollback-hooks: Private generic functions
Method, select-list: Public generic functions
Method, select-table-sql-expr: Private generic functions
Method, slot-defs: Private generic functions
Method, slot-list: Public generic functions
Method, slot-unbound: Public standalone methods
Method, slot-value-using-class: Public standalone methods
Method, specified-type: Private generic functions
Method, sql-error-connection-spec: Public generic functions
Method, sql-error-database: Public generic functions
Method, sql-error-database-message: Public generic functions
Method, sql-error-database-type: Public generic functions
Method, sql-error-error-id: Public generic functions
Method, sql-error-expression: Public generic functions
Method, sql-error-secondary-error-id: Public generic functions
Method, sql-fn: Private generic functions
Method, sql-table: Private generic functions
Method, sql-user-error-message: Public generic functions
Method, sql-warning-database: Public generic functions
Method, sql-warning-message: Private generic functions
Method, stmt-field-names: Private generic functions
Method, to-string: Private generic functions
Method, transaction: Public generic functions
Method, transaction-level: Public generic functions
Method, transaction-status: Private generic functions
Method, unescaped: Private generic functions
Method, unescaped: Private generic functions
Method, update-instance-from-records: Public generic functions
Method, update-record-from-slot: Public generic functions
Method, update-record-from-slots: Public generic functions
Method, update-records-from-instance: Public generic functions
Method, update-slot-default-values: Private generic functions
Method, update-slot-from-db-value: Private generic functions
Method, update-slot-from-record: Public generic functions
Method, update-slot-with-null: Private generic functions
Method, validate-superclass: Public standalone methods
Method, value: Private generic functions
Method, view-class: Private generic functions
Method, view-class: Private generic functions
Method, view-class-qualifier: Private generic functions
Method, view-class-slot-autoincrement-sequence: Private generic functions
Method, view-class-slot-column: Private generic functions
Method, view-class-slot-db-constraints: Private generic functions
Method, view-class-slot-db-info: Private generic functions
Method, view-class-slot-db-kind: Private generic functions
Method, view-class-slot-db-reader: Private generic functions
Method, view-class-slot-db-type: Private generic functions
Method, view-class-slot-db-writer: Private generic functions
Method, view-class-slot-void-value: Private generic functions
Method, view-classes-and-slots-by-name: Private generic functions
Method, view-classes-and-storable-slots: Private generic functions
Method, view-database: Private generic functions
Method, view-table: Public generic functions
Method, view-table: Public generic functions
Method, view-table: Public generic functions
Method, view-table-exp: Private generic functions
Method, view-table-exp: Private generic functions
midnight: Public generic functions
midnight: Public generic functions
mjd-to-gregorian: Public ordinary functions
month-name: Public ordinary functions

N
next-prepared-id: Private ordinary functions
normalized-key-value: Private ordinary functions
normalizedp: Private generic functions
normalizedp: Private generic functions
not-direct-normalized-slot-p: Private ordinary functions
number-string-to-fractional: Private ordinary functions
number-string-to-integer: Private ordinary functions
number-to-sql-string: Public ordinary functions

O
object-definition: Private generic functions
object-definition: Private generic functions
odbc-conn: Private generic functions
odbc-conn: Private generic functions
odbc-result-set-full-set: Private ordinary functions
odbc-result-set-p: Private ordinary functions
odbc-result-set-query: Private ordinary functions
odbc-result-set-types: Private ordinary functions
oid: Private generic functions
order-by-strings: Private ordinary functions
ordered-class-direct-slots: Private ordinary functions
ordered-class-slots: Private ordinary functions
ordinal-day: Private ordinary functions
ordinal-month: Private ordinary functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql: Private generic functions
output-sql-hash-key: Private generic functions
output-sql-hash-key: Private generic functions
output-sql-hash-key: Private generic functions
output-sql-hash-key: Private generic functions
output-sql-hash-key: Private generic functions
output-sql-where-clause: Private ordinary functions
owner-clause: Private ordinary functions

P
parameters: Public generic functions
parameters: Public generic functions
parse-date-time: Public ordinary functions
parse-datestring: Public ordinary functions
parse-db-info: Private ordinary functions
parse-decimal-number: Public ordinary functions
parse-integer-insensitively: Private ordinary functions
parse-iso-8601-duration: Private ordinary functions
parse-iso-8601-time: Private ordinary functions
parse-timestring: Public ordinary functions
parse-yearstring: Public ordinary functions
pool-database-type: Private generic functions
pool-database-type: Private generic functions
pop-n: Private macros
position-char: Private ordinary functions
postgresql-database-list: Private ordinary functions
prepare-sql: Public ordinary functions
prepare-sql-parameter: Public generic functions
prepare-sql-parameter: Public generic functions
prepared-name: Public generic functions
prepared-name: Public generic functions
prepared-sql-to-postgresql-sql: Private ordinary functions
pretty-time: Private ordinary functions
previous-autocommit: Private generic functions
previous-autocommit: Private generic functions
primary-key-slot-values: Private generic functions
primary-key-slot-values: Private generic functions
print-date: Public ordinary functions
print-object: Public standalone methods
print-object: Public standalone methods
print-object: Public standalone methods
print-object: Public standalone methods
print-object: Public standalone methods
print-object: Public standalone methods
print-query: Public ordinary functions
print-readable-symbol: Private ordinary functions
probe-database: Public ordinary functions
process-class-option: Private macros
process-slot-option: Private macros
push-library-path: Public ordinary functions

Q
query: Public generic functions
query: Public generic functions
query: Public generic functions
query: Public generic functions
query-arg-p: Private ordinary functions
query-get-selections: Private ordinary functions
query-string: Private ordinary functions

R
read-decimal-value: Private ordinary functions
read-instance-from-stream: Public ordinary functions
read-large-object: Public ordinary functions
read-sql-value: Public generic functions
read-sql-value: Public generic functions
read-sql-value: Public generic functions
read-stream-to-string: Private ordinary functions
reconnect: Public ordinary functions
record-caches: Public generic functions
record-caches: Public generic functions
record-sql-command: Private ordinary functions
record-sql-result: Private ordinary functions
records-cache-results: Private ordinary functions
register-metaclass: Private ordinary functions
reinitialize-instance: Public standalone methods
release-to-pool: Private ordinary functions
reload-database-types: Public ordinary functions
remove-keyword-arg: Private ordinary functions
replace-all: Private ordinary functions
replace-at-index: Private ordinary functions
replace-string: Private ordinary functions
replaced-string-length: Private ordinary functions
required-argument: Public ordinary functions
reset-command-object: Public ordinary functions
restore-sql-reader-syntax-state: Public macros
restrict-intervals: Private ordinary functions
result-recording-stream: Public generic functions
result-recording-stream: Public generic functions
result-type-or-lose: Public ordinary functions
result-types: Private generic functions
result-types: Private generic functions
roll: Public ordinary functions
roll-to: Public ordinary functions
rollback: Public ordinary functions
rollback-hooks: Private generic functions
rollback-hooks: Private generic functions
round-half-away-from-zero: Public ordinary functions
run-prepared-sql: Public ordinary functions

S
select: Public ordinary functions
select-list: Public generic functions
select-list: Public generic functions
select-reference-equal: Private ordinary functions
select-table-sql-expr: Private generic functions
select-table-sql-expr: Private generic functions
sequence-exists-p: Public ordinary functions
sequence-last: Public ordinary functions
sequence-next: Public ordinary functions
set-autocommit: Public ordinary functions
set-sequence-position: Public ordinary functions
set-view-table-slot: Private ordinary functions
shrink-vector: Public macros
signal-closed-database-error: Private ordinary functions
signal-database-too-strange: Private ordinary functions
signal-no-database-error: Private ordinary functions
slot-defs: Private generic functions
slot-defs: Private generic functions
slot-has-default-p: Private ordinary functions
slot-list: Public generic functions
slot-list: Public generic functions
slot-unbound: Public standalone methods
slot-value-using-class: Public standalone methods
slotdef-for-slot-with-class: Private ordinary functions
slotdefs-for-slots-with-class: Private ordinary functions
slots-for-possibly-normalized-class: Private ordinary functions
sort-interval-list: Private ordinary functions
special-cased-symbol-p: Private ordinary functions
special-char-p: Private ordinary functions
specified-type: Private generic functions
specified-type: Private generic functions
sql: Public ordinary functions
sql-*: Public ordinary functions
sql-+: Public ordinary functions
sql--: Public ordinary functions
sql-/: Public ordinary functions
sql-<: Public ordinary functions
sql-<=: Public ordinary functions
sql-<>: Public ordinary functions
sql-=: Public ordinary functions
sql-==: Public ordinary functions
sql->: Public ordinary functions
sql->=: Public ordinary functions
sql-all: Public ordinary functions
sql-and: Public ordinary functions
sql-any: Public ordinary functions
sql-avg: Public ordinary functions
sql-between: Public ordinary functions
sql-coalesce: Public ordinary functions
sql-concat: Public ordinary functions
sql-concat-op: Public ordinary functions
sql-count: Public ordinary functions
sql-distinct: Public ordinary functions
sql-e-string: Private ordinary functions
sql-error-connection-spec: Public generic functions
sql-error-connection-spec: Public generic functions
sql-error-database: Public generic functions
sql-error-database: Public generic functions
sql-error-database-message: Public generic functions
sql-error-database-message: Public generic functions
sql-error-database-type: Public generic functions
sql-error-database-type: Public generic functions
sql-error-error-id: Public generic functions
sql-error-error-id: Public generic functions
sql-error-expression: Public generic functions
sql-error-expression: Public generic functions
sql-error-secondary-error-id: Public generic functions
sql-error-secondary-error-id: Public generic functions
sql-escape: Public ordinary functions
sql-escape-quotes: Public ordinary functions
sql-except: Public ordinary functions
sql-exists: Public ordinary functions
sql-expression: Public ordinary functions
sql-fn: Private generic functions
sql-fn: Private generic functions
sql-function: Public ordinary functions
sql-group-by: Public ordinary functions
sql-having: Public ordinary functions
sql-in: Public ordinary functions
sql-intersect: Public ordinary functions
sql-is: Public ordinary functions
sql-like: Public ordinary functions
sql-limit: Public ordinary functions
sql-lower: Private ordinary functions
sql-max: Public ordinary functions
sql-min: Public ordinary functions
sql-minus: Public ordinary functions
sql-not: Public ordinary functions
sql-not-null: Public ordinary functions
sql-null: Public ordinary functions
sql-nvl: Public ordinary functions
sql-operation: Public ordinary functions
sql-operator: Public ordinary functions
sql-or: Public ordinary functions
sql-order-by: Public ordinary functions
sql-output: Private ordinary functions
sql-query: Public ordinary functions
sql-reader-open: Private ordinary functions
sql-recording-p: Public ordinary functions
sql-slot-value: Public ordinary functions
sql-some: Public ordinary functions
sql-stream: Public ordinary functions
sql-substr: Public ordinary functions
sql-substring: Public ordinary functions
sql-sum: Public ordinary functions
sql-table: Private generic functions
sql-table: Private generic functions
sql-the: Public ordinary functions
sql-union: Public ordinary functions
sql-uplike: Public ordinary functions
sql-upper: Private ordinary functions
sql-user-error-message: Public generic functions
sql-user-error-message: Public generic functions
sql-userenv: Public ordinary functions
sql-view-class: Public ordinary functions
sql-warning-database: Public generic functions
sql-warning-database: Public generic functions
sql-warning-message: Private generic functions
sql-warning-message: Private generic functions
start-sql-recording: Public ordinary functions
start-transaction: Public ordinary functions
status: Public ordinary functions
stmt-field-names: Private generic functions
stmt-field-names: Private generic functions
stop-sql-recording: Public ordinary functions
string-align: Private ordinary functions
string-to-list-connection-spec: Private ordinary functions
substitute-char-string: Private ordinary functions
substitute-chars-strings: Private ordinary functions
substitute-string-for-char: Private ordinary functions
symbol-name-default-case: Public ordinary functions
syntax-parse-iso-8601: Private ordinary functions

T
table-exists-p: Public ordinary functions
table-name-from-arg: Private ordinary functions
time+: Public ordinary functions
time-: Public ordinary functions
time->date: Private ordinary functions
time-compare: Public ordinary functions
time-difference: Public ordinary functions
time-dow: Public ordinary functions
time-element: Public ordinary functions
time-hms: Private ordinary functions
time-max: Public ordinary functions
time-meridian: Private ordinary functions
time-min: Public ordinary functions
time-mjd: Public ordinary functions
time-second: Private ordinary functions
time-usec: Private ordinary functions
time-ymd: Public ordinary functions
time/=: Private ordinary functions
time<: Public ordinary functions
time<=: Public ordinary functions
time=: Public ordinary functions
time>: Public ordinary functions
time>=: Public ordinary functions
to-attributes-and-values: Private ordinary functions
to-class: Private ordinary functions
to-class-name: Private ordinary functions
to-slot-name: Private ordinary functions
to-string: Private generic functions
to-string: Private generic functions
transaction: Public generic functions
transaction: Public generic functions
transaction-level: Public generic functions
transaction-level: Public generic functions
transaction-status: Private generic functions
transaction-status: Private generic functions
truncate-database: Public ordinary functions

U
unescaped: Private generic functions
unescaped: Private generic functions
unescaped: Private generic functions
unescaped-database-identifier: Private ordinary functions
update-auto-increments-keys: Private ordinary functions
update-fault-join-normalized-slot: Private ordinary functions
update-instance-from-records: Public generic functions
update-instance-from-records: Public generic functions
update-objects-joins: Public ordinary functions
update-record-from-slot: Public generic functions
update-record-from-slot: Public generic functions
update-record-from-slots: Public generic functions
update-record-from-slots: Public generic functions
update-records: Public ordinary functions
update-records-from-instance: Public generic functions
update-records-from-instance: Public generic functions
update-slot-default-values: Private generic functions
update-slot-default-values: Private generic functions
update-slot-from-db: Private generic functions
update-slot-from-db-value: Private generic functions
update-slot-from-db-value: Private generic functions
update-slot-from-record: Public generic functions
update-slot-from-record: Public generic functions
update-slot-with-null: Private generic functions
update-slot-with-null: Private generic functions
utime->time: Public ordinary functions

V
valid-gregorian-date-p: Private ordinary functions
valid-month-p: Private ordinary functions
validate-superclass: Public standalone methods
value: Private generic functions
value: Private generic functions
view-class: Private generic functions
view-class: Private generic functions
view-class: Private generic functions
view-class-qualifier: Private generic functions
view-class-qualifier: Private generic functions
view-class-slot-autoincrement-sequence: Private generic functions
view-class-slot-autoincrement-sequence: Private generic functions
view-class-slot-column: Private generic functions
view-class-slot-column: Private generic functions
view-class-slot-db-constraints: Private generic functions
view-class-slot-db-constraints: Private generic functions
view-class-slot-db-info: Private generic functions
view-class-slot-db-info: Private generic functions
view-class-slot-db-kind: Private generic functions
view-class-slot-db-kind: Private generic functions
view-class-slot-db-reader: Private generic functions
view-class-slot-db-reader: Private generic functions
view-class-slot-db-type: Private generic functions
view-class-slot-db-type: Private generic functions
view-class-slot-db-writer: Private generic functions
view-class-slot-db-writer: Private generic functions
view-class-slot-void-value: Private generic functions
view-class-slot-void-value: Private generic functions
view-classes-and-slots-by-name: Private generic functions
view-classes-and-slots-by-name: Private generic functions
view-classes-and-storable-slots: Private generic functions
view-classes-and-storable-slots: Private generic functions
view-database: Private generic functions
view-database: Private generic functions
view-exists-p: Public ordinary functions
view-table: Public generic functions
view-table: Public generic functions
view-table: Public generic functions
view-table: Public generic functions
view-table-exp: Private generic functions
view-table-exp: Private generic functions
view-table-exp: Private generic functions

W
wall-time-p: Private ordinary functions
week-containing: Public ordinary functions
where-strings: Private ordinary functions
with-database: Public macros
with-default-database: Public macros
with-process-lock: Public macros
with-transaction: Public macros
without-interrupts: Public macros
wrap-time-for-date: Private macros
write-instance-to-stream: Public ordinary functions
write-large-object: Public ordinary functions


A.3 Variables

Jump to:   *   +  
A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   Y  
Index Entry  Section

*
*backend-warning-behavior*: Public special variables
*cache-table-queries-default*: Public special variables
*connect-if-exists*: Public special variables
*connected-databases*: Private special variables
*day-keywords*: Private special variables
*day-names*: Private special variables
*db-auto-sync*: Public special variables
*db-deserializing*: Private special variables
*db-info-lambda-list*: Private special variables
*db-initializing*: Private special variables
*db-pool*: Private special variables
*db-pool-lock*: Private special variables
*db-pool-max-free-connections*: Public special variables
*default-caching*: Public special variables
*default-database*: Public special variables
*default-database-type*: Public special variables
*default-encoding*: Private special variables
*default-string-length*: Public special variables
*default-update-objects-max-len*: Public special variables
*foreign-library-search-paths*: Public special variables
*in-subselect*: Private special variables
*initialized-database-types*: Public special variables
*iso-8601-duration-delimiters*: Private special variables
*loaded-database-types*: Public special variables
*month-keywords*: Private special variables
*month-names*: Private special variables
*next-prepared-id-num*: Private special variables
*old-sequence-names*: Public special variables
*original-readtable*: Private special variables
*output-hash*: Private special variables
*restore-sql-reader-syntax*: Private special variables
*roman-digits*: Private special variables
*select-arguments*: Private special variables
*sql-macro-close-char*: Private special variables
*sql-macro-open-char*: Private special variables
*sql-op-table*: Private special variables
*sql-stream*: Private special variables

+
+auto-increment-names+: Private special variables
+empty-string+: Private special variables
+extra-class-options+: Private special variables
+extra-slot-options+: Private special variables
+no-slot-value+: Private special variables
+null-string+: Private special variables
+whitespace-chars+: Private special variables

A
a: Private classes
alias: Public classes
all: Public classes
all-connections: Public classes
args: Public classes
attribute: Private classes
attribute-cache: Public classes
attributes: Private classes
attributes: Private classes
autocommit: Public classes
autoincrement-sequence: Private classes

B
b: Private classes
bad-component: Private conditions
bindings: Private classes

C
class-qualifier: Private classes
close-query-fn: Public classes
column: Private classes
column-list: Private classes
columns: Private classes
command-recording-stream: Public classes
commit-hooks: Public classes
components: Public classes
components: Public classes
conn-pool: Public classes
connection-spec: Public conditions
connection-spec: Public classes
connection-spec: Public classes
contained: Private structures

D
data: Private structures
database: Public conditions
database: Public conditions
database: Private conditions
database: Private classes
database-message: Public conditions
database-type: Public conditions
database-type: Public classes
database-type: Public classes
day: Public structures
db-constraints: Private classes
db-info: Private classes
db-kind: Private classes
db-reader: Private classes
db-type: Private classes
db-value: Private classes
db-writer: Private classes
dbi-package: Public classes
definition: Private classes
disconnect-fn: Public classes
distinct: Public classes

E
encoding: Public classes
end: Private structures
error-id: Public conditions
escaped: Private classes
exp: Public classes
expected-type: Private conditions
expression: Public conditions
expression: Public classes

F
fetch-row: Public classes
field-names: Private classes
flatp: Public classes
flatp: Public classes
free-connections: Public classes
from: Public classes
from: Private classes
full-set: Private structures

G
group-by: Public classes

H
has-been-prepared: Public classes
has-table-pg_roles: Public classes
having: Public classes
hour: Public structures

I
id: Private classes
inner-join: Public classes
into: Private classes

J
join-slots: Public classes
joins: Public classes

K
key-slots: Private classes

L
limit: Public classes
list-all-database-tables-fn: Public classes
list-all-table-columns-fn: Public classes
lock: Public classes

M
message: Public conditions
message: Public conditions
minute: Public structures
mjd: Public structures
mjd: Public structures
modifier: Public classes
modifier: Public classes
modifiers: Private classes
month: Public structures

N
name: Public classes
name: Public classes
name: Public classes
name: Private structures
name: Private classes
name: Private classes
normalizedp: Private classes

O
objects: Public classes
odbc-conn: Public classes
odbc-db-type: Public classes
offset: Public classes
on: Public classes
operator: Public classes
operator: Public classes
order-by: Public classes

P
parameters: Public classes
prepared-name: Public classes
previous-autocommit: Public classes

Q
qualifier: Public classes
query: Private structures
query: Private classes
query: Private classes

R
record-caches: Public classes
refresh: Public classes
result-recording-stream: Public classes
result-types: Private classes
rollback-hooks: Public classes

S
second: Public structures
second: Public structures
secondary-error-id: Public conditions
select-list: Public classes
selections: Public classes
set-operation: Public classes
Slot, a: Private classes
Slot, alias: Public classes
Slot, all: Public classes
Slot, all-connections: Public classes
Slot, args: Public classes
Slot, attribute: Private classes
Slot, attribute-cache: Public classes
Slot, attributes: Private classes
Slot, attributes: Private classes
Slot, autocommit: Public classes
Slot, autoincrement-sequence: Private classes
Slot, b: Private classes
Slot, bad-component: Private conditions
Slot, bindings: Private classes
Slot, class-qualifier: Private classes
Slot, close-query-fn: Public classes
Slot, column: Private classes
Slot, column-list: Private classes
Slot, columns: Private classes
Slot, command-recording-stream: Public classes
Slot, commit-hooks: Public classes
Slot, components: Public classes
Slot, components: Public classes
Slot, conn-pool: Public classes
Slot, connection-spec: Public conditions
Slot, connection-spec: Public classes
Slot, connection-spec: Public classes
Slot, contained: Private structures
Slot, data: Private structures
Slot, database: Public conditions
Slot, database: Public conditions
Slot, database: Private conditions
Slot, database: Private classes
Slot, database-message: Public conditions
Slot, database-type: Public conditions
Slot, database-type: Public classes
Slot, database-type: Public classes
Slot, day: Public structures
Slot, db-constraints: Private classes
Slot, db-info: Private classes
Slot, db-kind: Private classes
Slot, db-reader: Private classes
Slot, db-type: Private classes
Slot, db-value: Private classes
Slot, db-writer: Private classes
Slot, dbi-package: Public classes
Slot, definition: Private classes
Slot, disconnect-fn: Public classes
Slot, distinct: Public classes
Slot, encoding: Public classes
Slot, end: Private structures
Slot, error-id: Public conditions
Slot, escaped: Private classes
Slot, exp: Public classes
Slot, expected-type: Private conditions
Slot, expression: Public conditions
Slot, expression: Public classes
Slot, fetch-row: Public classes
Slot, field-names: Private classes
Slot, flatp: Public classes
Slot, flatp: Public classes
Slot, free-connections: Public classes
Slot, from: Public classes
Slot, from: Private classes
Slot, full-set: Private structures
Slot, group-by: Public classes
Slot, has-been-prepared: Public classes
Slot, has-table-pg_roles: Public classes
Slot, having: Public classes
Slot, hour: Public structures
Slot, id: Private classes
Slot, inner-join: Public classes
Slot, into: Private classes
Slot, join-slots: Public classes
Slot, joins: Public classes
Slot, key-slots: Private classes
Slot, limit: Public classes
Slot, list-all-database-tables-fn: Public classes
Slot, list-all-table-columns-fn: Public classes
Slot, lock: Public classes
Slot, message: Public conditions
Slot, message: Public conditions
Slot, minute: Public structures
Slot, mjd: Public structures
Slot, mjd: Public structures
Slot, modifier: Public classes
Slot, modifier: Public classes
Slot, modifiers: Private classes
Slot, month: Public structures
Slot, name: Public classes
Slot, name: Public classes
Slot, name: Public classes
Slot, name: Private structures
Slot, name: Private classes
Slot, name: Private classes
Slot, normalizedp: Private classes
Slot, objects: Public classes
Slot, odbc-conn: Public classes
Slot, odbc-db-type: Public classes
Slot, offset: Public classes
Slot, on: Public classes
Slot, operator: Public classes
Slot, operator: Public classes
Slot, order-by: Public classes
Slot, parameters: Public classes
Slot, prepared-name: Public classes
Slot, previous-autocommit: Public classes
Slot, qualifier: Public classes
Slot, query: Private structures
Slot, query: Private classes
Slot, query: Private classes
Slot, record-caches: Public classes
Slot, refresh: Public classes
Slot, result-recording-stream: Public classes
Slot, result-types: Private classes
Slot, rollback-hooks: Public classes
Slot, second: Public structures
Slot, second: Public structures
Slot, secondary-error-id: Public conditions
Slot, select-list: Public classes
Slot, selections: Public classes
Slot, set-operation: Public classes
Slot, slot-defs: Private classes
Slot, slot-list: Public classes
Slot, specified-type: Private classes
Slot, sql-fn: Public classes
Slot, start: Private structures
Slot, state: Public classes
Slot, status: Public classes
Slot, string: Private classes
Slot, sub-expressions: Public classes
Slot, sub-expressions: Public classes
Slot, table: Private classes
Slot, text: Public classes
Slot, transaction: Public classes
Slot, transaction-level: Public classes
Slot, transactions: Private classes
Slot, type: Public classes
Slot, type: Private structures
Slot, types: Private structures
Slot, unescaped: Private classes
Slot, usec: Public structures
Slot, usec: Public structures
Slot, value: Private conditions
Slot, values: Private classes
Slot, values: Private classes
Slot, view-class: Public classes
Slot, view-class: Private classes
Slot, view-classes: Public classes
Slot, view-database: Public classes
Slot, view-table: Private classes
Slot, void-value: Private classes
Slot, where: Public classes
Slot, where: Private classes
Slot, where: Private classes
Slot, with-check-option: Private classes
Slot, year: Public structures
slot-defs: Private classes
slot-list: Public classes
Special Variable, *backend-warning-behavior*: Public special variables
Special Variable, *cache-table-queries-default*: Public special variables
Special Variable, *connect-if-exists*: Public special variables
Special Variable, *connected-databases*: Private special variables
Special Variable, *day-keywords*: Private special variables
Special Variable, *day-names*: Private special variables
Special Variable, *db-auto-sync*: Public special variables
Special Variable, *db-deserializing*: Private special variables
Special Variable, *db-info-lambda-list*: Private special variables
Special Variable, *db-initializing*: Private special variables
Special Variable, *db-pool*: Private special variables
Special Variable, *db-pool-lock*: Private special variables
Special Variable, *db-pool-max-free-connections*: Public special variables
Special Variable, *default-caching*: Public special variables
Special Variable, *default-database*: Public special variables
Special Variable, *default-database-type*: Public special variables
Special Variable, *default-encoding*: Private special variables
Special Variable, *default-string-length*: Public special variables
Special Variable, *default-update-objects-max-len*: Public special variables
Special Variable, *foreign-library-search-paths*: Public special variables
Special Variable, *in-subselect*: Private special variables
Special Variable, *initialized-database-types*: Public special variables
Special Variable, *iso-8601-duration-delimiters*: Private special variables
Special Variable, *loaded-database-types*: Public special variables
Special Variable, *month-keywords*: Private special variables
Special Variable, *month-names*: Private special variables
Special Variable, *next-prepared-id-num*: Private special variables
Special Variable, *old-sequence-names*: Public special variables
Special Variable, *original-readtable*: Private special variables
Special Variable, *output-hash*: Private special variables
Special Variable, *restore-sql-reader-syntax*: Private special variables
Special Variable, *roman-digits*: Private special variables
Special Variable, *select-arguments*: Private special variables
Special Variable, *sql-macro-close-char*: Private special variables
Special Variable, *sql-macro-open-char*: Private special variables
Special Variable, *sql-op-table*: Private special variables
Special Variable, *sql-stream*: Private special variables
Special Variable, +auto-increment-names+: Private special variables
Special Variable, +empty-string+: Private special variables
Special Variable, +extra-class-options+: Private special variables
Special Variable, +extra-slot-options+: Private special variables
Special Variable, +no-slot-value+: Private special variables
Special Variable, +null-string+: Private special variables
Special Variable, +whitespace-chars+: Private special variables
specified-type: Private classes
sql-fn: Public classes
start: Private structures
state: Public classes
status: Public classes
string: Private classes
sub-expressions: Public classes
sub-expressions: Public classes

T
table: Private classes
text: Public classes
transaction: Public classes
transaction-level: Public classes
transactions: Private classes
type: Public classes
type: Private structures
types: Private structures

U
unescaped: Private classes
usec: Public structures
usec: Public structures

V
value: Private conditions
values: Private classes
values: Private classes
view-class: Public classes
view-class: Private classes
view-classes: Public classes
view-database: Public classes
view-table: Private classes
void-value: Private classes

W
where: Public classes
where: Private classes
where: Private classes
with-check-option: Private classes

Y
year: Public structures


A.4 Data types

Jump to:   %  
A   B   C   D   E   F   G   I   K   L   M   O   P   R   S   T   U   V   W  
Index Entry  Section

%
%database-identifier: Private classes
%slot-order-test-class: Private classes
%sql-expression: Private classes

A
ansi-loop: The ansi-loop package
attribute-value-pair: Private classes

B
base: The clsql/sql/base module
base-classes.lisp: The clsql/sql/base/base-classes․lisp file
bigint: Public types

C
Class, %database-identifier: Private classes
Class, %slot-order-test-class: Private classes
Class, %sql-expression: Private classes
Class, attribute-value-pair: Private classes
Class, class-and-slots: Private classes
Class, command-object: Public classes
Class, conn-pool: Public classes
Class, database: Public classes
Class, generic-database: Private classes
Class, generic-odbc-database: Public classes
Class, generic-postgresql-database: Public classes
Class, postgresql-stmt: Private classes
Class, select-list: Public classes
Class, sql: Public classes
Class, sql-assignment-exp: Public classes
Class, sql-between-exp: Public classes
Class, sql-create-table: Private classes
Class, sql-create-view: Private classes
Class, sql-delete: Private classes
Class, sql-escape-string-exp: Private classes
Class, sql-function-exp: Public classes
Class, sql-ident: Public classes
Class, sql-ident-attribute: Public classes
Class, sql-ident-table: Public classes
Class, sql-insert: Private classes
Class, sql-object-query: Public classes
Class, sql-query: Public classes
Class, sql-query-modifier-exp: Public classes
Class, sql-relational-exp: Public classes
Class, sql-set-exp: Public classes
Class, sql-typecast-exp: Public classes
Class, sql-upcase-like: Public classes
Class, sql-update: Private classes
Class, sql-value-exp: Public classes
Class, standard-db-class: Private classes
Class, standard-db-object: Public classes
Class, transaction: Public classes
Class, view-class-direct-slot-definition: Private classes
Class, view-class-effective-slot-definition: Private classes
Class, view-class-slot-definition-mixin: Private classes
class-and-slots: Private classes
clsql: The clsql system
clsql: The clsql package
clsql-sys: The clsql-sys package
clsql-system: The clsql-system package
clsql-user: The clsql-user package
clsql.asd: The clsql/clsql․asd file
cmucl-compat: The cmucl-compat package
cmucl-compat.lisp: The clsql/sql/base/cmucl-compat․lisp file
command-object: Public classes
command-object.lisp: The clsql/sql/generic/command-object․lisp file
Condition, database-too-strange: Private conditions
Condition, decimal-parse-error: Public conditions
Condition, iso-8601-syntax-error: Private conditions
Condition, sql-condition: Public conditions
Condition, sql-connection-error: Public conditions
Condition, sql-database-data-error: Public conditions
Condition, sql-database-error: Public conditions
Condition, sql-database-warning: Public conditions
Condition, sql-error: Public conditions
Condition, sql-fatal-error: Public conditions
Condition, sql-temporary-error: Public conditions
Condition, sql-timeout-error: Public conditions
Condition, sql-user-error: Public conditions
Condition, sql-value-conversion-error: Private conditions
Condition, sql-warning: Public conditions
conditions.lisp: The clsql/sql/base/conditions․lisp file
conn-pool: Public classes

D
database: The clsql/sql/database module
database: Public classes
database-too-strange: Private conditions
database.lisp: The clsql/sql/database/database․lisp file
date: Public structures
db-interface.lisp: The clsql/sql/base/db-interface․lisp file
decimal-parse-error: Public conditions
decimals: The decimals package
decimals.lisp: The clsql/sql/base/decimals․lisp file
duration: Public structures

E
expressions.lisp: The clsql/sql/syntax/expressions․lisp file

F
fddl.lisp: The clsql/sql/functional/fddl․lisp file
fdml.lisp: The clsql/sql/functional/fdml․lisp file
File, base-classes.lisp: The clsql/sql/base/base-classes․lisp file
File, clsql.asd: The clsql/clsql․asd file
File, cmucl-compat.lisp: The clsql/sql/base/cmucl-compat․lisp file
File, command-object.lisp: The clsql/sql/generic/command-object․lisp file
File, conditions.lisp: The clsql/sql/base/conditions․lisp file
File, database.lisp: The clsql/sql/database/database․lisp file
File, db-interface.lisp: The clsql/sql/base/db-interface․lisp file
File, decimals.lisp: The clsql/sql/base/decimals․lisp file
File, expressions.lisp: The clsql/sql/syntax/expressions․lisp file
File, fddl.lisp: The clsql/sql/functional/fddl․lisp file
File, fdml.lisp: The clsql/sql/functional/fdml․lisp file
File, generic-odbc.lisp: The clsql/sql/generic/generic-odbc․lisp file
File, generic-postgresql.lisp: The clsql/sql/generic/generic-postgresql․lisp file
File, generics.lisp: The clsql/sql/base/generics․lisp file
File, initialize.lisp: The clsql/sql/database/initialize․lisp file
File, kmr-mop.lisp: The clsql/sql/base/kmr-mop․lisp file
File, loop-extension.lisp: The clsql/sql/functional/loop-extension․lisp file
File, metaclasses.lisp: The clsql/sql/object/metaclasses․lisp file
File, ooddl.lisp: The clsql/sql/object/ooddl․lisp file
File, oodml.lisp: The clsql/sql/object/oodml․lisp file
File, operations.lisp: The clsql/sql/syntax/operations․lisp file
File, package.lisp: The clsql/sql/base/package․lisp file
File, pool.lisp: The clsql/sql/database/pool․lisp file
File, recording.lisp: The clsql/sql/database/recording․lisp file
File, sequences.lisp: The clsql/sql/generic/sequences․lisp file
File, syntax.lisp: The clsql/sql/syntax/syntax․lisp file
File, time.lisp: The clsql/sql/base/time․lisp file
File, transaction.lisp: The clsql/sql/functional/transaction․lisp file
File, utils.lisp: The clsql/sql/base/utils․lisp file
functional: The clsql/sql/functional module

G
generalized-boolean: Public types
generic: The clsql/sql/generic module
generic-database: Private classes
generic-odbc-database: Public classes
generic-odbc.lisp: The clsql/sql/generic/generic-odbc․lisp file
generic-postgresql-database: Public classes
generic-postgresql.lisp: The clsql/sql/generic/generic-postgresql․lisp file
generics.lisp: The clsql/sql/base/generics․lisp file

I
initialize.lisp: The clsql/sql/database/initialize․lisp file
interval: Private structures
iso-8601-syntax-error: Private conditions

K
kmr-mop.lisp: The clsql/sql/base/kmr-mop․lisp file

L
loop-extension.lisp: The clsql/sql/functional/loop-extension․lisp file

M
mediumint: Public types
metaclasses.lisp: The clsql/sql/object/metaclasses․lisp file
Module, base: The clsql/sql/base module
Module, database: The clsql/sql/database module
Module, functional: The clsql/sql/functional module
Module, generic: The clsql/sql/generic module
Module, object: The clsql/sql/object module
Module, sql: The clsql/sql module
Module, syntax: The clsql/sql/syntax module

O
object: The clsql/sql/object module
odbc-result-set: Private structures
ooddl.lisp: The clsql/sql/object/ooddl․lisp file
oodml.lisp: The clsql/sql/object/oodml․lisp file
operations.lisp: The clsql/sql/syntax/operations․lisp file

P
Package, ansi-loop: The ansi-loop package
Package, clsql: The clsql package
Package, clsql-sys: The clsql-sys package
Package, clsql-system: The clsql-system package
Package, clsql-user: The clsql-user package
Package, cmucl-compat: The cmucl-compat package
Package, decimals: The decimals package
package.lisp: The clsql/sql/base/package․lisp file
pool.lisp: The clsql/sql/database/pool․lisp file
postgresql-stmt: Private classes

R
recording.lisp: The clsql/sql/database/recording․lisp file

S
select-list: Public classes
sequences.lisp: The clsql/sql/generic/sequences․lisp file
smallint: Public types
sql: The clsql/sql module
sql: Public classes
sql-assignment-exp: Public classes
sql-between-exp: Public classes
sql-condition: Public conditions
sql-connection-error: Public conditions
sql-create-table: Private classes
sql-create-view: Private classes
sql-database-data-error: Public conditions
sql-database-error: Public conditions
sql-database-warning: Public conditions
sql-delete: Private classes
sql-error: Public conditions
sql-escape-string-exp: Private classes
sql-fatal-error: Public conditions
sql-function-exp: Public classes
sql-ident: Public classes
sql-ident-attribute: Public classes
sql-ident-table: Public classes
sql-insert: Private classes
sql-object-query: Public classes
sql-query: Public classes
sql-query-modifier-exp: Public classes
sql-relational-exp: Public classes
sql-set-exp: Public classes
sql-temporary-error: Public conditions
sql-timeout-error: Public conditions
sql-typecast-exp: Public classes
sql-upcase-like: Public classes
sql-update: Private classes
sql-user-error: Public conditions
sql-value-conversion-error: Private conditions
sql-value-exp: Public classes
sql-warning: Public conditions
standard-db-class: Private classes
standard-db-object: Public classes
Structure, date: Public structures
Structure, duration: Public structures
Structure, interval: Private structures
Structure, odbc-result-set: Private structures
Structure, wall-time: Public structures
syntax: The clsql/sql/syntax module
syntax.lisp: The clsql/sql/syntax/syntax․lisp file
System, clsql: The clsql system

T
time.lisp: The clsql/sql/base/time․lisp file
tinyint: Public types
transaction: Public classes
transaction.lisp: The clsql/sql/functional/transaction․lisp file
Type, bigint: Public types
Type, generalized-boolean: Public types
Type, mediumint: Public types
Type, smallint: Public types
Type, tinyint: Public types
Type, universal-time: Public types
Type, varchar: Public types

U
universal-time: Public types
utils.lisp: The clsql/sql/base/utils․lisp file

V
varchar: Public types
view-class-direct-slot-definition: Private classes
view-class-effective-slot-definition: Private classes
view-class-slot-definition-mixin: Private classes

W
wall-time: Public structures