diff options
| author | June McEnroe <june@causal.agency> | 2020-01-01 16:39:09 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-01-01 16:39:09 -0500 |
| commit | 1ba0d0b91a339ef2d684b628347674a756569c52 (patch) | |
| tree | 499e5fb5d78f58f9e6d1aef127c533223913bb10 /scoop.c | |
| parent | Document ENVIRONMENT in scoop(1) (diff) | |
| download | litterbox-1ba0d0b91a339ef2d684b628347674a756569c52.tar.gz litterbox-1ba0d0b91a339ef2d684b628347674a756569c52.zip | |
Add option for custom where expression to scoop
Diffstat (limited to '')
| -rw-r--r-- | scoop.c | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/scoop.c b/scoop.c index f75a32c..d21d77e 100644 --- a/scoop.c +++ b/scoop.c @@ -276,9 +276,10 @@ int main(int argc, char *argv[]) { int n = 0; struct Bind binds[argc]; const char *search = NULL; + const char *where = NULL; int opt; - while (0 < (opt = getopt(argc, argv, "D:F:N:T:a:b:c:d:f:gh:l:n:pqst:u:v"))) { + while (0 < (opt = getopt(argc, argv, "D:F:N:T:a:b:c:d:f:gh:l:n:pqst:u:vw:"))) { switch (opt) { break; case 'D': binds[n++] = Bind(":date", optarg, 0); break; case 'F': binds[n++] = Bind(":format", optarg, 0); @@ -299,6 +300,7 @@ int main(int argc, char *argv[]) { break; case 't': binds[n++] = Bind(":type", NULL, parseType(optarg)); break; case 'u': binds[n++] = Bind(":user", optarg, 0); break; case 'v': verbose = true; + break; case 'w': where = optarg; break; default: return EX_USAGE; } } @@ -347,15 +349,16 @@ int main(int argc, char *argv[]) { if (search) { snprintf( sql, sizeof(sql), - "WITH results AS (%s AND %s %s) %s;", - Inner, Search, Limit, (group ? Group : Outer) + "WITH results AS (%s AND %s AND %s %s) %s;", + Inner, Search, (where ? where : "true"), Limit, + (group ? Group : Outer) ); binds[n++] = Bind(":search", search, 0); } else { snprintf( sql, sizeof(sql), - "WITH results AS (%s %s) %s;", - Inner, Limit, (group ? Group : Outer) + "WITH results AS (%s AND %s %s) %s;", + Inner, (where ? where : "true"), Limit, (group ? Group : Outer) ); } |