philomena/lib/philomena_web/plugs/channel_plug.ex

defmodule PhilomenaWeb.ChannelPlug do
  alias Plug.Conn
  alias Philomena.Channels.Channel
  alias Philomena.Repo
  import Ecto.Query

  def init([]), do: []

  def call(conn, _opts) do
    live_channels =
      Channel
      |> where(is_live: true)
      |> Repo.aggregate(:count, :id)

    conn
    |> Conn.assign(:live_channels, live_channels)
  end
end