X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=usql%2FTODO;fp=usql%2FTODO;h=0000000000000000000000000000000000000000;hb=a179ca240c6f64d2dee0640ef4ceaecacd00827e;hp=cedc46422e6b34be9ac887146103b3a7cb4cfedb;hpb=86d84b96f3e70bbb52c5701ec8f0eee611a3b3c9;p=clsql.git diff --git a/usql/TODO b/usql/TODO deleted file mode 100644 index cedc464..0000000 --- a/usql/TODO +++ /dev/null @@ -1,101 +0,0 @@ - -GENERAL - -* test on (and port to) sbcl, lispworks, acl, scl, mcl and openmcl; -* implement remaining functions for CLSQL AODBC backend; -* port UncommonSQL ODBC and Oracle backends to CLSQL. - - -COMMONSQL SPEC - -* Missing: - - RECONNECT - CACHE-TABLE-QUERIES - *CACHE-TABLE-QUERIES-DEFAULT* - *DEFAULT-UPDATE-OBJECTS-MAX-LEN* - UPDATE-OBJECT-JOINS - INSTANCE-REFRESHED - - -* Incompatible - - - >> Initialisation and connection - - CONNECT - o should accept string as connection spec - - DISCONNECT - o should accept string as connection spec - - INITIALIZE-DATABASE-TYPE - o should initialise appropriate backend - - STATUS - o what is the behaviour in CommonSQL (esp :full parameter)? - - - >> The functional sql interface - - SELECT - o should accept keyword arg :refresh and call INSTANCE-REFRESHED - 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 - - LIST-ATTRIBUTE-TYPES - o should return list of (attribute datatype precision scale nullable) - - LOOP - o the extension is currently CMUCL specific - - - >> The object-oriented sql interface - - DEF-VIEW-CLASS - o get :target-slot working - o implement :retrieval :immediate - - LIST-CLASSES - o keyword arg :root-class should do something (portable) - - DO-QUERY,MAP-QUERY,LOOP - o should work with object queries as well as functional ones - - - >> Symbolic SQL syntax - - o Complete sql expressions (see operations.lisp) - - substr - some - order-by - times - nvl - null - distinct - except - intersect - between - userenv - - o variables (e.g., table identifiers) should be instantiated at runtime - - - -NOTES ABOUT THE BACKENDS - -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 -queries: nested subqueries do not seem to work - -SQLITE - -create-view: column-list parameter not supported