分页查询

梗概

• 从指定位置开始读若干个数据

示例

  /**
   * 分页查询
   * @param collection
   * @param pageIndex
   * @param pageSize
   * @param condition
   * @param selection
   * @returns
   */
  async selectForPage(
    collection: number,
    pageIndex = 1,
    pageSize = 10,
    condition: FindManyOptions<ChapterEntity>["where"] = {},
    selection?: FindManyOptions<ChapterEntity>["select"],
  ) {
    const options: FindManyOptions<ChapterEntity> = {
      skip: pageSize * (pageIndex - 1),
      take: pageSize,
      where: { collectionId: collection, ...condition },
    };
    if (selection) {
      options.select = selection;
    }
    return this.chapterRepo.find(options);
  }

• child::NestJs