def __initializeConnection(self, dbPath):
"""
Collects from the CS all the info needed to connect to the DB.
This should be in a base class eventually
"""
result = getDBParameters(dbPath)
if not result['OK']:
raise Exception('Cannot get database parameters: %s' %
result['Message'])
dbParameters = result['Value']
self.log.debug("db parameters: %s" % dbParameters)
self.host = dbParameters['Host']
self.port = dbParameters['Port']
self.user = dbParameters['User']
self.password = dbParameters['Password']
self.dbName = dbParameters['DBName']
self.engine = create_engine(
'mysql://%s:%s@%s:%s/%s' %
(self.user, self.password, self.host, self.port, self.dbName),
pool_recycle=3600,
echo_pool=True,
echo=self.log.getLevel() == 'DEBUG')
self.sessionMaker_o = sessionmaker(bind=self.engine)
self.inspector = Inspector.from_engine(self.engine)
def __init__(self, dbname, fullname, debug=False):
self.fullname = fullname
database_name = dbname
self.log = gLogger.getSubLogger(database_name)
result = getDBParameters(fullname)
if not result['OK']:
raise RuntimeError('Cannot get database parameters: %s' % result['Message'])
dbParameters = result['Value']
self.dbHost = dbParameters['Host']
self.dbPort = dbParameters['Port']
self.dbUser = dbParameters['User']
self.dbPass = dbParameters['Password']
self.dbName = dbParameters['DBName']
super(DB, self).__init__(hostName=self.dbHost,
userName=self.dbUser,
passwd=self.dbPass,
dbName=self.dbName,
port=self.dbPort,
debug=debug)
if not self._connected:
raise RuntimeError("Can not connect to DB '%s', exiting..." % self.dbName)
self.log.info("===================== MySQL ======================")
self.log.info("User: "******"Host: " + self.dbHost)
self.log.info("Port: " + str(self.dbPort))
#self.log.info("Password: "******"DBName: " + self.dbName)
self.log.info("==================================================")
def __init__( self, dbname, fullname, debug = False ):
self.fullname = fullname
database_name = dbname
self.log = gLogger.getSubLogger( database_name )
result = getDBParameters( fullname )
if not result['OK'] :
raise RuntimeError( 'Cannot get database parameters: %s' % result['Message'] )
dbParameters = result[ 'Value' ]
self.dbHost = dbParameters[ 'Host' ]
self.dbPort = dbParameters[ 'Port' ]
self.dbUser = dbParameters[ 'User' ]
self.dbPass = dbParameters[ 'Password' ]
self.dbName = dbParameters[ 'DBName' ]
MySQL.__init__( self, self.dbHost, self.dbUser, self.dbPass,
self.dbName, self.dbPort, debug = debug )
if not self._connected:
raise RuntimeError( 'Can not connect to DB %s, exiting...' % self.dbName )
self.log.info( "==================================================" )
#self.log.info("SystemInstance: "+self.system)
self.log.info( "User: "******"Host: " + self.dbHost )
self.log.info( "Port: " + str( self.dbPort ) )
#self.log.info("Password: "******"DBName: " + self.dbName )
self.log.info( "==================================================" )
def __init__(self, dbname, fullname, debug=False):
self.fullname = fullname
database_name = dbname
self.log = gLogger.getSubLogger(database_name)
result = getDBParameters(fullname)
if not result['OK']:
raise RuntimeError('Cannot get database parameters: %s' % result['Message'])
dbParameters = result['Value']
self.dbHost = dbParameters['Host']
self.dbPort = dbParameters['Port']
self.dbUser = dbParameters['User']
self.dbPass = dbParameters['Password']
self.dbName = dbParameters['DBName']
super(DB, self).__init__(hostName=self.dbHost,
userName=self.dbUser,
passwd=self.dbPass,
dbName=self.dbName,
port=self.dbPort,
debug=debug)
if not self._connected:
raise RuntimeError("Can not connect to DB '%s', exiting..." % self.dbName)
self.log.info("==================================================")
self.log.info("User: "******"Host: " + self.dbHost)
self.log.info("Port: " + str(self.dbPort))
#self.log.info("Password: "******"DBName: " + self.dbName)
self.log.info("==================================================")
def __initializeConnection( self, dbPath ):
"""
Collects from the CS all the info needed to connect to the DB.
This should be in a base class eventually
"""
result = getDBParameters( dbPath )
if not result[ 'OK' ]:
raise Exception( 'Cannot get database parameters: %s' % result['Message'] )
dbParameters = result[ 'Value' ]
self.log.debug("db parameters: %s" % dbParameters)
self.host = dbParameters[ 'Host' ]
self.port = dbParameters[ 'Port' ]
self.user = dbParameters[ 'User' ]
self.password = dbParameters[ 'Password' ]
self.dbName = dbParameters[ 'DBName' ]
self.engine = create_engine( 'mysql://%s:%s@%s:%s/%s' % ( self.user,
self.password,
self.host,
self.port,
self.dbName ),
pool_recycle = 3600,
echo_pool = True,
echo = self.log.getLevel() == 'DEBUG')
self.sessionMaker_o = sessionmaker( bind = self.engine )
self.inspector = Inspector.from_engine( self.engine )
def _initializeConnection(self, dbPath):
"""
Collect from the CS all the info needed to connect to the DB.
"""
result = getDBParameters(dbPath)
if not result["OK"]:
raise Exception("Cannot get database parameters: %s" %
result["Message"])
dbParameters = result["Value"]
self.log.debug("db parameters: %s" % dbParameters)
self.host = dbParameters["Host"]
self.port = dbParameters["Port"]
self.user = dbParameters["User"]
self.password = dbParameters["Password"]
self.dbName = dbParameters["DBName"]
self.engine = create_engine(
"mysql://%s:%s@%s:%s/%s" %
(self.user, self.password, self.host, self.port, self.dbName),
pool_recycle=3600,
echo_pool=True,
echo=self.log.getLevel() == "DEBUG",
)
self.sessionMaker_o = sessionmaker(bind=self.engine)
self.inspector = Inspector.from_engine(self.engine)
def __init__(self):
self.log = gLogger.getSubLogger('PilotsLoggingDB')
result = getDBParameters('WorkloadManagement/PilotsLoggingDB')
if not result['OK']:
raise RuntimeError('Cannot get database parameters: %s' %
result['Message'])
dbParameters = result['Value']
self.dbHost = dbParameters['Host']
self.dbPort = dbParameters['Port']
self.dbUser = dbParameters['User']
self.dbPass = dbParameters['Password']
self.dbName = dbParameters['DBName']
# These are the list of tables that will be created.
# They can be extended in an extension module
self.tablesList = getattr(
Utils.voimport(
'DIRAC.WorkloadManagementSystem.DB.PilotsLoggingDB'),
'TABLESLIST')
self.__initializeConnection()
resp = self.__initializeDB()
if not resp['OK']:
raise Exception("Couldn't create tables: " + resp['Message'])
def __init__(self, parentLogger=None):
if not parentLogger:
parentLogger = gLogger
self.log = parentLogger.getSubLogger(self.__class__.__name__)
result = getDBParameters("WorkloadManagement/PilotsLoggingDB")
if not result["OK"]:
raise RuntimeError("Cannot get database parameters: %s" % result["Message"])
dbParameters = result["Value"]
self.dbHost = dbParameters["Host"]
self.dbPort = dbParameters["Port"]
self.dbUser = dbParameters["User"]
self.dbPass = dbParameters["Password"]
self.dbName = dbParameters["DBName"]
# These are the list of tables that will be created.
# They can be extended in an extension module
self.tablesList = getattr(Utils.voimport("DIRAC.WorkloadManagementSystem.DB.PilotsLoggingDB"), "TABLESLIST")
self.__initializeConnection()
resp = self.__initializeDB()
if not resp["OK"]:
raise Exception("Couldn't create tables: " + resp["Message"])
def __getDBConnectionInfo(self, fullname):
""" Collect from the CS all the info needed to connect to the DB.
This should be in a base class eventually
"""
result = getDBParameters(fullname)
if not result['OK']:
raise Exception('Cannot get database parameters: %s' % result['Message'])
dbParameters = result['Value']
self.dbHost = dbParameters['Host']
self.dbPort = dbParameters['Port']
self.dbUser = dbParameters['User']
self.dbPass = dbParameters['Password']
self.dbName = dbParameters['DBName']
def __getDBConnectionInfo( self, fullname ):
""" Collect from the CS all the info needed to connect to the DB.
This should be in a base class eventually
"""
result = getDBParameters( fullname )
if not result[ 'OK' ]:
raise Exception( 'Cannot get database parameters: %s' % result[ 'Message' ] )
dbParameters = result[ 'Value' ]
self.dbHost = dbParameters[ 'Host' ]
self.dbPort = dbParameters[ 'Port' ]
self.dbUser = dbParameters[ 'User' ]
self.dbPass = dbParameters[ 'Password' ]
self.dbName = dbParameters[ 'DBName' ]
def __getDBConnectionInfo(self, fullname):
"""Collect from the CS all the info needed to connect to the DB.
This should be in a base class eventually
"""
result = getDBParameters(fullname)
if not result["OK"]:
raise Exception("Cannot get database parameters: %s" %
result["Message"])
dbParameters = result["Value"]
self.dbHost = dbParameters["Host"]
self.dbPort = dbParameters["Port"]
self.dbUser = dbParameters["User"]
self.dbPass = dbParameters["Password"]
self.dbName = dbParameters["DBName"]
def __initializeConnection( self, dbPath ):
result = getDBParameters( dbPath )
if not result[ 'OK' ]:
raise Exception( 'Cannot get database parameters: %s' % result['Message'] )
dbParameters = result[ 'Value' ]
self.host = dbParameters[ 'Host' ]
self.port = dbParameters[ 'Port' ]
self.user = dbParameters[ 'User' ]
self.password = dbParameters[ 'Password' ]
self.dbName = dbParameters[ 'DBName' ]
self.engine = create_engine( 'mysql://%s:%s@%s:%s/%s' % ( self.user, self.password, self.host, self.port, self.dbName ),
pool_recycle = 3600, echo_pool = True)
self.session = scoped_session( sessionmaker( bind = self.engine ) )
self.inspector = Inspector.from_engine( self.engine )
def __initializeConnection( self, dbPath ):
result = getDBParameters( dbPath )
if not result[ 'OK' ]:
raise Exception( 'Cannot get database parameters: %s' % result['Message'] )
dbParameters = result[ 'Value' ]
self.host = dbParameters[ 'Host' ]
self.port = dbParameters[ 'Port' ]
self.user = dbParameters[ 'User' ]
self.password = dbParameters[ 'Password' ]
self.dbName = dbParameters[ 'DBName' ]
self.engine = create_engine( 'mysql://%s:%s@%s:%s/%s' % ( self.user, self.password, self.host, self.port, self.dbName ),
pool_recycle = 3600, echo_pool = True)
self.session = scoped_session( sessionmaker( bind = self.engine ) )
self.inspector = Inspector.from_engine( self.engine )
def __initializeConnection(self, dbPath):
result = getDBParameters(dbPath)
if not result["OK"]:
raise Exception("Cannot get database parameters: %s" % result["Message"])
dbParameters = result["Value"]
self.host = dbParameters["Host"]
self.port = dbParameters["Port"]
self.user = dbParameters["User"]
self.password = dbParameters["Password"]
self.dbName = dbParameters["DBName"]
self.engine = create_engine(
"mysql://%s:%s@%s:%s/%s" % (self.user, self.password, self.host, self.port, self.dbName),
pool_recycle=3600,
echo_pool=True,
)
self.session = scoped_session(sessionmaker(bind=self.engine))
self.inspector = Inspector.from_engine(self.engine)
def __init__(self, dbname, fullname, debug=False, parentLogger=None):
self.fullname = fullname
result = getDBParameters(fullname)
if not result["OK"]:
raise RuntimeError("Cannot get database parameters: %s" %
result["Message"])
dbParameters = result["Value"]
self.dbHost = dbParameters["Host"]
self.dbPort = dbParameters["Port"]
self.dbUser = dbParameters["User"]
self.dbPass = dbParameters["Password"]
self.dbName = dbParameters["DBName"]
super(DB, self).__init__(
hostName=self.dbHost,
userName=self.dbUser,
passwd=self.dbPass,
dbName=self.dbName,
port=self.dbPort,
debug=debug,
parentLogger=parentLogger,
)
if not self._connected:
raise RuntimeError("Can not connect to DB '%s', exiting..." %
self.dbName)
self.log.info("===================== MySQL ======================")
self.log.info("User: "******"Host: " + self.dbHost)
self.log.info("Port: " + str(self.dbPort))
# self.log.info("Password: "******"DBName: " + self.dbName)
self.log.info("==================================================")
def __init__( self ):
self.log = gLogger.getSubLogger( 'PilotsLoggingDB' )
result = getDBParameters( 'WorkloadManagement/PilotsLoggingDB' )
if not result['OK']:
raise RuntimeError( 'Cannot get database parameters: %s' % result['Message'] )
dbParameters = result['Value']
self.dbHost = dbParameters['Host']
self.dbPort = dbParameters['Port']
self.dbUser = dbParameters['User']
self.dbPass = dbParameters['Password']
self.dbName = dbParameters['DBName']
#These are the list of tables that will be created.
#They can be extended in an extension module
self.tablesList = getattr(Utils.voimport( 'DIRAC.WorkloadManagementSystem.DB.PilotsLoggingDB' ),
'TABLESLIST')
self.__initializeConnection()
resp = self.__initializeDB( )
if not resp['OK']:
raise Exception( "Couldn't create tables: " + resp['Message'] )