web_results_display::WebResultsDisplay Class Reference

List of all members.

Public Member Functions
def	__init__
def	labels
def	readLogStatus
def	releasesHeaders
def	resultHeaders
def	runResults
def	stepResults
Public Attributes
	conn

---

Detailed Description

Definition at line 43 of file web_results_display.py.

---

Constructor & Destructor Documentation

def web_results_display::WebResultsDisplay::__init__	(		self,
			connect
	)

Definition at line 44 of file web_results_display.py.

00045                                :
00046         self.conn = connect
            

---

Member Function Documentation

def web_results_display::WebResultsDisplay::labels

(

self

)

Definition at line 56 of file web_results_display.py.

                      :
        curs = self.conn.cursor()
        sqlstr = "SELECT DISTINCT LABEL FROM RUN_HEADER"
        curs.prepare(sqlstr)
        curs.execute(sqlstr)
        return curs

def web_results_display::WebResultsDisplay::readLogStatus	(		self,
			label,
			runID
	)

Definition at line 97 of file web_results_display.py.

                                          :
        curs = self.conn.cursor()
        sqlstr = "SELECT LOG FROM RUN_HEADER WHERE RID = :rid"
        curs.prepare(sqlstr)
        curs.execute(sqlstr, rid = runID)
        for row in curs:
                return row[0].read()

def web_results_display::WebResultsDisplay::releasesHeaders	(		self,
			label,
			release = "",
			arch = ""
	)

Definition at line 80 of file web_results_display.py.

00081                                                           :
00082         curs = self.conn.cursor()
00083         if(release != "" and arch != ""):
00084                 sqlstr = "SELECT RID, TO_CHAR(RDATE, 'DD.MM.YYYY HH24:MI:SS'), LABEL, T_RELEASE, T_ARCH FROM RUN_HEADER WHERE T_RELEASE = :rel AND T_ARCH = :arc AND LABEL = :labl ORDER BY RID DESC"
00085                 curs.prepare(sqlstr)
00086                 curs.execute(sqlstr, rel=release, arc=arch, labl=label)
00087         elif(release != ""):
00088                 sqlstr = "SELECT RID, TO_CHAR(RDATE, 'DD.MM.YYYY HH24:MI:SS'), LABEL, T_RELEASE, T_ARCH FROM RUN_HEADER WHERE T_RELEASE = :rel AND LABEL = :labl ORDER BY RID DESC"
00089                 curs.prepare(sqlstr)
00090                 curs.execute(sqlstr, rel=release, labl=label)
00091         elif(arch != ""):
00092                 sqlstr = "SELECT RID, TO_CHAR(RDATE, 'DD.MM.YYYY HH24:MI:SS'), LABEL, T_RELEASE, T_ARCH FROM RUN_HEADER WHERE T_ARCH = :arc AND LABEL = :labl ORDER BY RID DESC"
00093                 curs.prepare(sqlstr)
00094                 curs.execute(sqlstr, arc=arch, labl=label)
00095         result = curs.fetchall()
00096         return result
    

def web_results_display::WebResultsDisplay::resultHeaders	(		self,
			label
	)

Definition at line 47 of file web_results_display.py.

00048                                   :
00049         curs = self.conn.cursor()
00050         sqlstr = "SELECT RID, TO_CHAR(RDATE, 'DD.MM.YYYY HH24:MI:SS'), LABEL, T_RELEASE, T_ARCH "
00051         sqlstr +="FROM RUN_HEADER WHERE LABEL = :labl ORDER BY RID DESC"
00052         curs.prepare(sqlstr)
00053         curs.execute(sqlstr, labl = label)
00054         result = curs.fetchall()
00055         return result
                

def web_results_display::WebResultsDisplay::runResults	(		self,
			rid
	)

Definition at line 63 of file web_results_display.py.

00064                                :
00065         curs = self.conn.cursor()
00066         sqlstr = "SELECT ID, R_RELEASE, R_ARCH FROM RUN_RESULT WHERE RID = :ids ORDER BY R_RELEASE" 
00067         curs.prepare(sqlstr)
00068         curs.execute(sqlstr, ids=rid)
00069         result = curs.fetchall()
00070         return result
        

def web_results_display::WebResultsDisplay::stepResults	(		self,
			id
	)

Definition at line 71 of file web_results_display.py.

00072                                :
00073         curs = self.conn.cursor()
00074         sqlstr = "SELECT ID, STATUS, STEP_LABEL FROM RUN_STEP_RESULT WHERE ID= :ids"
00075         curs.prepare(sqlstr)
00076         curs.execute(sqlstr, ids=id)
00077         result = curs.fetchall()
00078         count = len(result)
00079         return result, count
    

---

Member Data Documentation

web_results_display::WebResultsDisplay::conn

Definition at line 44 of file web_results_display.py.