from migrations.fixtures.delphi_tables.v1.triggers.base_trigger import BaseTrigger


class CampaignProviderTrigger(BaseTrigger):
    table = "CampaignProvider"
    function_name = 'log_campaign_provider_changes'

    def on_insert(self):
        return "INSERT INTO campaign_provider(id, name) VALUES(NEW.id, NEW.name);"

    def on_update(self):
        return "UPDATE campaign_provider SET name = NEW.name WHERE id = NEW.id;"

    def on_delete(self):
        return "DELETE FROM campaign_provider WHERE id = OLD.id;"