def find_organization_invites(organization, user_obj):
""" Finds all organization team invites for the given user under the given organization. """
invite_check = TeamMemberInvite.user == user_obj
if user_obj.verified:
invite_check = invite_check | (TeamMemberInvite.email
== user_obj.email)
query = (TeamMemberInvite.select().join(Team).where(
invite_check, Team.organization == organization))
return query
def lookup_team_invites(user_obj):
return TeamMemberInvite.select().where(TeamMemberInvite.user == user_obj)
def lookup_team_invites_by_email(email):
return TeamMemberInvite.select().where(TeamMemberInvite.email == email)
def get_organization_team_member_invites(teamid):
joined = TeamMemberInvite.select().join(Team).join(User)
query = joined.where(Team.id == teamid)
return query