In [1]:

    

from sqlalchemy.orm import sessionmaker

import dota.sql.orm as o


    

In [2]:

    

# init stuff

engine = o.create_engine('sqlite:///../data/pro/pro.db')
Session = sessionmaker(engine)
session = Session()


    

In [3]:

    

# A few example queries

g = session.query(o.Game).first()
print("Game - {}".format(g))

p = session.query(o.Player).first()
print("Player - {}".format(g))

t = session.query(o.Team).first()
print("Team - {}".format(g))


    

    




Game - <Game 10963>
Player - <Game 10963>
Team - <Game 10963>

In [4]:

    

player_counts = o.count_by(session, 'player', 'games')
player_counts.head()


    

    
Out[4]:





2    787
1    781
3    339
4    263
5    178
Name: player, dtype: int64

In [8]:

    

o.count_by(session, 'player', 'team')


    

    
Out[8]:





1    3443
Name: player, dtype: int64

In [ ]: