Exemplo n.º 1
0
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(","))
Exemplo n.º 2
0
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))
Exemplo n.º 3
0
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()