Changeset 37739

Timestamp:

Dec 12, 2014, 11:34:18 AM (12 years ago)

Author:

heather

Message:

small changes and tweaks to do full force addstar and to remove hard coded ippdb01 in ipptopsps

Location:

trunk

Files:

• ippScripts/scripts/addstar_run.pl (modified) (1 diff)
• ippToPsps/config/ippToPspsDbSchema.sql (modified) (1 diff)
• ippToPsps/config/settings.xml (modified) (2 diffs)
• ippToPsps/doc/notes.txt (modified) (1 diff)

trunk/ippScripts/scripts/addstar_run.pl

@@ -97 +97 @@
 #    $reduction = 'ADDSTAR';
 #} 
+#if ($stage =~/fullforce/) {
+#    $reduction = 'ADDSTAR';
+#} 
+
 if ($stage =~/fullforce/) {
-    $reduction = 'ADDSTAR';
-} 
+    $reduction='DEFAULT';
+    #hardwired because why not
+}
 
 my $recipe_addstar = $ipprc->reduction($reduction, 'ADDSTAR');

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -1 +1 @@
 -- MySQL dump 10.11
 --
--- Host: ippdb01    Database: ipptopsps
+-- Host: ipp06    Database: ipptopsps
 -- ------------------------------------------------------
 -- Server version       5.0.77-log

trunk/ippToPsps/config/settings.xml

@@ -70 +70 @@
   <gpc1database>
     <name>gpc1</name>
-    <host>ippdb01</host>
+    <host>ippdb05</host>
     <user>ipp</user>
     <password>ipp</password>
@@ -136 +136 @@
   <czardatabase>
     <name>czardb</name>
-    <host>ippdb01</host>
+    <host>ippdb05</host>
     <user>ipp</user>
     <password>ipp</password>

trunk/ippToPsps/doc/notes.txt

@@ -43 +43 @@
 mysql -h ipp006 -u dvo -p ipptopsps -e "select batch_id, stage_id from batch where batch_type = 'P2'" > P2.batches.dat
 
-on ippdb01: cp P2.batches.dat /tmp/datadump/
+on ippdb05: cp P2.batches.dat /tmp/datadump/
 
-mysql -h ippdb01 -u dvo -p gpc1
+mysql -h ippdb05 -u dvo -p gpc1
 mysql> create temporary table eam_p2_batches (batch_id int, cam_id int);
 mysql> create temporary table eam_st_batches (batch_id int, stack_id int);