X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-fdml.xml;h=e86dd36219fd90043c2930893b0776ac45f5115b;hb=5edc92aee527621ed13245b5b7892e40c2cd443f;hp=2908175042d8c71a5f54cb07c8c6df0a32192ff2;hpb=8a13e05588cb35ffeed91cca2dc26c313e387d70;p=clsql.git
diff --git a/doc/ref-fdml.xml b/doc/ref-fdml.xml
index 2908175..e86dd36 100644
--- a/doc/ref-fdml.xml
+++ b/doc/ref-fdml.xml
@@ -37,7 +37,7 @@
*CACHE-TABLE-QUERIES-DEFAULT*
- Variable*CACHE-TABLE-QUERIES-DEFAULT*
+ *CACHE-TABLE-QUERIES-DEFAULT*Specifies the default behaviour for caching of
attribute types.Variable
@@ -94,141 +94,17 @@
CACHE-TABLE-QUERIES
- FunctionCACHE-TABLE-QUERIES
- Controls the caching of attribute type information for a database table.
- Function
+ CACHE-TABLE-QUERIES
+ Control the caching of table attribute types.
-
- Syntax
-
- cache-table-queriestable &key actiondatabase) =>
-
-
- Arguments and Values
-
-
- table
-
-
- A string representing a database table, &t; or
- :default.
-
-
-
-
- action
-
-
- &t;, &nil; or :flush.
-
-
-
-
- database
-
- A
- database
- object. This will default to the value
- of *default-database*.
-
-
-
-
-
- Description
- Controls the caching of attribute type information on the
- table specified by table in
- database which defaults to
- *default-database*. action
- specifies the caching behaviour to adopt. If its value is &t;
- then attribute type information is cached whereas if its value
- is &nil; then attribute type information is not cached. If
- action is :flush then
- all existing type information in the cache for
- table is removed, but caching is still
- enabled. table may be a string
- representing a table for which the caching action is to be taken
- while the caching action is applied to all tables if
- table is &t;. Alternatively, when
- table is :default, the
- default caching action specified by
- *cache-table-queries-default* is applied to all
- tables for which a caching action has not been explicitly set.
-
-
-
- Examples
-
-(setf *cache-table-queries-default* t)
-=> T
-(create-table [foo]
- '(([id] integer)
- ([height] float)
- ([name] (string 24))
- ([comments] varchar)))
-=>
-(cache-table-queries "foo")
-=>
-(list-attribute-types "foo")
-=> (("id" :INT4 4 NIL 1) ("height" :FLOAT8 8 NIL 1) ("name" :BPCHAR 24 NIL 1)
- ("comments" :VARCHAR 255 NIL 1))
-(drop-table "foo")
-=>
-(create-table [foo]
- '(([id] integer)
- ([height] float)
- ([name] (string 36))
- ([comments] (string 100))))
-=>
-(cache-table-queries "foo" :action :flush)
-=>
-(list-attribute-types "foo")
-=> (("id" :INT4 4 NIL 1) ("height" :FLOAT8 8 NIL 1) ("name" :BPCHAR 36 NIL 1)
- ("comments" :BPCHAR 100 NIL 1))
-
-
-
- Side Effects
-
- The internal attribute cache for
- database is modified.
-
-
-
- Affected by
-
- *cache-table-queries-default*
-
-
-
- Exceptional Situations
-
- None.
-
-
-
- See Also
-
- *cache-table-queries-default*
-
-
-
- Notes
-
- None.
-
-
-
-
-
INSERT-RECORDS
- FunctionINSERT-RECORDS
+ INSERT-RECORDSInsert tuples of data into a database table.Function
@@ -391,7 +267,7 @@
UPDATE-RECORDS
- FunctionUPDATE-RECORDS
+ UPDATE-RECORDSUpdates the values of existing records.Function
@@ -551,7 +427,7 @@
DELETE-RECORDS
- FunctionDELETE-RECORDS
+ DELETE-RECORDSDelete records from a database table.Function
@@ -665,7 +541,7 @@
EXECUTE-COMMAND
- Generic FunctionEXECUTE-COMMAND
+ EXECUTE-COMMANDExecute an SQL command which returns no values.Generic Function
@@ -769,7 +645,7 @@
QUERY
- Generic FunctionQUERY
+ QUERYExecute an SQL query and return the tuples as a
list.Generic Function
@@ -973,7 +849,7 @@
PRINT-QUERY
- FunctionPRINT-QUERY
+ PRINT-QUERYPrints a tabular report of query results.Function
@@ -1129,7 +1005,7 @@ ID FORENAME SURNAME EMAIL
SELECT
- FunctionSELECT
+ SELECTExecutes a query given the supplied constraints.Function
@@ -1506,7 +1382,7 @@ ID FORENAME SURNAME EMAIL
DO-QUERY
- MacroDO-QUERY
+ DO-QUERYIterate over all the tuples of a query.Macro
@@ -1687,9 +1563,10 @@ ID FORENAME SURNAME EMAIL
LOOP
- Additional clause for LOOP
- Iterate over all the tuples of a
- query via a loop clause.
+ LOOP
+ Extension to Common Lisp
+ Loop to iterate over all the
+ tuples of a query via a loop clause.Loop Clause