Skip to content

Instantly share code, notes, and snippets.

tateisu tateisu

Block or report user

Report or block tateisu

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:531cd72134a37a12c2ec5501636ac3c7
# select * from account_aliases ;
id | account_id | acct | uri | created_at | updated_at
----+------------+------+-----+------------+------------
(0 rows)
View gist:f5e4fce826c9a240a0a13a26bbde3948
web_1 | [77bc3d7c-698f-4ae6-a06c-982e517b8916] method=POST path=/settings/aliases format=html controller=Settings::AliasesController action=create status=500 error='ActionView::MissingTemplate: Missing template settings/aliases/show, settings/base/show, application/show with {:locale=>[:ja, :en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :haml]}. Searched in:
web_1 | * "/opt/mastodon/app/views"
web_1 | * "/opt/mastodon/vendor/bundle/ruby/2.6.0/gems/doorkeeper-5.2.0/app/views"
web_1 | * "/opt/mastodon/vendor/bundle/ruby/2.6.0/gems/devise-4.7.1/app/views"
web_1 | * "/opt/mastodon/vendor/bundle/ruby/2.6.0/gems/kaminari-core-1.1.1/app/views"
web_1 | * "/opt/mastodon/vendor/bundle/ruby/2.6.0/gems/pghero-2.3.0/app/views"
web_1 | ' duration=48.89 view=0.00 db=5.22
web_1 | [77bc3d7c-698f-4ae6-a06c-982e517b8916]
web_1 | [77bc3d7c-698f-4ae6-a06c-982e517b8916] ActionView::MissingTemplate (Missing template settings/aliases/show, settings/base/show, application/show with {
@tateisu
tateisu / gist:1616e73dec3602e1c673662873713320
Created Sep 19, 2019
Wi-Fiアダプタの速度計測をやってみる。
View gist:1616e73dec3602e1c673662873713320
Wi-Fiアダプタを買ったのでLANの速度計測をやってみる。
* 測定に使うソフト
iperfを使う。
* 無線LAN環境
NEC Aterm WG2600HP
壁式鉄筋の家屋なので電波の通りは悪い。
@tateisu
tateisu / removeSpam.pl
Last active Sep 16, 2019
suspend user who in pawoo.net and his note like 'めったにPawooを使いません'.
View removeSpam.pl
#!/usr/bin/perl --
use strict;
use warnings;
use utf8;
# mastodonのdockerコンテナの rails console はreadline がUS-ASCIIなので、文字列リテラルはエスケープが必要
sub escapeNonAscii($){
my($a) = @_;
$a =~ s/([\x{80}-\x{fffff}])/"\\u{".sprintf("%x",ord $1)."}"/ge;
$a;
View gist:cb0c9ee75ab9eae1b7138d8bc6c4a6b6
$ cat readpipe.sh
#!/bin/bash
FILE=/tmp/test.pipe
rm $FILE
mknod $FILE p
read -t 3 <>$FILE answer
echo $? $answer
$ cat writepipe.sh
#!/bin/bash
View TestAsyncAlertDialog.kt
package jp.radiko.testasyncalertdialog
import android.os.Bundle
import android.widget.Button
import android.widget.Toast
import androidx.appcompat.app.AlertDialog
import androidx.appcompat.app.AppCompatActivity
import kotlinx.coroutines.CoroutineScope
import kotlinx.coroutines.Dispatchers
import kotlinx.coroutines.Job
@tateisu
tateisu / timecalc.pl
Last active Mar 26, 2019
雑な時間計算機
View timecalc.pl
#!/usr/bin/perl --
use strict;
use warnings;
use feature qw(switch say);
use Math::BigFloat;
use Term::ReadLine;
use Getopt::Long;
# usage: ./timecalc.pl -v "9h15m + 10m - 20m * ( 0.5h / 15m ) * 0.5"
@tateisu
tateisu / gist:5d1db89783dd2607a7a7a7d98f25a1c8
Last active Mar 23, 2019
my app can get /users/@me/guilds, but can't get /guilds/{id}/channels . why?
View gist:5d1db89783dd2607a7a7a7d98f25a1c8
my app can get /users/@me/guilds, but can't get /guilds/{id}/channels . why?
----------------------------------------
log
$ perl testApp1.pl
apiGet https://discordapp.com/api/v6/users/@me/guilds
[{"owner": false, "permissions": 104324161, "icon": "423a112cd4b14ba6105051dcae0b7880", "id": "231908446830723072", "name": "joinmastodon.org"}, {"owner": false, "permissions": 104324161, "icon": null, "id": "305703658107043850", "name": "mastodon-jp"}, ...]
View gist:b9df6657960ab76666d823923fc87e4b
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendering stream_entries/show.html.haml within layouts/public
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/_og_description.html.haml (3.2ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/_og_image.html.haml (1.3ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/_poll.html.haml (2.2ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/_detailed_status.html.haml (17.5ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/_status.html.haml (18.2ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] Rendered stream_entries/show.html.haml within layouts/public (36.9ms)
web_1 | [5db0aa14-ef8d-40e3-b9e9-e91f261cbac3] method=GET path=/@tateisu/101695324967335706 format=html controller=StatusesController action=show status=500 error='ActionView::Template::Error: undefined method `account' for
@tateisu
tateisu / deletePosts.md
Last active Feb 24, 2019
Removing local copies of unreferenced external posts
View deletePosts.md

Removing local copies of unreferenced external posts

日本語 => https://gist.github.com/tateisu/3d98290f2b72d12ba5f1b977a0d5743c

Summary

SQL exapmle that deletes local copies of external posts flowing from the FTL or relays and that are not referenced long time by local users.

Note: It is "reduction" of data increase , not "to be able to operate infinitely with a fixed disk capacity".

You can’t perform that action at this time.