import mysql.connector
from datetime import datetime.
from connection import connection.
from student import Student.
from teacher import Teacher.
class DbManager:
def __init__(self,connection):
self.connection1 = connection.
self.cursor1 = self.connection1.cursor()
def getStudentById(self, id):
sql = "select * from student where id = %s"
value = (id,)
self.cursor.execute(sql,value)
try:
obj = self.cursor.fetchone()
return Student(obj[0],obj[1],obj[2],obj[3],obj[4],obj[5],obj[6])
except mysql.connector.Error as err:
print("error:",err)
def getStudentsByClassId(self, id):
pass.
def addstudent(self, student: Student):
pass.
def editstudent(self, student: Student):
pass.
def addteacher(self, teacher: Teacher):
pass.
def editteacher(self, teacher: Teacher):
pass.
db = DbManager()
student = db.getStudentById(2)
print(student.name)
print(student.surname)