summaryrefslogtreecommitdiffstats
path: root/generation
diff options
context:
space:
mode:
Diffstat (limited to 'generation')
-rwxr-xr-xgeneration/query.sh1
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