11 replies

Validations on aggregates

AshPostgres

Hi, I am implementing something similar to this: https://stackoverflow.com/questions/20744564/postgres-constraint-on-sum-of-a-column-without-triggers

I am wondering if there is an Ash way to do this such that when creating/updating a box, we'd effectively do these validations on the crate in a concurrency safe way.
⁨⁨

  # On the Crate resource                                                                                                           
  aggregates do                                                                                                                     
    sum :current_volume_used, :boxes, :box_volume                                                                                   
  end                                                                                                                               
                                                                                                                                    
  # Add a validation to check capacity                                                                                              
  validations do                                                                                                                    
    validate compare(:current_volume_used, less_than_or_equal_to: :max_volume),                                                     
      where: [present(:max_volume)]                                                                                               
  end

  # On the Crate resource                                                                                                           
  aggregates do                                                                                                                     
    sum :current_volume_used, :boxes, :box_volume                                                                                   
  end                                                                                                                               
                                                                                                                                    
  # Add a validation to check capacity                                                                                              
  validations do                                                                                                                    
    validate compare(:current_volume_used, less_than_or_equal_to: :max_volume),                                                     
      where: [present(:max_volume)]                                                                                               
  end

⁩⁩

Ash Framework•2mo ago•

11 replies

Validations on aggregates

AshPostgres

  # On the Crate resource                                                                                                           
  aggregates do                                                                                                                     
    sum :current_volume_used, :boxes, :box_volume                                                                                   
  end                                                                                                                               
                                                                                                                                    
  # Add a validation to check capacity                                                                                              
  validations do                                                                                                                    
    validate compare(:current_volume_used, less_than_or_equal_to: :max_volume),                                                     
      where: [present(:max_volume)]                                                                                               
  end

  # On the Crate resource                                                                                                           
  aggregates do                                                                                                                     
    sum :current_volume_used, :boxes, :box_volume                                                                                   
  end                                                                                                                               
                                                                                                                                    
  # Add a validation to check capacity                                                                                              
  validations do                                                                                                                    
    validate compare(:current_volume_used, less_than_or_equal_to: :max_volume),                                                     
      where: [present(:max_volume)]                                                                                               
  end

⁩⁩

Validations on aggregates

Validations on aggregates

Similar Threads

Similar Threads

Similar Threads