I've noticed that MySQL Triggers do not get formatted correctly. Any idea why this is

This simple input: <div class="snippet-clipboard-content notranslate position-rela

MySQL Trigger Support about sql-formatter HOT 4 CLOSED

Gerst20051 commented on August 24, 2024

MySQL Trigger Support

from sql-formatter.

Comments (4)

nene commented on August 24, 2024 1

Yep, as I said, there's currently no support for the delimiter syntax, and no plans of adding.

Sorry, I don't really have much time or motivation to significantly improve this library.

from sql-formatter.

nene commented on August 24, 2024 1

Closing this for now, as no plans for supporting stored procedures.

from sql-formatter.

nene commented on August 24, 2024

Depends on your definition of correct. Which input do you provide and which output do you get? What would you expect instead?

Most likely it's because there really hasn't been put any effort into supporting procedures and functions. Plus there's no support for changing the delimiter.

from sql-formatter.

Gerst20051 commented on August 24, 2024

This simple input:


DELIMITER $$


-- conveniencefee


CREATE TRIGGER conveniencefee_insert_data_sync_queue
AFTER INSERT ON conveniencefee FOR EACH ROW
BEGIN
  CALL sendToSyncQueue("operator", NEW.operator_id, "UPDATE");
  CALL sendToSyncQueue("zone_rate", NEW.zone_id, "UPDATE");
END;
$$

CREATE TRIGGER conveniencefee_update_data_sync_queue
AFTER UPDATE ON conveniencefee FOR EACH ROW
BEGIN
  CALL sendToSyncQueue("operator", NEW.operator_id, "UPDATE");
  CALL sendToSyncQueue("zone_rate", NEW.zone_id, "UPDATE");
END;
$$

CREATE TRIGGER conveniencefee_delete_data_sync_queue
BEFORE DELETE ON conveniencefee FOR EACH ROW
BEGIN
  CALL sendToSyncQueue("operator", OLD.operator_id, "UPDATE");
  CALL sendToSyncQueue("zone_rate", OLD.zone_id, "UPDATE");
END;
$$


DELIMITER ;

produces this output:

DELIMITER $ $ -- conveniencefee
CREATE TRIGGER conveniencefee_insert_data_sync_queue
AFTER
INSERT
  ON conveniencefee FOR EACH ROW BEGIN CALL sendToSyncQueue("operator", NEW.operator_id, "UPDATE");
CALL sendToSyncQueue("zone_rate", NEW.zone_id, "UPDATE");
END;
$ $ CREATE TRIGGER conveniencefee_update_data_sync_queue
AFTER
UPDATE
  ON conveniencefee FOR EACH ROW BEGIN CALL sendToSyncQueue("operator", NEW.operator_id, "UPDATE");
CALL sendToSyncQueue("zone_rate", NEW.zone_id, "UPDATE");
END;
$ $ CREATE TRIGGER conveniencefee_delete_data_sync_queue BEFORE DELETE ON conveniencefee FOR EACH ROW BEGIN CALL sendToSyncQueue("operator", OLD.operator_id, "UPDATE");
CALL sendToSyncQueue("zone_rate", OLD.zone_id, "UPDATE");
END;
$ $ DELIMITER;

I can provide more complicated examples if this gets addressed.

from sql-formatter.

Recommend Projects