customers.ex

# A user can be a part of multiple teams and orgs.  The OrgTeam
# table has user_id, organization_id and team_id

defmodule Conspyre.Customers do 
  import Ecto.Query

  alias Conspyre.Repo
  alias Conspyre.Customers.{Team, OrgTeam}
  alias Conspyre.Users.User

  def teams_for_user(current_user) do 
    team_query = from t in Team, select: %{id: t.id, name: t.name}
    user_query = from u in User, preload: [teams: ^team_query]

    user_info = Repo.one(user_query)
    user_info.teams
  end
end

## OR ##

  def teams_for_user(current_user) do
    team_data =
      Repo.get(User, current_user.id)
      |> Repo.preload(:teams)

    team_data.teams
  end