r9803: Remove items done from TODO files.

diff --git a/README b/README
index a112f9d645af2ffe7df3b82094c5914b3fe26933..6fc8d7ac38bec8c77271f07aeef6241ffc9b581f 100644 (file)
--- a/README
+++ b/README
@@ -12,7 +12,7 @@ UncommonSQL developed at onShore Development Inc.
 
 CLSQL's home is http://clsql.b9.com.
 
 
 CLSQL's home is http://clsql.b9.com.
 

-Documentation is availabe as a PDF file in doc/clsql.pdf and as HTML
+Documentation is available as a PDF file in doc/clsql.pdf and as HTML

 files in doc/html.tar.gz.
 
 
 files in doc/html.tar.gz.
 
 

diff --git a/TODO b/TODO
index a3c5a6c3f76215806290f062cf43fc4c73fecc22..87949bf9aecf63eeb625f3c18ea058ad82ae1e42 100644 (file)
--- a/TODO
+++ b/TODO
@@ -1,18 +1,11 @@
 TESTS TO ADD
 
 TESTS TO ADD
 

-* CACHE-TABLE-QUERIES

 * Test that ":db-kind :key" adds an index for that key. This is complicated by 
   different backends showing autogenerated primary key in different ways.
 * :db-constraint tests
 * Test that ":db-kind :key" adds an index for that key. This is complicated by 
   different backends showing autogenerated primary key in different ways.
 * :db-constraint tests

-* test *db-auto-sync* 
-* for-each-row macro
-* owner phrases for postgresql and oracle backends

 * Number and Char field types
 * Number and Char field types

-* Add test case for return type of (setf slot-value-using-class)

 * symbol slot
 * generalized-boolean slot
 * symbol slot
 * generalized-boolean slot

-* column and table constraints in CREATE-TABLE and DEF-VIEW-CLASS. 
-* escaping of single quotes

 
 OPTIMIZATIONS
  
 
 OPTIMIZATIONS
  


@@ -21,6 +14,8 @@ OPTIMIZATIONS
   current behaviours using single database queries.  
 * Possible use of cached attribute type information for operations which 
   insert/update records as mentioned in the CommonSQL user guide. 
   current behaviours using single database queries.  
 * Possible use of cached attribute type information for operations which 
   insert/update records as mentioned in the CommonSQL user guide. 

+* Extend caching of generated SQL strings to more complex expressions which 
+  are likely to be repeatedly executed many times. 

 
 POSSIBLE EXTENSIONS
 
 
 POSSIBLE EXTENSIONS
 

diff --git a/doc/TODO b/doc/TODO
index 03e7a0e793ba96eab01cb2b18eb7907d49dd1221..3a4dae93697e0c61e27ef2615e5acf35b22773c3 100644 (file)
--- a/doc/TODO
+++ b/doc/TODO
@@ -2,38 +2,25 @@ DOCUMENTATION TO DO LIST
 
 1. Variances from CommonSQL (Ideally, this will be extremely minimal) 
 
 
 1. Variances from CommonSQL (Ideally, this will be extremely minimal) 
 

- - The SQL syntax state functions are macros in CLSQL. 
- - CLSQL starts with in transaction AUTOCOMMIT mode. 
-
-

 2. Underdocumented CommonSQL features:
 
  - Retrieval immediate
  - SQL operators: ||, SUBSTR, MINUS, INTERSECT, UNION, NVL 
 
 2. Underdocumented CommonSQL features:
 
  - Retrieval immediate
  - SQL operators: ||, SUBSTR, MINUS, INTERSECT, UNION, NVL 
 

-

 3. CLSQL extensions to CommonSQL
 
 3. CLSQL extensions to CommonSQL
 

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

  - SQL operators: group-by, limit, not-null, ==, is, having, the, uplike,
    view-class, coalesce, except, exists, substring, concat 
 
  - SQL operators: group-by, limit, not-null, ==, is, having, the, uplike,
    view-class, coalesce, except, exists, substring, concat 
 

- - OODML: *db-auto-sync*
-

  - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, 
    :INNER-JOIN and :ON. 
 
  - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, 
    :INNER-JOIN and :ON. 
 

- - DEF-VIEW-CLASS: DB-CONSTRAINTS, DB-TYPE and VOID-VALUE slot options. 
-
-

 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 
  

-

 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.).