Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 1 | package eu.mulk.mulkcms2.benki.generic; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 2 | |
Matthias Andreas Benkard | 2d4f92e | 2020-02-09 16:15:07 +0100 | [diff] [blame] | 3 | import eu.mulk.mulkcms2.benki.accesscontrol.Role; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 4 | import eu.mulk.mulkcms2.benki.bookmarks.Bookmark; |
| 5 | import eu.mulk.mulkcms2.benki.lazychat.LazychatMessage; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 6 | import eu.mulk.mulkcms2.benki.users.User; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 7 | import eu.mulk.mulkcms2.benki.users.User_; |
Matthias Andreas Benkard | 35cb159 | 2020-01-24 11:05:20 +0100 | [diff] [blame] | 8 | import io.quarkus.hibernate.orm.panache.PanacheEntityBase; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 9 | import io.quarkus.security.identity.SecurityIdentity; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 10 | import java.time.OffsetDateTime; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 11 | import java.util.ArrayList; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 12 | import java.util.Set; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 13 | import javax.annotation.CheckForNull; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 14 | import javax.persistence.Column; |
| 15 | import javax.persistence.Entity; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 16 | import javax.persistence.FetchType; |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 17 | import javax.persistence.GeneratedValue; |
| 18 | import javax.persistence.GenerationType; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 19 | import javax.persistence.Id; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 20 | import javax.persistence.Inheritance; |
| 21 | import javax.persistence.InheritanceType; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 22 | import javax.persistence.JoinColumn; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 23 | import javax.persistence.JoinTable; |
| 24 | import javax.persistence.ManyToMany; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 25 | import javax.persistence.ManyToOne; |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 26 | import javax.persistence.SequenceGenerator; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 27 | import javax.persistence.Table; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 28 | import javax.persistence.criteria.CriteriaBuilder; |
| 29 | import javax.persistence.criteria.CriteriaQuery; |
| 30 | import javax.persistence.criteria.From; |
| 31 | import javax.persistence.criteria.JoinType; |
| 32 | import javax.persistence.criteria.Predicate; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 33 | |
| 34 | @Entity |
Matthias Andreas Benkard | 57c9a8a | 2020-01-24 19:09:38 +0100 | [diff] [blame] | 35 | @Table(name = "posts", schema = "benki") |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 36 | @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) |
| 37 | public abstract class Post extends PanacheEntityBase { |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 38 | |
| 39 | @Id |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 40 | @SequenceGenerator( |
| 41 | allocationSize = 1, |
| 42 | sequenceName = "posts_id_seq", |
| 43 | name = "posts_id_seq", |
| 44 | schema = "benki") |
| 45 | @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "posts_id_seq") |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 46 | @Column(name = "id", nullable = false) |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 47 | public Integer id; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 48 | |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 49 | @Column(name = "date", nullable = true) |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 50 | public OffsetDateTime date; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 51 | |
Matthias Andreas Benkard | aa75480 | 2020-01-24 11:55:26 +0100 | [diff] [blame] | 52 | @ManyToOne(fetch = FetchType.LAZY) |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 53 | @JoinColumn(name = "owner", referencedColumnName = "id") |
Matthias Andreas Benkard | 35cb159 | 2020-01-24 11:05:20 +0100 | [diff] [blame] | 54 | public User owner; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 55 | |
| 56 | @ManyToMany(fetch = FetchType.LAZY) |
| 57 | @JoinTable( |
| 58 | name = "user_visible_posts", |
Matthias Andreas Benkard | 553de3e | 2020-01-27 05:33:15 +0100 | [diff] [blame] | 59 | schema = "benki", |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 60 | joinColumns = @JoinColumn(name = "message"), |
| 61 | inverseJoinColumns = @JoinColumn(name = "user")) |
| 62 | public Set<User> visibleTo; |
Matthias Andreas Benkard | 2d4f92e | 2020-02-09 16:15:07 +0100 | [diff] [blame] | 63 | |
| 64 | @ManyToMany(fetch = FetchType.LAZY) |
| 65 | @JoinTable( |
| 66 | name = "post_targets", |
| 67 | schema = "benki", |
| 68 | joinColumns = @JoinColumn(name = "message"), |
| 69 | inverseJoinColumns = @JoinColumn(name = "target")) |
| 70 | public Set<Role> targets; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame^] | 71 | |
| 72 | public static <T extends Post> CriteriaQuery<T> findViewable( |
| 73 | Class<T> entityClass, |
| 74 | SecurityIdentity readerIdentity, |
| 75 | @CheckForNull User owner, |
| 76 | @CheckForNull Integer cursor, |
| 77 | CriteriaBuilder cb, |
| 78 | boolean forward) { |
| 79 | CriteriaQuery<T> query = cb.createQuery(entityClass); |
| 80 | |
| 81 | var conditions = new ArrayList<Predicate>(); |
| 82 | |
| 83 | From<?, T> post; |
| 84 | if (readerIdentity.isAnonymous()) { |
| 85 | post = query.from(entityClass); |
| 86 | var target = post.join(Post_.targets); |
| 87 | conditions.add(cb.equal(target, Role.getWorld())); |
| 88 | } else { |
| 89 | var userName = readerIdentity.getPrincipal().getName(); |
| 90 | var user = User.findByNickname(userName); |
| 91 | |
| 92 | var root = query.from(User.class); |
| 93 | conditions.add(cb.equal(root, user)); |
| 94 | if (entityClass.isAssignableFrom(Bookmark.class)) { |
| 95 | post = (From<?, T>) root.join(User_.visibleBookmarks); |
| 96 | } else { |
| 97 | assert entityClass.isAssignableFrom(LazychatMessage.class) : entityClass; |
| 98 | post = (From<?, T>) root.join(User_.visibleLazychatMessages); |
| 99 | } |
| 100 | } |
| 101 | |
| 102 | query.select(post); |
| 103 | post.fetch(Post_.owner, JoinType.LEFT); |
| 104 | |
| 105 | if (owner != null) { |
| 106 | conditions.add(cb.equal(post.get(Post_.owner), owner)); |
| 107 | } |
| 108 | |
| 109 | if (forward) { |
| 110 | query.orderBy(cb.desc(post.get(Post_.id))); |
| 111 | } else { |
| 112 | query.orderBy(cb.asc(post.get(Post_.id))); |
| 113 | } |
| 114 | |
| 115 | if (cursor != null) { |
| 116 | if (forward) { |
| 117 | conditions.add(cb.le(post.get(Post_.id), cursor)); |
| 118 | } else { |
| 119 | conditions.add(cb.gt(post.get(Post_.id), cursor)); |
| 120 | } |
| 121 | } |
| 122 | |
| 123 | query.where(conditions.toArray(new Predicate[0])); |
| 124 | |
| 125 | return query; |
| 126 | } |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 127 | } |