From fa4cef7354122a85d7a029de267f1d670d8d9138 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
Date: Wed, 9 Apr 2014 09:04:57 +0200
Subject: ruby script: add query.sh to generate matching csv

---
 generation/query.sh | 1 +
 1 file changed, 1 insertion(+)
 create mode 100755 generation/query.sh

(limited to 'generation')

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
-- 
cgit v1.2.3