def insert_data(self, post_data): if '/' in post_data['user_name'][0]: return False if ':' in post_data['user_name'][0]: return False if len(post_data['user_name'][0]) < 5 or len(post_data['user_name'][0]) > 20: return False if '\\' in post_data['user_name'][0]: return False if '#' in post_data['user_name'][0]: return False if '+' in post_data['user_name'][0]: return False if "'" in post_data['user_name'][0]: return False if '"' in post_data['user_name'][0]: return False if '(' in post_data['user_name'][0]: return False if ')' in post_data['user_name'][0]: return False if ' ' in post_data['user_name'][0]: return False try: CabMember.create(uid=tools.get_uuid(), user_name=post_data['user_name'][0], user_pass=tools.md5(post_data['user_pass'][0]), user_email=post_data['user_email'][0], privilege='10000', reset_passwd_timestamp=0, ) return True except: return False
def check_user(self, u_name, u_pass): tt = CabMember.select().where(CabMember.user_name == u_name).count() if tt == 0: return -1 a = CabMember.get(user_name=u_name) if a.user_pass == tools.md5(u_pass): return 1 return 0
def delete(self, del_id): try: del_count = CabMember.delete().where(CabMember.uid == del_id) del_count.execute() return True except: return False
def update_info(self, u_name, newemail): entry = CabMember.update( user_email=newemail, ).where(CabMember.user_name == u_name) entry.execute() return entry
def delete_by_user_name(self, user_name): try: del_count = CabMember.delete().where(CabMember.user_name == user_name) del_count.execute() return True except: return False
def delete_by_user_name(self, user_name): try: del_count = CabMember.delete().where( CabMember.user_name == user_name) del_count.execute() return True except: return False
def insert_data(self, post_data): if '/' in post_data['user_name'][0]: return False if ':' in post_data['user_name'][0]: return False if len(post_data['user_name'][0]) < 5 or len( post_data['user_name'][0]) > 20: return False if '\\' in post_data['user_name'][0]: return False if '#' in post_data['user_name'][0]: return False if '+' in post_data['user_name'][0]: return False if "'" in post_data['user_name'][0]: return False if '"' in post_data['user_name'][0]: return False if '(' in post_data['user_name'][0]: return False if ')' in post_data['user_name'][0]: return False if ' ' in post_data['user_name'][0]: return False try: CabMember.create( uid=tools.get_uuid(), user_name=post_data['user_name'][0], user_pass=tools.md5(post_data['user_pass'][0]), user_email=post_data['user_email'][0], privilege='10000', reset_passwd_timestamp=0, ) return True except: return False
def get_by_id(self, uname): try: return CabMember.get(user_name=uname) except: return False
def get_by_uid(self, uid): try: return CabMember.get(CabMember.uid == uid) except: return False
def get_by_keyword(self, par2): return CabMember.select().where(CabMember.user_name.contains(par2))
def update_pass(self, u_name, newpass): entry = CabMember.update(user_pass=tools.md5(newpass), ).where( CabMember.user_name == u_name) entry.execute() return entry
def update_pass(self, u_name, newpass): entry = CabMember.update( user_pass=tools.md5(newpass), ).where(CabMember.user_name == u_name) entry.execute() return entry
def get_by_email(self, emai): try: return CabMember.get(user_email=emai) except: return False
def update_reset_passwd_timestamp(self, uname, timeit): entry = CabMember.update( reset_passwd_timestamp=timeit, ).where(CabMember.user_name == uname) entry.execute() return entry
def update_reset_passwd_timestamp(self, uname, timeit): entry = CabMember.update(reset_passwd_timestamp=timeit, ).where( CabMember.user_name == uname) entry.execute() return entry
def update_privilege(self, u_name, newprivilege): entry = CabMember.update( privilege=newprivilege ).where(CabMember.user_name == u_name) entry.execute() return entry
def update_privilege(self, u_name, newprivilege): entry = CabMember.update(privilege=newprivilege).where( CabMember.user_name == u_name) entry.execute() return entry
def __init__(self): try: CabMember.create_table() except: pass