SchemaPlus::Indexes adds various convenient capabilities to ActiveRecord's index handling.
SchemaPlus::Indexes is part of the SchemaPlus family of Ruby on Rails extension gems.
As usual:
gem "schema_plus_indexes" # in a Gemfile
gem.add_dependency "schema_plus_indexes" # in a .gemspect.string :role, index: true # shorthand for index: {}t.string :product_code, index: :unique # shorthand for index: { unique: true }Adds an option to include other columns in the index:
t.string :first_name
t.string :last_name, index: { with: :first_name }
t.string :country_code
t.string :area_code
t.string :local_number, index: { with: [:country_code, :area_code] }ActiveRecord supports the index: option to column definitions when creating table. SchemaPlus::Indexes extends that to work also with add_column and in change_table
add_column "tablename", "columnname", index: { ... }
change_table :tablename do |t|
t.integer :column, index: true
endThese of course accept the shorthands and with: option described above.
remove_index "tablename", "columnname", if_exists: trueSchemaPlus::Indexes lets you easily get the indexes of a model:
Model.indexes # shorthand for `connection.indexes(Model.table_name)`The value gets cached until the next time Model.reset_column_information is called.
-
Provides consistent behavior regarding attempted duplicate index creation: Ignore and log a warning. Different versions of Rails with different db adapters otherwise behave inconsistently: some ignore the attempt, some raise an error.
-
In the schema dump
schema.rb, index definitions are included within thecreate_tablestatements rather than added afterwards -
When using SQLite3, makes sure that the definitions returned by
connection.indexesproperly include the column orders (:ascor:desc) -
For the
ActiveRecord::ConnectionAdapters::IndexDefinitionclass (the object that's returned byconnection.indexes), SchemaPlus::Indexes:- Provides an
==operator to compare if two objects refer to an equivalent index - Allows calling
newwith a signature that matches add_index:IndexDefinition.new(table_name, column_names, options) - Fleshes out the
:ordersattribute, listing:ascfor a column instead of leaving it undefined. - Prevents errors from a down :change migration attempting to remove an index that wasn't previously added (this can arise, e.g. with auto-indexing plugins).
- Provides an
schema_plus_indexes is tested on
- ruby 2.5 with activerecord 5.2, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.5 with activerecord 6.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.5 with activerecord 6.1, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.7 with activerecord 5.2, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.7 with activerecord 6.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.7 with activerecord 6.1, using mysql2, sqlite3 or postgresql:9.6
- ruby 2.7 with activerecord 7.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.0 with activerecord 6.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.0 with activerecord 6.1, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.0 with activerecord 7.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.1 with activerecord 6.0, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.1 with activerecord 6.1, using mysql2, sqlite3 or postgresql:9.6
- ruby 3.1 with activerecord 7.0, using mysql2, sqlite3 or postgresql:9.6
- Add AR 6.1 and 7.0 support
- Add Ruby 3.1 support
- Drop AR < 5.2 and add 6.0 support
- Drop Ruby < 2.5 and add Ruby 3.0 support
- Remove its-it GEM
- Support AR 5.2. Thanks to @jeremyyap
- Supports AR 5.1. Thanks to @iagopiimenta
- Supports AR 5.0. Thanks to @myabc
- Missing require
- Explicit gem dependencies
- Upgrade to schema_plus_core 1.0 and conform
- Prevent down :change migrations from failing due to trying to remove non-existent indexes
- Initial release, extracted from schema_plus 1.x
Are you interested in contributing to schema_plus_indexes? Thanks! Please follow the standard protocol: fork, feature branch, develop, push, and issue pull request.
Some things to know about to help you develop and test:
-
schema_dev: SchemaPlus::Indexes uses schema_dev to facilitate running rspec tests on the matrix of ruby, activerecord, and database versions that the gem supports, both locally and on github actions
To to run rspec locally on the full matrix, do:
$ schema_dev bundle install $ schema_dev rspecYou can also run on just one configuration at a time; For info, see
schema_dev --helpor the schema_dev README.The matrix of configurations is specified in
schema_dev.ymlin the project root.
- schema_plus_core: SchemaPlus::Indexes uses the SchemaPlus::Core API that provides middleware callback stacks to make it easy to extend ActiveRecord's behavior. If that API is missing something you need for your contribution, please head over to schema_plus_core and open an issue or pull request.
- schema_monkey: SchemaPlus::Indexes is implemented as a schema_monkey client, using schema_monkey's convention-based protocols for extending ActiveRecord and using middleware stacks.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent