Mastodonのユーザー数カウントするsh

mastodon-usercount.sh

#!/bin/bash

# TMP=0とか書いて置いておけばいい
. ./usercount.txt

COUNT=$(sudo -u postgres echo $(psql -U postgres -t -c 'select count(*) from accounts where domain is null;' mastodon_production))

if [ $COUNT -gt $TMP ] ; then
  echo "TMP=$COUNT" > ./usercount.txt
  echo "$TMP -> $COUNT"

  #メール用の一時ファイル(消したかったらrmを後ろに突っ込んで)
  tmptxt=./mailtmp.txt

  echo "Subject: Newbie has commen!" > $tmptxt
  echo "To: {宛先アドレス}" >> $tmptxt
  echo "From: {送信元アドレス(なくてもいい)}" >> $tmptxt
  echo "" >> $tmptxt
  echo "User account has increased" >> $tmptxt
  echo "$TMP -> $COUNT" >> $tmptxt
  echo "" >> $tmptxt

  sendmail -t < $tmptxt
fi