Changeset 37179 for branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py

Timestamp:

Aug 4, 2014, 4:27:44 PM (12 years ago)

Author:

eugene

Message:

add tessID, projectionID, skycellID; cleanup StackMeta fields

File:

• branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py (modified) (2 diffs)

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

@@ -131 +131 @@
         return filterID
 
+    '''
+    Gets tess ID for this tess name
+    '''
+    def getTessID(self, name):
+     
+        sql = "SELECT tessID FROM TessellationType WHERE name = '" + name + "'"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            tessID = rs.getInt(1)
+        except:
+            self.logger.errorPair("No tess ID found for tess", name)
+            tessID = -1
+
+        return tessID
+
     ''' 
     Gets imageID from extern ID 
@@ -476 +492 @@
                ippDetectID BIGINT, \
                imageID INT, \
+               catID INT, \
                ra DOUBLE, \
                dec_ DOUBLE, \