def FilterNginx(SrcFileName):
FileList = ReadFile(SrcFileName)
FileDict = {}
for i in range(0, len(FileList)):
key = (FileList[i][0], FileList[i][6], FileList[i][8])
FileDict[key] = FileDict.get(key, 0) + 1
FilterList = sorted(FileDict.items(), key=lambda x: x[1], reverse=True)
sql = 'truncate table accesslog'
dbutil.execute_commit_sql(sql)
sql = 'insert into accesslog(count,ip,url,code) values(%s,%s,%s,%s)'
count = dbutil.execute_aggregation_sql(sql, FilterList)
if count:
return True
else:
return False
def DelUser(id):
_sql='delete from user where id=%s'
_args=(id,)
_count=dbutil.execute_commit_sql(_sql,_args)
if _count:
return True
else:
return False
def AddUser(username,password,age):
_sql='insert into user(username,password,age) values(%s,md5(%s),%s)'
_args=(username,password,age)
_count=dbutil.execute_commit_sql(_sql,_args)
if _count:
return True
else:
return False
def ChangeUser(id,username,password,age):
_sql='select * from user where id=%s and username=%s'
_args=(id,username)
_count,_rt_list=dbutil.execute_fetch_sql(_sql,_args)
if not _count:
_sql='select * from user where username=%s'
_args=(username,)
_count,_rt_list=dbutil.execute_fetch_sql(_sql,_args)
if _count:
return 'sameusername'
_sql='select * from user where username=%s and password=md5(%s)'
_args=(username,password)
_count,_rt_list=dbutil.execute_fetch_sql(_sql,_args)
if _count:
return 'samepassword'
else:
_sql='update user set username=%s,password=md5(%s),age=%s where id=%s'
_args=(username,password,age,id)
_count=dbutil.execute_commit_sql(_sql,_args)
if _count:
return True
else:
return False