3 * test on (and port to) openmcl and mcl. SCL no longer affordable to
5 * implement remaining functions for CLSQL AODBC backend;
6 * port Oracle and ODBC backend to UFFI.
14 *CACHE-TABLE-QUERIES-DEFAULT*
15 *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
23 >> Initialisation and connection
26 o should accept string as connection spec
29 o should accept string as connection spec
31 INITIALIZE-DATABASE-TYPE
32 o should initialise appropriate backend
35 o what is the behaviour in CommonSQL (esp :full parameter)?
38 >> The functional sql interface
41 o should accept keyword arg :refresh and call INSTANCE-REFRESHED
42 o should return (values result-list field-names)
43 o should coerce values returned as strings to appropriate lisp type
46 o should return (values result-list field-names)
47 o should coerce values returned as strings to appropriate lisp type
50 o should return list of (attribute datatype precision scale nullable)
53 o Port to lispworks. Potentially useful documentation:
54 http://www.lispworks.com/reference/lcl50/loop/loop-52.html
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