Comment on page
Golang

Creating a Spice Function in Go
Function Handlers
In the function.yaml , code execution runtime and invocation handler is defined.
Example function.yaml for a Go function
# hello_world/function.yaml
output_datasets: 
  - {orgName}.{appName}.hello_world
# This will trigger the function to execute on every new Ethereum block.
triggers:
  - path: eth
# This selects the runtime that will execute your code.
runtime: go1.x
# For Go, handler is [file_name_with_main].go
# The below will invoke the main method in a file `spice_function.go`.
handler: spice_function.go
Replace {orgName} and {appName} with the values for your specific org and app.
See Spice Functions YAML Specification for the full YAML schema.
Function Handlers
To implement a Function handler in Go, use the spice-functions-go package.
1.Get the spice-functions-go package:
go get github.com/spiceai/spice-functions-go
2.Wrap the function handler with the spice-functions-go handler.
// main.go
package main
​
import (
	"database/sql"
	"fmt"
	"github.com/spiceai/spice-functions-go/function"
	"github.com/spiceai/gospice/v3"
)
​
func hello(ctx *function.FunctionCtx, duckDb *sql.DB, spiceClient *gospice.SpiceClient) error {
	fmt.Println("Hello Spice Functions!")
	return nil
}
​
func main() {
	function.Run(hello)
}
A Go invocation handler method has the following signature:
func hello(ctx *function.FunctionCtx, duckDb *sql.DB, spiceClient *gospice.SpiceClient) error
ctx: A context.Context struct with additional getter funcs, E.g. BlockNumber() and BlockHash()
duckDb: A connection to the Spice Function's DuckDB instance.
spiceClient: A gospice client that is pre-initialized with the Spice app's API Key.
The handler method will be called on each triggered event.
Example Function
An example Go function:
package main
​
import (
	"database/sql"
	"fmt"
​
	"github.com/spiceai/gospice/v3"
	"github.com/spiceai/spice-functions-go/function"
)
​
func HelloWorldGo(ctx *function.FunctionCtx, duckDb *sql.DB, client *gospice.SpiceClient) error {
	fmt.Println("Hello from Spice Go runtime!")
​
	_, err = duckDb.ExecContext(ctx, "INSERT INTO output.hello_world_golang (block_number, greeting) VALUES ($1, $2);", ctx.BlockNumber(), "Hello from Spice Go runtime!")
	if err != nil {
		return err
	}
​
	return nil
}
​
func main() {
	function.Run(HelloWorldGo)
}
Last modified 1mo ago