IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 38963 for trunk/ippToPsps/test


Ignore:
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.

Location:
trunk/ippToPsps/test
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippToPsps/test/fulltest.sh

    r38949 r38963  
    11#!/bin/csh -f
     2
     3set dbuser = czw
     4set dbpass = -pczw
    25
    36chmod +x mkgpc1data.dvo mkgpc1.sh
    … …  
    190193  # does the database already exist?
    191194  # XXX this command will blow away an existing database!!
    192   mysql -h localhost -u dvo -pdvo -e "create database if not exists ipptopsps_test" || exit 3
    193   mysql -h localhost -u dvo -pdvo ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql || exit 3
     195  mysql -h localhost -u $dbuser $dbpass -e "create database if not exists ipptopsps_test" || exit 3
     196  mysql -h localhost -u $dbuser $dbpass ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql || exit 3
    194197  echo " ---- init ipptopsps_test: done ----"
    195198endif
    … …  
    201204
    202205  # create the database (ignore failure if it already exists)
    203   mysql -h localhost -u dvo -pdvo -e "drop database if exists ipptopsps_test_scratch"
    204   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test_scratch"
     206  mysql -h localhost -u $dbuser $dbpass -e "drop database if exists ipptopsps_test_scratch"
     207  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test_scratch"
    205208  ippjython setupScratchDb.py -test < /dev/null
    206209  if ($status) exit

  • trunk/ippToPsps/test/mkgpc1.sh

    r38888 r38963  
    5959  echo ntable: $ntable
    6060  if ($ntable != 25) then
    61     echo "expected 25 lines (24 tables), but got $ntable, not deleting"
    62     exit 2
     61    if ($ntable != 21) then
     62        echo "expected 25 lines (24 tables), but got $ntable, not deleting"
     63        exit 2
     64    endif
     65    echo "Found old style 21 line (20 table) version of the database, so not blocking deletion."
    6366  endif
    6467

  • trunk/ippToPsps/test/mkgpc1data.dvo

    r38952 r38963  
    33input tap.dvo
    44
    5 if (not($?VERBOSE)) set VERBOSE = 0
     5opihi verbose on
     6if (not($?VERBOSE)) set VERBOSE = 1
    67if (not($?PARALLEL)) set PARALLEL = 0
    78
    … …  
    7071  $dbhost = localhost
    7172  $dbname = gpc1test
    72   $dbuser = dvo
    73   $dbpass = dvo
     73  $dbuser = czw
     74  $dbpass = czw
    7475
    7576  $RA = 10.0

  • trunk/ippToPsps/test/partest.sh

    r35097 r38963  
    11#!/bin/csh -f
     2
     3set dbuser = czw
     4set dbpass = -pczw
    25
    36set stackqueuename = 0
    … …  
    4952  # does the database already exist?
    5053  # XXX this command will blow away an existing database!!
    51   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test"
    52   mysql -h localhost -u dvo -pdvo ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
     54  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test"
     55  mysql -h localhost -u $dbuser $dbpass ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
    5356
    5457endif
    … …  
    8891
    8992  # create the database (ignore failure if it already exists)
    90   mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_test_scratch1"
    91   # mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch2"
    92   # mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch3"
    93 
    94   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test_scratch1"
    95   # mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch2"
    96   # mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch3"
     93  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_test_scratch1"
     94  # mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch2"
     95  # mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch3"
     96
     97  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test_scratch1"
     98  # mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch2"
     99  # mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch3"
    97100
    98101  ippjython setupScratchDb.py -test dummy ipptopsps_test_scratch1

  • trunk/ippToPsps/test/sastest.sh

    r37246 r38963  
    11#!/bin/csh -f
     2
     3set dbuser = czw
     4set dbpass = -pczw
    25
    36chmod +x mksasdata.dvo mkgpc1.sh
    … …  
    157160  # does the database already exist?
    158161  # XXX this command will blow away an existing database!!
    159   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test"
    160   mysql -h localhost -u dvo -pdvo ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
     162  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test"
     163  mysql -h localhost -u $dbuser $dbpass ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
    161164endif
    162165
    … …  
    165168
    166169  # create the database (ignore failure if it already exists)
    167   mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch"
    168   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch"
     170  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch"
     171  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch"
    169172  ippjython setupScratchDb.py -test < /dev/null
    170173  if ($status) exit

  • trunk/ippToPsps/test/widetest.sh

    r35204 r38963  
    11#!/bin/csh -f
     2
     3set dbuser = czw
     4set dbpass = -pczw
    25
    36set stackqueuename = 0
    … …  
    4851  # does the database already exist?
    4952  # XXX this command will blow away an existing database!!
    50   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test"
    51   mysql -h localhost -u dvo -pdvo ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
     53  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test"
     54  mysql -h localhost -u $dbuser $dbpass ipptopsps_test < $IPPTOPSPS_DATA/ippToPspsDbSchema.sql
    5255
    5356endif
    … …  
    5760
    5861  # create the database (ignore failure if it already exists)
    59   mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_test_scratch"
    60   mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_test_scratch"
     62  mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_test_scratch"
     63  mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_test_scratch"
    6164  ippjython setupScratchDb.py -test
    6265endif
Note: See TracChangeset for help on using the changeset viewer.