def get_pdns_record(self, dn=None, ip=None,
start='2016-01-01', end=datetime.date.today()):
session = self.Session()
try:
if dn:
result = session.query(Pdns_records).filter(
Pdns_records.query.like('%{}%'.format(dn)),
Pdns_records.first_seen >= start,
Pdns_records.last_seen <= '{} 23:59:59'.format(end))
elif ip:
result = session.query(Pdns_records).filter(
Pdns_records.answer.like('%P{%'.format(ip)),
Pdns_records.first_seen >= start,
Pdns_records.last_seen <= '{} 23:59:59'.format(end))
return result
except SQLAlchemyError as e:
logging.info((str(e)))
finally:
session.close()
评论列表
文章目录