Skip to content

Instantly share code, notes, and snippets.

@ddmitov

ddmitov/sqlite-triggers.sql

Last active August 12, 2024 08:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ddmitov/dc19a325ea578ff8f9a7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ddmitov/dc19a325ea578ff8f9a7 to your computer and use it in GitHub Desktop.
Download ZIP
Example SQLite triggers
Raw
sqlite-triggers.sql
CREATE TRIGGER calculate_vat_insert AFTER INSERT ON inventory
BEGIN
UPDATE inventory SET PRICE_VAT = new.PRICE/100*20+new.PRICE WHERE id = new.id;
END;
CREATE TRIGGER calculate_vat_update UPDATE OF PRICE ON inventory
BEGIN
UPDATE inventory SET PRICE_VAT = new.PRICE/100*20+new.PRICE WHERE id = old.id;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment