egg-sequelize-ts的crud操作

// service/project.ts
import {
    Service } from 'egg';
import {
    ICountOptions, IFindOptions } from 'sequelize-typescript';
import {
    Project } from '../model/project';
import CommUtil from '../util/CommUtil';

/**
 * ProjectService
 * @author pan
 * @date 2021-07-11
 */
export default class ProjectService extends Service {
   

  /**
   * 分页查找
   * @param page 页号
   * @param size 分页大小
   **/
  public async findPage(page = 1, size = 10) {
   
    const {
    ctx } = this;
    const {
    model } = ctx;

    // 获取总记录数
    const countQueryCondition = {
   
      col: 'id',
    } as ICountOptions<Project>;
    const total = await model.Project.count(countQueryCondition);
    const totalPage = CommUtil.totalPage