25 lines (19 loc) · 584 Bytes

Quickstart

client := d1http.New(d1http.Config{
    AccountID:  os.Getenv("CLOUDFLARE_ACCOUNT_ID"),
    DatabaseID: os.Getenv("D1_DATABASE_ID"),
    APIToken:   os.Getenv("CLOUDFLARE_API_TOKEN"),
})

Run SQL:

_, err := client.Exec(ctx, "CREATE TABLE IF NOT EXISTS kv (key TEXT PRIMARY KEY, value TEXT)")
_, err = client.Exec(ctx, "INSERT INTO kv (key, value) VALUES (?, ?)", "hello", "world")
rows, err := client.Raw(ctx, "SELECT value FROM kv WHERE key = ?", "hello")

Convert raw rows to maps:

maps := rows[0].Maps()
fmt.Println(maps[0]["value"])