rtree/deleteZipcode.c

static RDM_RETCODE deleteZipCode (RDM_DB db)
{
    RDM_RETCODE rc = sOKAY;
    RDM_CURSOR cursor = NULL;
    POINTSOFINTEREST_CITY_KEY keyVal = {{0}};
    RDM_RANGE_KEY range = {0};

    /* Set the key value for the lookup */
    strcpy (keyVal.city, "Nampa");

    /* Set key lookup information */
    range.value = &keyVal;
    range.range = RDM_RANGE_OPEN;
    range.bytesIn = sizeof (POINTSOFINTEREST_CITY_KEY);
    range.numKeyCols = 1;

    /* Start an update transaction */
    rc = rdm_dbStartUpdate (db, RDM_LOCK_ALL, 0, NULL, 0, NULL);
    if (rc == sOKAY)
    {
        /* Get a range cursor based on the city key */
        rc = rdm_dbGetRowsByKeyInRangeKeyRange (
            db, KEY_POINTSOFINTEREST_CITY, &range, &range, &cursor);
        if (rc == sOKAY)
        {
            /* Move to the first (should be only) row in the cursor */
            rc = rdm_cursorMoveToFirst (cursor);
            while (rc == sOKAY)
            {
                /* Delete the row */
                rc = rdm_cursorDeleteRow (cursor);

                if (rc == sOKAY)
                {
                    rc = rdm_cursorMoveToNext (cursor);
                }
            }

            /* We expect sENDOFCURSOR when we break out of the loop */
            if (rc == sENDOFCURSOR)
            {
                rc = sOKAY;
            }

            /* 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;
}