Forums

# Predictor - User makes predictions and saves/ 
@app.route('/predictor/',methods=['GET','POST'])  
@login_required
def predictions():
    user_id = g.user.id
    # retrieve predictions
    prediction= db.session.query(Fixture_prediction,\
               Fixture_prediction.fixture_id,Fixture.stage,\
               Fixture.home_team,Fixture_prediction.home_score,\
               Fixture_prediction.away_score,Fixture.away_team)\
               .outerjoin(Fixture,Fixture.id==Fixture_prediction.fixture_id)\
               .outerjoin(User,Fixture_prediction.user_id == User.id)\
               .filter(Fixture_prediction.fixture_id==Fixture.id)\
               .filter(Fixture_prediction.user_id==user_id).all()
    data = {'predictions': prediction}
    form = PredictionListForm(data=MultiDict(data))
   if request.method == 'POST':
       if form.validate() == False:
            flash('A score is missing, please fill in all predictions')
           render_template('predictor.html', form=form)
       else:
           for prediction in form.predictions:
               Fixture_prediction.query\
                   .filter_by(user_id=user_id)\
                   .update({'fixture_id':request.form['fixture_id']\
                       ,'home_score':request.form['home_score']\
                       ,'away_score':request.form['away_score']})
               db.session.commit()
               flash('Prediction added')
               return redirect(url_for('predictions'))
   # display current predictions
   elif request.method == 'GET':
       print form.data()
       return render_template('predictor.html', form=form)