From 7b9b150cf1be6c4a52855c1a8004673cac1beaa0 Mon Sep 17 00:00:00 2001 From: Marcus Pearce Date: Sat, 17 Jul 2004 16:52:52 +0000 Subject: [PATCH] r9803: Remove items done from TODO files. --- README | 2 +- TODO | 9 ++------- doc/TODO | 13 ------------- 3 files changed, 3 insertions(+), 21 deletions(-) diff --git a/README b/README index a112f9d..6fc8d7a 100644 --- 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 a3c5a6c..87949bf 100644 --- 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 03e7a0e..3a4dae9 100644 --- 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.). -- 2.34.1