bvdh
I’m trying to clean up my code by extracting default values in a select statment. I would like to do the following:
defaults = %{ x: :nil } # Large in reality, reused in different queries
from(product in Products, select: Map.merge(defaults, %{ y: true })
However, Ecto can’t compile the statement. Any tips on how to deal with this situation?
Trending in Questions
Hello everyone!
I am new to coding with Elixir/Erlang. And i am looking for some utilities for fuzzing testing like AFL++.
Does anyone ...
New
I’m very new to Elixir, so sorry if this is a silly question:
I am wondering what happens to the mailbox of a process when the machine i...
New
How do I tell Hologram not to escape HTML when substituting into templates?
{Textile.render(@product.long_description)}
escapes the HTM...
New
I load tested a plain Phoenix chat app backed by Postgres with 100 million messages in it, everything on default settings, to see what br...
New
Background
When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error:
* assembling mark...
New
I’d like to create a file with 600 permissions (rw-------), but there’s a race condition if I create it and then change the permissions. ...
New
Is there a way to import record definitions in the iex shell for pretty printing (similar to the rr command in the erl shell)? This woul...
New
Other Trending Topics
Edit: 2026 May 15 - This post is archived.
Mob is alive!!
Main docs: mob v0.7.11 — Documentation
A bit of explanation for the slightly c...
New
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly)
AI dream has many faces, but general...
New
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
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
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
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #elixirconf-us
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #elixirconf-eu
- #security
- #processes
- #api
- #forms
- #hex










Showing Posts 1 to 6- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
cevado
Can you elaborate on what you want?
defaultswill be a set of static values that will be added to the query in case they’re not present in the query result?if that’s the case you can’t do that in a query the way you want. either you do that with cte(or case conditions inside the select statment) or you handle that in the application side after you retrieve the query data:
bvdh
This problem arose in the context of several queries that get UNIONed, it’s not the exact same result set that is present. So doing things application side is not an option.
cevado
Why not? data present after the Repo.all is not required to be uniform for the application side to work.
with
Map.merge/2the second map(in my example the results of the query) will always have precedence over the default value.If you need the defaults data to make the union possible, you gonna need to be explicit setting those values in the query.
mpope
Would select_merge/3 work?
LostKobrakai
Ecto queries are a DSL to build sql queries, which you can see when doing e.g.
Repo.to_sql(:all, query). It therefore cannot allow you do run any actual elixir functions – the db wouldn’t know what to do with them.selectspecifically goes a bit astray from the plain sql in that it allows you to supply a non tabular format for data, which the data returned from the db is then mapped into. That still doesn’t allow you to use elixir functions though. For arbitrary transformations map the data manually after having loaded it from the db.bvdh
@cevado to clarify: I should have written that it’s not the exact same column set that is present.