【django后端分离】mysql原生查询命令后,RawQueryset类型的自定
发布时间:2020-12-15 17:09:15 所属栏目:大数据 来源:网络整理
导读:1:设置mysql原生分页 # 监控系统首页显示分页 def MyPagination(limitid,offsetid): limitid = str(limitid) offsetid = str(offsetid) # 这里是mysql原生代码 show_goods = " select dal_keywordtable.* from (select asin,min(ranking) as minRanking fro
1:设置mysql原生分页 # 监控系统首页显示分页 def MyPagination(limitid,offsetid): limitid =str(limitid) offsetid =str(offsetid) 2:GET请求连接上找到传入的limit与offset: from utils import orm 导入上面的分页连接,带参数调用这个方法 从第offsetid开始取,取limitid个 limitid = request._request.GET.get(limit") offsetid = request._request.GET.get(offset) raw_Pagination =MyPagination(limitid,offsetid) obj_rawqueryset = models.KeyWordTable.objects.raw(raw_Pagination) # 得到 3:序列化查询的RawQueryset类型,返回json格式: 序列化 json_data = {} data_list = [] for obj in obj_rawqueryset: data = {} 要在遍历里面创建字典用于存数据 (obj) data[goods_title"] = obj.goods_title data[src obj.src data[single_keyword obj.single_keyword data[asin obj.asin data[seed_asin obj.seed_asin data[ranking obj.ranking data[position obj.position data[time"] = obj.time.strftime('%Y-%m-%d') data_list.append(data) json_data[data'] = data_list Response(json_data) 返回给前端的json格式: { : [ { ": Sloggers Women's Waterproof Rain and Garden Shoe with Comfort Insole,Blue Swirls,Size 6,Style 5117SWL06,https://images-na.ssl-images-amazon.com/images/I/41CSEL0bHeL._SS36_.jpg: null,1)">B077TDGR51B01H7X9ASA": 6666662019-12-02 },{ S1loggers Women's Waterproof Rain and Garden Shoe with Comfort Insole,1)">B077TDGR53B01H7X9ASBS2loggers Women's Waterproof Rain and Garden Shoe with Comfort Insole,1)">B077TDGR52B01H7X9ASC": 22019-12-03 } ] } ? ? (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |