tateisu

#!/usr/bin/perl --

# プロフィールの表のの中のURLのホスト名のIPアドレスが特定の値ならサスペンドします。

# usage:
# export PSQL="docker exec mastodon1_db_backend_1 psql -U user database"
# export RAILS_CONSOLE=""docker-compose run --rm web bundle exec rails console"
# perl removeSpam2.pl --userDomain=mastodon.social 185.117.119.170

use strict;

tateisu

#!/usr/bin/perl
use strict;
use warnings;

use JSON::XS;
use Data::Dump qw(dump);

open(my $fh,"-|","docker exec mastodon1_redis_1 redis-cli zrange retry 0 -1")
    or die "can't open redis-cli. $!";

tateisu

select count(*) as c,domain from accounts
where exists(select from follows left join accounts as a2 on a2.id=follows.account_id 
             where a2.domain is null and target_account_id=accounts.id)
group by domain order by c desc limit 100;

  c   |            domain
------+-------------------------------
 1476 | pawoo.net
 1186 | mstdn.jp
  396 |

tateisu

# select * from  account_aliases ;
 id | account_id | acct | uri | created_at | updated_at
----+------------+------+-----+------------+------------
(0 rows)

tateisu

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

Wi-Fiアダプタを買ったのでLANの速度計測をやってみる。

* 測定に使うソフト

iperfを使う。

* 無線LAN環境
NEC Aterm WG2600HP
壁式鉄筋の家屋なので電波の通りは悪い。

tateisu

#!/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;

tateisu

$ 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

tateisu

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

#!/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"