liquid_feedback_core
annotate lf_export @ 113:76ffbafb23b5
Work on event and notification system; Added more "issue_state"s; Replaced "ignored_issue" table; Removal of sessions in "delete_member" function
- "state" column of table "event" is now always filled
- splitted revocation state into 3 new "issue_state"s:
- 'canceled_revoked_before_accepted'
- 'canceled_after_revocation_during_discussion'
- 'canceled_after_revocation_during_verification'
- Added columns "notify_level" and "notify_event_id" to "member" table
- Replaced view "ignored_issue" by three new views:
- TABLE "ignored_member"
- TABLE "ignored_initiative"
- TABLE "non_voter"
- Function "delete_member" now removes "session"s
- Added member specific views on events:
- VIEW "event_seen_by_member"
- VIEW "pending_notification"
- "state" column of table "event" is now always filled
- splitted revocation state into 3 new "issue_state"s:
- 'canceled_revoked_before_accepted'
- 'canceled_after_revocation_during_discussion'
- 'canceled_after_revocation_during_verification'
- Added columns "notify_level" and "notify_event_id" to "member" table
- Replaced view "ignored_issue" by three new views:
- TABLE "ignored_member"
- TABLE "ignored_initiative"
- TABLE "non_voter"
- Function "delete_member" now removes "session"s
- Added member specific views on events:
- VIEW "event_seen_by_member"
- VIEW "pending_notification"
| author | jbe |
|---|---|
| date | Sat Mar 05 22:05:13 2011 +0100 (2011-03-05) |
| parents | 2b03946cb0c2 |
| children |
| 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@40 | 14 # TODO: use character encoding of original database |
| jbe@40 | 15 if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null) |
| jbe@8 | 16 then |
| jbe@8 | 17 echo "Deleting private data in copied database..." |
| jbe@9 | 18 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null |
| jbe@8 | 19 then |
| jbe@8 | 20 echo "Dumping and compressing copied database to \"$2\"..." |
| jbe@8 | 21 if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2" |
| jbe@8 | 22 then |
| jbe@11 | 23 true |
| jbe@8 | 24 else |
| jbe@8 | 25 retval=4 |
| jbe@8 | 26 fi |
| jbe@8 | 27 else |
| jbe@8 | 28 retval=3 |
| jbe@8 | 29 fi |
| jbe@8 | 30 else |
| jbe@8 | 31 retval=2 |
| jbe@8 | 32 fi |
| jbe@8 | 33 echo "Dropping database \"$EXPORT_DBNAME\"..." |
| jbe@8 | 34 dropdb "$EXPORT_DBNAME" |
| jbe@8 | 35 echo "DONE." |
| jbe@8 | 36 exit $retval |