X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-syntax.xml;h=e0364fabd825483540f4d323de1c210d69a019dc;hb=b50166ae0ba2bc09a9094c0e675ec92010b7293e;hp=c83cab344d41ad08852dfb922f4db23adba092a7;hpb=f7a356bb4c11d062eeeb5d4aaf4e187a3cb15a27;p=clsql.git diff --git a/doc/ref-syntax.xml b/doc/ref-syntax.xml index c83cab3..e0364fa 100644 --- a/doc/ref-syntax.xml +++ b/doc/ref-syntax.xml @@ -16,6 +16,12 @@ utilities for enabling and disabling the square bracket reader syntax and for constructing symbolic SQL expressions. + + Tip: just want it on + + file-enable-sql-reader-syntax at the top of each file is easiest. + + @@ -23,7 +29,7 @@ ENABLE-SQL-READER-SYNTAX - Macro ENABLE-SQL-READER-SYNTAX + ENABLE-SQL-READER-SYNTAX Globally enable square bracket reader syntax. Macro @@ -57,6 +63,12 @@ Modifies the default readtable. + + + &clsql; tries to keep track of whether the syntax has already been enabled. This can be problematic if the syntax is somehow disabled externally to &clsql; as future attempts to enable the syntax will do nothing--the system thinks it is already enabled. This may happen if there is an enable, but no disable, in a file that is processed with load or compile-file as the lisp implementation will restore the readtable on completion. Or, even if there is a disable but a compiler-error is encountered before running the disable. If you encounter this try running disable-sql-reader-syntax a couple times in the REPL. + + See file-enable-sql-reader-syntax for an alternative. + Affected by @@ -77,6 +89,7 @@ locally-enable-sql-reader-syntax locally-disable-sql-reader-syntax restore-sql-reader-syntax-state + file-enable-sql-reader-syntax @@ -97,7 +110,7 @@ DISABLE-SQL-READER-SYNTAX - Macro DISABLE-SQL-READER-SYNTAX + DISABLE-SQL-READER-SYNTAX Globally disable square bracket reader syntax. Macro @@ -151,6 +164,7 @@ locally-enable-sql-reader-syntax locally-disable-sql-reader-syntax restore-sql-reader-syntax-state + file-enable-sql-reader-syntax @@ -171,8 +185,8 @@ LOCALLY-ENABLE-SQL-READER-SYNTAX - Macro LOCALLY-ENABLE-SQL-READER-SYNTAX - Globally enable square bracket reader syntax. + LOCALLY-ENABLE-SQL-READER-SYNTAX + Locally enable square bracket reader syntax. Macro @@ -210,6 +224,12 @@ Modifies the default readtable. + + + &clsql; tries to keep track of whether the syntax has already been enabled. This can be problematic if the syntax is somehow disabled externally to &clsql; as future attempts to enable the syntax will do nothing--the system thinks it is already enabled. This may happen if there is an enable, but no disable, in a file that is processed with load or compile-file as the lisp implementation will restore the readtable on completion. Or, even if there is a disable but a compiler-error is encountered before running the disable. If you encounter this try running disable-sql-reader-syntax a couple times in the REPL. + + See file-enable-sql-reader-syntax for an alternative. + Affected by @@ -228,6 +248,7 @@ disable-sql-reader-syntax locally-disable-sql-reader-syntax restore-sql-reader-syntax-state + file-enable-sql-reader-syntax @@ -249,7 +270,7 @@ LOCALLY-DISABLE-SQL-READER-SYNTAX - Macro LOCALLY-DISABLE-SQL-READER-SYNTAX + LOCALLY-DISABLE-SQL-READER-SYNTAX Locally disable square bracket reader syntax. Macro @@ -310,6 +331,7 @@ disable-sql-reader-syntax locally-enable-sql-reader-syntax restore-sql-reader-syntax-state + file-enable-sql-reader-syntax @@ -330,7 +352,7 @@ RESTORE-SQL-READER-SYNTAX-STATE - Macro RESTORE-SQL-READER-SYNTAX-STATE + RESTORE-SQL-READER-SYNTAX-STATE Restore square bracket reader syntax to its previous state. @@ -394,6 +416,7 @@ disable-sql-reader-syntax locally-enable-sql-reader-syntax locally-disable-sql-reader-syntax + file-enable-sql-reader-syntax @@ -409,12 +432,86 @@ + + + FILE-ENABLE-SQL-READER-SYNTAX + + + FILE-ENABLE-SQL-READER-SYNTAX + + Enable the square bracket reader syntax for the duration of the file. + + Macro + + + Syntax + + file-enable-sql-reader-syntax => + + + Arguments and Values + None. + + + Description + Uncoditionally enables the SQL reader syntax. Unlike + enable-sql-reader-syntax and + disable-sql-reader-syntax which try to keep track of whether + the syntax has been enabled or disabled and keep track of the old read-table for restoration this function just enables it unconditionally. + + Once enabled this way there is no corresponding disable function but instead relies on being used in a file context. The spec for load and compile-file states that the *readtable* will be restored after processing the file. + + + Examples + Intended to be used at the top of a file that contains sql reader syntax. + + (in-package :my-package) + (clsql:file-enable-sql-reader-syntax) + ... + ;;functions that use the square bracket syntax. + + + + Side Effects + + Modifies the readtable for #\[ and #\] + + + + Affected by + None. + + + Exceptional Situations + + None. + + + + See Also + + enable-sql-reader-syntax + disable-sql-reader-syntax + locally-enable-sql-reader-syntax + locally-disable-sql-reader-syntax + + + + Notes + + Unique to &clsql;, not present in &commonsql;. + + + + SQL - Function SQL + SQL Construct an SQL string from supplied expressions. Function @@ -513,7 +610,7 @@ SQL-EXPRESSION - Function SQL-EXPRESSION + SQL-EXPRESSION Constructs an SQL expression from supplied keyword arguments. Function @@ -671,7 +768,7 @@ SQL-OPERATION - Function SQL-OPERATION + SQL-OPERATION Constructs an SQL expression from a supplied operator and arguments. Function @@ -775,7 +872,7 @@ SQL-OPERATOR - Function SQL-OPERATOR + SQL-OPERATOR Returns the symbol for the supplied SQL operator. Function @@ -847,80 +944,73 @@ - any - , - some - , - all - , - not - , - union - , - intersect - , - minus - , + any + some + all + not + union + intersect + minus except - , + order-by - , + null - , + * - , + + - , + / - , + - - , + like - , + and - , + or - , + in - , + substr - , + || - , + = - , + < - , + > - , + >= - , + <= - , + <> - , + count - , + max - , + min - , + avg - , + sum - , + function - , + between - , + distinct - , + nvl - , + slot-value - , + userenv - , + as well as the pseudo-operator function. @@ -930,30 +1020,30 @@ concat - , + substring - , + limit - , + group-by - , + having - , + not-null - , + exists - , + uplike - , + is - , + == - , + the - , + coalesce - , - view-class. + + view-class