# # ChangeLog for trunk/ippTools/share # # Generated by Trac 1.6 # Jul 19, 2026, 10:36:36 PM Thu, 18 Sep 2008 23:03:35 GMT Paul Price [19601] * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) Fixing difftool -todiffskyfile query. The old query didn't support ... Thu, 18 Sep 2008 19:32:59 GMT Paul Price [19598] * trunk/ippTools/share/stacktool_tosum.sql (modified) Don't need camera out any more. Tue, 16 Sep 2008 20:09:43 GMT Paul Price [19582] * trunk/ippTools/share/difftool_inputskyfile.sql (modified) * trunk/ippTools/src/difftool.c (modified) Optimising difftool -inputskyfile: this was driving the load on the ... Tue, 16 Sep 2008 19:02:39 GMT Paul Price [19573] * trunk/ippTools/share/chiptool_find_rawexp.sql (modified) Get all data about exposures, for -pretend. Tue, 16 Sep 2008 00:21:00 GMT bills [19558] * trunk/dbconfig/changes.txt (modified) * trunk/dbconfig/fake.md (modified) * trunk/ippTools/share/camtool_find_pendingexp.sql (modified) * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) * trunk/ippTools/share/faketool_pendingimfile.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/share/stacktool_tosum.sql (modified) * trunk/ippTools/share/warptool_towarped.sql (modified) * trunk/ippTools/src/faketool.c (modified) changes to support cleanup, purge, and update processing Fri, 12 Sep 2008 21:47:11 GMT bills [19538] * trunk/ippTools/share/warptool_towarped.sql (modified) need warpRun.state in output of -towarped Fri, 12 Sep 2008 01:34:47 GMT bills [19528] * trunk/ippTools/share/camtool_pendingcleanupexp.sql (modified) * trunk/ippTools/share/camtool_pendingcleanuprun.sql (modified) include runs in goto_purged state in the pending lists Fri, 12 Sep 2008 01:33:27 GMT bills [19527] * trunk/ippTools/share/chiptool_change_exp_state.sql (modified) * trunk/ippTools/share/chiptool_change_imfile_data_state.sql (modified) * trunk/ippTools/share/chiptool_pendingcleanupimfile.sql (modified) * trunk/ippTools/share/chiptool_pendingcleanuprun.sql (modified) forgot to look for files to purge. added some comments Fri, 12 Sep 2008 01:31:21 GMT bills [19526] * trunk/ippTools/share/stacktool_pendingcleanuprun.sql (modified) use DISTINCT to get the right set of runs Fri, 12 Sep 2008 01:30:13 GMT eugene [19525] * trunk/ippTools/share/difftool_definebyquery.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) allow for selection based on warp_label or stack_label Fri, 12 Sep 2008 01:24:32 GMT bills [19521] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/warptool_change_run_state.sql (added) * trunk/ippTools/share/warptool_change_skyfile_data_state.sql (added) * trunk/ippTools/share/warptool_pendingcleanuprun.sql (modified) * trunk/ippTools/share/warptool_pendingcleanupskyfile.sql (modified) * trunk/ippTools/share/warptool_updateskyfile.sql (added) Changes to support goto_cleaned, goto_purged, and update for warp stage Thu, 11 Sep 2008 21:24:37 GMT Paul Price [19492] * trunk/ippTools/share/chiptool_pendingimfile.sql (modified) Need additional brackets, since additional restrictions may be added. Wed, 10 Sep 2008 19:48:03 GMT Paul Price [19462] * trunk/ippTools/share/difftool_revertdiffskyfile_delete.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Adding search on label to difftool -revertdiffskyfile Wed, 10 Sep 2008 19:20:04 GMT Paul Price [19459] * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Add label search to difftool -todiffskyfile Wed, 10 Sep 2008 19:16:05 GMT Paul Price [19458] * trunk/ippTools/share/difftool_definebyquery.sql (modified) States have changed due to cleanup. Wed, 10 Sep 2008 19:13:14 GMT Paul Price [19457] * trunk/ippTools/share/difftool_definebyquery.sql (modified) * trunk/ippTools/src/difftool.c (modified) Needed to alter query to get label. Wed, 10 Sep 2008 01:00:48 GMT Paul Price [19448] * trunk/ippTools/share/stacktool_revertsumskyfile_delete.sql (modified) Need access to stackRun table. Tue, 09 Sep 2008 19:28:07 GMT Paul Price [19434] * trunk/ippTools/share/stacktool_tosum.sql (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) Adding search on label to stacktool -tosum Tue, 09 Sep 2008 05:56:19 GMT Paul Price [19433] * trunk/ippTools/share/chiptool_revertprocessedimfile.sql (modified) Need chipRun for label. Sat, 06 Sep 2008 04:53:44 GMT bills [19404] * trunk/ippTools/share/warptool_pendingcleanupskyfile.sql (modified) removed two obsolete and one redundant column from a query Fri, 05 Sep 2008 21:28:29 GMT bills [19392] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) add missing comma Fri, 05 Sep 2008 00:24:22 GMT eugene [19372] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) adding label, reduction, data_state to diff, stack, warp tables, mods ... Fri, 05 Sep 2008 00:23:50 GMT eugene [19371] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/flatcorr_inputimfile.sql (added) * trunk/ippTools/share/flatcorr_pendingprocess.sql (modified) * trunk/ippTools/src/flatcorr.c (modified) * trunk/ippTools/src/flatcorrConfig.c (modified) various updates to support needed queries for the flatcorr script Fri, 05 Sep 2008 00:21:07 GMT eugene [19366] * trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) do not require the pendingimfile to be yet-unprocessed (can be used ... Wed, 03 Sep 2008 19:52:26 GMT eugene [19338] * trunk/ippTools/share/pxadmin_drop_tables.sql (modified) change to the ChipLink and CamLink tables Wed, 03 Sep 2008 00:05:26 GMT bills [19334] * trunk/dbconfig/changes.txt (modified) * trunk/dbconfig/chip.md (modified) * trunk/ippTasks/chip.pro (modified) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/chiptool_change_exp_state.sql (added) * trunk/ippTools/share/chiptool_change_imfile_data_state.sql (added) * trunk/ippTools/share/chiptool_pendingcleanupimfile.sql (modified) * trunk/ippTools/share/chiptool_pendingimfile.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/chiptool.h (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) Add modes for transitioning chipProcessedImfiles from full to cleaned ... Tue, 02 Sep 2008 19:37:06 GMT eugene [19325] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/flatcorr_chiprundone.sql (added) * trunk/ippTools/share/flatcorr_pendingprocess.sql (added) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/flatcorr.c (modified) * trunk/ippTools/src/flatcorr.h (modified) * trunk/ippTools/src/flatcorrConfig.c (modified) substantial work on flatcorr; reworked the sequence somewhat Fri, 29 Aug 2008 02:24:03 GMT bills [19276] * trunk/ippTools/share/stacktool_sumskyfile.sql (modified) * trunk/ippTools/src/stacktool.c (modified) fix incorrect sql for stackSumSkyfile lookup Thu, 28 Aug 2008 20:01:01 GMT eugene [19260] * trunk/ippTools/share/stacktool_inputskyfile.sql (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) allow -inputskyfiles to return the list even if run is done Thu, 28 Aug 2008 03:57:36 GMT eugene [19258] * trunk/ippTools/share/difftool_definebyquery.sql (modified) * trunk/ippTools/share/faketool_find_camrun.sql (modified) * trunk/ippTools/share/magictool_definebyquery.sql (modified) * trunk/ippTools/share/magictool_definebyquery_select_part1.sql (modified) * trunk/ippTools/share/magictool_definebyquery_select_test.sql (modified) * trunk/ippTools/share/magictool_definebyquery_temp_insert.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_insert.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_part2.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_test.sql (modified) * trunk/ippTools/share/stacktool_find_complete_warps.sql (modified) do not join against tess_id Thu, 28 Aug 2008 01:37:35 GMT Paul Price [19249] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/stacktool_definebyquery_insert_random.sql (deleted) * trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql (added) * trunk/ippTools/share/stacktool_definebyquery_insert_random_part2.sql (added) * trunk/ippTools/src/stacktool.c (modified) stacktool wasn't applying the restrictions specified on the command- ... Tue, 26 Aug 2008 23:25:33 GMT bills [19219] * trunk/ippTools/share/pstamptool_addjob_otherjob.sql (modified) * trunk/ippTools/share/pstamptool_addjob_stampjob.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/pstamptool.c (modified) * trunk/ippTools/src/pstamptool.h (modified) * trunk/ippTools/src/pstamptoolConfig.c (modified) add exp_id to pstampJob. Rename -processedreq to -updatereq and ... Sat, 23 Aug 2008 19:33:25 GMT eugene [19181] * trunk/ippTools/share/chiptool_pendingimfile.sql (modified) adding sample WHERE for update (commented out) Fri, 22 Aug 2008 02:51:55 GMT eugene [19160] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/warptool_definebyquery.sql (added) * trunk/ippTools/src/warptool.c (modified) * trunk/ippTools/src/warptool.h (modified) * trunk/ippTools/src/warptoolConfig.c (modified) add definebyquery mode to warptool Thu, 21 Aug 2008 22:20:49 GMT bills [19152] * trunk/ippTools/share/stacktool_definebyquery_insert.sql (modified) disambiguate warp_id in insert sql Wed, 20 Aug 2008 20:24:15 GMT bills [19134] * trunk/ippTools/share/magictool_definebyquery_temp_insert.sql (modified) fix ambiguous column in query Mon, 18 Aug 2008 01:42:03 GMT eugene [19115] * trunk/ippTools/share/warptool_towarped.sql (modified) supply exp_tag so we can use it in output names Mon, 18 Aug 2008 01:24:22 GMT eugene [19108] * trunk/ippTools/share/difftool_revertdiffskyfile_update.sql (modified) * trunk/ippTools/share/stacktool_revertsumskyfile_update.sql (modified) using new state values (new, full, etc) Mon, 18 Aug 2008 00:57:39 GMT eugene [19107] * trunk/ippTools/share/stacktool_definebyquery_insert.sql (modified) drop the join against tess_id, add explicit table refs to tess_id and ... Mon, 18 Aug 2008 00:50:56 GMT eugene [19105] * trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) remove tess_id from JOIN Mon, 18 Aug 2008 00:41:26 GMT eugene [19104] * trunk/ippTools/share/stacktool_definebyquery_part2.sql (modified) whitespace Sat, 16 Aug 2008 23:27:58 GMT eugene [19092] * trunk/ippTools/notes.txt (modified) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/camtool_donecleanup.sql (added) * trunk/ippTools/share/camtool_find_pendingexp.sql (modified) * trunk/ippTools/share/camtool_pendingcleanupexp.sql (added) * trunk/ippTools/share/camtool_pendingcleanuprun.sql (added) * trunk/ippTools/share/camtool_reset_faulted_runs.sql (modified) * trunk/ippTools/share/dettool_addprocessedexp.sql (modified) * trunk/ippTools/share/dettool_definebydetrun.sql (modified) * trunk/ippTools/share/dettool_pendingcleanup_normalizedexp.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_normalizedimfile.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_normalizedstat.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_processedexp.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_processedimfile.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_residexp.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_residimfile.sql (added) * trunk/ippTools/share/dettool_pendingcleanup_stacked.sql (added) * trunk/ippTools/share/difftool_donecleanup.sql (added) * trunk/ippTools/share/difftool_inputskyfile.sql (modified) * trunk/ippTools/share/difftool_pendingcleanuprun.sql (added) * trunk/ippTools/share/difftool_pendingcleanupskyfile.sql (added) * trunk/ippTools/share/difftool_skyfile.sql (modified) * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) * trunk/ippTools/share/faketool_completely_processed_exp.sql (modified) * trunk/ippTools/share/faketool_donecleanup.sql (added) * trunk/ippTools/share/faketool_find_camrun.sql (modified) * trunk/ippTools/share/faketool_find_pendingexp.sql (modified) * trunk/ippTools/share/faketool_pendingcleanupimfile.sql (added) * trunk/ippTools/share/faketool_pendingcleanuprun.sql (added) * trunk/ippTools/share/faketool_queue_cam_id.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_test.sql (modified) * trunk/ippTools/share/stacktool_donecleanup.sql (added) * trunk/ippTools/share/stacktool_find_complete_warps.sql (modified) * trunk/ippTools/share/stacktool_inputskyfile.sql (modified) * trunk/ippTools/share/stacktool_pendingcleanuprun.sql (added) * trunk/ippTools/share/stacktool_pendingcleanupskyfile.sql (added) * trunk/ippTools/share/stacktool_sumskyfile.sql (modified) * trunk/ippTools/share/stacktool_tosum.sql (modified) * trunk/ippTools/share/warptool_donecleanup.sql (added) * trunk/ippTools/share/warptool_exp.sql (modified) * trunk/ippTools/share/warptool_imfile.sql (modified) * trunk/ippTools/share/warptool_pendingcleanuprun.sql (added) * trunk/ippTools/share/warptool_pendingcleanupskyfile.sql (added) * trunk/ippTools/share/warptool_scmap.sql (modified) * trunk/ippTools/share/warptool_tooverlap.sql (modified) * trunk/ippTools/share/warptool_towarped.sql (modified) * trunk/ippTools/share/warptool_warped.sql (modified) * trunk/ippTools/src/Makefile.am (modified) * trunk/ippTools/src/camtool.c (modified) * trunk/ippTools/src/camtool.h (modified) * trunk/ippTools/src/camtoolConfig.c (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) * trunk/ippTools/src/dettool.c (modified) * trunk/ippTools/src/dettool.h (modified) * trunk/ippTools/src/dettoolConfig.c (modified) * trunk/ippTools/src/dettool_correction.c (modified) * trunk/ippTools/src/dettool_detrunsummary.c (added) * trunk/ippTools/src/dettool_normalizedexp.c (added) * trunk/ippTools/src/dettool_normalizedimfile.c (added) * trunk/ippTools/src/dettool_normalizedstat.c (added) * trunk/ippTools/src/dettool_processedexp.c (added) * trunk/ippTools/src/dettool_processedimfile.c (added) * trunk/ippTools/src/dettool_residexp.c (added) * trunk/ippTools/src/dettool_residimfile.c (added) * trunk/ippTools/src/dettool_stack.c (added) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftool.h (modified) * trunk/ippTools/src/difftoolConfig.c (modified) * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketool.h (modified) * trunk/ippTools/src/faketoolConfig.c (modified) * trunk/ippTools/src/guidetool.c (deleted) * trunk/ippTools/src/guidetool.h (deleted) * trunk/ippTools/src/guidetoolConfig.c (deleted) * trunk/ippTools/src/pxcam.c (modified) * trunk/ippTools/src/pxfake.c (modified) * trunk/ippTools/src/pxtools.c (modified) * trunk/ippTools/src/pxwarp.c (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktool.h (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) * trunk/ippTools/src/warptool.c (modified) * trunk/ippTools/src/warptool.h (modified) * trunk/ippTools/src/warptoolConfig.c (modified) extensive changes from eam_branch_20080719: * added the 'cleanup' ... Wed, 13 Aug 2008 01:41:25 GMT Paul Price [19038] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/difftool_revertdiffskyfile.sql (deleted) * trunk/ippTools/share/difftool_revertdiffskyfile_delete.sql (added) * trunk/ippTools/share/difftool_revertdiffskyfile_update.sql (added) * trunk/ippTools/src/difftool.c (modified) Changing so 'difftool -revertdiffskyfile' sets the state to 'run' in ... Tue, 12 Aug 2008 20:26:04 GMT Paul Price [19029] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/stacktool_revertsumskyfile.sql (deleted) * trunk/ippTools/share/stacktool_revertsumskyfile_delete.sql (added) * trunk/ippTools/share/stacktool_revertsumskyfile_update.sql (added) * trunk/ippTools/src/stacktool.c (modified) Make 'stacktool -revertsumskyfile' to update the run state as well as ... Tue, 12 Aug 2008 20:03:59 GMT Paul Price [19027] * trunk/ippTools/share/stacktool_definebyquery_insert.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_insert_random.sql (modified) Don't include warps that are 'ignored'. Fri, 08 Aug 2008 22:37:49 GMT bills [18975] * trunk/ippTools/share/difftool_skyfile.sql (modified) * trunk/ippTools/share/stacktool_sumskyfile.sql (modified) * trunk/ippTools/share/warptool_warped.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) * trunk/ippTools/src/warptool.c (modified) In the modes for difftool, stacktool, and warptool that print out ... Fri, 08 Aug 2008 03:53:09 GMT bills [18952] * trunk/ippTools/share/difftool_skyfile.sql (modified) if it isn't tested it doesn't work Fri, 08 Aug 2008 03:41:36 GMT bills [18951] * trunk/ippTools/share/stacktool_sumskyfile.sql (modified) in mode -sumskyfile don't require state to be run and output the state Fri, 08 Aug 2008 03:40:54 GMT bills [18950] * trunk/ippTools/share/warptool_warped.sql (modified) in mode -warped don't require state to be 'run' and output the state Fri, 08 Aug 2008 03:40:18 GMT bills [18949] * trunk/ippTools/share/difftool_skyfile.sql (modified) For mode -diffskyfile don't require state to be run, output the state Fri, 08 Aug 2008 03:32:05 GMT bills [18948] * trunk/ippTools/share/chiptool_processedimfile.sql (modified) Add chipRun.state to the output of -processedimfile Tue, 05 Aug 2008 20:10:36 GMT Paul Price [18915] * trunk/ippTools/share/warptool_tooverlap.sql (modified) Want exp_tag for output directory name. Mon, 04 Aug 2008 21:31:29 GMT bills [18886] * trunk/ippTools/share/chiptool_processedimfile.sql (modified) add exp_id to output of chiptool -processedimfile Thu, 31 Jul 2008 00:32:56 GMT Paul Price [18793] * trunk/ippTools/share/faketool_pendingimfile.sql (modified) Missing constraint on LEFT JOIN with fakeProcessedImfile was leaving ... Wed, 30 Jul 2008 20:41:20 GMT Paul Price [18782] * trunk/ippTools/share/magictool_toprocess_tree.sql (modified) Need additional outputs for script. Wed, 30 Jul 2008 20:39:37 GMT Paul Price [18781] * trunk/ippTools/share/magictool_tomask.sql (modified) Need additional values out for script. Wed, 30 Jul 2008 20:15:06 GMT Paul Price [18779] * trunk/ippTools/share/magictool_totree.sql (modified) Want exp_id for filenames. Wed, 30 Jul 2008 20:11:41 GMT Paul Price [18778] * trunk/ippTools/share/magictool_totree.sql (modified) Need workdir Wed, 30 Jul 2008 00:38:03 GMT Paul Price [18771] * trunk/ippTools/share/magictool_toprocess_inputs.sql (modified) Want path_base for magictool -toprocess Tue, 29 Jul 2008 20:42:08 GMT bills [18764] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) My last "fix" was in error. It turns out that the trailing semicolon ... Mon, 28 Jul 2008 22:19:56 GMT bills [18761] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) add missing semicolon at the end of the file Thu, 24 Jul 2008 04:02:26 GMT Paul Price [18704] * trunk/ippTools/share/magictool_inputs.sql (modified) Need path_base out of diffSkyfile for magic_process.pl Thu, 24 Jul 2008 03:59:23 GMT Paul Price [18703] * trunk/ippTools/share/magictool_toprocess_inputs.sql (modified) Need camera for magic_process.pl Thu, 24 Jul 2008 03:40:26 GMT Paul Price [18700] * trunk/ippTools/share/magictool_definebyquery_insert.sql (modified) Using skycell_id as the node name. Thu, 24 Jul 2008 02:34:14 GMT Paul Price [18699] * trunk/ippTools/share/magictool_definebyquery_insert.sql (modified) Can't spell. Thu, 24 Jul 2008 02:33:23 GMT Paul Price [18698] * trunk/ippTools/share/magictool_definebyquery_insert.sql (modified) * trunk/ippTools/src/magictool.c (modified) Whoops --- exp_id isn't a string, but a S64, so I have to play games ... Thu, 24 Jul 2008 02:29:30 GMT Paul Price [18697] * trunk/ippTools/share/magictool_definebyquery_insert.sql (modified) * trunk/ippTools/src/magictool.c (modified) Need to restrict what's inserted into magicInputSkyfile by the exp_id. Thu, 24 Jul 2008 02:20:00 GMT Paul Price [18694] * trunk/ippTools/share/magictool_totree.sql (modified) Also need RA, Dec, tess_id. Thu, 24 Jul 2008 02:17:44 GMT Paul Price [18693] * trunk/ippTools/share/magictool_totree.sql (modified) Need camera out of magictool -totree. Thu, 24 Jul 2008 01:17:52 GMT Paul Price [18688] * trunk/ippTools/share/faketool_find_pendingexp.sql (modified) Exposure level requires that fakeProcessedImfile is populated, so ... Thu, 24 Jul 2008 00:48:45 GMT Paul Price [18684] * trunk/ippTools/share/difftool_queue.sql (deleted) Replaced by difftool_definebyquery.sql Wed, 23 Jul 2008 21:14:20 GMT Paul Price [18673] * trunk/ippTools/share/difftool_definebyquery.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Adding selection on good_frac. Wed, 23 Jul 2008 20:55:10 GMT Paul Price [18672] * trunk/ippTools/share/magictool_definebyquery.sql (modified) Don't list all fields. Wed, 23 Jul 2008 20:47:03 GMT Paul Price [18669] * trunk/ippTools/share/magictool_definebyquery_select_part1.sql (modified) No need to get every column. Wed, 23 Jul 2008 20:24:23 GMT Paul Price [18668] * trunk/ippTools/share/magictool_definebyquery.sql (modified) Updating to match the various distributed parts. Wed, 23 Jul 2008 03:03:09 GMT bills [18665] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) apply changes to the pstamp tables Wed, 23 Jul 2008 02:39:04 GMT Paul Price [18664] * trunk/ippTools/share/Makefile.am (modified) Adding missing file. Wed, 23 Jul 2008 02:36:48 GMT Paul Price [18663] * trunk/ippTools/doc/magic_flow.txt (added) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/magictool_definebyquery.sql (added) * trunk/ippTools/share/magictool_definebyquery_insert.sql (added) * trunk/ippTools/share/magictool_definebyquery_select_part1.sql (added) * trunk/ippTools/share/magictool_definebyquery_select_part2.sql (added) * trunk/ippTools/share/magictool_definebyquery_select_test.sql (added) * trunk/ippTools/share/magictool_definebyquery_temp_create.sql (added) * trunk/ippTools/share/magictool_definebyquery_temp_insert.sql (added) * trunk/ippTools/share/magictool_definebyquery_temp_insert_groupby.sql (added) * trunk/ippTools/share/magictool_find_complete_diffed_exposures.sql (deleted) * trunk/ippTools/share/magictool_find_complete_warpruns.sql (deleted) * trunk/ippTools/share/magictool_find_unmagiced.sql (deleted) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Reworking magictool -definebyquery to support automation: want to be ... Wed, 23 Jul 2008 02:17:46 GMT Paul Price [18662] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) Adding exposure identifier in magicRun. Tue, 22 Jul 2008 05:15:29 GMT Paul Price [18656] * trunk/ippTools/share/difftool_definebyquery.sql (added) Renaming difftool -queue to difftool -definebyquery. Expanding SQL ... Tue, 22 Jul 2008 05:14:30 GMT Paul Price [18655] * trunk/ippTools/share/Makefile.am (modified) Renaming queue to definebyquery. Fri, 18 Jul 2008 02:13:53 GMT Paul Price [18610] * trunk/ippTools/share/stacktool_definebyquery_part2.sql (modified) Don't need that one. Fri, 18 Jul 2008 02:12:41 GMT Paul Price [18609] * trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_part2.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_test.sql (modified) That ORDER BY which I claimed was so important wasn't really. I ... Wed, 16 Jul 2008 23:01:47 GMT Paul Price [18579] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/stacktool_definebyquery_groupby.sql (deleted) * trunk/ippTools/share/stacktool_definebyquery_part1.sql (added) * trunk/ippTools/share/stacktool_definebyquery_part2.sql (added) * trunk/ippTools/share/stacktool_definebyquery_select.sql (deleted) * trunk/ippTools/share/stacktool_definebyquery_test.sql (added) * trunk/ippTools/src/stacktool.c (modified) Fixing buggy query to get list of warps and stacks. It would return ... Wed, 16 Jul 2008 19:25:45 GMT Paul Price [18577] * trunk/ippTools/share/stacktool_definebyquery_insert.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_insert_random.sql (modified) * trunk/ippTools/share/stacktool_definebyquery_select.sql (modified) Adding additional comments Wed, 16 Jul 2008 19:25:00 GMT Paul Price [18576] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) Reformatting some of my tables. Adding "filter" to stackRun. Wed, 16 Jul 2008 05:55:19 GMT Paul Price [18574] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/stacktool_definebyquery_groupby.sql (added) * trunk/ippTools/share/stacktool_definebyquery_insert.sql (added) * trunk/ippTools/share/stacktool_definebyquery_insert_random.sql (added) * trunk/ippTools/share/stacktool_definebyquery_select.sql (added) * trunk/ippTools/share/stacktool_find_complete_warps.sql (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) Completely reworking stacktool -definebyquery in order to support ... Wed, 16 Jul 2008 02:16:16 GMT Paul Price [18573] * trunk/ippTools/share/magictool_inputs.sql (modified) * trunk/ippTools/share/magictool_tomask.sql (modified) * trunk/ippTools/share/magictool_toprocess_tree.sql (modified) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictool.h (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Adding revert options, fault code handling. Tue, 15 Jul 2008 20:30:59 GMT eugene [18561] * trunk/ippTools/notes.txt (modified) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/dettool_addprocessedexp.sql (added) * trunk/ippTools/share/dettool_childlessrun.sql (added) * trunk/ippTools/share/dettool_definebydetrun.sql (added) * trunk/ippTools/share/dettool_detrunsummary.sql (added) * trunk/ippTools/share/dettool_input.sql (added) * trunk/ippTools/share/dettool_normalizedexp.sql (added) * trunk/ippTools/share/dettool_normalizedimfile.sql (added) * trunk/ippTools/share/dettool_pending.sql (added) * trunk/ippTools/share/dettool_processedimfile.sql (added) * trunk/ippTools/share/dettool_residexp.sql (added) * trunk/ippTools/share/dettool_residimfile.sql (added) * trunk/ippTools/share/dettool_stacked.sql (added) * trunk/ippTools/share/dettool_tonormalize.sql (added) * trunk/ippTools/share/dettool_tonormalizedexp.sql (modified) * trunk/ippTools/share/dettool_toresidexp.sql (modified) * trunk/ippTools/share/dettool_toresidimfile.sql (modified) * trunk/ippTools/share/difftool_queue.sql (modified) * trunk/ippTools/share/magictool_create_tmp_warpcomplete.sql (added) * trunk/ippTools/share/pstamptool_addjob_otherjob.sql (added) * trunk/ippTools/share/pstamptool_addjob_stampjob.sql (added) * trunk/ippTools/share/pstamptool_datastore.sql (added) * trunk/ippTools/share/pstamptool_pendingjob.sql (added) * trunk/ippTools/share/pstamptool_pendingreq.sql (added) * trunk/ippTools/src/caltool.c (modified) * trunk/ippTools/src/caltoolConfig.c (modified) * trunk/ippTools/src/camtool.c (modified) * trunk/ippTools/src/camtoolConfig.c (modified) * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) * trunk/ippTools/src/detselect.c (modified) * trunk/ippTools/src/detselect.h (modified) * trunk/ippTools/src/detselectConfig.c (modified) * trunk/ippTools/src/dettool.c (modified) * trunk/ippTools/src/dettool.h (modified) * trunk/ippTools/src/dettoolConfig.c (modified) * trunk/ippTools/src/dettool_correction.c (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) * trunk/ippTools/src/flatcorr.c (modified) * trunk/ippTools/src/flatcorrConfig.c (modified) * trunk/ippTools/src/guidetool.c (modified) * trunk/ippTools/src/guidetoolConfig.c (modified) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictoolConfig.c (modified) * trunk/ippTools/src/pstamptool.c (modified) * trunk/ippTools/src/pstamptoolConfig.c (modified) * trunk/ippTools/src/pxconfig.c (modified) * trunk/ippTools/src/pxconfig.h (modified) * trunk/ippTools/src/pxinjectConfig.c (modified) * trunk/ippTools/src/pxtools.h (modified) * trunk/ippTools/src/pztool.c (modified) * trunk/ippTools/src/pztoolConfig.c (modified) * trunk/ippTools/src/regtool.c (modified) * trunk/ippTools/src/regtoolConfig.c (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) * trunk/ippTools/src/warptool.c (modified) * trunk/ippTools/src/warptoolConfig.c (modified) completely deprecate config->where; make all command-line handling ... Tue, 15 Jul 2008 04:21:12 GMT Paul Price [18526] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/magictool_addmask.sql (added) * trunk/ippTools/share/magictool_inputs.sql (added) * trunk/ippTools/share/magictool_mask.sql (added) * trunk/ippTools/share/magictool_node.sql (deleted) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictool.h (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Adding magictool -mask (to get the URI for the mask information out). ... Tue, 15 Jul 2008 03:31:55 GMT Paul Price [18524] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/magictool_node.sql (added) * trunk/ippTools/share/magictool_toprocess_inputs.sql (modified) * trunk/ippTools/share/magictool_toprocess_tree.sql (modified) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictool.h (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Removing uri out of magictool -toprocess. Adding magictool -node to ... Tue, 15 Jul 2008 02:05:33 GMT Paul Price [18523] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/magictool_totree.sql (added) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictool.h (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Adding magictool -totree Tue, 15 Jul 2008 01:18:02 GMT Paul Price [18520] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/magictool.c (modified) * trunk/ippTools/src/magictool.h (modified) * trunk/ippTools/src/magictoolConfig.c (modified) Updating tables for magic (adding fault codes, removing skyfilemask) Fri, 11 Jul 2008 22:30:30 GMT Paul Price [18483] * trunk/ippTools/share/stacktool_tosum.sql (modified) Need to get camera name out of stacktool -tosum. Wed, 09 Jul 2008 22:38:31 GMT eugene [18448] * trunk/ippTools/notes.txt (modified) * trunk/ippTools/share/difftool_inputskyfile.sql (modified) * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) * trunk/ippTools/share/faketool_find_camrun.sql (modified) * trunk/ippTools/share/faketool_find_pendingexp.sql (modified) * trunk/ippTools/share/warptool_imfile.sql (modified) * trunk/ippTools/share/warptool_scmap.sql (modified) * trunk/ippTools/share/warptool_tooverlap.sql (modified) * trunk/ippTools/share/warptool_towarped.sql (modified) chiptool now uses new state names: new (for run), full (for stop), ... Wed, 09 Jul 2008 22:11:17 GMT Paul Price [18447] * trunk/ippTools/share/chiptool_completely_processed_exp.sql (modified) chiptool now uses 'new' instead of 'run' Wed, 02 Jul 2008 02:04:24 GMT jhoblitt [18395] * trunk/ippTools/share/pztool_revert_fileset_faults.sql (modified) don't remove faults less than 10 minutes old Mon, 30 Jun 2008 01:02:07 GMT eugene [18366] * trunk/ippTools/scripts/regtest.sh (modified) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/camtool_find_chip_id.sql (modified) * trunk/ippTools/share/camtool_find_pendingexp.sql (modified) * trunk/ippTools/share/camtool_queue_chip_id.sql (modified) * trunk/ippTools/share/chiptool_pendingcleanup.sql (deleted) * trunk/ippTools/share/chiptool_pendingcleanupimfile.sql (added) * trunk/ippTools/share/chiptool_pendingcleanuprun.sql (added) * trunk/ippTools/share/chiptool_pendingimfile.sql (modified) * trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql (modified) * trunk/ippTools/share/flatcorr_find_processedimfiles.sql (modified) * trunk/ippTools/share/flatcorr_pending.sql (modified) * trunk/ippTools/src/Makefile.am (modified) * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/chiptool.h (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) * trunk/ippTools/src/faketoolConfig.c (modified) * trunk/ippTools/src/pxchip.c (modified) * trunk/ippTools/src/pxchip.h (modified) * trunk/ippTools/src/pxtools.h (modified) merge updates from cleanup branch Thu, 26 Jun 2008 20:59:02 GMT jhoblitt [18328] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/regtool_create_dup_table.sql (added) * trunk/ippTools/share/regtool_populate_dup_table.sql (added) * trunk/ippTools/src/regtool.c (modified) * trunk/ippTools/src/regtool.h (modified) * trunk/ippTools/src/regtoolConfig.c (modified) add regtool -cleardupexp Wed, 25 Jun 2008 09:27:31 GMT bills [18319] * trunk/ippTools/share/pztool_revert_downloadimfile_faults.sql (modified) We forgot the most basic Data Store non-error. 503 Try Again.