carlosarli

carlosarli

Hello everyone,
I have the following models and changesets for users and addresses:
user.ex

schema "users" do
        field :title, :string
        field :f_name, :string
        field :l_name, :string
        field :DOB, :date
        field :email, :string
        field :username, :string
        field :password, :string, virtual: true
        field :password_confirmation, :string, virtual: true
        field :password_hash, :string
        field :image, Assistant.Image.Type

        #associations
        has_one :addresses, Assistant.Web.Address
        has_many :appointment, Assistant.Web.Appointment
        belongs_to :role, Assistant.Web.Role

        timestamps()
    end

    #checks the changeset of the controller to see whether the input matches the rules I set here
    def changeset(model, params \\ :invalid) do
        model
        |> cast(params, ~w(title f_name l_name DOB email username role_id))
        |> cast_attachments(params, [:image])
        |> validate_required([:title, :f_name, :l_name, :DOB, :email, :username, :role_id, :image])
        |> validate_length(:username, min: 2, max: 20)
        |> unique_constraint(:username)
        |> assoc_constraint(:role)
        |> cast_assoc(:addresses, required: true)
    end

Address.ex

schema "addresses" do
        field :house_n, :integer
        field :address_1, :string
        field :address_2, :string
        field :post_code, :string
        field :city, :string
        field :county, :string
        field :country, :string

        belongs_to :user, Assistant.Web.User, foreign_key: :user_id

        timestamps()
    end

      @doc """
      Builds a changeset based on the `struct` and `params`.
      """
    def changeset(struct, params \\ %{}) do
        struct
        |> cast(params, [:house_n, :address_1, :address_2, :post_code, :city, :county, :country])
        |> validate_required([:house_n, :address_1, :address_2, :post_code, :city, :county, :country])
    end

When I try to delete a new user I have created it gives me this error:
constraint error when attempting to delete struct:

  • foreign_key: addresses_user_id_fkey

I have searched through the forum and on stack overflow and the solution seems to be to add the foreign_key_constraint(), but I am not exactly clear on how to go on about it as I have tried following the suggestions, but so far I keep getting the same error. Has it got anything to do with the cast_assoc()? I’ve got that from the book programming phoenix but online I found varying opinions on it so I thought maybe that could be the issue.

Thank you for your help :slight_smile:

Showing Posts 1 to 4

kokolegorille

kokolegorille

Maybe You could set the on_delete option between user and its addresses association.

By default, it will do nothing… Thus I think it is why You get this error.

For this to work, You could look at

https://hexdocs.pm/ecto/Ecto.Migration.html#references/2

and

This would be in your addresses migration

add :user_id, references("users"), on_delete: :delete_all

and in the schema

has_one :addresses, Assistant.Web.Address, on_delete: :delete_all

It is not tested, but it might help…

carlosarli

carlosarli OP

Thanks for your reply :slight_smile:
I would also delete the cast_assoc from the changeset right?

carlosarli

carlosarli OP

It works!! it was the on_delete thing thank you :slight_smile:

kokolegorille

kokolegorille

Glad it works :slight_smile:

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
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
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
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
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New

Other Trending Topics Top

JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews