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

def find_principal_by_username(username):
    stmt = Select(PrincipalTable).where(PrincipalTable.username == username)
    principal = db.session.execute(stmt).scalar_one_or_none()
    return principal


def find_principal_by_id(principal_id):
    stmt = Select(PrincipalTable).where(PrincipalTable.id == principal_id)
    principal = db.session.execute(stmt).scalar_one_or_none()
    return principal