Commit | Line | Data |
---|---|---|
9d5e1087 FB |
1 | #!/bin/bash |
2 | ||
3 | . ../inc/pervasive.sh | |
4 | ||
5 | ########################################################### | |
d0293d9b FB |
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)" | |
9d5e1087 FB |
10 | cat |
11 | ||
d0293d9b FB |
12 | echo -n "* create database " |
13 | (echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | $MYSQL) || die "ERROR" | |
14 | echo "OK" | |
15 | ||
9d5e1087 FB |
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 " | |
d0293d9b | 23 | (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE >/dev/null) || die "ERROR" |
9d5e1087 FB |
24 | echo "OK" |
25 | done | |
26 | ||
27 | for sql in *.sql | |
28 | do | |
29 | echo -n "* running $sql " | |
d0293d9b | 30 | (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE >/dev/null) || die "ERROR" |
9d5e1087 FB |
31 | echo "OK" |
32 | done | |
33 | ||
34 | ########################################################### | |
35 | echo -n "Importing phone numbers " | |
36 | ||
d0293d9b | 37 | ../newdirectory-0.0.1/phones.php || die "ERROR" |
9d5e1087 FB |
38 | echo "OK" |
39 | ||
40 | ########################################################### | |
41 | echo "Updating birthday dates " | |
42 | ||
43 | ./birthday.php || die "ERROR" | |
44 | echo "OK" |