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

diff --git a/TODO b/TODO
index a3c5a6c3f76215806290f062cf43fc4c73fecc22..87949bf9aecf63eeb625f3c18ea058ad82ae1e42 100644 (file)
--- a/TODO
+++ b/TODO
@@ -1,18 +1,11 @@
 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 *db-auto-sync* 
-* for-each-row macro
-* owner phrases for postgresql and oracle backends
 * Number and Char field types
-* Add test case for return type of (setf slot-value-using-class)
 * symbol slot
 * generalized-boolean slot
-* column and table constraints in CREATE-TABLE and DEF-VIEW-CLASS. 
-* escaping of single quotes
 
 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. 
+* Extend caching of generated SQL strings to more complex expressions which 
+  are likely to be repeatedly executed many times. 
 
 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) 
 
- - 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 
 
-
 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 
 
- - OODML: *db-auto-sync*
-
  - 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 
  
-
 5. Notes on any peculiarities of each of the backends (e.g., unsupported 
    features, notable extensions etc.).