Changeset 38963 for trunk/ippToPsps/test/widetest.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/widetest.sh (modified) (3 diffs)

trunk/ippToPsps/test/widetest.sh

@@ -1 +1 @@
 #!/bin/csh -f
+
+set dbuser = czw
+set dbpass = -pczw
 
 set stackqueuename = 0
@@ -48 +51 @@
   # 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
@@ -57 +60 @@
 
   # create the database (ignore failure if it already exists)
-  mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_test_scratch"
-  mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test_scratch"
+  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_test_scratch"
+  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test_scratch"
   ippjython setupScratchDb.py -test
 endif