3 * test on mcl. SCL no longer affordable to individuals;
4 * implement remaining functions for CLSQL AODBC backend;
5 * port Oracle and ODBC backend to UFFI.
13 *CACHE-TABLE-QUERIES-DEFAULT*
14 *DEFAULT-UPDATE-OBJECTS-MAX-LEN*
22 >> Initialisation and connection
25 o should accept string as connection spec
28 o should accept string as connection spec
30 INITIALIZE-DATABASE-TYPE
31 o should initialise appropriate backend
34 o what is the behaviour in CommonSQL (esp :full parameter)?
37 >> The functional sql interface
40 o should accept keyword arg :refresh and call INSTANCE-REFRESHED
41 o should return (values result-list field-names)
42 o should coerce values returned as strings to appropriate lisp type
45 o should return (values result-list field-names)
46 o should coerce values returned as strings to appropriate lisp type
49 o should return list of (attribute datatype precision scale nullable)
52 >> The object-oriented sql interface
55 o get :target-slot working
56 o implement :retrieval :immediate
59 o keyword arg :root-class should do something (portable)
61 DO-QUERY,MAP-QUERY,LOOP
62 o should work with object queries as well as functional ones
65 >> Symbolic SQL syntax
67 o Complete sql expressions (see operations.lisp)
81 o variables (e.g., table identifiers) should be instantiated at runtime
85 NOTES ABOUT THE BACKENDS
89 drop-index: requires a table to be specified with the :from keyword parameter
90 transactions: don't seem to work
91 views: mysql does not support views
92 queries: nested subqueries do not seem to work
96 create-view: column-list parameter not supported