Method saveToDB

keyword/keyword.ts:440–472

()

        task_id, cid, key, msg, include, regexp, exact, case_sensitive,
        ignore_forward, reply, delete_msg, ban, restrict, delay_delete, source_delay_delete
      ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    `);

    const deleteStmt = db.prepare("DELETE FROM keyword_tasks");
    deleteStmt.run();

    for (const task of this.tasks) {
      stmt.run(
        task.task_id,
        task.cid,
        task.key,
        task.msg,
        task.include ? 1 : 0,
        task.regexp ? 1 : 0,
        task.exact ? 1 : 0,
        task.case ? 1 : 0,
        task.ignore_forward ? 1 : 0,
        task.reply ? 1 : 0,
        task.delete ? 1 : 0,
        task.ban,
        task.restrict,
        task.delay_delete,
        task.source_delay_delete
      );
    }
  }

  loadFromDB(): void {
    if (!db) return;

    const stmt = db.prepare("SELECT * FROM keyword_tasks");
    const rows = stmt.all() as any[];

    this.tasks = rows.map(
      (row) =>
        new KeywordTask({