Press n or j to go to the next uncovered block, b, p or k for the previous block.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | 8x 8x 8x 8x 16x 1x 1x 2x 2x 1x | import { InjectRepository } from '@nestjs/typeorm'; import { ApiCommentGetRequestQueryDto } from 'src/comment/dto/api-comment-get-request-query.dto'; import { CommentEntity } from 'src/entities/comment.entity'; import { UserDto } from 'src/user/dto/user.dto'; import { IsNull, LessThan, Repository } from 'typeorm'; export class CommentQueryRepository { constructor( @InjectRepository(CommentEntity) private repository: Repository<CommentEntity>, ) {} async save(commentEntity: CommentEntity): Promise<CommentEntity> { return this.repository.save(commentEntity); } async findOne(uuid: string): Promise<CommentEntity> { return this.repository.findOne({ where: { uuid, archived_at: IsNull() }, }); } async find(uuid: string, dto: ApiCommentGetRequestQueryDto): Promise<CommentEntity[]> { const whereConditions = { target_uuid: uuid, archived_at: IsNull(), ...(dto.last_id > 0 ? { id: LessThan(dto.last_id) } : {}), }; return this.repository.find({ where: whereConditions, order: { created_at: 'DESC' }, take: dto.size, }); } async findMyComment(uuid: string, user: UserDto): Promise<CommentEntity> { return this.repository.findOne({ where: { target_uuid: uuid, user_uuid: user.uuid, archived_at: IsNull() }, }); } } |