hauleth
Proposal: Named parameters in Ecto `fragment`s
There were cases when I needed to use some arguments in fragment few times, and as fragment("foo(?, ?)", a, a) roughly translates to foo($1, $2) with [a, a] passed as parameters, this sometimes result with unwanted results, so instead I would like to be able to do something like fragment("foo(?{a}, ?{a})", a: a) which would allow to improve some complicated queries in lateral joins (as these need to be fragments currently).
Most Liked
hauleth
Yes, you can (I have even created library for handling simple cases like that), but sometimes it is infeasible to create macro for each fragment in some queries. Also this will not work in case of some queries, ex.:
fragment("""
SELECT
date_fragment(foo.inserted_at, ?) AS date,
COUNT()
FROM foos foo
GROUP BY date_fragment(foo.inserted_at, ?)
""", date, date)
Will fail even with macro as date_fragment(foo.inserted_at, ?) in each case is different (even if it seems to be the same).
Popular in Discussions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Real-time error tracking, performance insights, and observability for devs.
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
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Real-time error tracking, performance insights, and observability for devs.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"