diff options
| author | Sebastian Reichel <sre@ring0.de> | 2019-04-02 23:02:39 +0200 |
|---|---|---|
| committer | Sebastian Reichel <sre@ring0.de> | 2019-04-02 23:02:39 +0200 |
| commit | 2714fc190f01894eaaa64bf3869a4a4269ab1dcf (patch) | |
| tree | e615f5622b5455f1a46c7dcfa8c92ef47cd26fab | |
| parent | ad0e5a7ae756a7a63cff5b0a4a77d3b50e9c1fde (diff) | |
| download | serial-barcode-scanner-2714fc190f01894eaaa64bf3869a4a4269ab1dcf.tar.bz2 | |
update query.sh
| -rwxr-xr-x | generation/query.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/generation/query.sh b/generation/query.sh index 957fb62..67accaf 100755 --- a/generation/query.sh +++ b/generation/query.sh @@ -1 +1 @@ -sqlite3 ../shop.db "SELECT id,firstname,lastname FROM users LEFT JOIN authentication ON users.id = authentication.user WHERE (disabled IS NULL or disabled != 1) and id > 0" | sed "s~|~,~g" > users.csv +sqlite3 shop.db "SELECT id,firstname,lastname FROM users LEFT JOIN authentication ON users.id = authentication.user WHERE (users.disabled IS NULL or users.disabled != 1) and id > 0" | sed "s~|~,~g" > users.csv |