freewebwithme

Creating a User with Profile schema?

Hi!
I want to create a user and also profile schema at the same time.

For example

defmodule MyApp.Accounts.User do
  use Ecto.Schema
  import Ecto.Changeset

  schema "users" do
    field :username, :string
    field :password, Comeonin.Ecto.Password
    field :email, :string

    has_one :profile, MyApp.Accounts.Profile
    timestamps()
  end
end

defmodule MyApp.Accounts.Profile do
  use Ecto.Schema
  import Ecto.Changeset

  schema "profiles" do
    field :phone_number, :string
    field :address, :string
    field :intro, :string

    belongs_to :user, MyApp.Accounts.User
    timestamps()
  end
end

then I got an input from user like this

attrs = %{username: "username",
          password: "secret", 
          email: "email@example.com", 
          phone_number: "2223334444", 
          address: "some address", 
          intro: "Hello world!"}

then in my accounts.ex file

def create_user(attrs) do                                                                                                                                     
     user_changeset = User.changeset(%User{}, attrs)                                                                                                                   
     profile_changeset = Profile.changeset(%Profile{}, attrs)
                                                                  
     user_changeset                                                                                                                                                    
     |> Ecto.Changeset.put_assoc(:profile, profile_changeset)                                                                                               
     |> Repo.insert()                                                                                                                                                   
end

I think it works..
But is there any better (elixir) way?

8 comments

#ecto #schema

0 2206 8

2019-11-27 09:43:31 UTC

First 8 of 8 Posts

OvermindDL1

No that’s pretty much it, although I’d probably use a transaction because I like the reliability of the transaction, but it doesn’t look like it actually matters in this case.

Post #1

r8code

What do you mean by “use a transaction” , is it by using Ecto.multi ? ,
do you mind to share how to “use a transaction” ?
Thank you

Post #3

wolfiton

This should offer you an example from the docs Ecto.Repo — Ecto v3.14.0

Post #4

wolfiton

Does someone still need an example of Multi new and run for this?

If you do reply to this message and mention my user like this @wolfiton

Post #5

OvermindDL1

I most often use Ecto.Multi’s yes, but then I frequently don’t use associations due to significant limitations of them anyway.

Nah, you can just run it in a transaction function all that you need to do anyway. ^.^

Post #6

freewebwithme

Can you explain more about this? Do you mean you don’t frequently use associations(like has_one, has_many, belongs_to etc.) in you database design?

Post #7

OvermindDL1

Ecto’s associations assume there is only one join column, but because of legacy reasons I have at minimum 2 join columns and sometimes more, thus making the Ecto associations absolutely useless for me as it assumes a design that cannot exist here. ^.^;

Post #8