def get(cls, user_id):
'''
Retrieves a list of teams a given users is a member of.
:param user_id: int
:returns: list of tlog.base.team.Team
'''
with new_session() as session:
query = session.query(
models.User_team,
models.Team,
).filter(
models.User_team.user_id==user_id,
models.Team.id==models.User_team.team_id,
).all()
teams = []
for team in query:
teams.append(Team._format_from_query(team.Team))
return teams
def get_teams_by_filter_id(cls, filter_id):
'''
Retrieves a list of teams from a filter_id.
:param filter_id: int
:returns: list of tlog.base.team.Team
'''
with new_session() as session:
query = session.query(
models.Filter_team,
models.Team,
).filter(
models.Filter_team.filter_id==filter_id,
models.Team.id==models.Filter_team.team_id,
).all()
teams = []
for team in query:
teams.append(Team._format_from_query(team.Team))
return teams
def get_teams_by_filter_id(cls, filter_id):
'''
Retrieves a list of teams from a filter_id.
:param filter_id: int
:returns: list of tlog.base.team.Team
'''
with new_session() as session:
query = session.query(
models.Filter_team,
models.Team,
).filter(
models.Filter_team.filter_id == filter_id,
models.Team.id == models.Filter_team.team_id,
).all()
teams = []
for team in query:
teams.append(Team._format_from_query(team.Team))
return teams
def get(cls, user_id):
'''
Retrieves a list of teams a given users is a member of.
:param user_id: int
:returns: list of tlog.base.team.Team
'''
with new_session() as session:
query = session.query(
models.User_team,
models.Team,
).filter(
models.User_team.user_id == user_id,
models.Team.id == models.User_team.team_id,
).all()
teams = []
for team in query:
teams.append(Team._format_from_query(team.Team))
return teams