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