BryanJBryce
Does Ash support defining exclusion constraints on resources with the DSL?
Does Ash support defining exclusion constraints on resources with the DSL (maybe that’s a Postgres specific thing?).
I’m wanting to enforce non-overlapping appointment times. It may be that I need to just write custom SQL, which, I think is how it’s done in Ecto currently if you want to do it.
Marked As Solved
zachdaniel
There is no way to do it using any of the builtin ones (like check_constraint), but you can at least manage it in the resource using custom_statements.
The example for that is here:
But I’ll copy it over for reference:
custom_statements do
# the name is used to detect if you remove or modify the statement
statement :pgweb_idx do
up "CREATE INDEX pgweb_idx ON pgweb USING GIN (to_tsvector('english', title || ' ' || body));"
down "DROP INDEX pgweb_idx;"
end
end
Also Liked
zachdaniel
Keep in mind that with custom_statements sometimes you will need to manually reorder the statements in your migration, i.e if it refers to a field you are adding or something like that.
zachdaniel
That is used for expressing a list of exclusion constraints that exist that may raise errors, so if you add an exclusion constraint you should add the name there so you get a nice error.
Popular in Questions
Other popular topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
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.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"