class Questionnaire_Form(Form):
# Let's hardcode some data.
# First, income levels:
income_levels = ["0-30,000", "30,001-48,000", "48,001-75,000", "75,001-110,000", "over 110,000"]
income_choices = [("", "")]
for level in income_levels:
if level == "over 110,000":
income_choices.append((level, "Over $110,000"))
else:
income_choices.append((level, "$"+level))
# Next, US states:
states = ["Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming"]
state_choices = [("", "")]
for state in states:
state_choices.append((state, state))
# Last, budget categories:
budget_choices = [
("", ""),
("10000", "Less than $10,000"),
("20000", "$10,000 - $20,000"),
("40000", "$20,000 - $40,000"),
("60000", "$40,000 - $60,000"),
("80000", "$60,000 - $80,000"),
("100000", "$80,000 - $100k"),
("120000", "$100k - $120k"),
("150000", "$120k - $150k"),
("200000", "$150k - $200k"),
("300000", "More than $200k")
]
# With that out of the way, let's generate some fields!
first_name = StringField("First name:", validators = [Required("Please enter your first name.")])
last_name = StringField("Last name:", validators = [Required("Please enter your last name.")])
email = EmailField("Email:", validators = [Required("Please enter your email."), Email("Please enter a valid email address.")])
photo = FileField("Photo:", validators = [FileAllowed(["jpg", "png", "jpeg"], "Your photo needs to be either a JPEG or PNG. Sorry!")])
career = SelectQueryField("Career:", query = Career.select().join(Recipe).distinct().where(Recipe.career == Career.id), get_label = "name", allow_blank = True, blank_text = " ", validators = [Required("Please choose a career.")])
appeal = TextAreaField("Why does this career appeal to you?")
experience = TextAreaField("Do you have any experiences related to the career you chose?")
income = SelectField("What's your family's income level?", choices = income_choices, validators = [Required("Please select your family's income level.")])
budget = SelectField("What's your budget for higher education?", choices = budget_choices, validators = [Required("Please enter a budget.")])
list_of_choices = ["Personal savings", "Student loans", "Help from parents or relatives", "Federal grants", "Scholarships or private grants"]
choices = [(x, x) for x in list_of_choices]
payment = MultiCheckboxField("How do you plan to pay for college?", choices = choices)
scholarships = StringField("If you're expecting to receive scholarships or private grants, how much do you expect total?")
gpa = StringField("What's your high school GPA?")
test_score = StringField("What's your SAT or ACT score?")
city = StringField("What city do you live in?", validators = [Required("Please enter the city you live in.")])
state = SelectField("What state do you live in?", choices = state_choices, validators = [Required("Please enter the state you live in.")])
stay_home = RadioField("Is it important to you to stay close to home?", choices = [("Yes", "Yes"), ("No", "No")])
considering = StringField("What's a college you're already considering?")
alternatives = RadioField("Are you willing to consider online & alternative schools?", choices = [("Yes", "Yes"), ("No", "No")])
misc = TextAreaField("Do you have any additional needs we should know about?")
def handle_foreign_key(self, model, field, **kwargs):
if field.null:
kwargs['allow_blank'] = True
if field.choices is not None:
field_obj = SelectQueryField(query=field.choices, **kwargs)
else:
field_obj = ModelSelectField(model=field.rel_model, **kwargs)
return FieldInfo(field.name, field_obj)
class Add_Report(Form):
student = SelectQueryField("Make a report for:", query = Student.select(), get_label = "name", validators = [Required()])
career = SelectQueryField("Choose a career:", query = Career.select(), get_label = "name", allow_blank = True, blank_text = " ", validators = [Required()])
class Choose_Report(Form):
report = SelectQueryField("Choose a report to view:", query = Report.select(), get_label = "career.name", allow_blank = True, blank_text = " ", validators = [Required()])
class Choose_Student(Form):
student = SelectQueryField("Choose a student:", query = Student.select(), get_label = "name", allow_blank = True, blank_text = " ", validators = [Required()])