def post(self):
"""
发送课表数据到服务器
地址: /interaction/api/v2/syllabus_collection
方法: POST
参数:
位置: form
必选参数:
username 用户账号
token 验证令牌
start_year 学年的开始年份
season 某个学期, 和学分制对应
syllabus 课表的JSON数据
:return:
"""
self.POST_PARSER.add_argument("username", required=True, location="form")
self.POST_PARSER.add_argument("token", required=True, location="form")
self.POST_PARSER.add_argument("start_year", type=int, required=True, location="form")
self.POST_PARSER.add_argument("season", type=int, required=True, location="form")
self.POST_PARSER.add_argument("collection_id", required=True, location="form")
self.POST_PARSER.add_argument("syllabus", required=True, location="form")
args = self.POST_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collector = common.query_single_by_filed(models.Collector, "collection_id", args["collection_id"])
if collector is None:
# 表明用户输入了错误的collection_id
return {"error": "wrong collection_id"}, 404
# 检查学期是否正确
if collector.start_year != args["start_year"] or collector.season != args["season"]:
return {"error": "semester doesn't match"}, 400
collection = models.SyllabusCollection.query.filter_by(account=user.account).filter_by(collection_id=args["collection_id"]).first()
if collection is not None:
# 删除原有记录
status = delete_record(db, collection)
if status != True:
return {"error": repr(status[1])}, 500
collection = models.SyllabusCollection(collection_id=args["collection_id"], syllabus=args["syllabus"], account=args["username"])
result = common.add_to_db(db, collection)
if result == True:
return {"id": collection.id}
else:
return {"error": "commit error in mysql"}, 500
def get(self):
"""
申请人获取用户已经上传的课表数据
地址: /interaction/api/v2/syllabus_collection
方法: GET
参数:
位置: headers
必须参数:
username 用户账号
token 验证令牌
collectionID 之前申请到的获取id
:return:
"""
self.GET_PARSER.add_argument("username",
required=True,
location="headers")
self.GET_PARSER.add_argument("token",
required=True,
location="headers")
# header里面的键名不能有下划线
self.GET_PARSER.add_argument("collectionID",
required=True,
location="headers")
args = self.GET_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account",
args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collector = common.query_single_by_filed(models.Collector,
"collection_id",
args["collectionID"])
if collector is None:
# 表明用户输入了错误的collection_id
return {"error": "wrong collection_id"}, 404
# 检查权限
if collector.uid != user.id:
return {"error": "have not the permission"}, 403
collections = models.SyllabusCollection.query.filter_by(
collection_id=args["collectionID"]).all()
collections = [
dict(id=x.id, account=x.account, syllabus=x.syllabus)
for x in collections
]
return {"collections": collections}
def get(self):
self.GET_PARSER.add_argument("username",
required=True,
location="headers")
self.GET_PARSER.add_argument("token",
required=True,
location="headers")
args = self.GET_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account",
args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
token_check = {"uid": user.id, "token": args["token"]}
if not common.check_token(token_check):
return {"error": "token is wrong"}, 401
collectors = models.Collector.query.filter_by(uid=user.id).all()
result = []
for collector in collectors:
count = models.SyllabusCollection.query.with_entities(
models.SyllabusCollection.collection_id).filter_by(
collection_id=collector.collection_id).count()
result.append({
"collection_id": collector.collection_id,
"start_year": collector.start_year,
"season": collector.season,
"count": count
})
# collectors = [ dict(collection_id=x.collection_id, start_year=x.start_year, season=x.season) for x in collectors ]
return {"collection_ids": result}
def new_or_update_user(account, token):
"""
插入新的用户, 或者是更新旧用户
:param account:
:param token:
:return:
"""
user = common.query_single_by_filed(User, "account", account)
if user is None:
# 新用户
user = User(account=account, token=token)
ret_val = common.add_to_db(db, user)
if ret_val != True:
print(ret_val[1])
return False
else:
return user
# 老用户
user.token = token # 更新token
ret_val = common.add_to_db(db, user)
if ret_val != True:
print(ret_val[1])
return False
else:
return user
def get(self, account=None):
if account is None:
return {"error": "name required in the query parameter"}, 400
# print(name)
# input()
user = common.query_single_by_filed(User, "account", account)
if user is None:
return {"error": "no user's account is {}".format(account)}, 404
return marshal(user, SINGLE_USER_STRUCTURE)
# class UserResource(GenericResource):
#
# # curl --header "Content-type: application/json" localhost:8080/interaction/api/v2/user -X PUT -d '{"id": 1, "birthday": "819648000", "nickname": "xiaofud", "gender": 1, "profile": "hello world"}'
# # date -d "1995-12-23" "+%s" 获取时间戳
# def put(self):
# args = put_parser.parse_args()
# if args["birthday"] is not None:
# birthday = datetime.fromtimestamp(int(args["birthday"]))
# birthday = birthday.strftime("%Y-%m-%d %H:%M:%S")
# args["birthday"] = birthday
# # print(birthday)
# user_id = args.pop("id")
#
# # for arg in args:
# # if arg not in UserResource.ACCEPT_VARIABLES:
# # args.pop(arg)
# # 去除其他参数, 避免用户自己修改token之类的数据
# helpers.clean_arguments(args, PUT_ACCEPT_VARIABLES)
#
# result = user_operation.update_user_by_id(user_id, **args)
# if result == True:
# return {"status": "updated"}, 200
# else:
# if result[1] == user_operation.common.ERROR_NOT_FOUND:
# return {"error": "user not found"}, 404
# else:
# return {"error": "failed"}, 500 # Internal Server Error
# Argument Locations
# By default, the RequestParser tries to parse values from flask.Request.values, and flask.Request.json.
#
# Use the location argument to add_argument() to specify alternate locations to pull the values from. Any variable on the flask.Request can be used. For example:
#
# # Look only in the POST body
# parser.add_argument('name', type=int, location='form')
#
# # Look only in the querystring
# parser.add_argument('PageSize', type=int, location='args')
#
# # From the request headers
# parser.add_argument('User-Agent', location='headers')
#
# # From http cookies
# parser.add_argument('session_id', location='cookies')
#
# # From file uploads
# parser.add_argument('picture', type=werkzeug.datastructures.FileStorage, location='files')
# Note
# Only use type=list when location='json'. See this issue for more details
def get(self):
self.GET_PARSER.add_argument("username", required=True, location="headers")
self.GET_PARSER.add_argument("token", required=True, location="headers")
args = self.GET_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
token_check = {
"uid": user.id,
"token": args["token"]
}
if not common.check_token(token_check):
return {"error": "token is wrong"}, 401
collectors = models.Collector.query.filter_by(uid=user.id).all()
result = []
for collector in collectors:
count = models.SyllabusCollection.query.with_entities(models.SyllabusCollection.collection_id).filter_by(collection_id=collector.collection_id).count()
result.append(
{
"collection_id": collector.collection_id,
"start_year": collector.start_year,
"season": collector.season,
"count": count
}
)
# collectors = [ dict(collection_id=x.collection_id, start_year=x.start_year, season=x.season) for x in collectors ]
return {"collection_ids": result}
def delete(self):
self.DELETE_PARSER.add_argument("username",
required=True,
location="headers")
self.DELETE_PARSER.add_argument("token",
required=True,
location="headers")
self.DELETE_PARSER.add_argument("id",
required=True,
location="headers")
args = self.DELETE_PARSER.parse_args()
# 检查token
user = common.query_single_by_filed(models.User, "account",
args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collection = common.query_single_by_id(models.SyllabusCollection,
args["id"])
if collection is None:
return {"error": "collection not found"}, 404
if collection.account == args["username"]:
status = delete_record(db, collection)
if status == True:
return {"status": "deleted"}
else:
return {"error": repr(status[1])}, 500
else:
collector = common.query_single_by_filed(models.Collector,
"collection_id",
collection.collection_id)
if collector is None:
return {"error": "collector not found"}, 404
if collector.uid == user.id:
status = delete_record(db, collection)
if status == True:
return {"status": "deleted"}
else:
return {"error": repr(status[1])}, 500
else:
return {"error": "have not the permission"}, 403
def get(self):
"""
申请人获取用户已经上传的课表数据
地址: /interaction/api/v2/syllabus_collection
方法: GET
参数:
位置: headers
必须参数:
username 用户账号
token 验证令牌
collectionID 之前申请到的获取id
:return:
"""
self.GET_PARSER.add_argument("username", required=True, location="headers")
self.GET_PARSER.add_argument("token", required=True, location="headers")
# header里面的键名不能有下划线
self.GET_PARSER.add_argument("collectionID", required=True, location="headers")
args = self.GET_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collector = common.query_single_by_filed(models.Collector, "collection_id", args["collectionID"])
if collector is None:
# 表明用户输入了错误的collection_id
return {"error": "wrong collection_id"}, 404
# 检查权限
if collector.uid != user.id:
return {"error": "have not the permission"}, 403
collections = models.SyllabusCollection.query.filter_by(collection_id=args["collectionID"]).all()
collections = [ dict(id=x.id, account=x.account, syllabus=x.syllabus) for x in collections ]
return {"collections": collections}
def post(self):
args = self.get_parser.parse_args(strict=True)
status = auth(args["username"], args["password"])
if status["code"] == CODE_OKAY:
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "account correct but not found in database"}, 404
return {"token": user.token}, 200
elif status["code"] == CODE_FALSE:
# 凭证有误
return {"error": "incorrect"}, 401
else:
# 内部网络错误
return {"error": "INTERNET FAILURE"}, 500
def delete(self):
self.DELETE_PARSER.add_argument("username", required=True, location="headers")
self.DELETE_PARSER.add_argument("token", required=True, location="headers")
self.DELETE_PARSER.add_argument("id", required=True, location="headers")
args = self.DELETE_PARSER.parse_args()
# 检查token
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collection = common.query_single_by_id(models.SyllabusCollection, args["id"])
if collection is None:
return {"error": "collection not found"}, 404
if collection.account == args["username"]:
status = delete_record(db, collection)
if status == True:
return {"status": "deleted"}
else:
return {"error": repr(status[1])}, 500
else:
collector = common.query_single_by_filed(models.Collector, "collection_id", collection.collection_id)
if collector is None:
return {"error": "collector not found"}, 404
if collector.uid == user.id:
status = delete_record(db, collection)
if status == True:
return {"status": "deleted"}
else:
return {"error": repr(status[1])}, 500
else:
return {"error": "have not the permission"}, 403
def post(self):
"""
请求地址: /interaction/api/v2/collector
参数:
必选参数:
位置: form
username 用户账号
token 用户验证令牌
start_year 学年的开始年份
season 春夏秋指定一个, 同学分制
:return:
"""
self.POST_PARSER.add_argument("username",
required=True,
location="form")
self.POST_PARSER.add_argument("token", required=True, location="form")
self.POST_PARSER.add_argument("start_year",
type=int,
required=True,
location="form")
self.POST_PARSER.add_argument("season",
type=int,
required=True,
location="form")
args = self.POST_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account",
args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
token_check = {"uid": user.id, "token": args["token"]}
if not common.check_token(token_check):
return {"error": "token is wrong"}, 401
while True:
collection_id = generate_collection_id()
if not check_existence(collection_id):
break
collector = models.Collector(collection_id=collection_id,
start_year=args["start_year"],
season=args["season"],
uid=user.id)
result = common.add_to_db(db, collector)
if result == True:
return {"collection_id": collector.collection_id}
else:
return {"error": "commit error in mysql"}, 500
def post(self):
"""
请求地址: /interaction/api/v2/collector
参数:
必选参数:
位置: form
username 用户账号
token 用户验证令牌
start_year 学年的开始年份
season 春夏秋指定一个, 同学分制
:return:
"""
self.POST_PARSER.add_argument("username", required=True, location="form")
self.POST_PARSER.add_argument("token", required=True, location="form")
self.POST_PARSER.add_argument("start_year", type=int, required=True, location="form")
self.POST_PARSER.add_argument("season", type=int, required=True, location="form")
args = self.POST_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account", args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
token_check = {
"uid": user.id,
"token": args["token"]
}
if not common.check_token(token_check):
return {"error": "token is wrong"}, 401
while True:
collection_id = generate_collection_id()
if not check_existence(collection_id):
break
collector = models.Collector(collection_id=collection_id, start_year=args["start_year"], season=args["season"], uid=user.id)
result = common.add_to_db(db, collector)
if result == True:
return {"collection_id": collector.collection_id}
else:
return {"error": "commit error in mysql"}, 500
def post(self):
"""
发送课表数据到服务器
地址: /interaction/api/v2/syllabus_collection
方法: POST
参数:
位置: form
必选参数:
username 用户账号
token 验证令牌
start_year 学年的开始年份
season 某个学期, 和学分制对应
syllabus 课表的JSON数据
:return:
"""
self.POST_PARSER.add_argument("username",
required=True,
location="form")
self.POST_PARSER.add_argument("token", required=True, location="form")
self.POST_PARSER.add_argument("start_year",
type=int,
required=True,
location="form")
self.POST_PARSER.add_argument("season",
type=int,
required=True,
location="form")
self.POST_PARSER.add_argument("collection_id",
required=True,
location="form")
self.POST_PARSER.add_argument("syllabus",
required=True,
location="form")
args = self.POST_PARSER.parse_args()
user = common.query_single_by_filed(models.User, "account",
args["username"])
if user is None:
return {"error": "user doesn't exist"}, 404
if not check_token(user, args["token"]):
return {"error": "token is wrong"}, 401
collector = common.query_single_by_filed(models.Collector,
"collection_id",
args["collection_id"])
if collector is None:
# 表明用户输入了错误的collection_id
return {"error": "wrong collection_id"}, 404
# 检查学期是否正确
if collector.start_year != args[
"start_year"] or collector.season != args["season"]:
return {"error": "semester doesn't match"}, 400
collection = models.SyllabusCollection.query.filter_by(
account=user.account).filter_by(
collection_id=args["collection_id"]).first()
if collection is not None:
# 删除原有记录
status = delete_record(db, collection)
if status != True:
return {"error": repr(status[1])}, 500
collection = models.SyllabusCollection(
collection_id=args["collection_id"],
syllabus=args["syllabus"],
account=args["username"])
result = common.add_to_db(db, collection)
if result == True:
return {"id": collection.id}
else:
return {"error": "commit error in mysql"}, 500
def check_existence(collection_id):
collector = common.query_single_by_filed(models.Collector, "collection_id",
collection_id)
if collector is None:
return False
return True
def get(self, account=None):
if account is None:
return {"error": "name required in the query parameter"}, 400
# print(name)
# input()
user = common.query_single_by_filed(User, "account", account)
if user is None:
return {"error": "no user's account is {}".format(account)}, 404
return marshal(user, SINGLE_USER_STRUCTURE)
# class UserResource(GenericResource):
#
# # curl --header "Content-type: application/json" localhost:8080/interaction/api/v2/user -X PUT -d '{"id": 1, "birthday": "819648000", "nickname": "xiaofud", "gender": 1, "profile": "hello world"}'
# # date -d "1995-12-23" "+%s" 获取时间戳
# def put(self):
# args = put_parser.parse_args()
# if args["birthday"] is not None:
# birthday = datetime.fromtimestamp(int(args["birthday"]))
# birthday = birthday.strftime("%Y-%m-%d %H:%M:%S")
# args["birthday"] = birthday
# # print(birthday)
# user_id = args.pop("id")
#
# # for arg in args:
# # if arg not in UserResource.ACCEPT_VARIABLES:
# # args.pop(arg)
# # 去除其他参数, 避免用户自己修改token之类的数据
# helpers.clean_arguments(args, PUT_ACCEPT_VARIABLES)
#
# result = user_operation.update_user_by_id(user_id, **args)
# if result == True:
# return {"status": "updated"}, 200
# else:
# if result[1] == user_operation.common.ERROR_NOT_FOUND:
# return {"error": "user not found"}, 404
# else:
# return {"error": "failed"}, 500 # Internal Server Error
# Argument Locations
# By default, the RequestParser tries to parse values from flask.Request.values, and flask.Request.json.
#
# Use the location argument to add_argument() to specify alternate locations to pull the values from. Any variable on the flask.Request can be used. For example:
#
# # Look only in the POST body
# parser.add_argument('name', type=int, location='form')
#
# # Look only in the querystring
# parser.add_argument('PageSize', type=int, location='args')
#
# # From the request headers
# parser.add_argument('User-Agent', location='headers')
#
# # From http cookies
# parser.add_argument('session_id', location='cookies')
#
# # From file uploads
# parser.add_argument('picture', type=werkzeug.datastructures.FileStorage, location='files')
# Note
# Only use type=list when location='json'. See this issue for more details
def check_existence(collection_id):
collector = common.query_single_by_filed(models.Collector, "collection_id", collection_id)
if collector is None:
return False
return True
