def create(_id):
logger.info("create start, id=%s", _id)
conn = db.connect_torndb()
rel = conn.get("select * from track_group_item_rel where id=%s", _id)
if rel is None or rel["active"] != 'Y':
conn.close()
return
track_group_id = rel["trackGroupId"]
company_id = rel["companyId"]
investor_id = rel["investorId"]
track_group = conn.get("select * from track_group where id=%s", track_group_id)
if track_group is None or track_group["active"] != 'Y':
conn.close()
return
messages = track_util.get_messages_by_item(conn, track_group, company_id or investor_id)
user_ids = track_util.get_track_user_ids_by_track_group(conn, track_group_id)
conn.close()
mongo = db.connect_mongo()
for message in messages:
for user_id in user_ids:
track_util.push_message_to_user(mongo, track_group, user_id, message)
mongo.close()
logger.info("create end.")
def process(conn, mongo, company_message_id):
if company_message_id is None:
return
message = conn.get("select * from company_message where id=%s",
company_message_id)
if message is None:
return
if message["active"] != 'Y':
return
logger.info("track company_message_id: %s", company_message_id)
# 推送给用户
company_id = message["companyId"]
track_dimension = message["trackDimension"]
track_sub_type = conn.get(
"select st.* from track_sub_type st join track_type t on st.trackTypeId=t.id "
"where st.trackDimension=%s and t.type=82001 and st.active='Y' and t.active='Y' limit 1",
track_dimension)
if track_sub_type is None:
return
# 公司所在的分组
track_groups = track_util.get_track_groups(conn,
track_dimension,
company_id=company_id)
for g in track_groups:
track_group_id = g["id"]
user_ids = track_util.get_track_user_ids_by_track_group(
conn, track_group_id)
for user_id in user_ids:
track_util.push_message_to_user(mongo, g, user_id, message)
def create(_id):
logger.info("create start, id=%s", _id)
conn = db.connect_torndb()
dim = conn.get("select * from track_group_dimension where id=%s", _id)
if dim is None or dim["active"] != 'Y':
conn.close()
return
track_group_id = dim["trackGroupId"]
track_dimension = dim["trackDimension"]
track_group = conn.get("select * from track_group where id=%s",
track_group_id)
if track_group is None or track_group["active"] != 'Y':
conn.close()
return
messages = track_util.get_messages_by_track_group_and_dimension(
conn, track_group, track_dimension)
user_ids = track_util.get_track_user_ids_by_track_group(
conn, track_group_id)
conn.close()
mongo = db.connect_mongo()
for message in messages:
for user_id in user_ids:
track_util.push_message_to_user(mongo, track_group, user_id,
message)
mongo.close()
logger.info("create end.")
def delete(_id):
logger.info("delete start, id=%s", _id)
conn = db.connect_torndb()
mongo = db.connect_mongo()
# 删除分组某个公司or机构消息
item = conn.get("select * from track_group_item_rel where id=%s", _id)
if item is None or item["active"] != 'N':
conn.close()
mongo.close()
return
track_group_id = item["trackGroupId"]
if item["companyId"] is not None:
item_id = item["companyId"]
mongo.message.user_message2.delete_many({"trackGroupId": track_group_id, "companyId": item_id})
elif item["investorId"] is not None:
item_id = item["investorId"]
mongo.message.user_message2.delete_many({"trackGroupId": track_group_id, "investorId": item_id})
else:
conn.close()
mongo.close()
return
track_group = conn.get("select * from track_group where id=%s", track_group_id)
if track_group is None:
conn.close()
mongo.close()
return
# 删除-1,-2,-3冗余数据
messages = track_util.get_messages_by_item(conn, track_group, item_id)
user_ids = track_util.get_track_user_ids_by_track_group(conn, track_group_id)
track_util.purge_redundant_user_message(mongo, track_group, user_ids, messages)
mongo.close()
conn.close()
logger.info("delete end.")
def delete(_id):
logger.info("delete start, id=%s", _id)
conn = db.connect_torndb()
mongo = db.connect_mongo()
# 删除分组所有消息
mongo.message.user_message2.delete_many({"trackGroupId": _id})
track_group_id = _id
track_group = conn.get("select * from track_group where id=%s", track_group_id)
if track_group is None or track_group["active"] != 'N':
conn.close()
mongo.close()
return
# 删除-1,-2,-3冗余数据
messages = track_util.get_messages_by_track_group(conn, track_group)
user_ids = track_util.get_track_user_ids_by_track_group(conn, track_group_id)
track_util.purge_redundant_user_message(mongo, track_group, user_ids, messages)
mongo.close()
conn.close()
logger.info("delete end.")
def delete(_id):
logger.info("create delete, id=%s", _id)
conn = db.connect_torndb()
mongo = db.connect_mongo()
# 删除分组某个维度消息
dim = conn.get("select * from track_group_dimension where id=%s", _id)
if dim is None or dim["active"] != 'N':
conn.close()
mongo.close()
return
track_group_id = dim["trackGroupId"]
track_dimension = dim["trackDimension"]
mongo.message.user_message2.delete_many({
"trackGroupId": track_group_id,
"trackDimension": track_dimension
})
track_group = conn.get("select * from track_group where id=%s",
track_group_id)
if track_group is None:
conn.close()
mongo.close()
return
# 删除-1,-2,-3冗余数据
messages = track_util.get_messages_by_track_group_and_dimension(
conn, track_group, track_dimension)
user_ids = track_util.get_track_user_ids_by_track_group(
conn, track_group_id)
track_util.purge_redundant_user_message(mongo, track_group, user_ids,
messages)
mongo.close()
conn.close()
logger.info("delete end.")