'Join for a super-component'

def testGetJoinSuperComponent(self):

    resource = current.s3db.resource('pr_person')
    component = resource.components['contact']
    rtable = resource.table
    ctable = component.table
    expected = ((rtable.pe_id == ctable.pe_id) & (ctable.deleted != True))
    join = component.get_join()
    self.assertEqual(str(join), str(expected))
