Changeset 37917 for trunk/ippToPsps/jython/forcedobjectbatch.py

Timestamp:

Feb 20, 2015, 1:19:35 PM (11 years ago)

Author:

heather

Message:

current state of ipptopsps / sas37 - ob/p2/st/df work

File:

• trunk/ippToPsps/jython/forcedobjectbatch.py (modified) (1 diff)

trunk/ippToPsps/jython/forcedobjectbatch.py

@@ -180 +180 @@
         for filter in filters:
             # now do a sum of n[filters], but do not include the ones with -999
-            sql  = "UPDATE ObjectThin "
-            sql += "SET nDetections = nDetections + n" + filter[1]
+            sql  = "UPDATE ForcedMeanObject"
+            sql += "SET nDetections = nDetections + " + filter[1] +"nTotal "
             sql += " WHERE n" + filter[1] + " != -999"
             self.scratchDb.execute(sql)
+            try: self.scratchDb.execute(sql)
+            except:
+                self.logger.errorPair("failed update MeanObject nDetections", sql)
+                raise
 
     '''