diff options
Diffstat (limited to 'src')
19 files changed, 580 insertions, 85 deletions
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java index a659049..256c988 100644 --- a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java +++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java @@ -1,7 +1,6 @@ package eu.mulk.mulkcms2.benki.bookmarks; import eu.mulk.mulkcms2.benki.posts.Post; -import eu.mulk.mulkcms2.common.markdown.MarkdownConverter; import java.util.Set; import javax.annotation.CheckForNull; import javax.persistence.CollectionTable; @@ -11,23 +10,14 @@ import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.JoinColumn; import javax.persistence.Table; -import javax.persistence.Transient; @Entity @Table(name = "bookmarks", schema = "benki") -public class Bookmark extends Post { +public class Bookmark extends Post<BookmarkText> { @Column(name = "uri", nullable = false, length = -1) public String uri; - @Column(name = "title", nullable = true, length = -1) - @CheckForNull - public String title; - - @Column(name = "description", nullable = true, length = -1) - @CheckForNull - public String description; - @ElementCollection(fetch = FetchType.LAZY) @CollectionTable( name = "bookmark_tags", @@ -36,13 +26,10 @@ public class Bookmark extends Post { @Column(name = "tag") public Set<String> tags; - @Transient @CheckForNull - protected String computeDescriptionHtml() { - if (description == null) { - return null; - } - return new MarkdownConverter().htmlify(description); + private String getDescription() { + var text = getText(); + return text == null ? null : text.description; } @CheckForNull @@ -54,7 +41,8 @@ public class Bookmark extends Post { @CheckForNull @Override public String getTitle() { - return title; + var text = getText(); + return text == null ? null : text.title; } @Override @@ -66,4 +54,29 @@ public class Bookmark extends Post { public boolean isLazychatMessage() { return false; } + + public void setTitle(String x) { + var text = getText(); + if (text == null) { + text = new BookmarkText(); + text.post = this; + text.language = ""; + texts.put(text.language, text); + } + + text.title = x; + } + + public void setDescription(String x) { + var text = getText(); + if (text == null) { + text = new BookmarkText(); + text.post = this; + text.language = ""; + texts.put(text.language, text); + } + + text.description = x; + text.cachedDescriptionHtml = null; + } } diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java index f81ed04..bb39be9 100644 --- a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java +++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java @@ -66,9 +66,9 @@ public class BookmarkResource extends PostResource { var bookmark = new Bookmark(); bookmark.uri = uri.toString(); - bookmark.title = title; bookmark.tags = Set.of(); - bookmark.description = description; + bookmark.setTitle(title); + bookmark.setDescription(description); bookmark.owner = user; bookmark.date = OffsetDateTime.now(); @@ -106,10 +106,9 @@ public class BookmarkResource extends PostResource { } bookmark.uri = uri.toString(); - bookmark.title = title; bookmark.tags = Set.of(); - bookmark.description = description; - bookmark.cachedDescriptionHtml = null; + bookmark.setTitle(title); + bookmark.setDescription(description); bookmark.owner = user; assignPostTargets(visibility, user, bookmark); diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java new file mode 100644 index 0000000..c30f3df --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java @@ -0,0 +1,31 @@ +package eu.mulk.mulkcms2.benki.bookmarks; + +import eu.mulk.mulkcms2.benki.posts.PostText; +import eu.mulk.mulkcms2.common.markdown.MarkdownConverter; +import javax.annotation.CheckForNull; +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Table; +import javax.persistence.Transient; + +@Entity +@Table(name = "bookmark_texts", schema = "benki") +public class BookmarkText extends PostText<Bookmark> { + + @Column(name = "title", nullable = true, length = -1) + @CheckForNull + public String title; + + @Column(name = "description", nullable = true, length = -1) + @CheckForNull + public String description; + + @Transient + @CheckForNull + protected String computeDescriptionHtml() { + if (description == null) { + return null; + } + return new MarkdownConverter().htmlify(description); + } +} diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java new file mode 100644 index 0000000..92bda99 --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java @@ -0,0 +1,54 @@ +package eu.mulk.mulkcms2.benki.bookmarks; + +import java.io.Serializable; +import java.util.Objects; +import javax.persistence.Column; +import javax.persistence.FetchType; +import javax.persistence.Id; +import javax.persistence.JoinColumn; +import javax.persistence.ManyToOne; + +public class BookmarkTextPK implements Serializable { + + @Id + @Column(name = "language", nullable = false, length = -1) + private String language; + + @ManyToOne(fetch = FetchType.LAZY) + @JoinColumn(name = "bookmark", referencedColumnName = "id", nullable = false) + private Bookmark bookmark; + + public String getLanguage() { + return language; + } + + public void setLanguage(String language) { + this.language = language; + } + + public Bookmark getBookmark() { + return bookmark; + } + + public void setBookmark(Bookmark bookmark) { + this.bookmark = bookmark; + } + + @Override + public boolean equals(Object o) { + if (this == o) { + return true; + } + if (!(o instanceof BookmarkTextPK)) { + return false; + } + BookmarkTextPK that = (BookmarkTextPK) o; + return Objects.equals(getBookmark(), that.getBookmark()) + && getLanguage().equals(that.getLanguage()); + } + + @Override + public int hashCode() { + return Objects.hash(getBookmark(), getLanguage()); + } +} diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java index 5cec6aa..aa5b6eb 100644 --- a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java +++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java @@ -1,11 +1,9 @@ package eu.mulk.mulkcms2.benki.lazychat; import eu.mulk.mulkcms2.benki.posts.Post; -import eu.mulk.mulkcms2.common.markdown.MarkdownConverter; import java.util.Collection; import javax.annotation.CheckForNull; import javax.json.bind.annotation.JsonbTransient; -import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.OneToMany; @@ -14,14 +12,7 @@ import javax.persistence.Transient; @Entity @Table(name = "lazychat_messages", schema = "benki") -public class LazychatMessage extends Post { - - @Column(name = "content", nullable = true, length = -1) - @CheckForNull - public String content; - - @Column(name = "format", nullable = false, length = -1) - public String format; +public class LazychatMessage extends Post<LazychatMessageText> { @OneToMany(mappedBy = "referrer", fetch = FetchType.LAZY) @JsonbTransient @@ -46,16 +37,6 @@ public class LazychatMessage extends Post { return null; } - @CheckForNull - @Override - @JsonbTransient - protected String computeDescriptionHtml() { - if (content == null) { - return null; - } - return new MarkdownConverter().htmlify(content); - } - @Override public boolean isBookmark() { return false; @@ -65,4 +46,17 @@ public class LazychatMessage extends Post { public boolean isLazychatMessage() { return true; } + + public void setContent(String x) { + var text = getText(); + if (text == null) { + text = new LazychatMessageText(); + text.post = this; + text.language = ""; + texts.put(text.language, text); + } + + text.cachedDescriptionHtml = null; + text.content = x; + } } diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java new file mode 100644 index 0000000..1a60877 --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java @@ -0,0 +1,28 @@ +package eu.mulk.mulkcms2.benki.lazychat; + +import eu.mulk.mulkcms2.benki.posts.PostText; +import eu.mulk.mulkcms2.common.markdown.MarkdownConverter; +import javax.annotation.CheckForNull; +import javax.json.bind.annotation.JsonbTransient; +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Table; + +@Entity +@Table(name = "lazychat_message_texts", schema = "benki") +public class LazychatMessageText extends PostText<LazychatMessage> { + + @Column(name = "content", nullable = true, length = -1) + @CheckForNull + public String content; + + @CheckForNull + @Override + @JsonbTransient + protected String computeDescriptionHtml() { + if (content == null) { + return null; + } + return new MarkdownConverter().htmlify(content); + } +} diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java new file mode 100644 index 0000000..33063b1 --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java @@ -0,0 +1,54 @@ +package eu.mulk.mulkcms2.benki.lazychat; + +import java.io.Serializable; +import java.util.Objects; +import javax.persistence.Column; +import javax.persistence.FetchType; +import javax.persistence.Id; +import javax.persistence.JoinColumn; +import javax.persistence.ManyToOne; + +public class LazychatMessageTextPK implements Serializable { + + @ManyToOne(fetch = FetchType.LAZY) + @JoinColumn(name = "lazychat_message", referencedColumnName = "id", nullable = false) + public LazychatMessage lazychatMessage; + + @Id + @Column(name = "language", nullable = false, length = -1) + private String language; + + public LazychatMessage getLazychatMessage() { + return lazychatMessage; + } + + public void setLazychatMessageId(LazychatMessage lazychatMessage) { + this.lazychatMessage = lazychatMessage; + } + + public String getLanguage() { + return language; + } + + public void setLanguage(String language) { + this.language = language; + } + + @Override + public boolean equals(Object o) { + if (this == o) { + return true; + } + if (!(o instanceof LazychatMessageTextPK)) { + return false; + } + LazychatMessageTextPK that = (LazychatMessageTextPK) o; + return Objects.equals(getLazychatMessage(), that.getLazychatMessage()) + && getLanguage().equals(that.getLanguage()); + } + + @Override + public int hashCode() { + return Objects.hash(getLazychatMessage(), getLanguage()); + } +} diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java index 156b638..270a3d0 100644 --- a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java +++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java @@ -45,8 +45,7 @@ public class LazychatResource extends PostResource { var user = Objects.requireNonNull(getCurrentUser()); var message = new LazychatMessage(); - message.content = text; - message.format = "markdown"; + message.setContent(text); message.owner = user; message.date = OffsetDateTime.now(); @@ -81,9 +80,7 @@ public class LazychatResource extends PostResource { throw new ForbiddenException(); } - message.content = text; - message.cachedDescriptionHtml = null; - message.format = "markdown"; + message.setContent(text); assignPostTargets(visibility, user, message); diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java index 2bd9ade..8f2166c 100644 --- a/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java +++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java @@ -1,5 +1,7 @@ package eu.mulk.mulkcms2.benki.posts; +import static java.util.stream.Collectors.toList; + import eu.mulk.mulkcms2.benki.accesscontrol.Role; import eu.mulk.mulkcms2.benki.bookmarks.Bookmark; import eu.mulk.mulkcms2.benki.lazychat.LazychatMessage; @@ -10,7 +12,9 @@ import java.time.LocalDate; import java.time.OffsetDateTime; import java.util.ArrayList; import java.util.Comparator; +import java.util.HashMap; import java.util.List; +import java.util.Map; import java.util.Objects; import java.util.Set; import java.util.TimeZone; @@ -18,6 +22,7 @@ import java.util.stream.Collectors; import javax.annotation.CheckForNull; import javax.annotation.Nullable; import javax.json.bind.annotation.JsonbTransient; +import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; @@ -30,6 +35,8 @@ import javax.persistence.JoinColumn; import javax.persistence.JoinTable; import javax.persistence.ManyToMany; import javax.persistence.ManyToOne; +import javax.persistence.MapKey; +import javax.persistence.OneToMany; import javax.persistence.SequenceGenerator; import javax.persistence.Table; import javax.persistence.criteria.CriteriaBuilder; @@ -43,12 +50,10 @@ import org.jboss.logging.Logger; @Entity @Table(name = "posts", schema = "benki") @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) -public abstract class Post extends PanacheEntityBase { +public abstract class Post<Text extends PostText<?>> extends PanacheEntityBase { private static final Logger log = Logger.getLogger(Post.class); - private static final int DESCRIPTION_CACHE_VERSION = 1; - @Id @SequenceGenerator( allocationSize = 1, @@ -63,14 +68,6 @@ public abstract class Post extends PanacheEntityBase { @CheckForNull public OffsetDateTime date; - @Column(name = "cached_description_version", nullable = true) - @CheckForNull - public Integer cachedDescriptionVersion; - - @Column(name = "cached_description_html", nullable = true) - @CheckForNull - public String cachedDescriptionHtml; - @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "owner", referencedColumnName = "id") @CheckForNull @@ -95,6 +92,18 @@ public abstract class Post extends PanacheEntityBase { @JsonbTransient public Set<Role> targets; + @OneToMany( + mappedBy = "post", + fetch = FetchType.LAZY, + cascade = CascadeType.ALL, + targetEntity = PostText.class) + @MapKey(name = "language") + public Map<String, Text> texts = new HashMap<>(); + + public Map<String, Text> getTexts() { + return texts; + } + public abstract boolean isBookmark(); public abstract boolean isLazychatMessage(); @@ -103,23 +112,6 @@ public abstract class Post extends PanacheEntityBase { public abstract String getTitle(); @CheckForNull - public final String getDescriptionHtml() { - if (cachedDescriptionHtml != null - && cachedDescriptionVersion != null - && cachedDescriptionVersion >= DESCRIPTION_CACHE_VERSION) { - return cachedDescriptionHtml; - } else { - @CheckForNull var descriptionHtml = computeDescriptionHtml(); - cachedDescriptionHtml = descriptionHtml; - cachedDescriptionVersion = DESCRIPTION_CACHE_VERSION; - return descriptionHtml; - } - } - - @CheckForNull - protected abstract String computeDescriptionHtml(); - - @CheckForNull public abstract String getUri(); public Visibility getVisibility() { @@ -195,7 +187,16 @@ public abstract class Post extends PanacheEntityBase { return getVisibility() == Visibility.PUBLIC || (user != null && visibleTo.contains(user)); } - public static class PostPage<T extends Post> { + @CheckForNull + public final String getDescriptionHtml() { + var text = getText(); + if (text == null) { + return null; + } + return text.getDescriptionHtml(); + } + + public static class PostPage<T extends Post<? extends PostText>> { public @CheckForNull final Integer prevCursor; public @CheckForNull final Integer cursor; public @CheckForNull final Integer nextCursor; @@ -229,7 +230,7 @@ public abstract class Post extends PanacheEntityBase { public void cacheDescriptions() { for (var post : posts) { - post.getDescriptionHtml(); + post.getTexts().values().forEach(PostText::getDescriptionHtml); } } } @@ -245,12 +246,12 @@ public abstract class Post extends PanacheEntityBase { } } - public static PostPage<Post> findViewable( + public static PostPage<Post<? extends PostText>> findViewable( PostFilter postFilter, Session session, @CheckForNull User viewer, @CheckForNull User owner) { return findViewable(postFilter, session, viewer, owner, null, null); } - public static PostPage<Post> findViewable( + public static PostPage<Post<? extends PostText>> findViewable( PostFilter postFilter, Session session, @CheckForNull User viewer, @@ -271,7 +272,7 @@ public abstract class Post extends PanacheEntityBase { return findViewable(entityClass, session, viewer, owner, cursor, count); } - protected static <T extends Post> PostPage<T> findViewable( + protected static <T extends Post<? extends PostText>> PostPage<T> findViewable( Class<? extends T> entityClass, Session session, @CheckForNull User viewer, @@ -316,9 +317,31 @@ public abstract class Post extends PanacheEntityBase { } } + // Fetch texts (to avoid n+1 selects). + var postIds = forwardResults.stream().map(x -> x.id).collect(toList()); + + if (!postIds.isEmpty()) { + find("SELECT p FROM Post p LEFT JOIN FETCH p.texts WHERE p.id IN (?1)", postIds).stream() + .count(); + } + return new PostPage<>(prevCursor, cursor, nextCursor, forwardResults); } + @CheckForNull + protected Text getText() { + var texts = getTexts(); + if (texts.isEmpty()) { + return null; + } else if (texts.containsKey("")) { + return texts.get(""); + } else if (texts.containsKey("en")) { + return texts.get("en"); + } else { + return texts.values().stream().findAny().get(); + } + } + public enum Visibility { PUBLIC, SEMIPRIVATE, diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java new file mode 100644 index 0000000..01753dc --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java @@ -0,0 +1,61 @@ +package eu.mulk.mulkcms2.benki.posts; + +import javax.annotation.CheckForNull; +import javax.json.bind.annotation.JsonbTransient; +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.FetchType; +import javax.persistence.Id; +import javax.persistence.IdClass; +import javax.persistence.Inheritance; +import javax.persistence.InheritanceType; +import javax.persistence.JoinColumn; +import javax.persistence.ManyToOne; +import javax.persistence.Table; + +@Entity +@Table(name = "post_texts", schema = "benki") +@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) +@IdClass(PostTextPK.class) +public abstract class PostText<OwningPost extends Post<?>> { + + private static final int DESCRIPTION_CACHE_VERSION = 1; + + @Id + @Column(name = "post", nullable = false, insertable = false, updatable = false) + public int postId; + + @Id + @Column(name = "language", nullable = false, length = -1) + public String language; + + @Column(name = "cached_description_version", nullable = true) + @CheckForNull + public Integer cachedDescriptionVersion; + + @Column(name = "cached_description_html", nullable = true) + @CheckForNull + public String cachedDescriptionHtml; + + @ManyToOne(fetch = FetchType.LAZY, targetEntity = Post.class) + @JoinColumn(name = "post", referencedColumnName = "id", nullable = false) + @JsonbTransient + public OwningPost post; + + @CheckForNull + public final String getDescriptionHtml() { + if (cachedDescriptionHtml != null + && cachedDescriptionVersion != null + && cachedDescriptionVersion >= DESCRIPTION_CACHE_VERSION) { + return cachedDescriptionHtml; + } else { + @CheckForNull var descriptionHtml = computeDescriptionHtml(); + cachedDescriptionHtml = descriptionHtml; + cachedDescriptionVersion = DESCRIPTION_CACHE_VERSION; + return descriptionHtml; + } + } + + @CheckForNull + protected abstract String computeDescriptionHtml(); +} diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java new file mode 100644 index 0000000..0a945dd --- /dev/null +++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java @@ -0,0 +1,55 @@ +package eu.mulk.mulkcms2.benki.posts; + +import java.io.Serializable; +import java.util.Objects; +import javax.persistence.Column; +import javax.persistence.FetchType; +import javax.persistence.Id; +import javax.persistence.IdClass; +import javax.persistence.JoinColumn; +import javax.persistence.ManyToOne; + +@IdClass(PostTextPK.class) +public class PostTextPK implements Serializable { + + @ManyToOne(fetch = FetchType.LAZY) + @JoinColumn(name = "post", referencedColumnName = "id", nullable = false) + public Post<?> post; + + @Id + @Column(name = "language", nullable = false, length = -1) + private String language; + + public Post<?> getPost() { + return post; + } + + public void setPost(Post post) { + this.post = post; + } + + public String getLanguage() { + return language; + } + + public void setLanguage(String language) { + this.language = language; + } + + @Override + public boolean equals(Object o) { + if (this == o) { + return true; + } + if (!(o instanceof PostTextPK)) { + return false; + } + PostTextPK that = (PostTextPK) o; + return Objects.equals(getPost(), that.getPost()) && getLanguage().equals(that.getLanguage()); + } + + @Override + public int hashCode() { + return Objects.hash(getPost(), getLanguage()); + } +} diff --git a/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js b/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js index 6ecc355..b4d21d3 100644 --- a/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js +++ b/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js @@ -173,9 +173,11 @@ export class MlkBookmarkSubmissionForm extends HTMLElement { let post = await r.json(); this.uriInput.value = post.uri; - this.titleInput.value = post.title; - this.descriptionInput.innerText = post.description; this.visibilityInput.value = post.visibility; + if (post.texts['']) { + this.titleInput.value = post.texts[''].title; + this.descriptionInput.innerText = post.texts[''].description; + } this.loaded = true; } diff --git a/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js b/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js index c6334ad..3688527 100644 --- a/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js +++ b/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js @@ -107,8 +107,10 @@ export class MlkLazychatSubmissionForm extends HTMLElement { } let post = await r.json(); - this.textInput.value = post.content; this.visibilityInput.value = post.visibility; + if (post.texts['']) { + this.textInput.value = post.texts[''].content; + } this.loaded = true; } diff --git a/src/main/resources/db/changeLog-1.2.xml b/src/main/resources/db/changeLog-1.2.xml new file mode 100644 index 0000000..87ff426 --- /dev/null +++ b/src/main/resources/db/changeLog-1.2.xml @@ -0,0 +1,15 @@ +<?xml version="1.1" encoding="UTF-8" standalone="no"?> +<databaseChangeLog + xmlns="http://www.liquibase.org/xml/ns/dbchangelog" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation=" + http://www.liquibase.org/xml/ns/dbchangelog + http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.10.xsd"> + + <changeSet author="mulk" id="1.2-1"> + <dropColumn tableName="lazychat_messages" schemaName="benki"> + <column name="format"/> + </dropColumn> + </changeSet> + +</databaseChangeLog> diff --git a/src/main/resources/db/changeLog-1.3.xml b/src/main/resources/db/changeLog-1.3.xml new file mode 100644 index 0000000..a0659c0 --- /dev/null +++ b/src/main/resources/db/changeLog-1.3.xml @@ -0,0 +1,79 @@ +<?xml version="1.1" encoding="UTF-8" standalone="no"?> +<databaseChangeLog + xmlns="http://www.liquibase.org/xml/ns/dbchangelog" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation=" + http://www.liquibase.org/xml/ns/dbchangelog + http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.10.xsd"> + + <changeSet author="mulk" id="1.3-1"> + <createTable tableName="lazychat_message_texts" schemaName="benki"> + <column name="lazychat_message" type="integer"> + <constraints + nullable="false" + primaryKeyName="lazychat_message_texts_pkey" + primaryKey="true" + foreignKeyName="lazychat_message_texts_lazychat_message_fkey" + referencedTableSchemaName="benki" + referencedTableName="lazychat_messages" + referencedColumnNames="id"/> + </column> + + <column name="language" type="varchar"> + <constraints + nullable="false" + primaryKeyName="lazychat_message_texts_pkey" + primaryKey="true" + checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/> + </column> + + <column name="content" type="varchar"> + <constraints nullable="false"/> + </column> + </createTable> + + <sql> + insert into benki.lazychat_message_texts(lazychat_message, language, content) + select id, '', content from benki.lazychat_messages; + </sql> + + <dropColumn tableName="lazychat_messages" schemaName="benki"> + <column name="content"/> + </dropColumn> + + <createTable tableName="bookmark_texts" schemaName="benki"> + <column name="bookmark" type="integer"> + <constraints + nullable="false" + primaryKeyName="bookmark_texts_pkey" + primaryKey="true" + foreignKeyName="bookmark_texts_bookmark_fkey" + referencedTableSchemaName="benki" + referencedTableName="bookmarks" + referencedColumnNames="id"/> + </column> + + <column name="language" type="varchar"> + <constraints + nullable="false" + primaryKeyName="bookmark_texts_pkey" + primaryKey="true" + checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/> + </column> + + <column name="title" type="varchar"/> + <column name="description" type="varchar"/> + </createTable> + + <sql> + insert into benki.bookmark_texts(bookmark, language, title, description) + select id, '', title, description from benki.bookmarks; + </sql> + + <dropColumn tableName="bookmarks" schemaName="benki"> + <column name="title"/> + <column name="description"/> + </dropColumn> + </changeSet> + +</databaseChangeLog> diff --git a/src/main/resources/db/changeLog-1.4.xml b/src/main/resources/db/changeLog-1.4.xml new file mode 100644 index 0000000..2e47dab --- /dev/null +++ b/src/main/resources/db/changeLog-1.4.xml @@ -0,0 +1,43 @@ +<?xml version="1.1" encoding="UTF-8" standalone="no"?> +<databaseChangeLog + xmlns="http://www.liquibase.org/xml/ns/dbchangelog" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation=" + http://www.liquibase.org/xml/ns/dbchangelog + http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.10.xsd"> + + <changeSet author="mulk" id="1.3-1"> + <createTable tableName="post_texts" schemaName="benki"> + <column name="post" type="integer"> + <constraints + nullable="false" + primaryKeyName="post_texts_pkey" + primaryKey="true" + foreignKeyName="post_texts_post_fkey" + referencedTableSchemaName="benki" + referencedTableName="posts" + referencedColumnNames="id"/> + </column> + + <column name="language" type="varchar"> + <constraints + nullable="false" + primaryKeyName="lazychat_message_texts_pkey" + primaryKey="true" + checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/> + </column> + </createTable> + + <renameColumn tableName="lazychat_message_texts" schemaName="benki" oldColumnName="lazychat_message" newColumnName="post"/> + <renameColumn tableName="bookmark_texts" schemaName="benki" oldColumnName="bookmark" newColumnName="post"/> + + <sql> + ALTER TABLE benki.lazychat_message_texts INHERIT benki.post_texts; + </sql> + + <sql> + ALTER TABLE benki.bookmark_texts INHERIT benki.post_texts; + </sql> + </changeSet> + +</databaseChangeLog> diff --git a/src/main/resources/db/changeLog-1.5.xml b/src/main/resources/db/changeLog-1.5.xml new file mode 100644 index 0000000..c10beb1 --- /dev/null +++ b/src/main/resources/db/changeLog-1.5.xml @@ -0,0 +1,41 @@ +<?xml version="1.1" encoding="UTF-8" standalone="no"?> +<databaseChangeLog + xmlns="http://www.liquibase.org/xml/ns/dbchangelog" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation=" + http://www.liquibase.org/xml/ns/dbchangelog + http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.10.xsd"> + + <changeSet author="mulk" id="1.3-1"> + <addColumn tableName="bookmark_texts" schemaName="benki"> + <column name="cached_description_html" type="VARCHAR"/> + <column name="cached_description_version" type="INTEGER"/> + </addColumn> + + <addColumn tableName="lazychat_message_texts" schemaName="benki"> + <column name="cached_description_html" type="VARCHAR"/> + <column name="cached_description_version" type="INTEGER"/> + </addColumn> + + <addColumn tableName="post_texts" schemaName="benki"> + <column name="cached_description_html" type="VARCHAR"/> + <column name="cached_description_version" type="INTEGER"/> + </addColumn> + + <dropColumn tableName="posts" schemaName="benki"> + <column name="cached_description_html"/> + <column name="cached_description_version"/> + </dropColumn> + + <dropColumn tableName="bookmarks" schemaName="benki"> + <column name="cached_description_html"/> + <column name="cached_description_version"/> + </dropColumn> + + <dropColumn tableName="lazychat_messages" schemaName="benki"> + <column name="cached_description_html"/> + <column name="cached_description_version"/> + </dropColumn> + </changeSet> + +</databaseChangeLog> diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml index 7d346aa..1c5c4ea 100644 --- a/src/main/resources/db/changeLog.xml +++ b/src/main/resources/db/changeLog.xml @@ -8,5 +8,9 @@ <include file="db/changeLog-1.0.xml"/> <include file="db/changeLog-1.1.xml"/> + <include file="db/changeLog-1.2.xml"/> + <include file="db/changeLog-1.3.xml"/> + <include file="db/changeLog-1.4.xml"/> + <include file="db/changeLog-1.5.xml"/> </databaseChangeLog> diff --git a/src/main/resources/db/liquibase.properties b/src/main/resources/db/liquibase.properties index 79aca15..38e258c 100644 --- a/src/main/resources/db/liquibase.properties +++ b/src/main/resources/db/liquibase.properties @@ -1,3 +1,3 @@ -url = jdbc:postgresql:///mulkcms?currentSchemas=public,benki +url = jdbc:postgresql://localhost:5432/mulkcms?currentSchemas=public,benki changeLogFile = src/main/resources/db/changeLog.xml schemas = public,benki |