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

trunk/ippToPsps/test/partest.sh

@@ -1 +1 @@
 #!/bin/csh -f
+
+set dbuser = czw
+set dbpass = -pczw
 
 set stackqueuename = 0
@@ -49 +52 @@
   # 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
@@ -88 +91 @@
 
   # create the database (ignore failure if it already exists)
-  mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_test_scratch1"
-  # mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch2"
-  # mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch3"
-
-  mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test_scratch1"
-  # mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch2"
-  # mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch3"
+  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_test_scratch1"
+  # mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch2"
+  # mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch3"
+
+  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test_scratch1"
+  # mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch2"
+  # mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch3"
 
   ippjython setupScratchDb.py -test dummy ipptopsps_test_scratch1