Skip to content

Instantly share code, notes, and snippets.

View kojiisd's full-sized avatar

Koji Ishida kojiisd

2 followers · 0 following
  • Acroquest Technology Co., Ltd.
  • Japan
View GitHub Profile
@kojiisd
kojiisd / file0.txt
Created January 5, 2019 09:04
Amazon TranslateにどうにかExcelを翻訳させてみた ref: https://qiita.com/kojiisd/items/fd790717084bbca51930
$ pip install xlrd
# 読み込み用
$ pip install xlwt
$ pip install openpyxl
# 書き込み用
@kojiisd
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
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
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
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
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
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
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
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
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>