DBUtils

Class that collects utilities used in Accounting and Monitoring systems

class DIRAC.AccountingSystem.private.DBUtils.DBUtils(db, setup)

Bases: object

__init__(db, setup)

getKeyValues(typeName, condDict)

Get all valid key values in a type

stripDataField(dataDict, fieldId)

Strip <fieldId> data and sum the rest as it was data from one key

Parameters:

• dataDict (dict) –

  dictionary of the form:

  { 'key' : { <timeEpoch1>: [1, 2, 3],
              <timeEpoch2>: [3, 4, 5].. } }
  

  The dataDict is modified in this function and the return structure is:

  dataDict : { 'key' : { <timeEpoch1>: 1,
                         <timeEpoch2>: 3.. } }
  

• fieldId (int)

Returns:

list of dictionaries

[ { <timeEpoch1>: 2, <timeEpoch2>: 4... }
  { <timeEpoch1>: 3, <timeEpoch2>): 5... } ]

Return type:

list