aboutsummaryrefslogtreecommitdiffstats
path: root/testing/homer-api/homer_db_init
blob: c80328ac6aed586df19c355c51088cb89d28d88d (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
#!/bin/sh -e

# HOMER database setup script
# Copyright (c) 2017 Kaarle Ritvanen

exec_sql() {
	mysql $2 < /usr/share/homer-db/$1.sql
}

exec_sql homer_databases
exec_sql homer_user

for db in configuration data statistic; do
	exec_sql schema_$db homer_$db
done

homer_rotate

[ "$1" = -r ] || exit 0

mysql <<EOF
CREATE USER 'homer_user' IDENTIFIED BY 'homer_password';
GRANT SELECT ON homer_data.* TO 'homer_user';
EOF