cursor/registerMembers.c

static RDM_RETCODE registerMembers (
RDM_CURSOR club,
RDM_CURSOR lastMember,
RDM_CURSOR beforeFirstMember,
RDM_DB db)
{
RDM_RETCODE rc = sOKAY;
RDM_CURSOR member = NULL;
RDM_CURSOR_COMPARE comparison;


/* Clone fistMember to keep its position as is */

rc = rdm_cursorGetClone (lastMember, &member);


if (rc == sOKAY)
{
rc = rdm_cursorComparePosition (member, beforeFirstMember, &comparison);
}
while (rc == sOKAY && comparison == CURSOR_AFTER)
{
rc = rdm_cursorLinkRow (member, REF_MEMBERS, club);
if (rc == sOKAY)
{
rc = rdm_cursorMoveToPrevious (member);
if (rc == sENDOFCURSOR)
rc = sOKAY;
}
if (rc == sOKAY)
{
rc = rdm_cursorComparePosition (
member, beforeFirstMember, &comparison);
}
}
rdm_cursorFree (member);


return rc;
}


static RDM_RETCODE registerJuniorMembers (
RDM_CURSOR club,
RDM_CURSOR firstMember,
RDM_CURSOR afterLastMember,
RDM_DB db)
{
RDM_RETCODE rc = sOKAY;
RDM_CURSOR member = NULL;
RDM_CURSOR_COMPARE comparison;


/* Clone fistMember to keep its position as is */

rc = rdm_cursorGetClone (firstMember, &member);


if (rc == sOKAY)
{
rc = rdm_cursorComparePosition (member, afterLastMember, &comparison);
}
while (rc == sOKAY && comparison == CURSOR_BEFORE)
{
rc = rdm_cursorLinkRow (member, REF_JUNIOR_MEMBERS, club);
if (rc == sOKAY)
{
rc = rdm_cursorMoveToNext (member);
if (rc == sENDOFCURSOR)
rc = sOKAY;
}
if (rc == sOKAY)
{
rc = rdm_cursorComparePosition (
member, afterLastMember, &comparison);
}
}
rdm_cursorFree (member);


return rc;
}


static RDM_RETCODE registerHalfOfTheAdultsAsMembers (RDM_CURSOR club, RDM_DB db)
{
RDM_RETCODE rc;
uint64_t numMembers;
RDM_CURSOR adults = NULL;
RDM_CURSOR beforeFirst = NULL;
uint64_t i;


printf ("Register half of the adults as members:\n");


rc = rdm_rdmGetBeforeFirst (&beforeFirst);
if (rc == sOKAY)
{
rc = rdm_dbGetRows (db, TABLE_ADULT, &adults);
}
if (rc == sOKAY)
{
rc = rdm_cursorGetCount (adults, &numMembers);
}
if (rc == sOKAY)
{
rc = rdm_cursorMoveToLast (adults);
}
for (i = 0; rc == sOKAY && i < numMembers / 2; i++)
{
rc = rdm_cursorMoveToPrevious (adults);
}
if (rc == sOKAY)
{
rc = registerMembers (club, adults, beforeFirst, db);
}
rdm_cursorFree (adults);
return rc;
}