Changeset 39785 for trunk/ippToPsps/jython/ipptopspsdb.py

Timestamp:

Oct 21, 2016, 11:24:05 AM (10 years ago)

Author:

heather

Message:

first steps for gaia object batches

File:

• trunk/ippToPsps/jython/ipptopspsdb.py (modified) (4 diffs)

trunk/ippToPsps/jython/ipptopspsdb.py

@@ -819 +819 @@
 
         sql = "INSERT INTO diffobject ( \
+               batch_id \
+               ,region \
+               ) VALUES ( \
+               " + str(batchID) + " \
+               ,'" + region + "' \
+               )"
+
+        self.execute(sql)
+
+            '''
+    Inserts some gaiaobject metadata for this batch ID
+    '''
+    def insertGaiaObjectMeta(self, batchID, region):
+
+        sql = "INSERT INTO gaiaobject ( \
                batch_id \
                ,region \
@@ -1104 +1119 @@
         ,queue_FW \
         ,queue_FO \
+        ,queue_FG \
+        ,queue_GO \
         ,parallel \
         ,P2_smf_version \
@@ -1179 +1196 @@
 ###        if rs.getInt(25) == 1: self.skychunk.batchTypes.append("FG") fix this when P2 is done
         if rs.getInt(25) == 1: self.skychunk.batchTypes.append("FO")
+        if rs.getInt(26) == 1: self.skychunk.batchTypes.append("FG")
+        if rs.getInt(27) == 1: self.skychunk.batchTypes.append("GO")
+        
 
         self.skychunk.force = True # TODO
         self.skychunk.parallel = False # TODO
 
-        if rs.getInt(26) == 1: self.skychunk.parallel = True
-        self.skychunk.P2_smf_version = rs.getString(27)
+        if rs.getInt(28) == 1: self.skychunk.parallel = True
+        self.skychunk.P2_smf_version = rs.getString(29)
         # options: "use_new", "not_reproc", "use_original"
 
-        self.skychunk.ST_cmf_version = rs.getString(28)
+        self.skychunk.ST_cmf_version = rs.getString(30)
         # options: not used?
 
@@ -1212 +1232 @@
         # print "typename: " + rsmd.getColumnTypeName(16)
 
-        self.skychunk.trange_start = rs.getString(29)
+        self.skychunk.trange_start = rs.getString(31)
         # options: "YYYY-MM-DD,HH:MM:SS" or "0000-00-00 00:00:00"
 
-        self.skychunk.trange_end = rs.getString(30) 
+        self.skychunk.trange_end = rs.getString(32) 
         # options: "YYYY-MM-DD,HH:MM:SS" or "0000-00-00 00:00:00"