Namespaces | Variables
geo2elec.py File Reference

Go to the source code of this file.

Namespaces

 geo2elec
 

Variables

 geo2elec.conn = psycopg2.connect("dbname=nova_hardware host=ifdbprod.fnal.gov user=nova_reader port=5432")
 
 geo2elec.cur = conn.cursor()
 
string geo2elec.SQL = "select CAST(btrim(location1, 'DIBLK:') AS INT), CAST(btrim(position1, 'DCM:') AS INT), CAST(btrim(port1,'PRT:') AS INT) from public.feb_comm_cables where location2='BLK:{}' and position2='PLN:{}' and port2='POS:{}';"
 
 geo2elec.rows = cur.fetchall()
 
 geo2elec.diblock = row[0]
 print "ROW IS " print row More...
 
 geo2elec.dcm = row[1]
 
 geo2elec.prt = row[2]