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)