def search_lock_domain_name(self):
"""
查询域名状态
:return:
"""
try:
"""查询redis"""
result = BusinessUtil.get_redis_by_key(
busi_config.LOCK_ACCOUNT_REDIS_KEY)
if result:
return result
"""查询数据库"""
_db = MySqlHelper()
result = _db.fetch_one(
send_email_account_sql.search_lock_domain_name)
if not result:
return False
"""获取域名"""
domain_name = result.get("domainName", "")
"""如果不为空 则添加到redis"""
if domain_name:
BusinessUtil.set_redis_by_key(
busi_config.LOCK_ACCOUNT_REDIS_KEY, domain_name,
busi_config.REDIS_CACHE_TIME)
return domain_name
except Exception as e:
self.logger.error("【查询发送邮箱账号】查询异常信息为：%s" % traceback.format_exc())
return False
def search_task_code_by_server_ip(self, server_ip):
"""
通过服务器IP查询任务编号
:param server_ip
:return:
"""
try:
_db = MySqlHelper()
result = _db.fetch_one(task_sql.search_task_code_by_server_ip,
server_ip)
if not result:
self.logger.info("【查询任务编号】响应结果为空，结束流程")
return False
return result
except Exception as e:
self.logger.error("【查询任务编号】查询异常信息为：%s" % traceback.format_exc())
return False
def search_account_residue(self, user_name):
"""
查询账号剩余量
:param user_name:
:return:
"""
try:
if not user_name:
return False
timeStr = str(
time.strftime('%Y-%m-%d', time.localtime(time.time())))
_db = MySqlHelper()
result = _db.fetch_one(used_of_count_sql.search_account_residue,
(timeStr, user_name))
if not result:
return False
return result.get("residue", 0)
except Exception as e:
self.logger.error("【查询账号使用量】查询异常信息为：%s" % traceback.format_exc())
return False
def search_by_status(self, user_name, status):
"""
通过账号、状态查询当前用户发送次数
:param user_name:
:param status:
:return:
"""
try:
"""参数异常"""
if not user_name or not status:
return False
"""查询"""
timeStr = str(
time.strftime('%Y-%m-%d', time.localtime(time.time())))
_db = MySqlHelper()
result = _db.fetch_one(send_record_sql.search_by_status,
(user_name, status, timeStr))
if not result:
return False
return result.get("num", 0)
except Exception as e:
self.logger.error("【查询发送记录】查询异常信息为：%s" % traceback.format_exc())
return False
