X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=TODO;h=eaadf078ffe3ef8ba9e3ccda8d70b5f9e4dc8de7;hb=5990bfce392a05c10237d4f97b008c4f828028e5;hp=4b160e54bac909fcb539d339ec16d178521db033;hpb=4d1a3100285889c84e63f8f4500dbd4b6c1f8ddc;p=clsql.git diff --git a/TODO b/TODO index 4b160e5..eaadf07 100644 --- a/TODO +++ b/TODO @@ -1,6 +1,17 @@ -GENERAL +TESTS TO ADD -* port Oracle backend to UFFI. +* CACHE-TABLE-QUERIES +* 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 @@ -10,34 +21,17 @@ COMMONSQL SPEC * Incompatible - - >> Initialisation and connection - - STATUS - o what is the behaviour in CommonSQL (esp :full parameter)? - - >> The functional sql interface 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)