"""Snowflake Queries."""

CLEANUP_MANUFACTURED_UPCS = """
    UPDATE $db.$schema.MANUFACTURED_UPCS
    SET DELETED_AT=CURRENT_DATE(), DELETED_BY='lambda-documents-load-from-s3'
    WHERE DELETED_AT IS NULL AND DELETED_BY IS NULL
    AND STATEMENT_PERIOD_ID=$statement_period_id;
"""

INSERT_MANUFACTURED_UPCS = """
    INSERT INTO $db.$schema.MANUFACTURED_UPCS
    (STATEMENT_PERIOD_ID, UPC, CREATED_AT, CREATED_BY)
    VALUES $values;
"""