Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 1 | package eu.mulk.mulkcms2.benki.posts; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 2 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 3 | import static java.util.stream.Collectors.toList; |
| 4 | |
Matthias Andreas Benkard | 2d4f92e | 2020-02-09 16:15:07 +0100 | [diff] [blame] | 5 | import eu.mulk.mulkcms2.benki.accesscontrol.Role; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 6 | import eu.mulk.mulkcms2.benki.bookmarks.Bookmark; |
| 7 | import eu.mulk.mulkcms2.benki.lazychat.LazychatMessage; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame^] | 8 | import eu.mulk.mulkcms2.benki.newsletter.Newsletter; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 9 | import eu.mulk.mulkcms2.benki.users.User; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 10 | import eu.mulk.mulkcms2.benki.users.User_; |
Matthias Andreas Benkard | 35cb159 | 2020-01-24 11:05:20 +0100 | [diff] [blame] | 11 | import io.quarkus.hibernate.orm.panache.PanacheEntityBase; |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 12 | import java.time.LocalDate; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 13 | import java.time.OffsetDateTime; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 14 | import java.util.ArrayList; |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame^] | 15 | import java.util.Collection; |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 16 | import java.util.Comparator; |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 17 | import java.util.HashMap; |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 18 | import java.util.List; |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 19 | import java.util.Map; |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 20 | import java.util.Objects; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 21 | import java.util.Set; |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 22 | import java.util.TimeZone; |
| 23 | import java.util.stream.Collectors; |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 24 | import java.util.stream.Stream; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 25 | import javax.annotation.CheckForNull; |
Matthias Andreas Benkard | 6cfe16b | 2020-04-18 15:36:04 +0200 | [diff] [blame] | 26 | import javax.annotation.Nullable; |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 27 | import javax.json.bind.annotation.JsonbTransient; |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 28 | import javax.persistence.CascadeType; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 29 | import javax.persistence.Column; |
| 30 | import javax.persistence.Entity; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 31 | import javax.persistence.FetchType; |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 32 | import javax.persistence.GeneratedValue; |
| 33 | import javax.persistence.GenerationType; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 34 | import javax.persistence.Id; |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 35 | import javax.persistence.Inheritance; |
| 36 | import javax.persistence.InheritanceType; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 37 | import javax.persistence.JoinColumn; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 38 | import javax.persistence.JoinTable; |
| 39 | import javax.persistence.ManyToMany; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 40 | import javax.persistence.ManyToOne; |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 41 | import javax.persistence.MapKey; |
| 42 | import javax.persistence.OneToMany; |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 43 | import javax.persistence.SequenceGenerator; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 44 | import javax.persistence.Table; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 45 | import javax.persistence.criteria.CriteriaBuilder; |
| 46 | import javax.persistence.criteria.CriteriaQuery; |
| 47 | import javax.persistence.criteria.From; |
| 48 | import javax.persistence.criteria.JoinType; |
| 49 | import javax.persistence.criteria.Predicate; |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 50 | import org.hibernate.Session; |
| 51 | import org.jboss.logging.Logger; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 52 | |
| 53 | @Entity |
Matthias Andreas Benkard | 57c9a8a | 2020-01-24 19:09:38 +0100 | [diff] [blame] | 54 | @Table(name = "posts", schema = "benki") |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 55 | @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 56 | public abstract class Post<Text extends PostText<?>> extends PanacheEntityBase { |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 57 | |
Matthias Andreas Benkard | 593765d | 2020-04-18 20:44:07 +0200 | [diff] [blame] | 58 | private static final Logger log = Logger.getLogger(Post.class); |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 59 | |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 60 | @Id |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 61 | @SequenceGenerator( |
| 62 | allocationSize = 1, |
| 63 | sequenceName = "posts_id_seq", |
| 64 | name = "posts_id_seq", |
| 65 | schema = "benki") |
| 66 | @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "posts_id_seq") |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 67 | @Column(name = "id", nullable = false) |
Matthias Andreas Benkard | 0246c3e | 2020-01-27 05:39:08 +0100 | [diff] [blame] | 68 | public Integer id; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 69 | |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 70 | @Column(name = "date", nullable = true) |
Matthias Andreas Benkard | 1e7674c | 2020-04-18 20:28:51 +0200 | [diff] [blame] | 71 | @CheckForNull |
Matthias Andreas Benkard | d9b9588 | 2020-01-24 11:42:49 +0100 | [diff] [blame] | 72 | public OffsetDateTime date; |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 73 | |
Matthias Andreas Benkard | aa75480 | 2020-01-24 11:55:26 +0100 | [diff] [blame] | 74 | @ManyToOne(fetch = FetchType.LAZY) |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame^] | 75 | @JoinColumn(name = "newsletter", referencedColumnName = "id", nullable = true) |
| 76 | @CheckForNull |
| 77 | @JsonbTransient |
| 78 | public Newsletter newsletter; |
| 79 | |
| 80 | @ManyToOne(fetch = FetchType.LAZY) |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 81 | @JoinColumn(name = "owner", referencedColumnName = "id") |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 82 | @CheckForNull |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 83 | @JsonbTransient |
Matthias Andreas Benkard | 35cb159 | 2020-01-24 11:05:20 +0100 | [diff] [blame] | 84 | public User owner; |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 85 | |
| 86 | @ManyToMany(fetch = FetchType.LAZY) |
| 87 | @JoinTable( |
| 88 | name = "user_visible_posts", |
Matthias Andreas Benkard | 553de3e | 2020-01-27 05:33:15 +0100 | [diff] [blame] | 89 | schema = "benki", |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 90 | joinColumns = @JoinColumn(name = "message"), |
| 91 | inverseJoinColumns = @JoinColumn(name = "user")) |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 92 | @JsonbTransient |
Matthias Andreas Benkard | f9c7427 | 2020-01-24 11:51:35 +0100 | [diff] [blame] | 93 | public Set<User> visibleTo; |
Matthias Andreas Benkard | 2d4f92e | 2020-02-09 16:15:07 +0100 | [diff] [blame] | 94 | |
| 95 | @ManyToMany(fetch = FetchType.LAZY) |
| 96 | @JoinTable( |
| 97 | name = "post_targets", |
| 98 | schema = "benki", |
| 99 | joinColumns = @JoinColumn(name = "message"), |
| 100 | inverseJoinColumns = @JoinColumn(name = "target")) |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 101 | @JsonbTransient |
Matthias Andreas Benkard | 2d4f92e | 2020-02-09 16:15:07 +0100 | [diff] [blame] | 102 | public Set<Role> targets; |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 103 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 104 | @OneToMany( |
| 105 | mappedBy = "post", |
| 106 | fetch = FetchType.LAZY, |
| 107 | cascade = CascadeType.ALL, |
| 108 | targetEntity = PostText.class) |
| 109 | @MapKey(name = "language") |
| 110 | public Map<String, Text> texts = new HashMap<>(); |
| 111 | |
| 112 | public Map<String, Text> getTexts() { |
| 113 | return texts; |
| 114 | } |
| 115 | |
Matthias Andreas Benkard | 371164a | 2020-03-23 06:21:25 +0100 | [diff] [blame] | 116 | public abstract boolean isBookmark(); |
| 117 | |
| 118 | public abstract boolean isLazychatMessage(); |
| 119 | |
Matthias Andreas Benkard | d5ae0d5 | 2020-03-29 18:57:22 +0200 | [diff] [blame] | 120 | @CheckForNull |
| 121 | public abstract String getTitle(); |
| 122 | |
| 123 | @CheckForNull |
Matthias Andreas Benkard | d5ae0d5 | 2020-03-29 18:57:22 +0200 | [diff] [blame] | 124 | public abstract String getUri(); |
| 125 | |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 126 | public Visibility getVisibility() { |
| 127 | if (targets.isEmpty()) { |
| 128 | return Visibility.PRIVATE; |
| 129 | } else if (targets.contains(Role.getWorld())) { |
| 130 | return Visibility.PUBLIC; |
| 131 | } else { |
| 132 | // FIXME: There should really be a check whether targets.equals(owner.defaultTargets) here. |
| 133 | // Otherwise the actual visibility is DISCRETIONARY. |
| 134 | return Visibility.SEMIPRIVATE; |
| 135 | } |
| 136 | } |
| 137 | |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 138 | protected static <T extends Post> CriteriaQuery<T> queryViewable( |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 139 | Class<T> entityClass, |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 140 | @CheckForNull User reader, |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 141 | @CheckForNull User owner, |
| 142 | @CheckForNull Integer cursor, |
| 143 | CriteriaBuilder cb, |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 144 | boolean forward, |
| 145 | @CheckForNull String searchQuery) { |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 146 | CriteriaQuery<T> query = cb.createQuery(entityClass); |
| 147 | |
| 148 | var conditions = new ArrayList<Predicate>(); |
| 149 | |
| 150 | From<?, T> post; |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 151 | if (reader == null) { |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 152 | post = query.from(entityClass); |
| 153 | var target = post.join(Post_.targets); |
| 154 | conditions.add(cb.equal(target, Role.getWorld())); |
| 155 | } else { |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 156 | var root = query.from(User.class); |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 157 | conditions.add(cb.equal(root, reader)); |
Matthias Andreas Benkard | ca4d794 | 2020-04-18 14:13:41 +0200 | [diff] [blame] | 158 | if (entityClass.isAssignableFrom(Post.class)) { |
| 159 | post = (From<?, T>) root.join(User_.visiblePosts); |
| 160 | } else if (entityClass.isAssignableFrom(Bookmark.class)) { |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 161 | post = (From<?, T>) root.join(User_.visibleBookmarks); |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 162 | } else if (entityClass.isAssignableFrom(LazychatMessage.class)) { |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 163 | post = (From<?, T>) root.join(User_.visibleLazychatMessages); |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 164 | } else { |
Matthias Andreas Benkard | ca4d794 | 2020-04-18 14:13:41 +0200 | [diff] [blame] | 165 | throw new IllegalArgumentException(); |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 166 | } |
| 167 | } |
| 168 | |
| 169 | query.select(post); |
| 170 | post.fetch(Post_.owner, JoinType.LEFT); |
| 171 | |
| 172 | if (owner != null) { |
| 173 | conditions.add(cb.equal(post.get(Post_.owner), owner)); |
| 174 | } |
| 175 | |
| 176 | if (forward) { |
| 177 | query.orderBy(cb.desc(post.get(Post_.id))); |
| 178 | } else { |
| 179 | query.orderBy(cb.asc(post.get(Post_.id))); |
| 180 | } |
| 181 | |
| 182 | if (cursor != null) { |
| 183 | if (forward) { |
| 184 | conditions.add(cb.le(post.get(Post_.id), cursor)); |
| 185 | } else { |
| 186 | conditions.add(cb.gt(post.get(Post_.id), cursor)); |
| 187 | } |
| 188 | } |
| 189 | |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 190 | if (searchQuery != null && !searchQuery.isBlank()) { |
| 191 | var postTexts = post.join(Post_.texts); |
| 192 | var localizedSearches = |
| 193 | Stream.of("de", "en") |
| 194 | .map( |
| 195 | language -> |
| 196 | cb.isTrue( |
| 197 | cb.function( |
| 198 | "post_matches_websearch", |
| 199 | Boolean.class, |
| 200 | postTexts.get(PostText_.searchTerms), |
| 201 | cb.literal(language), |
| 202 | cb.literal(searchQuery)))) |
| 203 | .toArray(n -> new Predicate[n]); |
| 204 | conditions.add(cb.or(localizedSearches)); |
| 205 | } |
| 206 | |
Matthias Andreas Benkard | f599955 | 2020-03-22 06:52:06 +0100 | [diff] [blame] | 207 | query.where(conditions.toArray(new Predicate[0])); |
| 208 | |
| 209 | return query; |
| 210 | } |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 211 | |
Matthias Andreas Benkard | 6cfe16b | 2020-04-18 15:36:04 +0200 | [diff] [blame] | 212 | public final boolean isVisibleTo(@Nullable User user) { |
| 213 | // FIXME: Make this more efficient. |
| 214 | return getVisibility() == Visibility.PUBLIC || (user != null && visibleTo.contains(user)); |
| 215 | } |
| 216 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 217 | @CheckForNull |
| 218 | public final String getDescriptionHtml() { |
| 219 | var text = getText(); |
| 220 | if (text == null) { |
| 221 | return null; |
| 222 | } |
| 223 | return text.getDescriptionHtml(); |
| 224 | } |
| 225 | |
| 226 | public static class PostPage<T extends Post<? extends PostText>> { |
Matthias Andreas Benkard | 593765d | 2020-04-18 20:44:07 +0200 | [diff] [blame] | 227 | public @CheckForNull final Integer prevCursor; |
| 228 | public @CheckForNull final Integer cursor; |
| 229 | public @CheckForNull final Integer nextCursor; |
| 230 | public final List<T> posts; |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 231 | |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 232 | private static final TimeZone timeZone = TimeZone.getDefault(); |
| 233 | |
| 234 | public PostPage( |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 235 | @CheckForNull Integer c0, |
| 236 | @CheckForNull Integer c1, |
| 237 | @CheckForNull Integer c2, |
| 238 | List<T> resultList) { |
| 239 | this.prevCursor = c0; |
| 240 | this.cursor = c1; |
| 241 | this.nextCursor = c2; |
| 242 | this.posts = resultList; |
| 243 | } |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 244 | |
Matthias Andreas Benkard | 60c0892 | 2020-06-13 19:22:25 +0200 | [diff] [blame] | 245 | public void cacheDescriptions() { |
| 246 | days().forEach(Day::cacheDescriptions); |
| 247 | } |
| 248 | |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 249 | public class Day { |
| 250 | public final @CheckForNull LocalDate date; |
| 251 | public final List<T> posts; |
| 252 | |
| 253 | private Day(LocalDate date, List<T> posts) { |
| 254 | this.date = date; |
| 255 | this.posts = posts; |
| 256 | } |
Matthias Andreas Benkard | 60c0892 | 2020-06-13 19:22:25 +0200 | [diff] [blame] | 257 | |
| 258 | public void cacheDescriptions() { |
| 259 | for (var post : posts) { |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 260 | post.getTexts().values().forEach(PostText::getDescriptionHtml); |
Matthias Andreas Benkard | 60c0892 | 2020-06-13 19:22:25 +0200 | [diff] [blame] | 261 | } |
| 262 | } |
Matthias Andreas Benkard | 1c2a8a7 | 2020-04-26 06:09:57 +0200 | [diff] [blame] | 263 | } |
| 264 | |
| 265 | public List<Day> days() { |
| 266 | return posts.stream() |
| 267 | .collect(Collectors.groupingBy(post -> post.date.toLocalDate())) |
| 268 | .entrySet() |
| 269 | .stream() |
| 270 | .map(x -> new Day(x.getKey(), x.getValue())) |
| 271 | .sorted(Comparator.comparing((Day day) -> day.date).reversed()) |
| 272 | .collect(Collectors.toUnmodifiableList()); |
| 273 | } |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 274 | } |
| 275 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 276 | public static PostPage<Post<? extends PostText>> findViewable( |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 277 | PostFilter postFilter, Session session, @CheckForNull User viewer, @CheckForNull User owner) { |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 278 | return findViewable(postFilter, session, viewer, owner, null, null, null); |
Matthias Andreas Benkard | d5ae0d5 | 2020-03-29 18:57:22 +0200 | [diff] [blame] | 279 | } |
| 280 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 281 | public static PostPage<Post<? extends PostText>> findViewable( |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 282 | PostFilter postFilter, |
| 283 | Session session, |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 284 | @CheckForNull User viewer, |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 285 | @CheckForNull User owner, |
| 286 | @CheckForNull Integer cursor, |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 287 | @CheckForNull Integer count, |
| 288 | @CheckForNull String searchQuery) { |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 289 | Class<? extends Post> entityClass; |
| 290 | switch (postFilter) { |
| 291 | case BOOKMARKS_ONLY: |
| 292 | entityClass = Bookmark.class; |
| 293 | break; |
| 294 | case LAZYCHAT_MESSAGES_ONLY: |
| 295 | entityClass = LazychatMessage.class; |
| 296 | break; |
| 297 | default: |
| 298 | entityClass = Post.class; |
| 299 | } |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 300 | return findViewable(entityClass, session, viewer, owner, cursor, count, searchQuery); |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 301 | } |
| 302 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 303 | protected static <T extends Post<? extends PostText>> PostPage<T> findViewable( |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 304 | Class<? extends T> entityClass, |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 305 | Session session, |
Matthias Andreas Benkard | cf0fe88 | 2020-04-19 18:33:37 +0200 | [diff] [blame] | 306 | @CheckForNull User viewer, |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 307 | @CheckForNull User owner, |
| 308 | @CheckForNull Integer cursor, |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 309 | @CheckForNull Integer count, |
| 310 | @CheckForNull String searchQuery) { |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 311 | |
| 312 | if (cursor != null) { |
| 313 | Objects.requireNonNull(count); |
| 314 | } |
| 315 | |
| 316 | var cb = session.getCriteriaBuilder(); |
| 317 | |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 318 | var forwardCriteria = queryViewable(entityClass, viewer, owner, cursor, cb, true, searchQuery); |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 319 | var forwardQuery = session.createQuery(forwardCriteria); |
| 320 | |
| 321 | if (count != null) { |
| 322 | forwardQuery.setMaxResults(count + 1); |
| 323 | } |
| 324 | |
| 325 | log.debug(forwardQuery.unwrap(org.hibernate.query.Query.class).getQueryString()); |
| 326 | |
| 327 | @CheckForNull Integer prevCursor = null; |
| 328 | @CheckForNull Integer nextCursor = null; |
| 329 | |
| 330 | if (cursor != null) { |
| 331 | // Look backwards as well so we can find the prevCursor. |
Matthias Andreas Benkard | 8563a3c | 2020-09-16 17:57:24 +0200 | [diff] [blame] | 332 | var backwardCriteria = |
| 333 | queryViewable(entityClass, viewer, owner, cursor, cb, false, searchQuery); |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 334 | var backwardQuery = session.createQuery(backwardCriteria); |
| 335 | backwardQuery.setMaxResults(count); |
| 336 | var backwardResults = backwardQuery.getResultList(); |
| 337 | if (!backwardResults.isEmpty()) { |
| 338 | prevCursor = backwardResults.get(backwardResults.size() - 1).id; |
| 339 | } |
| 340 | } |
| 341 | |
Matthias Andreas Benkard | 4940b29 | 2020-03-29 18:41:07 +0200 | [diff] [blame] | 342 | var forwardResults = (List<T>) forwardQuery.getResultList(); |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 343 | if (count != null) { |
| 344 | if (forwardResults.size() == count + 1) { |
| 345 | nextCursor = forwardResults.get(count).id; |
| 346 | forwardResults.remove((int) count); |
| 347 | } |
| 348 | } |
| 349 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 350 | // Fetch texts (to avoid n+1 selects). |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame^] | 351 | fetchTexts(forwardResults); |
| 352 | |
| 353 | return new PostPage<>(prevCursor, cursor, nextCursor, forwardResults); |
| 354 | } |
| 355 | |
| 356 | public static <T extends Post<?>> void fetchTexts(Collection<T> posts) { |
| 357 | var postIds = posts.stream().map(x -> x.id).collect(toList()); |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 358 | |
| 359 | if (!postIds.isEmpty()) { |
| 360 | find("SELECT p FROM Post p LEFT JOIN FETCH p.texts WHERE p.id IN (?1)", postIds).stream() |
| 361 | .count(); |
| 362 | } |
Matthias Andreas Benkard | 3d399f3 | 2020-03-22 07:23:07 +0100 | [diff] [blame] | 363 | } |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 364 | |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 365 | @CheckForNull |
Matthias Andreas Benkard | ba3e58c | 2020-11-01 12:58:35 +0100 | [diff] [blame^] | 366 | public Text getText() { |
Matthias Andreas Benkard | d5498fc | 2020-08-23 21:51:00 +0200 | [diff] [blame] | 367 | var texts = getTexts(); |
| 368 | if (texts.isEmpty()) { |
| 369 | return null; |
| 370 | } else if (texts.containsKey("")) { |
| 371 | return texts.get(""); |
| 372 | } else if (texts.containsKey("en")) { |
| 373 | return texts.get("en"); |
| 374 | } else { |
| 375 | return texts.values().stream().findAny().get(); |
| 376 | } |
| 377 | } |
| 378 | |
Matthias Andreas Benkard | 06e6c81 | 2020-04-13 17:01:35 +0200 | [diff] [blame] | 379 | public enum Visibility { |
| 380 | PUBLIC, |
| 381 | SEMIPRIVATE, |
| 382 | DISCRETIONARY, |
| 383 | PRIVATE, |
| 384 | } |
| 385 | |
| 386 | @Override |
| 387 | public boolean equals(Object o) { |
| 388 | if (this == o) { |
| 389 | return true; |
| 390 | } |
| 391 | if (!(o instanceof Post)) { |
| 392 | return false; |
| 393 | } |
| 394 | Post post = (Post) o; |
| 395 | return Objects.equals(id, post.id); |
| 396 | } |
| 397 | |
| 398 | @Override |
| 399 | public int hashCode() { |
| 400 | return Objects.hash(id); |
| 401 | } |
Matthias Andreas Benkard | 734879e | 2020-01-24 10:47:37 +0100 | [diff] [blame] | 402 | } |