liquid_feedback_core
annotate lf_export @ 78:4fc1779a9c98
add test policies
the test policies have values that move them quickly to the target area for frontend development
the test policies have values that move them quickly to the target area for frontend development
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Mon Oct 04 14:24:29 2010 +0200 (2010-10-04) |
| 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 |