Context Navigation

Changeset 36815

Timestamp:

Jun 4, 2014, 3:42:24 PM (12 years ago)

Author:

heather

Message:

current ipptopsps before we discovered we need skinny objects

Location:

trunk/ippToPsps

Files:

-              r36706
+              r36815
 -- Dump completed on 2012-04-10  6:00:59
+DROP TABLE IF EXISTS `dvodb`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `dvodb` (
+  `dvo_db` varchar(30) default NULL,
+  `batch_type` varchar(10) default NULL,
+  `stage_id` bigint(20) unsigned default NULL,
+  `ra_center` float default NULL,
+  `dec_center` float default NULL,
+  `uniq_key` varchar(30) default NULL,
+  UNIQUE KEY `uniq_key` (`uniq_key`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;

-              r36706
+              r36815
 # this thing will just parse the votables and print out in 'ken schema style'
 #$wiki=1;
 $csv = 1;
+$wiki=1;
+#$csv = 1;
 $infield = 0;
 $intable = 0;

-              r36697
+              r36815
         # self.logger.infoPair("Items written to alt Db", "%d" % count)
+    '''
+    Creates a temporary table and shoves it full of stage_ids and ra/dec coords
+    '''
+    def storeAllItemsInDvodb(self, rows, dvo_db, batchType):
+        #try:
+        #    self.execute("DROP TABLE all_pending")
+        #except:
+        #    pass
+        #self.execute("CREATE TEMPORARY TABLE all_pending (stage_id bigint(20), ra_bore float, dec_bore float)")
+        for row in rows:
+            try:
+                uniq = dvo_db + "."+ batchType + "." + str(row[0])
+                sql = "INSERT INTO dvodb (dvo_db, batch_type, stage_id, ra_center, dec_center, uniq_key) \
+                       VALUES ( '" + dvo_db + "', '" + batchType + "'," + str(row[0]) + "," + str(row[1]) + " \
+                       , " + str(row[2]) + ", '"+uniq+"' ) "
+                print "sql 1: ", sql
+                self.execute(sql)
+            except: continue
+        #count = self.getRowCount("all_pending")
+        #self.logger.infoPair("Items written to Db", "%d" % count)
     '''
     Gets all items in the all_pending temporary table within the bounds of this box

r36614	r36815
31	31
32	32	tempFile = tempfile.NamedTemporaryFile(mode='w+b')
33
	33	self.logger.infoPair("checkOdmStatus.pl -b " + batch + " -f " + tempFile.name, "")
34	34	p = Popen("checkOdmStatus.pl -b " + batch + " -f " + tempFile.name,
35	35	shell=True,

Note: See TracChangeset for help on using the changeset viewer.