CMS 3D CMS Logo

 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Pages
List of all members | Public Member Functions | Public Attributes | Static Public Attributes
results_db.ResultsDB Class Reference

Public Member Functions

def __init__
 
def addResultLog
 
def checkResult
 
def create
 
def deleteResultSteps
 
def deleteRun
 
def drop
 
def getDate
 
def getNewResId
 
def getNewRunId
 
def read
 
def readResults
 
def readRun
 
def readSelection
 
def writeResult
 
def writeStepResult
 

Public Attributes

 conn
 

Static Public Attributes

tuple curs = self.conn.cursor()
 
 foundRun = False
 
tuple id = self.getNewResId()
 
tuple innercur = self.conn.cursor()
 
string isqlstr = "SELECT STATUS FROM RUN_STEP_RESULT WHERE ID= :ids"
 
 putAnd = False
 
string sqlstr = "CREATE TABLE RUN_HEADER (RID NUMBER, RDATE DATE, LABEL VARCHAR2(20), "
 

Detailed Description

Definition at line 29 of file results_db.py.

Constructor & Destructor Documentation

def results_db.ResultsDB.__init__ (   self,
  connect 
)

Definition at line 30 of file results_db.py.

30 
31  def __init__(self, connect):
32  self.conn = connect

Member Function Documentation

def results_db.ResultsDB.addResultLog (   self,
  runID,
  logStr 
)

Definition at line 195 of file results_db.py.

def addResultLog(self, runID, logStr):
def results_db.ResultsDB.checkResult (   self,
  runID 
)

Definition at line 202 of file results_db.py.

203  def checkResult( self, runID ):
204  curs = self.conn.cursor()
sqlstr = "SELECT ID FROM RUN_RESULT WHERE RID=:rid"
def results_db.ResultsDB.create (   self)

Definition at line 33 of file results_db.py.

33 
def create( self ):
def results_db.ResultsDB.deleteResultSteps (   self,
  id 
)

Definition at line 159 of file results_db.py.

Referenced by results_db.ResultsDB.deleteRun().

160  def deleteResultSteps( self, id ):
161  curs = self.conn.cursor()
162  sqlstr = "DELETE FROM RUN_STEP_RESULT WHERE ID=:ids"
163  curs.prepare(sqlstr)
164  curs.execute(sqlstr, ids=id)
def results_db.ResultsDB.deleteRun (   self,
  rid 
)

Definition at line 144 of file results_db.py.

References results_db.ResultsDB.deleteResultSteps().

145  def deleteRun( self,rid ):
146  curs = self.conn.cursor()
sqlstr = "SELECT ID FROM RUN_RESULT WHERE RID = :rids"
def results_db.ResultsDB.drop (   self)

Definition at line 56 of file results_db.py.

56 
def drop( self ):
def results_db.ResultsDB.getDate (   self)

Definition at line 233 of file results_db.py.

Referenced by cmsPerfSuite.PerfSuite.printDate(), and cmsPerfSuite.PerfSuite.runCmdSet().

def getDate( self ):
def results_db.ResultsDB.getNewResId (   self)

Definition at line 217 of file results_db.py.

218  def getNewResId( self ):
219  curs = self.conn.cursor()
220  sqlstr = "SELECT RES_ID_SEQ.NextVal FROM DUAL"
221  curs.prepare(sqlstr)
222  curs.execute(sqlstr)
223  for row in curs:
224  return row[0]
def results_db.ResultsDB.getNewRunId (   self)

Definition at line 225 of file results_db.py.

226  def getNewRunId( self ):
227  curs = self.conn.cursor()
228  sqlstr = "SELECT RUN_ID_SEQ.NextVal FROM DUAL"
229  curs.prepare(sqlstr)
230  curs.execute(sqlstr)
231  for row in curs:
232  return row[0]
def results_db.ResultsDB.read (   self)

Definition at line 73 of file results_db.py.

References results_db.printRun(), and results_db.ResultsDB.readRun().

Referenced by Vispa.Plugins.EdmBrowser.EdmDataAccessor.EdmDataAccessor.goto(), and Vispa.Plugins.EdmBrowser.EdmDataAccessor.EdmDataAccessor.setFilterBranches().

73 
def read( self ):
def results_db.ResultsDB.readResults (   self,
  id 
)

Definition at line 93 of file results_db.py.

References results_db.printStepResult().

Referenced by results_db.ResultsDB.readRun().

93 
def readResults(self, id):
def results_db.ResultsDB.readRun (   self,
  rid 
)

Definition at line 83 of file results_db.py.

References results_db.printResult(), and results_db.ResultsDB.readResults().

Referenced by results_db.ResultsDB.read().

83 
def readRun( self, rid ):
def results_db.ResultsDB.readSelection (   self,
  runId,
  label,
  trel,
  tarch,
  full 
)

Definition at line 102 of file results_db.py.

def readSelection( self, runId, label, trel, tarch, full ):
def results_db.ResultsDB.writeResult (   self,
  runID,
  timeStamp,
  match,
  resTags 
)

Definition at line 165 of file results_db.py.

def writeResult(self, runID, timeStamp, match, resTags):
def results_db.ResultsDB.writeStepResult (   self,
  id,
  step_label,
  status 
)

Definition at line 187 of file results_db.py.

def writeStepResult(self, id, step_label, status):

Member Data Documentation

results_db.ResultsDB.conn

Definition at line 31 of file results_db.py.

tuple results_db.ResultsDB.curs = self.conn.cursor()
static

Definition at line 34 of file results_db.py.

results_db.ResultsDB.foundRun = False
static

Definition at line 170 of file results_db.py.

tuple results_db.ResultsDB.id = self.getNewResId()
static

Definition at line 177 of file results_db.py.

Referenced by NodeCut.MatchId.match().

tuple results_db.ResultsDB.innercur = self.conn.cursor()
static

Definition at line 208 of file results_db.py.

string results_db.ResultsDB.isqlstr = "SELECT STATUS FROM RUN_STEP_RESULT WHERE ID= :ids"
static

Definition at line 209 of file results_db.py.

results_db.ResultsDB.putAnd = False
static

Definition at line 106 of file results_db.py.

string results_db.ResultsDB.sqlstr = "CREATE TABLE RUN_HEADER (RID NUMBER, RDATE DATE, LABEL VARCHAR2(20), "
static

Definition at line 35 of file results_db.py.