Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

During my Xed restoring of data I decided to make a script for this...

Code Block
languagebash
titledb-restore.sh
collapsetrue
#!/bin/bash

RESET_DIR="$(dirname $0)"
MANAGE_PY="/home/vagrant/norduni/src/niweb/manage.py"
NOCLOOK_DIR="/home/vagrant/norduni/src/scripts"
NEO4J_DIR="/home/vagrant/neo4j-community-2.1.6"


function now (){
  date +"%Y-%m-%d %H:%M:%S"
}


function msg(){
  echo "> $1 - $(now)"
}


msg "Stopping neo4j"
$NEO4J_DIR/bin/neo4j stop


msg "Removing neo4j data"
rm -rf $NEO4J_DIR/data/*


msg "Starting neo4j again"
$NEO4J_DIR/bin/neo4j start


msg "Adding indexes to neo4j"
curl -D - -H "Content-Type: application/json" --data '{"name" : "node_auto_index","config" : {"type" : "fulltext","provider" : "lucene"}}' -X POST http://localhost:7474/db/data/index/node/
curl -D - -H "Content-Type: application/json" --data '{"name" : "relationship_auto_index","config" : {"type" : "fulltext","provider" : "lucene"}}' -X POST http://localhost:7474/db/data/index/relationship/


msg "Drop, Create, Grant on DB"
sudo -u postgres psql -f "$RESET_DIR/sql/drop-create-grant.sql"


msg "Python migrate"
python $MANAGE_PY syncdb
python $MANAGE_PY migrate apps.noclook
python $MANAGE_PY migrate actstream
python $MANAGE_PY migrate tastypie


msg "Reset DB sequences"
sudo -u postgres psql -f "$RESET_DIR/sql/reset-sequences-noclook.sql" norduni


msg "Importing data from json"
cd $NOCLOOK_DIR
python noclook_consumer.py -C $RESET_DIR/restore.conf -I