kojiisd’s gists

kojiisd / file0.txt

Created January 5, 2019 09:04

Amazon TranslateにどうにかExcelを翻訳させてみた ref: https://qiita.com/kojiisd/items/fd790717084bbca51930

kojiisd / file0.sql

Created January 1, 2019 01:53

低コストかつ簡単な方法でWebページを作成・更新をできるようにしてみた ref: https://qiita.com/kojiisd/items/58ebc5cd848484b58677

	update wp_posts set guid=REPLACE(guid, 'http://＜旧IPアドレス＞/', 'http://＜新IPアドレス＞/') where post_type='page';

	update wp_options set option_value=REPLACE(option_value, 'http://＜旧IPアドレス＞', 'http://＜新IPアドレス＞') where option_value like ('%＜旧IPアドレス＞%');

kojiisd / file0.txt

Last active December 24, 2018 11:41

AWS Amplify ConsoleとAWS CodeBuildでサーバレスアプリをデプロイするまでどれくらいでできるかタイムトライアルしてみた ref: https://qiita.com/kojiisd/items/9649f374d89345c78cb6

	version: 0.2

	phases:
	install:
	commands:
	- apt-get update -y
	- npm install -g serverless
	pre_build:
	commands:
	- sed -i -e "s\|COGNITO_IDP_ARN\|${COGNITO_IDP_ARN}\|g" serverless.yml

kojiisd / file0.txt

Last active November 27, 2018 02:21

AWS Amplify Consoleがどれだけお手軽か試してみた所感 ref: https://qiita.com/kojiisd/items/709557fa4649aa25b483

	export const environment = {
	production: false,
	amplify: {
	Auth: {
	region: 'REGION',
	userPoolId: 'USER_POOL_ID',
	userPoolWebClientId: 'USER_POOL_WEB_CLIENT_ID',
	identityPoolId: 'IDENTITY_POOL_ID'
	}
	},

kojiisd / file0.sh

Created October 7, 2018 10:54

GitLab APIを使ってIssuesの一覧を取得できるようにした ref: https://qiita.com/kojiisd/items/e5af8ef89592c4615c99

	$ pip install -t libs requests
	$ pip install -t libs beautifulsoup4

kojiisd / file0.py

Created September 2, 2018 09:14

AWS LambdaでCognitoユーザ一覧を取得 ref: https://qiita.com/kojiisd/items/690b5952835823ac1be1

	import json
	from datetime import datetime
	import os
	import boto3

	cognito_client = boto3.client('cognito-idp')

	def list_users(event, context):

	if 'UserPoolId' not in event:

kojiisd / file0.sh

Last active August 26, 2018 08:10

サブドメインをRoute 53で管理してみた（メインはCloud DNSで管理、ドメイン移管なし） ref: https://qiita.com/kojiisd/items/2fe717cfc980c0bd46d8

	$ dig ns test-kojiisd.tk

	:
	:

	;; ANSWER SECTION:
	test-kojiisd.tk. 60 IN NS ns-cloud-a4.googledomains.com.
	test-kojiisd.tk. 60 IN NS ns-cloud-a1.googledomains.com.
	test-kojiisd.tk. 60 IN NS ns-cloud-a2.googledomains.com.
	test-kojiisd.tk. 60 IN NS ns-cloud-a3.googledomains.com.

kojiisd / file0.txt

Created August 13, 2018 22:28

今さらだけどAlexaのカスタムスキルを作ってみた ref: https://qiita.com/kojiisd/items/bc6e53026b08fca38aab

	import datetime
	import locale

	def lambda_handler(event, context):
	intent = event['request']['intent']
	date_str = intent['slots']['date']['value']

	locale.setlocale(locale.LC_TIME, 'ja_JP.UTF-8')
	date = datetime.datetime.strptime(date_str, '%Y-%m-%d')

kojiisd / file0.sh

Created August 12, 2018 06:15

remot3.itでインバウンド全閉じ状態のマシンにインターネット経由でアクセスしてみた ref: https://qiita.com/kojiisd/items/5ccc14098ba34fb508ce

	pi@raspberrypi:~ $ cat /etc/os-release
	PRETTY_NAME="Raspbian GNU/Linux 9 (stretch)"
	NAME="Raspbian GNU/Linux"
	VERSION_ID="9"
	VERSION="9 (stretch)"
	ID=raspbian
	ID_LIKE=debian
	HOME_URL="http://www.raspbian.org/"
	SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
	BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs"

kojiisd / file0.html

Last active July 19, 2018 01:36

Amazon Translateが日本語対応したので使ってみた ref: https://qiita.com/kojiisd/items/e2bc1b655524100511b8

	<tr>
	<td><label>Source Language: </label></td>
	<td>
	<select name="srcLang">
	<option value="en" selected>English</option>
	<option value="zh">Chinese (Simplified)</option>
	<option value="fr">French</option>
	<option value="de">German</option>
	<option value="pt">Portuguese</option>
	<option value="es">Spanish</option>

Koji Ishida kojiisd