def consult_all_teacher():
sql = "SELECT * FROM teacher"
result = database.consult(sql)
if result:
return to_dic(result)
return []
def consult_single_teacher(id: str):
sql = "SELECT * FROM teacher WHERE id_teacher = ?"
result = database.consult(sql, (id, ))
if result:
return to_dic(result)[0]
return False
def consult_all_subject():
sql = "SELECT * FROM SUBJECT"
result = database.consult(sql)
if result:
return to_dic(result)
return []
def consult_single_subject(id: str):
sql = "SELECT * FROM subject WHERE id_subject = ?"
result = database.consult(sql, (id, ))
if result:
return to_dic(result)[0]
return False
def consult_all_student():
sql = "SELECT * FROM student"
result = database.consult(sql, None)
if result:
return to_dic(result)
return []
def consult_single_student(id: str):
sql = "SELECT * FROM student WHERE id_student = ?"
result = database.consult(sql, (id, ))
if result:
return to_dic(result)[0]