bgpratt2000
Hi! I’m super new to ecto and struggling with writing queries without using the postgreSQL views that I learned in college.
So what I’m wondering is:
Given the following schemas:
schema "s1" do
field :f1, :dtype1
field :f2, :dtype2
belongs_to :b1, B1
belongs_to :b2, B2
belongs_to :b3, B3
end
schema "s2" do
field :f3, :dtype2
belongs_to :b1, B1
belongs_to :b2, B2
belongs_to :b3, B3
belongs_to :b4, B4
end
how do I join s1 with s2 on b1, b2, and b3 without doing a million joins and associations?
In the end I actually want to update every instance of s1.f2 to be equal to the corresponding s2.b4.
THANKS!!!
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Courses that'll move you from confusion to "Aha, now I get it!"
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #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
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #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, logs, uptime, and Just Enough APM. Built for developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 1- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
Hermanverschooten
Hi and welcome.
There is no rule saying you cannot use views in ecto, you just replace your schema name with the name of the view.