ruby on rails-在OmniauthCallbacksController期间约束失败

Question

我对RubyonRails很陌生，所以请耐心等待。

我希望用户能够通过Facebook登录。我遵循了railscast#265 Devise和OmniAuth(修订版(。在railscast中，用户在登录Facebook之前会被要求提供电子邮件地址。我希望用户能够通过Facebook登录，而无需事先发送电子邮件地址。

我使用的：Devise和Omniauth脸书宝石

我的期望：用户点击链接，通过Facebook登录，Facebook返回电子邮件、姓名、uid，我的应用程序将其保存到数据库中，用户就创建了。

我得到的：错误消息ActiveRecord::StatementInvalid in OmniauthCallbacksController#facebook

SQLite3::ConstraintException: constraint failed: INSERT INTO "users" ("created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "last_sign_in_at", "last_sign_in_ip", "name", "provider", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "uid", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

这是我的user.rb模型：

class User < ActiveRecord::Base
  # Include default devise modules. Others available are:
  # :token_authenticatable, :confirmable,
  # :lockable, :timeoutable and :omniauthable
  devise :database_authenticatable, :registerable, :omniauthable,
         :recoverable, :rememberable, :trackable, :validatable
  # Setup accessible (or protected) attributes for your model
  attr_accessible :email, :password, :password_confirmation, :remember_me
  # attr_accessible :title, :body
  # Nodig als :validatable uit is
  #validates_presence_of   :email, :if => :email_required?
  #validates_uniqueness_of :email, :allow_blank => true, :if => :email_changed?
  #validates_format_of     :email, :with  => Devise.email_regexp, :allow_blank => true, :if => :email_changed?
  #
  #validates_presence_of     :password, :if => :password_required?
  #validates_confirmation_of :password, :if => :password_required?
  #validates_length_of       :password, :within => Devise.password_length, :allow_blank => true

  def self.from_omniauth(auth)
    where(auth.slice(:provider, :uid)).first_or_create do |user|
      user.provider = auth.provider
      user.uid = auth.uid
      user.email = auth.email
      user.name = auth.info.name
    end
  end
  def self.new_with_session(params, session)
    if session["devise.user_attributes"]
      new(session["devise.user_attributes"], without_protection: true) do |user|
        user.attributes = params
        user.valid?
      end
    else
      super
    end
  end
  def email_required?
    provider == :facebook
  end
  def password_required?
    super && provider.blank?
  end
  def update_with_password(params, *options)
    if encrypted_password.blank?
      update_attributes(params, *options)
    else
      super
    end
  end
end

这是我将OmniAuth添加到用户(用户已经有电子邮件(的迁移

class AddOmniauthToUsers < ActiveRecord::Migration
  def change
    add_column :users, :provider, :string
    add_column :users, :uid, :string
    add_column :users, :name, :string
  end
end

这是我的OmniAuth回调控制器：

class OmniauthCallbacksController < Devise::OmniauthCallbacksController
  def all
      user = User.from_omniauth(request.env["omniauth.auth"])
      if user.persisted?
        flash.notice = "Loged in!"
        sign_in_and_redirect user
      else
        session["devise.user_attributes"] = user.attributes
        redirect_to new_user_registration_url
      end
    end
    alias_method :facebook, :all  
end

提前感谢

编辑：堆栈跟踪：

app/models/user.rb:23:in `from_omniauth'
app/controllers/omniauth_callbacks_controller.rb:3:in `all'

编辑：服务器日志奇怪的是，当我打印auth时，我可以在服务器日志中看到名称、电子邮件、提供商和uid。然而，随后出现了以下情况：

INSERT INTO "users" ("created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "last_sign_in_at", "last_sign_in_ip", "name", "provider", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "uid", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["created_at", Tue, 26 Feb 2013 17:20:23 UTC +00:00], ["current_sign_in_at", nil], ["current_sign_in_ip", nil], ["email", nil], ["encrypted_password", ""], ["last_sign_in_at", nil], ["last_sign_in_ip", nil], ["name", nil], ["provider", "facebook"], ["remember_created_at", nil], ["reset_password_sent_at", nil], ["reset_password_token", nil], ["sign_in_count", 0], ["uid", "XXXXX"], ["updated_at", Tue, 26 Feb 2013 17:20:23 UTC +00:00]]
SQLite3::ConstraintException: constraint failed: INSERT INTO "users" ("created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "last_sign_in_at", "last_sign_in_ip", "name", "provider", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "uid", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

例如，名称、电子邮件是nil，但提供者和uid(现在是XXXXX(已经填写完毕。我在用户模型中添加了自己的名称和电子邮件。也许这里有问题？这有帮助吗？

Answer 1

每当我放入p auth.info.email(对于需要添加.info的许多事情(时，服务器日志都会显示电子邮件地址。

我认为这与我改变了我的用户模型有关：

  def self.from_omniauth(auth)
    where(auth.slice(:provider, :uid)).first_or_initialize.tap do |user|
      user.provider = auth.provider
      user.uid = auth.uid
      user.email = auth.info.email
      user.name = auth.info.name
      user.save!
    end
  end

错误现在消失了。我添加了user.save!，我更改为auth.info.email，我将first_or_create替换为first_or_initialize.tap

因此，当我在控制台(User.all(中查看时，电子邮件、名称、uid和提供者都在数据库中。

显然现在一切都好了。坦克伤害你的帮助！

p.s：服务器日志仍然会打问号，但确实会将数据保存在记录中。

Answer 2

我猜你要么试图创建一个没有所有必需字段的用户，要么试图创建已经存在的用户(我怀疑电子邮件中存在唯一性限制(。

消灭后来的；从用户表中删除所有用户。

测试前者；尝试使用User.create(some_params)创建一个用户，该用户具有与from_omniauth方法相同的参数。要想弄清楚这些，可以使用类似于撬或简单地做的东西：

def self.from_omniauth(auth)
    p auth # Add this line and watch the logs.
    ....
end

同样可能有帮助的是查看db/schema.rb(或运行rake db:structure:dump后的db/structure.sql(，看看是否有任何NOT NULL或UNIQUE约束。