Skip to content

Instantly share code, notes, and snippets.

View matsubo's full-sized avatar

Yuki Matsukura matsubo

View GitHub Profile
@matsubo
matsubo / gist:cb875c98b3fd740abb24dd9f8f33d8a0
Created May 19, 2024 03:13
mysql 8.4に対応するためにパスワードのプラグインを変更する方法
# dockerコンテナの場合は手動で立ち上げて、そのコンテナにexecで入ってローカルに接続して変更する
ALTER USER 'root'@'localhost' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
ALTER USER 'root'@'%' IDENTIFIED with caching_sha2_password BY 'xxxxxxxxx'
@matsubo
matsubo / gist:dadcfc7554bc62855352b899bf5a7348
Created May 15, 2024 21:55
Delete all article using wp-cli.
$ wp post list| awk '{print $1} '| xargs -n 1 -I XXX wp post delete XXX --force
@matsubo
matsubo / gist:ac31be9578834db85e034ac54c0b433f
Created January 21, 2024 15:05
install nodejs oneliner on Ubuntu or Debian
RUN curl -fsSL https://deb.nodesource.com/setup_18.x | bash - && apt-get install -y nodejs
@matsubo
matsubo / commit-msg
Created January 17, 2024 13:01 — forked from iberianpig/commit-msg
IssueID_xxxxなブランチ名の時に自動でコミットメッセージの先頭に[#IssueID]を付与するrubyスクリプト
#!/usr/bin/env ruby
message_file = ARGV[0]
message = File.read(message_file, :encoding => Encoding::UTF_8)
# remove prefix issue number like [#1234] from COMMIT_EDITMSG
message = message.sub(/^\[#[0-9A-Za-z_].*\]/, "")
# remove comment
message = message.gsub(/^#(?! ------------------------ >8 ------------------------).*\n|^\n/, "")
@matsubo
matsubo / autofill.js
Last active December 16, 2023 17:23
法人番号検索API サンプルコード
document.getElementById('s').addEventListener('keyup', async (e) => {
if (e.key !== 'Enter') return;
const s = e.target.value;
const corporateInfoUrl = `https://corporation.teraren.com/corporations.json?s=${s}`;
try {
const corporateResponse = await fetch(corporateInfoUrl);
const { items: [corporateData] } = await corporateResponse.json();
@matsubo
matsubo / Mutagen.md
Last active December 11, 2023 07:52
@matsubo
matsubo / applications.js
Created November 27, 2023 07:40
Disable wheel on <input type="number"> to prevent un-intended value change.
import { disableWheel } from './disable-wheel.js';
window.addEventListener('load', function () {
disableWheel('input[type="number"]')
}, false);
@matsubo
matsubo / gist:f8765683b75ab5098f99730ae6442bae
Created November 23, 2023 06:11
gistを更新しても草は生えますか?
gistを更新しても草は生えますか?
@matsubo
matsubo / README.md
Last active December 20, 2023 11:39