Method CreateView

internal/store/views.go:11–44

CreateView adds a new saved view.

(workspaceID string, input models.ViewCreate)

// CreateView adds a new saved view.
func (s *Store) CreateView(workspaceID string, input models.ViewCreate) (*models.View, error) {
	id := newID()
	ts := now()

	slug := input.Slug
	if slug == "" {
		slug = slugify(input.Name)
	}
	slug, err := s.uniqueSlug("views", "workspace_id", workspaceID, slug)
	if err != nil {
		return nil, fmt.Errorf("generate slug: %w", err)
	}

	config := input.Config
	if config == "" {
		config = "{}"
	}

	viewType := input.ViewType
	if viewType == "" {
		viewType = "list"
	}

	_, err = s.db.Exec(s.q(`
		INSERT INTO views (id, workspace_id, collection_id, name, slug, view_type, config, sort_order, is_default, created_at, updated_at)
		VALUES (?, ?, ?, ?, ?, ?, ?, 0, ?, ?, ?)`),
		id, workspaceID, input.CollectionID, input.Name, slug, viewType, config, s.dialect.BoolToInt(false), ts, ts,
	)
	if err != nil {
		return nil, fmt.Errorf("insert view: %w", err)
	}

	return s.GetView(id)
}

// GetView returns a single view by ID.
func (s *Store) GetView(id string) (*models.View, error) {