def run(self):
if(self.loggerFlag):
logger = logging.getLogger(type(self).__name__)
logger.info("Starting %s thread." % (self.getName()))
try:
processData = True
config = ConfigParser.RawConfigParser()
configFile = open(self.configFilename, 'r')
config.readfp(configFile)
dbUser = config.get('Database', 'user')
dbPwd = config.get('Database', 'password')
dbHost = config.get('Database', 'host')
dbName = config.get('Database', 'name')
dbConnType = config.get('Database', 'connectionstring')
configFile.close()
db = xeniaAlchemy()
if(db.connectDB(dbConnType, dbUser, dbPwd, dbHost, dbName, False) == True):
if(logger):
logger.info("Succesfully connect to DB: %s at %s" %(dbName,dbHost))
else:
logger.error("Unable to connect to DB: %s at %s. Terminating script." %(dbName,dbHost))
processData = False
#sys.exit(-1)
except ConfigParser.Error, e:
if(logger):
logger.exception(e)
class platformInventory:
def __init__(self, organizationID, configurationFile, logger=True):
self.organizationID = organizationID
self.configurationFile = configurationFile
self.logger = None
if(logger):
self.logger = logging.getLogger(type(self).__name__)
def connectDB(self):
try:
config = ConfigParser.RawConfigParser()
config.read(self.configurationFile)
dbUser = config.get('Database', 'user')
dbPwd = config.get('Database', 'password')
dbHost = config.get('Database', 'host')
dbName = config.get('Database', 'name')
dbConnType = config.get('Database', 'connectionstring')
except ConfigParser.Error, e:
if(self.logger):
self.logger.exception(e)
return(False)
try:
self.db = xeniaAlchemy(self.logger)
if(self.db.connectDB(dbConnType, dbUser, dbPwd, dbHost, dbName, False) == True):
if(self.logger):
self.logger.info("Succesfully connect to DB: %s at %s" %(dbName,dbHost))
return(True)
else:
self.logger.error("Unable to connect to DB: %s at %s." %(dbName,dbHost))
except Exception,e:
self.logger.exception(e)
dest="dbPwd",
help="The xenia database password name to connect with.")
parser.add_option("-f", "--ResultsFile", dest="resultsFile", help="")
(options, args) = parser.parse_args()
try:
outFile = open(options.resultsFile, "w")
inventory = assetInventory(baseUrl=options.baseUrl)
directoryObjs = inventory.getDirectory()
if (directoryObjs == None):
print("Did not receive a valid directory object, cannot continue.")
sys.exit(-1)
db = xeniaAlchemy()
if (db.connectDB("postgresql+psycopg2", options.dbUser, options.dbPwd,
options.dbHost, options.dbName, False) != True):
print("Unable to connect to database. Host: %s DBName: %s" %
(options.dbHost, options.dbName))
sys.exit(-1)
#First pass to log out platforms that aren't in our database.
outFile.write("Platforms not in database.\n\n")
for mooring in directoryObjs:
if (len(mooring['regionalId']) == 0):
type = inventory.getPlatformType(mooring['urlId'])
if (type == None):
type = ""
status = inventory.getPlatformStatus(mooring['urlId'])
if (status == None):
help="The xenia database password name to connect with." )
parser.add_option("-f", "--ResultsFile", dest="resultsFile",
help="" )
(options, args) = parser.parse_args()
try:
outFile = open(options.resultsFile, "w")
inventory = assetInventory(baseUrl=options.baseUrl)
directoryObjs = inventory.getDirectory()
if(directoryObjs == None):
print("Did not receive a valid directory object, cannot continue.")
sys.exit(-1)
db = xeniaAlchemy()
if(db.connectDB("postgresql+psycopg2", options.dbUser, options.dbPwd, options.dbHost, options.dbName, False) != True):
print("Unable to connect to database. Host: %s DBName: %s" %(options.dbHost, options.dbName))
sys.exit(-1)
#First pass to log out platforms that aren't in our database.
outFile.write("Platforms not in database.\n\n")
for mooring in directoryObjs:
if(len(mooring['regionalId']) == 0):
type = inventory.getPlatformType(mooring['urlId'])
if(type == None):
type = ""
status = inventory.getPlatformStatus(mooring['urlId'])
if(status == None):
status = ""
responsible = inventory.getResponsibleMember(mooring['urlId'])
dbUser = self.config.get('Database', 'user')
dbPwd = self.config.get('Database', 'password')
dbHost = self.config.get('Database', 'host')
dbName = self.config.get('Database', 'name')
dbConnType = self.config.get('Database', 'connectionstring')
except ConfigParser.Error, e:
if(self.logger):
self.logger.exception(e)
except Exception,e:
if(self.logger):
self.logger.exception(e)
else:
try:
#Attempt to connect to the xenia database
self.xeniaDb = xeniaAlchemy(self.logger)
if(self.xeniaDb.connectDB(dbConnType, dbUser, dbPwd, dbHost, dbName, False) == True):
if(self.logger):
self.logger.info("Succesfully connect to DB: %s at %s" %(dbName,dbHost))
return(True)
else:
if(self.logger):
self.logger.info("Unable to connect to DB: %s at %s" %(dbName,dbHost))
return(False)
except Exception,e:
if(self.logger):
self.logger.exception(e)
return(False)
def disconnect(self):
try:
