from src.models import TeacherTable
from src import db
from sqlalchemy import Select


def find_teacher_by_username(username):
    stmt = Select(TeacherTable).where(TeacherTable.username == username)
    teacher = db.session.execute(stmt).scalar_one_or_none()
    return teacher


def find_teacher_by_id(id):
    stmt = Select(TeacherTable).where(TeacherTable.id == id)
    teacher = db.session.execute(stmt).scalar_one_or_none()
    return teacher