ezcontainer_example/lib/ezcontainer_railway/projects.ex

defmodule EzcontainerRailway.Projects do
  import Ecto.Query

  alias EzcontainerRailway.Repo
  alias EzcontainerRailway.Project
  alias EzcontainerRailway.Railway

  def get_project_by_token(token) do
    {:ok, user_id} = Railway.get_user_id(token)

    get_project_by_user_id(user_id)

    Repo.one(
      from p in Project,
      where: p.user_id == ^user_id,
      limit: 1
    )
  end

  def get_project_by_user_id(user_id) do
    Repo.one(
      from p in Project,
      where: p.user_id == ^user_id,
      limit: 1
    )
  end

  def create_project(token) do
    {:ok, project_id} = Railway.create_project(token)
    {:ok, user_id} = Railway.get_user_id(token)

    %Project{}
    |> Project.changeset(%{user_id: user_id, project_id: project_id})
    |> Repo.insert!
  end
end