IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Aug 16, 2008, 1:27:58 PM (18 years ago)
Author:
eugene
Message:

extensive changes from eam_branch_20080719:

  • added the 'cleanup' options to camtool, faketool, warptool, difftool, stacktool
  • added corresponding sql code
  • changed the states for camera, fake, warp, diff, and stack to the new set of states: new, full, goto_cleaned, cleaned, update, goto_purged, and purged
  • added 'data_state' entries to the detrend tables and the detRunSummary
  • added 'cleanup' options to dettool using the detRunSummary data_state as the control
  • moved dettool supporting code to dettool_STAGE, where stage is processedimfile, processedexp, etc.
  • converted dettool to use S64 for det_id and exp_id entries
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/pxadmin_create_tables.sql

    r18764 r19092  
    485485    user_5 DOUBLE,
    486486    path_base VARCHAR(255),
     487    data_state VARCHAR(64),
    487488    fault SMALLINT NOT NULL,
    488489    PRIMARY KEY(det_id, exp_id, class_id),
    … …  
    512513    user_5 DOUBLE,
    513514    path_base VARCHAR(255),
     515    data_state VARCHAR(64),
    514516    fault SMALLINT NOT NULL,
    515517    PRIMARY KEY(det_id, exp_id),
    … …  
    535537    user_4 DOUBLE,
    536538    user_5 DOUBLE,
     539    data_state VARCHAR(64),
    537540    fault SMALLINT NOT NULL,
    538541    PRIMARY KEY(det_id, iteration, class_id),
    … …  
    549552    class_id VARCHAR(64),
    550553    norm FLOAT,
     554    data_state VARCHAR(64),
    551555    fault SMALLINT NOT NULL,
    552556    PRIMARY KEY(det_id, iteration, class_id),
    … …  
    572576    user_5 DOUBLE,
    573577    path_base VARCHAR(255),
     578    data_state VARCHAR(64),
    574579    fault SMALLINT NOT NULL,
    575580    PRIMARY KEY(det_id, iteration, class_id),
    … …  
    595600    user_5 DOUBLE,
    596601    path_base VARCHAR(255),
     602    data_state VARCHAR(64),
    597603    fault SMALLINT NOT NULL,
    598604    PRIMARY KEY(det_id, iteration),
    … …  
    629635    user_5 DOUBLE,
    630636    path_base VARCHAR(255),
     637    data_state VARCHAR(64),
    631638    fault SMALLINT NOT NULL,
    632639    PRIMARY KEY(det_id, iteration, exp_id, class_id),
    … …  
    641648) ENGINE=innodb DEFAULT CHARSET=latin1;
    642649
    643 CREATE TABLE detResidExp (det_id BIGINT, iteration INT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detResidImfile(det_id, iteration, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
    644 CREATE TABLE detRunSummary (det_id BIGINT, iteration INT, bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detResidExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
    645 CREATE TABLE detRegisteredImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detRun(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
     650CREATE TABLE detResidExp (
     651       det_id BIGINT,
     652       iteration INT,
     653       exp_id BIGINT,
     654       recipe VARCHAR(64),
     655       bg DOUBLE,
     656       bg_stdev DOUBLE,
     657       bg_mean_stdev DOUBLE,
     658       bg_skewness DOUBLE,
     659       bg_kurtosis DOUBLE,
     660       bin_stdev DOUBLE,
     661       fringe_0 DOUBLE,
     662       fringe_1 DOUBLE,
     663       fringe_2 DOUBLE,
     664       fringe_resid_0 DOUBLE,
     665       fringe_resid_1 DOUBLE,
     666       fringe_resid_2 DOUBLE,
     667       user_1 DOUBLE,
     668       user_2 DOUBLE,
     669       user_3 DOUBLE,
     670       user_4 DOUBLE,
     671       user_5 DOUBLE,
     672       path_base VARCHAR(255),
     673       data_state VARCHAR(64),
     674       accept TINYINT,
     675       fault SMALLINT NOT NULL,
     676       PRIMARY KEY(det_id, iteration, exp_id),
     677       KEY(fault),
     678       INDEX(det_id, iteration),
     679       FOREIGN KEY (det_id, iteration, exp_id) 
     680       REFERENCES  detInputExp(det_id, iteration, exp_id),
     681       FOREIGN KEY (det_id, iteration, exp_id) 
     682       REFERENCES  detResidImfile(det_id, iteration, exp_id)
     683) ENGINE=innodb DEFAULT CHARSET=latin1;
     684
     685CREATE TABLE detRunSummary (
     686       det_id BIGINT,
     687       iteration INT,
     688       data_state VARCHAR(64),
     689       bg DOUBLE,
     690       bg_stdev DOUBLE,
     691       bg_mean_stdev DOUBLE,
     692       accept TINYINT,
     693       fault SMALLINT NOT NULL,
     694       PRIMARY KEY(det_id, iteration),
     695       KEY(fault),
     696       FOREIGN KEY (det_id, iteration) 
     697         REFERENCES  detInputExp(det_id, iteration),
     698       FOREIGN KEY (det_id, iteration) 
     699         REFERENCES  detResidExp(det_id, iteration)
     700) ENGINE=innodb DEFAULT CHARSET=latin1;
     701
     702CREATE TABLE detRegisteredImfile (
     703       det_id BIGINT,
     704       iteration INT,
     705       class_id VARCHAR(64),
     706       uri VARCHAR(255),
     707       bg DOUBLE,
     708       bg_stdev DOUBLE,
     709       bg_mean_stdev DOUBLE,
     710       user_1 DOUBLE,
     711       user_2 DOUBLE,
     712       user_3 DOUBLE,
     713       user_4 DOUBLE,
     714       user_5 DOUBLE,
     715       path_base VARCHAR(255),
     716       data_state VARCHAR(64),
     717       fault SMALLINT NOT NULL,
     718       PRIMARY KEY(det_id, iteration, class_id),
     719       KEY(fault),
     720       FOREIGN KEY (det_id, iteration) 
     721         REFERENCES  detRun(det_id, iteration)
     722) ENGINE=innodb DEFAULT CHARSET=latin1;
    646723
    647724CREATE TABLE warpRun (
Note: See TracChangeset for help on using the changeset viewer.