The clsql-orm Reference Manual

Table of Contents

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

The clsql-orm Reference Manual

This is the clsql-orm Reference Manual, version 0.2.1, generated automatically by Declt version 2.4 "Will Decker" on Wed Jun 20 11:35:30 2018 GMT+0.


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

1 Introduction

CLSQL-PG-INTROSPECT
-------------------

Use this package to help with introspective operations on Postgres
databases.

Some small examples of some basic operations follow.

(gen-view-class music)

Would take the music table and define a clsql class based upon it.
This currently includes designating primary keys, not-null
constraints, unique constraints, and joins on foreign tables.

(gen-view-class musicians :classname music-people)

Defines a class MUSIC-PEOPLE based on table musicians. This is best to
avoid if you can, as then autogenerated foreign relations won't work.

(gen-view-class music :generate-joins nil)

Defines class MUSIC, but without the joins.

By default, accessors are generated, named after the columns. To turn this
off, pass :generate-accessors nil to gen-view-class.

Accessors/slots for joins are named [home key]-[target table]

Besides this main utility, there are functions for:
- determining if a column has any of the following restrictions:
  + not-null (not-null-p)
  + unique (unique-p)
  + is a primary key (primary-key-p)
- listing all foreign constraints of a table (list-foreign-constraints)
- listing all user columns of a table and their type (user-columns)
- figuring out a clsql type given a PostgreSQL type (clsql-type-for-pg-type)


Most of the functionality is wrapped up in one simple macro:
(defmacro gen-view-classes-for-database ((connection-spec database-type &key (generate-joins t) (generate-accessors t)) &rest classes)

That'll do it for you.

Of course, database-type has to be :postgresql. The option is in for...forwards compatibility?

Bug reports and patches gladly accepted.

Thanks,
Alan Shields
Alan-Shields@omrf.ouhsc.edu

This work was made possible by the Centola Lab of the Oklahoma Medical
Research Foundation

License information is in the file LICENSE


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

2 Systems

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


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

2.1 clsql-orm

Version

0.2.1

Dependencies
Source

clsql-orm.asd (file)

Components

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

3 Files

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


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

3.1 Lisp


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

3.1.1 clsql-orm.asd

Location

clsql-orm.asd

Systems

clsql-orm (system)

Packages

clsql-orm.system


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

3.1.2 clsql-orm/package.lisp

Parent

clsql-orm (system)

Location

package.lisp

Packages

clsql-orm


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

3.1.3 clsql-orm/sqlite3.lisp

Dependency

package.lisp (file)

Parent

clsql-orm (system)

Location

sqlite3.lisp

Internal Definitions

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

3.1.4 clsql-orm/mysql.lisp

Dependency

sqlite3.lisp (file)

Parent

clsql-orm (system)

Location

mysql.lisp

Internal Definitions

mysql-list-columns-sql (function)


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

3.1.5 clsql-orm/main.lisp

Dependency

mysql.lisp (file)

Parent

clsql-orm (system)

Location

main.lisp

Exported Definitions
Internal Definitions

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

4 Packages

Packages are listed by definition order.


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

4.1 clsql-orm.system

Source

clsql-orm.asd

Use List

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

4.2 clsql-orm

This package provides methods to introspect a database
Providing features such as generating a CLSQL class based on a table name

Source

package.lisp (file)

Use List
Exported Definitions
Internal Definitions

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

5 Definitions

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


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

5.1 Exported definitions


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

5.1.1 Functions

Function: col-spec-eql C1 C2
Package

clsql-orm

Source

main.lisp (file)

Function: col= C1 C2
Package

clsql-orm

Source

main.lisp (file)

Function: column-def SCHEMA TABLE COLUMN DB-TYPE COL-LENGTH SCALE IS-NULL DEFAULT CONSTRAINTS FKEY-SCHEMA FKEY-TABLE FKEY-COL
Package

clsql-orm

Source

main.lisp (file)

Function: column-diff TABLE-1 TABLE-2 &key SCHEMA-1 SCHEMA-2
Package

clsql-orm

Source

main.lisp (file)

Function: column-name= C1 C2
Package

clsql-orm

Source

main.lisp (file)

Function: gen-view-class TABLE &key CLASSNAME IS-VIEW GENERATE-JOINS GENERATE-REVERSE-JOINS GENERATE-ACCESSORS INHERITS-FROM VIEW-INHERITS-FROM PACKAGE NICKNAMES SINGULARIZE SCHEMA METACLASS SLOTS EXPORT-SYMBOLS PRINT?

Generate a view class for clsql, given a table
If you want to name the class differently from the table, use the :classname keyword.
If you do not want to generate join information for the class, do :generate-joins nil
Note: if you specify a classname, join generation to this table won’t work properly, as it depends on table names and class names being the same.

The join slots/accessors will be named [home key]-[target table]. If you want to have your own naming conventions, it’s best to define a class that inherits from your generated class.

Package

clsql-orm

Source

main.lisp (file)

Function: gen-view-classes &key CLASSES EXCLUDES GENERATE-JOINS GENERATE-REVERSE-JOINS GENERATE-ACCESSORS SCHEMA PACKAGE EXPORT-SYMBOLS NICKNAMES SINGULARIZE INHERITS-FROM VIEW-INHERITS-FROM METACLASS

This is the function most people will use to generate table classes. It uses gen-view-class.

This function will operate on the default clsql database

Package

clsql-orm

Source

main.lisp (file)

Function: list-columns TABLE &optional SCHEMA
Package

clsql-orm

Source

main.lisp (file)

Function: list-tables &optional SCHEMA
Package

clsql-orm

Source

main.lisp (file)


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

5.1.2 Generic functions

Generic Function: clsql-join-definition HOME-TABLE HOME-KEY FOREIGN-TABLE FOREIGN-KEY &key GENERATE-ACCESSORS

Creates the definition for the joins. Note that this does not handle multi-column foreign keys at the moment. For that matter, if you wish to have custom names and the like, you’d best define an inheriting class

Package

clsql-orm

Source

main.lisp (file)

Methods
Method: clsql-join-definition HOME-TABLE HOME-KEY FOREIGN-TABLE FOREIGN-KEY &key GENERATE-ACCESSORS
Method: clsql-join-definition (HOME-TABLE symbol) (HOME-KEY symbol) (FOREIGN-TABLE symbol) (FOREIGN-KEY symbol) &key GENERATE-ACCESSORS
Generic Function: col-length OBJECT
Generic Function: (setf col-length) NEW-VALUE OBJECT
Package

clsql-orm

Methods
Method: col-length (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf col-length) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: column (CONDITION nullable-column-with-default)
Method: (setf column) NEW-VALUE (CONDITION nullable-column-with-default)
Source

main.lisp (file)

Method: column (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf column) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

Generic Function: db-type OBJECT
Generic Function: (setf db-type) NEW-VALUE OBJECT
Package

clsql-orm

Methods
Method: db-type (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf db-type) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

Generic Function: is-null OBJECT
Generic Function: (setf is-null) NEW-VALUE OBJECT
Package

clsql-orm

Methods
Method: is-null (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf is-null) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: scale (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf scale) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: spec-type (COLUMN-DEF column-def)
Method: (setf spec-type) NEW-VALUE (COLUMN-DEF column-def)

the original database type rather than its clsql/lisp keyword

Source

main.lisp (file)


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

5.1.3 Classes

Class: column-def ()
Package

clsql-orm

Source

main.lisp (file)

Direct superclasses

standard-object (class)

Direct methods
Direct slots
Slot: schema
Initargs

:schema

Initform

clsql-orm::*schema*

Readers

schema (generic function)

Writers

(setf schema) (generic function)

Slot: table
Initargs

:table

Readers

table (generic function)

Writers

(setf table) (generic function)

Slot: column
Initargs

:column

Readers

column (generic function)

Writers

(setf column) (generic function)

Slot: db-type
Initargs

:db-type

Readers

db-type (generic function)

Writers

(setf db-type) (generic function)

Slot: spec-type

the original database type rather than its clsql/lisp keyword

Initargs

:spec-type

Readers

spec-type (generic function)

Writers

(setf spec-type) (generic function)

Slot: col-length
Initargs

:col-length

Readers

col-length (generic function)

Writers

(setf col-length) (generic function)

Slot: scale
Initargs

:scale

Readers

scale (generic function)

Writers

(setf scale) (generic function)

Slot: is-null
Initargs

:is-null

Readers

is-null (generic function)

Writers

(setf is-null) (generic function)

Slot: default
Initargs

:default

Readers

default (generic function)

Writers

(setf default) (generic function)

Slot: constraints
Initargs

:constraints

Readers

constraints (generic function)

Writers

(setf constraints) (generic function)

Slot: fkey-schema
Initargs

:fkey-schema

Readers

fkey-schema (generic function)

Writers

(setf fkey-schema) (generic function)

Slot: fkey-table
Initargs

:fkey-table

Readers

fkey-table (generic function)

Writers

(setf fkey-table) (generic function)

Slot: fkey-col
Initargs

:fkey-col

Readers

fkey-col (generic function)

Writers

(setf fkey-col) (generic function)


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

5.2 Internal definitions


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

5.2.1 Special variables

Special Variable: *db-model-package*
Package

clsql-orm

Source

main.lisp (file)

Special Variable: *export-symbols*

Should we export every symbol we intern?

Package

clsql-orm

Source

main.lisp (file)

Special Variable: *schema*

The schema we are generating from

Package

clsql-orm

Source

main.lisp (file)

Special Variable: *singularize*

Should we try to singularize table names

Package

clsql-orm

Source

main.lisp (file)


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

5.2.2 Macros

Macro: awhen COND &body BODY
Package

clsql-orm

Source

main.lisp (file)

Macro: ensure-strings (&rest VARS) &body BODY
Package

clsql-orm

Source

main.lisp (file)


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

5.2.3 Functions

Function: %tables-to-generate CLASSES EXCLUDES SCHEMA
Package

clsql-orm

Source

main.lisp (file)

Function: accessor-name-for-column TABLE COLUMN
Package

clsql-orm

Source

main.lisp (file)

Function: clsql-column-definitions TABLE &key SCHEMA GENERATE-ACCESSORS GENERATE-JOINS

For each user column, find out if it’s a primary key, constrain it to not null if necessary, translate its type, and declare an initarg

Package

clsql-orm

Source

main.lisp (file)

Function: clsql-join-column-name TABLE REF-TABLE COLNAME
Package

clsql-orm

Source

main.lisp (file)

Function: clsql-reverse-join-definition COLUMN-DEF &key GENERATE-ACCESSORS
Package

clsql-orm

Source

main.lisp (file)

Function: clsql-reverse-join-definitions TABLE &key SCHEMA
Package

clsql-orm

Source

main.lisp (file)

Function: clsql-type-for-db-type DB-TYPE LEN

Given a postgres type and a modifier, return the clsql type

Package

clsql-orm

Source

main.lisp (file)

Function: default-list-columns TABLE &key SCHEMA REVERSE-JOINS?

Returns a list of
#(column type length is-null default (key-types) fkey-table fkey-col)
for the user columns of table.
Do not confuse a table with the clsql class of a table - this needs the actual table name.
User columns are those columns which the user defines. Others are defined for various reasons. OID is often one of these.

Package

clsql-orm

Source

main.lisp (file)

Function: default-list-columns-lesser-sql SCHEMA TABLE

A fallback sql for databases whose information_schema is lacking (previously mysql, but perhaps others)

Package

clsql-orm

Source

main.lisp (file)

Function: default-list-columns-sql SCHEMA TABLE REVERSE-JOINS? &aux WHERE ORDER
Package

clsql-orm

Source

main.lisp (file)

Function: ensure-list X
Package

clsql-orm

Source

main.lisp (file)

Function: identity-column-p TABLE COLUMN &aux COLNAME

a function that can determine if a key column is IDENTITY for sqlserver

Package

clsql-orm

Source

main.lisp (file)

Function: intern-normalize-for-lisp ME &optional PACKAGE

Interns a string after uppercasing and flipping underscores to hyphens

Package

clsql-orm

Source

main.lisp (file)

Function: internup ME &optional PACKAGE
Package

clsql-orm

Source

main.lisp (file)

Function: list-reverse-join-columns TABLE &key SCHEMA
Package

clsql-orm

Source

main.lisp (file)

Function: mysql-list-columns-sql SCHEMA TABLE REVERSE-JOINS? &aux WHERE ORDER
Package

clsql-orm

Source

mysql.lisp (file)

Function: normalize-for-sql S
Package

clsql-orm

Source

main.lisp (file)

Function: pg-sequence-name COL
Package

clsql-orm

Source

main.lisp (file)

Function: singular-intern-normalize-for-lisp ME &optional PACKAGE

Interns a string after uppercasing and flipping underscores to hyphens

Package

clsql-orm

Source

main.lisp (file)

Function: sqlite3-column-def TABLE COLUMN-NAME TYPE IS-NULL? DEFAULT PK?
Package

clsql-orm

Source

sqlite3.lisp (file)

Function: sqlite3-list-columns TABLE &optional SCHEMA
Package

clsql-orm

Source

sqlite3.lisp (file)

Function: sqlite3-list-tables &key SCHEMA OWNER
Package

clsql-orm

Source

sqlite3.lisp (file)

Function: type-of-db ()

Returns the underlying db type for the dynamic connection

Package

clsql-orm

Source

main.lisp (file)


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

5.2.4 Generic functions

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

clsql-orm

Methods
Method: constraints (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf constraints) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: default (CONDITION nullable-column-with-default)
Method: (setf default) NEW-VALUE (CONDITION nullable-column-with-default)
Source

main.lisp (file)

Method: default (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf default) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

Generic Function: fkey-col OBJECT
Generic Function: (setf fkey-col) NEW-VALUE OBJECT
Package

clsql-orm

Methods
Method: fkey-col (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf fkey-col) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

Generic Function: fkey-schema OBJECT
Generic Function: (setf fkey-schema) NEW-VALUE OBJECT
Package

clsql-orm

Methods
Method: fkey-schema (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf fkey-schema) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: fkey-table (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf fkey-table) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: schema (CONDITION nullable-column-with-default)
Method: (setf schema) NEW-VALUE (CONDITION nullable-column-with-default)
Source

main.lisp (file)

Method: schema (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf schema) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)

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

clsql-orm

Methods
Method: table (CONDITION nullable-column-with-default)
Method: (setf table) NEW-VALUE (CONDITION nullable-column-with-default)
Source

main.lisp (file)

Method: table (COLUMN-DEF column-def)

automatically generated reader method

Source

main.lisp (file)

Method: (setf table) NEW-VALUE (COLUMN-DEF column-def)

automatically generated writer method

Source

main.lisp (file)


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

5.2.5 Conditions

Condition: nullable-column-with-default ()
Package

clsql-orm

Source

main.lisp (file)

Direct superclasses

warning (condition)

Direct methods
  • default (method)
  • default (method)
  • column (method)
  • column (method)
  • table (method)
  • table (method)
  • schema (method)
  • schema (method)
Direct slots
Slot: schema
Initargs

:schema

Initform

(quote nil)

Readers

schema (generic function)

Writers

(setf schema) (generic function)

Slot: table
Initargs

:table

Initform

(quote nil)

Readers

table (generic function)

Writers

(setf table) (generic function)

Slot: column
Initargs

:column

Initform

(quote nil)

Readers

column (generic function)

Writers

(setf column) (generic function)

Slot: default
Initargs

:default

Initform

(quote nil)

Readers

default (generic function)

Writers

(setf default) (generic function)


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

Appendix A Indexes


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

A.1 Concepts

Jump to:   C   F   L  
Index Entry  Section

C
clsql-orm.asd: The clsql-orm<dot>asd file
clsql-orm/main.lisp: The clsql-orm/main<dot>lisp file
clsql-orm/mysql.lisp: The clsql-orm/mysql<dot>lisp file
clsql-orm/package.lisp: The clsql-orm/package<dot>lisp file
clsql-orm/sqlite3.lisp: The clsql-orm/sqlite3<dot>lisp file

F
File, Lisp, clsql-orm.asd: The clsql-orm<dot>asd file
File, Lisp, clsql-orm/main.lisp: The clsql-orm/main<dot>lisp file
File, Lisp, clsql-orm/mysql.lisp: The clsql-orm/mysql<dot>lisp file
File, Lisp, clsql-orm/package.lisp: The clsql-orm/package<dot>lisp file
File, Lisp, clsql-orm/sqlite3.lisp: The clsql-orm/sqlite3<dot>lisp file

L
Lisp File, clsql-orm.asd: The clsql-orm<dot>asd file
Lisp File, clsql-orm/main.lisp: The clsql-orm/main<dot>lisp file
Lisp File, clsql-orm/mysql.lisp: The clsql-orm/mysql<dot>lisp file
Lisp File, clsql-orm/package.lisp: The clsql-orm/package<dot>lisp file
Lisp File, clsql-orm/sqlite3.lisp: The clsql-orm/sqlite3<dot>lisp file

Jump to:   C   F   L  

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

A.2 Functions

Jump to:   %   (  
A   C   D   E   F   G   I   L   M   N   P   S   T  
Index Entry  Section

%
%tables-to-generate: Internal functions

(
(setf col-length): Exported generic functions
(setf col-length): Exported generic functions
(setf column): Exported generic functions
(setf column): Exported generic functions
(setf column): Exported generic functions
(setf constraints): Internal generic functions
(setf constraints): Internal generic functions
(setf db-type): Exported generic functions
(setf db-type): Exported generic functions
(setf default): Internal generic functions
(setf default): Internal generic functions
(setf default): Internal generic functions
(setf fkey-col): Internal generic functions
(setf fkey-col): Internal generic functions
(setf fkey-schema): Internal generic functions
(setf fkey-schema): Internal generic functions
(setf fkey-table): Internal generic functions
(setf fkey-table): Internal generic functions
(setf is-null): Exported generic functions
(setf is-null): Exported generic functions
(setf scale): Exported generic functions
(setf scale): Exported generic functions
(setf schema): Internal generic functions
(setf schema): Internal generic functions
(setf schema): Internal generic functions
(setf spec-type): Exported generic functions
(setf spec-type): Exported generic functions
(setf table): Internal generic functions
(setf table): Internal generic functions
(setf table): Internal generic functions

A
accessor-name-for-column: Internal functions
awhen: Internal macros

C
clsql-column-definitions: Internal functions
clsql-join-column-name: Internal functions
clsql-join-definition: Exported generic functions
clsql-join-definition: Exported generic functions
clsql-join-definition: Exported generic functions
clsql-reverse-join-definition: Internal functions
clsql-reverse-join-definitions: Internal functions
clsql-type-for-db-type: Internal functions
col-length: Exported generic functions
col-length: Exported generic functions
col-spec-eql: Exported functions
col=: Exported functions
column: Exported generic functions
column: Exported generic functions
column: Exported generic functions
column-def: Exported functions
column-diff: Exported functions
column-name=: Exported functions
constraints: Internal generic functions
constraints: Internal generic functions

D
db-type: Exported generic functions
db-type: Exported generic functions
default: Internal generic functions
default: Internal generic functions
default: Internal generic functions
default-list-columns: Internal functions
default-list-columns-lesser-sql: Internal functions
default-list-columns-sql: Internal functions

E
ensure-list: Internal functions
ensure-strings: Internal macros

F
fkey-col: Internal generic functions
fkey-col: Internal generic functions
fkey-schema: Internal generic functions
fkey-schema: Internal generic functions
fkey-table: Internal generic functions
fkey-table: Internal generic functions
Function, %tables-to-generate: Internal functions
Function, accessor-name-for-column: Internal functions
Function, clsql-column-definitions: Internal functions
Function, clsql-join-column-name: Internal functions
Function, clsql-reverse-join-definition: Internal functions
Function, clsql-reverse-join-definitions: Internal functions
Function, clsql-type-for-db-type: Internal functions
Function, col-spec-eql: Exported functions
Function, col=: Exported functions
Function, column-def: Exported functions
Function, column-diff: Exported functions
Function, column-name=: Exported functions
Function, default-list-columns: Internal functions
Function, default-list-columns-lesser-sql: Internal functions
Function, default-list-columns-sql: Internal functions
Function, ensure-list: Internal functions
Function, gen-view-class: Exported functions
Function, gen-view-classes: Exported functions
Function, identity-column-p: Internal functions
Function, intern-normalize-for-lisp: Internal functions
Function, internup: Internal functions
Function, list-columns: Exported functions
Function, list-reverse-join-columns: Internal functions
Function, list-tables: Exported functions
Function, mysql-list-columns-sql: Internal functions
Function, normalize-for-sql: Internal functions
Function, pg-sequence-name: Internal functions
Function, singular-intern-normalize-for-lisp: Internal functions
Function, sqlite3-column-def: Internal functions
Function, sqlite3-list-columns: Internal functions
Function, sqlite3-list-tables: Internal functions
Function, type-of-db: Internal functions

G
gen-view-class: Exported functions
gen-view-classes: Exported functions
Generic Function, (setf col-length): Exported generic functions
Generic Function, (setf column): Exported generic functions
Generic Function, (setf constraints): Internal generic functions
Generic Function, (setf db-type): Exported generic functions
Generic Function, (setf default): Internal generic functions
Generic Function, (setf fkey-col): Internal generic functions
Generic Function, (setf fkey-schema): Internal generic functions
Generic Function, (setf fkey-table): Internal generic functions
Generic Function, (setf is-null): Exported generic functions
Generic Function, (setf scale): Exported generic functions
Generic Function, (setf schema): Internal generic functions
Generic Function, (setf spec-type): Exported generic functions
Generic Function, (setf table): Internal generic functions
Generic Function, clsql-join-definition: Exported generic functions
Generic Function, col-length: Exported generic functions
Generic Function, column: Exported generic functions
Generic Function, constraints: Internal generic functions
Generic Function, db-type: Exported generic functions
Generic Function, default: Internal generic functions
Generic Function, fkey-col: Internal generic functions
Generic Function, fkey-schema: Internal generic functions
Generic Function, fkey-table: Internal generic functions
Generic Function, is-null: Exported generic functions
Generic Function, scale: Exported generic functions
Generic Function, schema: Internal generic functions
Generic Function, spec-type: Exported generic functions
Generic Function, table: Internal generic functions

I
identity-column-p: Internal functions
intern-normalize-for-lisp: Internal functions
internup: Internal functions
is-null: Exported generic functions
is-null: Exported generic functions

L
list-columns: Exported functions
list-reverse-join-columns: Internal functions
list-tables: Exported functions

M
Macro, awhen: Internal macros
Macro, ensure-strings: Internal macros
Method, (setf col-length): Exported generic functions
Method, (setf column): Exported generic functions
Method, (setf column): Exported generic functions
Method, (setf constraints): Internal generic functions
Method, (setf db-type): Exported generic functions
Method, (setf default): Internal generic functions
Method, (setf default): Internal generic functions
Method, (setf fkey-col): Internal generic functions
Method, (setf fkey-schema): Internal generic functions
Method, (setf fkey-table): Internal generic functions
Method, (setf is-null): Exported generic functions
Method, (setf scale): Exported generic functions
Method, (setf schema): Internal generic functions
Method, (setf schema): Internal generic functions
Method, (setf spec-type): Exported generic functions
Method, (setf table): Internal generic functions
Method, (setf table): Internal generic functions
Method, clsql-join-definition: Exported generic functions
Method, clsql-join-definition: Exported generic functions
Method, col-length: Exported generic functions
Method, column: Exported generic functions
Method, column: Exported generic functions
Method, constraints: Internal generic functions
Method, db-type: Exported generic functions
Method, default: Internal generic functions
Method, default: Internal generic functions
Method, fkey-col: Internal generic functions
Method, fkey-schema: Internal generic functions
Method, fkey-table: Internal generic functions
Method, is-null: Exported generic functions
Method, scale: Exported generic functions
Method, schema: Internal generic functions
Method, schema: Internal generic functions
Method, spec-type: Exported generic functions
Method, table: Internal generic functions
Method, table: Internal generic functions
mysql-list-columns-sql: Internal functions

N
normalize-for-sql: Internal functions

P
pg-sequence-name: Internal functions

S
scale: Exported generic functions
scale: Exported generic functions
schema: Internal generic functions
schema: Internal generic functions
schema: Internal generic functions
singular-intern-normalize-for-lisp: Internal functions
spec-type: Exported generic functions
spec-type: Exported generic functions
sqlite3-column-def: Internal functions
sqlite3-list-columns: Internal functions
sqlite3-list-tables: Internal functions

T
table: Internal generic functions
table: Internal generic functions
table: Internal generic functions
type-of-db: Internal functions

Jump to:   %   (  
A   C   D   E   F   G   I   L   M   N   P   S   T  

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

A.3 Variables

Jump to:   *  
C   D   F   I   S   T  
Index Entry  Section

*
*db-model-package*: Internal special variables
*export-symbols*: Internal special variables
*schema*: Internal special variables
*singularize*: Internal special variables

C
col-length: Exported classes
column: Exported classes
column: Internal conditions
constraints: Exported classes

D
db-type: Exported classes
default: Exported classes
default: Internal conditions

F
fkey-col: Exported classes
fkey-schema: Exported classes
fkey-table: Exported classes

I
is-null: Exported classes

S
scale: Exported classes
schema: Exported classes
schema: Internal conditions
Slot, col-length: Exported classes
Slot, column: Exported classes
Slot, column: Internal conditions
Slot, constraints: Exported classes
Slot, db-type: Exported classes
Slot, default: Exported classes
Slot, default: Internal conditions
Slot, fkey-col: Exported classes
Slot, fkey-schema: Exported classes
Slot, fkey-table: Exported classes
Slot, is-null: Exported classes
Slot, scale: Exported classes
Slot, schema: Exported classes
Slot, schema: Internal conditions
Slot, spec-type: Exported classes
Slot, table: Exported classes
Slot, table: Internal conditions
spec-type: Exported classes
Special Variable, *db-model-package*: Internal special variables
Special Variable, *export-symbols*: Internal special variables
Special Variable, *schema*: Internal special variables
Special Variable, *singularize*: Internal special variables

T
table: Exported classes
table: Internal conditions

Jump to:   *  
C   D   F   I   S   T  

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

A.4 Data types

Jump to:   C   N   P   S  
Index Entry  Section

C
Class, column-def: Exported classes
clsql-orm: The clsql-orm system
clsql-orm: The clsql-orm package
clsql-orm.system: The clsql-orm<dot>system package
column-def: Exported classes
Condition, nullable-column-with-default: Internal conditions

N
nullable-column-with-default: Internal conditions

P
Package, clsql-orm: The clsql-orm package
Package, clsql-orm.system: The clsql-orm<dot>system package

S
System, clsql-orm: The clsql-orm system

Jump to:   C   N   P   S