def get_user_in_team_by_email(cls, email, team_id):
team_user = db.session.query(UsersByTeamsTableEntry).join(
UserTableEntry,
and_(UsersByTeamsTableEntry.team_id == team_id,
UserTableEntry.user_id == UsersByTeamsTableEntry.user_id,
UserTableEntry.email == email)).one_or_none()
return TeamModelMapper.to_user_in_team(team_user)
def update_team(cls, team):
team_entry = db.session.query(TeamTableEntry).filter(
TeamTableEntry.team_id == team.id).one_or_none()
team_entry.team_name = team.name
team_entry.picture = team.picture
team_entry.location = team.location
team_entry.description = team.description
team_entry.welcome_message = team.welcome_message
DatabaseClient.add(team_entry)
return TeamModelMapper.to_team(team_entry)
def get_all_team_channels_by_team_id(cls, team_id):
channels = db.session.query(
ChannelTableEntry.channel_id, ChannelTableEntry.team_id,
ChannelTableEntry.name, UserTableEntry.user_id,
UserTableEntry.username, UserTableEntry.first_name,
UserTableEntry.last_name, ChannelTableEntry.visibility,
ChannelTableEntry.description,
ChannelTableEntry.welcome_message).join(
UserTableEntry,
UserTableEntry.user_id == ChannelTableEntry.creator).filter(
ChannelTableEntry.team_id == team_id).all()
return TeamModelMapper.to_team_channels(channels)
def get_all_team_users_by_team_id(cls, team_id):
users = db.session.query(
UserTableEntry.user_id, UserTableEntry.username,
UserTableEntry.email, UserTableEntry.first_name,
UserTableEntry.last_name, UserTableEntry.profile_pic,
UserTableEntry.online, UserTableEntry.role,
UsersByTeamsTableEntry.team_id,
UsersByTeamsTableEntry.role.label("team_role")).join(
UsersByTeamsTableEntry,
and_(UserTableEntry.user_id == UsersByTeamsTableEntry.user_id,
UsersByTeamsTableEntry.team_id == team_id)).all()
return TeamModelMapper.to_team_members(users)
def get_user_teams_by_user_id(cls, user_id, is_admin=False):
if is_admin:
team_entry = db.session.query(TeamTableEntry.team_id,
TeamTableEntry.team_name,
TeamTableEntry.picture,
TeamTableEntry.location,
TeamTableEntry.description,
TeamTableEntry.welcome_message,
literal(None).label("role")).all()
else:
team_entry = db.session.query(
TeamTableEntry.team_id, TeamTableEntry.team_name,
TeamTableEntry.picture, TeamTableEntry.location,
TeamTableEntry.description, TeamTableEntry.welcome_message,
UsersByTeamsTableEntry.role).join(
UsersByTeamsTableEntry,
and_(
UsersByTeamsTableEntry.user_id == user_id,
UsersByTeamsTableEntry.team_id ==
TeamTableEntry.team_id)).all()
return TeamModelMapper.to_teams(team_entry)
def get_team_by_name(cls, team_name):
team_entry = db.session.query(TeamTableEntry).filter(
func.lower(TeamTableEntry.team_name) ==
team_name.lower()).one_or_none()
return TeamModelMapper.to_team(team_entry)
def get_team_by_id(cls, team_id):
team_entry = db.session.query(TeamTableEntry).filter(
TeamTableEntry.team_id == team_id).one_or_none()
return TeamModelMapper.to_team(team_entry)
def get_forbidden_words_from_team(cls, team_id):
words = db.session.query(ForbiddenWordTableEntry).filter(
ForbiddenWordTableEntry.team_id == team_id).all()
return TeamModelMapper.to_forbidden_words(words)
def get_forbidden_word_by_id(cls, team_id, word_id):
word = db.session.query(ForbiddenWordTableEntry).filter(
ForbiddenWordTableEntry.team_id == team_id,
ForbiddenWordTableEntry.id == word_id).one_or_none()
return TeamModelMapper.to_forbidden_word(word)
def get_team_invite_by_token(cls, token, email):
invite = db.session.query(TeamsInvitesTableEntry).filter(
TeamsInvitesTableEntry.invite_token == token,
TeamsInvitesTableEntry.email == email).one_or_none()
return TeamModelMapper.to_team_invite(invite)
def get_team_invite(cls, team_id, email):
invite = db.session.query(TeamsInvitesTableEntry).filter(
TeamsInvitesTableEntry.team_id == team_id,
TeamsInvitesTableEntry.email == email).one_or_none()
return TeamModelMapper.to_team_invite(invite)
def add_team(cls, team):
team_entry = TeamDatabaseMapper.to_team(team)
DatabaseClient.add(team_entry)
return TeamModelMapper.to_team(team_entry)
def get_user_in_team_by_ids(cls, user_id, team_id):
team_user = db.session.query(UsersByTeamsTableEntry).filter(
UsersByTeamsTableEntry.user_id == user_id,
UsersByTeamsTableEntry.team_id == team_id).one_or_none()
return TeamModelMapper.to_user_in_team(team_user)