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: