aaron-price
Ecto association with custom name
Suppose I have two schemas, Property, and User.
schema "property" do
belongs_to :owner, User, [foreign_key: :owner_id]
end
schema "user" do
has_many :property, Property, [references: :owner_id]
end
And migrations
create table(:user) do
end
create table(:property) do
add :owner_id, references(:user)
end
When I recompile at the repl, I get
== Compilation error in file lib/app/accounts/user.ex ==
** (ArgumentError) schema does not have the field :owner_id used by association :property, please set the :references option accordingly
Marked As Solved
mhanberg
I think for your user schema want to set the foreign_key to owner_id, as that is the key it is references on the other schema. by default it will look for user_id on the property schema
You don’t need to set the :references option since the foreign key is still pointing to the id column on the user table
schema "user" do
has_many :property, Property, foreign_key: :owner_id
end
Also Liked
aaron-price
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io
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
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"