Skip to content

Instantly share code, notes, and snippets.

View eiryu's full-sized avatar

eiryu eiryu

View GitHub Profile
@eiryu
eiryu / script.js
Created September 13, 2023 08:25
IRKitの `POST /wifi` にリクエストする際の文字列を生成するスクリプト
// https://hakataminamiwebservice.hatenablog.com/entry/2022/12/13/155403
"use strict";
// Original Source Code: http://jsdo.it/mash/keyserializer-test
// MIT License
// This Source Code is transpiled from https://github.com/bouzuya/node-irkit/blob/master/src/irkit-device-key-serializer.ts typescript
// to javascript, and add a little change.
// CRC-8-Dallas/Maxim
@eiryu
eiryu / keybase.md
Created July 23, 2020 18:42
keybase.md

Keybase proof

I hereby claim:

  • I am eiryu on github.
  • I am eiryu (https://keybase.io/eiryu) on keybase.
  • I have a public key ASDCzWLk5mOGtorwnclIEmBVQzosNB9JtQjaA9W1dylh0wo

To claim this, I am signing this object:

@eiryu
eiryu / scraping.js
Created March 1, 2019 07:06
Zaifコイン積み立て JavaScript
$('.table-striped tr').map(function(i, dom) {
var $td = $(dom).children();
console.log($td.eq(0).text() + ',' + $td.eq(1).text() + ',' + $td.eq(2).text() + ',' + $td.eq(3).children('span').text() + ',' + $td.eq(4).text().trim());
});
@eiryu
eiryu / createCryptactCustomCSV.groovy
Last active March 1, 2019 07:05
Zaifコイン積み立て Groovy
// Groovy Version: 2.5.0 JVM: 1.8.0_181 Vendor: Azul Systems, Inc. OS: Mac OS X
import java.time.LocalDateTime
import java.time.OffsetDateTime
import java.time.format.DateTimeFormatter
import java.time.temporal.TemporalAccessor
def records = []
new File('/Users/eiryu/Downloads/zaif').eachFileRecurse { file ->
def m = (file.name =~ /zaif_コイン積み立て_(\d\d\d\d)(\d\d)\.csv/)
if (m.matches()) {
@eiryu
eiryu / a.sql
Created October 30, 2018 12:55
MySQLでtimestampをdateに変換する
mysql> select date_format(now(), '%Y-%m-%d');
+--------------------------------+
| date_format(now(), '%Y-%m-%d') |
+--------------------------------+
| 2018-10-30 |
+--------------------------------+
1 row in set (0.00 sec)
@eiryu
eiryu / a.md
Created June 9, 2017 01:04
AirPods page
$ http https://www.apple.com/jp/shop/product/MMEF2/airpods | grep as-purchaseinfo-dudeinfo-deliverymsg -A 2
            <li class="as-purchaseinfo-dudeinfo-deliverymsg">
                <span>{{{.}}}</span>
            </li>
@eiryu
eiryu / gist:e6949d1ca1fcda0c8bd73a0a0323fcfa
Created May 29, 2017 11:08
MavenのローカルRepoを-Dで指定
mvn -Dmaven.repo.local=/path/to/environment/repository clean install
@eiryu
eiryu / foo.sql
Last active May 21, 2016 22:17
テーブルの文字コード変換でデータ型が変わってしまう
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.27 |
+-----------+
1 row in set (0.00 sec)
mysql> create table a(
-> a text
@eiryu
eiryu / foo.sql
Created February 10, 2016 11:06
MySQLのCREATE TABLEの挙動
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.27 |
+-----------+
1 row in set (0.00 sec)
mysql> create table a(
-> a timestamp not null comment 'foo',
@eiryu
eiryu / error.log
Created November 27, 2015 12:49
PostgreSQL 8.4 pg_dumpエラーメッセージ
pg_dump: テーブル"foo_table"のデータをリストアしています
pg_dump: テーブルfoo_tableの内容をダンプしています
pg_dump: テーブル"foo_table"の内容のダンプに失敗: PQgetCopyData()が失敗しました。
pg_dump: サーバのエラーメッセージ: サーバとの接続が想定外にクローズされました
おそらく要求の処理前または処理中にサーバが異常終了
したことを意味しています。
pg_dump: 次のコマンドでした: COPY public.foo_table (*, *, *, *, *, *, *, *) TO stdout;
pg_dump: *** エラーのため中断