liquid_feedback_core: c65002c1a509 lf

liquid_feedback_core

view lf_export @ 69:c65002c1a509

Important bugfix, affecting correct counting of supporters/votes

Changed "trustee_id" to "truster_id" in following views:
- global_delegation
- area_delegation
- issue_delegation

Also updated comments for that views.

The new behaviour was expected by the following functions:
- membership_weight_with_skipping
- weight_of_added_delegations_for_population_snapshot
- weight_of_added_delegations_for_interest_snapshot
- weight_of_added_vote_delegations

The bug caused inactive members to falsely increase voting weight of trustees.

author	jbe
date	Mon Aug 30 22:01:08 2010 +0200 (2010-08-30)
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