X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=TODO;h=4a25b42f9f8fded6dbf4335e30f7c189b946ec0f;hp=4ca294e1d67392f6b04a07ee02b3c7fe920c2e58;hb=550cc94ed84c6cfc61830c25fac2b39e92393b06;hpb=5a429a60e6a20dbe2af3ddb31af83c48e36550a6 diff --git a/TODO b/TODO index 4ca294e..4a25b42 100644 --- a/TODO +++ b/TODO @@ -1,11 +1,17 @@ GENERAL * port Oracle backend to UFFI. +* consider adding large object support to mysql and odbc +* add support for prepared statements. 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 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)