This PR adds a test case for all Cloud Spanner data types.

• [x] yaml.TestLoad
• [x] spanner.TestSave

Note: StringArray is commented because ARRAY types are not supported(#13).

Thank you for NICE tool.

With the following schema and yaml:

CREATE TABLE Users (
  UserId   INT64 NOT NULL,
  Name STRING(128),
) PRIMARY KEY (UserId);

- UserId: 101312
  Name: hoge

The following error occurred: failed to load data to spanner tables: failed to insert records: spanner: code = "InvalidArgument", desc = "client doesn't support type uint64

It would be more useful if the above yaml could be used.

temporary solution

As a temporary solution, I edited the yaml as shown below and the error did not occur. Int64 columns with '' .

- UserId: '101312'
  Name: hoge

Feature request to add example code to the repository, or README.md.

This tool seems to be very useful during development! But developers can't determine it because there is currently no example yaml, or etc. (well, I did read code, so I know these tools feature :P)

splanter seems to support all Cloud Spanner table column types except ARRAY types. Ideally, ARRAY types should be supported.

Schama

CREATE TABLE AllTypes (
                     ID STRING(MAX) NOT NULL,
                     BoolValue BOOL,
                     Int64Value INT64,
                     Float64Value FLOAT64,
                     TimestampValue TIMESTAMP,
                     DateValue DATE,
                     StringValue STRING(MAX),
                     BytesValue BYTES(MAX),
                     NumericValue NUMERIC,
                     JSONValue JSON,
                     StringArray ARRAY<STRING(MAX)>,
) PRIMARY KEY(ID);

YAML

---
# Values are need to be encoded as documented.
# https://cloud.google.com/spanner/docs/reference/rpc/google.spanner.v1#google.spanner.v1.TypeCode
- ID: "All_Type_Values"
  BoolValue: true
  BytesValue: "aG9nZQ==" # base64("hoge")
  DateValue: "2022-04-01"
  Float64Value: 3.14159
  Int64Value: 42
  JSONValue: '{"test": 1}'
  NumericValue: "-12345678901234567890123456789.123456789"
  StringValue: "FooBar"
  TimestampValue: "2022-04-01T00:00:00Z"
  # failed to load data to spanner tables: failed to insert records: spanner: code = "InvalidArgument", desc = "client doesn't support type []interface {}"exit status 1
  # StringArray:
  #   - "Foo"
  #   - "Bar"

In this case, it seems to need []interface{}-to-[]string conversion(using INFORMATION_SCHEMA or use reflection?). ARRAY<INT64>, ARRAY<TIMESTAMP>, etc are also should be supported