Method FinalizeStaleChatDebugRows

coderd/database/querier.go:253–253

Marks orphaned in-progress rows as interrupted so they do not stay in a non-terminal state forever. The NOT IN list must match the terminal statuses defined by ChatDebugStatus in codersdk/chats.go. The steps CTE also catches steps whose parent run was just finalized (via run_id IN), because Postgre

(ctx context.Context, arg FinalizeStaleChatDebugRowsParams)

	// @now is the caller's clock timestamp so that mock-clock tests stay
	// consistent with the @updated_before cutoff.
	FinalizeStaleChatDebugRows(ctx context.Context, arg FinalizeStaleChatDebugRowsParams) (FinalizeStaleChatDebugRowsRow, error)
	// FindMatchingPresetID finds a preset ID that is the largest exact subset of the provided parameters.
	// It returns the preset ID if a match is found, or NULL if no match is found.
	// The query finds presets where all preset parameters are present in the provided parameters,