# # ChangeLog for trunk/ippTools # # Generated by Trac 1.6 # Jul 20, 2026, 11:53:11 AM Sun, 12 Oct 2008 22:27:17 GMT bills [20071] * trunk/ippTools/share/difftool_skyfile.sql (modified) the minuend image (template = 0) is not necessarily a warp so we ... Sat, 11 Oct 2008 02:40:01 GMT Paul Price [20064] * trunk/ippTools/configure.ac (modified) Use new ippdb version 1.1.43. Sat, 11 Oct 2008 02:34:12 GMT Paul Price [20062] * trunk/ippScripts/scripts/diff_skycell.pl (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Adding more QA fields for diff. Fri, 10 Oct 2008 04:02:35 GMT Paul Price [20042] * trunk/ippTools/src/camtool.c (modified) Don't need to specify table name. Fri, 10 Oct 2008 04:00:58 GMT Paul Price [20041] * trunk/ippTools/share/camtool_find_chip_id.sql (modified) * trunk/ippTools/share/faketool_find_camrun.sql (modified) * trunk/ippTools/share/warptool_definebyquery.sql (modified) Fixing solang --> sun_angle. Thu, 09 Oct 2008 21:40:08 GMT bills [20024] * trunk/ippTools/share/difftool_skyfile.sql (modified) add warp_id to the output of difftool -diffskyfile Wed, 08 Oct 2008 22:11:57 GMT Paul Price [20007] * trunk/ippTools/configure.ac (modified) Upgrading database schema. Wed, 08 Oct 2008 18:51:40 GMT eugene [19988] * trunk/ippTools/src/dettool.c (modified) fix definebytag errors Wed, 08 Oct 2008 02:32:42 GMT eugene [19973] * trunk/ippTools/src/camtool.c (modified) * trunk/ippTools/src/camtoolConfig.c (modified) adding dtime_astrom, dtime_addstar Wed, 08 Oct 2008 02:32:14 GMT eugene [19972] * trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) need to pass all chipProcessedImfile metadata through Wed, 08 Oct 2008 02:29:38 GMT eugene [19970] * trunk/dbconfig/cam.md (modified) * trunk/dbconfig/changes.txt (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) adding dtime_astrom and dtime_addstar Tue, 07 Oct 2008 20:46:30 GMT Paul Price [19957] * trunk/ippTools/configure.ac (modified) Use current version of IPPDB. Tue, 07 Oct 2008 19:54:27 GMT eugene [19941] * trunk/ippTools/share/pxadmin_create_tables.sql (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) adding IQ stats, n_psfstars, n_iqstars Tue, 07 Oct 2008 00:53:18 GMT Paul Price [19934] * trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) Remove fields that are no longer in chipProcessedImfile. Tue, 07 Oct 2008 00:36:15 GMT Paul Price [19933] * trunk/ippTools/share/faketool_pendingimfile.sql (modified) Removing fields which are no longer in chipProcessedImfile. Tue, 07 Oct 2008 00:02:15 GMT Paul Price [19931] * trunk/ippTools/configure.ac (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (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/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketoolConfig.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) Reusing astrometry time field since ppImage doesn't do that any more. ... Thu, 02 Oct 2008 17:49:47 GMT eugene [19816] * trunk/ippTools/share/dettool_toresidimfile.sql (modified) fixed sql error: do not run images which failed on processing Thu, 02 Oct 2008 17:49:12 GMT eugene [19815] * trunk/ippTools/share/dettool_toresidexp.sql (modified) fixed error in sql logic Thu, 02 Oct 2008 17:48:51 GMT eugene [19814] * trunk/ippTools/src/dettool.h (modified) add isValidDetRunState Thu, 02 Oct 2008 17:48:31 GMT eugene [19813] * trunk/ippTools/src/dettoolConfig.c (modified) fixed the options for definebydetrun Thu, 02 Oct 2008 17:46:21 GMT eugene [19812] * trunk/ippTools/src/dettool.c (modified) fixed the options for definebydetrun; added additional states: wait, ... Sun, 28 Sep 2008 19:49:06 GMT bills [19777] * trunk/ippTools/src/pstamptool.c (modified) fixed problem code Sun, 28 Sep 2008 19:32:03 GMT bills [19776] * trunk/ippTools/share/Makefile.am (modified) add new file pstamptool_project.sql Sun, 28 Sep 2008 02:38:49 GMT bills [19775] * trunk/ippTools/share/pstamptool_project.sql (added) add pstamptool_project.sql Sat, 27 Sep 2008 21:50:17 GMT eugene [19774] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/src/pstamptool.c (modified) comment out problem code Sat, 27 Sep 2008 21:49:51 GMT eugene [19773] * trunk/ippTools/share/dettool_definebydetrun.sql (modified) add iteration to query Sat, 27 Sep 2008 21:49:23 GMT eugene [19772] * trunk/ippTools/src/dettoolConfig.c (modified) add needed options to definebydetrun Sat, 27 Sep 2008 21:49:07 GMT eugene [19771] * trunk/ippTools/src/dettool.c (modified) cleanup & fix definebydetrun Sat, 27 Sep 2008 03:10:43 GMT Paul Price [19769] * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) workdir should be required for chiptool -definebyquery Fri, 26 Sep 2008 00:05:59 GMT bills [19760] * trunk/dbconfig/changes.txt (modified) * trunk/dbconfig/pstamp.md (modified) * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/share/pxadmin_drop_tables.sql (modified) * trunk/ippTools/src/pstamptool.c (modified) * trunk/ippTools/src/pstamptool.h (modified) * trunk/ippTools/src/pstamptoolConfig.c (modified) add table pstampProject Fri, 26 Sep 2008 00:04:28 GMT bills [19759] * trunk/ippTools/share/magictool_definebyquery.sql (modified) fix typo Wed, 24 Sep 2008 23:46:53 GMT bills [19752] * trunk/ippTools/share/difftool_skyfile.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) undo last change for a more flexible solution. Add -code to the list ... Wed, 24 Sep 2008 23:34:23 GMT bills [19751] * trunk/ippTools/share/difftool_skyfile.sql (modified) in the mode -diffskyfile only return skyfiles with fault = 0 Wed, 24 Sep 2008 19:03:21 GMT bills [19734] * trunk/ippTools/src/regtoolConfig.c (modified) add elevation to args list Wed, 24 Sep 2008 01:12:18 GMT eugene [19725] * trunk/ippTools/src/dettoolConfig.c (modified) clarify arguments Tue, 23 Sep 2008 22:43:04 GMT bills [19702] * trunk/ippTools/share/Makefile.am (modified) * trunk/ippTools/share/chiptool_change_exp_state.sql (modified) * trunk/ippTools/share/faketool_change_exp_state.sql (added) * trunk/ippTools/share/faketool_change_imfile_data_state.sql (added) * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketool.h (modified) * trunk/ippTools/src/faketoolConfig.c (modified) added modes to change imfile state for cleanup,update,purge processing Tue, 23 Sep 2008 22:42:30 GMT bills [19701] * trunk/ippTools/src/chiptool.c (modified) cause an error if no rows get state changed in cleanup, update,purge ... Tue, 23 Sep 2008 22:41:41 GMT bills [19700] * trunk/ippTools/src/chiptoolConfig.c (modified) fix typo Tue, 23 Sep 2008 20:59:07 GMT Paul Price [19694] * trunk/ippTools/src/difftool.c (modified) Wrong type. Tue, 23 Sep 2008 20:56:38 GMT bills [19693] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) add new fields Tue, 23 Sep 2008 20:12:51 GMT eugene [19686] * trunk/ippTools/src/regtool.c (modified) * trunk/ippTools/src/regtoolConfig.c (modified) adding options to populate sun/moon data fields Tue, 23 Sep 2008 19:57:01 GMT bills [19678] * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/share/stacktool_tosum.sql (modified) removed data_state Tue, 23 Sep 2008 19:56:39 GMT bills [19677] * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftool.h (modified) * trunk/ippTools/src/difftoolConfig.c (modified) added -updateskyfile mode removed data_state Tue, 23 Sep 2008 19:51:00 GMT bills [19676] * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktool.h (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) added -updatesumskyfile for error recording during update processing ... Tue, 23 Sep 2008 19:37:16 GMT Paul Price [19673] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) Adding statistics on number of stamps Tue, 23 Sep 2008 18:25:56 GMT Paul Price [19666] * trunk/ippTools/src/stacktoolConfig.c (modified) Missed -dtime_phot Mon, 22 Sep 2008 23:26:50 GMT bills [19647] * trunk/ippTools/src/warptool.c (modified) removed incorrect comment Mon, 22 Sep 2008 23:03:13 GMT Paul Price [19646] * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) Adding additional statistics for stacking. Mon, 22 Sep 2008 21:07:11 GMT Paul Price [19639] * trunk/dbconfig/changes.txt (modified) * trunk/dbconfig/diff.md (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Adding additional statistics for diff. Mon, 22 Sep 2008 07:20:47 GMT eugene [19633] * trunk/ippTools/Makefile.am (modified) * trunk/ippTools/configure.ac (modified) * trunk/ippTools/scripts/Makefile.am (added) * trunk/ippTools/scripts/ippadmin (added) adding ippadmin script (was dbadmin script from ippMonitor) Mon, 22 Sep 2008 07:20:25 GMT eugene [19632] * trunk/ippTools/share/dettool_residimfile.sql (modified) * trunk/ippTools/src/dettool_residimfile.c (modified) allow residimfile query for any state Sat, 20 Sep 2008 00:11:37 GMT eugene [19621] * trunk/ippScripts/scripts/detrend_resid_imfile.pl (modified) * trunk/ippTasks/Makefile.am (modified) * trunk/ippTasks/automate.pro (modified) * trunk/ippTasks/detrend.resid.pro (modified) * trunk/ippTasks/simtest.detverify.auto (added) * trunk/ippTasks/simtest.detverify.config (added) * trunk/ippTasks/simtest.pro (modified) * trunk/ippTools/share/dettool_addprocessedexp.sql (modified) * trunk/ippTools/share/dettool_childlessrun.sql (modified) * trunk/ippTools/share/dettool_stop_completed_correct_runs.sql (modified) * trunk/ippTools/share/dettool_tocorrectimfile.sql (modified) * trunk/ippTools/share/dettool_toprocessedexp.sql (modified) * trunk/ippTools/share/dettool_toprocessedimfile.sql (modified) * trunk/ippTools/share/dettool_toresidimfile.sql (modified) * trunk/ippTools/share/pxadmin_create_tables.sql (modified) * trunk/ippTools/src/dettool.c (modified) * trunk/ippTools/src/dettoolConfig.c (modified) * trunk/ippTools/src/dettool_correction.c (modified) * trunk/ippTools/src/dettool_processedimfile.c (modified) * trunk/ippTools/src/dettool_residimfile.c (modified) changing detrend verify mode to behave just like master mode in terms ... Fri, 19 Sep 2008 01:19:45 GMT Paul Price [19607] * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) Don't need that extra output, leftover from testing. Fri, 19 Sep 2008 01:18:58 GMT Paul Price [19606] * trunk/ippTools/share/difftool_todiffskyfile.sql (modified) Fixing query: was joining on the wrong tables. Fri, 19 Sep 2008 01:09:06 GMT bills [19605] * trunk/ippTools/src/chiptoolConfig.c (modified) add -set_state to argument list for chiptool -updaterun 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. Wed, 17 Sep 2008 02:13:35 GMT eugene [19592] * trunk/ippTools/src/camtool.c (modified) * trunk/ippTools/src/camtoolConfig.c (modified) * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketoolConfig.c (modified) making set_state and set_label options consistent Tue, 16 Sep 2008 20:43:20 GMT Paul Price [19587] * trunk/ippTools/src/chiptool.c (modified) = should be == 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:03:08 GMT Paul Price [19574] * trunk/ippTools/src/chiptool.c (modified) Fix SEGV in printing metadatas in chiptool -definebyquery -pretend. 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 17:28:59 GMT Paul Price [19572] * trunk/ippTools/src/camtool.c (modified) Allow reversion based on fault code. 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 03:12:33 GMT Paul Price [19531] * trunk/ippTools/src/warptool.c (modified) More table woes. Fri, 12 Sep 2008 03:06:58 GMT Paul Price [19530] * trunk/ippTools/src/warptool.c (modified) * trunk/ippTools/src/warptoolConfig.c (modified) Allow searching on label by warptool -definebyquery 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:25:25 GMT bills [19522] * trunk/ippTools/src/warptool.c (modified) * trunk/ippTools/src/warptool.h (modified) * trunk/ippTools/src/warptoolConfig.c (modified) New modes to support goto_cleaned, goto_purged, and update processing 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. Thu, 11 Sep 2008 21:09:27 GMT Paul Price [19490] * trunk/ippTools/src/pxfake.c (modified) No need the extra 'where'. Thu, 11 Sep 2008 21:06:34 GMT Paul Price [19489] * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketoolConfig.c (modified) * trunk/ippTools/src/pxfake.c (modified) Adding search on label to faketool -updaterun Thu, 11 Sep 2008 21:01:04 GMT Paul Price [19488] * trunk/ippTools/src/camtoolConfig.c (modified) Fixing: failed to lookup value for -state Wed, 10 Sep 2008 19:48:48 GMT Paul Price [19463] * trunk/ippTools/src/difftool.c (modified) The usual table differences. 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 19:11:41 GMT Paul Price [19456] * trunk/ippTools/src/difftool.c (modified) Wrong type. Wed, 10 Sep 2008 19:09:44 GMT Paul Price [19455] * trunk/ippTools/src/difftool.c (modified) * trunk/ippTools/src/difftoolConfig.c (modified) Select warps with a certain 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. Wed, 10 Sep 2008 01:00:40 GMT Paul Price [19447] * trunk/ippTools/src/stacktool.c (modified) Need to specify table names. Wed, 10 Sep 2008 00:56:57 GMT Paul Price [19446] * trunk/ippTools/src/stacktool.c (modified) Ditto. Wed, 10 Sep 2008 00:56:10 GMT Paul Price [19445] * trunk/ippTools/src/stacktool.c (modified) Which table? Wed, 10 Sep 2008 00:55:18 GMT Paul Price [19444] * trunk/ippTools/src/stacktool.c (modified) * trunk/ippTools/src/stacktoolConfig.c (modified) Adding search on label for stacktool -revertsumskyfile Tue, 09 Sep 2008 19:29:58 GMT Paul Price [19435] * trunk/ippTools/src/stacktool.c (modified) Need to specify table names. 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. Tue, 09 Sep 2008 02:11:02 GMT Paul Price [19430] * trunk/ippTools/src/faketool.c (modified) Don't promote from fake->warp if the tess_id isn't set. Tue, 09 Sep 2008 01:55:18 GMT Paul Price [19428] * trunk/ippTools/src/faketool.c (modified) Wrong joining word. Tue, 09 Sep 2008 01:39:37 GMT Paul Price [19425] * trunk/ippTools/src/faketool.c (modified) Getting into trouble with table names. Tue, 09 Sep 2008 01:38:13 GMT Paul Price [19424] * trunk/ippTools/src/faketool.c (modified) * trunk/ippTools/src/faketoolConfig.c (modified) Adding search on label for some faketool functions. Tue, 09 Sep 2008 00:28:25 GMT Paul Price [19423] * trunk/ippTools/src/camtool.c (modified) * trunk/ippTools/src/camtoolConfig.c (modified) * trunk/ippTools/src/pxcam.c (modified) Label use depends on the function, so can't include it in pxcam. Tue, 09 Sep 2008 00:17:12 GMT Paul Price [19422] * trunk/ippTools/src/chiptoolConfig.c (modified) Had wrong type. Tue, 09 Sep 2008 00:02:54 GMT Paul Price [19420] * trunk/ippTools/src/chiptool.c (modified) * trunk/ippTools/src/chiptoolConfig.c (modified) Adding label to search for chiptool -pendingimfile Mon, 08 Sep 2008 23:59:50 GMT Paul Price [19419] * trunk/ippTools/src/pxchip.c (modified) The source for the label varies with the operation, so it should be a ...