def getFTSHistory( self ):
""" get FTS history snapshot """
getFTSHistory = self.ftsManager().getFTSHistory()
if not getFTSHistory["OK"]:
self.log.error( getFTSHistory["Message"] )
return getFTSHistory
getFTSHistory = getFTSHistory["Value"]
return S_OK( [ FTSHistoryView( ftsHistory ) for ftsHistory in getFTSHistory ] )
def getFTSHistory( self ):
""" get FTS history snapshot """
getFTSHistory = self.ftsManager.getFTSHistory()
if not getFTSHistory['OK']:
self.log.error( 'Failed to get FTS history', getFTSHistory['Message'] )
return getFTSHistory
getFTSHistory = getFTSHistory['Value']
return S_OK( [ FTSHistoryView( ftsHistory ) for ftsHistory in getFTSHistory ] )
def getFTSHistory(self):
""" query FTSHistoryView, return list of FTSHistoryViews """
query = self._transaction(["SELECT * FROM `FTSHistoryView`;"])
if not query['OK']:
return query
if not query['Value']:
return S_OK()
return S_OK([
FTSHistoryView(fromDict) for fromDict in query['Value'].values()[0]
])
def setUp(self):
""" test set up """
self.ftsHistoryViews = [
FTSHistoryView({
"TargetSE": "RAL-USER",
"SourceSE": "CERN-USER",
"FTSJobs": 10,
"FTSServer":
"https://fts22-t0-export.cern.ch:8443/glite-data-transfer-fts/services/FileTransfer",
"Status": "Active",
"Files": 1000,
"Size": 10000000
})
]
def getViewMeta():
""" return db views in dict format
at the moment only one view - FTSHistoryView
"""
return {'FTSHistoryView': FTSHistoryView.viewDesc()}
def _getFTSHistoryProperties(self, columnNames=None):
""" select :columnNames: from FTSHistory view """
columnNames = columnNames if columnNames else FTSHistoryView.viewDesc(
)["Fields"].keys()
return "SELECT %s FROM `FTSHistoryView`;" % ",".join(columnNames)
def getViewMeta():
""" return db views in dict format
at the moment only one view - FTSHistoryView
"""
return { 'FTSHistoryView': FTSHistoryView.viewDesc() }
def _getFTSHistoryProperties( self, columnNames = None ): """ select :columnNames: from FTSHistory view """ columnNames = columnNames if columnNames else FTSHistoryView.viewDesc()["Fields"].keys() return "SELECT %s FROM `FTSHistoryView`;" % ",".join( columnNames )
