Spaces:
Build error
Build error
File size: 8,586 Bytes
46be47d |
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 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 |
import sqlite3
# Connect to sqlite
connection = sqlite3.connect("database/student.db")
# Create a cursor object to create table, insert record and retrieve
cursor = connection.cursor()
# Create the table
table_info = """ create table if not exists STUDENT (
ID_STU integer primary key not null,
NAME_STU nvarchar(30),
BIRTHDAY_STU date,
BIRTHPLACE_STU nvarchar(100))"""
cursor.execute(table_info)
table_info = """ create table if not exists LECTURER (
ID_LEC integer primary key not null,
NAME_LEC nvarchar(30),
BIRTHDAY_LEC date,
BIRTHPLACE_LEC nvarchar(100))"""
cursor.execute(table_info)
table_info = """create table if not exists COURSE (
ID_COU integer primary key not null,
NAME_COU nvarchar(100),
ID_LEC integer,
foreign key (ID_LEC) references LECTURER(ID_LEC))"""
cursor.execute(table_info)
table_info = """create table if not exists REGISTRATION_FORM (
ID_REG integer primary key not null,
ID_COU integer,
ID_STU integer,
foreign key (ID_COU) references COURSE(ID_COU),
foreign key (ID_STU) references STUDENT(ID_STU))"""
cursor.execute(table_info)
# Insert some records
connection.execute("PRAGMA foreign_keys = ON")
cursor.execute(
"""insert into STUDENT values (1, 'Đặng Tuấn Anh','1999-08-08', 'Hải Phòng');"""
)
cursor.execute(
"""insert into STUDENT values (2, 'Hoàng Đức Anh','1999-08-09', 'Hà Nội');"""
)
cursor.execute(
"""insert into STUDENT values (3, 'Lưu Trang Anh','1999-08-10', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into STUDENT values (4, 'Phạm Hoàng Anh','2000-08-11', 'Nam Định');"""
)
cursor.execute(
"""insert into STUDENT values (5, 'Phạm Thị Hiền Anh','2000-07-12', 'Hưng Yên');"""
)
cursor.execute(
"""insert into STUDENT values (6, 'Phạm Khắc Việt Anh','2000-07-13', 'Hải Phòng');"""
)
cursor.execute(
"""insert into STUDENT values (7, 'Đỗ Hoàng Gia Bảo','2000-07-14', 'Hà Nội');"""
)
cursor.execute(
"""insert into STUDENT values (8, 'Trần Thị Minh Châu','1998-07-15', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into STUDENT values (9, 'Tăng Phương Chi','1998-09-16', 'Nam Định');"""
)
cursor.execute(
"""insert into STUDENT values (10, 'Gan Feng Du','1998-09-17', 'Hưng Yên');"""
)
cursor.execute(
"""insert into STUDENT values (11, 'Phạm Tiến Dũng','1998-09-19', 'Hải Phòng');"""
)
cursor.execute(
"""insert into STUDENT values (12, 'Nguyễn Thái Dương','1997-09-19', 'Hà Nội');"""
)
cursor.execute(
"""insert into STUDENT values (13, 'Trần An Dương','1997-05-20', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into STUDENT values (14, 'Mạc Trung Đức','1997-05-21', 'Nam Định');"""
)
cursor.execute(
"""insert into STUDENT values (15, 'Vũ Hương Giang','1997-05-22', 'Hưng Yên');"""
)
cursor.execute(
"""insert into STUDENT values (16, 'Nguyễn Thị Ngân Hà','1997-01-23', 'Hải Phòng');"""
)
cursor.execute(
"""insert into STUDENT values (17, 'Nguyễn Lê Hiếu','1996-01-24', 'Hà Nội');"""
)
cursor.execute(
"""insert into STUDENT values (18, 'Phạm Xuân Hòa','1996-01-25', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into STUDENT values (19, 'Khoa Minh Hoàng','1996-01-26', 'Nam Định');"""
)
cursor.execute(
"""insert into STUDENT values (20, 'Nguyễn Hữu Hiệp Hoàng','1996-01-27', 'Hưng Yên');"""
)
cursor.execute(
"""insert into STUDENT values (21, 'Nguyễn Văn A', '2000-09-25', 'Hải Phòng')"""
)
cursor.execute("""insert into STUDENT (ID_STU, BIRTHPLACE_STU) values (22, 'Hà Nội')""")
cursor.execute(
"""insert into LECTURER values (1, 'Đặng Quốc Việt','1987-7-01', 'Hải Phòng');"""
)
cursor.execute(
"""insert into LECTURER values (2, 'Hoàng Văn Bảo','1987-7-02', 'Hà Nội');"""
)
cursor.execute(
"""insert into LECTURER values (3, 'Lưu Thanh Tuấn','1987-7-03', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into LECTURER values (4, 'Hoàng Thị Thanh Mai','1987-7-04', 'Nam Định');"""
)
cursor.execute(
"""insert into LECTURER values (5, 'Nguyễn Quỳnh Hoa','1987-7-05', 'Hưng Yên');"""
)
cursor.execute(
"""insert into LECTURER values (6, 'Cao Thị Xuân Dung','1992-6-06', 'Hải Phòng');"""
)
cursor.execute(
"""insert into LECTURER values (7, 'Đỗ Hồng Việt','1992-6-07', 'Hà Nội');"""
)
cursor.execute(
"""insert into LECTURER values (8, 'Phạm Thị Thu Hương','1992-6-08', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into LECTURER values (9, 'Bùi Thị Vân Thiện','1992-6-6', 'Nam Định');"""
)
cursor.execute(
"""insert into LECTURER values (10, 'Nguyễn Thị Thu Hiền','1990-5-10', 'Hưng Yên');"""
)
cursor.execute(
"""insert into LECTURER values (11, 'Nguyễn Thị Trà My','1990-5-11', 'Hải Phòng');"""
)
cursor.execute(
"""insert into LECTURER values (12, 'Trần Thị Thúy','1990-5-12', 'Hà Nội');"""
)
cursor.execute(
"""insert into LECTURER values (13, 'Trần Trọng Dũng','1990-5-13', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into LECTURER values (14, 'Mạc Văn Việt','1990-1-14', 'Nam Định');"""
)
cursor.execute(
"""insert into LECTURER values (15, 'Bùi Thị Thu Hương','1993-1-15', 'Hưng Yên');"""
)
cursor.execute(
"""insert into LECTURER values (16, 'Nguyễn Văn Đạm','1993-1-16', 'Hải Phòng');"""
)
cursor.execute(
"""insert into LECTURER values (17, 'Lê Thị Hợi','1993-1-17', 'Hà Nội');"""
)
cursor.execute(
"""insert into LECTURER values (18, 'Phạm Văn Cường','1993-2-18', 'Bắc Ninh');"""
)
cursor.execute(
"""insert into LECTURER values (19, 'Khoa Năng Tùng','1991-2-19', 'Nam Định');"""
)
cursor.execute("""insert into COURSE values (1,'Tester basic',1);""")
cursor.execute("""insert into COURSE values (2,'Tester advance',2);""")
cursor.execute("""insert into COURSE values (3,'Automation test',1);""")
cursor.execute("""insert into COURSE values (4,'API testing',4);""")
cursor.execute("""insert into COURSE values (5,'DB testing',5);""")
cursor.execute("""insert into COURSE values (6,'Performance testing',3);""")
cursor.execute("""insert into COURSE values (7,'GUI testing',7);""")
cursor.execute("""insert into COURSE values (8,'Mobile testing',8);""")
cursor.execute("""insert into COURSE values (9,'Game testing',9);""")
cursor.execute("""insert into REGISTRATION_FORM values (1,1,1);""")
cursor.execute("""insert into REGISTRATION_FORM values (2,2,2);""")
cursor.execute("""insert into REGISTRATION_FORM values (3,3,3);""")
cursor.execute("""insert into REGISTRATION_FORM values (4,4,4);""")
cursor.execute("""insert into REGISTRATION_FORM values (5,5,5);""")
cursor.execute("""insert into REGISTRATION_FORM values (6,6,6);""")
cursor.execute("""insert into REGISTRATION_FORM values (7,7,7);""")
cursor.execute("""insert into REGISTRATION_FORM values (8,8,8);""")
cursor.execute("""insert into REGISTRATION_FORM values (9,9,9);""")
cursor.execute("""insert into REGISTRATION_FORM values (10,1,10);""")
cursor.execute("""insert into REGISTRATION_FORM values (11,2,11);""")
cursor.execute("""insert into REGISTRATION_FORM values (12,3,12);""")
cursor.execute("""insert into REGISTRATION_FORM values (13,4,13);""")
cursor.execute("""insert into REGISTRATION_FORM values (14,5,14);""")
cursor.execute("""insert into REGISTRATION_FORM values (15,6,15);""")
cursor.execute("""insert into REGISTRATION_FORM values (16,7,16);""")
cursor.execute("""insert into REGISTRATION_FORM values (17,8,17);""")
cursor.execute("""insert into REGISTRATION_FORM values (18,9,18);""")
cursor.execute("""insert into REGISTRATION_FORM values (19,1,19);""")
cursor.execute("""insert into REGISTRATION_FORM values (20,2,20);""")
cursor.execute("""insert into REGISTRATION_FORM values (21,3,1);""")
cursor.execute("""insert into REGISTRATION_FORM values (22,4,2);""")
cursor.execute("""insert into REGISTRATION_FORM values (23,5,3);""")
cursor.execute("""insert into REGISTRATION_FORM values (24,6,4);""")
cursor.execute("""insert into REGISTRATION_FORM values (25,7,5);""")
cursor.execute("""insert into REGISTRATION_FORM values (26,8,6);""")
cursor.execute("""insert into REGISTRATION_FORM values (27,9,7);""")
cursor.execute("""insert into REGISTRATION_FORM values (28,1,8);""")
cursor.execute("""insert into REGISTRATION_FORM values (29,2,9);""")
cursor.execute("""insert into REGISTRATION_FORM values (30,3,10);""")
# Close the connection
connection.commit()
connection.close()
|