liquid_feedback_core
annotate 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 |
| rev | line source |
|---|---|
| jbe@8 | 1 #!/bin/sh |
| jbe@8 | 2 |
| jbe@8 | 3 if [ -z "$1" -o -z "$2" ]; then |
| jbe@8 | 4 echo "Usage: $0 <dbname> <filename>.sql.gz" |
| jbe@8 | 5 exit 1 |
| jbe@8 | 6 fi |
| jbe@8 | 7 |
| jbe@8 | 8 EXPORT_DBNAME=liquid_feedback_autoexport |
| jbe@8 | 9 retval=0 |
| jbe@8 | 10 |
| jbe@8 | 11 echo "Dropping database \"$EXPORT_DBNAME\" if existent..." |
| jbe@8 | 12 dropdb "$EXPORT_DBNAME" 2> /dev/null |
| jbe@8 | 13 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..." |
| jbe@8 | 14 if createdb -T "$1" "$EXPORT_DBNAME" |
| jbe@8 | 15 then |
| jbe@8 | 16 echo "Deleting private data in copied database..." |
| jbe@8 | 17 if psql liquid_feedback -c 'SELECT delete_private_data()' > /dev/null |
| jbe@8 | 18 then |
| jbe@8 | 19 echo "Dumping and compressing copied database to \"$2\"..." |
| jbe@8 | 20 if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2" |
| jbe@8 | 21 then |
| jbe@8 | 22 else |
| jbe@8 | 23 retval=4 |
| jbe@8 | 24 fi |
| jbe@8 | 25 else |
| jbe@8 | 26 retval=3 |
| jbe@8 | 27 fi |
| jbe@8 | 28 else |
| jbe@8 | 29 retval=2 |
| jbe@8 | 30 fi |
| jbe@8 | 31 echo "Dropping database \"$EXPORT_DBNAME\"..." |
| jbe@8 | 32 dropdb "$EXPORT_DBNAME" |
| jbe@8 | 33 echo "DONE." |
| jbe@8 | 34 exit $retval |