def testDatabase(self):
gComponentInstaller.setMySQLPasswords(self.rootPwd, self.diracPwd)
# Install database
self.client.do_install('db FTS3DB')
# Check installation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()['Value']
self.assertTrue(cfg.isSection('Systems/DataManagement/' + self.frameworkSetup + '/Databases/FTS3DB/'))
# Check in database
result = self.monitoringClient.getInstallations(
{'Instance': 'FTS3DB',
'UnInstallationTime': None,
'InstalledBy': self.user},
{'DIRACSystem': 'DataManagement',
'Type': 'DB',
'DIRACModule': 'FTS3DB'},
{},
False)
self.assertTrue(result['OK'] and len(result['Value']) == 1)
# Uninstall database
self.client.do_uninstall('db FTS3DB')
# Check uninstallation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()['Value']
self.assertTrue(not cfg.isSection('Systems/DataManagement/' + self.frameworkSetup + '/Databases/FTS3DB/'))
def testDatabase(self):
gComponentInstaller.setMySQLPasswords(self.rootPwd, self.diracPwd)
# Install database
self.client.do_install('db FTSDB')
# Check installation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()['Value']
self.assertTrue(cfg.isSection('Systems/DataManagement/' + self.frameworkSetup + '/Databases/FTSDB/'))
# Check in database
result = self.monitoringClient.getInstallations({'Instance': 'FTSDB',
'UnInstallationTime': None, 'InstalledBy': self.user},
{'System': 'DataManagement', 'Type': 'DB', 'Module': 'FTSDB'},
{}, False)
self.assertTrue(result['OK'] and len(result['Value']) == 1)
# Uninstall database
self.client.do_uninstall('db FTSDB')
# Check uninstallation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()['Value']
self.assertTrue(not cfg.isSection('Systems/DataManagement/' + self.frameworkSetup + '/Databases/FTSDB/'))
def testDatabase(self):
gComponentInstaller.setMySQLPasswords(self.rootPwd, self.diracPwd)
# Install database
self.client.do_install("db FTS3DB")
# Check installation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()["Value"]
self.assertTrue(cfg.isSection("Systems/DataManagement/" + self.frameworkSetup + "/Databases/FTS3DB/"))
# Check in database
result = self.monitoringClient.getInstallations(
{"Instance": "FTS3DB", "UnInstallationTime": None, "InstalledBy": self.user},
{"DIRACSystem": "DataManagement", "Type": "DB", "DIRACModule": "FTS3DB"},
{},
False,
)
self.assertTrue(result["OK"] and len(result["Value"]) == 1)
# Uninstall database
self.client.do_uninstall("db FTS3DB")
# Check uninstallation in CS
self.csClient.downloadCSData()
cfg = self.csClient.getCurrentCFG()["Value"]
self.assertTrue(not cfg.isSection("Systems/DataManagement/" + self.frameworkSetup + "/Databases/FTS3DB/"))
def export_installMySQL( self, mysqlPassword = None, diracPassword = None ):
""" Install MySQL database server
"""
if mysqlPassword or diracPassword:
gComponentInstaller.setMySQLPasswords( mysqlPassword, diracPassword )
if gComponentInstaller.mysqlInstalled()['OK']:
return S_OK( 'Already installed' )
result = gComponentInstaller.installMySQL()
if not result['OK']:
return result
return S_OK( 'Successfully installed' )
def export_uninstallDatabase(self, dbName, mysqlPassword=None):
""" Uninstall a DIRAC database named dbName
"""
if mysqlPassword:
gComponentInstaller.setMySQLPasswords(mysqlPassword)
return gComponentInstaller.uninstallDatabase(gConfig, dbName)
def export_getDatabases(self, mysqlPassword=None):
""" Get the list of installed databases
"""
if mysqlPassword:
gComponentInstaller.setMySQLPasswords(mysqlPassword)
return gComponentInstaller.getDatabases()
def export_uninstallDatabase( self, dbName, mysqlPassword = None ):
""" Uninstall a DIRAC database named dbName
"""
if mysqlPassword :
gComponentInstaller.setMySQLPasswords( mysqlPassword )
return gComponentInstaller.uninstallDatabase( gConfig, dbName )
def export_getDatabases( self, mysqlPassword = None ):
""" Get the list of installed databases
"""
if mysqlPassword :
gComponentInstaller.setMySQLPasswords( mysqlPassword )
return gComponentInstaller.getDatabases()
