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