liquid_feedback_core
annotate lf_export @ 9:4af4df1415f9
Version beta10
Voting will be skipped, if no initiative is admitted for voting
Invite code feature allows people having an invite code to create one account
Contingent system to limit the number of initiatives or text entries to be submitted by each member within a given time
Ability to store a formatting engine for each draft, which can be used to allow initiatives to choose between available wiki parsers
New table setting storing user settings for the frontend (replaced hidden_hints column of beta9)
Better policy support:
- New table allowed_policy to select which policies can be used in each area
- Policies are now ordered by an index field
Bugfixes:
- In function close_voting(...): If there were no voters, this resulted in a NULL value as positive and negative vote counts
- In delete_private_data() function: Secret fields of member table are now deleted too
- Major bug fixed in lf_export, which caused data loss on execution
Voting will be skipped, if no initiative is admitted for voting
Invite code feature allows people having an invite code to create one account
Contingent system to limit the number of initiatives or text entries to be submitted by each member within a given time
Ability to store a formatting engine for each draft, which can be used to allow initiatives to choose between available wiki parsers
New table setting storing user settings for the frontend (replaced hidden_hints column of beta9)
Better policy support:
- New table allowed_policy to select which policies can be used in each area
- Policies are now ordered by an index field
Bugfixes:
- In function close_voting(...): If there were no voters, this resulted in a NULL value as positive and negative vote counts
- In delete_private_data() function: Secret fields of member table are now deleted too
- Major bug fixed in lf_export, which caused data loss on execution
| author | jbe |
|---|---|
| date | Thu Dec 10 12:00:00 2009 +0100 (2009-12-10) |
| parents | e6faf5ff83af |
| children | 015825e225ca |
| 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@9 | 17 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /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 |