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 - Function CACHE-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-queries table &key action database) => - - - 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 - Function INSERT-RECORDS + INSERT-RECORDS Insert tuples of data into a database table. Function @@ -391,7 +272,7 @@ UPDATE-RECORDS - Function UPDATE-RECORDS + UPDATE-RECORDS Updates the values of existing records. Function @@ -551,7 +432,7 @@ DELETE-RECORDS - Function DELETE-RECORDS + DELETE-RECORDS Delete records from a database table. Function @@ -665,7 +546,7 @@ EXECUTE-COMMAND - Generic Function EXECUTE-COMMAND + EXECUTE-COMMAND Execute an SQL command which returns no values. Generic Function @@ -769,7 +650,7 @@ QUERY - Generic Function QUERY + QUERY Execute an SQL query and return the tuples as a list. Generic Function @@ -973,7 +854,7 @@ PRINT-QUERY - Function PRINT-QUERY + PRINT-QUERY Prints a tabular report of query results. Function @@ -1129,7 +1010,7 @@ ID FORENAME SURNAME EMAIL SELECT - Function SELECT + SELECT Executes 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 - Macro DO-QUERY + DO-QUERY Iterate 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