| Revision: | 1.3 |
| Committed: | Tue Mar 27 12:55:06 2012 UTC (13 years, 1 month ago) by grchrist |
| Content type: | text/x-python |
| Branch: | MAIN |
| CVS Tags: | V00-02-06, V00-02-05, V00-02-04, V00-02-03, V00-02-01, V00-01-10, V-00-01-10, V00-01-09, V00-01-08, V00-01-07, V00-01-06, V00-01-05, V00-01-04, V00-01-03, V00-01-02, V00-01-01, V00-00-34, V00-00-33, MenuAnalyzer_V00-00-02, MenuAnalyzer_V00-00-01, MenuAnalyzer_V1, V00-00-32, V00-00-31, V00-00-30, V00-00-29, V00-00-28, V00-00-27, V00-00-26, V00-00-24, V00-00-23, V00-00-22, V00-00-21, HEAD |
| Changes since 1.2: | +1 -1 lines |
| Log Message: | again comparing triggers by version, get latest run now passes when can't find runs. Print LS with bad predictions |
| # | Content |
|---|---|
| 1 | import cx_Oracle |
| 2 | import sys |
| 3 | import os |
| 4 | |
| 5 | def GetLatestRunNumberList(minRunNumber): |
| 6 | cmd='cat ~centraltspro/secure/cms_trg_r.txt' |
| 7 | line=os.popen(cmd).readlines() |
| 8 | magic = line[0].rstrip("\n\r") |
| 9 | connect= 'cms_trg_r/' + magic + '@cms_omds_lb' |
| 10 | # connect to the DB |
| 11 | orcl = cx_Oracle.connect(connect) |
| 12 | curs = orcl.cursor() |
| 13 | RunNoQuery=""" |
| 14 | SELECT A.RUNNUMBER FROM CMS_RUNINFO.RUNNUMBERTBL A, CMS_WBM.RUNSUMMARY B WHERE A.RUNNUMBER=B.RUNNUMBER AND B.TRIGGERS>0 AND B.RUNNUMBER>=%d |
| 15 | """ % minRunNumber |
| 16 | curs.execute(RunNoQuery) |
| 17 | |
| 18 | runs=[] |
| 19 | for run, in curs.fetchall(): |
| 20 | TrigModeQuery = """ |
| 21 | SELECT TRIGGERMODE FROM CMS_WBM.RUNSUMMARY WHERE RUNNUMBER = %d |
| 22 | """ % run |
| 23 | curs.execute(TrigModeQuery) |
| 24 | trigm, = curs.fetchone() |
| 25 | isCol=0 |
| 26 | try: |
| 27 | if trigm.find('l1_hlt_collisions')!=-1: |
| 28 | runs.append(run) |
| 29 | except: |
| 30 | continue |
| 31 | return runs |
| 32 | |
| 33 | def usage(): |
| 34 | print sys.argv[0]+" MinRunNumber" |
| 35 | |
| 36 | if __name__=='__main__': |
| 37 | if len(sys.argv)<2: |
| 38 | usage() |
| 39 | sys.exit(0) |
| 40 | try: |
| 41 | for run in GetLatestRunNumber(int(sys.argv[1])): |
| 42 | print run |
| 43 | except: |
| 44 | print "Invalid Run Number: "+str(sys.argv[1]) |
| 45 | usage() |