Yuki Hirai yukihirai0505

## log.sql
SET @t = 2;

SELECT
SUM(A.counter) AS counter
FROM
(SELECT
FROM_UNIXTIME(CEILING(UNIX_TIMESTAMP(access_date) / (@t * 60)) * (@t * 60)) AS access_date,
1 AS counter
FROM
tmp_user

## __init__.py
#!/usr/local/bin/python
# -*- coding:utf-8 -*-
from fabric.api import *
from fabric.decorators import runs_once
from datetime import datetime

env.hosts = ['ホスト名']
env.user = 'ユーザー名'
env.key_filename = '鍵の場所'
env.project_name = 'プロジェクトネーム'
	SET @t = 2;

	SELECT
	SUM(A.counter) AS counter
	FROM
	(SELECT
	FROM_UNIXTIME(CEILING(UNIX_TIMESTAMP(access_date) / (@t * 60)) * (@t * 60)) AS access_date,
	1 AS counter
	FROM
	tmp_user
	#!/usr/local/bin/python
	# -- coding:utf-8 --
	from fabric.api import *
	from fabric.decorators import runs_once
	from datetime import datetime

	env.hosts = ['ホスト名']
	env.user = 'ユーザー名'
	env.key_filename = '鍵の場所'
	env.project_name = 'プロジェクトネーム'