From 499a136441e41a3ab046d43bc8a925d9f10a479a Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Tue, 7 Jul 2020 13:31:58 -0400 Subject: Use >= and < on events.time for -D This will enable the use of an index on events.time. --- scoop.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/scoop.c b/scoop.c index f49f09a..9605530 100644 --- a/scoop.c +++ b/scoop.c @@ -402,7 +402,8 @@ int main(int argc, char *argv[]) { for (int opt; 0 < (opt = getopt(argc, argv, Opts));) { switch (opt) { break; case 'D': { - append(where, SQL(AND date(events.time) = date(:date))); + append(where, SQL(AND events.time >= date(:date))); + append(where, SQL(AND events.time < date(:date, '+1 day'))); binds[n++] = Bind(":date", optarg, 0); } break; case 'F': { -- cgit 1.4.1 'master' selected='selected'>master dontfiles
summary refs log tree commit diff
path: root/bin/1sh/libedit/filecomplete.c (unfollow)
Commit message (Collapse)Author
2019-09-20Enable cookies in titleJune McEnroe
Perhaps this will make it less suspicious to Google. Who knows.
2019-09-16Use sensitivity aliases in TF2June McEnroe
2019-09-16Add The Just CityJune McEnroe
2019-09-12Only GET the final redirect locationJune McEnroe
2019-09-12Consume entire bodyJune McEnroe
Aborting the request and leaving data around may be causing intermittent errors. Just discard the rest of the data.
2019-09-10Add title -v flagJune McEnroe
2019-09-10Use curl error bufferJune McEnroe
2019-09-10Set Accept-Encoding in titleJune McEnroe
Because apparently it's fine for servers to respond with Content-Encoding you didn't ask for, and curl won't decode it if you didn't ask for it.
2019-09-08Set title User-AgentJune McEnroe
Some things don't like you if you don't send one.
2019-09-07Add -x flag to titleJune McEnroe
2019-09-07Ignore SIGPIPE in relayJune McEnroe
Allows restarting consumers safely.
2019-09-07Add A Memory Called EmpireJune McEnroe
2019-09-05Handle lack of Content-TypeJune McEnroe
2019-09-05Use CURLINFO_CONTENT_TYPEJune McEnroe
Oops, didn't see this.
2019-09-05Decode entities in titlesJune McEnroe
2019-09-05Print title as soon as it's availableJune McEnroe
2019-09-05Use CURL_PREFIX to set flagsJune McEnroe
2019-09-05Add titleJune McEnroe
2019-09-04Add Avorter n'est pas tuerJune McEnroe
2019-08-29Unset executable on shell scriptsJune McEnroe
2019-08-29Add long-missing setopt to bin.7June McEnroe
2019-08-29Add editJune McEnroe