quoteIdent double-quotes a SQL identifier (table/column from information_schema) so an odd name (reserved word, mixed case) is referenced safely.

resolveContentImageRef turns a /image/<hash>[_variant] token into the absolute CDN URL via imageclient.MainURL/VariantURL (the contract path layout —

rowToCard maps a resource row to the list-card DTO. `isLiked` is per-caller and must be looked up via the batch helper ResourceRepository.FindLikedSe

sendEnvelope is the single request path behind do/doJSON/doJSONWithToken: build the request, run it, decode the {code,message,data} envelope, and unma

────────────────────────────────────────── Reads ────────────────────────────────────────── sfwScope chains the age_limit='all' predicate when SFW mod

topicSectionFootprint is a topic's moemoepoint outcome given whether it sits in a paid section, mirroring Create: a paid section is a net deduction (−

writeImageAttr writes ` name="value"` for an attribute the meta transformer stamped on the image node, escaping the value. No-op if the attr is absent

AddContributor adds the given user as a contributor (inside a tx), ignoring if the pair already exists.

AdjustCommentCount bumps comment_count by delta.

AdjustFavoriteCount adjusts topic.favorite_count by delta.

AdjustFavoriteCount bumps favorite_count by delta (inside a tx).

AdjustLikeCount adjusts galgame_rating.like_count by delta.

AdjustLikeCount bumps like_count by delta (inside a tx).

AdjustLocalResourceCount adjusts galgame.resource_count by delta. Uses .Table(...).Update(...) which BYPASSES GORM's autoUpdateTime — so adjusting the

AdjustOptionVoteCount adjusts topic_poll_option.vote_count by delta.

AwardSync is the SYNCHRONOUS variant of Award for replayable cron paths (notably wiki-approve) that must know whether the OAuth call landed before adv

Create inserts a new galgame_resource row within the given tx.

────────────────────────────────────────── Writes (transactional) ────────────────────────────────────────── Create inserts a new toolset. Call inside

────────────────────────────────────────── Writes ────────────────────────────────────────── Create inserts a new article row (inside a tx).

────────────────────────────────────────── Writes ────────────────────────────────────────── Create inserts a new website row (inside a tx).

────────────────────────────────────────── Tag writes ────────────────────────────────────────── Create inserts a new tag row.

CreateGalgameCommentMention notifies a user @-mentioned in a galgame comment, deep-linked to that comment so clicking the notification lands on it: ?c

CreateLike inserts a like row.

CreateLinks inserts resource_link rows, skipping (resource_id, url) duplicates.

────────────────────────────────────────── Side-effect helpers used by Create / MergePR ────────────────────────────────────────── CreateLocalStub cre

CreatePollOption inserts a TopicPollOption row inside the caller tx.

CreateReplyMessage creates a (non-deduped) reply/commented notification for every target/owner separately. Callers should ensure this is only invoked

DeleteByID removes a rating (cascade clears likes & comments).

DeleteByID deletes a tag row and all its relation rows.

DeleteLike removes a specific like row.

DeleteWithToken performs a DELETE with Bearer token. See PostWithToken for contentType semantics.

ExtractMentionIDs returns the unique, positive user ids @mentioned in raw markdown `content`, in first-seen order. Used to fan out mention notificatio

FetchTopicBestAnswers batch-loads the accepted best-answer reply (topic .best_answer_id → topic_reply) for the topics that have one, keyed by topic id

FetchUserInfo retrieves the OAuth user info using an access token. Returns a typed *Error on OAuth-side failures.

────────────────────────────────────────── Tag reads ────────────────────────────────────────── FindAll returns all tags ordered by id ASC.

FindByName returns a tag by its unique name.

FindCommentByID returns a comment for permission checks.

FindGalgameOwner reads galgame.user_id used for delete permission checks.

────────────────────────────────────────── Writes — rating like ────────────────────────────────────────── FindLike returns the like row for (rating,

FindLocalBatch returns local stats for a list of galgame IDs.

FindNamesByIDs returns a map[id]name for the given category IDs.

────────────────────────────────────────── Tags ──────────────────────────────────────────

FindRatingGalgameID returns the galgame_id for a rating (used by comment notifications).

FindResourceMetaBatch aggregates DISTINCT (galgame_id, platform, language) tuples for a batch of galgame IDs.

FindSectionsByNamesTx resolves section names to rows inside the caller tx.

FindUserRating returns the user's rating for a toolset, if any. Returns (nil, nil) when the user has not rated.

GetAdminStats fetches wiki-side admin stats for the last N days. The wiki's admin/stats is an authenticated admin endpoint (401s anonymously), so the

GetBatch fetches lightweight galgame info for multiple IDs anonymously (status=0 only). Returns a map[galgameID] -> GalgameBrief for easy lookup. For

GetByIDForUser loads a collection only if it belongs to userID (owner-scoped mutations: 404 for missing OR not-yours).

GetMoemoepoint reads a user's unified balance from OAuth (06 §3.2).

GetSystemReadCursor returns the user's "read up to" marker, or 0 when the user has never marked any broadcast as read.

GetUserStats returns contribution + interaction counts for the profile page.

GetUserStats fetches galgame-related stats for a user from wiki.

HasNSFW reports whether any item in the list is nsfw.

Reaction data access for topics + replies (unified 'like'/'dislike'/emoji). Write methods take the caller's tx so toggles stay atomic with count + sid

────────────────────────────────────────── Reply reactions ──────────────────────────────────────────

HydrateCardsByIDs turns an ORDERED galgame id list into list cards, fusing wiki metadata + OAuth users + local stats/ratings/resource-meta. The output

────────────────────────────────────────── Queries ────────────────────────────────────────── IsKnownType reports whether typeStr is a recognised acti

IsLikedBy checks whether a user has liked a given resource.

LevelSumsByWebsiteIDs returns a map[websiteID] -> sum of tag levels for the given websites.

────────────────────────────────────────── Reads — list with filters ────────────────────────────────────────── ListPaginated applies the filter and r

---- URL helpers (pure, no network) ---- MainURL returns the CDN URL for the main image of a hash. Argument order matches VariantURL for consistency.

NewCompleteUploadRequestWithBody generates requests for CompleteUpload with any type of body

NewInitUploadRequestWithBody generates requests for InitUpload with any type of body

ParseCompleteUploadResp parses an HTTP response from a CompleteUploadWithResponse call

ParseInitUploadResp parses an HTTP response from a InitUploadWithResponse call

PurgeUserContent deletes everything authored/cast by userID and returns the pre-delete preview breakdown. The whole operation is one transaction: any

ReplaceAliases deletes existing aliases and inserts the given names (within a tx). Empty/whitespace-only names are skipped.

ReplaceProviderNames overwrites the jsonb provider_name column with the given display labels (e.g. ["百度网盘", "OneDrive"]). Stored as JSON text; the rea

ReplaceProviders overwrites the text[] provider column for a resource. GORM has no native array type, so this uses raw SQL with a manually- formatted

Samples returns up to `n` minimal samples (name + banner).

Search — GET /galgame-tag/search Wiki search is Meilisearch-backed; response shape is `{items, total, processing_time_ms}`. The frontend (galgame/tag

SearchUsers returns user search results from the OAuth /users/search endpoint. Identity is OAuth-owned, so we don't run any local DB query here. moemo

SetContentImageMetaResolver wires the image-metadata resolver used to enrich content <img> tags. Call once at startup with the image client's MetaReso

SetContentSiteBase configures the origin for @mention link hrefs. Call once at startup with the web origin.

Summary returns the (counts, avg) pair for a toolset, used by the detail view.

ToggleReaction adds/removes a reaction on a topic. like/dislike are effectful (like → ±1 moemoepoint to the owner + a "liked" notification) and mutual

ToggleReplyReaction is the reply-level counterpart of TopicWriteService .ToggleReaction: like → ±1 moemoepoint to the reply owner + a "liked" notifica

Touch marks a CONTENT update on a galgame (claim / merged edit) so the kungal list (ORDER BY g.resource_update_time DESC) surfaces it: it ensures the

TouchGalgameUpdated bumps galgame.resource_update_time to now to mark a resource content change (publish / edit). Separate from AdjustLocalResourceCou

────────────────────────────────────────── Update ──────────────────────────────────────────

UpdateFields updates arbitrary fields on a toolset row.