tnederlof
I have an Event that has_one Number (the schema and migrations are shown simplified below). I can use put_assoc when inserting a number to associate a number with an event. However I would like to be able to disassociate the two (essentially remove the relationship) without deleting the Number or Event (so the number would end up with no event_id). Any ideas would be quite helpful.
defmodule App.Events.Event do
use Ecto.Schema
import Ecto.Changeset
schema "events" do
field :description, :string
field :name, :string
has_one :number, App.Events.Number
timestamps()
end
@doc false
def changeset(event, attrs) do
required_fields = [:name]
optional_fields = [:description]
event
|> cast(attrs, required_fields ++ optional_fields)
|> validate_required(required_fields)
end
end
defmodule App.Repo.Migrations.CreateEvents do
use Ecto.Migration
def change do
create table(:events) do
add :name, :string
add :description, :text
timestamps()
end
end
end
defmodule App.Events.Number do
use Ecto.Schema
import Ecto.Changeset
schema "numbers" do
field :description, :string
field :name, :string
field :phone_number, :string
belongs_to :event, App.Events.Event
timestamps()
end
@doc false
def changeset(number, attrs) do
required_fields = [:name, :phone_number]
optional_fields = [:description]
number
|> cast(attrs, required_fields ++ optional_fields)
|> validate_required(required_fields)
end
end
defmodule App.Repo.Migrations.CreateNumbers do
use Ecto.Migration
def change do
create table(:numbers) do
add :name, :string
add :description, :text
add :phone_number, :string, null: false
add :event_id, references(:events, on_delete: :delete_all)
timestamps()
end
end
end
Trending in Questions
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
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
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
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
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
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
I’m trying to set up Emacs with elixir-ls via lsp-mode and credo via Flycheck. This should mostly be preconfigured as Flycheck picks up c...
New
Other Trending Topics
I am happy to introduce the very α version of the new programming language compiled to BEAM.
Welcome Cure.
It has literally three kille...
New
Hobbes is a low-level distributed database for the Elixir programming language.
Hobbes provides a simple, safe, and scalable storage lay...
New
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
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
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
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming










Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
idi527
Would setting the
event_idtoNULLwork?tnederlof
Yes I think so, I was overthinking it! Thank you for the help.