.Insert[T](table, data)
Inserts one or multiple records in the database.
Method Syntax
db.Insert[T](table, data)
Arguments
| Arguments | Description |
|---|
table optional | Optionally pass along a table to insert into. |
data optional | Either a single document/record or an array of documents/records to insert |
cancellationToken optional | The cancellationToken enables graceful cancellation of asynchronous operations. |
Example usage
package main
import (
"fmt"
"time"
surrealdb "github.com/surrealdb/surrealdb.go"
"github.com/surrealdb/surrealdb.go/pkg/models"
)
func ExampleInsert() {
db, err := surrealdb.New("ws://localhost:8000")
if err != nil {
panic(err)
}
if err = db.Use("test", "test"); err != nil {
panic(err)
}
token, err := db.SignIn(&surrealdb.Auth{
Username: "root",
Password: "root",
})
if err != nil {
panic(err)
}
if err = db.Authenticate(token); err != nil {
panic(err)
}
type Person struct {
Name string `json:"name"`
CreatedAt models.CustomDateTime `json:"created_at,omitempty"`
UpdatedAt *models.CustomDateTime `json:"updated_at,omitempty"`
}
createdAt, err := time.Parse(time.RFC3339, "2023-10-01T12:00:00Z")
if err != nil {
panic(err)
}
var inserted *[]Person
inserted, err = surrealdb.Insert[Person](
db,
"persons",
map[string]any{
"name": "First",
"created_at": createdAt,
})
if err != nil {
panic(err)
}
fmt.Printf("Insert result: %+s\n", *inserted)
_, err = surrealdb.Insert[struct{}](
db,
"persons",
map[string]any{
"name": "Second",
"created_at": createdAt,
},
)
if err != nil {
panic(err)
}
_, err = surrealdb.Insert[struct{}](
db,
"persons",
Person{
Name: "Third",
CreatedAt: models.CustomDateTime{
Time: createdAt,
},
},
)
if err != nil {
panic(err)
}
fourthAsMap, err := surrealdb.Insert[map[string]any](
db,
"persons",
Person{
Name: "Fourth",
CreatedAt: models.CustomDateTime{
Time: createdAt,
},
},
)
if err != nil {
panic(err)
}
if _, ok := (*fourthAsMap)[0]["id"].(models.RecordID); ok {
delete((*fourthAsMap)[0], "id")
}
fmt.Printf("Insert result: %+s\n", *fourthAsMap)
selected, err := surrealdb.Select[[]Person](
db,
"persons",
)
if err != nil {
panic(err)
}
for _, person := range *selected {
fmt.Printf("Selected person: %+s\n", person)
}
}
