from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from datetime import datetime

from database_setup import Base, RecipeUsers, Recipes, RecipeComments, RecipeLikes, RecipeProcess, RecipeIngredients, ghostUser, ghostGame, ghostComplete, SurveyUsers, SurveyResults, SurveyQuestions, PoolUsers, PoolGolfers, PoolGroups, PoolChoices, PoolTournaments, PoolResults


import psycopg2

engine = create_engine('sqlite:////var/www/jbv2/jbv2/jb.db')
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
Base.metadata.bind = engine

DBSession = sessionmaker(bind=engine)
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()

results = session.query(PoolResults)
for result in results:
    if result.tournament.name == "Farmers Insurance Open" and result.golfer.name == "Beau Hossler":
        result.overall = 51
        session.add(result)
        session.commit()

# tournaments = session.query(PoolTournaments)
# for tournie in tournaments:
#     tournie.delete()

# golfers = session.query(PoolGolfers)
# users = session.query(PoolUsers)
# user = users.filter_by(username='ryanarnold').one()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='edarnold').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Day').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='teresabrassington').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lee Westwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='garybalaski').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ian Poulter').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='davejones').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='tylerroberge').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thorbjorn Olesen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shubhankar Sharma').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='johnstone').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Peter Uihlein').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='sabrinadriedger').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Day').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ian Poulter').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lee Westwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Danny Lee').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shubhankar Sharma').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Martin Kaymer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='moejones').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='johnwilding').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Day').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thorbjorn Olesen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Palmer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='davepaynter').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Stewart Cink').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Tway').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='kristamitchell').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lucas Glover').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='jordielingel').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lee Westwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Tway').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shubhankar Sharma').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lucas Glover').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='ronrekunyk').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Martin Kaymer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='jamiestewart').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='lindajones').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Tway').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='dennisthomas').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shane Lowry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Dylan Frittelli').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='jopeter').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Eddie Pepperell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Palmer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lucas Glover').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='gregmoody').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='mikegoodrich').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='jenstewart').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Billy Horschel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Henley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Danny Lee').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Martin Laird').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='ronstewart').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Na').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='tonyshea').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Eddie Pepperell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lee Westwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shubhankar Sharma').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='amerkhakawany').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='kylemoody').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Steele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='randybutson').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='leiffossum').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Na').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Tway').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='rebeccastewart').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tyrell Hatton').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='tomrak').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='toddkergan').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thorbjorn Olesen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Peter Uihlein').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='shirleyanneegan').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lucas Glover').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='dellachartrand').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tyrell Hatton').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='benblack').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jimmy Walker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lucas Glover').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='bradtaylor').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='waltermoerno').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Day').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thorbjorn Olesen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Stewart Cink').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='briankain').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Na').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shane Lowry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jamie Lovemark').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='rodmcleod').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Emilano Grillo').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chez Reavie').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='billlane').one()
# golfer = golfers.filter_by(name='Brooks Koepka').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Tway').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='kevinhannam').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='mikebrassington').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Day').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Keegan Bradley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Smith').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charlie Hoffman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Anirban Lahiri').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='stuillot').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chesson Hadley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Lee Westwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='J.B. Holmes').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Shubhankar Sharma').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Martin Kaymer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='paulmichaud').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Webb Simpson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kyle Stanley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Stewart Cink').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Abraham Ancer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='jordanroberge').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='spencerholt').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Henrik Stenson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tyrell Hatton').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Scott').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matthew Fitzpatrick').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Thomas Pieters').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Julian Suri').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='martypeters').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jon Rahm').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ian Poulter').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Cameron Champ').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Chappell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Dylan Frittelli').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charl Schwartzel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Chris Kirk').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='joshbriand').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jordan Spieth').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Reed').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Phil Mickelson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Sergio Garcia').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Billy Horschel').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tyrell Hatton').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Charles Howell III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Eddie Pepperell').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Henley').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Palmer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ross Fisher').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Peter Uihlein').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Danny Lee').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Anirban Lahiri').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Martin Laird').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='susanmcelvery').one()
# golfer = golfers.filter_by(name='Justin Rose').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Francesco Molinari').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ian Poulter').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Na').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Palmer').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Byeong Hun An').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Landry').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='mikemacdonald').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rory McIlroy').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rickie Fowler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Xander Schauffele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Paul Casey').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Gary Woodland').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patrick Cantlay').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Louis Oosthuizen').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brandt Snedeker').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Daniel Berger').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ryan Moore').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Russell Knox').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Andrew Putnam').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Kokrak').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jhonattan Vegas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='kerryroberge').one()
# golfer = golfers.filter_by(name='Dustin Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tony Finau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Marc Leishman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Matt Kuchar').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tyrell Hatton').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Rafa Cabrera Bello').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Adam Hadwin').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Grace').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Beau Hossler').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Aaron Wise').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brendan Steele').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Harold Varner III').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bill Haas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# user = users.filter_by(username='zekehume').one()
# golfer = golfers.filter_by(name='Justin Thomas').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bryson DeChambeau').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tiger Woods').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Tommy Fleetwood').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Bubba Watson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Alexander Noren').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Kisner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Hideki Matsuyama').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kevin Na').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Brian Harman').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Kiradech Aphibarnrat').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Pat Perez').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Zach Johnson').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Siwoo Kim').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Luke List').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Patton Kizzire').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Ollie Schniederjans').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()
# golfer = golfers.filter_by(name='Jason Dufner').one()
# choice = PoolChoices(user=user, golfer=golfer, group=golfer.group)
# session.add(choice)
# session.commit()

# tournaments = session.query(PoolTournaments)
# for tournament in tournaments:
#     if tournament.id > 20:
#         session.delete(tournament)
#         session.commit()

# newUser=PoolUsers(username='ryanarnold', password='ryanarnold', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='edarnold', password='edarnold', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='teresabrassington', password='teresabrassington', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='garybalaski', password='garybalaski', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='davejones', password='davejones', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='tylerroberge', password='tylerroberge', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='johnstone', password='johnstone', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='sabrinadriedger', password='sabrinadriedger', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='moejones', password='moejones', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='johnwilding', password='johnwilding', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='davepaynter', password='davepaynter', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='kristamitchell', password='kristamitchell', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='jordielingel', password='jordielingel', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='ronrekunyk', password='ronrekunyk', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='jamiestewart', password='jamiestewart', email='')
# session.add(newUser)
# session.commit()
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='lindajones', password='lindajones', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='dennisthomas', password='dennisthomas', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='jopeter', password='jopeter', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='gregmoody', password='gregmoody', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='mikegoodrich', password='mikegoodrich', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='jenstewart', password='jenstewart', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='ronstewart', password='ronstewart', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='tonyshea', password='tonyshea', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='amerkhakawany', password='amerkhakawany', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='kylemoody', password='kylemoody', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='randybutson', password='randybutson', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='leiffossum', password='leiffossum', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='rebeccastewart', password='rebeccastewart', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='tomrak', password='tomrak', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='toddkergan', password='toddkergan', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='shirleyanneegan', password='shirleyanneegan', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='dellachartrand', password='dellachartrand', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='benblack', password='benblack', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='bradtaylor', password='bradtaylor', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='waltermoerno', password='waltermoerno', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='briankain', password='briankain', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='rodmcleod', password='rodmcleod', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='billlane', password='billlane', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='martypeters', password='martypeters', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='joshbriand', password='joshbriand', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='susanmcelvery', password='susanmcelvery', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='mikemacdonald', password='mikemacdonald', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='kerryroberge', password='kerryroberge', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='zekehume', password='zekehume', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='kevinhannam', password='kevinhannam', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='mikebrassington', password='mikebrassington', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='stuillot', password='stuillot', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='paulmichaud', password='paulmichaud', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='jordanroberge', password='jordanroberge', email='')
# session.add(newUser)
# session.commit()
# newUser=PoolUsers(username='spencerholt', password='spencerholt', email='')
# session.add(newUser)
# session.commit()

# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=13).one()
# newGolfer=PoolGolfers(name='Lee Westwood', country='ENG', startingRank=64, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Zach Johnson', country='USA', startingRank=66, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Ryan Moore', country='USA', startingRank=77, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Ryan Palmer', country='USA', startingRank=79, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Stewart Cink', country='USA', startingRank=84, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Jimmy Walker', country='USA', startingRank=88, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=17).one()
# newGolfer=PoolGolfers(name='Andrew Landry', country='USA', startingRank=104, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Shubhankar Sharma', country='IND', startingRank=116, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Jason Kokrak', country='USA', startingRank=126, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Anirban Lahiri', country='IND', startingRank=143, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Jamie Lovemark', country='USA', startingRank=150, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Harold Varner III', country='USA', startingRank=158, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Ollie Schniederjans', country='USA', startingRank=168, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=10).one()
# newGolfer=PoolGolfers(name='Brandt Snedeker', country='USA', startingRank=49, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Brian Harman', country='USA', startingRank=51, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Charlie Hoffman', country='USA', startingRank=53, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Charles Howell III', country='USA', startingRank=58, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Adam Hadwin', country='CAN', startingRank=67, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=14).one()
# newGolfer=PoolGolfers(name='Byeong Hun An', country='KOR', startingRank=52, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Siwoo Kim', country='KOR', startingRank=59, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Russell Knox', country='SCO', startingRank=68, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Thomas Pieters', country='BEL', startingRank=70, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Ross Fisher', country='ENG', startingRank=72, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Shane Lowry', country='IRL', startingRank=74, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=18).one()
# newGolfer=PoolGolfers(name='Jason Dufner', country='USA', startingRank=105, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Jhonattan Vegas', country='VEN', startingRank=113, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Lucas Glover', country='USA', startingRank=130, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Chris Kirk', country='USA', startingRank=159, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Martin Kaymer', country='GER', startingRank=163, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Bill Haas', country='USA', startingRank=182, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Martin Laird', country='SCO', startingRank=194, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=11).one()
# newGolfer=PoolGolfers(name='Kiradech Aphibarnrat', country='THA', startingRank=37, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Eddie Pepperell', country='ENG', startingRank=38, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Matthew Fitzpatrick', country='ENG', startingRank=40, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Thorbjorn Olesen', country='DEN', startingRank=43, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Emilano Grillo', country='ARG', startingRank=46, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Brendan Grace', country='RSA', startingRank=48, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Aaron Wise', country='USA', startingRank=50, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=15).one()
# newGolfer=PoolGolfers(name='Aaron Wise', country='USA', startingRank=50, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Luke List', country='USA', startingRank=56, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Abraham Ancer', country='MEX', startingRank=60, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Chez Reavie', country='USA', startingRank=62, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Dylan Frittelli', country='RSA', startingRank=76, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Peter Uihlein', country='USA', startingRank=78, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Julian Suri', country='USA', startingRank=81, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=8).one()
# newGolfer=PoolGolfers(name='Patrick Cantlay', country='USA', startingRank=20, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Tyrell Hatton', country='ENG', startingRank=24, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Hideki Matsuyama', country='JPN', startingRank=25, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Cameron Smith', country='AUS', startingRank=33, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Cameron Champ', country='USA', startingRank=97, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=12).one()
# newGolfer=PoolGolfers(name='Daniel Berger', country='USA', startingRank=55, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Pat Perez', country='USA', startingRank=61, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Chesson Hadley', country='USA', startingRank=65, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Kevin Chappell', country='USA', startingRank=71, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Russell Henley', country='USA', startingRank=85, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Beau Hossler', country='USA', startingRank=87, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# groups = session.query(PoolGroups)
# newGolferGroup = groups.filter_by(id=16).one()
# newGolfer=PoolGolfers(name='Andrew Putnam', country='USA', startingRank=73, group=newGolferGroup)
# newGolfer=PoolGolfers(name='Charl Schwartzel', country='RSA', startingRank=81, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Kevin Tway', country='USA', startingRank=91, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Danny Lee', country='NZL', startingRank=95, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='J.B. Holmes', country='USA', startingRank=96, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Patton Kizzire', country='USA', startingRank=98, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()
# newGolfer=PoolGolfers(name='Brendan Steele', country='USA', startingRank=103, group=newGolferGroup)
# session.add(newGolfer)
# session.commit()

# newGroup = PoolGroups(groupname="Group 1")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 2")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 3")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 4")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 5")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 6")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 7")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 8")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 9")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 10")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 11")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 12")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 13")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 14")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 15")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 16")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 17")
# session.add(newGroup)
# session.commit()
# newGroup = PoolGroups(groupname="Group 18")
# session.add(newGroup)
# session.commit()

# newTournament = PoolTournaments(year=2019, name="Sentry Tournament of Champions", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Farmers Insurance Open", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Waste Management Phoenix Open", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="AT&T Pebble Beach National", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Genesis Open", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="WGC Mexico Championship", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="The Honda Championship", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="The Players Championship", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="WGC Match Play Championship", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Masters Tournament", tier=1)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Wells Fargo Championship", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="PGA Championship", tier=1)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="The Memorial Tournament", tier=3)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="US Open", tier=1)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="British Open", tier=1)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="WGC Fed-Ex St Jude Invitational", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Wyndam Championship", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="The Northern Trust", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="BMW Championship", tier=2)
# session.add(newTournament)
# session.commit()
# newTournament = PoolTournaments(year=2019, name="Tour Championship", tier=2)
# session.add(newTournament)
# session.commit()
#
# newUser = PoolUsers(username="admin", password="59543", email="joshbriand@gmail.com")
# session.add(newUser)
# session.commit()

# newUser = PoolUsers(username="admin", password="triple20", email="joshbriand@gmail.com")
# session.add(newUser)
# session.commit()

# newUser = RecipeUsers(name="joshbriand", email="joshbriand@gmail.com", password="joshbriand")
# session.add(newUser)
# session.commit()
# newUser = RecipeUsers(name="seancasey", email="seancasey@gmail.com", password="seancasey")
# session.add(newUser)
# session.commit()
# print "Added users"
#
# newRecipe = Recipes(
#     name="Panko Fish",
#     cuisine="Japanese",
#     meal="Dinner",
#     date=datetime.now(),
#     picture="https://www.takemefishing.org/tmf/assets/images/fish/albacore-464x170.png",
#     user_id=2)
# session.add(newRecipe)
# session.commit()
# recipe_id = session.query(Recipes).filter_by(user_id=2).first().id
# newIngredient = RecipeIngredients(
#     ingredient="3/4 cup Japanese panko breadcrumbs",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="3/4 cup Parmesan cheese finely grated",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="3 tablespoons unsalted butter room temperature",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="3 tablespoons mayonnaise",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="3 green onions, green tops only thinly sliced",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="1 teaspoon Worchestershire sauce",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="1/2 teaspoon Tabasco or other hot pepper sauce",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="1 1/2 tablespoons lemon juice freshly squeezed (approx. 1/2 lemon)",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="salt and pepper to taste",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="4 white fish fillets approx. 6 oz; 1/2 to 3/4 inch thick",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="2 tablespoons fresh flat-leaf parsely finely chopped",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newProcess = RecipeProcess(
#     process="Preheat oven to 400f. Lightly butter a baking dish or individual grain dishes for the fillets.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="n medium bowl, mix together the cheese, breadcrumbs, butter, mayonnaise, green onions, Worcestershire sauce, Tabasco and lemon juice; season to taste with salt and pepper. Set aside until needed.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Pat the fish fillets completely dry with paper towels (removing the moisture ensures they won't get mushy while baking); season generously with salt and pepper. Arrange the fish in a lightly buttered baking dish or individual gratin dishes.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Spread about 3 tablespoons of the cheese mixture over each fillet.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Place in preheated oven and bake until bubbly and almost cooked through, about 10 minutes. Temperature should be approximately 125-130f when tested at thickest part of fillet with meat thermometer.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Move fillets to broiler for 2 to 3 minutes to brown and crisp the tops. When done, the fish should flake easily with a fork.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Remove from oven, garnish with fresh parsley and serve immediately.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newRecipe = Recipes(
#     name="Roast Beetroot and Sweet Potato Buddha Bowl with Spicy Tahini Honey Dressing",
#     cuisine="Vegan",
#     meal="Dinner",
#     date=datetime.now(),
#     picture="http://www.thefoodiecorner.gr/wp-content/uploads/2017/03/Roast-Beetroot-and-Sweet-Potato-Buddha-Bowl-with-Spicy-Tahini-Honey-Dressing-www.thefoodiecorner.gr-8-1.jpg",
#     user_id=1)
# session.add(newRecipe)
# session.commit()
# recipe_id = session.query(Recipes).filter_by(user_id=1).first().id
# newIngredient = RecipeIngredients(
#     ingredient="500g sweet potato cubed",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="400g beetroot, cubed",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="4 tbs olive oil", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="1 tsp salt", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="1 cup brown rice", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="6-8 handfuls greens",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="3-4 tbs dried cranberries",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="2-3 tbs sunflower seeds",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="For the dressing:", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="4 tbs tahini", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="2 tbs honey", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="2 tbs olive oil", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="2 tbs water", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="1 tbs orange juice",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="1/4 tsp cinnamon", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="1/4 tsp salt", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(
#     ingredient="1/8 tsp chilli powder",
#     recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newIngredient = RecipeIngredients(ingredient="1/8 tsp cumin", recipe_id=recipe_id)
# session.add(newIngredient)
# session.commit()
# newProcess = RecipeProcess(process="""Preheat oven to 180C fan assisted (200C
# conventional). Line two baking sheets with grease proof paper. Put the sweet
# potato, 2 tablespoons of oil and half a teaspoon of salt in a bowl and mix with
# your hands to coat. Spread it out on a baking sheet (the pieces need to have
# room, no crowding!). Do the same with the beetroot, the other 2 tbs oil and half
#  teaspoon salt. Put both sheets in the oven to roast the veggies. The beetroot
#  should need about 25 minutes till softened and the sweet potato about 30 till
#  softened and starting to brown.""", recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="Boil the rice according to instructions.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(
#     process="To make the dressing whisk all the ingredients in a bowl. If needed warm it up a bit in the microwave to make it runnier.",
#     recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# newProcess = RecipeProcess(process="""Assemble the bowls with a little of each
# vegetable, some rice, a small handful of spinach and rocket, a sprinkling of
# cranberries and sunflower seeds, and a drizzle of dressing. Start modestly with
# the dressing as it's strong tasting, and add more if desired. Serve warm or at
# room temperature.""", recipe_id=recipe_id)
# session.add(newProcess)
# session.commit()
# print "recipes added"


# names=['admin', 'josh', 'adam', 'paul', 'stephen', 'james', 'jonathan']
# passwords=['admin', 'josh', 'adam', 'paul', 'stephen', 'james', 'jonathan']
#
# for x in range(0,len(names)):
#     if names[x] in usernames:
#         print names[x] + " exists already"
#     else:
#         newUser = ghostUser(name=names[x], password=passwords[x], email="joshbriand@gmail.com", notifications="no")
#         session.add(newUser)
#         session.commit()
#         print names[x] + " added"
#
# newUser = SurveyUsers(username="admin", password="59545")
# session.add(newUser)
# session.commit()
# print "Added admin user"
