Changeset 1d6f9a2 in Klonkt

Timestamp:

06/30/2026 05:29:01 PM (2 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

b5a09ce2

Parents:

ecbfa41

Message:

feat(video-cover): backend — convert animated WebP covers to a muted loop MP4 on upload

• DB: posts.cover_video_url (the muted loop MP4 for an animated cover)
• /posts/upload-image: an animated WebP → VideoCoverService.animatedWebpToVideo → returns {video} next to the still {url}; create + save persist cover_video_url (req.body.cover_video_url)

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

Location:

src

Files:

• config/database.js (modified) (1 diff)
• routes/posts.js (modified) (5 diffs)

src/config/database.js

@@ -84 +84 @@
   ensureColumn('posts', 'fan_only', 'INTEGER DEFAULT 0');  // fan-only preview (premium #3)
   ensureColumn('posts', 'nsfw',     'INTEGER DEFAULT 0');  // sensitive content → blur + click-to-reveal; fediverse sensitive
+  ensureColumn('posts', 'cover_video_url', 'TEXT');        // muted loop MP4 for an animated cover (Safari-smooth)
   ensureColumn('posts', 'content_warning', 'TEXT');        // custom CW label (empty = default "Gevoelige inhoud")
   ensureColumn('posts', 'type',    "TEXT DEFAULT 'post'");  // post | foto | video | audio

src/routes/posts.js

@@ -18 +18 @@
 import { audioUrl } from '../services/AudioStreamService.js';
 import { toWebp } from '../services/ImageWebpService.js';
+import VideoCoverService from '../services/VideoCoverService.js';
 import ActivityPubService from '../services/ActivityPubService.js';
 import MusicMeta from '../services/MusicMeta.js';
@@ -72 +73 @@
 // insert a markdown ![](url) into content.
 router.post('/posts/upload-image', requireAuth, (req, res) => {
-  imageUpload.single('image')(req, res, (err) => {
+  imageUpload.single('image')(req, res, async (err) => {
     if (err) return res.status(400).json({ error: err.message });
     if (!req.file) return res.status(400).json({ error: 'No file' });
-    const url = '/media/post-images/' + toWebp(req.file);
-    res.json({ url, size: req.file.size, mime: req.file.mimetype });
+    const name = toWebp(req.file);
+    const url = '/media/post-images/' + name;
+    // An animated WebP cover → also make a muted loop MP4 (Safari plays it smoothly where the
+    // animated WebP is janky on iOS). Best-effort; on failure we just return the still image.
+    // The editor stores `video` in the hidden cover_video_url field for the cover.
+    let video = null;
+    try {
+      const src = path.join(POST_IMAGES_DIR, name);
+      if (VideoCoverService.isAnimatedWebp(src)) {
+        const r = await VideoCoverService.animatedWebpToVideo(src, POST_IMAGES_DIR, path.basename(name, path.extname(name)) + '-v');
+        if (r) video = '/media/post-images/' + path.basename(r.videoPath);
+      }
+    } catch { /* keep the still image */ }
+    res.json({ url, video, size: req.file.size, mime: req.file.mimetype });
   });
 });
@@ -245 +258 @@
     INSERT INTO posts (
       id, site_id, slug, author_id, title, content, excerpt,
-      status, cover_image_url, pinned, tags, type, noindex, fan_only, nsfw, content_warning, publish_at,
+      status, cover_image_url, cover_video_url, pinned, tags, type, noindex, fan_only, nsfw, content_warning, publish_at,
       created_at, updated_at, published_at
-    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
+    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
   `).run(
     postId, site.id, finalSlug, req.session.user.id,
     title || finalSlug, cleanContent, excerpt || '',
-    finalStatus, cover_image_url || null, parsePinnedRank(pinned),
+    finalStatus, cover_image_url || null, (req.body.cover_video_url || null), parsePinnedRank(pinned),
     JSON.stringify((tags || '').split(',').map(t => t.trim()).filter(Boolean)),
     finalType, noindex ? 1 : 0, fanOnly, nsfw, cw, publishAt,
@@ -372 +385 @@
     UPDATE posts SET
       title = ?, content = ?, excerpt = ?, status = ?,
-      cover_image_url = ?, pinned = ?, tags = ?,
+      cover_image_url = ?, cover_video_url = ?, pinned = ?, tags = ?,
       type = ?, noindex = ?, fan_only = ?, nsfw = ?, content_warning = ?, publish_at = ?,
       slug = ?, published_at = ?, updated_at = ?
@@ -378 +391 @@
   `).run(
     title, cleanContent, excerpt, finalStatus,
-    cover_image_url || null, parsePinnedRank(pinned),
+    cover_image_url || null, (req.body.cover_video_url || null), parsePinnedRank(pinned),
     JSON.stringify((tags || '').split(',').map(t => t.trim()).filter(Boolean)),
     finalType, noindex ? 1 : 0, fanOnly, nsfw, cw, publishAt,