Changeset 28486
- Timestamp:
- Jun 24, 2010, 3:02:57 PM (16 years ago)
- Location:
- trunk
- Files:
-
- 25 edited
- 25 copied
-
. (modified) (1 prop)
-
Ohana (modified) (1 prop)
-
dbconfig/background.md (copied) (copied from branches/pap/dbconfig/background.md )
-
dbconfig/changes.txt (modified) (1 diff)
-
dbconfig/ipp.m4 (modified) (1 diff)
-
ippScripts/Build.PL (modified) (1 diff)
-
ippScripts/scripts/background_chip.pl (copied) (copied from branches/pap/ippScripts/scripts/background_chip.pl )
-
ippScripts/scripts/background_warp.pl (copied) (copied from branches/pap/ippScripts/scripts/background_warp.pl )
-
ippTasks/Makefile.am (modified) (1 diff)
-
ippTasks/background.pro (copied) (copied from branches/pap/ippTasks/background.pro )
-
ippTools/configure.ac (modified) (1 diff)
-
ippTools/share/Makefile.am (modified) (1 diff)
-
ippTools/share/bgtool_advancechip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_advancechip.sql )
-
ippTools/share/bgtool_advancewarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_advancewarp.sql )
-
ippTools/share/bgtool_chip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_chip.sql )
-
ippTools/share/bgtool_chipinputs.sql (copied) (copied from branches/pap/ippTools/share/bgtool_chipinputs.sql )
-
ippTools/share/bgtool_cleanedchip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_cleanedchip.sql )
-
ippTools/share/bgtool_cleanedwarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_cleanedwarp.sql )
-
ippTools/share/bgtool_definechip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_definechip.sql )
-
ippTools/share/bgtool_definewarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_definewarp.sql )
-
ippTools/share/bgtool_revertchip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_revertchip.sql )
-
ippTools/share/bgtool_revertwarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_revertwarp.sql )
-
ippTools/share/bgtool_tochip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_tochip.sql )
-
ippTools/share/bgtool_tocleanchip.sql (copied) (copied from branches/pap/ippTools/share/bgtool_tocleanchip.sql )
-
ippTools/share/bgtool_tocleanwarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_tocleanwarp.sql )
-
ippTools/share/bgtool_towarp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_towarp.sql )
-
ippTools/share/bgtool_warp.sql (copied) (copied from branches/pap/ippTools/share/bgtool_warp.sql )
-
ippTools/share/bgtool_warpinputs.sql (copied) (copied from branches/pap/ippTools/share/bgtool_warpinputs.sql )
-
ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)
-
ippTools/share/pxadmin_drop_tables.sql (modified) (1 diff)
-
ippTools/src (modified) (1 prop)
-
ippTools/src/Makefile.am (modified) (3 diffs)
-
ippTools/src/bgtool.c (copied) (copied from branches/pap/ippTools/src/bgtool.c )
-
ippTools/src/bgtool.h (copied) (copied from branches/pap/ippTools/src/bgtool.h )
-
ippTools/src/bgtoolConfig.c (copied) (copied from branches/pap/ippTools/src/bgtoolConfig.c )
-
ippTools/src/pxtools.c (modified) (2 diffs)
-
ippTools/src/pxtools.h (modified) (1 diff)
-
ippconfig/recipes (modified) (1 prop)
-
ippconfig/recipes/Makefile.am (modified) (1 diff)
-
ippconfig/recipes/ppBackground.mdc (copied) (copied from branches/pap/ippconfig/recipes/ppBackground.mdc )
-
ippconfig/recipes/ppStatsFromMetadata.config (modified) (1 diff)
-
ippconfig/recipes/reductionClasses.mdc (modified) (1 diff)
-
ippconfig/system.config (modified) (1 diff)
-
psModules (modified) (1 prop)
-
psconfig/tagsets/ipp-2.9.dist (modified) (1 diff)
-
psphot (modified) (1 prop)
-
pstamp (modified) (1 prop)
-
pstamp/Makefile.am (modified) (1 diff)
-
pstamp/configure.ac (modified) (2 diffs)
-
pstamp/ppstamp.pc.in (copied) (copied from branches/pap/pstamp/ppstamp.pc.in )
Legend:
- Unmodified
- Added
- Removed
-
trunk
- Property svn:mergeinfo changed
/branches/pap merged: 28179,28188-28189,28195,28197,28199-28200,28441,28443,28454-28485
- Property svn:mergeinfo changed
-
trunk/Ohana
- Property svn:mergeinfo changed
/branches/pap/Ohana merged: 28484-28485
- Property svn:mergeinfo changed
-
trunk/dbconfig/changes.txt
r28428 r28486 1718 1718 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1719 1719 1720 1721 -- Tables to support background restoration 1722 -- Background replacement on a chipRun 1723 CREATE TABLE chipBackgroundRun ( 1724 chip_bg_id BIGINT AUTO_INCREMENT, -- unique identifier 1725 chip_id BIGINT NOT NULL, -- link to chipRun 1726 state VARCHAR(64) NOT NULL, -- state of run (new, full, etc.) 1727 workdir VARCHAR(255) NOT NULL, -- working directory 1728 label VARCHAR(64), -- processing label 1729 data_group VARCHAR(64), -- group for data 1730 dist_group VARCHAR(64), -- group for distribution 1731 reduction VARCHAR(64), -- reduction class (for altering recipe) 1732 note VARCHAR(255), -- note 1733 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered 1734 PRIMARY KEY(chip_bg_id), 1735 KEY(chip_id), 1736 KEY(state), 1737 KEY(label), 1738 KEY(data_group), 1739 KEY(dist_group), 1740 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id) 1741 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1742 1743 -- Results of background replacement from chipBackgroundRun 1744 CREATE TABLE chipBackgroundImfile ( 1745 chip_bg_id BIGINT NOT NULL, -- unique identifier 1746 class_id VARCHAR(64) NOT NULL, -- class (component) identifier 1747 path_base VARCHAR(255) NOT NULL, -- root name for outputs 1748 magicked BIGINT, -- magic_id if magicked 1749 dtime_script FLOAT, -- elapsed time for script 1750 hostname VARCHAR(64) NOT NULL, -- host that executed script 1751 quality SMALLINT NOT NULL, -- bad quality flag 1752 fault SMALLINT NOT NULL, -- fault code 1753 software_ver VARCHAR(16), -- software version 1754 bg FLOAT, -- background level 1755 bg_stdev FLOAT, -- stdev of background 1756 maskfrac_npix FLOAT, -- Number of pixels masked 1757 maskfrac_static FLOAT, -- Fraction masked static 1758 maskfrac_dynamic FLOAT, -- Fraction masked dynamic 1759 maskfrac_magic FLOAT, -- Fraction masked magic 1760 maskfrac_advisory FLOAT, -- Fraction masked advisory 1761 PRIMARY KEY(chip_bg_id,class_id), 1762 KEY(fault), 1763 KEY(quality), 1764 FOREIGN KEY(chip_bg_id) REFERENCES chipBackgroundRun(chip_bg_id) 1765 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1766 1767 -- Background replacement on a warpRun (utilising chipBackgroundRun) 1768 CREATE TABLE warpBackgroundRun ( 1769 warp_bg_id BIGINT AUTO_INCREMENT, -- unique identifier 1770 warp_id BIGINT NOT NULL, -- link to warpRun 1771 chip_bg_id BIGINT NOT NULL, -- link to chipBackgroundRun 1772 state VARCHAR(64) NOT NULL, -- state of run (new, full, etc.) 1773 workdir VARCHAR(255) NOT NULL, -- working directory 1774 label VARCHAR(64), -- processing label 1775 data_group VARCHAR(64), -- group for data 1776 dist_group VARCHAR(64), -- group for distribution 1777 reduction VARCHAR(64), -- reduction class (for altering recipe) 1778 note VARCHAR(255), -- note 1779 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered 1780 PRIMARY KEY(warp_bg_id), 1781 KEY(warp_id), 1782 KEY(chip_bg_id), 1783 KEY(state), 1784 KEY(label), 1785 KEY(data_group), 1786 KEY(dist_group), 1787 FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id), 1788 FOREIGN KEY(chip_bg_id) REFERENCES chipBackgroundRun(chip_bg_id) 1789 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1790 1791 -- Results of background replacement from warpBackgroundRun 1792 CREATE TABLE warpBackgroundSkyfile ( 1793 warp_bg_id BIGINT NOT NULL, -- unique identifier 1794 skycell_id VARCHAR(64) NOT NULL, -- skycell identifier 1795 path_base VARCHAR(255) NOT NULL, -- root name for outputs 1796 magicked BIGINT, -- magic_id if magicked 1797 dtime_script FLOAT, -- elapsed time for script 1798 hostname VARCHAR(64) NOT NULL, -- host that executed script 1799 quality SMALLINT NOT NULL, -- bad quality flag 1800 fault SMALLINT NOT NULL, -- fault code 1801 software_ver VARCHAR(16), -- software version 1802 bg FLOAT, -- background level 1803 bg_stdev FLOAT, -- stdev of background 1804 maskfrac_npix FLOAT, -- Number of pixels masked 1805 maskfrac_static FLOAT, -- Fraction masked static 1806 maskfrac_dynamic FLOAT, -- Fraction masked dynamic 1807 maskfrac_magic FLOAT, -- Fraction masked magic 1808 maskfrac_advisory FLOAT, -- Fraction masked advisory 1809 PRIMARY KEY(warp_bg_id,skycell_id), 1810 KEY(fault), 1811 KEY(quality), 1812 FOREIGN KEY(warp_bg_id) REFERENCES warpBackgroundRun(warp_bg_id) 1813 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1814 1815 1720 1816 -- Version 1.1.68 addition of minidvodb tables and changes to addTables 1721 1817 -
trunk/dbconfig/ipp.m4
r28343 r28486 33 33 include(receive.md) 34 34 include(publish.md) 35 include(background.md) 35 36 include(diffphot.md) -
trunk/ippScripts/Build.PL
r28375 r28486 109 109 scripts/bundle_detrends.pl 110 110 scripts/ipp_cluster_load_monitor.pl 111 scripts/background_chip.pl 112 scripts/background_warp.pl 111 113 scripts/skycell_jpeg.pl 112 114 scripts/diffphot.pl -
trunk/ippTasks/Makefile.am
r28344 r28486 35 35 nightly_stacks.pro \ 36 36 lossy_compress.pro \ 37 background.pro \ 37 38 diffphot.pro 38 39 -
trunk/ippTools/configure.ac
r26566 r28486 19 19 PKG_CHECK_MODULES([PSMODULES], [psmodules >= 1.1.0]) 20 20 PKG_CHECK_MODULES([IPPDB], [ippdb >= 1.1.63]) 21 PKG_CHECK_MODULES([PPSTAMP], [ippdb >= 1.1.63]) 21 22 22 PXTOOLS_CFLAGS="${PSLIB_CFLAGS=} ${PSMODULES_CFLAGS=} ${ IPPDB_CFLAGS=}"23 PXTOOLS_CFLAGS="${PSLIB_CFLAGS=} ${PSMODULES_CFLAGS=} ${PPSTAMP_CFLAGS=} ${IPPDB_CFLAGS=}" 23 24 PXTOOLS_LIBS="${PSLIB_LIBS=} ${PSMODULES_LIBS=} ${IPPDB_LIBS=}" 24 25 AC_SUBST(PXTOOLS_CFLAGS,[$PXTOOLS_CFLAGS]) -
trunk/ippTools/share/Makefile.am
r28412 r28486 4 4 5 5 dist_pkgdata_DATA = \ 6 addtool_checkminidvodbaddrun.sql \ 7 addtool_donecleanup.sql \ 8 addtool_find_cam_id.sql \ 9 addtool_find_pendingexp.sql \ 10 addtool_find_pendingmergeprocess.sql \ 11 addtool_find_processedexp.sql \ 12 addtool_find_minidvodbprocessed.sql \ 13 addtool_find_minidvodbrun.sql \ 14 addtool_pendingcleanupexp.sql \ 15 addtool_pendingcleanuprun.sql \ 16 addtool_queue_cam_id.sql \ 17 addtool_queue_minidvodbrun.sql \ 18 addtool_revertminidvodbprocessed.sql \ 19 addtool_revertprocessedexp.sql \ 20 camtool_addprocessedexp.sql \ 21 camtool_donecleanup.sql \ 22 camtool_find_chip_id.sql \ 23 camtool_pendingexp.sql \ 24 camtool_find_pendingimfile.sql \ 25 camtool_find_processedexp.sql \ 26 camtool_pendingcleanupexp.sql \ 27 camtool_pendingcleanuprun.sql \ 28 camtool_queue_chip_id.sql \ 29 camtool_revertprocessedexp.sql \ 30 camtool_export_run.sql \ 31 camtool_export_processed_exp.sql \ 32 chiptool_change_exp_state.sql \ 33 chiptool_change_imfile_data_state.sql \ 34 chiptool_completely_processed_exp.sql \ 35 chiptool_coalesce_run.sql \ 36 chiptool_definecopy.sql \ 37 chiptool_donecleanup.sql \ 38 chiptool_find_rawexp.sql \ 39 chiptool_listrun.sql \ 40 chiptool_pendingcleanupimfile.sql \ 41 chiptool_pendingcleanuprun.sql \ 42 chiptool_pendingimfile.sql \ 43 chiptool_processedimfile.sql \ 44 chiptool_revertprocessedimfile.sql \ 45 chiptool_revertupdatedimfile.sql \ 46 chiptool_run.sql \ 47 chiptool_runstate.sql \ 48 chiptool_setimfiletoupdate.sql \ 49 chiptool_export_run.sql \ 50 chiptool_export_imfile.sql \ 51 chiptool_export_processed_imfile.sql \ 52 chiptool_unmasked.sql \ 53 detselect_search.sql \ 54 detselect_select.sql \ 55 dettool_addprocessedexp.sql \ 56 dettool_childlessrun.sql \ 57 dettool_definebydetrun.sql \ 58 dettool_detrunsummary.sql \ 59 dettool_find_completed_runs.sql \ 60 dettool_input.sql \ 61 dettool_normalizedexp.sql \ 62 dettool_normalizedimfile.sql \ 63 dettool_normalizedstat.sql \ 64 dettool_pending.sql \ 65 dettool_pendingcleanup_detrunsummary.sql \ 66 dettool_pendingcleanup_normalizedexp.sql \ 67 dettool_pendingcleanup_normalizedimfile.sql \ 68 dettool_pendingcleanup_normalizedstat.sql \ 69 dettool_pendingcleanup_processedexp.sql \ 70 dettool_pendingcleanup_processedimfile.sql \ 71 dettool_pendingcleanup_residexp.sql \ 72 dettool_pendingcleanup_residimfile.sql \ 73 dettool_pendingcleanup_stacked.sql \ 74 dettool_processedimfile.sql \ 75 dettool_raw.sql \ 76 dettool_residexp.sql \ 77 dettool_residimfile.sql \ 78 dettool_revertdetrunsummary.sql \ 79 dettool_revertnormalizedexp.sql \ 80 dettool_revertnormalizedimfile.sql \ 81 dettool_revertnormalizedstat.sql \ 82 dettool_revertprocessedexp.sql \ 83 dettool_revertprocessedimfile.sql \ 84 dettool_revertresidexp.sql \ 85 dettool_revertresidimfile.sql \ 86 dettool_revertstacked.sql \ 87 dettool_runs.sql \ 88 dettool_stacked.sql \ 89 dettool_start_new_iteration.sql \ 90 dettool_stop_completed_correct_runs.sql \ 91 dettool_tocorrectexp.sql \ 92 dettool_tocorrectimfile.sql \ 93 dettool_todetrunsummary.sql \ 94 dettool_tonormalize.sql \ 95 dettool_tonormalizedexp.sql \ 96 dettool_tonormalizedstat.sql \ 97 dettool_toprocessedexp.sql \ 98 dettool_toprocessedimfile.sql \ 99 dettool_toresidexp.sql \ 100 dettool_toresidimfile.sql \ 101 dettool_tostacked.sql \ 102 difftool_change_skyfile_data_state.sql \ 103 difftool_change_run_state.sql \ 104 difftool_completed_runs.sql \ 105 difftool_coalesce_run.sql \ 106 difftool_definewarpstack_part1.sql \ 107 difftool_definewarpstack_part2.sql \ 108 difftool_definewarpstack_temp_create.sql \ 109 difftool_definewarpwarp_temp_create.sql \ 110 difftool_definewarpwarp_temp_insert.sql \ 111 difftool_definewarpwarp_select.sql \ 112 difftool_definewarpwarp_insert.sql \ 113 difftool_definestackstack_part0.sql \ 114 difftool_definestackstack_part1.sql \ 115 difftool_donecleanup.sql \ 116 difftool_export_input_skyfile.sql \ 117 difftool_export_run.sql \ 118 difftool_export_skyfile.sql \ 119 difftool_inputskyfile.sql \ 120 difftool_listrun.sql \ 121 difftool_pendingcleanuprun.sql \ 122 difftool_pendingcleanupskyfile.sql \ 123 difftool_revertdiffskyfile_delete.sql \ 124 difftool_revertdiffskyfile_updated.sql \ 125 difftool_setskyfiletoupdate.sql \ 126 difftool_skyfile.sql \ 127 difftool_todiffskyfile.sql \ 128 difftool_tosummary.sql \ 129 difftool_addsummary.sql \ 130 disttool_definebyquery_camera.sql \ 131 disttool_definebyquery_chip.sql \ 132 disttool_definebyquery_diff.sql \ 133 disttool_definebyquery_fake.sql \ 134 disttool_definebyquery_raw.sql \ 135 disttool_definebyquery_stack.sql \ 136 disttool_definebyquery_warp.sql \ 137 disttool_definebyquery_SSdiff.sql \ 138 disttool_defineinterest.sql \ 139 disttool_listfilesets.sql \ 140 disttool_listinterests.sql \ 141 disttool_pending_camera.sql \ 142 disttool_pending_chip.sql \ 143 disttool_pending_diff.sql \ 144 disttool_pending_fake.sql \ 145 disttool_pending_raw.sql \ 146 disttool_pending_stack.sql \ 147 disttool_pending_warp.sql \ 148 disttool_pending_SSdiff.sql \ 149 disttool_pendingfileset.sql \ 150 disttool_pendingdest.sql \ 151 disttool_pendingcleanup.sql \ 152 disttool_processedcomponent.sql \ 153 disttool_queuercrun.sql \ 154 disttool_revertrcrun.sql \ 155 disttool_revertrun.sql \ 156 disttool_revertcomponent.sql \ 157 disttool_revertfileset.sql \ 158 disttool_toadvance.sql \ 159 disttool_updateinterest.sql \ 160 disttool_updatercrun.sql \ 161 dqstatstool_createbundle.sql \ 162 dqstatstool_definebyquery.sql \ 163 dqstatstool_get_contents.sql \ 164 dqstatstool_get_run.sql \ 165 faketool_change_exp_state.sql \ 166 faketool_change_imfile_data_state.sql \ 167 faketool_completely_processed_exp.sql \ 168 faketool_donecleanup.sql \ 169 faketool_export_processed_imfile.sql \ 170 faketool_export_run.sql \ 171 faketool_find_camrun.sql \ 172 faketool_find_pendingexp.sql \ 173 faketool_pendingcleanupimfile.sql \ 174 faketool_pendingcleanuprun.sql \ 175 faketool_pendingimfile.sql \ 176 faketool_processedimfile.sql \ 177 faketool_queue_cam_id.sql \ 178 faketool_revertprocessedimfile.sql \ 179 faketool_unmasked.sql \ 180 flatcorr_chiprundone.sql \ 181 flatcorr_camerarundone.sql \ 182 flatcorr_pendingprocess.sql \ 183 flatcorr_inputimfile.sql \ 184 flatcorr_dropchip.sql \ 185 flatcorr_dropcamera.sql \ 186 magictool_addmask.sql \ 187 magictool_restore_camera.sql \ 188 magictool_restore_chip.sql \ 189 magictool_restore_diff.sql \ 190 magictool_restore_raw.sql \ 191 magictool_restore_warp.sql \ 192 magictool_create_tmp_warpcomplete.sql \ 193 magictool_definebyquery_insert.sql \ 194 magictool_definebyquery_select.sql \ 195 magictool_inputs.sql \ 196 magictool_inputskyfile.sql \ 197 magictool_mask.sql \ 198 magictool_tomask.sql \ 199 magictool_toprocess_inputs.sql \ 200 magictool_toprocess_runs.sql \ 201 magictool_toprocess_tree.sql \ 202 magictool_toskyfilemask.sql \ 203 magictool_totree.sql \ 204 magictool_diffskyfile.sql \ 205 magictool_warpskyfile.sql \ 206 magictool_chipprocessedimfile.sql \ 207 magictool_rawimfile.sql \ 208 magictool_revertnode.sql \ 209 magictool_exposure.sql \ 210 magicdstool_clearstatefaults.sql \ 211 magicdstool_completed_runs.sql \ 212 magicdstool_completedrevert.sql \ 213 magicdstool_definebyquery_raw.sql \ 214 magicdstool_definebyquery_chip.sql \ 215 magicdstool_definebyquery_camera.sql \ 216 magicdstool_definebyquery_warp.sql \ 217 magicdstool_definebyquery_diff.sql \ 218 magicdstool_definecopy_chip.sql \ 219 magicdstool_definecopy_warp.sql \ 220 magicdstool_getrunids.sql \ 221 magicdstool_getskycells.sql \ 222 magicdstool_revertdestreakedfile.sql \ 223 magicdstool_tocleanup.sql \ 224 magicdstool_todestreak_camera.sql \ 225 magicdstool_todestreak_chip.sql \ 226 magicdstool_todestreak_diff.sql \ 227 magicdstool_todestreak_raw.sql \ 228 magicdstool_todestreak_warp.sql \ 229 magicdstool_toremove.sql \ 230 magicdstool_torevert_raw.sql \ 231 magicdstool_torevert_chip.sql \ 232 magicdstool_torevert_camera.sql \ 233 magicdstool_torevert_warp.sql \ 234 magicdstool_torevert_diff.sql \ 235 pstamptool_completedreq.sql \ 236 pstamptool_datastore.sql \ 237 pstamptool_getdependent.sql \ 238 pstamptool_listjob.sql \ 239 pstamptool_pendingcleanup.sql \ 240 pstamptool_pendingdependent.sql \ 241 pstamptool_pendingjob.sql \ 242 pstamptool_pendingreq.sql \ 243 pstamptool_project.sql \ 244 pstamptool_revertdependent.sql \ 245 pstamptool_revertjob.sql \ 246 pstamptool_revertreq.sql \ 247 pstamptool_revertreq_deletejobs.sql \ 248 pstamptool_updatejob.sql \ 249 pxadmin_create_tables.sql \ 250 pxadmin_create_mirror_tables.sql \ 251 pxadmin_drop_tables.sql \ 252 pxadmin_update_version.sql \ 253 pubtool_definerun.sql \ 254 pubtool_pending.sql \ 255 pubtool_revert.sql \ 256 pztool_find_completed_exp.sql \ 257 pztool_pendingimfile.sql \ 258 pztool_revert_downloadimfile_faults.sql \ 259 pztool_revert_fileset_faults.sql \ 260 pztool_revertcopied.sql \ 261 receivetool_list.sql \ 262 receivetool_addfileset.sql \ 263 receivetool_pendingfileset.sql \ 264 receivetool_pendingfile.sql \ 265 receivetool_revert.sql \ 266 receivetool_toadvance.sql \ 267 regtool_create_dup_table.sql \ 268 regtool_export_exp.sql \ 269 regtool_export_imfile.sql \ 270 regtool_pendingexp.sql \ 271 regtool_pendingimfile.sql \ 272 regtool_populate_dup_table.sql \ 273 regtool_processedexp.sql \ 274 regtool_processedimfile.sql \ 275 regtool_revertprocessedexp.sql \ 276 regtool_revertprocessedimfile.sql \ 277 regtool_updateprocessedimfile.sql \ 278 regtool_pendingcompressimfile.sql \ 279 regtool_finishcompressexp.sql \ 280 regtool_updatebyquery.sql \ 281 regtool_updatebyqueryimfile.sql \ 282 stacktool_associationdefine_select.sql \ 283 stacktool_definebyquery_insert.sql \ 284 stacktool_definebyquery_insert_random_part1.sql \ 285 stacktool_definebyquery_insert_random_part2.sql \ 286 stacktool_definebyquery_select.sql \ 287 stacktool_definebyquery_test.sql \ 288 stacktool_donecleanup.sql \ 289 stacktool_export_input_skyfile.sql \ 290 stacktool_export_run.sql \ 291 stacktool_export_sum_skyfile.sql \ 292 stacktool_find_complete_warps.sql \ 293 stacktool_inputskyfile.sql \ 294 stacktool_pendingcleanuprun.sql \ 295 stacktool_pendingcleanupskyfile.sql \ 296 stacktool_revertsumskyfile_delete.sql \ 297 stacktool_sumskyfile.sql \ 298 stacktool_sassskyfile.sql \ 299 stacktool_tosum.sql \ 300 stacktool_tosummary.sql \ 301 stacktool_addsummary.sql \ 302 staticskytool_definebyquery_select.sql \ 303 staticskytool_definebyquery_inputs.sql \ 304 staticskytool_inputs.sql \ 305 staticskytool_todo.sql \ 306 staticskytool_result.sql \ 307 staticskytool_revert.sql \ 308 warptool_change_skyfile_data_state.sql \ 309 warptool_change_run_state.sql \ 310 warptool_definebyquery.sql \ 311 warptool_donecleanup.sql \ 312 warptool_exp.sql \ 313 warptool_export_imfile.sql \ 314 warptool_export_run.sql \ 315 warptool_export_skyfile.sql \ 316 warptool_export_skycell_map.sql \ 317 warptool_finished_run_select.sql \ 318 warptool_finish_run.sql \ 319 warptool_coalesce_run.sql \ 320 warptool_imfile.sql \ 321 warptool_listrun.sql \ 322 warptool_pendingcleanuprun.sql \ 323 warptool_pendingcleanupskyfile.sql \ 324 warptool_revertoverlap.sql \ 325 warptool_revertwarped_delete.sql \ 326 warptool_revertwarped_updated.sql \ 327 warptool_runstate.sql \ 328 warptool_scmap.sql \ 329 warptool_setskyfiletoupdate.sql \ 330 warptool_tooverlap.sql \ 331 warptool_towarped.sql \ 332 warptool_updateskyfile.sql \ 333 warptool_warped.sql \ 334 warptool_tosummary.sql \ 335 warptool_addsummary.sql \ 6 addtool_checkminidvodbaddrun.sql \ 7 addtool_donecleanup.sql \ 8 addtool_find_cam_id.sql \ 9 addtool_find_pendingexp.sql \ 10 addtool_find_pendingmergeprocess.sql \ 11 addtool_find_processedexp.sql \ 12 addtool_find_minidvodbprocessed.sql \ 13 addtool_find_minidvodbrun.sql \ 14 addtool_pendingcleanupexp.sql \ 15 addtool_pendingcleanuprun.sql \ 16 addtool_queue_cam_id.sql \ 17 addtool_queue_minidvodbrun.sql \ 18 addtool_revertminidvodbprocessed.sql \ 19 addtool_revertprocessedexp.sql \ 20 bgtool_advancechip.sql \ 21 bgtool_advancewarp.sql \ 22 bgtool_chipinputs.sql \ 23 bgtool_chip.sql \ 24 bgtool_cleanedchip.sql \ 25 bgtool_cleanedwarp.sql \ 26 bgtool_definechip.sql \ 27 bgtool_definewarp.sql \ 28 bgtool_revertchip.sql \ 29 bgtool_revertwarp.sql \ 30 bgtool_tochip.sql \ 31 bgtool_tocleanchip.sql \ 32 bgtool_tocleanwarp.sql \ 33 bgtool_towarp.sql \ 34 bgtool_warpinputs.sql \ 35 bgtool_warp.sql \ 36 camtool_donecleanup.sql \ 37 camtool_find_chip_id.sql \ 38 camtool_pendingexp.sql \ 39 camtool_find_pendingimfile.sql \ 40 camtool_find_processedexp.sql \ 41 camtool_pendingcleanupexp.sql \ 42 camtool_pendingcleanuprun.sql \ 43 camtool_queue_chip_id.sql \ 44 camtool_revertprocessedexp.sql \ 45 camtool_export_run.sql \ 46 camtool_export_processed_exp.sql \ 47 chiptool_change_exp_state.sql \ 48 chiptool_change_imfile_data_state.sql \ 49 chiptool_completely_processed_exp.sql \ 50 chiptool_coalesce_run.sql \ 51 chiptool_definecopy.sql \ 52 chiptool_donecleanup.sql \ 53 chiptool_find_rawexp.sql \ 54 chiptool_listrun.sql \ 55 chiptool_pendingcleanupimfile.sql \ 56 chiptool_pendingcleanuprun.sql \ 57 chiptool_pendingimfile.sql \ 58 chiptool_processedimfile.sql \ 59 chiptool_revertprocessedimfile.sql \ 60 chiptool_revertupdatedimfile.sql \ 61 chiptool_run.sql \ 62 chiptool_runstate.sql \ 63 chiptool_setimfiletoupdate.sql \ 64 chiptool_export_run.sql \ 65 chiptool_export_imfile.sql \ 66 chiptool_export_processed_imfile.sql \ 67 chiptool_unmasked.sql \ 68 detselect_search.sql \ 69 detselect_select.sql \ 70 dettool_addprocessedexp.sql \ 71 dettool_childlessrun.sql \ 72 dettool_definebydetrun.sql \ 73 dettool_detrunsummary.sql \ 74 dettool_find_completed_runs.sql \ 75 dettool_input.sql \ 76 dettool_normalizedexp.sql \ 77 dettool_normalizedimfile.sql \ 78 dettool_normalizedstat.sql \ 79 dettool_pending.sql \ 80 dettool_pendingcleanup_detrunsummary.sql \ 81 dettool_pendingcleanup_normalizedexp.sql \ 82 dettool_pendingcleanup_normalizedimfile.sql \ 83 dettool_pendingcleanup_normalizedstat.sql \ 84 dettool_pendingcleanup_processedexp.sql \ 85 dettool_pendingcleanup_processedimfile.sql \ 86 dettool_pendingcleanup_residexp.sql \ 87 dettool_pendingcleanup_residimfile.sql \ 88 dettool_pendingcleanup_stacked.sql \ 89 dettool_processedimfile.sql \ 90 dettool_raw.sql \ 91 dettool_residexp.sql \ 92 dettool_residimfile.sql \ 93 dettool_revertdetrunsummary.sql \ 94 dettool_revertnormalizedexp.sql \ 95 dettool_revertnormalizedimfile.sql \ 96 dettool_revertnormalizedstat.sql \ 97 dettool_revertprocessedexp.sql \ 98 dettool_revertprocessedimfile.sql \ 99 dettool_revertresidexp.sql \ 100 dettool_revertresidimfile.sql \ 101 dettool_revertstacked.sql \ 102 dettool_runs.sql \ 103 dettool_stacked.sql \ 104 dettool_start_new_iteration.sql \ 105 dettool_stop_completed_correct_runs.sql \ 106 dettool_tocorrectexp.sql \ 107 dettool_tocorrectimfile.sql \ 108 dettool_todetrunsummary.sql \ 109 dettool_tonormalize.sql \ 110 dettool_tonormalizedexp.sql \ 111 dettool_tonormalizedstat.sql \ 112 dettool_toprocessedexp.sql \ 113 dettool_toprocessedimfile.sql \ 114 dettool_toresidexp.sql \ 115 dettool_toresidimfile.sql \ 116 dettool_tostacked.sql \ 117 difftool_change_skyfile_data_state.sql \ 118 difftool_change_run_state.sql \ 119 difftool_completed_runs.sql \ 120 difftool_coalesce_run.sql \ 121 difftool_definewarpstack_part1.sql \ 122 difftool_definewarpstack_part2.sql \ 123 difftool_definewarpstack_temp_create.sql \ 124 difftool_definewarpwarp_temp_create.sql \ 125 difftool_definewarpwarp_temp_insert.sql \ 126 difftool_definewarpwarp_select.sql \ 127 difftool_definewarpwarp_insert.sql \ 128 difftool_definestackstack_part0.sql \ 129 difftool_definestackstack_part1.sql \ 130 difftool_donecleanup.sql \ 131 difftool_export_input_skyfile.sql \ 132 difftool_export_run.sql \ 133 difftool_export_skyfile.sql \ 134 difftool_inputskyfile.sql \ 135 difftool_listrun.sql \ 136 difftool_pendingcleanuprun.sql \ 137 difftool_pendingcleanupskyfile.sql \ 138 difftool_revertdiffskyfile_delete.sql \ 139 difftool_revertdiffskyfile_updated.sql \ 140 difftool_setskyfiletoupdate.sql \ 141 difftool_skyfile.sql \ 142 difftool_todiffskyfile.sql \ 143 difftool_tosummary.sql \ 144 difftool_addsummary.sql \ 145 disttool_definebyquery_camera.sql \ 146 disttool_definebyquery_chip.sql \ 147 disttool_definebyquery_diff.sql \ 148 disttool_definebyquery_fake.sql \ 149 disttool_definebyquery_raw.sql \ 150 disttool_definebyquery_stack.sql \ 151 disttool_definebyquery_warp.sql \ 152 disttool_definebyquery_SSdiff.sql \ 153 disttool_defineinterest.sql \ 154 disttool_listfilesets.sql \ 155 disttool_listinterests.sql \ 156 disttool_pending_camera.sql \ 157 disttool_pending_chip.sql \ 158 disttool_pending_diff.sql \ 159 disttool_pending_fake.sql \ 160 disttool_pending_raw.sql \ 161 disttool_pending_stack.sql \ 162 disttool_pending_warp.sql \ 163 disttool_pending_SSdiff.sql \ 164 disttool_pendingfileset.sql \ 165 disttool_pendingdest.sql \ 166 disttool_pendingcleanup.sql \ 167 disttool_processedcomponent.sql \ 168 disttool_queuercrun.sql \ 169 disttool_revertrcrun.sql \ 170 disttool_revertrun.sql \ 171 disttool_revertcomponent.sql \ 172 disttool_revertfileset.sql \ 173 disttool_toadvance.sql \ 174 disttool_updateinterest.sql \ 175 disttool_updatercrun.sql \ 176 dqstatstool_createbundle.sql \ 177 dqstatstool_definebyquery.sql \ 178 dqstatstool_get_contents.sql \ 179 dqstatstool_get_run.sql \ 180 faketool_change_exp_state.sql \ 181 faketool_change_imfile_data_state.sql \ 182 faketool_completely_processed_exp.sql \ 183 faketool_donecleanup.sql \ 184 faketool_export_processed_imfile.sql \ 185 faketool_export_run.sql \ 186 faketool_find_camrun.sql \ 187 faketool_find_pendingexp.sql \ 188 faketool_pendingcleanupimfile.sql \ 189 faketool_pendingcleanuprun.sql \ 190 faketool_pendingimfile.sql \ 191 faketool_processedimfile.sql \ 192 faketool_queue_cam_id.sql \ 193 faketool_revertprocessedimfile.sql \ 194 faketool_unmasked.sql \ 195 flatcorr_chiprundone.sql \ 196 flatcorr_camerarundone.sql \ 197 flatcorr_pendingprocess.sql \ 198 flatcorr_inputimfile.sql \ 199 flatcorr_dropchip.sql \ 200 flatcorr_dropcamera.sql \ 201 magictool_addmask.sql \ 202 magictool_restore_camera.sql \ 203 magictool_restore_chip.sql \ 204 magictool_restore_diff.sql \ 205 magictool_restore_raw.sql \ 206 magictool_restore_warp.sql \ 207 magictool_create_tmp_warpcomplete.sql \ 208 magictool_definebyquery_insert.sql \ 209 magictool_definebyquery_select.sql \ 210 magictool_inputs.sql \ 211 magictool_inputskyfile.sql \ 212 magictool_mask.sql \ 213 magictool_tomask.sql \ 214 magictool_toprocess_inputs.sql \ 215 magictool_toprocess_runs.sql \ 216 magictool_toprocess_tree.sql \ 217 magictool_toskyfilemask.sql \ 218 magictool_totree.sql \ 219 magictool_diffskyfile.sql \ 220 magictool_warpskyfile.sql \ 221 magictool_chipprocessedimfile.sql \ 222 magictool_rawimfile.sql \ 223 magictool_revertnode.sql \ 224 magictool_exposure.sql \ 225 magicdstool_clearstatefaults.sql \ 226 magicdstool_completed_runs.sql \ 227 magicdstool_completedrevert.sql \ 228 magicdstool_definebyquery_raw.sql \ 229 magicdstool_definebyquery_chip.sql \ 230 magicdstool_definebyquery_camera.sql \ 231 magicdstool_definebyquery_warp.sql \ 232 magicdstool_definebyquery_diff.sql \ 233 magicdstool_definecopy_chip.sql \ 234 magicdstool_definecopy_warp.sql \ 235 magicdstool_getrunids.sql \ 236 magicdstool_getskycells.sql \ 237 magicdstool_revertdestreakedfile.sql \ 238 magicdstool_tocleanup.sql \ 239 magicdstool_todestreak_camera.sql \ 240 magicdstool_todestreak_chip.sql \ 241 magicdstool_todestreak_diff.sql \ 242 magicdstool_todestreak_raw.sql \ 243 magicdstool_todestreak_warp.sql \ 244 magicdstool_toremove.sql \ 245 magicdstool_torevert_raw.sql \ 246 magicdstool_torevert_chip.sql \ 247 magicdstool_torevert_camera.sql \ 248 magicdstool_torevert_warp.sql \ 249 magicdstool_torevert_diff.sql \ 250 pstamptool_completedreq.sql \ 251 pstamptool_datastore.sql \ 252 pstamptool_getdependent.sql \ 253 pstamptool_listjob.sql \ 254 pstamptool_pendingcleanup.sql \ 255 pstamptool_pendingdependent.sql \ 256 pstamptool_pendingjob.sql \ 257 pstamptool_pendingreq.sql \ 258 pstamptool_project.sql \ 259 pstamptool_revertdependent.sql \ 260 pstamptool_revertjob.sql \ 261 pstamptool_revertreq.sql \ 262 pstamptool_revertreq_deletejobs.sql \ 263 pstamptool_updatejob.sql \ 264 pxadmin_create_tables.sql \ 265 pxadmin_create_mirror_tables.sql \ 266 pxadmin_drop_tables.sql \ 267 pxadmin_update_version.sql \ 268 pubtool_definerun.sql \ 269 pubtool_pending.sql \ 270 pubtool_revert.sql \ 271 pztool_find_completed_exp.sql \ 272 pztool_pendingimfile.sql \ 273 pztool_revert_downloadimfile_faults.sql \ 274 pztool_revert_fileset_faults.sql \ 275 pztool_revertcopied.sql \ 276 receivetool_list.sql \ 277 receivetool_addfileset.sql \ 278 receivetool_pendingfileset.sql \ 279 receivetool_pendingfile.sql \ 280 receivetool_revert.sql \ 281 receivetool_toadvance.sql \ 282 regtool_create_dup_table.sql \ 283 regtool_export_exp.sql \ 284 regtool_export_imfile.sql \ 285 regtool_pendingexp.sql \ 286 regtool_pendingimfile.sql \ 287 regtool_populate_dup_table.sql \ 288 regtool_processedexp.sql \ 289 regtool_processedimfile.sql \ 290 regtool_revertprocessedexp.sql \ 291 regtool_revertprocessedimfile.sql \ 292 regtool_updateprocessedimfile.sql \ 293 regtool_pendingcompressimfile.sql \ 294 regtool_finishcompressexp.sql \ 295 regtool_updatebyquery.sql \ 296 regtool_updatebyqueryimfile.sql \ 297 stacktool_associationdefine_select.sql \ 298 stacktool_definebyquery_insert.sql \ 299 stacktool_definebyquery_insert_random_part1.sql \ 300 stacktool_definebyquery_insert_random_part2.sql \ 301 stacktool_definebyquery_select.sql \ 302 stacktool_definebyquery_test.sql \ 303 stacktool_donecleanup.sql \ 304 stacktool_export_input_skyfile.sql \ 305 stacktool_export_run.sql \ 306 stacktool_export_sum_skyfile.sql \ 307 stacktool_find_complete_warps.sql \ 308 stacktool_inputskyfile.sql \ 309 stacktool_pendingcleanuprun.sql \ 310 stacktool_pendingcleanupskyfile.sql \ 311 stacktool_revertsumskyfile_delete.sql \ 312 stacktool_sumskyfile.sql \ 313 stacktool_sassskyfile.sql \ 314 stacktool_tosum.sql \ 315 stacktool_tosummary.sql \ 316 stacktool_addsummary.sql \ 317 staticskytool_definebyquery_select.sql \ 318 staticskytool_definebyquery_inputs.sql \ 319 staticskytool_inputs.sql \ 320 staticskytool_todo.sql \ 321 staticskytool_result.sql \ 322 staticskytool_revert.sql \ 323 warptool_change_skyfile_data_state.sql \ 324 warptool_change_run_state.sql \ 325 warptool_definebyquery.sql \ 326 warptool_donecleanup.sql \ 327 warptool_exp.sql \ 328 warptool_export_imfile.sql \ 329 warptool_export_run.sql \ 330 warptool_export_skyfile.sql \ 331 warptool_export_skycell_map.sql \ 332 warptool_finished_run_select.sql \ 333 warptool_finish_run.sql \ 334 warptool_coalesce_run.sql \ 335 warptool_imfile.sql \ 336 warptool_listrun.sql \ 337 warptool_pendingcleanuprun.sql \ 338 warptool_pendingcleanupskyfile.sql \ 339 warptool_revertoverlap.sql \ 340 warptool_revertwarped_delete.sql \ 341 warptool_revertwarped_updated.sql \ 342 warptool_runstate.sql \ 343 warptool_scmap.sql \ 344 warptool_setskyfiletoupdate.sql \ 345 warptool_tooverlap.sql \ 346 warptool_towarped.sql \ 347 warptool_updateskyfile.sql \ 348 warptool_warped.sql \ 349 warptool_tosummary.sql \ 350 warptool_addsummary.sql \ 336 351 diffphottool_definerun.sql \ 337 352 diffphottool_input.sql \ -
trunk/ippTools/share/pxadmin_create_tables.sql
r28428 r28486 1715 1715 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1716 1716 1717 1718 -- Processing labels with their priorities 1717 1719 CREATE TABLE Label ( 1718 1720 label VARCHAR(64), … … 1723 1725 KEY(priority), 1724 1726 KEY(active) 1727 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1728 1729 -- Tables to support background restoration 1730 1731 -- Background replacement on a chipRun 1732 CREATE TABLE chipBackgroundRun ( 1733 chip_bg_id BIGINT AUTO_INCREMENT, -- unique identifier 1734 chip_id BIGINT NOT NULL, -- link to chipRun 1735 state VARCHAR(64) NOT NULL, -- state of run (new, full, etc.) 1736 workdir VARCHAR(255) NOT NULL, -- working directory 1737 label VARCHAR(64), -- processing label 1738 data_group VARCHAR(64), -- group for data 1739 dist_group VARCHAR(64), -- group for distribution 1740 reduction VARCHAR(64), -- reduction class (for altering recipe) 1741 note VARCHAR(255), -- note 1742 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered 1743 magicked BIGINT DEFAULT 0 NOT NULL, -- magic status 1744 PRIMARY KEY(chip_bg_id), 1745 KEY(chip_id), 1746 KEY(state), 1747 KEY(label), 1748 KEY(data_group), 1749 KEY(dist_group), 1750 FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id) 1751 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1752 1753 -- Results of background replacement from chipBackgroundRun 1754 CREATE TABLE chipBackgroundImfile ( 1755 chip_bg_id BIGINT NOT NULL, -- unique identifier 1756 class_id VARCHAR(64) NOT NULL, -- class (component) identifier 1757 path_base VARCHAR(255) NOT NULL, -- root name for outputs 1758 magicked BIGINT, -- magic_id if magicked 1759 dtime_script FLOAT, -- elapsed time for script 1760 hostname VARCHAR(64) NOT NULL, -- host that executed script 1761 quality SMALLINT NOT NULL, -- bad quality flag 1762 fault SMALLINT NOT NULL, -- fault code 1763 software_ver VARCHAR(16), -- software version 1764 bg FLOAT, -- background level 1765 bg_stdev FLOAT, -- stdev of background 1766 maskfrac_npix FLOAT, -- Number of pixels masked 1767 maskfrac_static FLOAT, -- Fraction masked static 1768 maskfrac_dynamic FLOAT, -- Fraction masked dynamic 1769 maskfrac_magic FLOAT, -- Fraction masked magic 1770 maskfrac_advisory FLOAT, -- Fraction masked advisory 1771 PRIMARY KEY(chip_bg_id,class_id), 1772 KEY(fault), 1773 KEY(quality), 1774 FOREIGN KEY(chip_bg_id) REFERENCES chipBackgroundRun(chip_bg_id) 1775 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1776 1777 -- Background replacement on a warpRun (utilising chipBackgroundRun) 1778 CREATE TABLE warpBackgroundRun ( 1779 warp_bg_id BIGINT AUTO_INCREMENT, -- unique identifier 1780 warp_id BIGINT NOT NULL, -- link to warpRun 1781 chip_bg_id BIGINT NOT NULL, -- link to chipBackgroundRun 1782 state VARCHAR(64) NOT NULL, -- state of run (new, full, etc.) 1783 workdir VARCHAR(255) NOT NULL, -- working directory 1784 label VARCHAR(64), -- processing label 1785 data_group VARCHAR(64), -- group for data 1786 dist_group VARCHAR(64), -- group for distribution 1787 reduction VARCHAR(64), -- reduction class (for altering recipe) 1788 note VARCHAR(255), -- note 1789 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered 1790 magicked BIGINT DEFAULT 0 NOT NULL, -- magic status 1791 PRIMARY KEY(warp_bg_id), 1792 KEY(warp_id), 1793 KEY(chip_bg_id), 1794 KEY(state), 1795 KEY(label), 1796 KEY(data_group), 1797 KEY(dist_group), 1798 FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id), 1799 FOREIGN KEY(chip_bg_id) REFERENCES chipBackgroundRun(chip_bg_id) 1800 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1801 1802 -- Results of background replacement from warpBackgroundRun 1803 CREATE TABLE warpBackgroundSkyfile ( 1804 warp_bg_id BIGINT NOT NULL, -- unique identifier 1805 skycell_id VARCHAR(64) NOT NULL, -- skycell identifier 1806 path_base VARCHAR(255) NOT NULL, -- root name for outputs 1807 magicked BIGINT, -- magic_id if magicked 1808 dtime_script FLOAT, -- elapsed time for script 1809 hostname VARCHAR(64) NOT NULL, -- host that executed script 1810 quality SMALLINT NOT NULL, -- bad quality flag 1811 fault SMALLINT NOT NULL, -- fault code 1812 software_ver VARCHAR(16), -- software version 1813 bg FLOAT, -- background level 1814 bg_stdev FLOAT, -- stdev of background 1815 maskfrac_npix FLOAT, -- Number of pixels masked 1816 maskfrac_static FLOAT, -- Fraction masked static 1817 maskfrac_dynamic FLOAT, -- Fraction masked dynamic 1818 maskfrac_magic FLOAT, -- Fraction masked magic 1819 maskfrac_advisory FLOAT, -- Fraction masked advisory 1820 PRIMARY KEY(warp_bg_id,skycell_id), 1821 KEY(fault), 1822 KEY(quality), 1823 FOREIGN KEY(warp_bg_id) REFERENCES warpBackgroundRun(warp_bg_id) 1725 1824 ) ENGINE=innodb DEFAULT CHARSET=latin1; 1726 1825 -
trunk/ippTools/share/pxadmin_drop_tables.sql
r28375 r28486 91 91 DROP TABLE IF EXISTS Label; 92 92 DROP TABLE IF EXISTS pstampWebRequest; 93 DROP TABLE IF EXISTS chipBackgroundRun; 94 DROP TABLE IF EXISTS chipBackgroundImfile; 95 DROP TABLE IF EXISTS warpBackgroundRun; 96 DROP TABLE IF EXISTS warpBackgroundSkyfile; 93 97 DROP TABLE IF EXISTS diffPhotRun; 94 98 DROP TABLE IF EXISTS diffPhotSkyfile; -
trunk/ippTools/src
- Property svn:ignore
-
old new 39 39 warptool 40 40 staticskytool 41 41 bgtool 42 42 diffphottool
-
- Property svn:ignore
-
trunk/ippTools/src/Makefile.am
r28343 r28486 1 1 bin_PROGRAMS = \ 2 2 addtool \ 3 bgtool \ 3 4 caltool \ 4 5 camtool \ … … 48 49 noinst_HEADERS = \ 49 50 addtool.h \ 51 bgtool.h \ 50 52 caltool.h \ 51 53 camtool.h \ … … 117 119 addtoolConfig.c 118 120 121 bgtool_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS) 122 bgtool_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la 123 bgtool_SOURCES = \ 124 bgtool.c \ 125 bgtoolConfig.c 126 119 127 caltool_CFLAGS = $(PSLIB_CFLAGS) $(PSMODULES_CFLAGS) $(IPPDB_CFLAGS) 120 128 caltool_LDADD = $(PSLIB_LIBS) $(PSMODULES_LIBS) $(IPPDB_LIBS) libpxtools.la -
trunk/ippTools/src/pxtools.c
r28321 r28486 48 48 } 49 49 50 bool pxIsValidCleanedState(const char *state) 51 { 52 PS_ASSERT_PTR_NON_NULL(state, false); 53 54 if (!strcmp(state, "cleaned")) return true; 55 if (!strcmp(state, "purged")) return true; 56 if (!strcmp(state, "scrubbed")) return true; 57 return false; 58 } 59 50 60 psString pxMergeCodeVersions(psString version1, psString version2) 51 61 { … … 211 221 212 222 // change the value for tableName.columName from 'full' to 'cleaned' if necessary 213 bool pxSetStateCleaned(const psString tableName, const psStringcolumnName, psArray *rows)223 bool pxSetStateCleaned(const char *tableName, const char *columnName, psArray *rows) 214 224 { 215 225 for (long i = 0; i < psArrayLength(rows); i++) { 216 226 psMetadata *row = rows->data[i]; 217 psStringstate = psMetadataLookupStr(NULL, row, columnName);227 const char *state = psMetadataLookupStr(NULL, row, columnName); 218 228 if (!state) { 219 229 psError(PS_ERR_PROGRAMMING, false, "%s not found in row %ld of table %s", -
trunk/ippTools/src/pxtools.h
r28089 r28486 53 53 54 54 bool pxIsValidState(const char *state); 55 bool pxIsValidCleanedState(const char *state); 55 56 psString pxMergeCodeVersions(psString version1, psString version2); 56 57 bool pxCoalesceRunStatus(pxConfig *config, const psString dbQFile, psS64 stage_id, psString *software_ver, 57 psS64 *maskfrac_npix, psF32 *maskfrac_static, psF32 *maskfrac_dynamic,58 psF32 *maskfrac_magic, psF32 *maskfrac_advisory);58 psS64 *maskfrac_npix, psF32 *maskfrac_static, psF32 *maskfrac_dynamic, 59 psF32 *maskfrac_magic, psF32 *maskfrac_advisory); 59 60 bool pxSetRunSoftware(pxConfig *config, const psString tableName, const psString stage_id_name, const psS64 stage_id, 60 psString software_ver);61 psString software_ver); 61 62 bool pxSetRunMaskfrac(pxConfig *config, const psString tableName, const psString stage_id_name, const psS64 stage_id, 62 psS64 maskfrac_npix, psF32 maskfrac_static, psF32 maskfrac_dynamic,63 psF32 maskfrac_magic, psF32 maskfrac_advisory);63 psS64 maskfrac_npix, psF32 maskfrac_static, psF32 maskfrac_dynamic, 64 psF32 maskfrac_magic, psF32 maskfrac_advisory); 64 65 bool pxCamSetRunMaskfrac(pxConfig *config, const psString tableName, const psString stage_id_name, const psS64 stage_id, 65 psS64 maskfrac_ref_npix, psF32 maskfrac_ref_static, psF32 maskfrac_ref_dynamic,66 psF32 maskfrac_ref_magic, psF32 maskfrac_ref_advisory,67 psS64 maskfrac_max_npix, psF32 maskfrac_max_static, psF32 maskfrac_max_dynamic,68 psF32 maskfrac_max_magic, psF32 maskfrac_max_advisory);69 70 bool pxSetStateCleaned(const psString tableName, const psStringcolumnName, psArray *rows);66 psS64 maskfrac_ref_npix, psF32 maskfrac_ref_static, psF32 maskfrac_ref_dynamic, 67 psF32 maskfrac_ref_magic, psF32 maskfrac_ref_advisory, 68 psS64 maskfrac_max_npix, psF32 maskfrac_max_static, psF32 maskfrac_max_dynamic, 69 psF32 maskfrac_max_magic, psF32 maskfrac_max_advisory); 70 71 bool pxSetStateCleaned(const char *tableName, const char *columnName, psArray *rows); 71 72 bool pxAddLabelSearchArgs (pxConfig *config, psMetadata *where, char *field, char *name, char *op); 72 73 -
trunk/ippconfig/recipes
-
Property svn:mergeinfo
set to
/branches/czw_branch/20100427/ippconfig/recipes merged eligible /branches/pap/ippconfig/recipes merged eligible
-
Property svn:mergeinfo
set to
-
trunk/ippconfig/recipes/Makefile.am
r26831 r28486 30 30 ppSkycell.config \ 31 31 ppVizPSF.mdc \ 32 nightly_science.config 32 nightly_science.config \ 33 ppBackground.mdc 33 34 34 35 install_DATA = $(install_files) -
trunk/ippconfig/recipes/ppStatsFromMetadata.config
r28089 r28486 326 326 END 327 327 328 329 BACKGROUND_WARP METADATA 330 ENTRY MULTI 331 TYPE VAL KEYWORD TYPE STATISTIC FLAG 332 ENTRY VAL ROBUST_MEDIAN F32 ROBUST_MEDIAN -bg 333 ENTRY VAL ROBUST_STDEV F32 RMS -bg_stdev 334 ENTRY VAL QUALITY S32 CONSTANT -quality # Bad quality flag 335 336 # Revision values 337 ENTRY VAL PSLIB_V STR CONSTANT -ver_pslib 338 ENTRY VAL MODULE_V STR CONSTANT -ver_psmodules 339 ENTRY VAL STATS_V STR CONSTANT -ver_ppstats 340 ENTRY VAL WARP_V STR CONSTANT -ver_pswarp 341 342 # Mask stats values 343 ENTRY VAL MASKFRAC_NPIX S32 CONSTANT -maskfrac_npix 344 ENTRY VAL MASKFRAC_STATIC F32 CONSTANT -maskfrac_static 345 ENTRY VAL MASKFRAC_DYNAMIC F32 CONSTANT -maskfrac_dynamic 346 ENTRY VAL MASKFRAC_MAGIC F32 CONSTANT -maskfrac_magic 347 ENTRY VAL MASKFRAC_ADVISORY F32 CONSTANT -maskfrac_advisory 348 END 349 350 328 351 STACK_SKYCELL METADATA 329 352 ENTRY MULTI -
trunk/ippconfig/recipes/reductionClasses.mdc
r28378 r28486 158 158 PSASTRO STR DEFAULT_RECIPE 159 159 STACKPHOT STR STACKPHOT 160 BACKGROUND_PPBACKGROUND STR BACKGROUND 161 BACKGROUND_PSWARP STR BACKGROUND 162 160 163 END 161 164 -
trunk/ippconfig/system.config
r26831 r28486 59 59 PPVIZPSF STR recipes/ppVizPSF.mdc # PSF visualisation 60 60 NIGHTLY_SCIENCE STR recipes/nightly_science.config # Nightly Science 61 PPBACKGROUND STR recipes/ppBackground.mdc # Background restoration 61 62 END -
trunk/psModules
- Property svn:mergeinfo changed
/branches/pap/psModules merged: 28179,28484-28485
- Property svn:mergeinfo changed
-
trunk/psconfig/tagsets/ipp-2.9.dist
r28375 r28486 73 73 YYYYY ppTranslate ipp-2-9 -0 74 74 YYYYY ppViz ipp-2-9 -0 75 YYYYY ppBackground ipp-2-9 -0 75 76 YYYYY ppSkycell ipp-2-9 -0 76 77 -
trunk/psphot
- Property svn:mergeinfo changed
/branches/pap/psphot merged: 28484-28485
- Property svn:mergeinfo changed
-
trunk/pstamp
- Property svn:ignore
-
old new 16 16 ltmain.sh 17 17 libtool 18 ppstamp.pc
-
- Property svn:ignore
-
trunk/pstamp/Makefile.am
r16675 r28486 1 1 SUBDIRS = src scripts 2 2 3 pkgconfigdir = $(libdir)/pkgconfig 4 pkgconfig_DATA= ppstamp.pc 5 6 EXTRA_DIST = \ 7 ppstamp.pc.in 8 3 9 CLEANFILES = *~ core core.* -
trunk/pstamp/configure.ac
r19229 r28486 33 33 IPP_STDOPTS 34 34 CFLAGS="${CFLAGS} -Wall -Werror" 35 PPSTAMP_CFLAGS="${PSLIB_CFLAGS=} ${PSMODULES_CFLAGS=}" 36 PPSTAMP_LIBS="${PSLIB_LIBS=} ${PSMODULES_LIBS=}" 35 37 echo "PPSTAMP_CFLAGS: $PPSTAMP_CFLAGS" 36 38 echo "PPSTAMP_LIBS: $PPSTAMP_LIBS" … … 43 45 src/Makefile 44 46 scripts/Makefile 47 ppstamp.pc 45 48 ]) 46 49
Note:
See TracChangeset
for help on using the changeset viewer.
