sezaru
Suggestion: Add possibility to write calculate expression inside code block
Currently, when writing a calculation, the third argument is the expression.
For example:
calculate :full_name, :string, expr(first_name <> " " <> last_name)
This looks clean and simple, but when the calculation is a little bit more complex, it starts to get a little bit messy:
calculate :total_feedbacks_in_class_this_month,
:integer,
expr(
count(feedbacks,
query: [
filter:
expr(
class_id == ^arg(:class_id) and
inserted_at >= fragment("date_trunc('month', now())") and
inserted_at <
fragment("date_trunc('month', now()) + interval '1 month'")
)
]
)
) do
argument :class_id, :string, allow_nil?: false
end
I was wondering if we could add an alternative way to write the calculations where we can not write the third argument and alternatively add it inside the calculate code block.
Something like this:
calculate :total_feedbacks_in_class_this_month, :integer do
expression expr(
count(feedbacks,
query: [
filter:
expr(
class_id == ^arg(:class_id) and
inserted_at >= fragment("date_trunc('month', now())") and
inserted_at < fragment("date_trunc('month', now()) + interval '1 month'")
)
]
)
)
argument :class_id, :string, allow_nil?: false
end
At least for me, this seems easier to read.
Marked As Solved
zachdaniel
Creator of Ash
You can do this today:
calculate :total_feedbacks_in_class_this_month, :integer do
calculation expr(
count(feedbacks,
query: [
filter:
expr(
class_id == ^arg(:class_id) and
inserted_at >= fragment("date_trunc('month', now())") and
inserted_at < fragment("date_trunc('month', now()) + interval '1 month'")
)
]
)
)
argument :class_id, :string, allow_nil?: false
end
Popular in Questions
Why is it that the mnesia database isn’t the most preferred database for use in Elixir/Phoenix?
New
Hello everybody,
usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors:
[WARN] - (starship::utils): Executing command ...
New
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
Hi! May someone helps me, please!
I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
New
If I have a string “1000 cfu/ml” . I want to remove the characters and / and space . So the string is like this
"1000"
What is the ...
New
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
New
Hello!
Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
There are pre-rolled solutions for other frameworks that do work. However, Phoenix does not seem to have these. Have people had good expe...
New
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New
Other popular topics
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: )
Hello all, this is ...
New
Good day to you all.
I have been struggling to get a query involving like and ilike to work.
Can anyone assist me on this, please?
pro...
New
This release brings a number of exciting features, including integration with the new Phoenix LiveDashboard and Phoenix LiveView. There h...
New
lets say i have a sample like
a = 20; b = 10;
if (a > b) do
{:ok, "a"}
end
if (a < b) do
{:ok, b}
end
if (a == b) do
{:ok, "equa...
New
When I run the Plug and I recompile I wind up having to use Ctrl C to quit iex and start again. Witht the help of rlwrap I can use the cu...
New
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
New
I am VERY much an elixir newbie. I have taken one elixir course and one phoenix course on Udemy. During that course, I saw the instructor...
New
I am trying to run a deploy with docker and I successfully runned with this command:
docker build -t romenigld/blog-prod .
but when I t...
New
I had some trouble figuring out how to make many-to-many associations work. Once I got it working, I wrote a blog post. Because I’m a nov...
New
I wrote this comment on r/haskell, and it’s not popular there. :wink: But I think I’m on to something…
Haskell reminds me of Java, and e...
New
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








