liquid_feedback_core

diff 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
author: jbe
date: Mon Nov 30 12:00:00 2009 +0100 (2009-11-30)
children: 4af4df1415f9
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/lf_export	Mon Nov 30 12:00:00 2009 +0100
     1.3 @@ -0,0 +1,34 @@
     1.4 +#!/bin/sh
     1.5 +
     1.6 +if [ -z "$1" -o -z "$2" ]; then
     1.7 +  echo "Usage: $0 <dbname> <filename>.sql.gz"
     1.8 +  exit 1
     1.9 +fi
    1.10 +
    1.11 +EXPORT_DBNAME=liquid_feedback_autoexport
    1.12 +retval=0
    1.13 +
    1.14 +echo "Dropping database \"$EXPORT_DBNAME\" if existent..."
    1.15 +dropdb "$EXPORT_DBNAME" 2> /dev/null
    1.16 +echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..."
    1.17 +if createdb -T "$1" "$EXPORT_DBNAME"
    1.18 +then
    1.19 +  echo "Deleting private data in copied database..."
    1.20 +  if psql liquid_feedback -c 'SELECT delete_private_data()' > /dev/null
    1.21 +  then
    1.22 +    echo "Dumping and compressing copied database to \"$2\"..."
    1.23 +    if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2"
    1.24 +    then
    1.25 +    else
    1.26 +      retval=4
    1.27 +    fi
    1.28 +  else
    1.29 +    retval=3
    1.30 +  fi
    1.31 +else
    1.32 +  retval=2
    1.33 +fi
    1.34 +echo "Dropping database \"$EXPORT_DBNAME\"..."
    1.35 +dropdb "$EXPORT_DBNAME"
    1.36 +echo "DONE."
    1.37 +exit $retval
author	jbe
date	Mon Nov 30 12:00:00 2009 +0100 (2009-11-30)
parents
children	4af4df1415f9