Get performs a GET request to the wiki service.

Hydrate looks up `ids` and returns a *total* map (every id in `ids` is present, missing/unknown ids get a Placeholder). Mapper code can then do `m[r.U

DB exposes the connection for service-owned transactions.

User is the single-id convenience. Returns (zero, false) for unknown ids.

ProxyWriteWithToken returns a Fiber handler that forwards a POST/PUT/DELETE to wiki with the session-stored OAuth access token. The token is taken fro

────────────────────────────────────────── Query helpers ────────────────────────────────────────── collectQuery converts the Fiber request query args

userBriefToDTO maps a userclient.User to the dto.UserBrief projection.

Delete removes an owner's collection. The default collection is protected. favorite_count is kept accurate for games held only in this collection; own

FindByID loads a single comment.

Run executes one sync cycle. Safe to call concurrently — events use SETNX guards so duplicate processing only re-writes the cursor. Designed to be che

────────────────────────────────────────── Reads — single rating ────────────────────────────────────────── FindByID returns a single rating row. Retu

GetBatchPublic is the cookie-aware batch fetch for any public list / feed enrichment path: enriches kungal-local IDs with wiki briefs while honouring

CreateGalgameMessageWithContent is the variant that records a content preview (used by resource liked/expired notifications). Dedup applies on (sender

────────────────────────────────────────── Init — POST /toolset/:id/upload/init ────────────────────────────────────────── Init validates the file, re

Render converts markdown to HTML with all custom transformations.

Update patches arbitrary columns on a rating row.

del runs a DELETE/UPDATE and PROPAGATES the error (unlike a fire-and-forget Exec) so any mid-transaction failure aborts and rolls back the whole purge

GetWithToken is like Get but attaches a Bearer token. Used by endpoints whose response shape depends on the caller's identity: - /galgame/batch with B

ToCards converts wiki galgame items into enriched GalgameCard DTOs, batch- loading users (from OAuth) and local stats once.

optionalUID returns the logged-in user's ID from OptionalAuth middleware, or 0 if not authenticated.

────────────────────────────────────────── Create — POST /galgame ────────────────────────────────────────── Create forwards the payload to wiki, then

Delete — DELETE /doc/tag

rewriteBanners walks the wiki response JSON and, for every object carrying U2 hash fields (`effective_banner_hash` / per-row `image_hash` + `sort_orde

truncate trims `s` to `maxLen` runes (rune-aware, avoids splitting multibyte chars).

withSFWFilter clones q and pins `content_limit` per the wiki NSFW protocol (see docs/galgame_wiki/00-handbook-for-downstream.md §16). Both modes are

Award adjusts the user's unified balance on OAuth and syncs the local cache. Fire-and-forget: it returns immediately and does the OAuth call + cache m

Delete removes a comment by reference.

SessionKey returns the Redis key for a session token.

Update edits an existing topic. PUT /api/topic/:tid

────────────────────────────────────────── Helpers ──────────────────────────────────────────

userBriefFromClient maps a userclient.User to the UserBrief shape used across toolset DTOs. Centralized so every call site is consistent.

Create — POST /doc/tag

SetContentImageCDNBase configures the CDN base for resolving /image/<hash> content refs. Call once at startup with cfg.GalgameWiki.ImageCDNBase.

Update — PUT /doc/tag (moderator+ enforced at the route level).

────────────────────────────────────────── Update — PUT /website-tag ──────────────────────────────────────────

hideTarget reports whether the profile owner (userID) is banned. When true, every content tab must render nothing: the profile page itself already deg

Create inserts a new galgame_rating row.

Delete removes a comment by reference.

Has reports whether the claim set contains an exact role name.

PostWithToken performs a POST with Bearer token. contentType controls how body is forwarded: - "" (empty) → defaults to "application/json"; st

RenderInline renders message markdown to sanitized HTML — inline formatting plus images only. Output is safe to render with v-html.

Configured reports whether the client can talk to the artifact service.

CreateTopicMessageWithContent is like CreateTopicMessage but stores a content preview. replyFloor/commentID deep-link the notification to a specific p

────────────────────────────────────────── Delete — DELETE /toolset/:id ──────────────────────────────────────────

FindByID returns the state row or sql.ErrNoRows if missing.

FindLikedSet returns the subset of commentIDs the user has liked. Anonymous (userID=0) or empty input → empty set without hitting DB. Used by GetComme

Update mutates an owner's collection (partial). The default collection can be renamed / re-described / re-privacied, but not deleted (see Delete).

────────────────────────────────────────── Update — PUT /toolset/:id ──────────────────────────────────────────

fetchOwnerAndName reads the galgame's owner user_id AND a display name from wiki in ONE request (0 / "" on any failure). The name becomes the notifica

mapErr turns a non-success artifact response into a sentinel (where callers branch) or a descriptive error.

tokenize splits a keyword string into trimmed non-empty tokens. Returns an error if the result is empty.