def getConsent(self, survey_id):
        with TRN:
            TRN.add("""SELECT agc.participant_name,
                              agc.participant_email,
                              agc.parent_1_name,
                              agc.parent_2_name,
                              agc.is_juvenile,
                              agc.deceased_parent,
                              agc.ag_login_id,
                              agc.date_signed,
                              agc.assent_obtainer,
                              agc.age_range,
                              agl.survey_id
                           FROM ag_consent agc
                           JOIN ag_login_surveys agl
                           USING (ag_login_id, participant_name)
                           WHERE agl.survey_id = %s""", [survey_id])
            result = TRN.execute_fetchindex()
            if not result:
                raise ValueError("Survey ID does not exist in DB: %s" %
                                 survey_id)
            return dict(result[0])