X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-fdml.xml;h=ca725bdd492e25973f4169adadabcb56f9f57bd1;hb=4413405fd38eaba7ba6d6d8b844fef118e326c9a;hp=2908175042d8c71a5f54cb07c8c6df0a32192ff2;hpb=8a13e05588cb35ffeed91cca2dc26c313e387d70;p=clsql.git
diff --git a/doc/ref-fdml.xml b/doc/ref-fdml.xml
index 2908175..ca725bd 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,22 @@
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 +272,7 @@
UPDATE-RECORDS
- FunctionUPDATE-RECORDS
+ UPDATE-RECORDSUpdates the values of existing records.Function
@@ -551,7 +432,7 @@
DELETE-RECORDS
- FunctionDELETE-RECORDS
+ DELETE-RECORDSDelete records from a database table.Function
@@ -665,7 +546,7 @@
EXECUTE-COMMAND
- Generic FunctionEXECUTE-COMMAND
+ EXECUTE-COMMANDExecute an SQL command which returns no values.Generic Function
@@ -769,7 +650,7 @@
QUERY
- Generic FunctionQUERY
+ QUERYExecute an SQL query and return the tuples as a
list.Generic Function
@@ -973,7 +854,7 @@
PRINT-QUERY
- FunctionPRINT-QUERY
+ PRINT-QUERYPrints a tabular report of query results.Function
@@ -1129,7 +1010,7 @@ ID FORENAME SURNAME EMAIL
SELECT
- FunctionSELECT
+ SELECTExecutes a query given the supplied constraints.Function
@@ -1444,10 +1325,8 @@ ID FORENAME SURNAME EMAIL
Side Effects
- Whatever effects the execution of the SQL query has on
the underlying database, if any.
- Affected by
@@ -1506,7 +1385,7 @@ ID FORENAME SURNAME EMAIL
DO-QUERY
- MacroDO-QUERY
+ DO-QUERYIterate over all the tuples of a query.Macro
@@ -1687,9 +1566,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