The hu.dwim.rdbms Reference Manual

Parent

generic (module)

Location

source/generic/cursor.lisp

Exported Definitions

collect-rows (function)
column-count (generic function)
column-count (method)
column-name (generic function)
column-name (method)
column-type (generic function)
column-type (method)
column-value (generic function)
column-value (method)
current-row (function)
cursor-position (generic function)
cursor-position (method)
(setf cursor-position) (method)
(setf cursor-position) (generic function)
(setf cursor-position) (method)
(setf cursor-position) (method)
for-each-row (function)
make-cursor (generic function)
make-cursor (method)
row-count (generic function)
row-count (method)
row-count (method)

Internal Definitions

absolute-cursor-position (generic function)
(setf absolute-cursor-position) (generic function)
(setf absolute-cursor-position) (method)
(setf absolute-cursor-position) (method)
close-cursor (generic function)
current-row-index-of (method)
(setf current-row-index-of) (method)
cursor (class)
default-result-type-of (method)
(setf default-result-type-of) (method)
random-access-cursor (class)
rows-of (method)
(setf rows-of) (method)
sequence-cursor (class)
sequential-access-cursor (class)
transaction-of (method)
(setf transaction-of) (method)

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

Parent

generic (module)

Location

source/generic/database.lisp

Exported Definitions

+database-command-line-options+ (constant)
clear-ddl-query-cache (function)
connection-specification-of (method)
(setf connection-specification-of) (method)
database (class)
disable-ddl-query-cache (function)
enable-ddl-query-cache (function)
rdbms-name-for (function)
transaction-mixin-class (generic function)
with-database (macro)

Internal Definitions

calculate-rdbms-name (generic function)
calculate-rdbms-name (method)
calculate-rdbms-name-with-utf-8-length-limit (function)
ddl-query-cache-of (method)
(setf ddl-query-cache-of) (method)
default-result-type-of (method)
(setf default-result-type-of) (method)
encoding-of (method)
(setf encoding-of) (method)
transaction-class-of (method)
(setf transaction-class-of) (method)

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

Dependency

Parent

generic (module)

Location

source/generic/ddl.lisp

Exported Definitions

add-column (function)
add-foreign-key-constraint (function)
add-primary-key-constraint (function)
alter-column-type (function)
alter-table (function)
continue-with-schema-change (function)
create-index (function)
create-sequence (function)
create-table (function)
create-temporary-table (function)
create-view (function)
database-list-table-foreign-keys (generic function)
database-list-view-definitions (generic function)
database-view-definition (generic function)
drop-column (function)
drop-index (function)
drop-sequence (function)
drop-table (function)
drop-table-foreign-keys (function)
drop-view (function)
foreign-key-descriptor (class)
list-dependent-views (function)
list-sequences (function)
list-table-columns (function)
list-table-foreign-keys (function)
list-table-indices (function)
list-table-primary-constraints (function)
list-tables (function)
list-view-definitions (function)
list-views (function)
sequence-current (function)
sequence-exists-p (function)
sequence-next (function)
set-sequence-value (function)
table-exists-p (function)
update-index (function)
update-table (function)
update-view (function)
view-definition (function)
view-exists-p (function)
with-confirmed-destructive-schema-changes (macro)

Internal Definitions

call-with-confirmed-destructive-schema-changes (function)
collect-column-foreign-keys (function)
database-list-dependent-views (generic function)
database-list-sequences (generic function)
database-list-table-columns (generic function)
database-list-table-indices (generic function)
database-list-table-primary-constraints (generic function)
database-list-tables (generic function)
database-list-views (generic function)
delete-rule-of (method)
(setf delete-rule-of) (method)
equal-type-p (generic function)
equal-type-p (method)
fkey-actions-same-p (function)
name-of (method)
(setf name-of) (method)
rdbms-type-for (generic function)
rdbms-type-for (method)
source-column-of (method)
(setf source-column-of) (method)
source-table-of (method)
(setf source-table-of) (method)
target-column-of (method)
(setf target-column-of) (method)
target-table-of (method)
(setf target-table-of) (method)
update-existing-table (function)
update-existing-table-foreign-keys (function)
update-rule-of (method)
(setf update-rule-of) (method)

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

Dependency

Parent

generic (module)

Location

source/generic/dml.lisp

Exported Definitions

delete-records (function)
insert-record (function)
select-count-* (function)
select-records (function)
update-records (function)

Internal Definitions

sql-literal-values-for (function)

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

Dependency

database.lisp (file)

Parent

generic (module)

Location

source/generic/transaction.lisp

Exported Definitions

abandon-and-recreate-transaction (function)
assert-single-select-statement (macro)
begin (function)
begin-transaction (generic function)
begin-transaction (method)
break-on-next-command (function)
call-in-transaction (generic function)
call-in-transaction (method)
cleanup-transaction (generic function)
cleanup-transaction (method)
commit (function)
commit-and-recreate-transaction (function)
commit-transaction (generic function)
commit-transaction (method)
commit-transaction (method)
commit-transaction (method)
current-delete-counter (function)
current-insert-counter (function)
current-select-counter (function)
current-update-counter (function)
delete-counter-of (method)
(setf delete-counter-of) (method)
execute (function)
execute-ddl (function)
in-transaction-p (function)
insert-counter-of (method)
(setf insert-counter-of) (method)
make-transaction (generic function)
make-transaction (method)
make-transaction (method)
mark-transaction-for-commit-only (function)
mark-transaction-for-rollback-only (function)
notify-transaction-event (generic function)
notify-transaction-event (method)
register-hook-in-transaction (generic function)
register-hook-in-transaction (method)
register-transaction-hook (macro)
release-savepoint (function)
report-transaction-state (function)
rollback (function)
rollback-to-savepoint (function)
rollback-transaction (generic function)
rollback-transaction (method)
rollback-transaction (method)
rollback-transaction (method)
savepoint (function)
select-counter-of (method)
(setf select-counter-of) (method)
transaction (class)
transaction-in-progress-p (function)
transaction-mixin-class (method)
transaction-timestamp (function)
transaction-valid-p (function)
transaction-with-hooks-mixin (class)
update-counter-of (method)
(setf update-counter-of) (method)
with-readonly-transaction (macro)
with-transaction (macro)
with-transaction* (macro)

Internal Definitions

%generate-log-description-for-command (function)
action-of (method)
(setf action-of) (method)
assert-transaction-in-progress (function)
backend-release-savepoint (generic function)
begin-was-executed-p (method)
(setf begin-was-executed-p) (method)
break-on-next-command-p (method)
(setf break-on-next-command-p) (method)
call-transaction-hooks (function)
call-with-transaction* (function)
command-counter (class)
command-counter-of (method)
(setf command-counter-of) (method)
database-of (method)
(setf database-of) (method)
default-result-type-of (method)
(setf default-result-type-of) (method)
execute-command (generic function)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
function-of (method)
(setf function-of) (method)
hooks-of (method)
(setf hooks-of) (method)
name-of (method)
(setf name-of) (method)
prepare-command (generic function)
prepared-statement (class)
state-of (method)
(setf state-of) (method)
terminal-action-of (method)
(setf terminal-action-of) (method)
(setf terminal-action-of) (method)
timestamp-of (method)
(setf timestamp-of) (method)
transaction-hook (class)
transaction-hook-action (type)
transaction-hook-invocation-time (type)
update-binding-values (function)
when-of (method)
(setf when-of) (method)

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

Dependencies

create-table.lisp (file)
constraint.lisp (file)

Parent

syntax (module)

Location

source/syntax/alter-table.lisp

Exported Definitions

constraint-to-action (generic function)
constraint-to-action (method)
constraint-to-action (method)
drop-foreign-key (function)
sql-add-foreign-key-constraint-action (macro)
sql-add-foreign-key-constraint-action (class)
sql-drop-constraint-action (macro)
sql-drop-constraint-action (class)

Internal Definitions

actions-of (method)
(setf actions-of) (method)
cascade-p (method)
(setf cascade-p) (method)
columns-of (method)
(setf columns-of) (method)
default-value-of (method)
(setf default-value-of) (method)
delete-rule-of (method)
(setf delete-rule-of) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
source-columns-of (method)
(setf source-columns-of) (method)
sql-add-column-action (macro)
sql-add-column-action (class)
sql-add-constraint-action (macro)
sql-add-constraint-action (class)
sql-add-primary-key-constraint-action (macro)
sql-add-primary-key-constraint-action (class)
sql-alter-column-type-action (macro)
sql-alter-column-type-action (class)
sql-alter-table (macro)
sql-alter-table (class)
sql-drop-column-action (macro)
sql-drop-column-action (class)
target-columns-of (method)
(setf target-columns-of) (method)
target-table-of (method)
(setf target-table-of) (method)
update-rule-of (method)
(setf update-rule-of) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/constraint.lisp

Exported Definitions

sql-foreign-key-constraint (macro)
sql-foreign-key-constraint (class)

Internal Definitions

action-of (method)
(setf action-of) (method)
delete-rule-of (method)
(setf delete-rule-of) (method)
event-of (method)
(setf event-of) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
sql-constraint (macro)
sql-constraint (class)
sql-constraint-with-tablespace (macro)
sql-constraint-with-tablespace (class)
sql-foreign-key-action (macro)
sql-foreign-key-action (class)
sql-not-null-constraint (macro)
sql-not-null-constraint (class)
sql-null-constraint (macro)
sql-null-constraint (class)
sql-primary-key-constraint (macro)
sql-primary-key-constraint (class)
sql-unique-constraint (macro)
sql-unique-constraint (class)
tablespace-of (method)
(setf tablespace-of) (method)
target-column-of (method)
(setf target-column-of) (method)
target-table-of (method)
(setf target-table-of) (method)
update-rule-of (method)
(setf update-rule-of) (method)

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

Dependencies

syntax.lisp (file)
expression.lisp (file)

Parent

syntax (module)

Location

source/syntax/create-table.lisp

Exported Definitions

constraints-of (method)
(setf constraints-of) (method)
sql-create-table (macro)
sql-create-table (class)
sql-create-view (macro)
sql-create-view (class)

Internal Definitions

as-of (method)
(setf as-of) (method)
columns-of (method)
(setf columns-of) (method)
default-value-of (method)
(setf default-value-of) (method)
format-sql-identifier (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
replace-p (method)
(setf replace-p) (method)
sql-column (macro)
sql-column (class)
temporary-of (method)
(setf temporary-of) (method)
type-of (method)
(setf type-of) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/delete.lisp

Internal Definitions

format-sql-syntax-node (method)
make-syntax-node (method)
sql-delete (macro)
sql-delete (class)
table-of (method)
(setf table-of) (method)
where-of (method)
(setf where-of) (method)

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

cascade-p (method)
(setf cascade-p) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
sql-drop-table (macro)
sql-drop-table (class)
sql-drop-view (macro)
sql-drop-view (class)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/expression.lisp

Exported Definitions

sql-cond (function)
sql-if (function)

Internal Definitions

*sql-function-names* (special variable)
*sql-operator-names* (special variable)
all-p (method)
(setf all-p) (method)
arguments-of (method)
(setf arguments-of) (method)
case-sensitive-p (method)
(setf case-sensitive-p) (method)
case-sensitive-p (method)
(setf case-sensitive-p) (method)
clauses-of (method)
(setf clauses-of) (method)
expression-of (method)
(setf expression-of) (method)
expressions-of (method)
(setf expressions-of) (method)
fix-of (method)
(setf fix-of) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
left-of (method)
(setf left-of) (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
pattern-of (method)
(setf pattern-of) (method)
pattern-of (method)
(setf pattern-of) (method)
right-of (method)
(setf right-of) (method)
set-operation-of (method)
(setf set-operation-of) (method)
sql-# (function)
sql-% (function)
sql-& (function)
sql-* (function)
sql-+ (function)
sql-- (function)
sql-/ (function)
sql-< (function)
sql-<< (function)
sql-<= (function)
sql-<> (function)
sql-= (function)
sql-> (function)
sql->= (function)
sql->> (function)
sql-@ (function)
sql-^ (function)
sql-and (function)
sql-avg (function)
sql-binary-operator (macro)
sql-binary-operator (class)
sql-case (macro)
sql-case (class)
sql-count (function)
sql-count-* (function)
sql-distinct (function)
sql-except (function)
sql-exists (function)
sql-expression (macro)
sql-expression (class)
sql-false-expression (macro)
sql-false-expression (class)
sql-function-call (macro)
sql-function-call (class)
sql-in (function)
sql-intersect (function)
sql-is-not-null (function)
sql-is-null (function)
sql-like (macro)
sql-like (class)
sql-max (function)
sql-min (function)
sql-n-ary-operator (macro)
sql-n-ary-operator (class)
sql-not (function)
sql-operator (macro)
sql-operator (class)
sql-or (function)
sql-query-expression (macro)
sql-query-expression (class)
sql-regexp-like (macro)
sql-regexp-like (class)
sql-set-operation-expression (macro)
sql-set-operation-expression (class)
sql-subquery (macro)
sql-subquery (class)
sql-sum (function)
sql-unary-operator (macro)
sql-unary-operator (class)
sql-union (function)
sql-| (function)
sql-|/ (function)
sql-|| (function)
sql-~ (function)
string-of (method)
(setf string-of) (method)
string-of (method)
(setf string-of) (method)
subqueries-of (method)
(setf subqueries-of) (method)

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

Parent

syntax (module)

Location

source/syntax/format.lisp

Exported Definitions

format-sql (function)
format-sql-to-string (function)
import-sql-constructor-names (function)
import-sql-syntax-node-names (function)

Internal Definitions

*binding-types* (special variable)
*binding-values* (special variable)
*binding-variables* (special variable)
*command-elements* (special variable)
*sql-constructor-names* (special variable)
*sql-stream* (special variable)
*sql-syntax-node-names* (special variable)
execute-command (method)
expand-sql-ast-into-lambda-form (function)
expand-sql-ast-into-lambda-form-cached (function)
format-char (macro)
format-comma-separated-identifiers (function)
format-comma-separated-list (function)
format-number (macro)
format-separated-list (function)
format-sql-syntax-node (generic function)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-where (function)
format-string (macro)
make-syntax-node (generic function)
print-number-to-sql-string (function)
reduce-subsequences (function)
same-backend-p (function)
sql-constructor-name (function)
sql-operator-name (function)
vector-extend (function)
with-cache (macro)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/index.lisp

Exported Definitions

sql-create-index (macro)
sql-create-index (class)

Internal Definitions

columns-of (method)
(setf columns-of) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
sql-drop-index (macro)
sql-drop-index (class)
sql-index (macro)
sql-index (class)
table-name-of (method)
(setf table-name-of) (method)
unique-p (method)
(setf unique-p) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/insert.lisp

Internal Definitions

columns-of (method)
(setf columns-of) (method)
format-sql-syntax-node (method)
make-syntax-node (method)
sql-insert (macro)
sql-insert (class)
subselect-of (method)
(setf subselect-of) (method)
table-of (method)
(setf table-of) (method)
values-of (method)
(setf values-of) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/lock.lisp

Internal Definitions

format-sql-syntax-node (method)
make-syntax-node (method)
mode-of (method)
(setf mode-of) (method)
sql-lock-table (macro)
sql-lock-table (class)
table-of (method)
(setf table-of) (method)
wait-p (method)
(setf wait-p) (method)

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

*original-unquote-reader* (special variable)
+default-sql-syntax-close-character+ (constant)
+default-sql-syntax-open-character+ (constant)
+default-sql-syntax-unquote-character+ (constant)
make-sql-reader (function)

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

Dependencies

syntax.lisp (file)
expression.lisp (file)

Parent

syntax (module)

Location

source/syntax/select.lisp

Internal Definitions

alias-of (method)
(setf alias-of) (method)
alias-of (method)
(setf alias-of) (method)
alias-of (method)
(setf alias-of) (method)
column-of (method)
(setf column-of) (method)
column-spec-of (method)
(setf column-spec-of) (method)
columns-of (method)
(setf columns-of) (method)
distinct-p (method)
(setf distinct-p) (method)
for-of (method)
(setf for-of) (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-table-reference (function)
group-by-of (method)
(setf group-by-of) (method)
having-of (method)
(setf having-of) (method)
kind-of (method)
(setf kind-of) (method)
left-of (method)
(setf left-of) (method)
limit-of (method)
(setf limit-of) (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
offset-of (method)
(setf offset-of) (method)
on-of (method)
(setf on-of) (method)
order-by-of (method)
(setf order-by-of) (method)
ordering-of (method)
(setf ordering-of) (method)
right-of (method)
(setf right-of) (method)
sort-key-of (method)
(setf sort-key-of) (method)
sql-all-columns (macro)
sql-all-columns (class)
sql-column-alias (macro)
sql-column-alias (class)
sql-column-alias* (type)
sql-derived-table (macro)
sql-derived-table (class)
sql-distinct-spec (macro)
sql-distinct-spec (class)
sql-joined-table (macro)
sql-joined-table (class)
sql-select (macro)
sql-select (class)
sql-sort-spec (macro)
sql-sort-spec (class)
sql-table-alias (macro)
sql-table-alias (class)
sql-table-alias* (type)
sql-table-reference (type)
subquery-of (method)
(setf subquery-of) (method)
table-of (method)
(setf table-of) (method)
tables-of (method)
(setf tables-of) (method)
using-of (method)
(setf using-of) (method)
wait-p (method)
(setf wait-p) (method)
where-of (method)
(setf where-of) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/sequence.lisp

Internal Definitions

currentp (method)
(setf currentp) (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
sql-create-sequence (macro)
sql-create-sequence (class)
sql-drop-sequence (macro)
sql-drop-sequence (class)
sql-sequence-currval-column (macro)
sql-sequence-currval-column (class)
sql-sequence-nextval-column (macro)
sql-sequence-nextval-column (class)
sql-sequence-setval (macro)
sql-sequence-setval (class)
temporary-p (method)
(setf temporary-p) (method)
value-of (method)
(setf value-of) (method)

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

Dependencies

syntax.lisp (file)
expression.lisp (file)

Parent

syntax (module)

Location

source/syntax/sexp.lisp

Exported Definitions

sql (macro)

Internal Definitions

compile-sexp-sql (function)
compile-sexp-sql-binding-variable (function)
compile-sexp-sql-column (function)
compile-sexp-sql-column-alias (function)
compile-sexp-sql-columns (function)
compile-sexp-sql-create (function)
compile-sexp-sql-delete (function)
compile-sexp-sql-drop (function)
compile-sexp-sql-expression (function)
compile-sexp-sql-function-call (function)
compile-sexp-sql-function-call-argument (function)
compile-sexp-sql-insert (function)
compile-sexp-sql-literal (function)
compile-sexp-sql-select (function)
compile-sexp-sql-table-alias (function)
compile-sexp-sql-type (function)
compile-sexp-sql-unquote (function)
compile-sexp-sql-update (function)
compile-sexp-sql-where (function)
error-at-form-of (method)
(setf error-at-form-of) (method)
process-sexp-sql-syntax-list (function)
process-sexp-sql-syntax-node (function)
sexp-sql-unquote-p (function)
sql-compile-error (function)
sql-compile-error (condition)
sql-function-call-form-p (function)
sql-function-name-p (function)
sql-symbol-equal (function)
stringify (function)
whole-form-of (method)
(setf whole-form-of) (method)

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

*expand-cached* (special variable)
execute-command (method)
expand-sql-unquote (function)
form-of (method)
(setf form-of) (method)
format-sql-function-name (generic function)
format-sql-function-name (method)
format-sql-function-name (method)
format-sql-identifier (generic function)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-literal (generic function)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-operator-name (generic function)
format-sql-operator-name (method)
format-sql-operator-name (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
name-of (method)
(setf name-of) (method)
named-sql-syntax-node (macro)
named-sql-syntax-node (class)
push-form-into-command-elements (function)
spliced-p (method)
(setf spliced-p) (method)
sql-binding-variable (macro)
sql-binding-variable (class)
sql-ddl-statement (class)
sql-dml-statement (class)
sql-fragment (macro)
sql-fragment (class)
sql-identifier (macro)
sql-identifier (class)
sql-identifier* (type)
sql-literal (macro)
sql-literal (class)
sql-literal* (type)
sql-of (method)
(setf sql-of) (method)
sql-statement (class)
sql-syntax-node (macro)
sql-syntax-node (class)
sql-unquote (macro)
sql-unquote (class)
type-of (method)
(setf type-of) (method)
type-of (method)
(setf type-of) (method)
unquote-aware-format-sql-binding-variable (function)
unquote-aware-format-sql-literal (function)
value-of (method)
(setf value-of) (method)
variable-name-of (method)
(setf variable-name-of) (method)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/type.lisp

Internal Definitions

bit-size-of (method)
(setf bit-size-of) (method)
equal-type-p (method)
equal-type-p (method)
equal-type-p (method)
format-size (function)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
rdbms-type-for (method)
size-of (method)
(setf size-of) (method)
sql-binary-large-object-type (macro)
sql-binary-large-object-type (class)
sql-bit-sized-type (macro)
sql-bit-sized-type (class)
sql-boolean-type (macro)
sql-boolean-type (class)
sql-character-large-object-type (macro)
sql-character-large-object-type (class)
sql-character-type (macro)
sql-character-type (class)
sql-character-varying-type (macro)
sql-character-varying-type (class)
sql-date-type (macro)
sql-date-type (class)
sql-float-type (macro)
sql-float-type (class)
sql-integer-type (macro)
sql-integer-type (class)
sql-interval-type (macro)
sql-interval-type (class)
sql-numeric-type (macro)
sql-numeric-type (class)
sql-simple-type (macro)
sql-simple-type (class)
sql-sized-type (macro)
sql-sized-type (class)
sql-string-type (macro)
sql-string-type (class)
sql-time-type (macro)
sql-time-type (class)
sql-timestamp-type (macro)
sql-timestamp-type (class)
sql-timestamp-with-timezone-type (macro)
sql-timestamp-with-timezone-type (class)
sql-type (macro)
sql-type (class)

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

Dependency

syntax.lisp (file)

Parent

syntax (module)

Location

source/syntax/update.lisp

Internal Definitions

columns-of (method)
(setf columns-of) (method)
format-sql-syntax-node (method)
make-syntax-node (method)
sql-update (macro)
sql-update (class)
table-of (method)
(setf table-of) (method)
values-of (method)
(setf values-of) (method)
where-of (method)
(setf where-of) (method)

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

Dependency

package.lisp (file)

Parent

source (module)

Location

source/variables.lisp

Exported Definitions

*database* (special variable)
*implicit-transaction* (special variable)
*implicit-transaction-default-terminal-action* (special variable)
*signal-non-destructive-alter-table-commands* (special variable)
*transaction* (special variable)

5 Packages

Packages are listed by definition order.

5.1 `hu.dwim.rdbms`

Source

package.lisp (file)

Use List

hu.dwim.util
hu.dwim.syntax-sugar
hu.dwim.logger
hu.dwim.defclass-star
hu.dwim.def
hu.dwim.common
hu.dwim.asdf
babel

Exported Definitions

*database* (special variable)
*implicit-transaction* (special variable)
*implicit-transaction-default-terminal-action* (special variable)
*signal-non-destructive-alter-table-commands* (special variable)
*transaction* (special variable)
+database-command-line-options+ (constant)
abandon-and-recreate-transaction (function)
add-column (function)
add-foreign-key-constraint (function)
add-primary-key-constraint (function)
alter-column-type (function)
alter-table (function)
assert-single-select-statement (macro)
begin (function)
begin-transaction (generic function)
begin-transaction (method)
break-on-next-command (function)
call-in-transaction (generic function)
call-in-transaction (method)
cleanup-transaction (generic function)
cleanup-transaction (method)
clear-ddl-query-cache (function)
collect-rows (function)
column-count (generic function)
column-count (method)
column-name (generic function)
column-name (method)
column-type (generic function)
column-type (method)
column-value (generic function)
column-value (method)
commit (function)
commit-and-recreate-transaction (function)
commit-transaction (generic function)
commit-transaction (method)
commit-transaction (method)
commit-transaction (method)
connection-specification-of (generic function)
connection-specification-of (method)
(setf connection-specification-of) (method)
(setf connection-specification-of) (generic function)
constraint-to-action (generic function)
constraint-to-action (method)
constraint-to-action (method)
constraints-of (generic function)
constraints-of (method)
(setf constraints-of) (method)
(setf constraints-of) (generic function)
continue-with-schema-change (function)
create-index (function)
create-sequence (function)
create-table (function)
create-temporary-table (function)
create-view (function)
current-delete-counter (function)
current-insert-counter (function)
current-row (function)
current-select-counter (function)
current-update-counter (function)
cursor-position (generic function)
cursor-position (method)
(setf cursor-position) (method)
(setf cursor-position) (generic function)
(setf cursor-position) (method)
(setf cursor-position) (method)
database (class)
database-list-table-foreign-keys (generic function)
database-list-view-definitions (generic function)
database-view-definition (generic function)
deadlock-detected-error (function)
deadlock-detected-error (condition)
delete-counter-of (generic function)
delete-counter-of (method)
(setf delete-counter-of) (method)
(setf delete-counter-of) (generic function)
delete-records (function)
disable-ddl-query-cache (function)
disable-sql-log (function)
drop-column (function)
drop-foreign-key (function)
drop-index (function)
drop-sequence (function)
drop-table (function)
drop-table-foreign-keys (function)
drop-view (function)
enable-ddl-query-cache (function)
enable-sql-log (function)
enable-sql-syntax (macro)
execute (function)
execute-ddl (function)
for-each-row (function)
foreign-key-descriptor (class)
format-sql (function)
format-sql-to-string (function)
import-sql-constructor-names (function)
import-sql-syntax-node-names (function)
in-transaction-p (function)
insert-counter-of (generic function)
insert-counter-of (method)
(setf insert-counter-of) (method)
(setf insert-counter-of) (generic function)
insert-record (function)
list-dependent-views (function)
list-sequences (function)
list-table-columns (function)
list-table-foreign-keys (function)
list-table-indices (function)
list-table-primary-constraints (function)
list-tables (function)
list-view-definitions (function)
list-views (function)
make-cursor (generic function)
make-cursor (method)
make-transaction (generic function)
make-transaction (method)
make-transaction (method)
mark-transaction-for-commit-only (function)
mark-transaction-for-rollback-only (function)
notify-transaction-event (generic function)
notify-transaction-event (method)
rdbms-error (condition)
rdbms-name-for (function)
register-hook-in-transaction (generic function)
register-hook-in-transaction (method)
register-transaction-hook (macro)
release-savepoint (function)
report-transaction-state (function)
rollback (function)
rollback-to-savepoint (function)
rollback-transaction (generic function)
rollback-transaction (method)
rollback-transaction (method)
rollback-transaction (method)
row-count (generic function)
row-count (method)
row-count (method)
savepoint (function)
select-count-* (function)
select-counter-of (generic function)
select-counter-of (method)
(setf select-counter-of) (method)
(setf select-counter-of) (generic function)
select-records (function)
sequence-current (function)
sequence-exists-p (function)
sequence-next (function)
set-sequence-value (function)
simple-rdbms-error (function)
simple-rdbms-error (condition)
sql (macro)
sql-add-foreign-key-constraint-action (macro)
sql-add-foreign-key-constraint-action (class)
sql-cond (function)
sql-create-index (macro)
sql-create-index (class)
sql-create-table (macro)
sql-create-table (class)
sql-create-view (macro)
sql-create-view (class)
sql-drop-constraint-action (macro)
sql-drop-constraint-action (class)
sql-foreign-key-constraint (macro)
sql-foreign-key-constraint (class)
sql-if (function)
table-exists-p (function)
transaction (class)
transaction-in-progress-p (function)
transaction-mixin-class (generic function)
transaction-mixin-class (method)
transaction-timestamp (function)
transaction-valid-p (function)
transaction-with-hooks-mixin (class)
unable-to-obtain-lock-error (function)
unable-to-obtain-lock-error (condition)
unbound-binding-variable-error (condition)
unconfirmed-destructive-schema-change (condition)
unconfirmed-destructive-schema-change/alter-column-type (condition)
unconfirmed-destructive-schema-change/drop-column (condition)
unconfirmed-schema-change (condition)
unconfirmed-schema-change/add-column (condition)
unconfirmed-schema-change/add-foreign-key (condition)
unconfirmed-schema-change/create-table (condition)
unconfirmed-schema-change/drop-foreign-key (condition)
unconfirmed-schema-change/replace-foreign-key (condition)
update-counter-of (generic function)
update-counter-of (method)
(setf update-counter-of) (method)
(setf update-counter-of) (generic function)
update-index (function)
update-records (function)
update-table (function)
update-view (function)
view-definition (function)
view-exists-p (function)
with-confirmed-destructive-schema-changes (macro)
with-database (macro)
with-readonly-transaction (macro)
with-transaction (macro)
with-transaction* (macro)

Internal Definitions

%generate-log-description-for-command (function)
%signal-translated-simple-rdbms-error (function)
*binding-types* (special variable)
*binding-values* (special variable)
*binding-variables* (special variable)
*command-elements* (special variable)
*expand-cached* (special variable)
*original-unquote-reader* (special variable)
*sql-constructor-names* (special variable)
*sql-function-names* (special variable)
*sql-operator-names* (special variable)
*sql-stream* (special variable)
*sql-syntax-node-names* (special variable)
+default-sql-syntax-close-character+ (constant)
+default-sql-syntax-open-character+ (constant)
+default-sql-syntax-unquote-character+ (constant)
absolute-cursor-position (generic function)
(setf absolute-cursor-position) (generic function)
(setf absolute-cursor-position) (method)
(setf absolute-cursor-position) (method)
action-of (generic function)
action-of (method)
(setf action-of) (method)
action-of (method)
(setf action-of) (method)
(setf action-of) (generic function)
actions-of (generic function)
actions-of (method)
(setf actions-of) (method)
(setf actions-of) (generic function)
alias-of (generic function)
alias-of (method)
(setf alias-of) (method)
alias-of (method)
(setf alias-of) (method)
alias-of (method)
(setf alias-of) (method)
(setf alias-of) (generic function)
all-p (generic function)
all-p (method)
(setf all-p) (method)
(setf all-p) (generic function)
arguments-of (generic function)
arguments-of (method)
(setf arguments-of) (method)
(setf arguments-of) (generic function)
as-of (generic function)
as-of (method)
(setf as-of) (method)
(setf as-of) (generic function)
assert-transaction-in-progress (function)
backend-release-savepoint (generic function)
begin-was-executed-p (generic function)
begin-was-executed-p (method)
(setf begin-was-executed-p) (method)
(setf begin-was-executed-p) (generic function)
bit-size-of (generic function)
bit-size-of (method)
(setf bit-size-of) (method)
(setf bit-size-of) (generic function)
break-on-next-command-p (generic function)
break-on-next-command-p (method)
(setf break-on-next-command-p) (method)
(setf break-on-next-command-p) (generic function)
calculate-rdbms-name (generic function)
calculate-rdbms-name (method)
calculate-rdbms-name-with-utf-8-length-limit (function)
call-transaction-hooks (function)
call-with-confirmed-destructive-schema-changes (function)
call-with-transaction* (function)
cascade-p (generic function)
cascade-p (method)
(setf cascade-p) (method)
cascade-p (method)
(setf cascade-p) (method)
(setf cascade-p) (generic function)
case-sensitive-p (generic function)
case-sensitive-p (method)
(setf case-sensitive-p) (method)
case-sensitive-p (method)
(setf case-sensitive-p) (method)
(setf case-sensitive-p) (generic function)
clauses-of (generic function)
clauses-of (method)
(setf clauses-of) (method)
(setf clauses-of) (generic function)
close-cursor (generic function)
collect-column-foreign-keys (function)
column-name-of (generic function)
column-name-of (method)
(setf column-name-of) (method)
(setf column-name-of) (generic function)
column-of (generic function)
column-of (method)
(setf column-of) (method)
(setf column-of) (generic function)
column-spec-of (generic function)
column-spec-of (method)
(setf column-spec-of) (method)
(setf column-spec-of) (generic function)
column-type-of (generic function)
column-type-of (method)
(setf column-type-of) (method)
(setf column-type-of) (generic function)
columns-of (generic function)
columns-of (method)
(setf columns-of) (method)
columns-of (method)
(setf columns-of) (method)
columns-of (method)
(setf columns-of) (method)
columns-of (method)
(setf columns-of) (method)
columns-of (method)
(setf columns-of) (method)
columns-of (method)
(setf columns-of) (method)
(setf columns-of) (generic function)
command-counter (class)
command-counter-of (generic function)
command-counter-of (method)
(setf command-counter-of) (method)
(setf command-counter-of) (generic function)
compile-sexp-sql (function)
compile-sexp-sql-binding-variable (function)
compile-sexp-sql-column (function)
compile-sexp-sql-column-alias (function)
compile-sexp-sql-columns (function)
compile-sexp-sql-create (function)
compile-sexp-sql-delete (function)
compile-sexp-sql-drop (function)
compile-sexp-sql-expression (function)
compile-sexp-sql-function-call (function)
compile-sexp-sql-function-call-argument (function)
compile-sexp-sql-insert (function)
compile-sexp-sql-literal (function)
compile-sexp-sql-select (function)
compile-sexp-sql-table-alias (function)
compile-sexp-sql-type (function)
compile-sexp-sql-unquote (function)
compile-sexp-sql-update (function)
compile-sexp-sql-where (function)
constraint-name-of (generic function)
constraint-name-of (method)
(setf constraint-name-of) (method)
constraint-name-of (method)
(setf constraint-name-of) (method)
constraint-name-of (method)
(setf constraint-name-of) (method)
(setf constraint-name-of) (generic function)
current-row-index-of (generic function)
current-row-index-of (method)
(setf current-row-index-of) (method)
(setf current-row-index-of) (generic function)
currentp (generic function)
currentp (method)
(setf currentp) (method)
(setf currentp) (generic function)
cursor (class)
database-list-dependent-views (generic function)
database-list-sequences (generic function)
database-list-table-columns (generic function)
database-list-table-indices (generic function)
database-list-table-primary-constraints (generic function)
database-list-tables (generic function)
database-list-views (generic function)
database-of (generic function)
database-of (method)
(setf database-of) (method)
(setf database-of) (generic function)
ddl-query-cache-of (generic function)
ddl-query-cache-of (method)
(setf ddl-query-cache-of) (method)
(setf ddl-query-cache-of) (generic function)
default-result-type-of (generic function)
default-result-type-of (method)
(setf default-result-type-of) (method)
default-result-type-of (method)
(setf default-result-type-of) (method)
default-result-type-of (method)
(setf default-result-type-of) (method)
(setf default-result-type-of) (generic function)
default-value-of (generic function)
default-value-of (method)
(setf default-value-of) (method)
default-value-of (method)
(setf default-value-of) (method)
(setf default-value-of) (generic function)
delete-rule-of (generic function)
delete-rule-of (method)
(setf delete-rule-of) (method)
delete-rule-of (method)
(setf delete-rule-of) (method)
delete-rule-of (method)
(setf delete-rule-of) (method)
(setf delete-rule-of) (generic function)
distinct-p (generic function)
distinct-p (method)
(setf distinct-p) (method)
(setf distinct-p) (generic function)
encoding-of (generic function)
encoding-of (method)
(setf encoding-of) (method)
(setf encoding-of) (generic function)
equal-type-p (generic function)
equal-type-p (method)
equal-type-p (method)
equal-type-p (method)
equal-type-p (method)
error-at-form-of (generic function)
error-at-form-of (method)
(setf error-at-form-of) (method)
(setf error-at-form-of) (generic function)
event-of (generic function)
event-of (method)
(setf event-of) (method)
(setf event-of) (generic function)
execute-command (generic function)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
execute-command (method)
expand-sql-ast-into-lambda-form (function)
expand-sql-ast-into-lambda-form-cached (function)
expand-sql-unquote (function)
expression-of (generic function)
expression-of (method)
(setf expression-of) (method)
(setf expression-of) (generic function)
expressions-of (generic function)
expressions-of (method)
(setf expressions-of) (method)
(setf expressions-of) (generic function)
fix-of (generic function)
fix-of (method)
(setf fix-of) (method)
(setf fix-of) (generic function)
fkey-actions-same-p (function)
for-of (generic function)
for-of (method)
(setf for-of) (method)
(setf for-of) (generic function)
form-of (generic function)
form-of (method)
(setf form-of) (method)
(setf form-of) (generic function)
format-char (macro)
format-comma-separated-identifiers (function)
format-comma-separated-list (function)
format-number (macro)
format-separated-list (function)
format-size (function)
format-sql-function-name (generic function)
format-sql-function-name (method)
format-sql-function-name (method)
format-sql-identifier (generic function)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-identifier (method)
format-sql-literal (generic function)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-literal (method)
format-sql-operator-name (generic function)
format-sql-operator-name (method)
format-sql-operator-name (method)
format-sql-syntax-node (generic function)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-syntax-node (method)
format-sql-table-reference (function)
format-sql-where (function)
format-string (macro)
function-of (generic function)
function-of (method)
(setf function-of) (method)
(setf function-of) (generic function)
group-by-of (generic function)
group-by-of (method)
(setf group-by-of) (method)
(setf group-by-of) (generic function)
having-of (generic function)
having-of (method)
(setf having-of) (method)
(setf having-of) (generic function)
hooks-of (generic function)
hooks-of (method)
(setf hooks-of) (method)
(setf hooks-of) (generic function)
ignore-missing-p (generic function)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
ignore-missing-p (method)
(setf ignore-missing-p) (method)
(setf ignore-missing-p) (generic function)
kind-of (generic function)
kind-of (method)
(setf kind-of) (method)
(setf kind-of) (generic function)
left-of (generic function)
left-of (method)
(setf left-of) (method)
left-of (method)
(setf left-of) (method)
(setf left-of) (generic function)
limit-of (generic function)
limit-of (method)
(setf limit-of) (method)
(setf limit-of) (generic function)
make-sql-reader (function)
make-syntax-node (generic function)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
make-syntax-node (method)
mode-of (generic function)
mode-of (method)
(setf mode-of) (method)
(setf mode-of) (generic function)
name-of (generic function)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
name-of (method)
(setf name-of) (method)
(setf name-of) (generic function)
named-sql-syntax-node (macro)
named-sql-syntax-node (class)
new-rdbms-type-of (generic function)
new-rdbms-type-of (method)
(setf new-rdbms-type-of) (method)
(setf new-rdbms-type-of) (generic function)
new-type-of (generic function)
new-type-of (method)
(setf new-type-of) (method)
(setf new-type-of) (generic function)
offset-of (generic function)
offset-of (method)
(setf offset-of) (method)
(setf offset-of) (generic function)
old-type-of (generic function)
old-type-of (method)
(setf old-type-of) (method)
(setf old-type-of) (generic function)
on-of (generic function)
on-of (method)
(setf on-of) (method)
(setf on-of) (generic function)
order-by-of (generic function)
order-by-of (method)
(setf order-by-of) (method)
(setf order-by-of) (generic function)
ordering-of (generic function)
ordering-of (method)
(setf ordering-of) (method)
(setf ordering-of) (generic function)
original-error-of (generic function)
original-error-of (method)
(setf original-error-of) (method)
(setf original-error-of) (generic function)
pattern-of (generic function)
pattern-of (method)
(setf pattern-of) (method)
pattern-of (method)
(setf pattern-of) (method)
(setf pattern-of) (generic function)
prepare-command (generic function)
prepared-statement (class)
print-number-to-sql-string (function)
process-sexp-sql-syntax-list (function)
process-sexp-sql-syntax-node (function)
push-form-into-command-elements (function)
random-access-cursor (class)
rdbms-type-for (generic function)
rdbms-type-for (method)
rdbms-type-for (method)
rdbms.debug (macro)
rdbms.dribble (macro)
rdbms.error (macro)
rdbms.fatal (macro)
rdbms.info (macro)
rdbms.warn (macro)
reduce-subsequences (function)
replace-p (generic function)
replace-p (method)
(setf replace-p) (method)
(setf replace-p) (generic function)
right-of (generic function)
right-of (method)
(setf right-of) (method)
right-of (method)
(setf right-of) (method)
(setf right-of) (generic function)
rows-of (generic function)
rows-of (method)
(setf rows-of) (method)
(setf rows-of) (generic function)
same-backend-p (function)
sequence-cursor (class)
sequential-access-cursor (class)
set-operation-of (generic function)
set-operation-of (method)
(setf set-operation-of) (method)
(setf set-operation-of) (generic function)
sexp-sql-unquote-p (function)
size-of (generic function)
size-of (method)
(setf size-of) (method)
(setf size-of) (generic function)
sort-key-of (generic function)
sort-key-of (method)
(setf sort-key-of) (method)
(setf sort-key-of) (generic function)
source-column-of (generic function)
source-column-of (method)
(setf source-column-of) (method)
(setf source-column-of) (generic function)
source-columns-of (generic function)
source-columns-of (method)
(setf source-columns-of) (method)
(setf source-columns-of) (generic function)
source-table-of (generic function)
source-table-of (method)
(setf source-table-of) (method)
(setf source-table-of) (generic function)
spliced-p (generic function)
spliced-p (method)
(setf spliced-p) (method)
(setf spliced-p) (generic function)
sql-# (function)
sql-% (function)
sql-& (function)
sql-* (function)
sql-+ (function)
sql-- (function)
sql-/ (function)
sql-< (function)
sql-<< (function)
sql-<= (function)
sql-<> (function)
sql-= (function)
sql-> (function)
sql->= (function)
sql->> (function)
sql-@ (function)
sql-^ (function)
sql-add-column-action (macro)
sql-add-column-action (class)
sql-add-constraint-action (macro)
sql-add-constraint-action (class)
sql-add-primary-key-constraint-action (macro)
sql-add-primary-key-constraint-action (class)
sql-all-columns (macro)
sql-all-columns (class)
sql-alter-column-type-action (macro)
sql-alter-column-type-action (class)
sql-alter-table (macro)
sql-alter-table (class)
sql-and (function)
sql-avg (function)
sql-binary-large-object-type (macro)
sql-binary-large-object-type (class)
sql-binary-operator (macro)
sql-binary-operator (class)
sql-binding-variable (macro)
sql-binding-variable (class)
sql-bit-sized-type (macro)
sql-bit-sized-type (class)
sql-boolean-type (macro)
sql-boolean-type (class)
sql-case (macro)
sql-case (class)
sql-character-large-object-type (macro)
sql-character-large-object-type (class)
sql-character-type (macro)
sql-character-type (class)
sql-character-varying-type (macro)
sql-character-varying-type (class)
sql-column (macro)
sql-column (class)
sql-column-alias (macro)
sql-column-alias (class)
sql-column-alias* (type)
sql-compile-error (function)
sql-compile-error (condition)
sql-constraint (macro)
sql-constraint (class)
sql-constraint-with-tablespace (macro)
sql-constraint-with-tablespace (class)
sql-constructor-name (function)
sql-count (function)
sql-count-* (function)
sql-create-sequence (macro)
sql-create-sequence (class)
sql-date-type (macro)
sql-date-type (class)
sql-ddl-statement (class)
sql-delete (macro)
sql-delete (class)
sql-derived-table (macro)
sql-derived-table (class)
sql-distinct (function)
sql-distinct-spec (macro)
sql-distinct-spec (class)
sql-dml-statement (class)
sql-drop-column-action (macro)
sql-drop-column-action (class)
sql-drop-index (macro)
sql-drop-index (class)
sql-drop-sequence (macro)
sql-drop-sequence (class)
sql-drop-table (macro)
sql-drop-table (class)
sql-drop-view (macro)
sql-drop-view (class)
sql-except (function)
sql-exists (function)
sql-expression (macro)
sql-expression (class)
sql-false-expression (macro)
sql-false-expression (class)
sql-float-type (macro)
sql-float-type (class)
sql-foreign-key-action (macro)
sql-foreign-key-action (class)
sql-fragment (macro)
sql-fragment (class)
sql-function-call (macro)
sql-function-call (class)
sql-function-call-form-p (function)
sql-function-name-p (function)
sql-identifier (macro)
sql-identifier (class)
sql-identifier* (type)
sql-in (function)
sql-index (macro)
sql-index (class)
sql-insert (macro)
sql-insert (class)
sql-integer-type (macro)
sql-integer-type (class)
sql-intersect (function)
sql-interval-type (macro)
sql-interval-type (class)
sql-is-not-null (function)
sql-is-null (function)
sql-joined-table (macro)
sql-joined-table (class)
sql-like (macro)
sql-like (class)
sql-literal (macro)
sql-literal (class)
sql-literal* (type)
sql-literal-values-for (function)
sql-lock-table (macro)
sql-lock-table (class)
sql-max (function)
sql-min (function)
sql-n-ary-operator (macro)
sql-n-ary-operator (class)
sql-not (function)
sql-not-null-constraint (macro)
sql-not-null-constraint (class)
sql-null-constraint (macro)
sql-null-constraint (class)
sql-numeric-type (macro)
sql-numeric-type (class)
sql-of (generic function)
sql-of (method)
(setf sql-of) (method)
(setf sql-of) (generic function)
sql-operator (macro)
sql-operator (class)
sql-operator-name (function)
sql-or (function)
sql-primary-key-constraint (macro)
sql-primary-key-constraint (class)
sql-query-expression (macro)
sql-query-expression (class)
sql-regexp-like (macro)
sql-regexp-like (class)
sql-select (macro)
sql-select (class)
sql-sequence-currval-column (macro)
sql-sequence-currval-column (class)
sql-sequence-nextval-column (macro)
sql-sequence-nextval-column (class)
sql-sequence-setval (macro)
sql-sequence-setval (class)
sql-set-operation-expression (macro)
sql-set-operation-expression (class)
sql-simple-type (macro)
sql-simple-type (class)
sql-sized-type (macro)
sql-sized-type (class)
sql-sort-spec (macro)
sql-sort-spec (class)
sql-statement (class)
sql-string-type (macro)
sql-string-type (class)
sql-subquery (macro)
sql-subquery (class)
sql-sum (function)
sql-symbol-equal (function)
sql-syntax-node (macro)
sql-syntax-node (class)
sql-table-alias (macro)
sql-table-alias (class)
sql-table-alias* (type)
sql-table-reference (type)
sql-time-type (macro)
sql-time-type (class)
sql-timestamp-type (macro)
sql-timestamp-type (class)
sql-timestamp-with-timezone-type (macro)
sql-timestamp-with-timezone-type (class)
sql-type (macro)
sql-type (class)
sql-unary-operator (macro)
sql-unary-operator (class)
sql-union (function)
sql-unique-constraint (macro)
sql-unique-constraint (class)
sql-unquote (macro)
sql-unquote (class)
sql-update (macro)
sql-update (class)
sql-| (function)
sql-|/ (function)
sql-|| (function)
sql-~ (function)
sql.debug (macro)
sql.dribble (macro)
sql.error (macro)
sql.fatal (macro)
sql.info (macro)
sql.warn (macro)
state-of (generic function)
state-of (method)
(setf state-of) (method)
(setf state-of) (generic function)
string-of (generic function)
string-of (method)
(setf string-of) (method)
string-of (method)
(setf string-of) (method)
(setf string-of) (generic function)
stringify (function)
subqueries-of (generic function)
subqueries-of (method)
(setf subqueries-of) (method)
(setf subqueries-of) (generic function)
subquery-of (generic function)
subquery-of (method)
(setf subquery-of) (method)
(setf subquery-of) (generic function)
subselect-of (generic function)
subselect-of (method)
(setf subselect-of) (method)
(setf subselect-of) (generic function)
table-name-of (generic function)
table-name-of (method)
(setf table-name-of) (method)
table-name-of (method)
(setf table-name-of) (method)
(setf table-name-of) (generic function)
table-of (generic function)
table-of (method)
(setf table-of) (method)
table-of (method)
(setf table-of) (method)
table-of (method)
(setf table-of) (method)
table-of (method)
(setf table-of) (method)
table-of (method)
(setf table-of) (method)
(setf table-of) (generic function)
tables-of (generic function)
tables-of (method)
(setf tables-of) (method)
(setf tables-of) (generic function)
tablespace-of (generic function)
tablespace-of (method)
(setf tablespace-of) (method)
(setf tablespace-of) (generic function)
target-column-of (generic function)
target-column-of (method)
(setf target-column-of) (method)
target-column-of (method)
(setf target-column-of) (method)
(setf target-column-of) (generic function)
target-columns-of (generic function)
target-columns-of (method)
(setf target-columns-of) (method)
(setf target-columns-of) (generic function)
target-table-of (generic function)
target-table-of (method)
(setf target-table-of) (method)
target-table-of (method)
(setf target-table-of) (method)
target-table-of (method)
(setf target-table-of) (method)
(setf target-table-of) (generic function)
temporary-of (generic function)
temporary-of (method)
(setf temporary-of) (method)
(setf temporary-of) (generic function)
temporary-p (generic function)
temporary-p (method)
(setf temporary-p) (method)
(setf temporary-p) (generic function)
terminal-action-of (generic function)
terminal-action-of (method)
(setf terminal-action-of) (method)
(setf terminal-action-of) (generic function)
(setf terminal-action-of) (method)
timestamp-of (generic function)
timestamp-of (method)
(setf timestamp-of) (method)
(setf timestamp-of) (generic function)
transaction-class-of (generic function)
transaction-class-of (method)
(setf transaction-class-of) (method)
(setf transaction-class-of) (generic function)
transaction-error (condition)
transaction-hook (class)
transaction-hook-action (type)
transaction-hook-invocation-time (type)
transaction-of (generic function)
transaction-of (method)
(setf transaction-of) (method)
(setf transaction-of) (generic function)
translated-rdbms-error (condition)
type-of (generic function)
type-of (method)
(setf type-of) (method)
type-of (method)
(setf type-of) (method)
type-of (method)
(setf type-of) (method)
(setf type-of) (generic function)
unique-p (generic function)
unique-p (method)
(setf unique-p) (method)
(setf unique-p) (generic function)
unquote-aware-format-sql-binding-variable (function)
unquote-aware-format-sql-literal (function)
update-binding-values (function)
update-existing-table (function)
update-existing-table-foreign-keys (function)
update-rule-of (generic function)
update-rule-of (method)
(setf update-rule-of) (method)
update-rule-of (method)
(setf update-rule-of) (method)
update-rule-of (method)
(setf update-rule-of) (method)
(setf update-rule-of) (generic function)
using-of (generic function)
using-of (method)
(setf using-of) (method)
(setf using-of) (generic function)
value-of (generic function)
value-of (method)
(setf value-of) (method)
value-of (method)
(setf value-of) (method)
(setf value-of) (generic function)
values-of (generic function)
values-of (method)
(setf values-of) (method)
values-of (method)
(setf values-of) (method)
(setf values-of) (generic function)
variable-name-of (generic function)
variable-name-of (method)
(setf variable-name-of) (method)
(setf variable-name-of) (generic function)
vector-extend (function)
wait-p (generic function)
wait-p (method)
(setf wait-p) (method)
wait-p (method)
(setf wait-p) (method)
(setf wait-p) (generic function)
when-of (generic function)
when-of (method)
(setf when-of) (method)
(setf when-of) (generic function)
where-of (generic function)
where-of (method)
(setf where-of) (method)
where-of (method)
(setf where-of) (method)
where-of (method)
(setf where-of) (method)
(setf where-of) (generic function)
whole-form-of (generic function)
whole-form-of (method)
(setf whole-form-of) (method)
(setf whole-form-of) (generic function)
with-cache (macro)

6 Definitions

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

6.1 Exported definitions

6.1.1 Constants

Constant: +database-command-line-options+

Package: hu.dwim.rdbms
Source: database.lisp (file)

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)

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)

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)

6.1.5 Generic functions

Generic Function: begin-transaction DATABASE TRANSACTION

Extension point for with-transaction and begin.

Package

Source

Methods

Method: begin-transaction DATABASE TRANSACTION

Generic Function: call-in-transaction DATABASE TRANSACTION FUNCTION

Extension point for with-transaction macro.

Package

Source

Methods

Method: call-in-transaction DATABASE TRANSACTION FUNCTION

Generic Function: cleanup-transaction TRANSACTION

Extension point with-transaction and commit/rollback.

Package

Source

Methods

Method: cleanup-transaction TRANSACTION

Generic Function: column-count CURSOR

Package

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

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

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

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

Source

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

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

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

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

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

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

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

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

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

Source

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

Source

Methods

Method: notify-transaction-event TRANSACTION EVENT

Generic Function: register-hook-in-transaction TRANSACTION WHEN ACTION FUNCTION

Package

Source

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

Source

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

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

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

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

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)

6.1.6 Conditions

Condition: deadlock-detected-error ()

Package

Source

Direct superclasses

simple-rdbms-error (condition)
translated-rdbms-error (condition)

Condition: rdbms-error ()

Package

Source

Direct superclasses

condition (condition)

Direct subclasses

translated-rdbms-error (condition)
simple-rdbms-error (condition)
unbound-binding-variable-error (condition)

Condition: simple-rdbms-error ()

Package

Source

Direct superclasses

rdbms-error (condition)
simple-error (condition)

Direct subclasses

unable-to-obtain-lock-error (condition)
deadlock-detected-error (condition)
transaction-error (condition)

Condition: unable-to-obtain-lock-error ()

Package

Source

Direct superclasses

simple-rdbms-error (condition)
translated-rdbms-error (condition)

Condition: unbound-binding-variable-error ()

Package

Source

syntax.lisp (file)

Direct superclasses

rdbms-error (condition)

Direct methods

variable-name-of (method)
variable-name-of (method)

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

Source

Direct superclasses

unconfirmed-schema-change (condition)

Direct subclasses

unconfirmed-destructive-schema-change/alter-column-type (condition)
unconfirmed-destructive-schema-change/drop-column (condition)

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

Package

Source

Direct superclasses

unconfirmed-destructive-schema-change (condition)

Direct methods

new-rdbms-type-of (method)
new-rdbms-type-of (method)
new-type-of (method)
new-type-of (method)
old-type-of (method)
old-type-of (method)

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

Source

Direct superclasses

serious-condition (condition)

Direct subclasses

unconfirmed-schema-change/add-column (condition)
unconfirmed-schema-change/create-table (condition)
unconfirmed-schema-change/add-foreign-key (condition)
unconfirmed-schema-change/drop-foreign-key (condition)
unconfirmed-schema-change/replace-foreign-key (condition)
unconfirmed-destructive-schema-change (condition)

Direct methods

column-name-of (method)
column-name-of (method)
table-name-of (method)
table-name-of (method)

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

Source

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods

column-type-of (method)
column-type-of (method)

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

Source

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods

constraint-name-of (method)
constraint-name-of (method)

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

Source

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods

constraint-name-of (method)
constraint-name-of (method)

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

Source

Direct superclasses

unconfirmed-schema-change (condition)

Direct methods

constraint-name-of (method)
constraint-name-of (method)

Direct slots

Slot: constraint-name

Initargs: :constraint-name
Readers: constraint-name-of (generic function)
Writers: (setf constraint-name-of) (generic function)

6.1.7 Classes

Class: database ()

Package

Source

database.lisp (file)

Direct superclasses

standard-object (class)

Direct methods

calculate-rdbms-name (method)
shared-initialize (method)
ddl-query-cache-of (method)
ddl-query-cache-of (method)
encoding-of (method)
encoding-of (method)
transaction-class-of (method)
transaction-class-of (method)
default-result-type-of (method)
default-result-type-of (method)
connection-specification-of (method)
connection-specification-of (method)

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

Source

ddl.lisp (file)

Direct superclasses

standard-object (class)

Direct methods

print-object (method)
delete-rule-of (method)
delete-rule-of (method)
update-rule-of (method)
update-rule-of (method)
target-column-of (method)
target-column-of (method)
target-table-of (method)
target-table-of (method)
source-column-of (method)
source-column-of (method)
source-table-of (method)
source-table-of (method)
name-of (method)
name-of (method)

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

Source

alter-table.lisp (file)

Direct superclasses

sql-add-constraint-action (class)

Direct methods

format-sql-syntax-node (method)
print-object (method)
update-rule-of (method)
update-rule-of (method)
delete-rule-of (method)
delete-rule-of (method)
target-table-of (method)
target-table-of (method)
target-columns-of (method)
target-columns-of (method)
source-columns-of (method)
source-columns-of (method)

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

Source

index.lisp (file)

Direct superclasses

sql-index (class)
sql-ddl-statement (class)

Direct methods

format-sql-syntax-node (method)
print-object (method)

Class: sql-create-table ()

An SQL CREATE TABLE statement.

Package

Source

create-table.lisp (file)

Direct superclasses

sql-ddl-statement (class)

Direct subclasses

sql-create-view (class)

Direct methods

format-sql-syntax-node (method)
print-object (method)
as-of (method)
as-of (method)
columns-of (method)
columns-of (method)
temporary-of (method)
temporary-of (method)
name-of (method)
name-of (method)

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

Source

create-table.lisp (file)

Direct superclasses

sql-create-table (class)

Direct methods

format-sql-syntax-node (method)
print-object (method)
replace-p (method)
replace-p (method)

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

Source

alter-table.lisp (file)

Direct superclasses

sql-syntax-node (class)

Direct methods

format-sql-syntax-node (method)
print-object (method)
name-of (method)
name-of (method)

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

Source

constraint.lisp (file)

Direct superclasses

sql-constraint-with-tablespace (class)

Direct methods

constraint-to-action (method)
format-sql-syntax-node (method)
print-object (method)
update-rule-of (method)
update-rule-of (method)
delete-rule-of (method)
delete-rule-of (method)
target-column-of (method)
target-column-of (method)
target-table-of (method)
target-table-of (method)

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

Source

Direct superclasses

standard-object (class)

Direct methods

make-cursor (method)
(setf terminal-action-of) (method)
print-object (method)
break-on-next-command-p (method)
break-on-next-command-p (method)
terminal-action-of (method)
terminal-action-of (method)
state-of (method)
state-of (method)
begin-was-executed-p (method)
begin-was-executed-p (method)
command-counter-of (method)
command-counter-of (method)
timestamp-of (method)
timestamp-of (method)
default-result-type-of (method)
default-result-type-of (method)
database-of (method)
database-of (method)

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

Source

Direct superclasses

standard-object (class)

Direct methods

register-hook-in-transaction (method)
rollback-transaction (method)
commit-transaction (method)
hooks-of (method)
hooks-of (method)

Direct slots

Slot: hooks

Type: list
Initargs: :hooks
Readers: hooks-of (generic function)
Writers: (setf hooks-of) (generic function)

6.2 Internal definitions

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)

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)

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)

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)

6.2.5 Generic functions

Generic Function: absolute-cursor-position CURSOR

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

Package

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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