from sqlalchemy import and_
from models.database import DATABASE_NAME, Session
import create_database as db_creator
from models.lesson import Lesson, association_table
from models.student import Student
from models.group import Group
if __name__ == '__main__':
db_is_created = os.path.exists(DATABASE_NAME)
if not db_is_created:
db_creator.create_database()
session = Session()
for it in session.query(Lesson):
print(it)
print('*' * 30)
for it in session.query(Lesson).filter(Lesson.id > 3):
print(it)
print('*' * 30)
for it in session.query(Lesson).filter(
and_(Lesson.id >= 3, Lesson.lesson_title.like('Ф%'))):
print(it)
print('*' * 30)
for it in session.query(Student).join(Group).filter(
Group.group_name == '1-МДА-9'):
print(it)
print('*' * 30)
for it, gr in session.query(Student, Group):
print(it, gr)
def get_department(id: str):
session = Session()
dep_out = session.query(Department).filter(Department.id == id).first()
return dep_out
def get_department_objects(id: str):
session = Session()
obj_out = session.query(Object).join(Department).filter(
Department.id == id).all()
obj_list = schemas.ObjectList(objects=obj_out)
return obj_list
def get_departments():
session = Session()
dep_out = session.query(Department).all()
dep_list = schemas.DepartmentList(departments=dep_out)
return dep_list