<turbo-stream action="append" target="posts_list"><template>    <div class="postbit" id="97374" data-post-id="97374">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="mikemccall" src="/assets/icons/user-9f439610.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  mikemccall
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<aside class="quote no-group" data-username="BenFenner" data-post="11" data-topic="16664">
<div class="title">
<div class="quote-controls"></div>
<img alt="" width="24" height="24" src="https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/b/278dde/48.png" class="avatar"> BenFenner:</div>
<blockquote>
<p>I believe URL manipulation could allow a user to send IDs through that don’t get verified as existing, and we could end up with relationships for Users and/or Resources that don’t exist.</p>
</blockquote>
</aside>
<p>Not if you set up your foreign key constraints and it looks like you have. You can use <a href="https://hexdocs.pm/ecto/Ecto.Schema.html#belongs_to/3" rel="noopener nofollow ugc">belongs_to</a> in your schema (Not required but it’s explicit <img src="https://forum.elixirforum.com/images/emoji/apple/+1.png?v=15" title=":+1:" class="emoji" alt=":+1:" loading="lazy" width="20" height="20"> ) and in your changeset you can use <a href="https://hexdocs.pm/ecto/Ecto.Changeset.html#foreign_key_constraint/3" rel="noopener nofollow ugc">foreign_key_constraint</a></p>
<pre><code>schema "user_resources" do
   belongs_to :resource, Resource
   belongs_to :user,  User
   field :inserted_by, :integer
   field :updated_by, :integer

   timestamps()
end

def changeset(user_resource, attrs) do
    user_resource
    |&gt; cast(attrs, [:user_id, :resource_id, :inserted_by, :updated_by])
    |&gt; validate_required([:user_id, :resource_id, :inserted_by, :updated_by])
    |&gt; foreign_key_constraint(:user_id)
    |&gt; foreign_key_constraint(:resource_id)
end
</code></pre>
<p>If the resource or user do not exist this will give you an error changeset.</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="97374" data-batch-url="/posts/batch_likers">
                        1
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/12">Post #11</a>
	                </div>
	            </div>
              <div id="likers-container-97374" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="97374"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #11"></div>
  </section>
</div>
    <div class="postbit" id="97377" data-post-id="97377">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="BenFenner" src="/assets/icons/user-9f439610.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  BenFenner
                    <span class="op-star" title="Thread Starter">
                      <img alt="OP" class="op-star-icon" src="/assets/thread-icons/thread-icon-thread-starter-df91e872.png" />
                    </span>
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>You’re right, I tried the URL manipulation and a constraint error of some type was thrown. I then applied your two suggestions, and a more informative changeset error was thrown. Cool times. <img src="https://forum.elixirforum.com/images/emoji/apple/slight_smile.png?v=15" title=":slight_smile:" class="emoji" alt=":slight_smile:" loading="lazy" width="20" height="20"></p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="97377" data-batch-url="/posts/batch_likers">
                        0
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/13">Post #12</a>
	                </div>
	            </div>
              <div id="likers-container-97377" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="97377"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #12"></div>
  </section>
</div>
    <div class="postbit" id="188889" data-post-id="188889">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="karlosmid" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/karlosmid/120/4307_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  karlosmid
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<aside class="quote no-group" data-username="mikemccall" data-post="2" data-topic="16664" data-full="true">
<div class="title">
<div class="quote-controls"></div>
<img alt="" width="24" height="24" src="https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/m/a587f6/48.png" class="avatar"> mikemccall:</div>
<blockquote>
<p><code>Repo.delete/2</code> expects a <code>changeset_or_struct</code> as the first argument. It looks like you’re piping an <code>#Ecto.Query</code> ( ie. <code>queryable</code> ) into it. I believe <a href="https://hexdocs.pm/ecto/Ecto.Repo.html#c:delete_all/2" rel="noopener nofollow ugc">delete_all/2 </a> is what you’re looking for.</p>
</blockquote>
</aside>
<p>Hi!</p>
<p>Great advice! Here is the query for Repo.delete_all base on this <a href="https://medium.com/coletiv-stories/ecto-elixir-many-to-many-relationships-66403933f8c1" rel="noopener nofollow ugc">example</a> how to do many-to-many relation:</p>
<aside class="onebox githubgist" data-onebox-src="https://gist.github.com/karlosmid/c4b6abb224efa563592d56dc00d5efec">
  <header class="source">

      <a href="https://gist.github.com/karlosmid/c4b6abb224efa563592d56dc00d5efec" target="_blank" rel="noopener nofollow ugc">gist.github.com</a>
  </header>

  <article class="onebox-body">
    <h4><a href="https://gist.github.com/karlosmid/c4b6abb224efa563592d56dc00d5efec" target="_blank" rel="noopener nofollow ugc">https://gist.github.com/karlosmid/c4b6abb224efa563592d56dc00d5efec</a></h4>



  </article>

  <div class="onebox-metadata">
    
    
  </div>

  <div style="clear: both"></div>
</aside>
 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="188889" data-batch-url="/posts/batch_likers">
                        0
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/14">Post #13</a>
	                </div>
	            </div>
              <div id="likers-container-188889" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="188889"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #13"></div>
  </section>
</div>
    <div class="postbit" id="209609" data-post-id="209609">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="hudsonbay" src="/assets/icons/user-9f439610.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  hudsonbay
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>BenFerrer, can I ask you something? I’m new to Elixir/Phoenix and I’m in a similar situation. Can you show me your endopint in the router? Because I don’t know how to pass two arguments to the controller <img src="https://forum.elixirforum.com/images/emoji/apple/frowning.png?v=15" title=":frowning:" class="emoji" alt=":frowning:" loading="lazy" width="20" height="20"></p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="209609" data-batch-url="/posts/batch_likers">
                        0
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/15">Post #14</a>
	                </div>
	            </div>
              <div id="likers-container-209609" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="209609"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #14"></div>
  </section>
</div>
    <div class="postbit" id="209610" data-post-id="209610">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="sanswork" src="https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/sanswork/120/39354_2.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  sanswork
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>You could do it like</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">get "/route/:id/:second_id", RouteController, :index
</code></pre>
<p>def index(conn, %{“id” =&gt; id, “second_id” =&gt; second_id}) do<br>
end</p>
<p>Is that what you’re asking for?</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="209610" data-batch-url="/posts/batch_likers">
                        1
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/16">Post #15</a>
	                </div>
	            </div>
              <div id="likers-container-209610" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="209610"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-standard-post cat-standard-post" title="Post #15"></div>
  </section>
</div>
    <div class="postbit" id="209747" data-post-id="209747">
  <section>
    <div class="post-wrap">


					<div class="post-header">
		        <div class="user-avatar">
		          <img alt="BenFenner" src="/assets/icons/user-9f439610.png" width="120" height="120" />
		        </div>
					
						<div class="user-details">
		          <div class="user-name">
		            <h3>
                  BenFenner
                    <span class="op-star" title="Thread Starter">
                      <img alt="OP" class="op-star-icon" src="/assets/thread-icons/thread-icon-thread-starter-df91e872.png" />
                    </span>
                  </h3>
		          </div>
						
						</div>
					
					</div>

	        <div class="thread-main">
	            <div class="post-body" data-turbo="false">
								<p>Oh boy, it’s been two and a half years since I gave any thought to this.<br>
I’m sorry, but this project has long been abandoned, as has the employment it was attached to.</p>
<p>However, here is the route in question as I believe it was implemented:</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">  scope "/", MyApp do
    resources "/users", UserController do
      get "/remove_resource/:resource_id", UserController, :remove_resource, as: :remove_resource
    end
  end
</code></pre>
<p>I believe the two ID situation is taken care of by having the route “inside” the resource of the other ID you want to deal with.</p>
<p>And here is what I believe the corresponding controller action looked like that the route went to:</p>
<pre data-code-wrap="elixir"><code class="lang-elixir">  def remove_resource(conn, %{"user_id" =&gt; user_id, "resource_id" =&gt; resource_id}) do
    Account.remove_resource(String.to_integer(user_id), String.to_integer(resource_id))

    conn
    |&gt; put_flash(:notice, "Resource removed from user successfully.")
    |&gt; redirect(to: Routes.user_path(conn, :show, user_id))
  end
</code></pre>
<p>I will admit it has been a long time since I’ve dealt with this, and I never really grok’d Elixir like I have other languages. So if I’ve messed something up let me know and maybe I can help a little bit more.</p> 
	            </div>

	            <div class="base-line">
	                <div class="thread-counters">
	                    <span class="thread-count count-likes js-likers-trigger" title="Likes" data-post-id="209747" data-batch-url="/posts/batch_likers">
                        1
                      </span>
                      <!-- <span class="thread-count js-solved-indicator" title="Marked as solution"></span> -->
	                </div>
	                <div class="go-to-post">
	                  <a title="Go to post" alt="Go to post" href="https://forum.elixirforum.com/t/how-to-remove-delete-a-many-to-many-relationhip/16664/17">Post #16</a>
	                </div>
	            </div>
              <div id="likers-container-209747" 
                   class="likers-container"
                   data-first-post="false"
                   data-batch-url="/posts/batch_likers">
                   <div class="likers-placeholder" 
                     data-likers-post-id="209747"
                     data-batch-url="/posts/batch_likers">
                  <div class="post-likers"></div>
                </div>
              </div>
	        </div>
			

    </div>

    <div class="triangle-top-right type-last-post cat-last-post" title="Last post!"></div>
  </section>
</div>
</template></turbo-stream><turbo-stream action="replace" target="load-more-container"><template><div id="load-more-container" class="load-more-container">
    <span class="all-loaded">— All posts loaded —</span>
</div></template></turbo-stream>