summary_parse.pl - Update the Sybase starcheck summary table of the aca database
summary_parse.pl [ mission planning directory ]
This script populates a table that stores all of the obsid-summary information from starcheck.txt. When called without any options, the script queries the mp_load_info table to get a list of all load directories that have newer ``processed dates'' than the dates already within the starcheck_summary table. The obsid summary data from the starcheck files within those directories are then added to the starcheck_summary table. If the script is run on a directory that already exists within the table (either reprocessed in automatic processing and hence updated in the mp_load_info table, or specified at the command line), the old information is deleted and a new entry is created.
name type length -------------------------------------------------- ---------- ----------- mp_path varchar 30 obsid int 4 tstart varchar 25 last_ap_date datetimn 8 line_num intn 4
This script should be run in an overnight cron job with no input parameters.
Jean Connelly, <jeanconn@localdomain>
Copyright 2006 by Smithsonian Astrophysical Obsevatory
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.