- Timestamp:
- Aug 12, 2014, 3:27:57 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopspsdb.py
r37232 r37239 1259 1259 AND batch_type = '" + batchType + "'") 1260 1260 1261 print "deleted old items"1262 1263 1261 for id in ids: 1264 1262 sql = "INSERT IGNORE INTO pending \ … … 1267 1265 (" + str(box_id) + ", '" + batchType + "', " + str(id) + ")" 1268 1266 1269 print "sql: ", sql1270 1271 1267 try: self.execute(sql) 1272 1268 except: 1273 1269 print "failed to insert into pending" 1270 print "sql: " + sql 1274 1271 raise 1275 1272 … … 1296 1293 GROUP BY ra_center LIMIT 1" 1297 1294 1298 # XXX print "sql: ", sql1299 1300 1295 try: rs = self.executeQuery(sql) 1301 1296 except: … … 1303 1298 print "SQL: " + sql 1304 1299 1305 print "SQL: " + sql1306 1300 if not rs.next(): 1307 1301 self.logger.errorPair("No outstanding boxes", "nothing to do here") … … 1384 1378 print "SQL: " + sql 1385 1379 1386 print "SQL: " + sql1387 1380 if not rs.next(): 1388 1381 self.logger.infoPair("No outstanding boxes", "nothing to do here") … … 1620 1613 VALUES ( '" + dvo_db + "', '" + batchType + "'," + str(row[0]) + "," + str(row[1]) + " \ 1621 1614 , " + str(row[2]) + ", '"+uniq+"' ) " 1622 print "sql 1: ", sql1615 # print "sql 1: ", sql 1623 1616 self.execute(sql) 1624 1617 except: continue … … 1641 1634 AND dec_bore BETWEEN " + str(minDEC) + " AND " + str(maxDEC) 1642 1635 1643 print "items: ", sql1644 1645 1636 try: 1646 1637 rs = self.executeQuery(sql) 1647 1638 while (rs.next()): 1648 1639 ids.append(rs.getInt(1)) 1649 print "stage_id: " + str(rs.getInt(1))1650 1640 except: 1651 1641 self.logger.errorPair("Can't get items in this box", sql)
Note:
See TracChangeset
for help on using the changeset viewer.
