The hu.dwim.rdbms Reference Manual

Table of Contents

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

The hu.dwim.rdbms Reference Manual

This is the hu.dwim.rdbms Reference Manual, generated automatically by Declt version 2.3 "Robert April" on Wed Mar 14 04:02:37 2018 GMT+0.


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

1 Introduction

http://dwim.hu/project/hu.dwim.rdbms

Davit Lichteblau and Tomas Hlavaty's have an extensive fork. Merging
is considered, but not planned in the near future.

http://src.knowledgetools.de/tomas/porting/


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

2 Systems

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


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

2.1 hu.dwim.rdbms

Authors

Tamás Borbély <tomi.borbely@gmail.com>
Attila Lendvai <attila.lendvai@gmail.com>
Levente Mészáros <levente.meszaros@gmail.com>

License

BSD or Bugroff

Description

Relational database independent RDBMS and SQL abstractions.

Defsystem Dependency

hu.dwim.asdf

Dependencies
Source

hu.dwim.rdbms.asd (file)

Component

source (module)


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

3 Modules

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


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

3.1 hu.dwim.rdbms/source

Parent

hu.dwim.rdbms (system)

Location

source/

Components

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

3.2 hu.dwim.rdbms/source/generic

Dependencies
Parent

source (module)

Location

source/generic/

Components

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

3.3 hu.dwim.rdbms/source/syntax

Dependency

generic (module)

Parent

source (module)

Location

source/syntax/

Components

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

4 Files

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


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

4.1 Lisp


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

4.1.1 hu.dwim.rdbms.asd

Location

hu.dwim.rdbms.asd

Systems

hu.dwim.rdbms (system)


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

4.1.2 hu.dwim.rdbms/source/conditions.lisp

Dependency

package.lisp (file)

Parent

source (module)

Location

source/conditions.lisp

Exported Definitions
Internal Definitions

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

4.1.3 hu.dwim.rdbms/source/logger.lisp

Dependency

package.lisp (file)

Parent

source (module)

Location

source/logger.lisp

Exported Definitions
Internal Definitions

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

4.1.4 hu.dwim.rdbms/source/package.lisp

Parent

source (module)

Location

source/package.lisp

Packages

hu.dwim.rdbms


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

4.1.5 hu.dwim.rdbms/source/generic/cursor.lisp

Dependency

transaction.lisp (file)

Parent

generic (module)

Location

source/generic/cursor.lisp

Exported Definitions
Internal Definitions

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

4.1.6 hu.dwim.rdbms/source/generic/database.lisp

Parent

generic (module)

Location

source/generic/database.lisp

Exported Definitions
Internal Definitions

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

4.1.7 hu.dwim.rdbms/source/generic/ddl.lisp

Dependency

transaction.lisp (file)

Parent

generic (module)

Location

source/generic/ddl.lisp

Exported Definitions
Internal Definitions

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

4.1.8 hu.dwim.rdbms/source/generic/dml.lisp

Dependency

transaction.lisp (file)

Parent

generic (module)

Location

source/generic/dml.lisp

Exported Definitions
Internal Definitions

sql-literal-values-for (function)


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

4.1.9 hu.dwim.rdbms/source/generic/transaction.lisp

Dependency

database.lisp (file)

Parent

generic (module)

Location

source/generic/transaction.lisp

Exported Definitions
Internal Definitions

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

4.1.10 hu.dwim.rdbms/source/syntax/alter-table.lisp

Dependencies
Parent

syntax (module)

Location

source/syntax/alter-table.lisp

Exported Definitions
Internal Definitions

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

4.1.11 hu.dwim.rdbms/source/syntax/constraint.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/constraint.lisp

Exported Definitions
Internal Definitions

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

4.1.12 hu.dwim.rdbms/source/syntax/create-table.lisp

Dependencies
Parent

syntax (module)

Location

source/syntax/create-table.lisp

Exported Definitions
Internal Definitions

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

4.1.13 hu.dwim.rdbms/source/syntax/delete.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/delete.lisp

Internal Definitions

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

4.1.14 hu.dwim.rdbms/source/syntax/drop-table.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/drop-table.lisp

Internal Definitions

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

4.1.15 hu.dwim.rdbms/source/syntax/expression.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/expression.lisp

Exported Definitions
Internal Definitions

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

4.1.16 hu.dwim.rdbms/source/syntax/format.lisp

Parent

syntax (module)

Location

source/syntax/format.lisp

Exported Definitions
Internal Definitions

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

4.1.17 hu.dwim.rdbms/source/syntax/index.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/index.lisp

Exported Definitions
Internal Definitions

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

4.1.18 hu.dwim.rdbms/source/syntax/insert.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/insert.lisp

Internal Definitions

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

4.1.19 hu.dwim.rdbms/source/syntax/lock.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/lock.lisp

Internal Definitions

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

4.1.20 hu.dwim.rdbms/source/syntax/reader-macro.lisp

Parent

syntax (module)

Location

source/syntax/reader-macro.lisp

Exported Definitions

enable-sql-syntax (macro)

Internal Definitions

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

4.1.21 hu.dwim.rdbms/source/syntax/select.lisp

Dependencies
Parent

syntax (module)

Location

source/syntax/select.lisp

Internal Definitions

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

4.1.22 hu.dwim.rdbms/source/syntax/sequence.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/sequence.lisp

Internal Definitions

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

4.1.23 hu.dwim.rdbms/source/syntax/sexp.lisp

Dependencies
Parent

syntax (module)

Location

source/syntax/sexp.lisp

Exported Definitions

sql (macro)

Internal Definitions

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

4.1.24 hu.dwim.rdbms/source/syntax/syntax.lisp

Dependency

format.lisp (file)

Parent

syntax (module)

Location

source/syntax/syntax.lisp

Exported Definitions

unbound-binding-variable-error (condition)

Internal Definitions

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

4.1.25 hu.dwim.rdbms/source/syntax/type.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/type.lisp

Internal Definitions

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

4.1.26 hu.dwim.rdbms/source/syntax/update.lisp

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/update.lisp

Internal Definitions

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

4.1.27 hu.dwim.rdbms/source/variables.lisp

Dependency

package.lisp (file)

Parent

source (module)

Location

source/variables.lisp

Exported Definitions

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

5 Packages

Packages are listed by definition order.


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

5.1 hu.dwim.rdbms

Source

package.lisp (file)

Use List
Exported Definitions
Internal Definitions

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

6 Definitions

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


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

6.1 Exported definitions


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

6.1.1 Constants

Constant: +database-command-line-options+
Package

hu.dwim.rdbms

Source

database.lisp (file)


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

6.1.2 Special variables

Special Variable: *database*

The current database, unbound by default. Can be rebound to access multiple databases within nested dynamic scope.

Package

hu.dwim.rdbms

Source

variables.lisp (file)

Special Variable: *implicit-transaction*

Specificies what to do when there is no transaction in progress during executing an SQL command. The value #f means an error will be signalled. The value :new unconditionally wraps each execution with a new transaction, while :ensure uses the current transaction if there’s one.

Package

hu.dwim.rdbms

Source

variables.lisp (file)

Special Variable: *implicit-transaction-default-terminal-action*

Specifies the default terminal action for implicit transactions.

Package

hu.dwim.rdbms

Source

variables.lisp (file)

Special Variable: *signal-non-destructive-alter-table-commands*
Package

hu.dwim.rdbms

Source

variables.lisp (file)

Special Variable: *transaction*

The current transaction, unbound by default. Can be rebound to access multiple transactions within nested dynamic scope.

Package

hu.dwim.rdbms

Source

variables.lisp (file)


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

6.1.3 Macros

Macro: assert-single-select-statement &body FORMS
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Macro: enable-sql-syntax &optional OPEN-CHAR CLOSE-CHAR UNQUOTE-CHAR

Enable [select ,foo ,bar] reader for the rest of the file (being loaded or compiled). Be careful when using in different situations, because it modifies *readtable*.

Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)

Macro: register-transaction-hook WHEN ACTION &body FORMS
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Macro: sql BODY

Parse BODY as an sexp-sql sexp.

Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Macro: sql-add-foreign-key-constraint-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-create-index &body ARGS
Package

hu.dwim.rdbms

Source

index.lisp (file)

Macro: sql-create-table &body ARGS
Package

hu.dwim.rdbms

Source

create-table.lisp (file)

Macro: sql-create-view &body ARGS
Package

hu.dwim.rdbms

Source

create-table.lisp (file)

Macro: sql-drop-constraint-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-foreign-key-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: with-confirmed-destructive-schema-changes &body WITH-BODY1
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Macro: with-database DATABASE &body FORMS

Evaluates FORMS within the dynamic scope of DATABASE.

Package

hu.dwim.rdbms

Source

database.lisp (file)

Macro: with-readonly-transaction &body FORMS

Evaluates FORMS within the dynamic scope of a new TRANSACTION that will unconditionally ROLLBACK.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Macro: with-transaction &body FORMS

Evaluates FORMS within the dynamic scope of a new TRANSACTION.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Macro: with-transaction* (&rest ARGS &key DEFAULT-TERMINAL-ACTION DATABASE TAKE-OVER &allow-other-keys) &body WITH-BODY1

Evaluates FORMS within the dynamic scope of a new TRANSACTION.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)


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

6.1.4 Functions

Function: abandon-and-recreate-transaction ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: add-column NAME COLUMN
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: add-foreign-key-constraint NAME ADD-CONSTRAINT
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: add-primary-key-constraint NAME COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: alter-column-type NAME COLUMN
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: alter-table NAME &rest ACTIONS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: begin &rest ARGS

Starts a new transaction. This transaction must be closed by an explicit call to either ROLLBACK or COMMIT. See with-transaction for convenience and safety. This is for debug purposes.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: break-on-next-command ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: clear-ddl-query-cache DATABASE
Package

hu.dwim.rdbms

Source

database.lisp (file)

Function: collect-rows CURSOR &key ROW-COUNT START-POSITION RESULT-TYPE
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Function: commit ()

Commits the current transaction. The transaction must be started by an explicit call to BEGIN. This is for debug purposes.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: commit-and-recreate-transaction ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: continue-with-schema-change &optional CONDITION
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: create-index NAME TABLE-NAME COLUMNS &key UNIQUE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: create-sequence NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: create-table NAME COLUMNS &key TEMPORARY
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: create-temporary-table NAME &rest COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: create-view NAME COLUMNS AS &key REPLACE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: current-delete-counter ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: current-insert-counter ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: current-row CURSOR &key RESULT-TYPE
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Function: current-select-counter ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: current-update-counter ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: deadlock-detected-error MESSAGE-OR-NESTED-CONDITION
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Function: delete-records TABLE &optional WHERE
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: disable-ddl-query-cache DATABASE
Package

hu.dwim.rdbms

Source

database.lisp (file)

Function: disable-sql-log ()
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Function: drop-column NAME COLUMN-NAME &optional CASCADE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: drop-foreign-key DESCRIPTOR
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Function: drop-index NAME &key IGNORE-MISSING
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: drop-sequence NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: drop-table NAME &key CASCADE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: drop-table-foreign-keys TABLE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: drop-view NAME &key IGNORE-MISSING
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: enable-ddl-query-cache DATABASE
Package

hu.dwim.rdbms

Source

database.lisp (file)

Function: enable-sql-log ()
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Function: execute COMMAND &rest ARGS &key VISITOR BINDINGS RESULT-TYPE WITH-TRANSACTION IMPLICIT-TRANSACTION-TERMINAL-ACTION &allow-other-keys

Executes an SQL command. If VISITOR is not present the result is returned in a sequence. The type of the sequence is determined by RESULT-TYPE which is either LIST or VECTOR. When VISITOR is present it will be called for each row in the result.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: execute-ddl COMMAND &rest ARGS &key IMPLICIT-TRANSACTION-TERMINAL-ACTION &allow-other-keys

A DDL statement is executed in a separate transaction if there is no active transaction.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: for-each-row FUNCTION CURSOR &key ROW-COUNT START-POSITION RESULT-TYPE
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Function: format-sql SYNTAX-NODE &key STREAM DATABASE

Formats the given SQL syntax node into the stream.

Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: format-sql-to-string SYNTAX-NODE &rest ARGS &key &allow-other-keys

Formats the given SQL syntax node into a string.

Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: import-sql-constructor-names &optional PACKAGE
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: import-sql-syntax-node-names &optional PACKAGE
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: in-transaction-p ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: insert-record TABLE COLUMNS VALUES
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: list-dependent-views TABLE COLUMN
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-sequences ()
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-table-columns NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-table-foreign-keys NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-table-indices NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-table-primary-constraints NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-tables ()
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-view-definitions ()
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: list-views ()
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: mark-transaction-for-commit-only ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: mark-transaction-for-rollback-only ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: rdbms-name-for NAME &optional THING
Package

hu.dwim.rdbms

Source

database.lisp (file)

Function: release-savepoint NAME
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: report-transaction-state ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: rollback ()

Rolls back the current transaction. The transaction must be started by an explicit call to BEGIN. This is for debug purposes.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: rollback-to-savepoint NAME
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: savepoint NAME
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: select-count-* TABLES &optional WHERE
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: select-records COLUMNS TABLES &key WHERE GROUP-BY HAVING ORDER-BY OFFSET LIMIT
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: sequence-current NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: sequence-exists-p NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: sequence-next NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: set-sequence-value NAME VALUE &optional CURRENTP
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: simple-rdbms-error MESSAGE &rest FORMAT-ARGUMENTS
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Function: sql-cond CLAUSES
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-if COND THEN ELSE
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: table-exists-p NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: transaction-in-progress-p &optional TRANSACTION
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: transaction-timestamp ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: transaction-valid-p &optional TRANSACTION

Returns true if we have a running transaction and its terminal action will be a commit.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: unable-to-obtain-lock-error MESSAGE-OR-NESTED-CONDITION
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Function: update-index NAME TABLE-NAME COLUMNS &key UNIQUE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: update-records TABLE COLUMNS VALUES &optional WHERE
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: update-table NAME COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: update-view NAME COLUMN AS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: view-definition NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: view-exists-p NAME
Package

hu.dwim.rdbms

Source

ddl.lisp (file)


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

6.1.5 Generic functions

Generic Function: begin-transaction DATABASE TRANSACTION

Extension point for with-transaction and begin.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: begin-transaction DATABASE TRANSACTION
Generic Function: call-in-transaction DATABASE TRANSACTION FUNCTION

Extension point for with-transaction macro.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: call-in-transaction DATABASE TRANSACTION FUNCTION
Generic Function: cleanup-transaction TRANSACTION

Extension point with-transaction and commit/rollback.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: cleanup-transaction TRANSACTION
Generic Function: column-count CURSOR
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: column-count (CURSOR sequence-cursor)
Generic Function: column-name CURSOR INDEX

Returns the column name as a string.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: column-name (CURSOR sequence-cursor) INDEX
Generic Function: column-type CURSOR INDEX

Returns the corresponding SQL type object slots filled in.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: column-type (CURSOR sequence-cursor) INDEX
Generic Function: column-value CURSOR INDEX

Returns values of type (or (member :null nil t) number string local-time (vector (unsigned-byte 8))).

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: column-value (CURSOR sequence-cursor) INDEX
Generic Function: commit-transaction DATABASE TRANSACTION

Extension point for with-transaction and commit.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: commit-transaction DATABASE (TRANSACTION transaction-with-hooks-mixin) around
Method: commit-transaction DATABASE TRANSACTION around
Method: commit-transaction DATABASE TRANSACTION
Generic Function: connection-specification-of OBJECT
Generic Function: (setf connection-specification-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: connection-specification-of (DATABASE database)
Method: (setf connection-specification-of) NEW-VALUE (DATABASE database)

Backend specific connection data, usually a plist of args passed to the connect function.

Source

database.lisp (file)

Generic Function: constraint-to-action CONSTRAINT TABLE-NAME
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Methods
Method: constraint-to-action (CONSTRAINT sql-foreign-key-constraint) TABLE-NAME
Method: constraint-to-action (CONSTRAINT sql-primary-key-constraint) TABLE-NAME
Generic Function: constraints-of OBJECT
Generic Function: (setf constraints-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: constraints-of (SQL-COLUMN sql-column)

automatically generated reader method

Source

create-table.lisp (file)

Method: (setf constraints-of) NEW-VALUE (SQL-COLUMN sql-column)

automatically generated writer method

Source

create-table.lisp (file)

Generic Function: cursor-position CURSOR

Returns values of type (or null (integer 0 (1- row-count))) where nil means the position is invalid.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Writer

(setf cursor-position) (generic function)

Methods
Method: cursor-position (CURSOR sequence-cursor)
Generic Function: (setf cursor-position) WHERE CURSOR

Modifies the cursor position, an implementation may not support all kinds of positioning. The integer is a signed value and means relative positioning.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Reader

cursor-position (generic function)

Methods
Method: (setf cursor-position) WHERE (CURSOR sequence-cursor)
Method: (setf cursor-position) WHERE (CURSOR sequential-access-cursor) before
Method: (setf cursor-position) WHERE (CURSOR random-access-cursor) before
Generic Function: database-list-table-foreign-keys NAME DATABASE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-view-definitions DATABASE

Returns the list of view names and definitions present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-view-definition VIEW-NAME DATABASE

Returns the view’s definition present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: delete-counter-of OBJECT
Generic Function: (setf delete-counter-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: delete-counter-of (COMMAND-COUNTER command-counter)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf delete-counter-of) NEW-VALUE (COMMAND-COUNTER command-counter)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: insert-counter-of OBJECT
Generic Function: (setf insert-counter-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: insert-counter-of (COMMAND-COUNTER command-counter)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf insert-counter-of) NEW-VALUE (COMMAND-COUNTER command-counter)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: make-cursor TRANSACTION &key RESULT-TYPE INITIAL-POSITION &allow-other-keys

Creates and associates a new cursor with the given ongoing transaction.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: make-cursor (TRANSACTION transaction) &key RESULT-TYPE INITIAL-POSITION &allow-other-keys around
Generic Function: make-transaction DATABASE &key DEFAULT-RESULT-TYPE &allow-other-keys

Extension point for with-transaction.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: make-transaction DATABASE &key &allow-other-keys before
Method: make-transaction DATABASE &rest ARGS &key DEFAULT-RESULT-TYPE &allow-other-keys
Generic Function: notify-transaction-event TRANSACTION EVENT
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: notify-transaction-event TRANSACTION EVENT
Generic Function: register-hook-in-transaction TRANSACTION WHEN ACTION FUNCTION
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: register-hook-in-transaction (TRANSACTION transaction-with-hooks-mixin) WHEN ACTION (FUNCTION function)
Generic Function: rollback-transaction DATABASE TRANSACTION

Extension point for with-transaction and rollback.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Methods
Method: rollback-transaction DATABASE (TRANSACTION transaction-with-hooks-mixin) around
Method: rollback-transaction DATABASE TRANSACTION around
Method: rollback-transaction DATABASE TRANSACTION
Generic Function: row-count CURSOR
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: row-count (CURSOR sequence-cursor)
Method: row-count (CURSOR cursor)
Generic Function: select-counter-of OBJECT
Generic Function: (setf select-counter-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: select-counter-of (COMMAND-COUNTER command-counter)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf select-counter-of) NEW-VALUE (COMMAND-COUNTER command-counter)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: transaction-mixin-class DATABASE

Collects the transaction mixin classes which will be inherited by the transaction class instantiated by with-transaction when using this database.

Package

hu.dwim.rdbms

Source

database.lisp (file)

Method Combination

list (short method combination)

Options: :most-specific-first

Methods
Method: transaction-mixin-class DATABASE list
Source

transaction.lisp (file)

Generic Function: update-counter-of OBJECT
Generic Function: (setf update-counter-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: update-counter-of (COMMAND-COUNTER command-counter)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf update-counter-of) NEW-VALUE (COMMAND-COUNTER command-counter)

automatically generated writer method

Source

transaction.lisp (file)


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

6.1.6 Conditions

Condition: deadlock-detected-error ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses
Condition: rdbms-error ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

condition (condition)

Direct subclasses
Condition: simple-rdbms-error ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses
Direct subclasses
Condition: unable-to-obtain-lock-error ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses
Condition: unbound-binding-variable-error ()
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Direct superclasses

rdbms-error (condition)

Direct methods
Direct slots
Slot: variable-name
Initargs

:variable-name

Readers

variable-name-of (generic function)

Writers

(setf variable-name-of) (generic function)

Condition: unconfirmed-destructive-schema-change ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Direct subclasses
Condition: unconfirmed-destructive-schema-change/alter-column-type ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-destructive-schema-change (condition)

Direct methods
Direct slots
Slot: old-type
Initargs

:old-type

Readers

old-type-of (generic function)

Writers

(setf old-type-of) (generic function)

Slot: new-type
Initargs

:new-type

Readers

new-type-of (generic function)

Writers

(setf new-type-of) (generic function)

Slot: new-rdbms-type
Initargs

:new-rdbms-type

Readers

new-rdbms-type-of (generic function)

Writers

(setf new-rdbms-type-of) (generic function)

Condition: unconfirmed-destructive-schema-change/drop-column ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-destructive-schema-change (condition)

Condition: unconfirmed-schema-change ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

serious-condition (condition)

Direct subclasses
Direct methods
Direct slots
Slot: table-name
Initargs

:table-name

Readers

table-name-of (generic function)

Writers

(setf table-name-of) (generic function)

Slot: column-name
Initargs

:column-name

Readers

column-name-of (generic function)

Writers

(setf column-name-of) (generic function)

Condition: unconfirmed-schema-change/add-column ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods
Direct slots
Slot: column-type
Initargs

:column-type

Readers

column-type-of (generic function)

Writers

(setf column-type-of) (generic function)

Condition: unconfirmed-schema-change/add-foreign-key ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods
Direct slots
Slot: constraint-name
Initargs

:constraint-name

Readers

constraint-name-of (generic function)

Writers

(setf constraint-name-of) (generic function)

Condition: unconfirmed-schema-change/create-table ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Condition: unconfirmed-schema-change/drop-foreign-key ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods
Direct slots
Slot: constraint-name
Initargs

:constraint-name

Readers

constraint-name-of (generic function)

Writers

(setf constraint-name-of) (generic function)

Condition: unconfirmed-schema-change/replace-foreign-key ()
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods
Direct slots
Slot: constraint-name
Initargs

:constraint-name

Readers

constraint-name-of (generic function)

Writers

(setf constraint-name-of) (generic function)


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

6.1.7 Classes

Class: database ()
Package

hu.dwim.rdbms

Source

database.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: connection-specification

Backend specific connection data, usually a plist of args passed to the connect function.

Initargs

:connection-specification

Readers

connection-specification-of (generic function)

Writers

(setf connection-specification-of) (generic function)

Slot: default-result-type
Type

(member vector list hu.dwim.rdbms::cursor)

Initargs

:default-result-type

Initform

(quote vector)

Readers

default-result-type-of (generic function)

Writers

(setf default-result-type-of) (generic function)

Slot: transaction-class

Transactions will be instances of this class. This class is created according to the generic method transaction-mixin-class.

Type

standard-class

Initargs

:transaction-class

Readers

transaction-class-of (generic function)

Writers

(setf transaction-class-of) (generic function)

Slot: encoding
Type

(member :utf-8 :us-ascii)

Initargs

:encoding

Initform

:utf-8

Readers

encoding-of (generic function)

Writers

(setf encoding-of) (generic function)

Slot: ddl-query-cache

A cache to speed up querying the metadata of the database (its schema).

Type

(or hash-table null)

Initargs

:ddl-query-cache

Readers

ddl-query-cache-of (generic function)

Writers

(setf ddl-query-cache-of) (generic function)

Class: foreign-key-descriptor ()
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: name
Initargs

:name

Readers

name-of (generic function)

Writers

(setf name-of) (generic function)

Slot: source-table
Initargs

:source-table

Readers

source-table-of (generic function)

Writers

(setf source-table-of) (generic function)

Slot: source-column
Initargs

:source-column

Readers

source-column-of (generic function)

Writers

(setf source-column-of) (generic function)

Slot: target-table
Initargs

:target-table

Readers

target-table-of (generic function)

Writers

(setf target-table-of) (generic function)

Slot: target-column
Initargs

:target-column

Readers

target-column-of (generic function)

Writers

(setf target-column-of) (generic function)

Slot: update-rule
Initargs

:update-rule

Readers

update-rule-of (generic function)

Writers

(setf update-rule-of) (generic function)

Slot: delete-rule
Initargs

:delete-rule

Readers

delete-rule-of (generic function)

Writers

(setf delete-rule-of) (generic function)

Class: sql-add-foreign-key-constraint-action ()
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Direct superclasses

sql-add-constraint-action (class)

Direct methods
Direct slots
Slot: source-columns
Type

list

Initargs

:source-columns

Readers

source-columns-of (generic function)

Writers

(setf source-columns-of) (generic function)

Slot: target-columns
Type

list

Initargs

:target-columns

Readers

target-columns-of (generic function)

Writers

(setf target-columns-of) (generic function)

Slot: target-table
Type

string

Initargs

:target-table

Readers

target-table-of (generic function)

Writers

(setf target-table-of) (generic function)

Slot: delete-rule
Type

hu.dwim.rdbms::sql-foreign-key-action

Initargs

:delete-rule

Readers

delete-rule-of (generic function)

Writers

(setf delete-rule-of) (generic function)

Slot: update-rule
Type

hu.dwim.rdbms::sql-foreign-key-action

Initargs

:update-rule

Readers

update-rule-of (generic function)

Writers

(setf update-rule-of) (generic function)

Class: sql-create-index ()

An SQL CREATE INDEX statement.

Package

hu.dwim.rdbms

Source

index.lisp (file)

Direct superclasses
Direct methods
Class: sql-create-table ()

An SQL CREATE TABLE statement.

Package

hu.dwim.rdbms

Source

create-table.lisp (file)

Direct superclasses

sql-ddl-statement (class)

Direct subclasses

sql-create-view (class)

Direct methods
Direct slots
Slot: name
Type

hu.dwim.rdbms::sql-identifier*

Initargs

:name

Readers

name-of (generic function)

Writers

(setf name-of) (generic function)

Slot: temporary
Type

(or boolean (member (:drop :preserve-rows :delete-rows)))

Initargs

:temporary

Readers

temporary-of (generic function)

Writers

(setf temporary-of) (generic function)

Slot: columns
Type

list

Initargs

:columns

Readers

columns-of (generic function)

Writers

(setf columns-of) (generic function)

Slot: as
Type

(or hu.dwim.rdbms::sql-select hu.dwim.rdbms::sql-set-operation-expression)

Initargs

:as

Readers

as-of (generic function)

Writers

(setf as-of) (generic function)

Class: sql-create-view ()

An SQL CREATE TABLE statement.

Package

hu.dwim.rdbms

Source

create-table.lisp (file)

Direct superclasses

sql-create-table (class)

Direct methods
Direct slots
Slot: replace
Type

boolean

Initargs

:replace

Readers

replace-p (generic function)

Writers

(setf replace-p) (generic function)

Class: sql-drop-constraint-action ()
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Direct superclasses

sql-syntax-node (class)

Direct methods
Direct slots
Slot: name
Type

string

Initargs

:name

Readers

name-of (generic function)

Writers

(setf name-of) (generic function)

Class: sql-foreign-key-constraint ()
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Direct superclasses

sql-constraint-with-tablespace (class)

Direct methods
Direct slots
Slot: target-table
Type

string

Initargs

:target-table

Readers

target-table-of (generic function)

Writers

(setf target-table-of) (generic function)

Slot: target-column
Type

string

Initargs

:target-column

Readers

target-column-of (generic function)

Writers

(setf target-column-of) (generic function)

Slot: delete-rule
Type

hu.dwim.rdbms::sql-foreign-key-action

Initargs

:delete-rule

Readers

delete-rule-of (generic function)

Writers

(setf delete-rule-of) (generic function)

Slot: update-rule
Type

hu.dwim.rdbms::sql-foreign-key-action

Initargs

:update-rule

Readers

update-rule-of (generic function)

Writers

(setf update-rule-of) (generic function)

Class: transaction ()

An object representing a transaction context. The actual backend connection/transaction is usually lazily created.

Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: database
Type

hu.dwim.rdbms:database

Initargs

:database

Readers

database-of (generic function)

Writers

(setf database-of) (generic function)

Slot: default-result-type
Type

(member vector list hu.dwim.rdbms::cursor)

Initargs

:default-result-type

Readers

default-result-type-of (generic function)

Writers

(setf default-result-type-of) (generic function)

Slot: timestamp
Type

integer

Initargs

:timestamp

Readers

timestamp-of (generic function)

Writers

(setf timestamp-of) (generic function)

Slot: command-counter
Type

hu.dwim.rdbms::command-counter

Initargs

:command-counter

Initform

(make-instance (quote hu.dwim.rdbms::command-counter))

Readers

command-counter-of (generic function)

Writers

(setf command-counter-of) (generic function)

Slot: begin-was-executed
Type

boolean

Initargs

:begin-was-executed

Readers

begin-was-executed-p (generic function)

Writers

(setf begin-was-executed-p) (generic function)

Slot: state
Type

(member :uninitialized :committed :rolled-back :in-progress)

Initargs

:state

Initform

:uninitialized

Readers

state-of (generic function)

Writers

(setf state-of) (generic function)

Slot: terminal-action

Used by with-transaction to decide what to do when the with-transaction body finishes without any errors.

Type

(member :commit :rollback :marked-for-commit-only :marked-for-rollback-only)

Initargs

:terminal-action

Initform

:commit

Readers

terminal-action-of (generic function)

Writers

(setf terminal-action-of) (generic function)

Slot: break-on-next-command
Type

boolean

Initargs

:break-on-next-command

Readers

break-on-next-command-p (generic function)

Writers

(setf break-on-next-command-p) (generic function)

Class: transaction-with-hooks-mixin ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: hooks
Type

list

Initargs

:hooks

Readers

hooks-of (generic function)

Writers

(setf hooks-of) (generic function)


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

6.2 Internal definitions


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

6.2.1 Constants

Constant: +default-sql-syntax-close-character+
Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)

Constant: +default-sql-syntax-open-character+
Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)

Constant: +default-sql-syntax-unquote-character+
Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)


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

6.2.2 Special variables

Special Variable: *binding-types*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *binding-values*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *binding-variables*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *command-elements*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *expand-cached*
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Special Variable: *original-unquote-reader*
Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)

Special Variable: *sql-constructor-names*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *sql-function-names*

A list of symbols that name an SQL function

Package

hu.dwim.rdbms

Source

expression.lisp (file)

Special Variable: *sql-operator-names*

A list of symbols that name an SQL operator

Package

hu.dwim.rdbms

Source

expression.lisp (file)

Special Variable: *sql-stream*
Package

hu.dwim.rdbms

Source

format.lisp (file)

Special Variable: *sql-syntax-node-names*
Package

hu.dwim.rdbms

Source

format.lisp (file)


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

6.2.3 Macros

Macro: format-char CHARACTER
Package

hu.dwim.rdbms

Source

format.lisp (file)

Macro: format-number NUMBER
Package

hu.dwim.rdbms

Source

format.lisp (file)

Macro: format-string STRING
Package

hu.dwim.rdbms

Source

format.lisp (file)

Macro: named-sql-syntax-node &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: rdbms.debug MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: rdbms.dribble MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: rdbms.error MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: rdbms.fatal MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: rdbms.info MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: rdbms.warn MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql-add-column-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-add-constraint-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-add-primary-key-constraint-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-all-columns &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-alter-column-type-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-alter-table &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-binary-large-object-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-binary-operator &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-binding-variable &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-bit-sized-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-boolean-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-case &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-character-large-object-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-character-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-character-varying-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-column &body ARGS
Package

hu.dwim.rdbms

Source

create-table.lisp (file)

Macro: sql-column-alias &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-constraint-with-tablespace &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-create-sequence &body ARGS
Package

hu.dwim.rdbms

Source

sequence.lisp (file)

Macro: sql-date-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-delete &body ARGS
Package

hu.dwim.rdbms

Source

delete.lisp (file)

Macro: sql-derived-table &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-distinct-spec &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-drop-column-action &body ARGS
Package

hu.dwim.rdbms

Source

alter-table.lisp (file)

Macro: sql-drop-index &body ARGS
Package

hu.dwim.rdbms

Source

index.lisp (file)

Macro: sql-drop-sequence &body ARGS
Package

hu.dwim.rdbms

Source

sequence.lisp (file)

Macro: sql-drop-table &body ARGS
Package

hu.dwim.rdbms

Source

drop-table.lisp (file)

Macro: sql-drop-view &body ARGS
Package

hu.dwim.rdbms

Source

drop-table.lisp (file)

Macro: sql-expression &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-false-expression &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-float-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-foreign-key-action &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-fragment &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-function-call &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-identifier &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-index &body ARGS
Package

hu.dwim.rdbms

Source

index.lisp (file)

Macro: sql-insert &body ARGS
Package

hu.dwim.rdbms

Source

insert.lisp (file)

Macro: sql-integer-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-interval-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-joined-table &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-like &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-literal &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-lock-table &body ARGS
Package

hu.dwim.rdbms

Source

lock.lisp (file)

Macro: sql-n-ary-operator &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-not-null-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-null-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-numeric-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-operator &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-primary-key-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-query-expression &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-regexp-like &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-select &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-sequence-currval-column &body ARGS
Package

hu.dwim.rdbms

Source

sequence.lisp (file)

Macro: sql-sequence-nextval-column &body ARGS
Package

hu.dwim.rdbms

Source

sequence.lisp (file)

Macro: sql-sequence-setval &body ARGS
Package

hu.dwim.rdbms

Source

sequence.lisp (file)

Macro: sql-set-operation-expression &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-simple-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-sized-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-sort-spec &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-string-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-subquery &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-syntax-node &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-table-alias &body ARGS
Package

hu.dwim.rdbms

Source

select.lisp (file)

Macro: sql-time-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-timestamp-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-timestamp-with-timezone-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-type &body ARGS
Package

hu.dwim.rdbms

Source

type.lisp (file)

Macro: sql-unary-operator &body ARGS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Macro: sql-unique-constraint &body ARGS
Package

hu.dwim.rdbms

Source

constraint.lisp (file)

Macro: sql-unquote &body ARGS
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Macro: sql-update &body ARGS
Package

hu.dwim.rdbms

Source

update.lisp (file)

Macro: sql.debug MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql.dribble MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql.error MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql.fatal MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql.info MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: sql.warn MESSAGE-CONTROL &rest MESSAGE-ARGS
Package

hu.dwim.rdbms

Source

logger.lisp (file)

Macro: with-cache (&rest KEYS) &body COMPILATION-BODY
Package

hu.dwim.rdbms

Source

format.lisp (file)


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

6.2.4 Functions

Function: %generate-log-description-for-command COMMAND BINDING-TYPES BINDING-VALUES
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: %signal-translated-simple-rdbms-error TYPE MESSAGE-OR-NESTED-CONDITION
Package

hu.dwim.rdbms

Source

conditions.lisp (file)

Function: assert-transaction-in-progress ()
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: calculate-rdbms-name-with-utf-8-length-limit NAME LIMIT &key PREFIX

Cuts off the end of names that are too long and appends the hash of the original name.

Package

hu.dwim.rdbms

Source

database.lisp (file)

Function: call-transaction-hooks TRANSACTION WHEN ACTION
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: call-with-confirmed-destructive-schema-changes FN0
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: call-with-transaction* FN0 &rest ARGS &key DEFAULT-TERMINAL-ACTION DATABASE TAKE-OVER &allow-other-keys
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: collect-column-foreign-keys COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: compile-sexp-sql FORM
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-binding-variable BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-column BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-column-alias BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-columns BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-create BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-delete BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-drop BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-expression BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-function-call BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-function-call-argument BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-insert BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-literal BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-select BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-table-alias BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-type BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-unquote BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-update BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: compile-sexp-sql-where BODY
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: expand-sql-ast-into-lambda-form SYNTAX-NODE &key DATABASE TOPLEVEL
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: expand-sql-ast-into-lambda-form-cached SYNTAX-NODE &key ENV DATABASE TOPLEVEL
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: expand-sql-unquote UNQOUTE-NODE DATABASE FORMATTER
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Function: fkey-actions-same-p DESCRIPTOR CONSTRAINT
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: format-comma-separated-identifiers NODES DATABASE
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: format-comma-separated-list NODES DATABASE &optional FORMAT-FN
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: format-separated-list NODES SEPARATOR DATABASE &optional FORMAT-FN
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: format-size SIZE
Package

hu.dwim.rdbms

Source

type.lisp (file)

Function: format-sql-table-reference REFERENCE DATABASE
Package

hu.dwim.rdbms

Source

select.lisp (file)

Function: format-sql-where WHERE DATABASE
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: make-sql-reader END-CHAR UNQUOTE-CHAR
Package

hu.dwim.rdbms

Source

reader-macro.lisp (file)

Function: print-number-to-sql-string NUMBER
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: process-sexp-sql-syntax-list BODY VISITOR &key FUNCTION-CALL-ALLOWED-P
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: process-sexp-sql-syntax-node NODE &optional VISITOR
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: push-form-into-command-elements FORM
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Function: reduce-subsequences SEQUENCE PREDICATE REDUCER
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: same-backend-p X Y
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: sexp-sql-unquote-p THING
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: sql-# LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-% LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-& LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-* &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-+ &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-- &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-/ LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-< LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-<< LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-<= LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-<> LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-= LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-> LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql->= LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql->> LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-@ EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-^ LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-and &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-avg &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-compile-error WHOLE-FORM &optional ERROR-AT-FORM
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: sql-constructor-name NAME
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: sql-count &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-count-* ()
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-distinct &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-except &rest SUBQUERIES
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-exists EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-function-call-form-p THING
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: sql-function-name-p THING
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: sql-in LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-intersect &rest SUBQUERIES
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-is-not-null EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-is-null EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-literal-values-for COLUMNS VALUES
Package

hu.dwim.rdbms

Source

dml.lisp (file)

Function: sql-max &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-min &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-not EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-operator-name NAME
Package

hu.dwim.rdbms

Source

format.lisp (file)

Function: sql-or &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-sum &rest ARGUMENTS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-symbol-equal A B
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: sql-union &rest SUBQUERIES
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-| LEFT RIGHT
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-|/ EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-|| &rest EXPRESSIONS
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: sql-~ EXPRESSION
Package

hu.dwim.rdbms

Source

expression.lisp (file)

Function: stringify NAME
Package

hu.dwim.rdbms

Source

sexp.lisp (file)

Function: unquote-aware-format-sql-binding-variable VARIABLE
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Function: unquote-aware-format-sql-literal LITERAL
Package

hu.dwim.rdbms

Source

syntax.lisp (file)

Function: update-binding-values BINDING-VARIABLES BINDING-TYPES BINDING-VALUES NAME-VALUE-BINDINGS
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Function: update-existing-table TABLE-NAME COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: update-existing-table-foreign-keys TABLE-NAME COLUMNS
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Function: vector-extend EXTENSION VECTOR
Package

hu.dwim.rdbms

Source

format.lisp (file)


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

6.2.5 Generic functions

Generic Function: absolute-cursor-position CURSOR
Generic Function: (setf absolute-cursor-position) WHERE CURSOR
Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Methods
Method: (setf absolute-cursor-position) WHERE (CURSOR cursor) before
Method: (setf absolute-cursor-position) WHERE (CURSOR cursor)
Generic Function: action-of OBJECT
Generic Function: (setf action-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: action-of (SQL-FOREIGN-KEY-ACTION sql-foreign-key-action)

automatically generated reader method

Source

constraint.lisp (file)

Method: (setf action-of) NEW-VALUE (SQL-FOREIGN-KEY-ACTION sql-foreign-key-action)

automatically generated writer method

Source

constraint.lisp (file)

Method: action-of (TRANSACTION-HOOK transaction-hook)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf action-of) NEW-VALUE (TRANSACTION-HOOK transaction-hook)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: actions-of OBJECT
Generic Function: (setf actions-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: actions-of (SQL-ALTER-TABLE sql-alter-table)

automatically generated reader method

Source

alter-table.lisp (file)

Method: (setf actions-of) NEW-VALUE (SQL-ALTER-TABLE sql-alter-table)

automatically generated writer method

Source

alter-table.lisp (file)

Generic Function: alias-of OBJECT
Generic Function: (setf alias-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: alias-of (SQL-COLUMN-ALIAS sql-column-alias)

automatically generated reader method

Source

select.lisp (file)

Method: (setf alias-of) NEW-VALUE (SQL-COLUMN-ALIAS sql-column-alias)

automatically generated writer method

Source

select.lisp (file)

Method: alias-of (SQL-DERIVED-TABLE sql-derived-table)

automatically generated reader method

Source

select.lisp (file)

Method: (setf alias-of) NEW-VALUE (SQL-DERIVED-TABLE sql-derived-table)

automatically generated writer method

Source

select.lisp (file)

Method: alias-of (SQL-TABLE-ALIAS sql-table-alias)

automatically generated reader method

Source

select.lisp (file)

Method: (setf alias-of) NEW-VALUE (SQL-TABLE-ALIAS sql-table-alias)

automatically generated writer method

Source

select.lisp (file)

Generic Function: all-p OBJECT
Generic Function: (setf all-p) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: all-p (SQL-SET-OPERATION-EXPRESSION sql-set-operation-expression)

automatically generated reader method

Source

expression.lisp (file)

Method: (setf all-p) NEW-VALUE (SQL-SET-OPERATION-EXPRESSION sql-set-operation-expression)

automatically generated writer method

Source

expression.lisp (file)

Generic Function: arguments-of OBJECT
Generic Function: (setf arguments-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: arguments-of (SQL-FUNCTION-CALL sql-function-call)

automatically generated reader method

Source

expression.lisp (file)

Method: (setf arguments-of) NEW-VALUE (SQL-FUNCTION-CALL sql-function-call)

automatically generated writer method

Source

expression.lisp (file)

Generic Function: as-of OBJECT
Generic Function: (setf as-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: as-of (SQL-CREATE-TABLE sql-create-table)

automatically generated reader method

Source

create-table.lisp (file)

Method: (setf as-of) NEW-VALUE (SQL-CREATE-TABLE sql-create-table)

automatically generated writer method

Source

create-table.lisp (file)

Generic Function: backend-release-savepoint NAME DATABASE
Package

hu.dwim.rdbms

Source

transaction.lisp (file)

Generic Function: begin-was-executed-p OBJECT
Generic Function: (setf begin-was-executed-p) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: begin-was-executed-p (TRANSACTION transaction)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf begin-was-executed-p) NEW-VALUE (TRANSACTION transaction)

automatically generated writer method

Source

transaction.lisp (file)

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

hu.dwim.rdbms

Methods
Method: bit-size-of (SQL-BIT-SIZED-TYPE sql-bit-sized-type)

automatically generated reader method

Source

type.lisp (file)

Method: (setf bit-size-of) NEW-VALUE (SQL-BIT-SIZED-TYPE sql-bit-sized-type)

automatically generated writer method

Source

type.lisp (file)

Generic Function: break-on-next-command-p OBJECT
Generic Function: (setf break-on-next-command-p) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: break-on-next-command-p (TRANSACTION transaction)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf break-on-next-command-p) NEW-VALUE (TRANSACTION transaction)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: calculate-rdbms-name DATABASE THING NAME

May be specialized to take name length and character set limitations into account.

Package

hu.dwim.rdbms

Source

database.lisp (file)

Methods
Method: calculate-rdbms-name (DATABASE database) THING NAME
Generic Function: cascade-p OBJECT
Generic Function: (setf cascade-p) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: cascade-p (SQL-DROP-TABLE sql-drop-table)

automatically generated reader method

Source

drop-table.lisp (file)

Method: (setf cascade-p) NEW-VALUE (SQL-DROP-TABLE sql-drop-table)

automatically generated writer method

Source

drop-table.lisp (file)

Method: cascade-p (SQL-DROP-COLUMN-ACTION sql-drop-column-action)

automatically generated reader method

Source

alter-table.lisp (file)

Method: (setf cascade-p) NEW-VALUE (SQL-DROP-COLUMN-ACTION sql-drop-column-action)

automatically generated writer method

Source

alter-table.lisp (file)

Generic Function: case-sensitive-p OBJECT
Generic Function: (setf case-sensitive-p) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: case-sensitive-p (SQL-REGEXP-LIKE sql-regexp-like)

automatically generated reader method

Source

expression.lisp (file)

Method: (setf case-sensitive-p) NEW-VALUE (SQL-REGEXP-LIKE sql-regexp-like)

automatically generated writer method

Source

expression.lisp (file)

Method: case-sensitive-p (SQL-LIKE sql-like)

automatically generated reader method

Source

expression.lisp (file)

Method: (setf case-sensitive-p) NEW-VALUE (SQL-LIKE sql-like)

automatically generated writer method

Source

expression.lisp (file)

Generic Function: clauses-of OBJECT
Generic Function: (setf clauses-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: clauses-of (SQL-CASE sql-case)

automatically generated reader method

Source

expression.lisp (file)

Method: (setf clauses-of) NEW-VALUE (SQL-CASE sql-case)

automatically generated writer method

Source

expression.lisp (file)

Generic Function: close-cursor CURSOR

Release any underlying resource.

Package

hu.dwim.rdbms

Source

cursor.lisp (file)

Generic Function: column-name-of CONDITION
Generic Function: (setf column-name-of) NEW-VALUE CONDITION
Package

hu.dwim.rdbms

Methods
Method: column-name-of (CONDITION unconfirmed-schema-change)
Method: (setf column-name-of) NEW-VALUE (CONDITION unconfirmed-schema-change)
Source

conditions.lisp (file)

Generic Function: column-of OBJECT
Generic Function: (setf column-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: column-of (SQL-COLUMN-ALIAS sql-column-alias)

automatically generated reader method

Source

select.lisp (file)

Method: (setf column-of) NEW-VALUE (SQL-COLUMN-ALIAS sql-column-alias)

automatically generated writer method

Source

select.lisp (file)

Generic Function: column-spec-of OBJECT
Generic Function: (setf column-spec-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: column-spec-of (SQL-DISTINCT-SPEC sql-distinct-spec)

automatically generated reader method

Source

select.lisp (file)

Method: (setf column-spec-of) NEW-VALUE (SQL-DISTINCT-SPEC sql-distinct-spec)

automatically generated writer method

Source

select.lisp (file)

Generic Function: column-type-of CONDITION
Generic Function: (setf column-type-of) NEW-VALUE CONDITION
Package

hu.dwim.rdbms

Methods
Method: column-type-of (CONDITION unconfirmed-schema-change/add-column)
Method: (setf column-type-of) NEW-VALUE (CONDITION unconfirmed-schema-change/add-column)
Source

conditions.lisp (file)

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

hu.dwim.rdbms

Methods
Method: columns-of (SQL-UPDATE sql-update)

automatically generated reader method

Source

update.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-UPDATE sql-update)

automatically generated writer method

Source

update.lisp (file)

Method: columns-of (SQL-SELECT sql-select)

automatically generated reader method

Source

select.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-SELECT sql-select)

automatically generated writer method

Source

select.lisp (file)

Method: columns-of (SQL-INSERT sql-insert)

automatically generated reader method

Source

insert.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-INSERT sql-insert)

automatically generated writer method

Source

insert.lisp (file)

Method: columns-of (SQL-INDEX sql-index)

automatically generated reader method

Source

index.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-INDEX sql-index)

automatically generated writer method

Source

index.lisp (file)

Method: columns-of (SQL-ADD-PRIMARY-KEY-CONSTRAINT-ACTION sql-add-primary-key-constraint-action)

automatically generated reader method

Source

alter-table.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-ADD-PRIMARY-KEY-CONSTRAINT-ACTION sql-add-primary-key-constraint-action)

automatically generated writer method

Source

alter-table.lisp (file)

Method: columns-of (SQL-CREATE-TABLE sql-create-table)

automatically generated reader method

Source

create-table.lisp (file)

Method: (setf columns-of) NEW-VALUE (SQL-CREATE-TABLE sql-create-table)

automatically generated writer method

Source

create-table.lisp (file)

Generic Function: command-counter-of OBJECT
Generic Function: (setf command-counter-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: command-counter-of (TRANSACTION transaction)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf command-counter-of) NEW-VALUE (TRANSACTION transaction)

automatically generated writer method

Source

transaction.lisp (file)

Generic Function: constraint-name-of CONDITION
Generic Function: (setf constraint-name-of) NEW-VALUE CONDITION
Package

hu.dwim.rdbms

Methods
Method: constraint-name-of (CONDITION unconfirmed-schema-change/replace-foreign-key)
Method: (setf constraint-name-of) NEW-VALUE (CONDITION unconfirmed-schema-change/replace-foreign-key)
Source

conditions.lisp (file)

Method: constraint-name-of (CONDITION unconfirmed-schema-change/drop-foreign-key)
Method: (setf constraint-name-of) NEW-VALUE (CONDITION unconfirmed-schema-change/drop-foreign-key)
Source

conditions.lisp (file)

Method: constraint-name-of (CONDITION unconfirmed-schema-change/add-foreign-key)
Method: (setf constraint-name-of) NEW-VALUE (CONDITION unconfirmed-schema-change/add-foreign-key)
Source

conditions.lisp (file)

Generic Function: current-row-index-of OBJECT
Generic Function: (setf current-row-index-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: current-row-index-of (SEQUENCE-CURSOR sequence-cursor)

automatically generated reader method

Source

cursor.lisp (file)

Method: (setf current-row-index-of) NEW-VALUE (SEQUENCE-CURSOR sequence-cursor)

automatically generated writer method

Source

cursor.lisp (file)

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

hu.dwim.rdbms

Methods
Method: currentp (SQL-SEQUENCE-SETVAL sql-sequence-setval)

automatically generated reader method

Source

sequence.lisp (file)

Method: (setf currentp) NEW-VALUE (SQL-SEQUENCE-SETVAL sql-sequence-setval)

automatically generated writer method

Source

sequence.lisp (file)

Generic Function: database-list-dependent-views TABLE COLUMN DATABASE

Returns the list of view names that depends on the specified column.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-sequences DATABASE

Returns the list of sequence names present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-table-columns NAME DATABASE

Returns the list of columns present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-table-indices NAME DATABASE

Returns the list of table indices present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-table-primary-constraints NAME DATABASE
Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-tables DATABASE

Returns the list of table names present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

Generic Function: database-list-views DATABASE

Returns the list of view names present in the database.

Package

hu.dwim.rdbms

Source

ddl.lisp (file)

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

hu.dwim.rdbms

Methods
Method: database-of (TRANSACTION transaction)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf database-of) NEW-VALUE (TRANSACTION transaction)

automatically generated writer method

Source

transaction.lisp (file)

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

hu.dwim.rdbms

Methods
Method: ddl-query-cache-of (DATABASE database)
Method: (setf ddl-query-cache-of) NEW-VALUE (DATABASE database)

A cache to speed up querying the metadata of the database (its schema).

Source

database.lisp (file)

Generic Function: default-result-type-of OBJECT
Generic Function: (setf default-result-type-of) NEW-VALUE OBJECT
Package

hu.dwim.rdbms

Methods
Method: default-result-type-of (CURSOR cursor)

automatically generated reader method

Source

cursor.lisp (file)

Method: (setf default-result-type-of) NEW-VALUE (CURSOR cursor)

automatically generated writer method

Source

cursor.lisp (file)

Method: default-result-type-of (TRANSACTION transaction)

automatically generated reader method

Source

transaction.lisp (file)

Method: (setf default-result-type-of) NEW-VALUE (TRANSACTION transaction)

automatically generated writer method

Source

transaction.lisp (file)

Method: default-result-type-of (DATABASE database)

automatically generated reader method

Source

database.lisp (file)

Method: (setf default-result-type-of) NEW-VALUE (DATABASE database)