forked from mozilla-releng/balrog
-
Notifications
You must be signed in to change notification settings - Fork 5
/
initdb_and_run.sh
executable file
·26 lines (20 loc) · 1.75 KB
/
initdb_and_run.sh
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
set -xe
export LOCAL_DUMP="/app/scripts/prod_db_dump.sql"
if [ ! -e /app/$CACHEDIR/mysql/db.done ]; then
echo "Initializing DB..."
python scripts/get-prod-db-dump.py
xz -d -c $LOCAL_DUMP | mysql -h $DB_HOST -u balrogadmin --password=balrogadmin balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into permissions (username, permission, options, data_version) values ("balrogagent", "scheduled_change", "{\"actions\": [\"enact\"]}", 1)' balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into permissions (username, permission, options, data_version) values ("bob@mozilla.com", "release", "{\"actions\": [\"get\"]}", 1)' balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into permissions (username, permission, options, data_version) values ("janet@mozilla.com", "release", "{\"actions\": [\"get\"]}", 1)' balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into user_roles (username, role, data_version) values ("bob@mozilla.com", "releng", 1);' balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into user_roles (username, role, data_version) values ("janet@mozilla.com", "releng", 1);' balrog
mysql -h $DB_HOST -u balrogadmin --password=balrogadmin -e 'insert into product_req_signoffs (product, channel, role, signoffs_required, data_version) values ("Firefox", "release", "releng", 1, 1);' balrog
touch /app/$CACHEDIR/mysql/db.done
echo "Done"
fi
# We need to try upgrading even if the database was freshly created, because it
# may use sample data from an older version.
python scripts/manage-db.py -d mysql://balrogadmin:balrogadmin@$DB_HOST/balrog upgrade
# run the command passed from docker
/app/scripts/run.sh $@