20 replies

Issue with check constraint and upserts

AshPostgres

Hi, I'm putting this here, because i don't yet know if it's a bug, or a bad implementation.
I'm setting up an inventory resource, which should have a create action that is an upsert. My resource has a check constraint regarding quantity, which should always be >= 0.
Here's my action definition:

create :create do
    upsert? true
    upsert_fields []
    upsert_identity :unique_product
    accept [:product_id]
    require_attributes [:product_id]
    argument :quantity, :decimal, default: 0
    change set_attribute(:quantity, arg(:quantity))
    change atomic_update(:quantity, expr(quantity + ^arg(:quantity)))
end

create :create do
    upsert? true
    upsert_fields []
    upsert_identity :unique_product
    accept [:product_id]
    require_attributes [:product_id]
    argument :quantity, :decimal, default: 0
    change set_attribute(:quantity, arg(:quantity))
    change atomic_update(:quantity, expr(quantity + ^arg(:quantity)))
end

I've noticed that when the product exists in the inventory, upserting the inventory fails due to the check constraint everytime I'm deducing stock.
I removed the check constraints, everything works well. Don't know if it's a normal behaviour or should be reported as a bug.

Ash Framework•4d ago•

20 replies

franckstifler

Issue with check constraint and upserts

AshPostgres

create :create do
    upsert? true
    upsert_fields []
    upsert_identity :unique_product
    accept [:product_id]
    require_attributes [:product_id]
    argument :quantity, :decimal, default: 0
    change set_attribute(:quantity, arg(:quantity))
    change atomic_update(:quantity, expr(quantity + ^arg(:quantity)))
end

create :create do
    upsert? true
    upsert_fields []
    upsert_identity :unique_product
    accept [:product_id]
    require_attributes [:product_id]
    argument :quantity, :decimal, default: 0
    change set_attribute(:quantity, arg(:quantity))
    change atomic_update(:quantity, expr(quantity + ^arg(:quantity)))
end

Issue with check constraint and upserts

Similar Threads

Issue with check constraint and upserts

Similar Threads

Similar Threads

Similar Threads