From 68fd11ed96276026dd8333aed7a3a4b2ac72127f Mon Sep 17 00:00:00 2001 From: ygrek Date: Tue, 20 Oct 2009 23:52:47 +0300 Subject: [PATCH] TODO: tutorial --- TODO | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/TODO b/TODO index 6553cac..c37ae26 100644 --- a/TODO +++ b/TODO @@ -1,14 +1,14 @@ +* write tutorial (for all languages), start documentation +* native-type annotations in queries * output params syntax for different DB * guarantee correct duplicate params usage * allow to parametrize SQL syntax itself (ORDER BY ASC|DESC) : unsafe and enumeration * camlp4 syntax extension for inline sql * allow to tolerate errors in query -* special code for queries returning single values (COUNT(*) without GROUP BY, LIMIT 1, SELECT and UNIQUE INDEX, etc) +* detect single-row queries (COUNT(*) without GROUP BY (done), LIMIT 1 (done), SELECT and UNIQUE INDEX, SELECT constant) * support BULK INSERTs (how?) * decide what to do with unquoted identifiers matching keywords * provide ways to extend lexer with tokens in runtime -* split overview into several pages -* some database API are inadequately strict about data types (notably ADO.NET), need native-type annotations in queries * choose better names for some common cases (WHERE id = ? etc) * fix line numbers in error output * enhance error reporting @@ -16,6 +16,7 @@ * verify that each parameter gets one type inferred * track NULLs * detect statements on single tables and group the corresponding generated code together +* use prepared statements in all traits * check function names for uniqueness * support/test other SQL engines * generate code for more languages -- 2.11.4.GIT