rtree/retrieveAllZipcode.c

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

    /* Set key lookup information */
    key.type = RDM_RTREE_ALL; /* Lookup all values in the R-tree */

    /* Start an update transaction */
    rc = rdm_dbStartRead (db, RDM_LOCK_ALL, 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);
            while (rc == sOKAY)
            {
                /* Read the row */
                rc = rdm_cursorReadRow (
                    cursor, &poi, sizeof (POINTSOFINTEREST), NULL);

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

            /* We expect to break out of the while loop with sENDOFCURSOR */
            if (rc == sENDOFCURSOR)
            {
                rc = sOKAY;
            }

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

        /* End the read transaction (free locks) */
        (void) rdm_dbEnd (db);
    }

    return rc;
}