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


class CampaignObjectiveTrigger(BaseTrigger):
    table = "CampaignObjective"
    function_name = "log_campaign_objective_changes"

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

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

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