现有Flask项目,已经可以用pymysql中sql语句去查询到已有的mysql的数据库中:
对应的数据了:
相关代码是:pageNumber = parsedArgs["pageNumber"]
pageSize = parsedArgs["pageSize"]
searchByUserSql = "SELECT * FROM `user_storybook_list` WHERE `userId` = %d" % userId
searchByUserOk, resultDict = sqlConn.executeSql(searchByUserSql)
log.debug("%s -> %s, %s", searchByUserSql, searchByUserOk, resultDict)
if searchByUserOk and resultDict["data"]:
foundItemList = resultDict["data"]
respDict["data"] = foundItemList
return jsonify(respDict)
else:
return genRespFailDict(NotFound.code, "Not found user storybook list from userId %d" % userId)
现在需要去:
实现返回结果的分页数据
根据page的size和number返回对应数据,最好加上:
中的字段:respData = {
"evaluationList": evaluationList,
"curPageNum": pageNumber,
"numPerPage": pageSize,
"totalNum": totalCount,
"totalPageNum": totalPageNum,
"hasPrev": hasPrev,
"hasNext": hasNext,
}
便于前端去分页显示
mysql select pagingSELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
好像就基本够用了。
还要加上sort才行,根据此处的