/
spanner_test.go
117 lines (104 loc) · 2.92 KB
/
spanner_test.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
package spanner
import (
"cloud.google.com/go/spanner"
database "cloud.google.com/go/spanner/admin/database/apiv1"
instance "cloud.google.com/go/spanner/admin/instance/apiv1"
"context"
"fmt"
"google.golang.org/api/option"
"google.golang.org/api/option/internaloption"
databasepb "google.golang.org/genproto/googleapis/spanner/admin/database/v1"
instancepb "google.golang.org/genproto/googleapis/spanner/admin/instance/v1"
"google.golang.org/grpc"
"google.golang.org/grpc/credentials/insecure"
"testing"
)
const (
projectId = "test-project"
instanceId = "test-instance"
databaseName = "test-db"
)
func TestSpanner(t *testing.T) {
ctx := context.Background()
container, err := setupSpanner(ctx)
if err != nil {
t.Fatal(err)
}
// Clean up the container after the test is complete
t.Cleanup(func() {
if err := container.Terminate(ctx); err != nil {
t.Fatalf("failed to terminate container: %s", err)
}
})
options := []option.ClientOption{
option.WithEndpoint(container.GRPCEndpoint),
option.WithGRPCDialOption(grpc.WithTransportCredentials(insecure.NewCredentials())),
option.WithoutAuthentication(),
internaloption.SkipDialSettingsValidation(),
}
instanceAdmin, err := instance.NewInstanceAdminClient(ctx, options...)
if err != nil {
t.Fatal(err)
}
defer instanceAdmin.Close()
instanceOp, err := instanceAdmin.CreateInstance(ctx, &instancepb.CreateInstanceRequest{
Parent: fmt.Sprintf("projects/%s", projectId),
InstanceId: instanceId,
Instance: &instancepb.Instance{
DisplayName: instanceId,
},
})
if err != nil {
t.Fatal(err)
}
_, err = instanceOp.Wait(ctx)
if err != nil {
t.Fatal(err)
}
c, err := database.NewDatabaseAdminClient(ctx, options...)
if err != nil {
t.Fatal(err)
}
defer c.Close()
databaseOp, err := c.CreateDatabase(ctx, &databasepb.CreateDatabaseRequest{
Parent: fmt.Sprintf("projects/%s/instances/%s", projectId, instanceId),
CreateStatement: fmt.Sprintf("CREATE DATABASE `%s`", databaseName),
ExtraStatements: []string{
"CREATE TABLE Languages (Language STRING(MAX), Mascot STRING(MAX)) PRIMARY KEY (Language)",
},
})
if err != nil {
t.Fatal(err)
}
_, err = databaseOp.Wait(ctx)
if err != nil {
t.Fatal(err)
}
db := fmt.Sprintf("projects/%s/instances/%s/databases/%s", projectId, instanceId, databaseName)
client, err := spanner.NewClient(ctx, db, options...)
if err != nil {
t.Fatal(err)
}
defer client.Close()
_, err = client.Apply(ctx, []*spanner.Mutation{
spanner.Insert("Languages",
[]string{"language", "mascot"},
[]interface{}{"Go", "Gopher"})})
if err != nil {
t.Fatal(err)
}
row, err := client.Single().ReadRow(ctx, "Languages",
spanner.Key{"Go"}, []string{"mascot"})
if err != nil {
t.Fatal(err)
}
var mascot string
err = row.ColumnByName("Mascot", &mascot)
if err != nil {
t.Fatal(err)
}
// perform assertions
if mascot != "Gopher" {
t.Fatalf("Expected value %s. Got %s.", "Gopher", mascot)
}
}