From 97e72ddd07ceff5c42b77fa819da80d34ba7a251 Mon Sep 17 00:00:00 2001 From: Elias Haugsbakk Date: Tue, 21 Jul 2026 23:35:37 +0200 Subject: include last edited to db --- .../eliashaugsbakk/clams/server/repository/ArticlesRepoSqlite.java | 7 ++++--- .../no/eliashaugsbakk/clams/server/repository/SqliteManager.java | 2 +- 2 files changed, 5 insertions(+), 4 deletions(-) (limited to 'clams-server/src/main/java') diff --git a/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/ArticlesRepoSqlite.java b/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/ArticlesRepoSqlite.java index 86a615b..60f0f9d 100644 --- a/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/ArticlesRepoSqlite.java +++ b/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/ArticlesRepoSqlite.java @@ -124,8 +124,8 @@ public class ArticlesRepoSqlite implements ArticlesRepo { @Override public void addArticle(Article article) { String sql = """ - INSERT INTO articles (slug, title, content, summary, published, is_published) - VALUES (?, ?, ?, ?, ?, ?) + INSERT INTO articles (slug, title, content, summary, published, last_edited, is_published) + VALUES (?, ?, ?, ?, ?, ?, ?) """; try (Connection conn = manager.getConnection(); @@ -136,7 +136,8 @@ public class ArticlesRepoSqlite implements ArticlesRepo { stmt.setString(3, article.content()); stmt.setString(4, article.summary()); stmt.setString(5, article.timePublished().toString()); - stmt.setBoolean(6, article.isPublished()); + stmt.setString(6, article.timePublished().toString()); + stmt.setBoolean(7, article.isPublished()); stmt.executeUpdate(); diff --git a/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/SqliteManager.java b/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/SqliteManager.java index 4054ae4..4832818 100644 --- a/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/SqliteManager.java +++ b/clams-server/src/main/java/no/eliashaugsbakk/clams/server/repository/SqliteManager.java @@ -33,7 +33,7 @@ public class SqliteManager implements AutoCloseable { content TEXT, summary TEXT, published TEXT NOT NULL, - last_edited TEXT, + last_edited TEXT NOT NULL, is_published BOOLEAN ); """; -- cgit v1.2.3