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