Kazutaka Goto kazgoto

kazgoto / thirdparty-RI-offering-search.sh

Last active October 28, 2020 09:46

Thirdparty RI を調べるワンライナー with Docker

	docker run --rm -i -v ~/.aws:/root/.aws amazon/aws-cli ec2 describe-reserved-instances-offerings \
	--profile [email protected] --instance-type m1.large \
	--offering-class standard \
	--product-description "Linux/UNIX" \
	--instance-tenancy default \
	--filters Name=marketplace,Values=true \| jq -r '.ReservedInstancesOfferings[] \|
	[.OfferingClass, .ProductDescription, .InstanceType, .OfferingType, .FixedPrice, .Duration, .ReservedInstancesOfferingId] \| @csv'

kazgoto / current-usdjpy.sh

Created July 15, 2015 03:49

get current USDJPY from Yahoo! Japan Finance

curl -s http://info.finance.yahoo.co.jp/fx/ | ruby -ne '$_.match(/<span id="USDJPY_top_bid">(.*?)<\/span>/){|s| puts s[1]}'

kazgoto / make-user-list-tsv.sh

Last active August 29, 2015 14:24

Active Slack User List TSV from user-list.json

cat user-list.json | jq -r '.members[] | select(.deleted==false) | "\(.id)\t\(.name)\t\(.real_name)"' 

kazgoto / unescape-unicode.sh

Last active December 28, 2017 16:13

Ruby One Liner to unescape unicode chars in JSON

cat unicode-escaped.json | ruby -ne 'puts $_.gsub(/\\u([\da-fA-F]{4})/) { [$1].pack("H*").unpack("n*").pack("U*") }'

kazgoto / lastmonth-usdjpy.sh

Last active September 9, 2020 04:13

get last month's average USDJPY from Mizuho Bank

curl -s https://www.mizuhobank.co.jp/market/csv/m_quote.csv | tail -1 | cut -d ',' -f 2

kazgoto / snippet-code-for-footer.php

Last active August 29, 2015 14:20

WordPressで開発・ステージングなどの環境名をリボンで表示する

	<?php
	// 設定方法: footer.phpの最後 wp_footer(); 直前に以下を追加する
	$envfile = '/var/www/env'; // 環境名定義
	if (file_exists($envfile) and filesize($envfile) > 0) {
	$envlabel = file_get_contents($envfile);
	?>
	<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/github-fork-ribbon-css/0.1.1/gh-fork-ribbon.css" />
	<div class="github-fork-ribbon-wrapper right fixed" onClick="this.style.display='none'" title="<?php echo $envlabel?>">
	<div class="github-fork-ribbon"><a href="#"><?php echo $envlabel ?></a></div>
	</div>

kazgoto / salesforce-beautify.css

Last active August 29, 2015 14:18

Salesforce UIカスタマイズCSSメモ

	* {
	font-family: 'Noto Sans', sans-serif !important;
	}

kazgoto / extract-rssfeeds-aws-service-dashboard.rb

Last active August 29, 2015 14:03

AWS Service Health DashboardからRSSフィードを抽出（2014.7.7版）

	require 'rubygems'
	require 'nokogiri'
	require 'open-uri'

	doc = Nokogiri::HTML(open('http://status.aws.amazon.com/'))

	doc.xpath('//td[@class="bb center top"]/a').each do \|link\|
	puts 'http://status.aws.amazon.com/' + link.attribute('href').value
	end

kazgoto / custom-conditional-formatter-sample.js

Last active December 24, 2015 21:28

Google Spreadsheetで、Excelの条件付き書式と同様、特定カラムの値で行の背景色を変えるとしたらスクリプト書かないといけないんだ。ちょっと面倒...

	function onEdit(event)
	{
	var status = new Array('納品待', '納品済', '無効');
	var color = new Array('#fffe99', '#ccfecc', '#b7b7b7');

	var keywordCol = 11;
	var columnStart = 1;
	var columnNum = 15;

	var range = event.source.getActiveRange();