Method rawQuery

src/database-engines/sqlite-engine.ts:425–465

(code: string)

  }

  async rawQuery(code: string): Promise<any> {
    try {
      const db = this.getConnection();
      if (!db) {
        return Promise.reject('Cannot connect to database')
      }

      return new Promise<any>((resolve, reject) => {
        // Determine if the query is a SELECT or PRAGMA statement
        const isSelect = /^\s*(SELECT|PRAGMA)\s+/i.test(code);

        if (isSelect) {
          db.all(code, (err, rows) => {
            if (err) {
              reportError(`SQLite run arbitrary query error: ${err}`);
              reject(err);
              return;
            }
            resolve(rows);
          });
        } else {
          db.run(code, function (err) {
            if (err) {
              reportError(`SQLite run arbitrary query error: ${err}`);
              reject(err);
              return;
            }

            // For non-SELECT queries, return information about the operation
            resolve({
              changes: this.changes,
              lastID: this.lastID
            });
          });
        }
      });
    } catch (err) {
      reportError(`SQLite run arbitrary query error: ${err}`);
      throw err;
    }
  }

  async beginTransaction(): Promise<Database> {
    try {