// base.ts
import { CreateDateColumn, Entity, PrimaryGeneratedColumn, UpdateDateColumn } from 'typeorm';
export abstract class BaseEntity {
@PrimaryGeneratedColumn()
id: number;
@CreateDateColumn({ type: 'timestamp', name: 'created_at' })
created_at: Date;
@UpdateDateColumn({ type: 'timestamp', name: 'updated_at' })
updated_at: Date;
}
// user.ts
import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn, UpdateDateColumn } from 'typeorm';
import { BaseEntity } from './base';
@Entity('user')
export class User extends BaseEntity {
@Column()
first_name: string;
@Column()
last_name: string;
@Column()
age: number;
}
// user_profile.ts
import { Column, Entity } from 'typeorm';
import { BaseEntity } from './base';
@Entity('user_profile')
export class UserProfile extends BaseEntity {
@Column()
email: string;
@Column()
user_id: number;
}
数据库数据有 user
id created_at updated_at first_name last_name age
1 2024-03-26 02:08:26.106077 2024-03-26 02:08:26.106077 Timber Saw 25
2 2024-03-26 02:17:34.012850 2024-03-26 02:21:58.541499 aaa a 11
user_profile
id created_at updated_at email user_id
1 2024-03-26 02:08:26.124340 2024-03-26 02:08:26.124340 [email protected] 1
2 2024-03-26 02:17:45.472608 2024-03-26 02:17:45.472608 [email protected] 2
index.ts 文件
import { AppDataSource } from './data-source';
import { User } from './entity/user';
import { UserProfile } from './entity/user_profile';
AppDataSource.initialize()
.then(async () => {
const userRepo = AppDataSource.getRepository(User);
const data = await userRepo
.createQueryBuilder('user')
.leftJoinAndSelect(UserProfile, 'user_profile', 'user.id = user_profile.user_id')
.where('user.id = :userId', { userId: 2 })
.getOne();
console.log(`☁️🚀☁️ `, data);
})
.catch((error) => console.log(error));
打印结果为:
☁️🚀☁️ User {id: 2, created_at: Tue Mar 26 2024 02:17:34 GMT+0800 (中国标准时间), updated_at: Tue Mar 26 2024 02:21:58 GMT+0800 (中国标准时间), first_name: 'aaa', last_name: 'a', …}
arg1: User {id: 2, created_at: Tue Mar 26 2024 02:17:34 GMT+0800 (中国标准时间), updated_at: Tue Mar 26 2024 02:21:58 GMT+0800 (中国标准时间), first_name: 'aaa', last_name: 'a', …}
age: 11
created_at: Tue Mar 26 2024 02:17:34 GMT+0800 (中国标准时间)
first_name: 'aaa'
id: 2
last_name: 'a'
updated_at: Tue Mar 26 2024 02:21:58 GMT+0800 (中国标准时间)
[[Prototype]]: BaseEntity
发现,user_profile 中的数据没有在里面(如 email 等),请问是怎么回事?
查看 typeorm 的 query 如下
QUERY : SELECT
`user`.`id` AS `user_id`,
`user`.`created_at` AS `user_created_at`,
`user`.`updated_at` AS `user_updated_at`,
`user`.`first_name` AS `user_first_name`,
`user`.`last_name` AS `user_last_name`,
`user`.`age` AS `user_age`,
`user_profile`.`id` AS `user_profile_id`,
`user_profile`.`created_at` AS `user_profile_created_at`,
`user_profile`.`updated_at` AS `user_profile_updated_at`,
`user_profile`.`email` AS `user_profile_email`,
`user_profile`.`user_id` AS `user_profile_user_id`
FROM
`user` `user`
LEFT JOIN `user_profile` `user_profile` ON `user`.`id` = `user_profile`.`user_id`
WHERE
`user`.`id` = ? -- PARAMETERS: [2]
