nest.js+mysql多表查询踩坑

[lizhongzhen11]

花了我4个小时我才搞懂。。。

https://github.com/typeorm/typeorm/blob/master/docs/one-to-one-relations.md

// Entity
import { Entity, Column, PrimaryGeneratedColumn, OneToOne, JoinColumn } from 'typeorm';
import { SYRole } from '../role/role.entity'

@Entity({
  name: 'SY_ManagerUser',
  synchronize: false
})
export class SYManagerUser {
  @PrimaryGeneratedColumn()
  userId: number;

  @Column()
  roleId: number;

  @Column({
    nullable: true
  })
  storeId: number | null;

  @Column({
    nullable: true
  })
  deptId: number | null;

  @Column({
    length: 10
  })
  userName: string;

  @Column({
    length: 10
  })
  nickName: string;

  @Column({
    length: 50
  })
  password: string;

  @Column({
    length: 15
  })
  phone: string;

  @Column({ 
    type: 'int',
    width: 1,
    default: 1 
  })
  status: number;

  @OneToOne(type => SYRole)
  @JoinColumn({
    name: 'roleId'
  })
  role: SYRole;
}


// service
@Injectable()
export class ManagerUserService {
  constructor(
    @InjectRepository(SYManagerUser)
    private managerUsersRepository: Repository<SYManagerUser>,
  ) {}

  async findAll(listbody: ListBody): Promise<ResponseData> {
    try {
      const current = listbody.current
      const result = await this.managerUsersRepository.findAndCount({
        skip: (current - 1) * 10,
        take: 10,
        relations: ["role"]
      });
      return Object.assign(SUCCESS, { data: result[0], current, pageSize: 10, total: result[1] })
    } catch (error) {
      console.log(error)
      return FAIL
    }
  }
}

最终结果：