liquid_feedback_core
annotate lf_export @ 142:54ac8c473263
Use an improved definition for "disqualified" initiatives
"initiative"."disqualified" is TRUE, if the initiative may not win, because it either (a) has no better rank than the status quo, or (b) because there exists a better ranked initiative X, which directly beats this initiative, and either more voters prefer X to this initiative than voters preferring X to the status quo or less voters prefer this initiative to X than voters preferring the status quo to X
"initiative"."disqualified" is TRUE, if the initiative may not win, because it either (a) has no better rank than the status quo, or (b) because there exists a better ranked initiative X, which directly beats this initiative, and either more voters prefer X to this initiative than voters preferring X to the status quo or less voters prefer this initiative to X than voters preferring the status quo to X
author | jbe |
---|---|
date | Wed Jun 01 16:58:00 2011 +0200 (2011-06-01) |
parents | 2b03946cb0c2 |
children |
rev | line source |
---|---|
jbe@8 | 1 #!/bin/sh |
jbe@8 | 2 |
jbe@8 | 3 if [ -z "$1" -o -z "$2" ]; then |
jbe@8 | 4 echo "Usage: $0 <dbname> <filename>.sql.gz" |
jbe@8 | 5 exit 1 |
jbe@8 | 6 fi |
jbe@8 | 7 |
jbe@8 | 8 EXPORT_DBNAME=liquid_feedback_autoexport |
jbe@8 | 9 retval=0 |
jbe@8 | 10 |
jbe@8 | 11 echo "Dropping database \"$EXPORT_DBNAME\" if existent..." |
jbe@8 | 12 dropdb "$EXPORT_DBNAME" 2> /dev/null |
jbe@8 | 13 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..." |
jbe@40 | 14 # TODO: use character encoding of original database |
jbe@40 | 15 if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null) |
jbe@8 | 16 then |
jbe@8 | 17 echo "Deleting private data in copied database..." |
jbe@9 | 18 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null |
jbe@8 | 19 then |
jbe@8 | 20 echo "Dumping and compressing copied database to \"$2\"..." |
jbe@8 | 21 if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2" |
jbe@8 | 22 then |
jbe@11 | 23 true |
jbe@8 | 24 else |
jbe@8 | 25 retval=4 |
jbe@8 | 26 fi |
jbe@8 | 27 else |
jbe@8 | 28 retval=3 |
jbe@8 | 29 fi |
jbe@8 | 30 else |
jbe@8 | 31 retval=2 |
jbe@8 | 32 fi |
jbe@8 | 33 echo "Dropping database \"$EXPORT_DBNAME\"..." |
jbe@8 | 34 dropdb "$EXPORT_DBNAME" |
jbe@8 | 35 echo "DONE." |
jbe@8 | 36 exit $retval |