IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 38964 for trunk/ippToPsps/test


Ignore:
Timestamp:
Oct 26, 2015, 5:24:35 PM (11 years ago)
Author:
watersc1
Message:

Merge of previous version to back out my over-zealous commit.

Location:
trunk/ippToPsps/test
Files:
6 edited

Legend:

Unmodified
Added
Removed
  • trunk/ippToPsps/test/fulltest.sh

    r38963 r38964  
    11#!/bin/csh -f
    2 
    3 set dbuser = czw
    4 set dbpass = -pczw
    52
    63chmod +x mkgpc1data.dvo mkgpc1.sh
     
    193190  # does the database already exist?
    194191  # XXX this command will blow away an existing database!!
    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
     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
    197194  echo " ---- init ipptopsps_test: done ----"
    198195endif
     
    204201
    205202  # create the database (ignore failure if it already exists)
    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"
     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"
    208205  ippjython setupScratchDb.py -test < /dev/null
    209206  if ($status) exit
  • trunk/ippToPsps/test/mkgpc1.sh

    r38963 r38964  
    5959  echo ntable: $ntable
    6060  if ($ntable != 25) then
    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."
     61    echo "expected 25 lines (24 tables), but got $ntable, not deleting"
     62    exit 2
    6663  endif
    6764
  • trunk/ippToPsps/test/mkgpc1data.dvo

    r38963 r38964  
    33input tap.dvo
    44
    5 opihi verbose on
    6 if (not($?VERBOSE)) set VERBOSE = 1
     5if (not($?VERBOSE)) set VERBOSE = 0
    76if (not($?PARALLEL)) set PARALLEL = 0
    87
     
    7170  $dbhost = localhost
    7271  $dbname = gpc1test
    73   $dbuser = czw
    74   $dbpass = czw
     72  $dbuser = dvo
     73  $dbpass = dvo
    7574
    7675  $RA = 10.0
  • trunk/ippToPsps/test/partest.sh

    r38963 r38964  
    11#!/bin/csh -f
    2 
    3 set dbuser = czw
    4 set dbpass = -pczw
    52
    63set stackqueuename = 0
     
    5249  # does the database already exist?
    5350  # XXX this command will blow away an existing database!!
    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
     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
    5653
    5754endif
     
    9188
    9289  # create the database (ignore failure if it already exists)
    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"
     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"
    10097
    10198  ippjython setupScratchDb.py -test dummy ipptopsps_test_scratch1
  • trunk/ippToPsps/test/sastest.sh

    r38963 r38964  
    11#!/bin/csh -f
    2 
    3 set dbuser = czw
    4 set dbpass = -pczw
    52
    63chmod +x mksasdata.dvo mkgpc1.sh
     
    160157  # does the database already exist?
    161158  # XXX this command will blow away an existing database!!
    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
     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
    164161endif
    165162
     
    168165
    169166  # create the database (ignore failure if it already exists)
    170   mysql -h localhost -u $dbuser $dbpass -e "drop database ipptopsps_scratch"
    171   mysql -h localhost -u $dbuser $dbpass -e "create database ipptopsps_scratch"
     167  mysql -h localhost -u dvo -pdvo -e "drop database ipptopsps_scratch"
     168  mysql -h localhost -u dvo -pdvo -e "create database ipptopsps_scratch"
    172169  ippjython setupScratchDb.py -test < /dev/null
    173170  if ($status) exit
  • trunk/ippToPsps/test/widetest.sh

    r38963 r38964  
    11#!/bin/csh -f
    2 
    3 set dbuser = czw
    4 set dbpass = -pczw
    52
    63set stackqueuename = 0
     
    5148  # does the database already exist?
    5249  # XXX this command will blow away an existing database!!
    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
     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
    5552
    5653endif
     
    6057
    6158  # create the database (ignore failure if it already exists)
    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"
     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"
    6461  ippjython setupScratchDb.py -test
    6562endif
Note: See TracChangeset for help on using the changeset viewer.