RailsDevsForDataIntegrity

Rails Devs For Data Integrity catches unique key and foreign key violations coming from the MySQLdatabase and converts them into an error on the ActiveRecord object similar to validation errors

class User < ActiveRecord::Base
  handle_unique_key_violation  :user_name, :message => 'is taken"
  handle_foreign_key_violation :primary_email_id, :message => 'is not available'
end

Instead of this nasty MySQL foreign key error:

ActiveRecord::StatementInvalid: Mysql::Error: Cannot add or update a child row:
a foreign key constraint fails (`zoo_development/animals`,
CONSTRAINT `fk_animal_species` FOREIGN KEY (`species_id`)
REFERENCES `species` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)

>> user.errors.on(:user_name)
=> "association does not exist."

Or in the case of a unique key violation:

>> user.errors.on(:primary_email_id)
=> "is a duplicate."

Developers

Install

Copyright © 2009 [name of plugin creator], released under the MIT license