def testGetNumberOfSubmissions(self): survey_id = connection.execute(survey_table.select().where( survey_table.c.survey_title == 'test_title')).first().survey_id submission_exec = connection.execute( submission_insert(submitter='test_submitter', submitter_email='*****@*****.**', survey_id=survey_id)) submission_id = submission_exec.inserted_primary_key[0] connection.execute(submission_table.select().where( submission_table.c.submission_id == submission_id)) self.assertEqual(get_number_of_submissions(connection, survey_id), 1)
def get(self, survey_id): email = self.get_email() result = self._get_records( table=auth_user_table.join(survey_table).join(submission_table), email=email, selected=[ submission_table.c.submission_id, submission_table.c.submitter, submission_table.c.submission_time, submission_table.c.save_time ], where=submission_table.c.survey_id == survey_id, text_filter_column=submission_table.c.submitter, default_sort_column_name='submission_time', total_records=get_number_of_submissions(self.db, survey_id) ) self.write(result)