Beispiel #1
0
    def set_questions(self, texts):
        """Sets and saves the questions using a sequence of texts

        The function updates the questions relationship so the text of its
        questions match the sequence of texts provided and saves the result
        to the database. It removes any question whose text is not in texts.
        It does nothing to questions whose text is in texts. It adds a new
        question for each text in texts that is not in questions. All 
        duplicates questions are removed.

        Args:
            questions: a sequence of strings representing the text of
                each question
        """
        old_texts = set([q.text for q in self.questions])
        texts = set(texts)
        for text in texts - old_texts:
            q = Question(text, self)
            db_session.add(q)
        for text in old_texts - texts:
            for q in self.questions:
                if q.text == text:
                    db_session.delete(q)
                    break
        db_session.commit()
Beispiel #2
0
def main(config_filename):
    app = create_app(config_filename)
    mailbox = DailyLogResponseMailbox(app.config['MAIL_SERVER'],
                                      app.config['MAIL_USER'],
                                      app.config['MAIL_PASSWORD'])
    uids = mailbox.uids()[:app.config['MAILS_PER_PROCESS']]
    for uid in uids:
        email = mailbox.get_email(uid)
        user = User.query.filter_by(email=email.sender).first()
        # todo error checking that the user does not exist
        # todo error checking that the email is not a valid dailylogemail
        answers = email.get_answers([q.text for q in user.questions])
        date = email.get_date()
        for i in xrange(len(answers)):
            answer = Answer(answers[i], date, user, user.questions[i])
            db_session.add(answer)
        db_session.commit()

    # todo get rid of the uids that errored out
    mailbox.delete(uids)