WammKD

WammKD

Put_assoc Cannot Perform Update to Many-to-Many

So I have a table of ItemA which has a many-to-many mapping to ItemB.

In the changeset of ItemA, the ItemB association gets preloaded and, then, the relevant ItemBs from the database are added via put_assoc().

When handling a list of ItemB that’s already associated with ItemA, the rows linking them are DELETEd from the mapping table (this makes sense as on_replace: is set to :delete).

However, they are, then, never INSERTed again, leaving my put_assoc() to not associate the struct.s I’ve provided with ItemA but to actively destroy the mappings.

Given that the association has no changes, I would expect (as the documentation says) for this to be skipped.

First Post!

WammKD

WammKD

I didn’t think I was doing anything particularly complicated; the ItemA schema looks like

defmodule ItemA do
  use    Ecto.Schema;
  import Ecto.Changeset;

  schema "item_a" do
    …

    many_to_many(:item_bs,                         ItemB,
                 join_through: "item_a_to_item_b", on_replace: :delete);

    timestamps();
  end

  def changeset(%ItemA{} = a, attrs) do
    a |> cast(attrs, […])    # these are actual struct.s from the database, in the code
      |> put_assoc(:item_bs, [%ItemB{}, %ItemB{}, %ItemB{}, %ItemB{}])
  end
end

Yet, after a successful first INSERT, any subsequent UPDATEs DELETEs all entries from the mapping table while the next UPDATE INSERTs them into the mapping table while the next UPDATE DELETEs them while the next UPDATE

I just want it to get the database to match the modules/structs I give it, not do the literal opposite.

Where Next?

Popular in Questions Top

senggen
Erlang/OTP 25 [erts-13.2.2] [source] [64-bit] [smp:8:8] [ds:8:8:10] [async-threads:1] 15:22:35.803 [error] gen_event {lager_file_backend...
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
Emily
I have VueJS GUIs with the project generated using Webpack. I have Elixir modules that will need to be used by the VueJS GUIs. I forese...
New
lucidguppy
I have a super simple question about elixir - how would I take a file like this foo bar baz and output a new file that enumerates th...
New
srinivasu
How to handle excepions in elixir? Suppose i have A, B, C ,D, E modules. and each module has get() function. A.get() method will call t...
New
rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list. ...
New
komlanvi
Hi everyone, I was playing with phoenix liveView but I run into an issue. I have a form and want to validate each input text when the te...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New

Other popular topics Top

aadeshere1
I have a another noob question about loop. Since elixir is immutable, while loop is not directly possible. total = 10 while total != 0 ...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
TunkShif
This post is an instruction guide to help you setup your Neovim for Elixir development from scratch. It includes general information on h...
274 41989 114
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
grych
Hi folks, Few months ago I have announced the proof-of-concept of the library to manipulate the browsers DOM objects directly from Elixi...
639 52673 488
New
dblack
I’ve got an issue with an app and I’ve no idea of how to troubleshoot it. I’m hoping someone here might have seen something similar. I p...
New
AstonJ
We’ve put together this wiki for Phoenix LiveView - please feel free to add any info you feel is worth including. What is Phoenix LiveV...
New
vegabook
I’m brand new to Phoenix and I have stripped one of the demo applications to the bone. I just want to get an svg up on the screen. Here i...
New

Latest on Elixir Forum

Elixir Forum

We're in Beta

About us Mission Statement