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)
