Hi all I have following schemas schema "languages_code" do field :code, :string field :text, :string timestamps end and another schema that will be associated with languages_code schema: schema "countries" do belongs_to :code, CountryCode, references: :alpha2 belongs_to :lang…

[image] kostonstyle: So, when I what to pass the :name option, how do I have to write? If you are using the defaults, the Ecto will figure it out for you. If you want to be double sure, you can inspect your foreign key names in the database using any database inspector or you can give a fake …

[image] kostonstyle: |> cast_assoc(:code) |> cast_assoc(:language) Sorry, you are right. You don’t need cast_assoc but make sure you pass both :code and :language to cast. I will edit my previous answer for clarify.

Sorry. I changed my schema to: schema "countries" do field :code, :string field :language, :string field :text, :string timestamps end def changeset(model, params \\ %{}) do model |> cast(params, [:code, :language, :text]) |> validate_required([:code, :language, :…

@josevalim I found the error, it is on migration file, since I rename the column: create table(:countries) do add :coun, references(:countries_code, column: :alpha2, type: :string) add :lang, references(:languages_code, column: :code, type: :string) add :text, :string timestamps end cre…

Delete and create the countries database with: def change do drop table(:countries) create table(:countries) do add :code, references(:countries_code, column: :alpha2, type: :string) add :language, references(:languages_code, column: :code, type: :string) add :text, :s…

If you are using “references”, one is automatically added for you. Please check the answer in my first post, I think you did not add the new fields to the “cast” call in your changeset function (because I forgot to do so as well in my original reply).

Hi jose I tried again as you metioned and it does not work. The schema and changeset function: schema "countries" do field :iso_country, :string field :iso_language, :string field :name, :string timestamps end def changeset(struct, params \\ %{}) do struct |> ca…

Constraints are only tested after you do a repository operation, such as Repo.insert, since it is the database reporting what is wrong (rather than we testing it).

So, I have to do Repo.insert to get to know if there is a constraint error or not?

Elixir Programming Language Forum

Cast_assoc invalid

Questions & Help Questions

kostonstyle November 24, 2016, 2:53pm 18

with the name option, I’ve got error as I mentioned above.