def get_all() -> Tuple[Dict[str, Any], ...]:
"""
Get departments
-Input: ---
-Output:
*All the departments of the table
*None value if we cannot find the OID
"""
return query("SELECT * FROM Departments")
def get_all() -> Tuple[Dict[str, Any], ...]:
"""
Get subjects
-Input: ---
-Output:
*All the subjects of the table
*None value if we cannot find the OID
"""
return base_dal.query("SELECT * FROM Subjects")
def get_all() -> Tuple[Dict[str, Any], ...]:
"""
Get TeachingLoads
-Input: ---
-Output:
*All the TeachingLoads of the table
*None value if we cannot find the OID
"""
return base_dal.query("SELECT * FROM TeachingLoads")
def get_by_acronym(acronym: str) -> Optional[Dict[str, Any]]:
"""
Get subject by acronym
-Input:
*The acronym of the subject that we want to get
-Output:
*Only one subject
*None value if we cannot find the acronym
"""
q = "SELECT * FROM Subjects WHERE acronym = %s"
params = (acronym, )
res: Tuple[Dict[str, Any], ...] = base_dal.query(q, params)
return res[0] if res else None
def get_by_name(name: str) -> Optional[Dict[str, Any]]:
"""
Get subject by name
-Input:
*The name of the subject that we want to get
-Output:
*Only one subject
*None value if we cannot find the name
"""
q = "SELECT * FROM Subjects WHERE name = %s"
params = (name, )
res: Tuple[Dict[str, Any]] = base_dal.query(q, params)
return res[0] if res else None
def get_by_oid(oid: int) -> Optional[Dict[str, Any]]:
"""
Get subject by OID
-Input:
*The OID of the subject that we want to get
-Output:
*Only one subject
*None value if we cannot find the OID
"""
q = "SELECT * FROM Subjects WHERE subjectId = %s"
params = (oid, )
res: Tuple[Dict[str, Any], ...] = base_dal.query(q, params)
return res[0] if res else None
def get_by_email(email: str) -> Optional[Dict[str, Any]]:
"""
Get professor by email
-Input:
*The name of the professor that we want to get
-Output:
*Only one professor
*None value if we cannot find the email
"""
q = "SELECT * FROM Professors WHERE email = %s"
params = (email,)
res: Tuple[Dict[str, Any]] = base_dal.query(q, params)
return res[0] if res else None
def get_by_name(name: str) -> Optional[Tuple[Dict[str, Any], ...]]:
"""
Get department by name
-Input:
*The name of the department that we want to get
-Output:
*Only one department
*None value if we cannot find the name
"""
q = "SELECT * FROM Department WHERE name = %s"
params = (name, )
res: Tuple[Dict[str, Any]] = query(q, params)
return res[0] if res else None
def get_by_oid(oid: int) -> Optional[Dict[str, Any]]:
"""
Get departments by OID
-Input:
*The OID of the department that we want to get
-Output:
*Only one department
*None value if we cannot find the OID
"""
q = "SELECT * FROM Departments WHERE departmentId = %s"
params = (oid, )
res: Tuple[Dict[str, Any], ...] = query(q, params)
return res[0] if res else None
def get_by_classroom_id(classroom_id: int) -> Optional[Dict[str, Any]]:
"""
Get groups by classroom_id
-Input:
*The classroom_id of the groups that we want to get
-Output:
*The groups which classroom_id is the same as received as parameter
*None value if we cannot find the name
"""
q = "SELECT * FROM Groups WHERE classroomId = %s"
params = (classroom_id, )
res: Tuple[Dict[str, Any]] = base_dal.query(q, params)
return res if res else None
def get_by_oid(oid: int) -> Optional[Dict[str, Any]]:
"""
Get TeachingLoad by OID
-Input:
*The OID of the TeachingLoad that we want to get
-Output:
*Only one TeachingLoad
*None value if we cannot find the OID
"""
q = "SELECT * FROM TeachingLoads WHERE teachingLoadId = %s"
params = (oid, )
res: Tuple[Dict[str, Any], ...] = base_dal.query(q, params)
return res[0] if res else None
def get_by_department(department_id: int):
q = "SELECT * FROM Professors WHERE departmentId = %s"
params = (department_id,)
return base_dal.query(q, params)
def get_by_year(year: int) -> Tuple[Dict[str, Any]]:
q = "SELECT * FROM Groups WHERE year = %s"
params = (year, )
return base_dal.query(q, params)
def get_by_professor_id(professor_id: int) -> Tuple[Dict[str, Any]]:
q = "SELECT * FROM TeachingLoads WHERE professorId = %s"
params = (professor_id, )
return base_dal.query(q, params)