Skip to content

Instantly share code, notes, and snippets.

@showyou
showyou / movie_count.sql
Created November 26, 2019 13:47
お前は今までに観た映画の数を覚えているか?
select text, count(text) as cnt from tweet
where
user='miyabiarts'
and
(text like '%はじまります%' or text like '%はじまっています%' )
and
datetime >= '2019-01-01'
and
not (text like 'ラブライブ!%' and datetime >= '2019-07-30')
and
@showyou
showyou / max_test.cpp
Created September 2, 2019 07:10
maxの引数
#include <iostream>
int main(){
int x = 1;
int ans = 0;
ans = std::max(x, ans);
std::cout << ans << std::endl;
}
@showyou
showyou / kuji.csv
Created July 28, 2019 14:03
ichibankuji
kuji figure
3 0
1 1
2 0
30 3
4 2
1 0
2 1
3 2
9 1
@showyou
showyou / digdag.log
Created June 18, 2019 03:26
digdag migration
2019-06-18 12:24:38 +0900: Digdag v0.9.37
2019-06-18 12:24:41 +0900 [INFO] (main): Database migration started
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20151204221156
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160602123456
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160602184025
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160610154832
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160623123456
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160719172538
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160817123456
2019-06-18 12:24:41 +0900 [INFO] (main): Applying database migration:20160818043815
@showyou
showyou / leetcode1030_a.py
Created April 22, 2019 01:02
leetcode1030
class Solution:
def allCellsDistOrder(self, R: int, C: int, r0: int, c0: int) -> List[List[int]]:
import copy
T = int(input())
def calc_min_len(ws):
min_len = 999999
for w in ws:
l = len(w)
if l < min_len:
min_len = l
return min_len
import copy
T = int(input())
def find_warp(galaxy, y, x, R, C):
#print("find_warp", y, x, galaxy)
# pick up next warp which is
# x != x2
# y != y2
# x - y != x2 - y2
T = int(input())
cnt = 1
for _ in range(T):
size = int(input())
L = input()
result = ""
for l in L:
result += "S" if l == "E" else "E"
print("Case #"+str(cnt)+":", result)
T = int(input())
Ns = [int(input()) for _ in range(T)]
A = 1
B = 1
cnt = 1
def check_four(i, keta):
s = str(i)
if s[-keta] == '4':
@showyou
showyou / gcj2019qrc.py
Created April 7, 2019 02:09
REエラーで通らなかった
T = int(input())
cnt = 1
def gen_primes(x):
if x < 2: return []
primes = [i for i in range(x)]
primes[1] = 0
for prime in primes: