Method count

packages/sql/src/query/QueryBuilder.ts:975–989

* Creates a COUNT query to count matching rows. * * @example * ```ts * const count = await em.createQueryBuilder(User) * .count() * .where({ isActive: true }) * .execute('get'); * ```

(field?: F | F[], distinct = false)

   * ```
   */
  count<F extends Field<Entity, RootAlias, Context>>(field?: F | F[], distinct = false): CountQueryBuilder<Entity> {
    if (field) {
      this.#state.fields = Utils.asArray(field as string);
    } else if (distinct || this.hasToManyJoins()) {
      this.#state.fields = this.mainAlias.meta.primaryKeys;
    } else {
      this.#state.fields = [raw('*')];
    }

    if (distinct) {
      this.#state.flags.add(QueryFlag.DISTINCT);
    }

    return this.init(QueryType.COUNT) as unknown as CountQueryBuilder<Entity>;
  }

  /**
   * Adds a JOIN clause to the query for an entity relation.