Method removeDatabaseCache

backend/store/database.go:85–97

removeDatabaseCache invalidates both workspace-scoped and unscoped cache entries for a database.

(ctx context.Context, instanceID, databaseName string)

// removeDatabaseCache invalidates both workspace-scoped and unscoped cache entries for a database.
func (s *Store) removeDatabaseCache(ctx context.Context, instanceID, databaseName string) {
	// Remove unscoped (runner) cache entry.
	s.databaseCache.Remove(getDatabaseCacheKey("", instanceID, databaseName))
	// Remove workspace-scoped (API) cache entry.
	// Query workspace directly from instance table to avoid workspace-filtering issues with GetInstance.
	var workspace string
	if err := s.GetDB().QueryRowContext(ctx,
		"SELECT workspace FROM instance WHERE resource_id = $1", instanceID,
	).Scan(&workspace); err != nil {
		return
	}
	s.databaseCache.Remove(getDatabaseCacheKey(workspace, instanceID, databaseName))
}

// GetDatabase gets a database.
func (s *Store) GetDatabase(ctx context.Context, find *FindDatabaseMessage) (*DatabaseMessage, error) {