python統計登入次數

標籤：http   ict   where   logs   exec   orm   統計   each   png   

# coding:utf-8# ==================================================================================# Author: changbo - EMail:[email protected]# 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 Counterimport pymysqlseachtime = ‘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‘" % seachtimetry:    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()

 圖示如下

 

 END!

python統計登入次數