sahana-s08-de-duplicator team mailing list archive

[Akilandeswari Ramakrishnan <aramakr@xxxxxxxx>]

Hi Pradnya,

I added this in the pr.py module. As of now,  I have collected the values of
one record in strlist array..
u can test by passing the same array twice.

jwalgo(strlist,strlist)

*Code for the menu:*

def shn_menu():
    response.menu_options = [
        [T("Home"), False, URL(r=request, f="index")],
        [T("Search for a Person"), False, URL(r=request, f="person",
args="search_simple")],
        [T("Persons"), False, URL(r=request, f="person"), [
            [T("List"), False, URL(r=request, f="person")],
            [T("Add"), False, URL(r=request, f="person", args="create")],
        ]],
        [T("Groups"), False, URL(r=request, f="group"), [
            [T("List"), False, URL(r=request, f="group")],
            [T("Add"), False, URL(r=request, f="group", args="create")],
        ]],
        #S08 - De-duplicator
*        [T("De-duplicator"), False, URL(r=request, f="people_duplicates")]]
*

*defined a function:*

#-------------------------------------------------------------------------------------------------------
#-----------------------------S08 -  People
deduplictor-------------------------------------------------
#-------------------------------------------------------------------------------------------------------

def people_duplicates():
    """
        Handle De-duplication of People
    """
    '''    Duplicate identification is done based on the 'first name only'.
       * This routine takes the first name from the 'pr_person' table
       * Each retrieved first name is passed to soundex algorithm
       * The soundex value is stored in the Table
       * Soundex value of each record is compared against every other record
in the table
       * Result is shown along with the dd
    '''

    persons=db().select  (db.pr_person.pe_label,
                          db.pr_person.missing,
                          db.pr_person.first_name,
                          db.pr_person.middle_name,
                          db.pr_person.last_name,
                          db.pr_person.preferred_name,
                          db.pr_person.local_name,
                          db.pr_person.age_group,
                          db.pr_person.gender,
                          db.pr_person.date_of_birth,
                          db.pr_person.nationality,
                          db.pr_person.country,
                          db.pr_person.religion,
                          db.pr_person.marital_status,
                          db.pr_person.occupation,
                          db.pr_person.tags,
                          db.pr_person.comments
                          )
    for person in persons:
        strlist =[]
        strlist.append(person.pe_label)
        strlist.append(person.missing)
        strlist.append(person.first_name)
        strlist.append(person.middle_name)
        strlist.append(person.last_name)
        strlist.append(person.preferred_name)
        strlist.append(person.local_name)
        strlist.append(person.age_group)
        strlist.append(person.gender)
        strlist.append(person.date_of_birth)
        strlist.append(person.nationality)
        strlist.append(person.country)
        strlist.append(person.religion)
        strlist.append(person.marital_status)
        strlist.append(person.occupation)
        strlist.append(person.tags)
        strlist.append(person.comments)
        print strlist


# S08 No authorization
    if deployment_settings.get_security_map() and not
shn_has_role("MapAdmin"):
        unauthorised()

    def delete_people(old, new):
        # Find all tables which link to the People table <pr_person>
        # @ToDo Replace with db.gis_location._referenced_by
        tables = shn_table_links("pr_person")

        for table in tables:
            for count in range(len(tables[table])):
                field = tables[str(db[table])][count]
                query = db[table][field] == old
                db(query).update(**{field:XXX})

        # Remove the record
        db(db.pr_person.id == old).update(deleted=True)

        return

    def open_btn(id):
        return A(T("Load Details"), _id=id, _href=URL(r=request,
f="person"), _class="action-btn", _target="_blank")

    def links_btn(id):
        return A(T("Linked Records"), _id=id, _href=URL(r=request,
f="location_links"), _class="action-btn", _target="_blank")

    # Unused: we do all filtering client-side using AJAX
    filter = request.vars.get("filter", None)

    #repr_select = lambda l: len(l.name) > 48 and "%s..." % l.name[:44] or
l.name
    repr_select = lambda l: l.first_name # and "%s (%s)" % (l.first_name,
response.s3.gis.location_hierarchy[l.level]) or l.first_name

    if filter:
        requires = IS_ONE_OF(db, "pr_person.id", repr_select,
filterby="first_name", filter_opts=(filter,),
orderby="pr_person.first_name", sort=True)
    else:
        requires = IS_ONE_OF(db, "pr_person.id", repr_select,
orderby="pr_person.first_name", sort=True, zero=T("Select a Person"))

    table = db.pr_person
    form = SQLFORM.factory(
                           Field("old", table, requires=requires, label =
SPAN(B(T("Old")), " (" + T("To delete") + ")"),
comment=DIV(links_btn("linkbtn_old"), open_btn("btn_old"))),
                           Field("new", table, requires=requires, label =
B(T("New")), comment=DIV(links_btn("linkbtn_new"), open_btn("btn_new"))),
                           formstyle = s3_formstyle
                          )

    form.custom.submit.attributes['_value'] = T("Delete Old")

    if form.accepts(request.vars, session):
        _vars = form.vars

        if not _vars.old == _vars.new:
            # Take Action
            delete_location(_vars.old, _vars.new)
            session.confirmation = T("People De-duplicated")
            redirect(URL(r=request))
        else:
            response.error = T("Person should be different!")

    elif form.errors:
         response.error = T("Need to select 2 Persons")

    return dict(form=form)
#---------------------------------------------------------------------------------------------------------------------------------------