def process_dbquestiontags(self, question_identifier, tag): dbquestiontag = QuestionsTags() dbquestiontag.question_identifier = question_identifier for dbtag in self.dbtags: if dbtag.tag == tag: dbquestiontag.tag_id = dbtag.id break if dbquestiontag.tag_id is None: logging.debug(tag + " NOT found. Adding it") # First look for it in the db dbtag = self.session.query(Tags).filter(Tags.tag == tag).first() if dbtag is None: dbtag = Tags() dbtag.tag = tag self.session.add(dbtag) self.session.commit() self.dbtags.append(dbtag) dbquestiontag.tag_id = dbtag.id self.session.add(dbquestiontag) self.session.commit()