1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21 package net.sourceforge.mystique.infrastructure.persistence;
22
23 import java.util.List;
24
25 import javax.persistence.Query;
26
27 import net.sourceforge.mystique.domain.entity.Attachment;
28 import net.sourceforge.mystique.domain.entity.Ticket;
29 import net.sourceforge.mystique.domain.repository.AttachmentRepository;
30 import net.sourceforge.mystique.domain.repository.RepositoryException;
31
32 import org.springframework.dao.DataIntegrityViolationException;
33 import org.springframework.stereotype.Repository;
34 import org.springframework.transaction.annotation.Transactional;
35
36
37
38
39 @Repository
40 public class AttachmentJpaRepository extends JpaRepository<Attachment, Long> implements AttachmentRepository {
41
42 @Override
43 @Transactional(readOnly = true)
44 public Attachment findById(Long id) throws RepositoryException {
45
46 return entityManager.find(Attachment.class, id);
47
48 }
49
50 @Override
51 @Transactional(readOnly = true)
52 @SuppressWarnings("unchecked")
53 public List<Attachment> findByTicket(Ticket ticket, int offset, int limit) throws RepositoryException {
54
55 Query query = entityManager.createNamedQuery("Attachment.findByTicket");
56 query.setParameter("ticket", ticket);
57
58 query.setFirstResult(offset);
59 query.setMaxResults(limit);
60
61 return query.getResultList();
62
63 }
64
65 @Override
66 @Transactional
67 public void store(Attachment attachment) throws RepositoryException {
68
69 if (attachment.getId() != null) {
70 throw new DataIntegrityViolationException("exception.updateNotSupported");
71 }
72
73 entityManager.persist(attachment);
74 entityManager.flush();
75
76 }
77
78 }