From d92aa9d79a3f80557119b660f7191e96b7d79878 Mon Sep 17 00:00:00 2001 From: Holger Cremer Date: Fri, 5 Apr 2019 18:01:28 +0200 Subject: Several pdf generation improvements. - 2 scripts to create barcodes - "joined add" parameter to create partial lists for updates - a dockerfile to easy creation --- generation/query.sh | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) (limited to 'generation/query.sh') diff --git a/generation/query.sh b/generation/query.sh index 67accaf..a6a9783 100755 --- a/generation/query.sh +++ b/generation/query.sh @@ -1 +1,17 @@ -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 +#!/bin/bash + +if [[ "$1" != "" ]]; then + # format YYYY-MM-DD, e.g. 2017-01-01 + DATE_PART="AND joined_at > strftime('%s', '$1')" +fi + +SQL=`cat < 0 +$DATE_PART +EOF +` +sqlite3 shop.db "$SQL" \ + | sed "s~|~,~g" > users.csv -- cgit v1.2.3