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