def post(self):
form = request.form
id = form.get("id")
if not id:
return error.error_1001()
user = User.Query().filter_by(id=id).first()
# 可以修改的信息：real_name, password, phone
real_name = form.get("real_name")
password = form.get("password")
phone = form.get("phone")
# 判断real_name是否存在
if real_name:
user.real_name = real_name
# 判断password是否存在
if password:
user.password = bcrypt.generate_password_hash(password).decode("utf-8")
# 判断phone是否存在
if phone:
phone_count = User.Query().filter(and_(User.phone == phone, User.id != id)).count()
if phone_count:
return error.error_1002("此手机号已存在")
user.phone = phone
# 提交到数据库
db.session.add(user)
try:
db.session.commit()
except:
return error.error_1003()
return error.success()
def post(self):
print(request.headers)
form = request.form
username = form.get("username")
password = form.get("password")
print(form)
print(request.get_data())
#username 和 password不能为空
if not username or not password:
return error.error_1001()
user = User.Query().filter(or_(User.name==username, User.phone==username)).first()
#判断user是否存在
if not user:
return error.error_1004()
#判断密码是否正确
if not bcrypt.check_password_hash(user.password, password):
return error.error_1004()
#获取uid
uid = user.id
#生成token
token_str = "{0}{1}{2}".format(user.name, uid, time()).encode("utf-8")
token = hashlib.sha1(token_str).hexdigest()
redisClient.set(token, uid)
redisClient.expire(token, config.redis_expireTime)
return error.success({"token": token, "uid": uid})
def query(self):
pageNo = int(
request.args.get("pageNo") or request.form.get("pageNo") or 1)
pageSize = int(
request.args.get("pageSize") or request.form.get("pageSize") or 10)
query = Answer.Query()
rows = query.offset((pageNo - 1) * pageSize).limit(pageSize).all()
answers = []
for r in rows:
user = User.Query().filter_by(id=r.user_id).first()
question = Question.Query().filter_by(id=r.question_id).first()
print(question.category_id)
category = Category.Query().filter_by(
id=question.category_id).first()
answer = {
"id": r.id,
"username": user.name,
"subject": question.subject,
"category": category.name,
"question_id": question.id,
"question_content": question.content,
"is_right": r.is_right,
"user_answer": r.user_answer
}
answers.append(answer)
return error.success({"list": answers})
def post(self):
id = request.form.get("id")
if not id:
return error.error_1001()
user = User.Query().filter_by(id=id).first()
# 判断user是否存在
if user:
user.is_valid = False
db.session.add(user)
db.session.commit()
return error.success()
def query(self):
pageNo = int(request.args.get("pageNo") or request.form.get("pageNo") or 1)
pageSize = int(request.args.get("pageSize") or request.form.get("pageSize") or 10)
rows = User.Query().offset((pageNo - 1)*pageSize).limit(pageSize).all()
count = User.Query().count()
pageCount = math.ceil(count / pageSize)
users = []
for r in rows:
user = {
"id": r.id,
"name": r.name,
"phone": r.phone,
"real_name": r.real_name,
"nick_name": r.nick_name,
"openid": r.openid,
"role": r.role,
"logo": r.logo,
"created_time": datetime.timestamp(r.created_time)
}
users.append(user)
return error.success({"list": users, "page":{"total": count, "pageCount": pageCount}})
def query(self):
id = g.uid
row = User.Query().filter_by(id=id).first()
has_answered = Answer.Query().filter_by(user_id=g.uid).count()
has_incorrect = Answer.Query().filter_by(user_id=g.uid, is_right=False).count()
user = {
"id": row.id,
"name": row.name,
"phone": row.phone,
"has_answered": has_answered,
"has_incorrect": has_incorrect
}
return error.success(user)
def post(self):
form = request.form
name = form.get("name")
phone = form.get("phone")
print(form)
print(request.get_data())
print(type(request.get_data()))
password = form.get("password")
openid = form.get("openid")
#phone,password不可以为空,username可以为空
if not phone or (not password):
return error.error_1001()
# 判断phone手机号是否存在
phone_count = User.Query().filter_by(phone=phone).count()
if phone_count:
return error.error_1002("此手机号已存在")
# 判断name用户名是否存在
name_count = User.Query().filter_by(name=name).count()
if name_count:
return error.error_1002("此用户已存在")
# 判断openid是否存在
if openid:
openid_count = User.Query().filter_by(openid=openid).count()
if openid_count:
return error.error_1002("此微信号已存在")
# 提交数据到数据库
user = User(form)
try:
db.session.add(user)
db.session.commit()
except:
return error.error_1003()
return error.success()
