IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Feb 21, 2007, 3:59:20 PM (19 years ago)
Author:
jhoblitt
Message:

s/Scfile/Skyfile/g
s/scfile/skyfile/g
s/SCFILE/SKYFILE/g

File:
1 edited

Legend:

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

    r11983 r11985  
    761761        " JOIN p4SkyCellMap\n"
    762762        "   USING(p4_id)\n"
    763         " LEFT JOIN p4Scfile\n"
     763        " LEFT JOIN p4Skyfile\n"
    764764        "   USING(p4_id, skycell_id, tess_id)\n"
    765765        " WHERE\n"
    766766        "   p4Run.state = 'run'\n"
    767         "   AND p4Scfile.p4_id IS NULL\n"
    768         "   AND p4Scfile.skycell_id IS NULL\n"
    769         "   AND p4Scfile.tess_id IS NULL\n"
     767        "   AND p4Skyfile.p4_id IS NULL\n"
     768        "   AND p4Skyfile.skycell_id IS NULL\n"
     769        "   AND p4Skyfile.tess_id IS NULL\n"
    770770    );
    771771
     
    893893    }
    894894
    895     // we don't want to insert the last scfile in a run but then not mark the
     895    // we don't want to insert the last skyfile in a run but then not mark the
    896896    // run as 'stop'
    897897    if (!psDBTransaction(config->dbh)) {
     
    901901
    902902    // XXX need to validate that this coresponds to an p4InputImfile
    903     if (!p4ScfileInsert(config->dbh,
     903    if (!p4SkyfileInsert(config->dbh,
    904904            (psS32)atoi(p4_id),
    905905            skycell_id,
     
    949949        "           p4Run.p4_id,\n"
    950950        "           p4SkyCellMap.p4_id as foo,\n"
    951         "           p4Scfile.p4_id as bar\n"
     951        "           p4Skyfile.p4_id as bar\n"
    952952        "       FROM p4Run\n"
    953953        "       JOIN p4SkyCellMap\n"
    954954        "           USING(p4_id)\n"
    955         "       LEFT JOIN p4Scfile\n"
     955        "       LEFT JOIN p4Skyfile\n"
    956956        "           USING(p4_id, skycell_id, tess_id)\n"
    957957        "       WHERE\n"
     
    960960        "           p4Run.p4_id\n" 
    961961        "       HAVING\n"
    962         "       COUNT(p4SkyCellMap.p4_id) = COUNT(p4Scfile.p4_id)\n"
     962        "       COUNT(p4SkyCellMap.p4_id) = COUNT(p4Skyfile.p4_id)\n"
    963963        "       ) as Foo\n"
    964964        "   )\n"
     
    990990    psString query = psStringCopy(
    991991        "SELECT\n"
    992         "   p4Scfile.*\n"
     992        "   p4Skyfile.*\n"
    993993        " FROM p4Run\n"
    994         " JOIN p4Scfile\n"
     994        " JOIN p4Skyfile\n"
    995995        "   USING(p4_id)\n"
    996996        " WHERE\n"
     
    999999
    10001000    if (config->where) {
    1001         psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p4Scfile");
     1001        psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p4Skyfile");
    10021002        psStringAppend(&query, " AND %s", whereClause);
    10031003        psFree(whereClause);
     
    10331033    }
    10341034    if (!psArrayLength(output)) {
    1035         psError(PS_ERR_UNKNOWN, false, "no p4Scfile rows found");
     1035        psError(PS_ERR_UNKNOWN, false, "no p4Skyfile rows found");
    10361036        psFree(output);
    10371037        return true;
     
    10501050    if (psArrayLength(output)) {
    10511051        // negative simple so the default is true
    1052         if (!ippdbPrintMetadatas(stdout, output, "p4Scfile", !simple)) {
     1052        if (!ippdbPrintMetadatas(stdout, output, "p4Skyfile", !simple)) {
    10531053            psError(PS_ERR_UNKNOWN, false, "failed to print array");
    10541054            psFree(output);
Note: See TracChangeset for help on using the changeset viewer.