from flask import Flask
from flask import render_template
import random
from flask import request
from peewee import *

db = SqliteDatabase('cfd.db')

class Answers(Model):
    q1 = CharField()
    q2 = CharField()
    q3 = CharField()
    q4 = CharField()
    q5 = CharField()
    q6 = CharField()
    q7 = CharField()
    q8 = CharField()
    q9 = CharField()
    q10 = CharField()
    class Meta:
        database = db


questions = [["wie heisst du?",0],
            ["wo wohnst du?",1],
            ["brot?",2],
            ["was ist das beste hackaspace",3],
            ["lol",4],
            ["lel",5],
            ["lul",6],
            ["lal",7],
            ["loel",8],
            ["lil",9]]

app = Flask(__name__)

@app.route("/")
def start():
    return render_template("index.html",questions=questions)

@app.route("/submit", methods=["POST"])
def submit():
    answers = []
    for x in range(len(questions)):
        answers.append(request.form.get(str(x)))
        print(questions[x][0],request.form.get(str(x)))
    entr = Answers(q1=answers[0],
                    q2=answers[1],
                    q3=answers[2],
                    q4=answers[3],
                    q5=answers[4],
                    q6=answers[5],
                    q7=answers[6],
                    q8=answers[7],
                    q9=answers[8],
                    q10=answers[9])
    entr.save()
    return "danki"


if __name__ == "__main__":
    db.connect()
    db.create_tables([Answers])
    app.run()