include last edited to db

2 files changed, 5 insertions, 4 deletions

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
         );
         """;