diesel 1.4.2

A safe, extensible ORM and Query Builder for PostgreSQL, SQLite, and MySQL
Documentation
1
2
3
4
5
6
7
8
9
10
11
CREATE TRIGGER __diesel_manage_updated_at_{table_name}
AFTER UPDATE ON {table_name}
FOR EACH ROW WHEN
  old.updated_at IS NULL AND
  new.updated_at IS NULL OR
  old.updated_at == new.updated_at
BEGIN
  UPDATE {table_name}
  SET updated_at = CURRENT_TIMESTAMP
  WHERE ROWID = new.ROWID;
END