def __init__(self, db_path, *args, **kwargs):
self.db = db_path
self.conn = pysql_connect( self.db )
return
def execute_sql (query, fd):
try:
fd.execute(query)
except DatabaseError, de:
print ("Database Error : %s" % de)
except ProgrammingError, pe:
print ("Programming Error : %s" % pe)
except SQLError, e:
print ("SQL Generic Error: %s" % e)
except Exception, e:
print ("Exception: %s" % e)
with pysql_connect(self.filename) as sql_ctx:
req = "CREATE TABLE IF NOT EXISTS {0}(".format(self.table_name)
req += "ip VARCHAR, "
req += "port INTEGER, "
req += "protocol VARCHAR, "
req += "banner VARCHAR, "
req += "os VARCHAR)"
execute_sql(req, sql_ctx)
idx = 0
if self.verbose:
self.logger.info("Table %s created in '%s'" % (self.table_name, self.filename))
for h in self.nmap_results.hosts :
for p in h.ports:
