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(location2, 'BLK:') AS INT), CAST(btrim(position2, 'PLN:') AS INT), CAST(btrim(port2,'POS:') AS INT) from public.feb_comm_cables where location1='DIBLK:{}' and position1='DCM:{}' and port1='PRT:{}';".format(sys.argv[1],sys.argv[2],sys.argv[3])