An Active Record Plugin that allows chaining a more DSL-style 'like' or 'not-like' query to an ActiveRecord::Base#where. Requires Rails 5 or higher.
This plugin has been salvaged from the stellar work done by @amatsuda and @claudiob, updated to ActiveRecord 5 by @PikachuEXE and 5.2 by @robotdana and then to ActiveRecord 6.1 by @nrw505. Most of the code was previously in Active Record master, but was subsequently removed due to, amongst other, scope creep (see discussion here). Array parameter handling was added by @rzane - thanks!
Add this line to your application's Gemfile:
gem 'activerecord-like'
And then execute:
$ bundle
Or install it yourself as:
$ gem install activerecord-like
Given a class Post and the WhereChain work in Active Record, this plugin allows code like:
Post.where.like(title: "%rails%")
Post.where.like(title: ["%ruby%", "%rails%"])
and
Post.where.not_like(title: "%rails%")
Post.where.not_like(title: ["%ruby%", "%rails%"])
ActiveRecord 5 or higher
- Fork it
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Add some feature'
) - Make sure the tests run. I will not merge commits that change code without testing the new code. Running the tests is as easy as running
bundle && rake
- if this does not work, consider it a bug and report it. Testing with a specific database engine is done usingexport DB={engine}; bundle && rake
or the equivalent for your system. Supported engines aremysql
,sqlite3
andpg
. - Push to the branch (
git push origin my-new-feature
) - Create new Pull Request