r9457: Reworked CLSQL file structure.

[clsql.git] / doc / TODO

diff --git a/doc/TODO b/doc/TODO
index b288ef093b13418e081885f84bccbcafe88cccd8..4132cf6f66ba1438f02920d28425512bdd27b000 100644 (file)
--- a/doc/TODO
+++ b/doc/TODO
@@ -4,6 +4,8 @@ DOCUMENTATION TO DO LIST
 
  - Ideally, this will be extremely minimal
 
 
  - Ideally, this will be extremely minimal
 

+ - The SQL syntax state functions are macros in CLSQL. 
+

 2. Underdocumented CommonSQL features:
 
  - Retrieval immediate
 2. Underdocumented CommonSQL features:
 
  - Retrieval immediate


@@ -11,7 +13,8 @@ DOCUMENTATION TO DO LIST
 
 2. CLSQL extensions to CommonSQL
 
 
 2. CLSQL extensions to CommonSQL
 

- - RESULT-TYPES, FIELD-NAMES keywords for SELECT and QUERY
+ - RESULT-TYPES, FIELD-NAMES keywords for SELECT, QUERY, DO-QUERY and 
+   MAP-QUERY. 

 
  - New types such as wall-time, boolean, and bigint
 
 
  - New types such as wall-time, boolean, and bigint
 


@@ -23,16 +26,41 @@ DOCUMENTATION TO DO LIST
    index-exists-p, create-sequence, drop-sequence, list-sequences,
    sequence-exists-p, sequence-next, sequence-last, set-sequence-position
 
    index-exists-p, create-sequence, drop-sequence, list-sequences,
    sequence-exists-p, sequence-next, sequence-last, set-sequence-position
 

+ - FDML: TRUNCATE-DATABASE, DESCRIBE-TABLE, FOR-EACH-ROW and large object 
+   support. 
+

  - OODML: *db-auto-sync*
 
  - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, 
    :INNER-JOIN and :ON. 
 
  - OODML: *db-auto-sync*
 
  - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, 
    :INNER-JOIN and :ON. 
 

+ - SQL-RECORDING-P: also accepts :both and :either values for the TYPE 
+   parameter. 
+
+ - DROP-TABLE/DROP-VIEW/DROP-INDEX: keyword arg :if-does-not-exist. 
+
+ - DROP-INDEX: keyword arg :on (for MySQL). 
+
+ - DEF-VIEW-CLASS: DB-CONSTRAINTS, DB-TYPE and VOID-VALUE slot options. 
+
+ - CREATE-TABLE: keyword args :TRANSACTIONS (for MySQL) and :CONSTRAINTS;  
+                 description arg accepts optional DB-TYPE string. 
+
+ - transactions: START-TRANSACTION and IN-TRANSACTION-P. 
+
+ - FIND-DATABASE: :db-type keyword arg. 
+
+ - CONNECT: :make-default and :pool keyword args. 
+
+

 4. Documenting lower level, non-CommonSQL functions (some of this is already 
    done). 
 
  - connection pools
  - database-query-result-set 
 4. Documenting lower level, non-CommonSQL functions (some of this is already 
    done). 
 
  - connection pools
  - database-query-result-set 

+ - with-default-database, with-database, create-database, probe-database, 
+   destroy-database, list-databases. 
+ 

 
 5. Notes on any peculiarities of each of the backends (e.g., unsupported 
    features, notable extensions etc.). 
 
 5. Notes on any peculiarities of each of the backends (e.g., unsupported 
    features, notable extensions etc.). 


@@ -44,6 +72,8 @@ DOCUMENTATION TO DO LIST
    queries:      nested subqueries are not supported
    syntax:       doesn't support the sql concatenation operator (||). 
                  doesn't support INTERSECT/EXCEPT set operations. 
    queries:      nested subqueries are not supported
    syntax:       doesn't support the sql concatenation operator (||). 
                  doesn't support INTERSECT/EXCEPT set operations. 

+   create-table: the transactions keyword arg controls whether the created 
+                 table is an InnoDB table (supporting transactions) or not. 

 
  - SQLITE 
 
 
  - SQLITE