forked from Ashwinshankar98/TeachersPetBot
-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathinitialize_db_script.py
More file actions
147 lines (115 loc) · 4.52 KB
/
initialize_db_script.py
File metadata and controls
147 lines (115 loc) · 4.52 KB
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
import sqlite3
conn = sqlite3.connect("db.sqlite")
c = conn.cursor()
SQL_STATEMENT = """CREATE TABLE IF NOT EXISTS ta_office_hours (
guild_id INT,
ta VARCHAR(50),
day VARCHAR(4),
begin_time DATETIME,
end_time DATETIME
)"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """CREATE TABLE IF NOT EXISTS exams (
guild_id INT,
title VARCHAR(50),
desc VARCHAR(300),
duration VARCHAR(15),
begin_date DATETIME,
end_date DATETIME
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """CREATE TABLE IF NOT EXISTS assignments (
guild_id INT,
title VARCHAR(50),
link VARCHAR(300),
desc VARCHAR(300),
date DATETIME
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """CREATE TABLE IF NOT EXISTS qna (
guild_id INT,
author VARCHAR(50),
answer VARCHAR(300),
qnumber INT
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO assignments VALUES(
1,
"Assignment #1",
"https://drive.google.com/assign1.html",
"Covers lecture material up to to the due date.",
"2021-09-25 18:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO assignments VALUES(
1,
"Assignment #1.2",
"https://drive.google.com/assign1.html",
"Covers lecture material up to to the due date.",
"2021-09-26 18:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """CREATE TABLE IF NOT EXISTS email_address (
author_id INT,
email_id VARCHAR(50),
is_active BOOLEAN NOT NULL CHECK (is_active IN (0, 1))
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO assignments VALUES(
1,
"Assignment #2",
"https://drive.google.com/assign2.html",
"Covers lecture material up to to the due date.",
"2021-09-28 18:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO exams VALUES(
1,
"Exam 1",
"All materials up to the date of the exam.",
"180 minutes",
"2021-09-29 10:30:00",
"2021-10-05 10:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO exams VALUES(
1,
"Exam 2",
"All materials after previous exam.",
"180 minutes",
"2021-10-06 16:30:00",
"2021-10-20 18:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO exams VALUES(
1,
"Final Exam",
"Final exam - covers everything taught!",
"180 minutes",
"2021-12-02 14:30:00",
"2021-12-02 18:30:00"
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO qna VALUES(
1,
"kailash98 s",
"Hello World",
1
);"""
c.execute(SQL_STATEMENT)
SQL_STATEMENT = """INSERT INTO qna VALUES(
1,
"kailash98 s",
"Hello",
2
);"""
SQL_STATEMENT = """INSERT INTO ta_office_hours VALUES(
1,
"kailash98 s",
"Mon",
"1900-01-01 14:30:00",
"1900-01-01 18:30:00"
);"""
c.execute(SQL_STATEMENT)
conn.commit()
conn.close()