X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=eaadf078ffe3ef8ba9e3ccda8d70b5f9e4dc8de7;hb=5990bfce392a05c10237d4f97b008c4f828028e5;hp=bc42595d3e32acafc00daf262139951bd9fe8fe0;hpb=8b5250e14e3280bdc4641c3b35a8dc68ca4dbde7;p=clsql.git diff --git a/TODO b/TODO index bc42595..eaadf07 100644 --- a/TODO +++ b/TODO @@ -1,54 +1,37 @@ -GENERAL +TESTS TO ADD -* implement remaining functions for CLSQL AODBC backend; -* port Oracle backend to UFFI. +* CACHE-TABLE-QUERIES +* Test that ":db-kind :key" adds an index for that key. This is complicated by different + backends showing autogenerated primary key in different ways. +* Large object testing +* Test bigint type +* :db-constraint tests + +POSSIBLE EXTENSIONS + +* port Oracle backend to UFFI +* large object support +* add support for prepared statements COMMONSQL SPEC * Missing: - CACHE-TABLE-QUERIES - *CACHE-TABLE-QUERIES-DEFAULT* - *DEFAULT-UPDATE-OBJECTS-MAX-LEN* UPDATE-OBJECT-JOINS - * Incompatible - - >> Initialisation and connection - - 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 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 coerce values returned as strings to appropriate lisp type - - LIST-ATTRIBUTE-TYPES - o should return list of (attribute datatype precision scale nullable) - - + >> The object-oriented sql interface DEF-VIEW-CLASS o get :target-slot working o implement :retrieval :immediate - 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)