-
-
Notifications
You must be signed in to change notification settings - Fork 495
/
GH4160.test.ts
94 lines (69 loc) · 2.31 KB
/
GH4160.test.ts
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
import { Collection, Entity, LoadStrategy, ManyToOne, OneToMany, OneToOne, OptionalProps, PrimaryKey, Property, Rel } from '@mikro-orm/core';
import { MikroORM } from '@mikro-orm/better-sqlite';
@Entity()
class Account {
[OptionalProps]?: 'client';
@PrimaryKey()
id!: string;
@Property()
name!: string;
@OneToOne(() => Client, c => c.account)
client!: Rel<Client>;
}
@Entity()
class Client {
@OneToOne({ primary: true, entity: () => Account })
account!: Account;
@OneToMany(() => Brand, brand => brand.client, { orphanRemoval: true })
brands = new Collection<Brand>(this);
}
@Entity()
class Brand {
@PrimaryKey()
id!: string;
@ManyToOne(() => Client)
client!: Client;
}
let orm: MikroORM;
beforeAll(async () => {
orm = await MikroORM.init({
entities: [Client, Account, Brand],
dbName: ':memory:',
});
await orm.schema.refreshDatabase();
const account1 = orm.em.create(Account, { name: 'Account 1', id: '1' });
const client1 = orm.em.create(Client, { account: account1 });
orm.em.create(Brand, { id: '1', client: client1 });
orm.em.create(Brand, { id: '2', client: client1 });
await orm.em.flush();
});
beforeEach(async () => {
orm.em.clear();
});
afterAll(async () => {
await orm.close(true);
});
it('populate with select-in strategy', async () => {
const brands1 = await orm.em.find(Brand, {}, {
populate: ['client.account'],
strategy: LoadStrategy.SELECT_IN,
});
expect(brands1[0].client.account).toMatchObject({ id: '1', name: 'Account 1' });
expect(brands1[1].client.account).toMatchObject({ id: '1', name: 'Account 1' });
});
it('populate with joined strategy', async () => {
const brands1 = await orm.em.find(Brand, {}, {
populate: ['client.account'],
strategy: LoadStrategy.JOINED,
});
expect(brands1[0].client.account).toMatchObject({ id: '1', name: 'Account 1' });
expect(brands1[1].client.account).toMatchObject({ id: '1', name: 'Account 1' });
});
it('populate with query builder', async () => {
const brands2 = await orm.em
.createQueryBuilder(Brand, 'brand')
.leftJoinAndSelect('brand.client', 'client')
.leftJoinAndSelect('client.account', 'account');
expect(brands2[0].client.account).toMatchObject({ id: '1', name: 'Account 1' });
expect(brands2[1].client.account).toMatchObject({ id: '1', name: 'Account 1' });
});