AuctionBase/createDatabase.sh at master · abbytse/AuctionBase · GitHub

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/bash

echo "Running create.sql..."
sqlite3 auction.db < create.sql
echo "Running load.txt..."
sqlite3 auction.db < load.txt
echo "Running constraints_verify.sql..."
sqlite3 auction.db < constraints_verify.sql
echo "Running trigger1_add.sql..."
sqlite3 auction.db < ./Triggers/trigger1_add.sql
echo "Running trigger2_add.sql..."
sqlite3 auction.db < ./Triggers/trigger2_add.sql
echo "Running trigger3_add.sql..."
sqlite3 auction.db < ./Triggers/trigger3_add.sql
echo "Running trigger4_add.sql..."
sqlite3 auction.db < ./Triggers/trigger4_add.sql
echo "Running trigger5_add.sql..."
sqlite3 auction.db < ./Triggers/trigger5_add.sql
echo "Running trigger6_add.sql..."
sqlite3 auction.db < ./Triggers/trigger6_add.sql
echo "Running trigger7_add.sql..."
sqlite3 auction.db < ./Triggers/trigger7_add.sql
echo "Running createStatus.py..."
python createStatus.py