class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text)
question_group_id = db.Column(db.Integer, db.ForeignKey('question_group.id'))
choices = db.relationship('Choice', backref='question')
question_type = db.Column(db.Text)
madlib_associations = db.relationship("QuestionMadlib", back_populates="question")
searchable_field = 'text'
def __init__(self, text):
self.text = text
# self.question_type = question_type
def madlibs_as_dict(self):
new_dict = {}
for madlib_association in self.madlib_associations:
madlib = madlib_association.madlib
new_dict[madlib_association.key] = madlib.jsonify()
return new_dict
def jsonify(self):
return {
"type": "question",
"text": self.text,
# "question_type": self.question_type,
"choices": [ choice.text for choice in self.choices ],
"madlibs": self.madlibs_as_dict()
}
class FormContext(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
forms = db.relationship('Form', backref='form_context')
searchable_field = 'name'
def __init__(self, name):
self.name = name
class QuestionGroupTemplate(db.Model):
id = db.Column(db.Integer, primary_key=True)
template = db.Column(db.Text)
version = db.Column(db.Integer, default = 0)
searchable_field = 'template'
def __init__(self, template):
self.template = template
class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text, unique=True)
forms = db.relationship('Form', backref='client')
searchable_field = 'name'
def __init__(self, name):
self.name = name
class QuestionMadlib(db.Model):
question_id = db.Column(db.Integer, db.ForeignKey('question.id'), primary_key = True)
madlib_id = db.Column(db.Integer, db.ForeignKey('madlib.id'), primary_key = True)
key = db.Column(db.Text)
madlib = db.relationship('Madlib', back_populates="question_associations")
question = db.relationship('Question', back_populates="madlib_associations")
def __init__(self,key):
self.key = key
class Choice(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text)
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
choice_template_id = db.Column(db.Integer, db.ForeignKey('choice_template.id'))
searchable_field = 'text'
def __init__(self, text):
self.text = text
class QuestionTemplate(db.Model):
id = db.Column(db.Integer, primary_key=True)
template = db.Column(db.Text)
version = db.Column(db.Integer, default = 0)
question_group_template_id = db.Column(db.Integer, db.ForeignKey('question_group_template.id'))
choice_templates = db.relationship('ChoiceTemplate')
searchable_field = 'template'
def __init__(self, template):
self.template = template
class QuestionGroup(db.Model):
id = db.Column(db.Integer, primary_key = True)
version = db.Column(db.Integer, default = 0)
title = db.Column(db.Text)
parent_id = db.Column(db.Integer, db.ForeignKey('question_group.id'))
question_group_template_id = db.Column(db.Integer, db.ForeignKey('question_group_template.id'))
forms = db.relationship('Form', backref='question_group')
questions = db.relationship('Question', backref='question')
parent = db.relationship('QuestionGroup', remote_side=id, backref='question_groups')
def __init__(self, title):
self.title = title
# TODO: add proper ordering
def children(self):
return (self.question_groups or []) + self.questions
def jsonify(self):
return {
"type": "question_group",
"title": self.title,
"children": [ child.jsonify() for child in self.children() ]
}
class Madlib(db.Model):
id = db.Column(db.Integer, primary_key=True)
placeholder = db.Column(db.Text)
word = db.Column(db.Text)
word_type = db.Column(db.Text)
version = db.Column(db.Integer, default = 0)
client_id = db.Column(db.Integer, db.ForeignKey('client.id'))
question_associations = db.relationship("QuestionMadlib", back_populates="madlib")
searchable_field = 'word'
def __init__(self, word):
self.word = word
def jsonify(self):
return {
"text": self.word,
"id": self.id
}
class Form(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.Text)
version = db.Column(db.Integer, default = 0)
client_id = db.Column(db.Integer, db.ForeignKey('client.id'))
question_group_id = db.Column(db.Integer, db.ForeignKey('question_group.id'))
form_context_id = db.Column(db.Integer, db.ForeignKey('form_context.id'))
searchable_field = 'title'
def __init__(self, title):
self.title = title
def jsonify(self):
# return {
# "id": self.id,
# "type": "form",
# "form_question_group": self.question_group.jsonify()
# }
return self.question_group.jsonify()