def get_user_info(self, supplied_kit_id):
        with TRN:
            sql = """SELECT CAST(ag_login_id AS VARCHAR(100)) AS ag_login_id,
                            email, name, address, city, state, zip, country
                     FROM ag_login
                     INNER JOIN ag_kit USING(ag_login_id)
                     WHERE supplied_kit_id = %s"""
            TRN.add(sql, [supplied_kit_id])
            row = TRN.execute_fetchindex()
            if not row:
                raise ValueError('Supplied kit id is not in DB: %s' %
                                 supplied_kit_id)
            user_data = dict(row[0])
            user_data['ag_login_id'] = str(user_data['ag_login_id'])
            return user_data