from sqlmodel import Session, select

from app.models import Persona


class PersonaRepository:
    def __init__(self, session: Session):
        self.session = session

    def get_active(self) -> list[Persona]:
        return list(self.session.exec(
            select(Persona)
            .where(Persona.active == 1)
            .order_by(Persona.sort_order)  # type: ignore
        ).all())