projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r9186: add attribute caching, improve inititialize-database-type
[clsql.git]
/
TODO
diff --git
a/TODO
b/TODO
index 9e3d694ba3317d08123a3165f138f142fe65242c..9d5e76d6e7b9800d7f32d665247bc9999e2fac27 100644
(file)
--- a/
TODO
+++ b/
TODO
@@
-1,29
+1,18
@@
GENERAL
GENERAL
-* test on mcl. SCL no longer affordable to individuals;
-* implement remaining functions for CLSQL AODBC backend;
-* port Oracle and ODBC backend to UFFI.
+* port Oracle backend to UFFI.
COMMONSQL SPEC
* Missing:
COMMONSQL SPEC
* Missing:
- RECONNECT
- CACHE-TABLE-QUERIES
- *CACHE-TABLE-QUERIES-DEFAULT*
- *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
UPDATE-OBJECT-JOINS
UPDATE-OBJECT-JOINS
- INSTANCE-REFRESHED
-
* Incompatible
>> Initialisation and connection
* Incompatible
>> Initialisation and connection
- INITIALIZE-DATABASE-TYPE
- o should initialise appropriate backend
-
STATUS
o what is the behaviour in CommonSQL (esp :full parameter)?
STATUS
o what is the behaviour in CommonSQL (esp :full parameter)?
@@
-31,17
+20,14
@@
COMMONSQL SPEC
>> The functional sql interface
SELECT
>> The functional sql interface
SELECT
- o
should accept keyword arg :refresh and call INSTANCE-REFRESHED
+ o
keyword arg :refresh should function as advertised
o should return (values result-list field-names)
o should coerce values returned as strings to appropriate lisp type
QUERY
o should return (values result-list field-names)
o should coerce values returned as strings to appropriate lisp type
QUERY
- o should return (values result-list field-names)
o should coerce values returned as strings to appropriate lisp type
o should coerce values returned as strings to appropriate lisp type
-
- LIST-ATTRIBUTE-TYPES
- o should return list of (attribute datatype precision scale nullable)
-
+ (except for SQLite interface, this works when :result-types is :auto).
+ Perhaps that should be the default?
>> The object-oriented sql interface
>> The object-oriented sql interface
@@
-78,9
+64,8
@@
NOTES ABOUT THE BACKENDS
MYSQL
drop-index: requires a table to be specified with the :from keyword parameter
MYSQL
drop-index: requires a table to be specified with the :from keyword parameter
-transactions: don't seem to work
views: mysql does not support views
views: mysql does not support views
-queries: nested subqueries
do not seem to work
+queries: nested subqueries
are not supported
SQLITE
SQLITE