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()
