TeachersPetBot/initialize_db_script.py at main · War-Keeper/TeachersPetBot · 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
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
import sqlite3

conn = sqlite3.connect("db.sqlite")

c = conn.cursor()

SQL_STATEMENT = """CREATE TABLE ta_office_hours (
    guild_id    INT,
    ta          VARCHAR(50),
    day         INT,
    begin_hr    INT,
    begin_min   INT,
    end_hr      INT,
    end_min     INT
);"""

c.execute(SQL_STATEMENT)

SQL_STATEMENT = """CREATE TABLE exams (
    guild_id    INT,
    title       VARCHAR(50),
    desc        VARCHAR(300),
    date        VARCHAR(10),
    begin_hr    INT,
    begin_min   INT,
    end_hr      INT,
    end_min     INT
);"""

c.execute(SQL_STATEMENT)


SQL_STATEMENT = """CREATE TABLE assignments (
    guild_id    INT,
    title       VARCHAR(50),
    link        VARCHAR(300),
    desc        VARCHAR(300),
    date        VARCHAR(10),
    due_hr      INT,
    due_min     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.",
    "09-25-2021",
    18,
    30
);"""

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.",
    "09-26-2021",
    18,
    30
);"""

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.",
    "09-28-2021",
    18,
    30
);"""

c.execute(SQL_STATEMENT)

SQL_STATEMENT = """INSERT INTO exams VALUES(
    1,
    "Exam 1",
    "All materials up to the date of the exam.",
    "09-29-2021",
    10,
    30,
    11,
    30
);"""

c.execute(SQL_STATEMENT)

SQL_STATEMENT = """INSERT INTO exams VALUES(
    1,
    "Exam 2",
    "All materials up to the date of the exam, except material covered by previous exam.",
    "10-06-2021",
    16,
    30,
    18,
    30
);"""

c.execute(SQL_STATEMENT)

SQL_STATEMENT = """INSERT INTO exams VALUES(
    1,
    "Final Exam",
    "Final exam - covers everything taught!",
    "12-02-2021",
    14,
    30,
    18,
    30
);"""


c.execute(SQL_STATEMENT)

conn.commit()

conn.close()