hudsonbay

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 :frowning:

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 :frowning:

Does someone have done this yet in the past and could show me a correct example?

Thanks in advance

Showing Posts 1 to 2

jhefreyzz

jhefreyzz

Does Entries have relationship with User model? If so, you can pass cast_assoc to 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.json it generates similar to this:

  def render("index.json", %{contacts: contacts}) do
    %{data: render_many(contacts, ContactView, "contact.json")}
  end

  def render("show.json", %{contact: contact}) do
    %{data: render_one(contact, ContactView, "contact.json")}
  end

 def render("phone_number.json", %{number: number}) do
    %{id:  number.id, phone_number: number.phone_number}
 end

 def render("contact.json", %{contact: contact}) do
    %{id: contact.id,
       name: contact.name,
       phone_numbers: render_many(contact.numbers, ContactView, "phone_number.json")
    }
end

Make sure you know the shape of the returned data so you can structure the views.

Given the results:

[
 %Contact{
   id: 'something',
   name: 'some name',
   numbers: [
      %Number{id: 'some id', phone_number: 'some phone number'},
      %Number{id: 'some id', phone_number: 'some phone number'}
   ]
 },
%Contact{
   id: 'something',
   name: 'some name',
   numbers: [
      %Number{id: 'some id', phone_number: 'some phone number'},
      %Number{id: 'some id', phone_number: 'some phone number'}
   ]
 }
]

We can return its json format response like this:

with {:ok, entries} = Users.create_users(users_params) do
        conn
        |> render("contact.json", contact: entries)
end

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

hudsonbay OP

Thanks

— All posts loaded —

Where Next? Top

Trending in Questions Top

Blokh
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
kszambelanczyk
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
Onor.io
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
Trolleger
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
matt-savvy
Anyone here using Honeybadger? My Honeybadger account is being overwhelmed with noise from some bots. Seeing a lot of Bandit.HTTPError...
New
RemyXRenard
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
samoloth
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 Top

garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
Damirados
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
netoum
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
wintermeyer
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
webofbits
Aludel - LLM Evaluation Workbench Aludel is an embeddable Phoenix LiveView dashboard for evaluating and comparing LLM prompts across mult...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews