Function getTotalRows

src/services/sql.ts:54–67

(engine: DatabaseEngine, dialect: KnexClientType, connection: knexlib.Knex | null, table: string, columns: Column[], whereClause?: Record<string, any>)

	},

	async getTotalRows(engine: DatabaseEngine, dialect: KnexClientType, connection: knexlib.Knex | null, table: string, columns: Column[], whereClause?: Record<string, any>): Promise<number> {
		if (!connection) return 0;

		let query = connection(table);

		if (whereClause) {
			const conditions = buildWhereClause(engine, dialect, whereClause, columns)
			query = applyConditionToQuery(query, conditions)
		}

		const result = await query.count('* as count');

		return (result[0])?.count as number;
	},

	async commitChange(connection: knexlib.Knex | null, serializedMutation: SerializedMutation, transaction?: knexlib.Knex.Transaction, openDelimiter: string = '`'): Promise<void> {
		if (!connection) return;