From 22b59d8d176ea0d329dcd5b074f38640367ad02c Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Fri, 23 Oct 2015 15:44:09 +0200 Subject: Add feature: multiple (?) or order_by() in query condition --- feature/view/list | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/feature/view/list b/feature/view/list index aa02062..2bd4bc8 100644 --- a/feature/view/list +++ b/feature/view/list @@ -1,3 +1,19 @@ +- Multiple (?) or order_by() in query condition + + Consider: + + #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. -- cgit v1.1