Function loadFunction

server/node/create_trigger.go:169–199

loadFunction loads the function with the given ID from the given collection. If the collection is nil, then this also loads the collection from the context.

(ctx *sql.Context, funcCollection *functions.Collection, funcID id.Function)

// loadFunction loads the function with the given ID from the given collection. If the collection is nil, then this also
// loads the collection from the context.
func loadFunction(ctx *sql.Context, funcCollection *functions.Collection, funcID id.Function) (functions.Function, error) {
	var err error
	if funcCollection == nil {
		funcCollection, err = core.GetFunctionsCollectionFromContext(ctx, "")
		if err != nil {
			return functions.Function{}, err
		}
	}
	var function functions.Function
	if len(funcID.SchemaName()) > 0 {
		function, err = funcCollection.GetFunction(ctx, funcID)
		if err != nil {
			return functions.Function{}, err
		}
	} else {
		searchPaths, err := core.SearchPath(ctx)
		if err != nil {
			return functions.Function{}, err
		}
		for _, searchPath := range searchPaths {
			function, err = funcCollection.GetFunction(ctx, id.NewFunction(searchPath, funcID.FunctionName()))
			if err != nil {
				return functions.Function{}, err
			}
			if function.ID.IsValid() {
				break
			}
		}
	}
	return function, nil
}