from services import Model import sys if len(sys.argv) == 1: raise Exception("You need to pass in at least one lineup") print sys.argv lineups = sys.argv[1:-1] if len(sys.argv) == 2: lineups = [sys.argv[1]] model = Model() for lineup in lineups: print lineup model.testTeam(lineup.split(","))
model = Model() if session.query(Player).count() == 0: model.fetchPlayers() for player in session.query(Player).yield_per(100): print "Fetching logs for %s..." % player.name model.fetchGamelogs(player) steph = session.query(Player).filter(Player.name == 'Stephen Curry')[0] model.fetchGamelogs(steph) for log in steph.gamelogs: print log.DK ''' model = Model() print "Fetching game logs..." #model.fetchPickablePlayers() fpg = ["D'Angelo Russell", "Lou Williams"] fsg = ["Kobe Bryant"] fc = ["Roy Hibbert"] fsf = ["Anthony Brown"] fpf = ["Julius Randle"] pgs = session.query(Player).filter(Player.pickable==True,Player.pos=='PG',Player.name.in_(fpg)) sgs = session.query(Player).filter(Player.pickable==True,Player.pos=='SG',Player.name.in_(fsg)) cs = session.query(Player).filter(Player.pickable==True,Player.pos=='C', Player.name.in_(fc)) sfs = session.query(Player).filter(Player.pickable==True,Player.pos=='SF',Player.name.in_(fsf))
from models import engine from models import Base from services import Model import sqlalchemy for tbl in reversed(Base.metadata.sorted_tables): try: tbl.drop(engine) except sqlalchemy.exc.ProgrammingError: print "Couldn't drop table %s" % tbl Base.metadata.create_all(engine) model = Model() model.fetchPlayers()