"""Vendor model in Neo4j."""

from connector_neo4j import get_session


def get_recent_awal_artist(vendor_id):
    """Fetch recent AWAL artist signups."""
    session = get_session()
    result = session.run(
        """
            MATCH(v:Vendor)<-[:HAS_LABEL]-(cb:CompanyBrand{name:"awal"})
            MATCH(v)-[:IN_SERVICE_TIER]->(st:ServiceTier { uuid:"5f2bd4fc-df94-4f35-97d3-ef23f8573279" })
            MATCH(v)-[:HAS_LABEL_PARTICIPANT]->(lp:LabelParticipant)
            WHERE date(v.createdAt) > date() - duration('P365D')
            AND v.id = $vendor_id
            RETURN lp
            ORDER BY lp.createdAt ASC
            LIMIT 1
        """,
        vendor_id=vendor_id,
    )
    artist = result.single()
    if artist is None:
        return ''
    return artist['lp']['name']