def create_table_students(db_name): with dbContext.DbContext(db_name) as db: create_table_query = """ CREATE TABLE students ( student_id INTEGER PRIMARY KEY, faculty TEXT NOT NULL, student_group TEXT NOT NULL, marks INTEGER, student_ticket INTEGER NOT NULL )""" db.execute(create_table_query)
def get_excellent_students_list(self): with dbContext.DbContext(self._db_name) as db: sql = 'select * from students where marks=\'5\'' query_response = db.execute(sql) return query_response.fetchall()
def get_student_by_ticket_number(self, ticket_number): with dbContext.DbContext(self._db_name) as db: sql = f'select * from students where student_ticket=\'{ticket_number}\'' query_response = db.execute(sql) return query_response.fetchall()
def get_all_students_list(self): with dbContext.DbContext(self._db_name) as db: sql = 'select * from students' query_response = db.execute(sql) return query_response.fetchall()
def add_student(self, faculty, group, student_ticket): with dbContext.DbContext(self._db_name) as db: sql = 'insert into students (faculty, student_group, marks, student_ticket) values(?, ?, ?, ?)' db.execute(sql, [faculty, group, None, str(student_ticket)])
def change_student_by_ticket_number(self, what_to_change, replacement, ticket_number): with dbContext.DbContext(self._db_name) as db: sql = f'update students set {what_to_change}=\'{replacement}\' where student_ticket=\'{ticket_number}\'' db.execute(sql)