X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=e7885ada35855a768e667e452532f153a80cd364;hb=a91ef336e5401ba5acbe0cf66447eeae7d4cad50;hp=4ca294e1d67392f6b04a07ee02b3c7fe920c2e58;hpb=5a429a60e6a20dbe2af3ddb31af83c48e36550a6;p=clsql.git diff --git a/TODO b/TODO index 4ca294e..e7885ad 100644 --- a/TODO +++ b/TODO @@ -1,11 +1,17 @@ -GENERAL - -* port Oracle backend to UFFI. - TESTS TO ADD * CACHE-TABLE-QUERIES -* :VOID-VALUE +* 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 @@ -19,12 +25,9 @@ COMMONSQL SPEC 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 - for SQLite backend + o should accept type-modified database identifiers (e.g., + [foo :string] which means that the values in column foo are returned + as Lisp strings) >> The object-oriented sql interface @@ -32,10 +35,6 @@ COMMONSQL SPEC 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)