liquid_feedback_core: a7537038640d lf

liquid_feedback_core

view lf_export @ 336:a7537038640d

Cleanup of new code for allowing "lf_update" to run without extensive locking

- Removed unnecessary variable "direct_voter_update_v" in function "forbid_changes_on_closed_issue_trigger"()
- Added PERFORM "require_transaction_isolation"() in more functions
- Integrated functions "issue_admission", "initiative_admission" and "freeze_after_snapshot" into "check_issue" function
- Removed function "manual_freeze" (replacement: set "issue" timings accordingly, when needed)
- Added/modified some comments

author	jbe
date	Wed Feb 20 02:56:49 2013 +0100 (2013-02-20)
parents	2b03946cb0c2
children

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 # TODO: use character encoding of original database

15 if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null)

16 then

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

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

19 then

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

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

22 then

23 true

24 else

25 retval=4

26 fi

27 else

28 retval=3

29 fi

30 else

31 retval=2

32 fi

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

34 dropdb "$EXPORT_DBNAME"

35 echo "DONE."

36 exit $retval