13#SQL = "set search_path to ashriverprod_factory;"
14#cur.execute(SQL)
15
16#print "__________________________________"
17#print "looking for diblock {} dcm {} port {}".format(sys.argv[1],sys.argv[2],sys.argv[3])
18
19
20 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:{}';".format(sys.argv[1],sys.argv[2],sys.argv[3])