apstndb

import "list"

a: [{id: 1}, {id: 2}]
b: [{id: 1}, {id: 1}]
c: [{id: 1}, {id: 2}, {id: 2}]

a_ids:: [x.id for x in a]
a_unique: list.UniqueItems(a_ids)

unique :: {

apstndb

CREATE TEMP FUNCTION typeof_literal(input STRING)
AS (
      CASE
        -- Process NUMERIC, DATE, DATETIME, TIME, TIMESTAMP,
        WHEN REGEXP_CONTAINS(input, r'^[A-Z]+ "') THEN REGEXP_EXTRACT(input, r'^([A-Z]+) "')
        WHEN REGEXP_CONTAINS(input, r'^-?[0-9]*$') THEN 'INT64'
        WHEN REGEXP_CONTAINS(input, r'^(-?[0-9]+[.e].*|CAST\("([^"]*)" AS FLOAT64\))$') THEN 'FLOAT64'
        WHEN input IN ('true', 'false') THEN 'BOOL'
        WHEN input LIKE '"%' THEN 'STRING'
        WHEN input LIKE 'b"%' THEN 'BYTES'

apstndb

• https://stackoverflow.com/a/49985190

apstndb

Start Cloud Spanner Emulator

gcloud beta emulators spanner start

Setup database(not idempotent and error prone)

SPANNER_EMULATOR_HOST_REST=localhost:9020

apstndb

Test about The backing indexes of Cloud Spanner Foreign Keys.

Tested at GCPUG Shared Spanner on 2020-03-10.

DDL

CREATE TABLE Referenced (

apstndb

curl -s https://packages.cloud.google.com/apt/dists/cloud-sdk/main/binary-amd64/Packages |
    gojq -srR 'def ver: split("-")[0];
               split("\n\n") |
               map(gsub("\n  "; " ") |
                   split("\n") |
                   map(capture("^(?<key>[A-Z][a-zA-Z-]*): (?<value>.*)$"; "")) |
                   from_entries) |
               group_by(.Package) |
               map({key: .[0].Package, value: (sort_by(.Version))}) |
               from_entries |

apstndb

package main

import (
	"context"
	"flag"

	"cloud.google.com/go/datastore"
	"github.com/k0kubun/pp"

	"log"

apstndb

Follow official gRPC example https://knative.dev/docs/serving/samples/grpc-ping-go/

GCP_PROJECT="your-own-project"

git clone -b "release-0.9" https://github.com/knative/docs knative-docs
cd knative-docs/docs/serving/samples/grpc-ping-go
gcloud builds submit --tag "gcr.io/${GCP_PROJECT}/grpc-ping-go"
gcloud beta run deploy --image=gcr.io/${GCP_PROJECT}/grpc-ping-go --allow-unauthenticated --platform=managed --region=asia-northeast1 grpc-ping

apstndb

Run gcping for each regions.

pivot table https://docs.google.com/spreadsheets/d/e/2PACX-1vTuzRKBOnjVjeNXab2_aDR5XlHBDYBzpGWLMspNd1xQNk0nB0-MTI6RI_XynV_BduaQvJ0o6xpPCiyy/pubhtml

apstndb

setting

$ gcloud iam service-accounts create callee
$ gcloud iam service-accounts create caller
$ gcloud builds submit -t gcr.io/${PROJECT_ID}/oidctest .
$ gcloud beta run deploy --image=gcr.io/${PROJECT_ID}/oidctest --allow-unauthenticated \
    --service-account=caller@${PROJECT_ID}.iam.gserviceaccount.com caller 
$ gcloud beta run deploy --image=gcr.io/${PROJECT_ID}/oidctest --no-allow-unauthenticated \
    --service-account=callee@{PROJECT_ID}.iam.gserviceaccount.com callee