def insert_update_used(self, param):
"""
添加或更新数据
:param param:
:return:
"""
_db = None
try:
if not param:
self.logger.info("【添加/更新账号使用量】请求参数为为空，流程结束")
"""查询数据"""
_db = MySqlHelper()
count = _db.count(
used_of_count_sql.count,
(param.get("usedOfContent"), param.get("usedType"),
param.get("start"), param.get("end")))
if count > 0:
result = _db.update(
used_of_count_sql.update_used_count,
(param.get("usedOfContent"), param.get("usedType"),
param.get("start"), param.get("end")))
else:
result = _db.insert_one(
used_of_count_sql.insert_used,
(param.get("usedOfContent"), param.get("usedType")))
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【添加/更新账号使用量】保存异常信息为：%s" %
traceback.format_exc())
return False
def insert_update(self, param):
"""
添加或更新数据
:param param:
:return:
"""
_db = None
try:
if not param:
self.logger.info("【添加/更新营销数据】请求参数为为空，流程结束")
"""查询数据"""
_db = MySqlHelper()
count = _db.count(marketing_data_sql.count,
(param.get("batchCode"), param.get("mobile"),
param.get("email")))
if count > 0:
result = _db.update(
marketing_data_sql.update_insert,
(param.get("subBatchCode"), param.get("batchCode"),
param.get("mobile"), param.get("email")))
else:
result = _db.insert_one(
marketing_data_sql.insert,
(param.get("batchCode"), param.get("subBatchCode"),
param.get("mobile"), param.get("email")))
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【添加/更新营销数据】保存异常信息为：%s" % traceback.format_exc())
return False
def insert_format(self, result):
"""
添加收取记录
:param result:
:return:
"""
_db = None
try:
if not result:
self.logger.info("【保存收取记录】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
for item in result:
insert_format = pop_record_sql.insert_format.format(**item)
_db.insert_one(insert_format)
_db.end()
return True
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【保存收取记录】保存异常信息为：%s" % traceback.format_exc())
return False
def update(self, param):
"""
更新发送邮箱账号
:return:
"""
_db = None
try:
if not param:
self.logger.info("【更新发送邮箱账号】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
result = _db.insert_one(send_email_account_sql.update, param)
_db.end()
return result
except Exception as e:
_db.isEnd = 2
_db.end()
self.logger.error("【更新发送邮箱账号】更新异常信息为：%s" % traceback.format_exc())
return False
def update(self, param):
"""
更新代理服务器
:return:
"""
_db = None
try:
if not param:
self.logger.info("【更新代理服务器】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
result = _db.insert_one(proxy_server_conf_sql.update, param)
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【更新代理服务器】更新异常信息为：%s" % traceback.format_exc())
return False
def insert(self, param):
"""
添加数据
:param param:
:return:
"""
_db = None
try:
if not param:
self.logger.info("【保存黑白名单】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
result = _db.insert_one(black_white_roll_call_sql.insert, param)
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【保存黑白名单】保存异常信息为：%s" % traceback.format_exc())
return False
def update_select_count(self, param):
"""
更新账号使用量
:return:
"""
_db = None
try:
if not param:
self.logger.info("【更新账号使用量】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
result = _db.insert_one(used_of_count_sql.update_select_count,
param)
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【更新账号使用量】更新异常信息为：%s" % traceback.format_exc())
return False
def insert(self, param):
"""
添加发送记录
:param param:
:return:
"""
_db = None
try:
if not param:
self.logger.info("【保存发送记录】请求参数为为空，流程结束")
return False
_db = MySqlHelper()
result = _db.insert_one(send_record_sql.insert, param)
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【保存发送记录】保存异常信息为：%s" % traceback.format_exc())
return False
def insert_update_more(self, result):
"""
添加或更新数据
:param result:
:return:
"""
_db = None
try:
if not result:
self.logger.info("【添加/更新营销数据】请求参数为为空，流程结束")
"""查询数据"""
_db = MySqlHelper()
for param in result:
param["subBatchCode"] = BusinessUtil.get_uniqu_time()
count = _db.count(marketing_data_sql.count,
(param.get("batchCode"), param.get("mobile"),
param.get("email")))
if count > 0:
result = _db.update(
marketing_data_sql.update_insert,
(param.get("subBatchCode"),
int(param.get("status", "0")), param.get("batchCode"),
param.get("mobile"), param.get("email")))
else:
result = _db.insert_one(
marketing_data_sql.insert,
(param.get("originalBatchCode"),
param.get("batchCode"), param.get("subBatchCode"),
param.get("mobile"), param.get("email"),
int(param.get("status", "0"))))
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【添加/更新营销数据】保存异常信息为：%s" % traceback.format_exc())
return False
def update_by_policy(self, sql):
"""
通过策略更新对应数据
:param sql:
:return:
"""
_db = None
try:
if not sql:
self.logger.info("【更新策略】请求参数为为空，流程结束")
_db = MySqlHelper()
"""判断是更新还是插入"""
if sql.upper().find("INSERT"):
result = _db.insert_one(sql)
else:
result = _db.update(sql)
_db.end()
return result
except Exception as e:
if _db:
_db.isEnd = 2
_db.end()
self.logger.error("【更新策略】保存异常信息为：%s" % traceback.format_exc())
return False
