summaryrefslogtreecommitdiff
path: root/schema/reloadtestdb.sh
blob: e839dcecfe0ba57e832ab1f21656646aa4cdd311 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#!/bin/bash -e

DB_NAME=${DB_NAME:-AUR}
DB_USER=${DB_USER:-aur}
# Password should allow empty definition
DB_PASS=${DB_PASS-aur}
DB_HOST=${DB_HOST:-localhost}
DATA_FILE=${DATA_FILE:-dummy-data.sql}

echo "Using database $DB_NAME, user $DB_USER, host $DB_HOST"

mydir=$(pwd)
if [ $(basename $mydir) != "schema" ]; then
	echo "you must be in the aurweb/schema directory to run this script"
	exit 1
fi

echo "recreating database..."
mysql -h $DB_HOST -u $DB_USER -p$DB_PASS < aur-schema.sql

if [ ! -f $DATA_FILE ]; then
	echo "creating dumy-data..."
	python3 gendummydata.py $DATA_FILE
fi

echo "loading dummy-data..."
mysql -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME < $DATA_FILE

echo "done."