def get(self, msg=""): surveys = get_surveys_by_email(self.db, self.current_user, 10) recent_submissions = submission_api.get_all(self.db, email=self.current_user, limit=5, direction='DESC') self.render('index.html', message=msg, surveys=surveys, recent_submissions=recent_submissions)
def get_all(connection: Connection, email: str) -> dict: """ Return a JSON representation of all the surveys for a user. :param connection: a SQLAlchemy Connection :param email: the user's e-mail address. :return: the JSON string representation """ surveys = get_surveys_by_email(connection, email) return json_response([_to_json(connection, survey) for survey in surveys])
def testGetSurveysForUserByEmail(self): user = connection.execute(auth_user_table.select().where( auth_user_table.c.email == 'test_email')).first() condition = survey_table.c.auth_user_id == user.auth_user_id surveys = connection.execute(survey_table.select().where( condition)).fetchall() surveys_by_email = get_surveys_by_email(connection, user.email) self.assertEqual(len(surveys), len(surveys_by_email)) self.assertEqual(surveys[0].survey_id, surveys_by_email[0].survey_id)