Function saveViewCollection

core/collection_query.go:261–297

------------------------------------------------------------------- saveViewCollection persists the provided View collection changes: - deletes the old related SQL view (if any) - creates a new SQL view with the latest newCollection.Options.Query - generates new feilds list based on newCollection.O

(app App, newCollection, oldCollection *Collection)

//
// This method returns an error if newCollection is not a "view".
func saveViewCollection(app App, newCollection, oldCollection *Collection) error {
	if !newCollection.IsView() {
		return errors.New("not a view collection")
	}

	return app.RunInTransaction(func(txApp App) error {
		query := newCollection.ViewQuery

		// generate collection fields from the query
		viewFields, err := txApp.CreateViewFields(query)
		if err != nil {
			return err
		}

		// delete old renamed view
		if oldCollection != nil {
			if err := txApp.DeleteView(oldCollection.Name); err != nil {
				return err
			}
		}

		// wrap view query if necessary
		query, err = normalizeViewQueryId(txApp, query)
		if err != nil {
			return fmt.Errorf("failed to normalize view query id: %w", err)
		}

		// (re)create the view
		if err := txApp.SaveView(newCollection.Name, query); err != nil {
			return err
		}

		newCollection.Fields = viewFields

		return txApp.Save(newCollection)
	})
}

// normalizeViewQueryId wraps (if necessary) the provided view query
// with a subselect to ensure that the id column is a text since