-
Notifications
You must be signed in to change notification settings - Fork 6
Expand file tree
/
Copy pathHibernateTest.java
More file actions
80 lines (65 loc) · 2.41 KB
/
HibernateTest.java
File metadata and controls
80 lines (65 loc) · 2.41 KB
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
package com.pgvector;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.EntityManager;
import jakarta.persistence.EntityManagerFactory;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.Id;
import jakarta.persistence.Persistence;
import jakarta.persistence.Table;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.annotations.Array;
import org.hibernate.annotations.JdbcTypeCode;
import org.hibernate.type.SqlTypes;
import org.junit.jupiter.api.Test;
import static org.junit.jupiter.api.Assertions.assertArrayEquals;
@Entity
@Table(name = "hibernate_items")
class Item {
@Id
@GeneratedValue
private Long id;
@Column
@JdbcTypeCode(SqlTypes.VECTOR)
@Array(length = 3)
private float[] embedding;
public Long getId() {
return id;
}
public float[] getEmbedding() {
return embedding;
}
public void setEmbedding(float[] embedding) {
this.embedding = embedding;
}
}
public class HibernateTest {
@Test
void example() throws SQLException {
// disable logging
System.setProperty("org.jboss.logging.provider", "slf4j");
EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("default");
EntityManager entityManager = entityManagerFactory.createEntityManager();
entityManager.getTransaction().begin();
Item item1 = new Item();
item1.setEmbedding(new float[] {1, 1, 1});
entityManager.persist(item1);
Item item2 = new Item();
item2.setEmbedding(new float[] {2, 2, 2});
entityManager.persist(item2);
Item item3 = new Item();
item3.setEmbedding(new float[] {1, 1, 2});
entityManager.persist(item3);
List<Item> items = entityManager
.createQuery("FROM Item ORDER BY l2_distance(embedding, :embedding) LIMIT 5", Item.class)
.setParameter("embedding", new float[] {1, 1, 1})
.getResultList();
assertArrayEquals(new Long[] {1L, 3L, 2L}, items.stream().map(v -> v.getId()).toArray());
assertArrayEquals(new float[] {1, 1, 1}, items.get(0).getEmbedding());
assertArrayEquals(new float[] {1, 1, 2}, items.get(1).getEmbedding());
assertArrayEquals(new float[] {2, 2, 2}, items.get(2).getEmbedding());
entityManager.getTransaction().commit();
}
}