Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"
\u30b0\u30e9\u30d5\u306fpsql\u306e\u51fa\u529b\u3092tsv\u306b\u7de8\u96c6\u3057\u3066\u304a\u3044\u3066Gnuplot\u3067\u3002<\/p>
reset
set xrange [-0.5:23.5]
set xtics 3
set yrange [0:40]
set y2range [0:1600]
set style data boxes
set style fill solid
set boxwidth 0.2
set xlabel \"Hour (UTC-10)\"
set ytics (0)
plot 'beer.dat' using 1:5 tit 'Total' axes x1y2 with lines,\\
'beer.dat' using ($1-0.2):3 tit 'Coke',\\
'beer.dat' using ($1+0.0):4 tit 'RedBull',\\
'beer.dat' using ($1+0.2):2 tit 'Beer'
set term push;set term png small; set output 'beer.png'
replot
unset output; set term pop<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316276547314509","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316276547314509","objectType":"comment","content":"
\u30b0\u30e9\u30d5\u306fpsql\u306e\u51fa\u529b\u3092tsv\u306b\u7de8\u96c6\u3057\u3066\u304a\u3044\u3066Gnuplot\u3067\u3002<\/p>
reset
set xrange [-0.5:23.5]
set xtics 3
set yrange [0:40]
set y2range [0:1600]
set style data boxes
set style fill solid
set boxwidth 0.2
set xlabel \"Hour (UTC-10)\"
set ytics (0)
plot 'beer.dat' using 1:5 tit 'Total' axes x1y2 with lines,\\
'beer.dat' using ($1-0.2):3 tit 'Coke',\\
'beer.dat' using ($1+0.0):4 tit 'RedBull',\\
'beer.dat' using ($1+0.2):2 tit 'Beer'
set term push;set term png small; set output 'beer.png'
replot
unset output; set term pop<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316276547314509","status_net":{"notice_id":null},"inReplyTo":{"objectType":"note","id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316271478290995","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316271478290995"}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2018-12-28:objectId=2608402:objectType=Conversation","notice_info":{"local_id":"1847635","source":"ostatus"}},"published":"2018-12-28T02:21:32+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316276547314509"},{"actor":{"id":"https:\/\/ding-dong.asmodeus.tokyo\/users\/shinderuman","displayName":"Asmodeus :dumpling: ?","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/14506-original-20200526050512.jpeg","rel":"avatar","type":"image\/jpeg","width":400,"height":400},{"url":"https:\/\/social.senooken.jp\/avatar\/14506-96-20200526054116.jpeg","rel":"avatar","type":"image\/jpeg","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/14506-48-20200526054116.jpeg","rel":"avatar","type":"image\/jpeg","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/14506-24-20200526054116.jpeg","rel":"avatar","type":"image\/jpeg","width":24,"height":24}],"profile_info":{"local_id":"14506"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/14506-96-20200526054116.jpeg","rel":"avatar","type":"image\/jpeg","width":96,"height":96},"objectType":"person","summary":"
\u50d5\u306e\u4f53\u306e\uff17\uff10\uff05\u306f\u30b2\u30fc\u30e0\u3067\u3067\u304d\u3066\u3044\u308b\u3002<\/p>
P.S I ? Monsters.<\/p>","url":"https:\/\/ding-dong.asmodeus.tokyo\/users\/shinderuman","portablecontacts_net":{"preferredUsername":"shinderuman@ding-dong.asmodeus.tokyo","displayName":"Asmodeus :dumpling: ?","note":"
\u50d5\u306e\u4f53\u306e\uff17\uff10\uff05\u306f\u30b2\u30fc\u30e0\u3067\u3067\u304d\u3066\u3044\u308b\u3002<\/p>
P.S I ? Monsters.<\/p>"}},"content":"
\u7a81\u7136\u3067\u3059\u304c\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u5348\u524d\u4e2d\u306b\u30b3\u30fc\u30e9\u3068\u30ec\u30c3\u30c9\u30d6\u30eb\u3092\u98f2\u307f\u5915\u65b9\u306b\u30d3\u30fc\u30eb\u3092\u98f2\u3080\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u5065\u5168\u3060w<\/p>
> SELECT
EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10') as hour,
SUM(CASE WHEN text LIKE '%\u30d3\u30fc\u30eb%' THEN 1 ELSE 0 END) AS beer,
SUM(CASE WHEN text LIKE '%\u30b3\u30fc\u30e9%' THEN 1 ELSE 0 END) AS coke,
SUM(CASE WHEN text LIKE '%\u30ec\u30c3\u30c9\u30d6\u30eb%'
OR text LIKE '%RedBull%' THEN 1 ELSE 0 END) AS redbull,
COUNT(1) as total
FROM statuses WHERE account_id=1
GROUP BY EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10');<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/ding-dong.asmodeus.tokyo\/users\/shinderuman\/statuses\/101316273312521030\/activity","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316271478290995","objectType":"note","content":"
\u7a81\u7136\u3067\u3059\u304c\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u5348\u524d\u4e2d\u306b\u30b3\u30fc\u30e9\u3068\u30ec\u30c3\u30c9\u30d6\u30eb\u3092\u98f2\u307f\u5915\u65b9\u306b\u30d3\u30fc\u30eb\u3092\u98f2\u3080\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u5065\u5168\u3060w<\/p>
> SELECT
EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10') as hour,
SUM(CASE WHEN text LIKE '%\u30d3\u30fc\u30eb%' THEN 1 ELSE 0 END) AS beer,
SUM(CASE WHEN text LIKE '%\u30b3\u30fc\u30e9%' THEN 1 ELSE 0 END) AS coke,
SUM(CASE WHEN text LIKE '%\u30ec\u30c3\u30c9\u30d6\u30eb%'
OR text LIKE '%RedBull%' THEN 1 ELSE 0 END) AS redbull,
COUNT(1) as total
FROM statuses WHERE account_id=1
GROUP BY EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10');<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316271478290995","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2018-12-28:objectId=2608402:objectType=Conversation","notice_info":{"local_id":"1847630","source":"ostatus","repeat_of":"1847626"}},"published":"2018-12-28T02:20:43+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"title":"shinderuman@ding-dong.asmodeus.tokyo repeated a notice by zundan@mastodon.zunda.ninja","verb":"share","url":"https:\/\/ding-dong.asmodeus.tokyo\/@shinderuman\/101316273312521030"},{"actor":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/1005-original-20200212031327.gif","rel":"avatar","type":"image\/gif","width":120,"height":120},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-48-20200212035814.gif","rel":"avatar","type":"image\/gif","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/1005-24-20200212035814.gif","rel":"avatar","type":"image\/gif","width":24,"height":24}],"profile_info":{"local_id":"1005"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/1005-96-20200212035814.gif","rel":"avatar","type":"image\/gif","width":96,"height":96},"objectType":"person","summary":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>","url":"https:\/\/mastodon.zunda.ninja\/users\/zundan","portablecontacts_net":{"preferredUsername":"zundan@mastodon.zunda.ninja","displayName":"zunda ? n\u306f\u304a\u307e\u3051 :green_dango:","note":"
Reads and writes in Japanese and English. Support engineer at Heroku. \u307d\u3093\u3053\u3064\u3067\u3059\u3002<\/p>"}},"content":"
\u7a81\u7136\u3067\u3059\u304c\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u5348\u524d\u4e2d\u306b\u30b3\u30fc\u30e9\u3068\u30ec\u30c3\u30c9\u30d6\u30eb\u3092\u98f2\u307f\u5915\u65b9\u306b\u30d3\u30fc\u30eb\u3092\u98f2\u3080\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u5065\u5168\u3060w<\/p>
> SELECT
EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10') as hour,
SUM(CASE WHEN text LIKE '%\u30d3\u30fc\u30eb%' THEN 1 ELSE 0 END) AS beer,
SUM(CASE WHEN text LIKE '%\u30b3\u30fc\u30e9%' THEN 1 ELSE 0 END) AS coke,
SUM(CASE WHEN text LIKE '%\u30ec\u30c3\u30c9\u30d6\u30eb%'
OR text LIKE '%RedBull%' THEN 1 ELSE 0 END) AS redbull,
COUNT(1) as total
FROM statuses WHERE account_id=1
GROUP BY EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10');<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316271478290995","object":{"id":"https:\/\/mastodon.zunda.ninja\/users\/zundan\/statuses\/101316271478290995","objectType":"note","content":"
\u7a81\u7136\u3067\u3059\u304c\u5f0a\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306f\u5348\u524d\u4e2d\u306b\u30b3\u30fc\u30e9\u3068\u30ec\u30c3\u30c9\u30d6\u30eb\u3092\u98f2\u307f\u5915\u65b9\u306b\u30d3\u30fc\u30eb\u3092\u98f2\u3080\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002\u5065\u5168\u3060w<\/p>
> SELECT
EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10') as hour,
SUM(CASE WHEN text LIKE '%\u30d3\u30fc\u30eb%' THEN 1 ELSE 0 END) AS beer,
SUM(CASE WHEN text LIKE '%\u30b3\u30fc\u30e9%' THEN 1 ELSE 0 END) AS coke,
SUM(CASE WHEN text LIKE '%\u30ec\u30c3\u30c9\u30d6\u30eb%'
OR text LIKE '%RedBull%' THEN 1 ELSE 0 END) AS redbull,
COUNT(1) as total
FROM statuses WHERE account_id=1
GROUP BY EXTRACT(HOUR FROM created_at AT TIME ZONE 'UTC-10');<\/p>","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316271478290995","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mastodon.zunda.ninja,2018-12-28:objectId=2608402:objectType=Conversation","notice_info":{"local_id":"1847626","source":"ostatus"}},"published":"2018-12-28T02:20:15+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mastodon.zunda.ninja\/@zundan\/101316271478290995"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/1306266","rel":"alternate","type":"text\/html"}]}