liquid_feedback_core

annotate lf_export @ 235:2a6984869ba3

Delete sessions:
- when they expire
- in function "delete_private_data" (security relevant in certain setups)
- in function "delete_member"

(Sessions had been removed in changeset ed2f94a397cd and re-added in changeset 4e3d8f1ca3a9 without mechanisms for deletion of sessions)
author jbe
date Tue Mar 13 18:04:53 2012 +0100 (2012-03-13)
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

Impressum / About Us