scanItemsChanges scans rows from ListItemsChangesSince (skinny projection + deleted_at so callers can distinguish tombstones).

scanItemsIndex scans rows from ListItemsIndex (skinny projection — no i.content column).

scanTopLevelJSONKey returns true if `key` appears as a top-level key in the JSON object encoded in body. It uses json.Decoder so it can terminate earl

Arm (or re-arm) the idle debounce to flush `markdown` for `ctx`. No-op * when recovering or `ctx` is null. Cancels any prior pending flush first,

--- search ---

searchFacets runs two GROUP BY queries against the full (unpaginated) search result set to produce collection and status breakdowns. Non-fatal — retur

searchOrderClause returns the ORDER BY clause for search results. Includes i.id as a tie-breaker for deterministic pagination.

seedBootstrapSizeFixture populates the workspace with the contributors the bootstrap size benchmark wants to exercise: always-on conventions with body

seedConventionFromLibrary converts a LibraryConvention into a SeedConvention by marshaling its domain-specific fields (status, trigger, scope, priorit

seedPlaybookFromLibrary converts a LibraryPlaybook into a SeedPlaybook. InvocationSlug and Arguments are forwarded into the seeded item's Fields JSON

seedTaggedItem POSTs an item with the given JSON tags array into a collection.

sendForceRefreshFrame writes a force_refresh control message on the conn. Used by the resume-cursor protocol when the client's announced `?since=<id>`

serverHintFor generates the actionable hint for ErrServerError. Catch-all — surface enough for an agent to file a bug report.

sessionWebMCPEnabled extracts the webmcp_enabled bool from a session payload. The second return value reports whether the key was present.

clearSessionCookie expires the session cookie on the client so a subsequent request doesn't keep presenting a now-revoked token. setSessionCookie (re)

Write a new value back to the bound state.

shouldCreateItemVersion mirrors ShouldCreateVersion but queries item_versions.

--- show ---

Helper functions for GitHub integration

shutdown signals the sweeper to exit. Idempotent — safe to call from Server.Stop alongside other shutdown paths that may have already fired during a t

skipJSONValue advances dec past one complete JSON value (object, array, or scalar). Used by scanTopLevelJSONKey to land on the next object key without

sliceEqual reports whether a and b have the same elements in the same order. Local tiny helper avoids pulling reflect.DeepEqual into each assertion at

snippetAround returns up to N bytes of body around the first occurrence of marker, or "(marker not found)". Used by the nonce test for diagnostic outp

splitFrontmatter separates a leading "---\n...\n---" block from the body. Returns ErrMalformed if the opening or closing fence is missing or the front

splitLines is a small dependency-free helper. We avoid bufio.Scanner here because the typical body is small (under 50KB) and allocating a scanner per

splitRef parses "TASK-5" into ("TASK", 5). The trailing -<number> is required; everything before the last '-' is the prefix. Returns ok=false on shape

splitScopeString parses RFC 6749 §3.3 space-delimited scope. Single space is the canonical separator; multi-spaces from hand-typed input are tolerated

splitSpaceSeparated decodes the "a b c" form back to fosite.Arguments (a []string alias). Empty input → empty slice (non-nil) so range is safe.

--- standup ---

────────────────────────────────────────────────────────────────────────────── GitHub integration ────────────────────────────────────────────────────

startMCPAuditWriter constructs the audit writer + spawns its worker goroutine + spawns the periodic retention sweeper. Called once at startup from cmd

startWALCheckpointer runs PRAGMA wal_checkpoint(TRUNCATE) on a timer so the WAL file can't grow without bound. SQLite's automatic wal_autocheckpoint i

statusIconChar returns just the icon character for a status (no text, no color).

--- stop ---

stopMCPAuditWriter signals the writer to drain + exit. Called from Server.Stop. Idempotent.

stopOpLogGC signals the loop to exit. Called from Server.Stop(). Safe to call when the loop never started.

stopOrphanGC signals the loop to exit. Called from Server.Stop(). Safe to call when the loop never started.

stopRedisSubscription cancels and cleans up the Redis subscription for a workspace. Must be called with b.mu held.

stopWorkspacePurgeSweeper signals the loop to exit. Called from Server.Stop(). Safe to call when the loop never started.

strconvUint is a tiny strconv.FormatUint replacement that avoids the import dance for a one-line helper.

streamAttachmentToTar resolves the storage backend for one attachment row, writes a tar header sized to size_bytes, and copies the blob from the backe

stringInSlice is a tiny test helper — `slices.Contains` would do but keeping the test free of stdlib generics ergonomics so it reads cleanly with the

stripCommentIndex returns the position of an unquoted `#` that begins a same-line comment in s, or -1 if no such comment exists. Comments preceded by

stripComments removes JS/TS // line comments and /* ... */ block comments. Conservative — uses simple regex passes which won't correctly handle `//` i

--- switch ---

* Build the on-the-wire `fields` object for a demo task. Filters out * undefined effort so we don't post `effort: undefined` JSON.

thumbnailFilename builds the synthetic filename for a derived row — parent's basename + variant suffix + extension. Surfaces a sensible Content-Dispos

titleCaseLabel converts a snake_case key into a Title Case label the same way the CLI does ("due_date" → "Due Date"). Duplicated from internal/mcp/dis

toRouteMapper compiles spec into a RouteMapper closure.

toShape converts the parsed extract into the (all_current, explicit) pair the seeder consumes. Three branches: - hasKey == false → all_current

toString coerces a scalar frontmatter value to string. Values originate as strings in practice; non-strings are rendered defensively.

transformedFilename builds the synthetic filename for the derived row. We append the operation tag (e.g. ".rotated", ".cropped") before the extension

* Trigger a sync immediately (e.g., when SSE sends sync_required * while the tab is still visible). This bypasses the visibility * change listener

trimSpace is strings.TrimSpace inlined to avoid pulling strings through this file just for one call. catalog_item.go already imports strings for joinS