rtree/updateZipcode.c

static RDM_RETCODE updateZipCode (RDM_DB db)
{
    RDM_RETCODE rc = sOKAY;
    RDM_CURSOR cursor = NULL;
    POINTSOFINTEREST poi = {0};
    POINTSOFINTEREST_LOCATION_KEY keyVal = {{0}};
    RDM_RTREE_KEY key = {0};

    /* Set the key value for the lookup */
    keyVal.location[0] = -116.577610; /* Longitude is the 'x' value */
    keyVal.location[1] = 43.529812;   /* Latitude is the 'y' value */
    keyVal.location[2] = -116.577610; /* Longitude is the 'x' value */
    keyVal.location[3] = 43.529812;   /* Latitude is the 'y' value */

    /* Set key lookup information */
    key.type = RDM_RTREE_EXACT; /* Lookup the exact value */
    key.value = &keyVal;
    key.bytesIn = sizeof (POINTSOFINTEREST_LOCATION_KEY);

    /* Start an update transaction */
    rc = rdm_dbStartUpdate (db, RDM_LOCK_ALL, 0, NULL, 0, NULL);
    if (rc == sOKAY)
    {
        /* Get a cursor based on the r-tree key information */
        rc = rdm_dbGetRowsByKeyInRtreeKeyRange (
            db, KEY_POINTSOFINTEREST_LOCATION, &key, &cursor);
        if (rc == sOKAY)
        {
            /* Move to the first (should be only) row in the cursor */
            rc = rdm_cursorMoveToFirst (cursor);
            if (rc == sOKAY)
            {
                /* Read the entire row */
                rc = rdm_cursorReadRow (
                    cursor, &poi, sizeof (POINTSOFINTEREST), NULL);

                /* Increase the maximum longitude/latitude, this zipcode will
                   now have a rectangle instead of just a point */
                keyVal.location[2] =
                    -116.577620;                /* Longitude is the 'x' value */
                keyVal.location[3] = 43.529822; /* Latitude is the 'y' value */

                /* Write the update row values to the database */
                rc = rdm_cursorUpdateRow (
                    cursor, &poi, sizeof (POINTSOFINTEREST));
            }

            /* Free the cursor */
            (void) rdm_cursorFree (cursor);
        }

        if (rc == sOKAY)
        {
            /* Commit the successful transaction */
            rc = rdm_dbEnd (db);
        }
        else
        {
            /* Rollback the failed transaction */
            (void) rdm_dbEndRollback (db);
        }
    }

    return rc;
}