curioustolearn
Repo.load does not assign a value to virtual fields
Hello,
I have results from a raw SQL query (using Postgres). I am trying to use Repo.load to map the results to an existing schema in my application. All columns are mapped except one column that is a virtual field. The column exists in the query result (as a string because it is from a raw query) and has values in each row. There is a 2018 post here, but it is not conclusive. Someone said that it is a bug if this happens. Anyone knows if this bug has been fixed? If not what is a good workaround?
I am using {:phoenix_ecto, "~> 4.5"}, {:ecto_sql, "~> 3.13"}`.
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Phoenix, LiveView, multimedia pipelines, distributed systems. 400 engineers, Elixir since 2017. Available for hire.
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
- #elixirconf-us
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #performance
- #security
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.
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!"
First 3 of 3 Posts!
curioustolearn
I would appreciate some advice from those who have experience. Should I just abandon the idea of trying to load it into a schema and use standard maps instead for this use case?
Thank you.
Schultzer
You might want to raise the issue in the Ecto github repository, to me it sounds like a bug.
curioustolearn
Thank you. I will do that.