Changeset 34108 for trunk

Timestamp:

Jun 29, 2012, 9:11:40 AM (14 years ago)

Author:

eugene

Message:

use modified photcode table to count the secfilt filters

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (2 diffs)

trunk/ippToPsps/jython/scratchdb.py

@@ -549 +549 @@
 
         # 2 is hardwired -- convert to an enum (should probably read Ohana/src/libdvo/include/dvo.h defines
-        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 2"
+        sql = "SELECT count(TYPE_AS_INT) FROM " + self.dvoPhotcodesTable + " WHERE TYPE_AS_INT = 2"
 
         filterCount = 0
@@ -567 +567 @@
     '''
     def getOrderedListOfFiltersFromPhotcodesTable(self, interestedFilters):
-
-        sql = "SELECT count(TYPE) FROM " + self.dvoPhotcodesTable + " WHERE TYPE = 'sec'"
 
         sql = "SELECT NAME FROM " + self.dvoPhotcodesTable + " WHERE "