def insert(self, id, url, verified, online, ip_str, submitted_td,
verified_td):
self.id = int(id)
self.url = str(url).strip()
self.verified = verified
self.online = online
self.submitted_td = submitted_td
if ip_str != None:
self.ip = ip2int(ip_str)
if verified_td != None:
self.verified_td = verified_td
self.tdstamp = datetime.utcnow()
try:
db_session.flush()
db_session.merge(self)
db_session.commit()
except AttributeError:
# traceback.print_exc(file=sys.stderr)
meh = "meh"
except:
traceback.print_exc(file=sys.stderr)
def insert(self, str_start, str_end):
self.start = ip2int(str_start)
self.end = ip2int(str_end)
self.tdstamp = datetime.utcnow()
try:
db_session.flush()
db_session.merge(self)
db_session.commit()
except AttributeError:
#traceback.print_exc(file=sys.stderr)
meh = "meh"
except:
traceback.print_exc(file=sys.stderr)
def isET(self, ip_str):
target_ip = ip2int(ip_str)
result = etModel.query.filter(target_ip >= etModel.start).filter(
target_ip <= et.end).first()
if result:
return True
return False
def __init__(self,
ip=None,
domain=None,
url=None,
date=None,
reverseLookup=None,
description=None,
registrant=None):
self.url = url
if ip != None:
self.ip = ip2int(ip)
def insert(self,
ip_str,
domain,
reverseLookup=None,
date=None,
registrant=None,
description=None,
url=None):
self.ip = ip2int(ip_str)
# MDL usually provides a URL without "http://" and calls it "domain"; we separate
if url == None:
self.url = "http://" + domain
urlResults = urlparse(self.url)
self.domain = urlResults[1]
# if I passed the URL argument I'm going to assume I preprocessed
else:
self.url = url
self.domain = domain
# their date is weird
date = str(date).replace("_", " ")
self.date = date
self.registrant = registrant
self.reverseLookup = reverseLookup
try:
db_session.flush()
db_session.merge(self)
db_session.commit()
except AttributeError:
# traceback.print_exc(file=sys.stderr)
meh = "meh"
except:
traceback.print_exc(file=sys.stderr)
def isKnown(self, str_ip):
ip = ip2int(str_ip)
result = self.query.filter_by(ip=ip).first()
return result != None