run.sh 669 Bytes
Newer Older
Stefan Vercillo's avatar
Stefan Vercillo committed
1
2
3
4
5
6
7
#!/bin/bash

# ** README **
# Requirements:
# 1. mysql-connector pip module installed
# 2. local path to loading data files updated in script1
# 3. input your database name for the db_name variable
Stefan Vercillo's avatar
Stefan Vercillo committed
8
db_name="Education"
Stefan Vercillo's avatar
Stefan Vercillo committed
9
user="snvercil"
Stefan Vercillo's avatar
Stefan Vercillo committed
10
password="pass"
Stefan Vercillo's avatar
Stefan Vercillo committed
11
12
13
14
15
16
17
18
19
20
21

mysql -u $user --password=$password --verbose --verbose $db_name < "script1.sql"
mysql -u $user --password=$password --verbose --verbose $db_name < "script2.sql"
mysql -u $user --password=$password --verbose --verbose $db_name < "script3.sql"

# # tested up to there ^
python3 update_course_offering_date.py
python3 update_imd_band.py

mysql -u $user --password=$password --verbose --verbose $db_name < "script4.sql"