Skip to content

Instantly share code, notes, and snippets.

View kangaechu's full-sized avatar
🔰

kangaechu kangaechu

🔰
12 followers · 12 following
View GitHub Profile
@kangaechu
kangaechu / redash_queries.sql
Last active October 16, 2023 04:57 — forked from araki-ka/redash_queries.sql
redashクエリ一覧
WITH
-- ID List(なぜかqueries.idが欠損しているので、欠損分の穴埋めのために生成)
ids AS (
SELECT
generate_series(1, (SELECT MAX(id) AS id FROM queries)) AS id
),
-- クエリ情報
queries AS (
SELECT
i.id AS query_id,
@kangaechu
kangaechu / gist:6cfaaf358bdda6726220f0248108b1fc
Last active October 13, 2022 02:36
Diff for GitHub unarchived/archived repository
# archived
$ gh api /repos/kangaechu/archive-test
{
"id": 550561224,
"node_id": "R_kgDOINDlyA",
"name": "archive-test",
"full_name": "kangaechu/archive-test",
"private": false,
"owner": {
"login": "kangaechu",
@kangaechu
kangaechu / gist:c1d7bc3a48fb2c4e5dd567d9fa675fa6
Created October 13, 2022 01:19
A plan diff happens after archiving repository
$ TF_LOG=debug terraform plan
2022-10-13T10:09:45.496+0900 [INFO] Terraform version: 1.3.2
2022-10-13T10:09:45.497+0900 [DEBUG] using github.com/hashicorp/go-tfe v1.9.0
2022-10-13T10:09:45.497+0900 [DEBUG] using github.com/hashicorp/hcl/v2 v2.14.1
2022-10-13T10:09:45.497+0900 [DEBUG] using github.com/hashicorp/terraform-config-inspect v0.0.0-20210209133302-4fd17a0faac2
2022-10-13T10:09:45.497+0900 [DEBUG] using github.com/hashicorp/terraform-svchost v0.0.0-20200729002733-f050f53b9734
2022-10-13T10:09:45.497+0900 [DEBUG] using github.com/zclconf/go-cty v1.11.0
2022-10-13T10:09:45.497+0900 [INFO] Go runtime version: go1.19.1
2022-10-13T10:09:45.497+0900 [INFO] CLI args: []string{"/usr/local/Cellar/tfenv/3.0.0/versions/1.3.2/terraform", "plan"}
2022-10-13T10:09:45.497+0900 [DEBUG] Attempting to open CLI config file: /Users/satoshi.tanaka/.terraformrc
@kangaechu
kangaechu / tenki.py
Created December 7, 2019 07:01
tenki
import requests
from bs4 import BeautifulSoup
class Tenki():
def __init__(self, url):
res = requests.get(url)
self.soup = BeautifulSoup(res.text, 'html.parser')
def weather(self):
CSS_CLASS = '#forecast-point-1h-today > tr.weather td' # 天気
@kangaechu
kangaechu / keybase.md
Created September 10, 2019 10:06

Keybase proof

I hereby claim:

  • I am kangaechu on github.
  • I am kangaechu (https://keybase.io/kangaechu) on keybase.
  • I have a public key ASAKHGsE47EjM72UondeoOH-J5S8k8VEkU1zoHfr4Sf_qgo

To claim this, I am signing this object:

@kangaechu
kangaechu / serial_runner.sh
Created January 29, 2019 06:36
AWSのコマンドによくある「実行コマンドが非同期で確認コマンドで終了を確認する」タイプの処理を # シリアルに実行するために使用します。
#!/bin/bash
# serial_runner.sh
# AWSのコマンドによくある「実行コマンドが非同期で確認コマンドで終了を確認する」タイプの処理を
# シリアルに実行するために使用します。
#
# 使用方法：
# serial_runner.sh <実行コマンド> <確認コマンド> [状況確認コマンドの実行間隔] [最大確認回数]
# 実行コマンドの戻り値には確認コマンドで指定するIDを返すようにします。
# 確認コマンドに${ID}と記載すると、スクリプト内部で実行コマンドで取得したIDを置換した確認コマンドを生成します。
@kangaechu
kangaechu / rdd_dataframe.ipynb
Created December 1, 2018 14:11
PySpark day1
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@kangaechu
kangaechu / csv.ipynb
Last active December 1, 2018 14:28
PySpark day2
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@kangaechu
kangaechu / jumanpp-assert.cc.patch
Created June 6, 2018 05:57
--- src/util/assert-org.cc
+++ src/util/assert.cc
@@ -9,7 +9,7 @@
#include "util/common.hpp"
#ifndef _WIN32_WINNT
-#include <sys/sysctl.h>
+#include <linux/sysctl.h>
#include <sys/types.h>
#include <unistd.h>
@kangaechu
kangaechu / mqtt-tls.ino
Created January 28, 2017 01:43 — forked from chaeplin/mqtt-tls.ino
mqtt-tls.ino
#include <ESP8266WiFi.h>
#include <WiFiClientSecure.h>
#include <PubSubClient.h>
#include <ESP8266mDNS.h>
#include <WiFiUdp.h>
#include <ArduinoOTA.h>
#include "/usr/local/src/ap_setting.h"
#define DEBUG_PRINT 1