IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Feb 21, 2008, 6:09:46 PM (18 years ago)
Author:
jhoblitt
Message:

replumb pz* steps

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/ippTools/src/pzgetexp.c

    r16170 r16588  
    22 * pzgetexp.c
    33 *
    4  * Copyright (C) 2006  Joshua Hoblitt
     4 * Copyright (C) 2006-2008  Joshua Hoblitt
    55 *
    66 * This program is free software; you can redistribute it and/or modify it
     
    186186    psFree(newSummitExps);
    187187
    188     // add new exps to pzPendingExp -- must be done before the new exps are
    189     // added to summitExp because of the SQL logic
    190     {
    191         char *query =
    192             "INSERT INTO pzPendingExp"
    193             "   SElECT"
    194             "       incoming.exp_name,"
    195             "       incoming.camera,"
    196             "       incoming.telescope"
    197             "   FROM incoming"
    198             "   LEFT JOIN summitExp"
    199             "       USING(exp_name, camera, telescope)"
    200             "   WHERE"
    201             "       summitExp.exp_name is NULL"
    202             "       AND summitExp.camera is NULL"
    203             "       AND summitExp.telescope is NULL";
    204 
    205         if (!p_psDBRunQuery(config->dbh, query)) {
    206             // rollback
    207             if (!psDBRollback(config->dbh)) {
    208                 psError(PS_ERR_UNKNOWN, false, "database error");
    209             }
    210             psError(PS_ERR_UNKNOWN, false, "database error");
    211             return false;
    212         }
    213     }
    214 
    215188    // add new exps to summitExp
    216189    {
Note: See TracChangeset for help on using the changeset viewer.