X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2FTODO;h=8d976c8effe4dfbd6df648850be005fb5e9a761e;hb=ddae27a4c55b8a055afc167bd7d65c766cc6c78e;hp=b288ef093b13418e081885f84bccbcafe88cccd8;hpb=e5a6fadf80e923a4fa08fbb8af16652d7970983e;p=clsql.git diff --git a/doc/TODO b/doc/TODO index b288ef0..8d976c8 100644 --- a/doc/TODO +++ b/doc/TODO @@ -4,6 +4,8 @@ DOCUMENTATION TO DO LIST - Ideally, this will be extremely minimal + - The SQL syntax state functions are macros in CLSQL. + 2. Underdocumented CommonSQL features: - Retrieval immediate @@ -28,12 +30,25 @@ DOCUMENTATION TO DO LIST - SELECT: additional keyword arguments accepted include :LIMIT, :OFFSET, :INNER-JOIN and :ON. + - SQL-RECORDING-P: also accepts :both and :either values for the TYPE + parameter. + + - DROP-TABLE/DROP-VIEW/DROP-INDEX: keyword arg :if-does-not-exist. + + - DROP-INDEX: keyword arg :on (for MySQL). + + - DEF-VIEW-CLASS: DB-CONSTRAINTS and DB-TYPE slot options. + + - CREATE-TABLE: keyword args :TRANSACTIONS (for MySQL) and :CONSTRAINTS + description arg accepts optional DB-TYPE string. + 4. Documenting lower level, non-CommonSQL functions (some of this is already done). - connection pools - database-query-result-set + 5. Notes on any peculiarities of each of the backends (e.g., unsupported features, notable extensions etc.). @@ -44,6 +59,8 @@ DOCUMENTATION TO DO LIST queries: nested subqueries are not supported syntax: doesn't support the sql concatenation operator (||). doesn't support INTERSECT/EXCEPT set operations. + create-table: the transactions keyword arg controls whether the created + table is an InnoDB table (supporting transactions) or not. - SQLITE