# coding:utf-8

# ==================================================================================
# Author: changbo - EMail:changbo@hmg100.com
# Last modified:2017-4-16
# filename:run_status.py
# Description:check nginx access.log, Base
# blog:http://www.cnblogs.com/changbo
# ==================================================================================

# check login times of IP (Login password explosion)

# whiteIP = [‘127.0.0.1‘, ]

from collections import Counter
import pymysql

seachtime = ‘2017-4-07‘
db = pymysql.connect("x.x.x.x", "xxxx", "xxxxx", "xxxxx")
cursor = db.cursor()

# sqlcommd = "INSERT INTO abnormal(ip, time, url) VALUES(‘%s‘ ,‘%s‘ ,‘%s‘)" % (ip1, time1, url1)
sqlcommd1 = "select time FROM abnormal where date=‘%s‘" % seachtime

try:
    logintime = []
    cursor.execute(sqlcommd1)
    db.commit()
    results = cursor.fetchall()
    for i in range(len(results)):
        logintime.append((‘%s‘ % results[i])[:5])
    print(dict(Counter(logintime)))
except Exception as e:
    print(e)
db.close()