Method getCount

packages/sql/src/query/QueryBuilder.ts:2664–2688

(
    field?: Field<Entity, RootAlias, Context> | Field<Entity, RootAlias, Context>[],
    distinct?: boolean,
  )

   */
  async getCount<F extends Field<Entity, RootAlias, Context>>(field?: F | F[], distinct?: boolean): Promise<number>;
  async getCount(
    field?: Field<Entity, RootAlias, Context> | Field<Entity, RootAlias, Context>[],
    distinct?: boolean,
  ): Promise<number> {
    let res: { count: number };

    if (this.type === QueryType.COUNT) {
      res = await this.execute<{ count: number }>('get', false);
    } else {
      const qb = (this.#state.type === undefined ? this : this.clone()) as unknown as QueryBuilder<
        Entity,
        RootAlias,
        Hint,
        Context
      >;
      qb.processPopulateHint(); // needs to happen sooner so `qb.hasToManyJoins()` reports correctly
      qb.count(field, distinct ?? qb.hasToManyJoins())
        .limit(undefined)
        .offset(undefined)
        .orderBy([]);
      res = await qb.execute<{ count: number }>('get', false);
    }

    return res ? +res.count : 0;
  }

  /**
   * Executes the query, returning both array of results and total count query (without offset and limit).