import sqlalchemy as sa
from anydi import singleton

from app.adapters.db.repositories import PgRepository

from .models import TwilioAccount


@singleton
class TwilioAccountRepository(PgRepository[TwilioAccount]):
    def get_by_account_sid(self, account_sid: str) -> TwilioAccount | None:
        query = sa.select(TwilioAccount).where(TwilioAccount.account_sid == account_sid)
        result = self.db.session.execute(query).scalar_one_or_none()
        return result