def testGetNumberOfSurveys(self): number_of_surveys = get_number_of_surveys(connection, 'test_email') self.assertEqual(number_of_surveys, 1) connection.execute(create_auth_user(email='TestSurveyEmail')) zero_surveys = get_number_of_surveys(connection, 'TestSurveyEmail') self.assertEqual(zero_surveys, 0)
def get(self): email = self.get_email() # Shorter variable names auth_user = auth_user_table survey = survey_table submission = submission_table submission_id = submission_table.c.submission_id submission_time = submission_table.c.submission_time result = self._get_records( table=auth_user.join(survey).outerjoin(submission), email=email, selected=[ survey_table.c.survey_title, count(submission_id).label('num_submissions'), # survey_table.c.created_on, sqlmax(submission_time).label('latest_submission'), survey_table.c.survey_id, ], text_filter_column=survey_table.c.survey_title, default_sort_column_name='latest_submission', total_records=get_number_of_surveys(self.db, email) ) self.write(result)