X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=f3852b0fd317cc1da6131ac6c93265d753a6cf5d;hb=ec9b352b8205e4204a06797f98970b03cf532ab2;hp=4ca294e1d67392f6b04a07ee02b3c7fe920c2e58;hpb=5a429a60e6a20dbe2af3ddb31af83c48e36550a6;p=clsql.git diff --git a/TODO b/TODO index 4ca294e..f3852b0 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. +* Test New universal and bigint types, add tests for other types such as duration and money +* Large object testing +* :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,9 @@ COMMONSQL SPEC o get :target-slot working o implement :retrieval :immediate - DO-QUERY,MAP-QUERY,LOOP + LOOP o should work with object queries as well as functional ones - >> Symbolic SQL syntax o Complete sql expressions (see operations.lisp)