/
MySQLMonetaryAmountTypeTest.java
98 lines (79 loc) · 2.78 KB
/
MySQLMonetaryAmountTypeTest.java
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
95
96
97
98
package com.vladmihalcea.hibernate.type.money;
import com.vladmihalcea.hibernate.util.AbstractMySQLIntegrationTest;
import org.hibernate.annotations.Columns;
import org.hibernate.annotations.Type;
import org.hibernate.annotations.TypeDef;
import org.javamoney.moneta.Money;
import org.junit.Test;
import javax.money.MonetaryAmount;
import javax.persistence.*;
import java.math.BigDecimal;
import static org.junit.Assert.assertEquals;
/**
* @author Piotr Olaszewski
*/
public class MySQLMonetaryAmountTypeTest extends AbstractMySQLIntegrationTest {
@Override
protected Class<?>[] entities() {
return new Class[]{
Salary.class
};
}
@Test
public void testPersistAndReadMoney() {
Salary _salary = doInJPA(entityManager -> {
Salary salary = new Salary();
salary.setSalary(Money.of(new BigDecimal("10.23"), "USD"));
entityManager.persist(salary);
return salary;
});
doInJPA(entityManager -> {
Salary salary = entityManager.find(Salary.class, _salary.getId());
assertEquals(salary.getSalary(), Money.of(new BigDecimal("10.23"), "USD"));
});
}
@Test
public void testSearchByMoney() {
doInJPA(entityManager -> {
Salary salary1 = new Salary();
salary1.setSalary(Money.of(new BigDecimal("10.23"), "USD"));
entityManager.persist(salary1);
Salary salary2 = new Salary();
salary2.setSalary(Money.of(new BigDecimal("20.23"), "EUR"));
entityManager.persist(salary2);
});
doInJPA(entityManager -> {
Money money = Money.of(new BigDecimal("10.23"), "USD");
Salary salary = entityManager.createQuery("select s from Salary s where salary = :salary", Salary.class)
.setParameter("salary", money)
.getSingleResult();
assertEquals(Long.valueOf(1), salary.getId());
});
}
@Entity(name = "Salary")
@Table(name = "salary")
@TypeDef(name = "monetary-amount-currency", typeClass = MonetaryAmountType.class, defaultForType = MonetaryAmount.class)
public static class Salary {
@Id
@GeneratedValue
private Long id;
@Columns(columns = {
@Column(name = "salary_amount"),
@Column(name = "salary_currency")
})
@Type(type = "monetary-amount-currency")
private MonetaryAmount salary;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public MonetaryAmount getSalary() {
return salary;
}
public void setSalary(MonetaryAmount salary) {
this.salary = salary;
}
}
}