4 * test on (and port to) sbcl, lispworks, acl, scl, mcl and openmcl;
5 * implement remaining functions for CLSQL AODBC backend;
6 * port UncommonSQL ODBC and Oracle backends to CLSQL.
15 *CACHE-TABLE-QUERIES-DEFAULT*
16 *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
24 >> Initialisation and connection
27 o should accept string as connection spec
30 o should accept string as connection spec
32 INITIALIZE-DATABASE-TYPE
33 o should initialise appropriate backend
36 o what is the behaviour in CommonSQL (esp :full parameter)?
39 >> The functional sql interface
42 o should accept keyword arg :refresh and call INSTANCE-REFRESHED
43 o should return (values result-list field-names)
44 o should coerce values returned as strings to appropriate lisp type
47 o should return (values result-list field-names)
48 o should coerce values returned as strings to appropriate lisp type
51 o should return list of (attribute datatype precision scale nullable)
54 o the extension is currently CMUCL specific
57 >> The object-oriented sql interface
60 o get :target-slot working
61 o implement :retrieval :immediate
64 o keyword arg :root-class should do something (portable)
66 DO-QUERY,MAP-QUERY,LOOP
67 o should work with object queries as well as functional ones
70 >> Symbolic SQL syntax
72 o Complete sql expressions (see operations.lisp)
86 o variables (e.g., table identifiers) should be instantiated at runtime
90 NOTES ABOUT THE BACKENDS
94 drop-index: requires a table to be specified with the :from keyword parameter
95 transactions: don't seem to work
96 views: mysql does not support views
97 queries: nested subqueries do not seem to work
101 create-view: column-list parameter not supported