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


class LabelTrigger(BaseTrigger):
    table = "Label"
    function_name = "log_label_changes"

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

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

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