Changeset 221a209 in Klonkt for src/services/CircleService.js
- Timestamp:
- 06/16/2026 08:52:32 PM (3 months ago)
- Branches:
- main
- Children:
- 2248cd2
- Parents:
- fb02cc0
- File:
-
- 1 edited
-
src/services/CircleService.js (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
src/services/CircleService.js
rfb02cc0 r221a209 29 29 function baseOf(remoteUrl) { 30 30 return String(remoteUrl).replace(/\/+$/, ''); 31 } 32 33 // AS Hashtag-array -> comma-separated tagnamen (zonder #), gesanitized. 34 function extractTags(tag) { 35 if (!Array.isArray(tag)) return null; 36 const names = tag 37 .map((t) => String((t && t.name) || '').replace(/^#/, '').trim()) 38 .filter(Boolean) 39 .slice(0, 12); 40 return names.length ? names.join(', ') : null; 31 41 } 32 42 … … 83 93 `), 84 94 upsertPost: db.prepare(` 85 INSERT INTO remote_posts (id, actor_id, published, title, summary, url, media_json, raw_json, fetched_at)86 VALUES (@id, @actor_id, @published, @title, @summary, @url, @media_json, @ raw_json, CURRENT_TIMESTAMP)95 INSERT INTO remote_posts (id, actor_id, published, title, summary, url, media_json, tags, raw_json, fetched_at) 96 VALUES (@id, @actor_id, @published, @title, @summary, @url, @media_json, @tags, @raw_json, CURRENT_TIMESTAMP) 87 97 ON CONFLICT(id) DO UPDATE SET 88 98 published=excluded.published, title=excluded.title, summary=excluded.summary, 89 url=excluded.url, media_json=excluded.media_json, raw_json=excluded.raw_json, fetched_at=CURRENT_TIMESTAMP 99 url=excluded.url, media_json=excluded.media_json, tags=excluded.tags, 100 raw_json=excluded.raw_json, fetched_at=CURRENT_TIMESTAMP 90 101 `), 91 102 }; … … 169 180 url: obj.url || obj.id, 170 181 media_json: media.length ? JSON.stringify(media) : null, 182 tags: extractTags(obj.tag), 171 183 raw_json: JSON.stringify(obj).slice(0, 20000), 172 184 });
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)