@app.route('/survey', methods=['get'])
def question_page():
    questions = Question.query.all()
    return render_template(
        'questinnaire.html',
        questions=questions
    )

def survey():
    if not request.args:
        return redirect(url_for('index'))
    gender = request.args.get['gender']
    age = request.args.get['age']

    user = Data(
        gender=gender,
        age=age
    )
    db.session.add(user)
    db.session.commit()
    db.session.refresh(user)
    ask = request.args.get('ask')
    ask2 = request.args.get('ask2')
    ask3 = request.args.get('ask3')
    ask4 = request.args.get('ask4')
    ask5 = request.args.get('ask5')
    ask6 = request.args.get('ask6')

    answer = Result(id=user.person.id, ask=ask, ask2=ask2, ask3=ask3, ask4=ask4, ask5=ask5, ask6=ask6)
    db.session.add(answer)
    db.session.commit()
    return 'Ok'

db = SQLAlchemy()

class Question(db.Model):
    __tablename__="questions"

    question_id = db.Column('question_id', db.Integer, primary_key=True)
    questions = db.Column('questions', db.Text)


class Result(db.Model):
    __tablename__="answers"

    answers_id = db.Column('answer_id', db.Integer, primary_key=True)
    ask = db.Column(db.Text)
    ask2 = db.Column(db.Text)
    ask3 = db.Column(db.Text)
    ask4 = db.Column(db.Text)
    ask5 = db.Column(db.Text)
    ask6 = db.Column(db.Text)


class Data(db.Model):
    __tablename__="person"

    person_id = db.Column('person_id', db.Integer, primary_key=True)
    gender = db.Column('gender', db.Text)
    age = db.Column('age', db.Integer)