Changeset 39170 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Nov 20, 2015, 2:53:37 PM (11 years ago)

Author:

eugene

Message:

adjust inv cmf IPP_IDET by value depending on [num]

File:

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

trunk/ippToPsps/jython/scratchdb.py

@@ -406 +406 @@
 
         return size
+
+    '''
+    Returns a row count for this table
+    '''
+    def getMaxIPP_IDET(self, table):
+
+        sql = "SELECT MAX(IPP_IDET) FROM " + table
+        rs = self.executeQuery(sql)  
+
+        if not rs.first():
+            self.logger.exception("Could not count rows for table: '" + table + "'")
+            return 0
+
+        return rs.getInt(1)
 
     '''