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
@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".

@tateisu
tateisu / gist:3d98290f2b72d12ba5f1b977a0d5743c
Last active Feb 24, 2019
使われてない古い投稿の削除
View gist:3d98290f2b72d12ba5f1b977a0d5743c

使われてない古い投稿の削除

English => https://gist.github.com/tateisu/c3c13f2580961e86f79889a17f57260a

背景

  • マストドンのインスタンスを運営していると、記録データが年々蓄積されていく。
  • 自分のインスタンスならローカルユーザ自身の投稿やローカルユーザが興味をもった外部の投稿を記録し続けないといけないのは理解できる。
  • しかし外部タンスの投稿について「もはやフォローされてない外部ユーザの投稿」「リレーで無条件に流れてくる外部ユーザの投稿」をもずっと記録し続ける理由はない。
  • 古い不要な投稿データを削除することで、記録データの増加を軽減できるのではないだろうか。サーバ維持費の増加を抑えられる。
View gist:d47dd733cba989adc138f1827236f709
> Task :apng:compileKotlin FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':apng:compileKotlin'.
> java.io.IOException: アクセスが拒否されました。
* Try:
Run with --info or --debug option to get more log output. Run with --scan to get full insights.
@tateisu
tateisu / gist:026dfb95a029484aed07d149743a6a63
Last active Jan 23, 2019
docker環境でのpostgreSQL 9.6 => 11 へのアップグレード
View gist:026dfb95a029484aed07d149743a6a63
# docker環境でのpostgreSQL 9.6 => 11 へのアップグレード
# https://github.com/tianon/docker-postgres-upgrade を利用する
# リポジトリに (OLD)-to-(NEW) のフォルダがあるか事前に確認しておく
# (今回の場合は 9.6-to-11 )
#################################
# 作業フォルダの作成
mkdir postgres-upgrade-2 && cd postgres-upgrade-2
mkdir -p postgresql/9.6/data postgresql/11/data
View gist:e8ae30f84e21d4423c1439d5677c5da7
+ docker-compose up -d
mastodon1_db_backend_1 is up-to-date
mastodon1_redis_1 is up-to-date
mastodon1_db_1 is up-to-date
Creating mastodon1_sidekiq_push_1
Creating mastodon1_web_1
Creating mastodon1_sidekiq_pull_1
Creating mastodon1_sidekiq_default_1
Creating mastodon1_streaming_1
@tateisu
tateisu / gist:615e807f108f2ef3765f65bdef9e7216
Created Jan 6, 2019
posting scheduled status with media raises error
View gist:615e807f108f2ef3765f65bdef9e7216
web_1 | [ec0d83d0-1b67-4492-9a82-399a665911d6] NameError (undefined local variable or method `media' for #<PostStatusService:0x0000563a60bc8a68>):
web_1 | [ec0d83d0-1b67-4492-9a82-399a665911d6]
web_1 | [ec0d83d0-1b67-4492-9a82-399a665911d6] app/services/post_status_service.rb:93:in `validate_media!'
web_1 | [ec0d83d0-1b67-4492-9a82-399a665911d6] app/services/post_status_service.rb:28:in `call'
web_1 | [ec0d83d0-1b67-4492-9a82-399a665911d6] app/controllers/api/v1/statuses_controller.rb:47:in `create'
View gist:38d480c317e11dc6b1717fa7f014d36b
GET /api/v1/scheduled_statuses does not contains what status will be post.
[{"id":"5","scheduled_at":"2019-01-06T07:27:00.000Z","media_attachments":[]},{"id":"4","scheduled_at":"2019-01-06T07:22:00.000Z","media_attachments":[]},{"id":"3","scheduled_at":"2019-01-06T07:08:00.000Z","media_attachments":[]},{"id":"2","scheduled_at":"2019-01-06T07:08:00.000Z","media_attachments":[]},{"id":"1","scheduled_at":"2019-01-06T07:06:00.000Z","media_attachments":[]}]
You can’t perform that action at this time.