数据库分页排序

import { Injectable } from '@nestjs/common'
import { CreateLoginDto } from './dto/create-login.dto'
import { UpdateLoginDto } from './dto/update-login.dto'
import { Login } from './entities/login.entity'
import { InjectRepository } from '@nestjs/typeorm'
import { Like, Repository } from 'typeorm'

@Injectable()
export class LoginService {
  //
  constructor(@InjectRepository(Login) private readonly login: Repository<Login>) {}
  //
  findAll(query: { keyWord: string; page: number; pageSize: number }) {
    return this.login.find({
      where: { name: Like(`%${query.keyWord}%`) },
      skip: (query.page - 1) * query.pageSize,
      take: query.pageSize,
      order: { id: 'ASC' },
    })
  }
}