hudsonbay
Hi, I am trying to create a POST endpoint in Phoenix that will receive an array of maps %{} and I need to insert all of that data into a database as a bulk insertion.
It would be receiving something like this:
entries = [
%{name: "Frank", age: 23},
%{name: "John", age: 24}
]
Parameters look like this:
%{"data" => [%{"name" => "Frank", "age" => 23}, %{"name" => "John", "age" => 24}]}
For now I only have created the Repo functions like:
def create_users(attrs) do
User
|> Repo.insert_all(attrs)
end
I’ve searched the entire web and I can’t find any article that explains how the controllers and views should be.
I know this is incorrect because it doesn’t work but it’s more or less what I have right now ![]()
def create_many(conn, %{"data" => users_params}) do
case Users.create_users(users_params) do
{:ok, %{errors: _, rows_affected: _}} ->
conn
|> json(%{result: "ok"})
# render(conn, "bulk_creation_result.json", %{some: result})
# {:error, _, changeset, _} ->
# render(conn, MyApp.ChangesetView, "error.json", changeset: changeset)
end
As far as the views I really have no clue ![]()
Does someone have done this yet in the past and could show me a correct example?
Thanks in advance
Trending in Questions
Hey guys,
I’ve got a huge CSV ( around 10 GB ) that needs to be processed hourly
Do you guys have any suggestions what is the best prac...
New
Hello!
Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app.
I creat...
New
I have what I’ve heard referred to as a “lookup table” in my database. This is a way of assigning codes to common values. One common lo...
New
What approach to take when sending live updates to “random” users Hi! I have a question, I have a little chat app, and when I create a DM...
New
Anyone here using Honeybadger?
My Honeybadger account is being overwhelmed with noise from some bots. Seeing a lot of
Bandit.HTTPError...
New
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
Other Trending Topics
Hobbes is a low-level distributed database for the Elixir programming language.
Hobbes provides a simple, safe, and scalable storage lay...
New
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve.
They are GUI (Emerge) and State management (S...
New
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
There are three potential reasons for members of this forum to have a look at https://vutuv.de
You are tired or annoyed of LinkedIn.
Yo...
New
Aludel - LLM Evaluation Workbench
Aludel is an embeddable Phoenix LiveView dashboard for evaluating and comparing LLM prompts across mult...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixir-ls
- #ai
- #elixirconf-us
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming










Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
jhefreyzz
Does Entries have relationship with User model? If so, you can pass
cast_assocto your changeset pipeline to do bulk insertion.What do you intent to do with views? Do you want to display the returned data?
When generating a json api using
mix phx.gen.jsonit generates similar to this:Make sure you know the shape of the returned data so you can structure the views.
Given the results:
We can return its json format response like this:
Be sure to put an action_fallback to your controller so it can automatically handle changeset errors.
In the example I gave, it uses ContactView, in your case change the view name to your appropriate one.
hudsonbay
Thanks