dbtest.ex

  setup do
    user = User.changeset(%User{}, %{
      email: "foo@bar.com", 
      password: "Foobar12345!"})
    |> Repo.insert!
    role = Role.changeset(%Role{}, %{name: "some_role"})
    |> Repo.insert!
    {:ok, user: user, role: role}
  end

  test "valid user role", context do
    changeset = UserRole.changeset(%UserRole{}, %{
      user_id: context[:user].id,
      role_id: context[:role].id})
    assert {:ok, user_role} = Repo.insert(changeset)
  end

  test "user role has foreign key user_id", context do
    changeset = UserRole.changeset(%UserRole{}, %{
      user_id: context[:user].id + 1,
      role_id: context[:role].id})
    assert {:error, user_role} = Repo.insert(changeset)
    assert user_role.errors == [user_id: "does not exist"]
  end

  test "user role has foreign key role_id", context do
    changeset = UserRole.changeset(%UserRole{}, %{
      user_id: context[:user].id,
      role_id: context[:role].id + 1})
    assert {:error, user_role} = Repo.insert(changeset)
    assert user_role.errors == [role_id: "does not exist"]
  end