liquid_feedback_core
view lf_export @ 10:effdd7a04ea7
Version beta11
Support is now automatically deleted, when interest is deleted
All tables dealing with delegations now contain a column scope (including table delegation)
Changes in fields related to notify_email of member
Policies can now specify larger majorities to be reached (e.g. 2/3)
New column agreed in table initiative to mark, if initiative has reached majority specified by policy
Minor bugfix in constraint non_admitted_initiatives_cant_contain_voting_results of initiative table
Function delete_private_data() no longer deletes invite codes, which have been already used
Removed view battle_participant
Added index on opinion (member_id, initiative_id)
Support is now automatically deleted, when interest is deleted
All tables dealing with delegations now contain a column scope (including table delegation)
Changes in fields related to notify_email of member
Policies can now specify larger majorities to be reached (e.g. 2/3)
New column agreed in table initiative to mark, if initiative has reached majority specified by policy
Minor bugfix in constraint non_admitted_initiatives_cant_contain_voting_results of initiative table
Function delete_private_data() no longer deletes invite codes, which have been already used
Removed view battle_participant
Added index on opinion (member_id, initiative_id)
| author | jbe |
|---|---|
| date | Fri Dec 25 12:00:00 2009 +0100 (2009-12-25) |
| parents | 4af4df1415f9 |
| children | 015825e225ca |
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 else
23 retval=4
24 fi
25 else
26 retval=3
27 fi
28 else
29 retval=2
30 fi
31 echo "Dropping database \"$EXPORT_DBNAME\"..."
32 dropdb "$EXPORT_DBNAME"
33 echo "DONE."
34 exit $retval