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 :profil…

[image] freewebwithme: But is there any better (elixir) way? 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. :slight_smile:

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

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

[image] 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” ? I most often use Ecto.Multi’s yes, but then I frequently don’t use associations due to significant limitations of them anyway. :slight_smile: [image] …

[image] OvermindDL1: but then I frequently don’t use associations due to significant limitations of them anyway 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?

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. ^.^;

Thanks @wolfiton and @OvermindDL1 for the reply

Elixir Programming Language Forum

Creating a User with Profile schema?

Questions & Help Questions

wolfiton November 23, 2019, 2:40pm 5

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