upgrade/account/update.sh

   1 #!/bin/bash
   2
   3 . ../inc/pervasive.sh
   4
   5 ###########################################################
   6 [ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat"
   7
   8 echo "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
   9 echo "* press ^D to start import (^C to cancel)"
  10 cat
  11
  12 echo -n "* create database "
  13 (echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | $MYSQL) || die "ERROR"
  14 echo "OK"
  15
  16 echo -n "* copying tables "
  17 ./copy_tables.php || die "ERROR"
  18 echo "OK"
  19
  20 for sql in ../newdirectory-0.0.1/*.sql
  21 do
  22     echo -n "* running $sql "
  23     (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE >/dev/null) || die "ERROR"
  24     echo "OK"
  25 done
  26
  27 for sql in *.sql
  28 do
  29     echo -n "* running $sql "
  30     (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE >/dev/null) || die "ERROR"
  31     echo "OK"
  32 done
  33
  34 ###########################################################
  35 echo -n "Importing phone numbers "
  36
  37 ../newdirectory-0.0.1/phones.php || die "ERROR"
  38 echo "OK"
  39
  40 ###########################################################
  41 echo "Updating birthday dates "
  42
  43 ./birthday.php || die "ERROR"
  44 echo "OK"