bvdh

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?

Showing Posts 1 to 6

cevado

cevado

Can you elaborate on what you want?
defaults will 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:

from(..., select: %{...})
|> Repo.all()
|> Enum.map(&Map.merge(defaults, &1))
bvdh

bvdh OP

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

cevado

Why not? data present after the Repo.all is not required to be uniform for the application side to work.
with Map.merge/2 the 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

mpope

Would select_merge/3 work?

LostKobrakai

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. select specifically 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

bvdh OP

@cevado to clarify: I should have written that it’s not the exact same column set that is present.

— All posts loaded —

Where Next? Top

Trending in Questions Top

Hellowman
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
yarrichar
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
pragdave
How do I tell Hologram not to escape HTML when substituting into templates? {Textile.render(@product.long_description)} escapes the HTM...
New
mandar1045
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
Fl4m3Ph03n1x
Background When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error: * assembling mark...
New
rlipscombe
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
saleyn
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 Top

GenericJam
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...
261 13183 112
New
mudasobwa
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
OndrejValenta
(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
kip
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
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews