diff options
author | Sebastian Reichel <sre@ring0.de> | 2014-04-09 09:04:57 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2014-04-09 09:04:57 +0200 |
commit | fa4cef7354122a85d7a029de267f1d670d8d9138 (patch) | |
tree | 5176b1b56b9447478d3a6b141abd030cf73bf4df | |
parent | 258c7c1dce42fed4b1a66900f8d3b45c42aa71e0 (diff) | |
download | serial-barcode-scanner-fa4cef7354122a85d7a029de267f1d670d8d9138.tar.bz2 |
ruby script: add query.sh to generate matching csv
-rwxr-xr-x | generation/query.sh | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/generation/query.sh b/generation/query.sh new file mode 100755 index 0000000..957fb62 --- /dev/null +++ b/generation/query.sh @@ -0,0 +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 |