|
JPA много @OneToOne
#39268489
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: СПБ
Сообщения: 1 847
|
|
no56892Atum1,
Вы удивитесь но сгенерит именно то что вы будете писать руками, тоесть один апдейт. Я писал как у меня сделано. Зато Кроме копипастов из интернетов от вас ничего не было.
Вчера писал с телефона ...вот полный тест с данными :
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
<dataset>
<Client id_client="10" name="John" age="23"/>
<Client id_client="11" name="Mike" age="28"/>
<Client id_client="12" name="Kevin" age="19"/>
<Account id_account="10" amount="50" currency="USD" id_client="10"/>
<Account id_account="11" amount="100" currency="USD" id_client="10"/>
<Account id_account="12" amount="150" currency="EUR" id_client="11"/>
<Account id_account="13" amount="200" currency="EUR" id_client="12"/>
</dataset>
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
@Entity
@Getter
@Setter
public class Client implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
@Column(name = "id_client")
private Integer id;
private String name;
private int age;
@OneToMany(mappedBy = "client"/*, orphanRemoval = true*/)
private List<Account> accounts = new ArrayList<>();
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
@Entity
@Getter
@Setter
public class Account implements Serializable {
@Id
@GeneratedValue
@Column(name = "id_account")
private Integer id;
private int amount;
private String currency;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "id_client")
private Client client;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
@Entity
@Getter
@Setter
@ToString
public class Report implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
private Integer id;
private String description;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
@Test
@Commit
public void showSpecificExecutionOrder() {
// 1. select client
Client client = getSession().get(Client.class, 10);
// 2. select account
Account account = client.getAccounts().get(0);
// 3. delete account
getSession().delete(account);
// 4. update client
client.setName("Elvis");
// 5. insert new report
Report report = new Report();
report.setDescription("Client has been updated; Account has been removed");
getSession().persist(report);
}
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.
Hibernate:
insert
into
CLIENT
(ID_CLIENT, NAME, AGE)
values
(10, 'John', 23)
Hibernate:
insert
into
CLIENT
(ID_CLIENT, NAME, AGE)
values
(11, 'Mike', 28)
Hibernate:
insert
into
CLIENT
(ID_CLIENT, NAME, AGE)
values
(12, 'Kevin', 19)
Hibernate:
insert
into
ACCOUNT
(ID_ACCOUNT, AMOUNT, CURRENCY, ID_CLIENT)
values
(10, 50, 'USD', 10)
Hibernate:
insert
into
ACCOUNT
(ID_ACCOUNT, AMOUNT, CURRENCY, ID_CLIENT)
values
(11, 100, 'USD', 10)
Hibernate:
insert
into
ACCOUNT
(ID_ACCOUNT, AMOUNT, CURRENCY, ID_CLIENT)
values
(12, 150, 'EUR', 11) {elapsed: 0ms}
Hibernate:
insert
into
ACCOUNT
(ID_ACCOUNT, AMOUNT, CURRENCY, ID_CLIENT)
values
(13, 200, 'EUR', 12)
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.
select
client0_.id_client as id_clien1_1_0_,
client0_.age as age2_1_0_,
client0_.name as name3_1_0_
from
Client client0_
where
client0_.id_client=10 {elapsed: 135ms}
Hibernate:
select
accounts0_.id_client as id_clien4_0_0_,
accounts0_.id_account as id_accou1_0_0_,
accounts0_.id_account as id_accou1_0_1_,
accounts0_.amount as amount2_0_1_,
accounts0_.id_client as id_clien4_0_1_,
accounts0_.currency as currency3_0_1_
from
Account accounts0_
where
accounts0_.id_client=10 {elapsed: 2ms}
Hibernate:
call next value for hibernate_sequence {elapsed: 3ms}
TRANSACTION BEFORECOMMIT!!!
Hibernate:
/* insert com.jeeconf.hibernate.basics.entity.Report
*/ insert
into
Report
(description, id)
values
('Client has been updated; Account has been removed', 1) {elapsed: 1ms}
Hibernate:
/* update
com.jeeconf.hibernate.basics.entity.Client */ update
Client
set
age=23,
name='Elvis'
where
id_client=10 {elapsed: 1ms}
Hibernate:
/* delete com.jeeconf.hibernate.basics.entity.Account */ delete
from
Account
where
id_account=10 {elapsed: 1ms}
TRANSACTION COMPLETE!!!
Не видите ничего странного ?
например что нарушается порядок выполнения кода ?
1)что сначала у вас выполнился insert Report
2)потом update ( причем почему то указаны сразу два поля !!!! age=23, name='Elvis' )
3) и в конце delete Account |
|
|
