run.sh 646 Bytes
Newer Older
Richard's avatar
script  
Richard 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
Richard's avatar
Richard committed
8
# 4. update connection info inside the python scripts
Richard's avatar
script  
Richard committed
9
10
11
12
13
14
15
16
db_name="ece356"

mysql -u root --verbose --verbose $db_name < "scripts/script1.sql"
mysql -u root --verbose --verbose $db_name < "scripts/script2.sql"
mysql -u root --verbose --verbose $db_name < "scripts/script3.sql"

#tested up to there ^
python3 scripts/update_course_offering_date.py
Richard's avatar
Richard committed
17
python3 scripts/update_imd_band.py
Richard's avatar
script  
Richard committed
18
19
20
21
mysql -u root --verbose --verbose $db_name < "scripts/script4.sql"