import uuid

class GenerateQuery:
    def __init__(self):
         pass
    
    def generate_event_id(self, text: str, namespace_uuid: uuid.UUID = uuid.NAMESPACE_DNS) -> str:
        return str(uuid.uuid5(namespace_uuid, text))


    def getEvent(self,property_id:str, date_start:str, date_end:str):
        query = f"""SELECT 
    eventId,
    eventTimeStamp,
    eventName,
    user_pseudo_id,
    source
    FROM `customer-360-profile.client_{property_id}.event` 
    WHERE eventTimeStamp BETWEEN DATETIME("{date_start}") AND DATETIME("{date_end}")
    """
        return query