X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=2a8c417fe5583e4c5662eaca4e54ae49c86148b4;hb=fd11963eb2f46ffac6da2b18fab3d7ff2a4390cf;hp=763403704ae9afebe2ba5d3e9d49d1397b37d6f0;hpb=80d94a5396eeaca850bb643390b836d8bd0825b3;p=clsql.git diff --git a/TODO b/TODO index 7634037..2a8c417 100644 --- a/TODO +++ b/TODO @@ -1,15 +1,18 @@ 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 -* :db-kind :key adds an index for that key, complicated by different - backends show autogenerated primary key in different ways. -* New universal and bigint types, add tests for other types - +* 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 * Missing: @@ -22,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 @@ -35,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)