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