Skip to content

Instantly share code, notes, and snippets.

View gecko655's full-sized avatar
🍅
アウトロが終わるとページをめくるたびにドキドキピルエット

YAMAMORI, Akihiro gecko655

🍅
アウトロが終わるとページをめくるたびにドキドキピルエット
31 followers · 18 following
View GitHub Profile
@gecko655
gecko655 / terraform_apply_google_cloudbuild_worker_pool.txt
Last active March 1, 2022 04:42
❯ TF_LOG=DEBUG terraform apply
2022-03-01T13:37:25.519+0900 [INFO] Terraform version: 1.1.6
2022-03-01T13:37:25.519+0900 [INFO] Go runtime version: go1.17.2
2022-03-01T13:37:25.519+0900 [INFO] CLI args: []string{"/Users/[user_name]/.asdf/installs/terraform/1.1.6/bin/terraform", "apply"}
2022-03-01T13:37:25.520+0900 [DEBUG] Attempting to open CLI config file: /Users/[user_name]/.terraformrc
2022-03-01T13:37:25.520+0900 [DEBUG] File doesn't exist, but doesn't need to. Ignoring.
2022-03-01T13:37:25.523+0900 [DEBUG] checking for credentials in "/Users/[user_name]/.terraform.d/plugins"
2022-03-01T13:37:25.523+0900 [DEBUG] checking for credentials in "/Users/[user_name]/.terraform.d/plugins/darwin_amd64"
2022-03-01T13:37:25.524+0900 [DEBUG] ignoring non-existing provider search directory terraform.d/plugins
2022-03-01T13:37:25.524+0900 [DEBUG] will search for provider plugins in /Users/[user_name]/.terraform.d/plugins
@gecko655
gecko655 / DataflowTemplates_build_fails_command.sh
Last active December 21, 2021 08:36
https://github.com/GoogleCloudPlatform/DataflowTemplates build fails
git clone git@github.com:GoogleCloudPlatform/DataflowTemplates.git DataflowTemplates
cd DataflowTemplates/v2
git rev-parse HEAD
# -> 68e6939d82e1ad84aa69f33e59c74d6bdea89a3e
docker run --rm -v $(pwd):/root --entrypoint=bash gcr.io/cloud-builders/mvn@sha256:d2142eae8adb79128665fdfb2953cb3135ef83b9f21c3d113273bc8907c88bdf \
-c "cd /root && mvn clean test --batch-mode \
-Dimage=gcr.io/hoge/piyo \
-Dbase-container-image='gcr.io/dataflow-templates-base/java8-template-launcher-base' \
-Dbase-container-image.version=latest \
-Dapp-root=/template/pubsub-cdc-to-bigquery \
@gecko655
gecko655 / go_embed.go
Last active October 4, 2021 10:56
package main
import (
_ "embed"
"fmt"
"strings"
)
//go:embed test.txt
var Content []byte
@gecko655
gecko655 / debug_log_for_terraform-provider-google_8579.txt
Last active March 1, 2021 06:11
2021-02-26T12:43:08.637+0900 [INFO] plugin: configuring client automatic mTLS
2021-02-26T12:43:08.656+0900 [DEBUG] plugin: starting plugin: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5 args=[.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5]
2021-02-26T12:43:08.667+0900 [DEBUG] plugin: plugin started: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5 pid=30310
2021-02-26T12:43:08.667+0900 [DEBUG] plugin: waiting for RPC address: path=.terraform/providers/registry.terraform.io/hashicorp/google/3.52.0/darwin_amd64/terraform-provider-google_v3.52.0_x5
2021-02-26T12:43:08.684+0900 [INFO] plugin.terraform-provider-google_v3.52.0_x5: configuring server automatic mTLS: timestamp=2021-02-26T12:43:08.684+0900
2021-02-26T12:43:08.704+0900 [DEBUG] plugin.terraform-provider-google_v3.52.0_x5: plugin address
@gecko655
gecko655 / uniontest.sql
Created June 23, 2020 03:43
BigQuery union behavior with different column definition
create table `uniontest.uniontest_1`
(partition_key date, cluster_key string, hoge string)
partition by partition_key
cluster by cluster_key
as select cast('2020-06-22' as date), 'a', 'b';
create table `uniontest.uniontest_2`
(partition_key date, cluster_key string, piyo string)
partition by partition_key
cluster by cluster_key
@gecko655
gecko655 / airflow_monitoring.py
Last active June 21, 2021 06:45
The file added by cloud composer when creating the environment
"""A liveness prober dag for monitoring composer.googleapis.com/environment/healthy."""
import airflow
from airflow import DAG
from airflow.operators.bash_operator import BashOperator
from datetime import timedelta
default_args = {
'start_date': airflow.utils.dates.days_ago(0),
'retries': 1,
'retry_delay': timedelta(minutes=5)
@gecko655
gecko655 / aikatsu_spotify_audio_features.csv
Last active May 7, 2020 06:35
アイカツ！楽曲のSpotifyによる音楽特徴量データ https://gecko655.hatenablog.com/entry/aikatsu_adc_2019_17
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 19 columns, instead of 10. in line 4.
id,name,popularity,album_name,artists_name,spotify_url,acousticness,danceability,duration_ms,energy,instrumentalness,key,liveness,loudness,mode,speechiness,tempo,time_signature,valence
1s1FMdNHcSpOfZR2cEjh0J,カレンダーガール,34,TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1,わか・ふうり・すなお from STAR☆ANIS,https://open.spotify.com/track/1s1FMdNHcSpOfZR2cEjh0J,0.185,0.592,264933,0.988,0,4,0.0601,0.239,True,0.152,135.063,4,0.531
3jPCPEwTmiQT97V247njPu,ダイヤモンドハッピー,30,TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目2,わか・ふうり・すなお from STAR☆ANIS,https://open.spotify.com/track/3jPCPEwTmiQT97V247njPu,0.0222,0.576,247707,0.984,0.0000613,10,0.38,-1.374,False,0.112,116.522,4,0.522
0aLmO5jZ8AeHSRoFzB8gz0,アイドル活動!,29,TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1,わか・ふうり・すなお from STAR☆ANIS,https://open.spotify.com/track/0aLmO5jZ8AeHSRoFzB8gz0,0.0265,0.524,272960,0.96,0,4,0.163,-2.922,True,0.0446,95.004,4,0.618
60kngDFK7Nm65hx1Wtep9L,Trap of Love,29,TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1,すなお・わか・ふうりfrom STAR☆ANIS,https://open.spotify.com/track/60kngDFK7Nm65hx1Wtep9L,0.115,0.592,231093,0.9
@gecko655
gecko655 / SPOTIFY_GET_TRACKS.md
Last active June 7, 2021 00:35
Spotifyの楽曲データを取得するスクリプト群
@gecko655
gecko655 / aikatsu_spotify_tracks.csv
Last active December 16, 2019 12:45
アイカツ！楽曲のSpotify上の楽曲データ https://gecko655.hatenablog.com/entry/aikatsu_adc_2019_16
曲名 popularity アルバム名 アーティスト URL
カレンダーガール 34 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1 わか・ふうり・すなお from STAR☆ANIS https://open.spotify.com/track/1s1FMdNHcSpOfZR2cEjh0J
ダイヤモンドハッピー 30 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目2 わか・ふうり・すなお from STAR☆ANIS https://open.spotify.com/track/3jPCPEwTmiQT97V247njPu
アイドル活動! 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1 わか・ふうり・すなお from STAR☆ANIS https://open.spotify.com/track/0aLmO5jZ8AeHSRoFzB8gz0
Trap of Love 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1 すなお・わか・ふうりfrom STAR☆ANIS https://open.spotify.com/track/60kngDFK7Nm65hx1Wtep9L
硝子ドール 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 1年目1 もえ・すなおfrom STAR☆ANIS https://open.spotify.com/track/5yFfhtvMQmPxppKzkMdrVe
SHINING LINE* 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 2年目2 わか・ふうり・ゆな from STAR☆ANIS https://open.spotify.com/track/45s4b55fdR2SbKIMUOxCXh
オリジナルスター☆彡 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 2年目1 わか・ふうり・すなお・れみ・もえ・えり・ゆな・りすこ from STAR☆ANIS https://open.spotify.com/track/49H75OFzOhGIlhbI9qA1Ph
チュチュ・バレリーナ 29 TVアニメ/データカードダス『アイカツ!』主題歌/挿入歌 3年目2 もな・るか・みき from AIKATSU☆STARS! https:
@gecko655
gecko655 / kahoha_yasashiishi_kawaii_noka.sh
Last active June 15, 2019 16:37
かほは優しいし可愛いのか？
# require: https://github.com/kakakaya/goshindan
for i in `seq 1 50000`
do
ret=`goshindan s -s 531740 -u $i`
pr=`echo "scale=5;1-((18225-1)/18225)^$i" | bc`
echo $i $pr $ret
if [[ $(echo $ret | grep 'かほは優しいし可愛い。') ]]; then
exit
fi