|author||Boris Kolpackov <email@example.com>||2015-10-23 15:44:09 +0200|
|committer||Boris Kolpackov <firstname.lastname@example.org>||2015-10-23 15:44:09 +0200|
Add feature: multiple (?) or order_by() in query condition
1 files changed, 16 insertions, 0 deletions
diff --git a/feature/view/list b/feature/view/list
index aa02062..2bd4bc8 100644
@@ -1,3 +1,19 @@
+- Multiple (?) or order_by() in query condition
+ #pragma ... query(foo.bar.not_null () && (?))
+ If we substitute "ORDER BY ..." for (?), then we will get "... AND ORDER BY"
+ in the statement. We can make it work by changing && to + but then if
+ we actually have additional conditions, that won't work.
+ One idea: have order_by() pragma? Though we can also have LIMIT, OFFSET,
+ etc. This should also align with ORDER BY, etc syntax in general queries.
+ Another idea: support multiple (?) that are "filled" from multiple
+ query() arguments (C++11 variadic template).
- Member names for table views
Currently we have to specify column names as strings in table views queries.