Method AutoArchiveInactiveChats

coderd/database/querier.go:73–73

Archives inactive root chats (pinned and already-archived chats skipped), cascading to children via root_chat_id. Limits apply to roots, not total rows. The Go caller passes @archive_cutoff as UTC midnight so that all chats sharing the same last-activity date are archived together. Used by dbpurge.

(ctx context.Context, arg AutoArchiveInactiveChatsParams)

	// created_at ASC flows through to dbpurge's digest truncation; see
	// buildDigestData in dbpurge.go for the tradeoff rationale.
	AutoArchiveInactiveChats(ctx context.Context, arg AutoArchiveInactiveChatsParams) ([]AutoArchiveInactiveChatsRow, error)
	// old_provider is matched as text; new_provider is also cast to ai_provider_type
	// for the EXISTS check against ai_providers.type.
	// ai_provider_id IS NOT NULL is defensive; the check constraint already