Changeset 38963 for trunk/ippToPsps/test/sastest.sh

Timestamp:

Oct 26, 2015, 5:17:19 PM (11 years ago)

Author:

watersc1

Message:

Dropping ra/dec fields from ForcedGalaxyShape, as these are inherited from the stack detection, and should be fixed to those values (as it's forced). 'Complete' version of the forcedgalaxybatch.py, which has all the things similar tables also have.

File:

• trunk/ippToPsps/test/sastest.sh (modified) (3 diffs)

trunk/ippToPsps/test/sastest.sh

@@ -1 +1 @@
 #!/bin/csh -f
+
+set dbuser = czw
+set dbpass = -pczw
 
 chmod +x mksasdata.dvo mkgpc1.sh
@@ -157 +160 @@
   # does the database already exist?
   # XXX this command will blow away an existing database!!
-  mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test"
-  mysql -h localhost -u dvo -pdvo ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
+  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test"
+  mysql -h localhost -u $dbuser $dbpass ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
 endif
 
@@ -165 +168 @@
 
   # create the database (ignore failure if it already exists)
-  mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch"
-  mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch"
+  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch"
+  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch"
   ippjython setupScratchDb.py -test < /dev/null
   if ($status) exit