import sqlalchemy as sa

from dmp.adapters.db import ReportingRepository
from dmp.text_campaigns.models import ArtistPhoneNumber


class ArtistPhoneNumberRepository(ReportingRepository[ArtistPhoneNumber]):
    def exists_by_id(self, global_participant_id: str) -> bool:
        query = sa.select(
            sa.select(1)
            .exists()
            .where(ArtistPhoneNumber.global_participant_id == global_participant_id)
        )
        result = self.db.session.execute(query)
        return bool(result.scalar_one())