liquid_feedback_core
view lf_export @ 8:e6faf5ff83af
Version beta9
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
Added missing indicies on TSVECTOR fields
New field latest_snapshot_event in table issue specifying the type of the latest snapshot taken
Added weight field also for (intermediate) delegating members in snapshot and voter tables
Possibility for an initiative to specify a URL where an external discussion takes place (discussion_url)
Export concept for creating a database dump, without some non-public information (e.g. private contact data), including:
- Shell script lf_export
- Database function delete_private_data()
Field in member table to be used by a frontend to store information about hints being hidden by the user
Minor cleanup / New comments
| author | jbe |
|---|---|
| date | Mon Nov 30 12:00:00 2009 +0100 (2009-11-30) |
| parents | |
| children | 4af4df1415f9 |
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 liquid_feedback -c 'SELECT delete_private_data()' > /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