def userEdit(uid, **kwargs): username = kwargs['username'] password = kwargs['password'] email = kwargs['email'] sql = ''' UPDATE users SET username="******",password="******",email="%s" WHERE id = %s; ''' % ( username, password, email, uid) return execute_sql(sql)
def userEdit(data): ## 1. 判断用户是否为空 #if data['username'] == '': # errmsg = "[User cannot be null...]" # return errmsg ## 2. 判断邮箱的后缀是不是公司的邮箱后缀 @51reboot.com #elif '@' not in data['email']: # errmsg = "[Email type wrong...]" # return errmsg #elif '@' in data['email']: # if data['email'].split('@')[1] != '51reboot.com': # errmsg = "[Email suffix error...]" # return errmsg ## 3. 密码复杂性要求 长度不能低于8位 必须包含大写、小写和数字等。(特殊字符) #elif recognize_passwd(data['password']) == False: # errmsg = "Password type error..." # print errmsg # return errmsg #else: sql = '''update users set username='******',email='%s',password='******' where id = %s;''' % ( data['username'], data['email'], data['password'], data['num']) return execute_sql(sql)
def userEdit(uid, data): sql = '''UPDATE users set username='******',email='%s',password='******' WHERE id = %s; ''' % ( data['username'], data['email'], data['password'], uid) print sql return execute_sql(sql)
def userDel(uid): sql = '''DELETE FROM users WHERE id = %s; ''' % uid print sql return execute_sql(sql)
def register(data): sql = '''INSERT INTO users(username, email, password) values('%s', '%s', '%s')''' % ( data['username'], data['email'], data['password']) print sql return execute_sql(sql)
def userUpdate(data): sql = '''UPDATE users set username='******',password='******',email='%s' WHERE id = %d;''' % (data['username'],data['password'],data['email'],data['id']) print 'update:' + sql return execute_sql(sql)
def modifi_passwd(modifi_data): sql = '''update users set password ='******' where username ='******'; ''' % ( modifi_data['password'], modifi_data['username']) print(sql) return execute_sql(sql)
def register(data): md5passwd = encryption(data['password']) sql = '''INSERT INTO users(username, email, password) values('%s', '%s', '%s')''' % ( data['username'], data['email'], md5passwd) #print sql return execute_sql(sql)
def userUpdate(data): sql = '''UPDATE users set username='******',password='******',email='%s' WHERE id = %d;''' % (data['username'],data['password'],data['email'],data['id']) logging.debug(sql) return execute_sql(sql)
def userDel(uid): sql = '''DELETE FROM users WHERE id = %s; ''' % uid logging.debug(sql) return execute_sql(sql)