user.service.ts 989 B

12345678910111213141516171819202122232425262728
  1. import { Injectable } from '@nestjs/common';
  2. import { InjectConnection } from '@nestjs/typeorm';
  3. import { Connection } from 'typeorm';
  4. import { UserEntity } from '../../entity/user/user.entity';
  5. import { AddressEntity } from '../../entity/address/address.entity';
  6. import { User } from '../../entity/user/user.interface';
  7. import { Address } from '../../entity/address/address.interface';
  8. @Injectable()
  9. export class UserService {
  10. constructor(@InjectConnection() private connection: Connection) {}
  11. findAll(): Promise<User[]> {
  12. return this.connection.manager.find(UserEntity);
  13. }
  14. findOne(userId: number): Promise<User> {
  15. return this.connection.manager.findOne(UserEntity, userId);
  16. }
  17. findAddressesByUserId(userId: number): Promise<Address[]> {
  18. return this.connection
  19. .getRepository(AddressEntity)
  20. .createQueryBuilder('address')
  21. .where('address.userId = :id', { id: userId })
  22. .getMany();
  23. }
  24. }