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)
