IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 30283 for trunk/ippTools/share


Ignore:
Timestamp:
Jan 14, 2011, 7:24:31 PM (16 years ago)
Author:
watersc1
Message:

is_daytime fix in register_imfile; bad class_ids in regtool; bad joins in the SQL

Location:
trunk/ippTools/share
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/regtool_checkburntoolimfile.sql

    r30277 r30283  
    1111       newExp.exp_id,
    1212       summitExp.exp_type,
    13        rawExp.dateobs,
    14        rawExp.obs_mode AS obs_mode,
    15        rawExp.object AS object,
     13       rawImfile.dateobs,
     14       rawImfile.obs_mode AS obs_mode,
     15       rawImfile.object AS object,
    1616       rawImfile.burntool_state AS burntool_state,
    1717       rawImfile.class_id,
    … …  
    2626       LEFT JOIN newImfile ON (summitImfile.class_id = newImfile.tmp_class_id AND newExp.exp_id = newImfile.exp_id)
    2727       LEFT JOIN rawExp ON rawExp.exp_id = newExp.exp_id
    28        LEFT JOIN rawImfile ON (rawImfile.exp_id = rawExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
     28       LEFT JOIN rawImfile ON (rawImfile.exp_id = newExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
    2929       WHERE
    3030             summitExp.dateobs >= '@DATEOBS_BEGIN@'

  • trunk/ippTools/share/regtool_pendingburntoolimfile.sql

    r30240 r30283  
    1212       newImfile.tmp_class_id,
    1313       summitExp.exp_type,
    14        rawExp.dateobs,
    15        rawExp.obs_mode AS obs_mode,
    16        rawExp.object AS object,
     14       rawImfile.dateobs,
     15       rawImfile.obs_mode AS obs_mode,
     16       rawImfile.object AS object,
    1717       rawImfile.burntool_state AS burntool_state,
    1818       rawImfile.class_id,
    … …  
    2727       LEFT JOIN newImfile ON (summitImfile.class_id = newImfile.tmp_class_id AND newExp.exp_id = newImfile.exp_id)
    2828       LEFT JOIN rawExp ON rawExp.exp_id = newExp.exp_id
    29        LEFT JOIN rawImfile ON (rawImfile.exp_id = rawExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
     29       LEFT JOIN rawImfile ON (rawImfile.exp_id = newExp.exp_id AND rawImfile.tmp_class_id = newImfile.tmp_class_id)
    3030       WHERE
    3131             summitExp.dateobs >= '@DATEOBS_BEGIN@'
Note: See TracChangeset for help on using the changeset viewer.