src/api/selectors/user/get_user.py

from sqlmodel import select
from src.api.models.user import User
from sqlmodel.ext.asyncio.session import AsyncSession
from typing import Optional


async def get_user_by_email(email: str, db: AsyncSession) -> Optional[User]:
    email = email.lower()
    result = await db.exec(select(User).where(User.email == email))
    return result.first()

async def get_user_by_id(id: int, db: AsyncSession) -> Optional[User]:
    result = await db.exec(select(User).where(User.id == id))
    return result.first()