| 66 | | {{{ippToPsps}}} works like this: |
| 67 | | |
| 68 | | * reads all relevant FITS tables from a given {{{smf}}} or {{{cmf}}} into temporary tables in a 'scratch' MySQL database |
| 69 | | * creates empty MySQL tables for PSPS output (also in the 'scratch' database). These tables match the shape of the final PSPS database tables exactly. |
| 70 | | * copies all relevant columns from the temporary IPP tables into the PSPS tables, discarding duplicates where necessary |
| 71 | | * accesses the DVO database and creates temporary MySQL tables containing all the detections for this {{{smf}}} or {{{cmf}}} |
| 72 | | * updates the PSPS tables with the IDs from the DVO MySQL tables |
| 73 | | * replaces any NULL values with -999, as required by the PSPS loader |
| 74 | | * exports the PSPS tables to a FITS file |
| 75 | | * publishes FITS file, complete with a batch 'manifest' file, to the datastore |
| 76 | | |
| 77 | | The reading and export of FITS tables is done using STILTS. For import, we can specify which columns we wish to import from the IPP smf and cmf files (we don't need everything). |
| | 66 | |