Method CreateView

backend/store/model/database.go:610–631

CreateView creates a new view in the schema. Returns an error if the view already exists.

(viewName string, definition string, dependencyColumns []*storepb.DependencyColumn)

// CreateView creates a new view in the schema.
// Returns an error if the view already exists.
func (s *SchemaMetadata) CreateView(viewName string, definition string, dependencyColumns []*storepb.DependencyColumn) (*storepb.ViewMetadata, error) {
	// Check if view already exists
	if s.GetView(viewName) != nil {
		return nil, errors.Errorf("view %q already exists in schema %q", viewName, s.proto.Name)
	}

	// Create new view proto
	newViewProto := &storepb.ViewMetadata{
		Name:              viewName,
		Definition:        definition,
		DependencyColumns: dependencyColumns,
	}

	// Add to proto's view list
	s.proto.Views = append(s.proto.Views, newViewProto)

	// Add to internal map
	viewID := normalizeNameByCaseSensitivity(viewName, s.isObjectCaseSensitive)
	s.internalViews[viewID] = newViewProto

	return newViewProto, nil
}

// DropView drops a view from the schema.
// Returns an error if the view does not exist.