def addSearch(): try: open_id = request.json['open_id'] keyword = request.json['keyword'] if not open_id and not keyword: return jsonify({'code': '9999', 'message': '新增数据失败:参数值不能为空'}) db = Db() # 取数据 result = db.selectAll( 'select * from gysw_search where keyword = "%s" and open_id = "%s"' % (keyword, open_id)) if not result or len(result) == 0: print('新增...') # 没有,新增 sql = 'insert into gysw_search (`open_id`, `keyword`, `last_update_at`) values (%s, %s, %s)' localtime = time.localtime(time.time()) db.insertOne(sql, (open_id, keyword, localtime)) else: print('修改...') # 修改,次数 +1 current = result[0] times = current['times'] + 1 db.updateOne( 'update gysw_search set times = %d where open_id = "%s" and keyword = "%s"' % (times, open_id, keyword)) db.close() return jsonify({'code': '0000', 'message': '新增数据成功'}) except Exception as e: print(e) return jsonify({'code': '9999', 'message': '新增数据失败'})
def editShelf(id): chapter_url = request.json['chapter_url'] try: db = Db() db.updateOne('update gysw_shelf set chapter_url = "%s" where id = %s' % (chapter_url, id)) db.close() return jsonify({'code': '0000', 'message': '修改数据成功'}) except: return jsonify({'code': '9999', 'message': '修改数据失败'})