Variables
fillPixelInfo Namespace Reference

Variables

 det = sys.argv[1]
 
string lastrunFile = "lastrun{}"
 
 conn = psycopg2.connect("dbname=nova_prod host=ifdbrep.fnal.gov user=nova_reader port=5436")
 
 cur = conn.cursor()
 
 f = open(lastrunFile,'r')
 
 line = f.readline().split()
 
 firstrun = int(line[0])
 
 firstcfg = int(line[1])
 
string SQL = "select * from (select DISTINCT ON (configid) configid,run from {}.runs where partition=1 and run>{} and nsubruns>0 order by configid,run asc) as foo order by run asc"
 
 rows = cur.fetchall()
 
int irow = 0
 
 nrows = len(rows)
 
int step = 5
 
 rowList = rows[irow:irow+step]
 
 nrun = len(rowList)
 
 firstRun = rowList[0][1]
 
 firstCfg = rowList[0][0]
 
 lastRun = rowList[nrun-1][1]
 
 lastCfg = rowList[nrun-1][0]
 
string cmd = "pushPixelInfo2Condb -p {}"
 

Variable Documentation

string fillPixelInfo.cmd = "pushPixelInfo2Condb -p {}"

Definition at line 60 of file fillPixelInfo.py.

fillPixelInfo.conn = psycopg2.connect("dbname=nova_prod host=ifdbrep.fnal.gov user=nova_reader port=5436")

Definition at line 10 of file fillPixelInfo.py.

fillPixelInfo.cur = conn.cursor()

Definition at line 21 of file fillPixelInfo.py.

fillPixelInfo.det = sys.argv[1]

Definition at line 5 of file fillPixelInfo.py.

fillPixelInfo.f = open(lastrunFile,'r')

Definition at line 23 of file fillPixelInfo.py.

fillPixelInfo.firstcfg = int(line[1])

Definition at line 26 of file fillPixelInfo.py.

fillPixelInfo.firstCfg = rowList[0][0]

Definition at line 57 of file fillPixelInfo.py.

fillPixelInfo.firstrun = int(line[0])

Definition at line 25 of file fillPixelInfo.py.

fillPixelInfo.firstRun = rowList[0][1]

Definition at line 56 of file fillPixelInfo.py.

int fillPixelInfo.irow = 0

Definition at line 44 of file fillPixelInfo.py.

fillPixelInfo.lastCfg = rowList[nrun-1][0]

Definition at line 59 of file fillPixelInfo.py.

fillPixelInfo.lastRun = rowList[nrun-1][1]

Definition at line 58 of file fillPixelInfo.py.

string fillPixelInfo.lastrunFile = "lastrun{}"

Definition at line 6 of file fillPixelInfo.py.

fillPixelInfo.line = f.readline().split()

Definition at line 24 of file fillPixelInfo.py.

fillPixelInfo.nrows = len(rows)

Definition at line 45 of file fillPixelInfo.py.

fillPixelInfo.nrun = len(rowList)

Definition at line 55 of file fillPixelInfo.py.

fillPixelInfo.rowList = rows[irow:irow+step]

Definition at line 53 of file fillPixelInfo.py.

fillPixelInfo.rows = cur.fetchall()

Definition at line 42 of file fillPixelInfo.py.

string fillPixelInfo.SQL = "select * from (select DISTINCT ON (configid) configid,run from {}.runs where partition=1 and run>{} and nsubruns>0 order by configid,run asc) as foo order by run asc"

Definition at line 38 of file fillPixelInfo.py.

int fillPixelInfo.step = 5

Definition at line 47 of file fillPixelInfo.py.