Skip to content

Instantly share code, notes, and snippets.

View sinmetal's full-sized avatar

sinmetal sinmetal

83 followers · 25 following
View GitHub Profile
@sinmetal
sinmetal / main.go
Created November 13, 2019 03:23
cloud.google.com/go/spanner/admin sample
package main
import (
"context"
"fmt"
"google.golang.org/genproto/protobuf/field_mask"
instance "cloud.google.com/go/spanner/admin/instance/apiv1"
instancepb "google.golang.org/genproto/googleapis/spanner/admin/instance/v1"
)
@sinmetal
sinmetal / main.go
Created May 25, 2018 02:47
urlfetch context.WithTimeout
package main
import (
"context"
"fmt"
"net/http"
"time"
"google.golang.org/appengine"
"google.golang.org/appengine/urlfetch"
@sinmetal
sinmetal / cloudsql.go
Created February 5, 2018 08:31
Cloud SQL Proxy Library for Go
package main
import (
"fmt"
"time"
"github.com/GoogleCloudPlatform/cloudsql-proxy/proxy/dialers/mysql"
"github.com/google/uuid"
)
@sinmetal
sinmetal / mvn.txt
Created January 31, 2018 05:20
mvn dependency:tree
INFO] org.sinmetal.mlapi:cleansing:jar:0.1
[INFO] +- org.apache.beam:beam-sdks-java-core:jar:2.2.0:compile
[INFO] | +- com.google.code.findbugs:jsr305:jar:3.0.1:compile
[INFO] | +- com.fasterxml.jackson.core:jackson-core:jar:2.8.9:compile
[INFO] | +- com.fasterxml.jackson.core:jackson-annotations:jar:2.8.9:compile
[INFO] | +- com.fasterxml.jackson.core:jackson-databind:jar:2.8.9:compile
[INFO] | +- org.apache.avro:avro:jar:1.8.2:compile
[INFO] | | +- org.codehaus.jackson:jackson-core-asl:jar:1.9.13:compile
[INFO] | | +- org.codehaus.jackson:jackson-mapper-asl:jar:1.9.13:compile
[INFO] | | +- com.thoughtworks.paranamer:paranamer:jar:2.7:compile
@sinmetal
sinmetal / export.go
Created November 27, 2017 02:32
Google Cloud Datastore Export Handler
package datastorebackup
import (
"fmt"
"net/http"
"time"
"google.golang.org/appengine"
"google.golang.org/appengine/log"
"google.golang.org/appengine/user"
@sinmetal
sinmetal / meta-projectid.go
Created November 1, 2017 09:23
Metdata ServerからProjectIDを取得するサンプル
package main
import (
"fmt"
"io/ioutil"
"net/http"
)
const MetadataServerURL = "http://metadata.google.internal/computeMetadata/v1/project/"
@sinmetal
sinmetal / bigquery.jobs.get.resutls.json
Created September 15, 2017 11:12
{
"kind": "bigquery#job",
"etag": "\"Nffj8WcBg8Vy0jj5i2Ow4j6Mrcs/Z3XdJy-3ci8it9bJqScatGFAerI\"",
"id": "metal-tile-dev0:bquijob_57d01daf_15e853bceec",
"selfLink": "https://www.googleapis.com/bigquery/v2/projects/metal-tile-dev0/jobs/bquijob_57d01daf_15e853bceec",
"jobReference": {
"projectId": "metal-tile-dev0",
"jobId": "bquijob_57d01daf_15e853bceec"
},
"configuration": {
@sinmetal
sinmetal / pubsub.request.md
Created September 13, 2017 10:41
Cloud PubSub Push Request Memo

App Engine StandardでCloud Pub/SubのPush Requestを受けた時のRequestの内容。 Headerに認証のTokenを入れるみたいなのはないっぽいので、やりたいなら、BodyのAttributesに適当にToken入れる感じだろうか。

Request Header

  • Content-Length = [284]
  • Accept-Charset = [UTF-8]
  • X-Appengine-Country = [ZZ]
  • X-Cloud-Trace-Context = [b637a4a25755adafd922090e3c844cee/379846021913007296]
  • Host = [sinmetal-pubsub.appspot.com]
@sinmetal
sinmetal / httpsv.go
Created August 25, 2017 02:18
package main
import (
"fmt"
"log"
"net/http"
"cloud.google.com/go/compute/metadata"
)
@sinmetal
sinmetal / cron.yaml
Created July 12, 2017 01:43
DatastoreBackup Sample
cron:
- description: Daily Backup
url: /_ah/datastore_admin/backup.create?name=BackupToCloud&kind=Billing&kind=Project&filesystem=gs&gs_bucket_name=datastore-backup&queue=backup
schedule: every day 02:00
timezone: Asia/Tokyo
target: ah-builtin-python-bundle
- description: Billing Report to Slack
url: /cron/1/billing/ratio
schedule: every day 10:00
timezone: Asia/Tokyo