DEV Community

Discussion on: What Did You Learn This Week --May 22?

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt • Edited

SQLite trigger. Mostly for ON UPDATE, actually.

    CREATE TRIGGER IF NOT EXISTS deck_on_update
      AFTER UPDATE ON deck
      WHEN
        OLD.date_created <> NEW.date_created
    BEGIN
      UPDATE deck
      SET date_updated = strftime('%Y-%m-%dT%H:%M:%fZ', 'now')
      WHERE [uid] = NEW.uid;
    END;

Also, better SQLite CURRENT_TIMESTAMP, to be inline with JavaScript's new Date().toISOString().

date_created  TEXT DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),
Collapse
 
waylonwalker profile image
Waylon Walker

I have never created a TRIGGER ini SQL