HarmonyOS relationalStore 自动更新字段当前时间

创建一个 TRIGGER去更新时间

建表语句：

CREATE TABLE IF NOT EXISTS shopCardTable(id INTEGER PRIMARY KEY AUTOINCREMENT,description TEXT,showtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP)
1.

TRIGGER语句

let sql = 'CREATE TRIGGER IF NOT EXISTS test AFTER UPDATE OF id,description\n' +
  'ON shopCardTable\n' +
  'FOR EACH ROW BEGIN UPDATE shopCardTable \n' +
  'SET showtime = CURRENT_TIMESTAMP WHERE rowid = NEW.rowid;\n' +
  'END;'
this.rdbStore.executeSql(sql)
1.
2.
3.
4.
5.
6.