Method getTotalRows

src/database-engines/sqlite-engine.ts:253–288

(
    table: string,
    columns: Column[],
    whereClause?: Record<string, any>
  )

  }

  async getTotalRows(
    table: string,
    columns: Column[],
    whereClause?: Record<string, any>
  ): Promise<number> {
    try {
      const db = this.getConnection();
      if (!db) {
        return Promise.reject('Cannot connect to database')
      }

      let query = `SELECT COUNT(*) as count FROM ${this.escapeIdentifier(table)}`;
      const params: any[] = [];

      if (whereClause && Object.keys(whereClause).length > 0) {
        const { whereString, whereParams } = this.buildWhereClause(whereClause, columns);
        query += whereString.trim() ? ` WHERE ${whereString}` : '';
        params.push(...whereParams);
      }

      return new Promise<number>((resolve, reject) => {
        db.get(query, params, (err, row: any) => {
          if (err) {
            reportError(`SQLite get total rows error: ${err}`);
            reject(err);
            return;
          }

          resolve(row ? row.count : 0);
        });
      });
    } catch (err) {
      reportError(`SQLite get total rows error: ${err}`);
      return 0;
    }
  }

  async getRows(table: string, columns: Column[], limit: number, offset: number, whereClause?: Record<string, any>): Promise<QueryResponse | undefined> {
    try {