IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Oct 20, 2015, 2:07:03 PM (11 years ago)
Author:
eugene
Message:

updating to test the forced warp stage (still turned off in fulltest.sh)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippToPsps/test/mkgpc1.sh

    r37246 r38888  
    1111  set dbpass = $4
    1212
    13   mysql -h $dbhost -u root -p <<EOF
    14    grant all on *.* to $dbuser@"$dbhost" identified by '$dbpass';
    15 EOF
    16     exit 0;
     13  mysql -h $dbhost -u root -p -e "grant all on *.* to $dbuser@"$dbhost" identified by '$dbpass'"
     14  exit 0;
    1715endif
    1816
    … …  
    2927
    3028  # create a database with completely minimal tables needed to test
    31   mysql -h $dbhost -u $dbuser $dbpass <<EOF
    32    CREATE DATABASE $dbname;
    33    USE $dbname;
    34   CREATE TABLE ippToPspsFake (
    35     my_id INT
    36   );
    37   CREATE TABLE skycell (
    38    radeg REAL,
    39    decdeg REAL,
    40    skycell_id CHAR(64)
    41   );
    42   CREATE TABLE rawExp (
    43    exp_id INT,
    44    exp_name CHAR(64),
    45    exp_time REAL,
    46    bg REAL,
    47    bg_stdev REAL,
    48    ra FLOAT,
    49    decl FLOAT,
    50    dateobs DATETIME
    51   );
    52   CREATE TABLE chipRun (
    53     exp_id INT,
    54     chip_id INT
    55   );
    56   CREATE TABLE camRun (
    57     chip_id INT,
    58     cam_id INT,
    59     dist_group CHAR(64),
    60     software_ver CHAR(16)
    61   );
    62   CREATE TABLE camProcessedExp (
    63     path_base CHAR(255),
    64     cam_id INT,
    65     fault INT
    66   );
    67   CREATE TABLE fakeRun (
    68     fake_id INT,
    69     cam_id INT
    70   );
    71   CREATE TABLE warpRun (
    72    warp_id INT,
    73    fake_id INT
    74   );
    75   CREATE TABLE warpSkyCellMap (
    76    warp_id INT,
    77    skycell_id CHAR(64),
    78    class_id CHAR(64)
    79   );
    80   CREATE TABLE stackRun (
    81    stack_id INT,
    82    skycell_id CHAR(64),
    83    filter CHAR(64),
    84    software_ver CHAR(16)
    85   );
    86   CREATE TABLE stackInputSkyfile (
    87    stack_id INT,
    88    warp_id INT
    89   );
    90   CREATE TABLE stackSumSkyfile (
    91    stack_id INT,
    92    mjd_obs DOUBLE
    93   );
    94   CREATE TABLE skycalRun (
    95    sky_id INT,
    96    skycal_id INT,
    97    stack_id INT
    98   );
    99   CREATE TABLE skycalResult (
    100    path_base CHAR(255),
    101    skycal_id INT
    102   );
    103   CREATE TABLE addRun (
    104     add_id INT,
    105     stage CHAR(64),
    106     state CHAR(64),
    107     stage_id INT,
    108     minidvodb_name CHAR(64)
    109   );
    110   CREATE TABLE addProcessedExp (
    111     add_id INT,
    112     fault INT
    113   );
    114   CREATE TABLE minidvodbRun (
    115    minidvodb_name CHAR(64),
    116    minidvodb_id INT,
    117    state CHAR(64)
    118   );
    119   CREATE TABLE minidvodbProcessed (
    120    minidvodb_id INT,
    121    fault INT
    122   );
    123   CREATE TABLE mergedvodbRun (
    124    minidvodb_id INT,
    125    merge_id INT,
    126    state CHAR(64),
    127    mergedvodb CHAR(64)
    128   );
    129   CREATE TABLE mergedvodbProcessed (
    130    merge_id INT,
    131    fault INT
    132   );
    133 EOF
    134     exit 0;
     29  mysql -h $dbhost -u $dbuser $dbpass -e "CREATE DATABASE $dbname"
     30  mysql -h $dbhost -u $dbuser $dbpass $dbname < gpc1schema.sql
     31  exit 0;
    13532endif
    13633
    … …  
    14643  endif
    14744
    148   mysql -h $dbhost -u $dbuser $dbpass <<EOF
    149    USE $dbname;
    150    describe ippToPspsFake;
    151 EOF
     45  (mysql -B -h $dbhost -u $dbuser $dbpass -e "show databases" | grep ^$dbname\$) >& /dev/null
     46  if ($status) then
     47    echo "database $dbname does not yet exist"
     48    exit 0
     49  endif
     50
     51  # mysql -h $dbhost -u $dbuser $dbpass $dbname -e "show tables"
     52  mysql -h $dbhost -u $dbuser $dbpass $dbname -e "describe ippToPspsFake" >& /dev/null
    15253  if ($status) then
    15354    echo "database does not contain ippToPspsFake, not deleting"
    … …  
    15556  endif
    15657
    157   set ntable = `echo "USE $dbname; show tables;" | mysql -h $dbhost -u $dbuser $dbpass | wc -l`
     58  set ntable = `mysql -B -h $dbhost -u $dbuser $dbpass $dbname -e "show tables" | wc -l`
    15859  echo ntable: $ntable
    159   if ($ntable != 21) then
    160     echo "expected 21 lines (20 tables), but got $ntable, not deleting"
     60  if ($ntable != 25) then
     61    echo "expected 25 lines (24 tables), but got $ntable, not deleting"
    16162    exit 2
    16263  endif
    16364
    16465  echo "database is valid, deleting"
    165   mysql -h $dbhost -u $dbuser $dbpass <<EOF
    166    drop database $dbname;
    167 EOF
    168 
    169    exit 0;
     66  mysql -h $dbhost -u $dbuser $dbpass -e "drop database $dbname"
     67  exit 0;
    17068endif
    17169
Note: See TracChangeset for help on using the changeset viewer.