Error while Rails/UniqueValidationWithoutIndex cop was inspecting

[aarona]

Error while Rails/UniqueValidationWithoutIndex cop was inspecting

[koic]

Unfortunately, I'm unable to reproduce the error. Rails/UniqueValidationWithoutIndex cop works model with db/schema.rb. Can you provide reproduction code for the error?

[yashka713]

@koic Could you explain how rubocop works with schema.rb?

Error:

app/models/buyer_user_notifications_setting.rb:4:3: C: Rails/UniqueValidationWithoutIndex: Uniqueness validation should have a unique index on the database column.
  validates :buyer_user_id, uniqueness: true
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Model:

validates :buyer_user_id, uniqueness: true

Schema:

create_table "buyer_user_notifications_settings", force: :cascade do |t|
    ...
    t.index ["buyer_user_id"], name: "index_buyer_user_notifications_settings_on_buyer_user_id", unique: true
  end

Migration:

add_index :buyer_user_notifications_settings, :buyer_user_id, unique: true, if_not_exists: true

pg_index:

Thank you!

[aarona]

Unfortunately, I'm unable to reproduce the error. Rails/UniqueValidationWithoutIndex cop works model with db/schema.rb. Can you provide reproduction code for the error?

I think that might be the issue here then. This is a simple website that actually has no ActiveRecord models associated with it. Just my POROs that are grabbing ActiveRecord functionality through some includes. Here's all of the code in my db/schema.rb file:

ActiveRecord::Schema.define(version: 0) do
end

Regardless, it seems that @yashka713 still has this problem even with real ActiveRecord models in their project.