validates-uniqueness-of ruby-on-rails-3.1

ActiveRecord::RecordNotUnique 之前的 validates_uniqueness_of

发布于 2024-12-10 05:30:23 字数 811 浏览 0 评论 0原文

我在 Rails 3.1.1 应用程序中有以下类：

class User < ActiveRecord::Base  
  attr_accessible :email, :password, :password_confirmation, :remember_me, :username, :admin, :moderator, :bio
  validates_presence_of :username
  validates_uniqueness_of :username, :case_sensitive => false
  validates_uniqueness_of :email,  :case_sensitive => false

并且在我的迁移中：

add_index :users, :email,                :unique => true
add_index :users, :username,             :unique => true

但是，当我尝试创建两个具有重复电子邮件或用户名的用户时，我得到数据库级别异常而不是失败的验证：

ActiveRecord::RecordNotUnique in RegistrationsController#create
PGError: ERROR:  duplicate key value violates unique constraint "index_users_on_username"

还有其他有效的验证完美，但是为什么在创建数据库之前不执行唯一性验证？

原文

I have the following class in a Rails 3.1.1 app:

class User < ActiveRecord::Base  
  attr_accessible :email, :password, :password_confirmation, :remember_me, :username, :admin, :moderator, :bio
  validates_presence_of :username
  validates_uniqueness_of :username, :case_sensitive => false
  validates_uniqueness_of :email,  :case_sensitive => false

and in my migrations:

add_index :users, :email,                :unique => true
add_index :users, :username,             :unique => true

However, when I try to create two users with duplicate emails or usernames I get a DB level exception rather than a failing validation:

ActiveRecord::RecordNotUnique in RegistrationsController#create
PGError: ERROR:  duplicate key value violates unique constraint "index_users_on_username"

There are other validations that work perfectly, but why aren't the uniqueness validations being performed before the DB create?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

差↓一点笑了 2024-12-17 05:30:23

尝试这样的事情：

class User < ActiveRecord::Base
  attr_accessible :email, 
              :password, 
              :password_confirmation, 
              :remember_me, 
              :username, 
              :admin, 
              :moderator, 
              :bio
  validates :username, :uniqueness => { :case_sensitive => false }, :presence => true
  validates :email,    :uniqueness => { :case_sensitive => false }

Try something like this:

class User < ActiveRecord::Base
  attr_accessible :email, 
              :password, 
              :password_confirmation, 
              :remember_me, 
              :username, 
              :admin, 
              :moderator, 
              :bio
  validates :username, :uniqueness => { :case_sensitive => false }, :presence => true
  validates :email,    :uniqueness => { :case_sensitive => false }

回复收藏 0 原文

~没有更多了~