Changeset 535f955 in Klonkt for src/config/database.js

Timestamp:

06/19/2026 09:49:35 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

247988e

Parents:

8cdb377

Message:

feat: post likes + favourites page for logged-in users

• New post_likes table (unique per post+user).
• ♥ like button on the post (shared partial, htmx toggle via POST /posts/:id/like); shows the like count. Anonymous → button links to login.
• /favorieten page (requireAuth) shows your liked posts (solo: own site, hub: across all sites with correct links). Link in account menu (sheet + topnav).

Co-Authored-By: Claude <noreply@…>

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -256 +256 @@
     );
   `);
+
+  // Likes / favorieten: een ingelogde gebruiker kan een post liken. De set van
+  // posts die een gebruiker likte = z'n favorieten (/favorieten-pagina). Eén rij
+  // per (post, user); uniek zodat liken idempotent is.
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS post_likes (
+      post_id TEXT NOT NULL,
+      user_id TEXT NOT NULL,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      PRIMARY KEY (post_id, user_id)
+    );
+    CREATE INDEX IF NOT EXISTS idx_post_likes_user ON post_likes(user_id, created_at);
+    CREATE INDEX IF NOT EXISTS idx_post_likes_post ON post_likes(post_id);
+  `);
 }