helicon

helicon

Update nested struct with Ecto

Hello!
I have 2 schemas: Asset and File.

# asset schema
has_many :files, File
# file schema
belongs_to :asset, Asset

So it looks like:

%Asset{
   __meta__: #Ecto.Schema.Metadata<:loaded, "assets">,
   id: 1,
   name: "name",
   files: []
 }

Each time i need to update my asset.files (for example: add one file, then add yet 3 files in 10 minutes).
Actually I do not really understand how works put_assoc function, but it not saves old data, it removes data and set new data. Or maybe build_assoc is the only way to handle that?!
Maybe i’m explaining too bad, but it must work like in Rails that command asset.files << new_file

Most Liked

jeremyjh

jeremyjh

Two options. Either just do inserts directly to Files that include asset_id, or if you will always have the entire collection of files loaded, you can use nested changesets. So in your Asset changeset, you will have a function: cast_assoc(:files, required: false, with: &File.changeset/2)

When you update Asset though, you need to include at least the id for all existing files, as well as the fields you want to set for any new files. The former option is the only safe one if concurrent updates are possible; by default you will get an exception if you leave an ID out of your new payload.

jeremyjh

jeremyjh

Yes this was what I was referring to. That means there are existing associations you have not included in your payload. After the first execution there are two files that were assigned IDs. You need to include those in your next params:

params = %{
  files: [
    %{id: file1.id},
    %{id: file2.id},
    %{filename: "name3"},
    %{filename: "name4"} 
  ]
}

Where Next?

Popular in Questions Top

lessless
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
New
jaysoifer
Is there a way to rollback a specific migration and only that one ("skipping" all the other ones)? Would mix ecto.rollback -v 2008090...
New
pmjoe
I have a relationship of love and hate with Elixir. Lots of things are just absolutely right, but there are some things that are kind of ...
New
johnnyicon
Hi all, I've just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I'm trying to use Postg...
New
itssasanka
Hi all, Trying to get some more clarity over utc_datetime and naive_datetime for Ecto: https://hexdocs.pm/ecto/Ecto.Schema.html#module-...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
ycv005
I have followed this StackOverflow post to install the specific version of Erlang. And When I am running mix ecto.setup then getting fol...
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
JDanielMartinez
Hi! May someone helps me, please! I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
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

Other popular topics Top

sen
Hi All, I set a environment variables in dev.exs , like below code. when i start server, how can i set the ${enable} value? thanks. d...
New
AstonJ
Posting this to see if we can make things easier for people to get into Neovim. If you use Neovim and have a favourite distro please let ...
New
JorisKok
I have a server on AWS, and was running a load test using artillery. When looking at the Phoenix dashboard I see the Ports going to 100% ...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
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
Please see the new poll here: Which code editor or IDE do you use? (Poll) (2022 Edition) It’s been a while since we first asked this, I...
208 31107 143
New
Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
dogweather
I wrote this comment on r/haskell, and it’s not popular there. :wink: But I think I’m on to something… Haskell reminds me of Java, and e...
New
svb
Hi! Currently I want to submit a form by pressing the Enter key. However, since my input field is of type “textarea” this is just adds a...
New

We're in Beta

About us Mission Statement