X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=d63b9af6cb4d233dfe1911ea9326d0cb6afa9b9f;hb=f469a630aeb903c0574dea5b1ac478bed182d072;hp=1aca8f2d3ae2c904ea16e246cc221973e289c2c5;hpb=913477a11d2258f8fe87ff5b390c8904d17d66fe;p=clsql.git diff --git a/TODO b/TODO index 1aca8f2..d63b9af 100644 --- a/TODO +++ b/TODO @@ -1,17 +1,13 @@ -GENERAL - -* port Oracle backend to UFFI. -* consider adding large object support to mysql and odbc - TESTS TO ADD * CACHE-TABLE-QUERIES -* :VOID-VALUE, use a new view-class with several fields with different void-values -* :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 +* *update-records-on-make-instance* + COMMONSQL SPEC * Missing: @@ -24,23 +20,12 @@ 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 - + >> 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) @@ -60,6 +45,12 @@ COMMONSQL SPEC o variables (e.g., table identifiers) should be instantiated at runtime +POSSIBLE EXTENSIONS + +* port Oracle backend to UFFI +* large object support +* add support for prepared statements + NOTES ABOUT THE BACKENDS