def validate_user(username,password):
_sql='select * from user where username=%s and password=md5(%s)'
_count,_rt_list=dbutil.execute_fetch_sql(_sql,(username,password))
if _count==0:
return False
else:
return True
def GetUser(id):
_sql='select * from user where id=%s'
_count,_rt_list=dbutil.execute_fetch_sql(_sql,(id))
if _count:
return _rt_list[0]
else:
return False
def GetPrivilege(username):
_sql='select * from user where username=%s'
_count,_rt_list=dbutil.execute_fetch_sql(_sql,(username))
if _count:
return _rt_list[0][4]
else:
return False
def GetUsers():
#return json.load(open(UserFile,'rb'),encoding='utf-8')
_colums=('id','username','password','age')
_sql='select * from user'
_count,_rt_list=dbutil.execute_fetch_sql(_sql)
_rt=[]
for _line in _rt_list:
_rt.append(dict(zip(_colums,_line)))
return _rt
def sort_nginx(topn):
sql = 'select * from accesslog order by count desc limit %s'
args = (topn, )
_count, _rt_list = dbutil.execute_fetch_sql(sql, args)
rt_list = []
if _count:
for i in range(0, len(_rt_list)):
rt_list.append(((_rt_list[i][2], _rt_list[i][3], _rt_list[i][4]),
_rt_list[i][1]))
return rt_list
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
def JudgUser(username):
_sql='select * from user where username=%s'
_count,_rt_list=dbutil.execute_fetch_sql(_sql,(username,))
if _count:
return True
return False
