def add_question_history(qid, date, view_num, answer_num): # 创建Session对象: session = mysql_api.get_session() entity = ZhQuestionHistory(qid, date, view_num, answer_num) session.add(entity) session.commit() session.close()
def add_log(type, event, msg): # 创建Session对象: session = mysql_api.get_session() entity = ZhLog(type, event, msg) session.add(entity) session.commit() session.close()
def add_answer_history(qid, aid, date, like_num, rank): # 创建Session对象: session = mysql_api.get_session() entity = ZhAnswerHistory(qid, aid, date, like_num, rank) session.add(entity) session.commit() session.close()
def query_res_content_by_type(type, exclude_ids): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: content = session.query(Resource).filter(Resource.type == type).filter(~Resource.id.in_(exclude_ids)).first() # 关闭Session: session.close() return content
def update_question_yestoday(qid, view_num, answer_num): # 创建Session对象: session = mysql_api.get_session() session.query(ZhQuestion)\ .filter(ZhQuestion.qid == qid) \ .update({"view_before_today": view_num, "answer_before_today": answer_num}) session.commit() session.close()
def query_early_check_rows_by_user_name(user_name): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(EarlyCheck).filter(EarlyCheck.user_name == user_name).all() # 关闭Session: session.close() return rows
def query_user_by_id(user_id): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: u = session.query(User).filter(User.id == user_id).one() # 关闭Session: session.close() return u
def query_today_order_amt(): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: amt = 0 # 关闭Session: session.close() return amt
def update_config(config_key, value): # 创建Session对象: session = mysql_api.get_session() session.query(ZhConfig) \ .filter(ZhConfig.config_key == config_key) \ .update({"value": value}) session.commit() session.close()
def update_answer_yestoday(aid, like_num, rank): # 创建Session对象: session = mysql_api.get_session() session.query(ZhAnswer)\ .filter(ZhAnswer.aid == aid) \ .update({"like_num_yestoday": like_num, "rank_yestoday": rank}) session.commit() session.close()
def query_service_by_id(service_id): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: row = session.query(Service).filter(Service.id == service_id).one() # 关闭Session: session.close() return row
def query_config(config_key): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: value = session.query(ZhConfig).filter( ZhConfig.config_key == config_key).one() # 关闭Session: session.close() return value
def update_search(article_id, rank): # 创建Session对象: session = mysql_api.get_session() session.query(ZhSearch)\ .filter(ZhSearch.article_id == article_id) \ .update({"rank": rank, "update_time": get_current_datetime()}) session.commit() session.close()
def query_answer_list(): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(ZhAnswer)\ .filter(ZhAnswer.flag == 0)\ .all() session.close() return rows
def query_service_subscribe_by_service_id(service_id): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(ServiceSubscribe).filter( ServiceSubscribe.service_id == service_id).filter( ServiceSubscribe.flag == 0).all() # 关闭Session: session.close() return rows
def update_answer(aid, like_num, rank): # 创建Session对象: session = mysql_api.get_session() session.query(ZhAnswer) \ .filter(ZhAnswer.aid == aid) \ .update({"like_num": like_num, "rank": rank, "update_time": get_current_datetime()}) session.commit() session.close()
def query_search_list(user_id): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(ZhSearch)\ .filter(ZhSearch.user_id == user_id) \ .order_by(ZhSearch.rank) \ .all() session.close() return rows
def add_order(order_no, sku_id, sku_name, price, fee, fee_rate, order_time, union_tag): # 创建Session对象: session = mysql_api.get_session() entity = ZhOrder(order_no, sku_id, sku_name, price, fee, fee_rate, order_time, union_tag) session.add(entity) session.commit() session.close() return
def query_res_log_by_type(user_id, res_type): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(ResourceLog).filter( ResourceLog.user_id == user_id).filter( ResourceLog.resource_type == res_type).all() # 关闭Session: session.close() return rows
def query_today_holiday(): # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(Holiday).filter(Holiday.date == time.strftime("%m-%d", time.localtime())).all() # 关闭Session: session.close() if len(rows) == 0: return '' else: return rows[0].desc
def add_resource(type, content): res = Resource(type, content) # 创建session对象: session = mysql_api.get_session() # 添加到session: session.add(res) # 提交即保存到数据库: session.commit() # 关闭session: session.close()
def add_resource_log(user_id, resource_id, resource_type): res_log = ResourceLog(user_id, resource_id, resource_type) # 创建session对象: session = mysql_api.get_session() # 添加到session: session.add(res_log) # 提交即保存到数据库: session.commit() # 关闭session: session.close()
def update_question(qid, title, view_num, answer_num): # 创建Session对象: session = mysql_api.get_session() session.query(ZhQuestion)\ .filter(ZhQuestion.qid == qid) \ .update({"title": title, "view_total": view_num, "answer_total": answer_num, "update_time": get_current_datetime()}) session.commit() session.close()
def query_error_log(): dateTime = get_last_x_min_ts(10).strftime('%Y-%m-%d %H:%M:%S') # dateTime = '2021-02-06 17:00' # 创建Session对象: session = mysql_api.get_session() # 创建Query查询,filter是where条件,最后调用one()返回唯一行,如果调用all()则返回所有行: rows = session.query(ZhLog) \ .filter(ZhLog.create_time > dateTime) \ .all() session.close() return rows
def add_early_check(user_name, date, check_time): logger.info('add new add_early_check param:{} {} {}'.format(user_name, date, check_time)) u = EarlyCheck(user_name, date, check_time) # 创建session对象: session = mysql_api.get_session() # 添加到session: session.add(u) # 提交即保存到数据库: session.commit() # 关闭session: session.close() return
def add_user(new_user): # 创建session对象: session = mysql_api.get_session() # 添加到session: session.add(new_user) # 提交即保存到数据库: session.commit() user_id = new_user.id # 关闭session: session.close() logger.info("add user id: {}".format(user_id)) return user_id
def update_goods(sku_id, sku_name, price, fee_rate, fee, jd_sale, order_num, cid1, cid1_name, cid2, cid2_name, cid3, cid3_name): # 创建Session对象: session = mysql_api.get_session() if sku_name == "无效商品": session.query(ZhGoods) \ .filter(ZhGoods.sku_id == sku_id) \ .update({"price": price, "fee_rate": fee_rate, "fee": fee, "jd_sale": jd_sale, "order_num": order_num, "cid1": cid1, "cid1_name": cid1_name, "cid2": cid2, "cid2_name": cid2_name, "cid3": cid3, "cid3_name": cid3_name, "update_time": get_current_datetime()}) else: session.query(ZhGoods) \ .filter(ZhGoods.sku_id == sku_id) \ .update({"sku_name": sku_name, "price": price, "fee_rate": fee_rate, "fee": fee, "jd_sale": jd_sale, "order_num": order_num, "cid1": cid1, "cid1_name": cid1_name, "cid2": cid2, "cid2_name": cid2_name, "cid3": cid3, "cid3_name": cid3_name, "update_time": get_current_datetime()}) session.commit() session.close()