Changeset 35042

Timestamp:

Jan 24, 2013, 11:36:13 AM (13 years ago)

Author:

eugene

Message:

add objID,detectID to dvoDetectionFull table definition rather than adding after inserts are done

Location:

branches/eam_branches/ipp-20121219/ippToPsps/jython

Files:

• dvo.py (modified) (1 diff)
• scratchdb.py (modified) (2 diffs)

branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py

@@ -621 +621 @@
         p.wait()
 
-        sql = "alter table dvoDetectionFull add key (objID, detectID)"
-        self.scratchDb.execute(sql)
-
         # update lists after attempted sync
         # self.printSummary()

branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py

@@ -340 +340 @@
             rs.first()
             if rs.getInt(1) < 50:
+                # print "bad astromety"
                 self.logger.debug("Bad astrometric solution for",  ota)
                 return False
             else:
+                # print "good astromety"
                 return True
         except:
+            # print "query failed"
             self.logger.debug("Unable to check astrometric solution")
             return False
@@ -401 +404 @@
                raErr REAL, \
                decErr REAL, \
-               PRIMARY KEY (imageID, ippDetectID) \
-               )"
+               PRIMARY KEY (imageID, ippDetectID), \
+               KEY (objID, detectID) \
+             )"
 
         try: self.execute(sql)