liquid_feedback_core: ac7836ac00d9 lf

liquid_feedback_core

view lf_export @ 14:ac7836ac00d9

Version beta15

Bugfix: Revoked initiatives will never be admitted

Possibility to recommend another initiative to support when revoking an initiative

Allow "initiator"."accepted" to be NULL (NULL means "no answer yet", while FALSE means "rejected")

author	jbe
date	Sun Jan 10 12:00:00 2010 +0100 (2010-01-10)
parents	015825e225ca
children	2b03946cb0c2

line source

1 #!/bin/sh

3 if [ -z "$1" -o -z "$2" ]; then

4 echo "Usage: $0 <dbname> <filename>.sql.gz"

5 exit 1

6 fi

8 EXPORT_DBNAME=liquid_feedback_autoexport

9 retval=0

11 echo "Dropping database \"$EXPORT_DBNAME\" if existent..."

12 dropdb "$EXPORT_DBNAME" 2> /dev/null

13 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..."

14 if createdb -T "$1" "$EXPORT_DBNAME"

15 then

16 echo "Deleting private data in copied database..."

17 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null

18 then

19 echo "Dumping and compressing copied database to \"$2\"..."

20 if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2"

21 then

22 true

23 else

24 retval=4

25 fi

26 else

27 retval=3

28 fi

29 else

30 retval=2

31 fi

32 echo "Dropping database \"$EXPORT_DBNAME\"..."

33 dropdb "$EXPORT_DBNAME"

34 echo "DONE."

35 exit $retval