RailsScopy

Generate automatically scopes in your model (PostgreSQL, SQLite, MySQL, etc...)

Installation

Add this line to your application's Gemfile:

gem 'rails_scopy'

And then execute:

$ bundle

Or install it yourself as:

$ gem install rails_scopy

Usage

Include RailsScopy in each models

class User < ApplicationRecord
  include RailsScopy
end

or in the parent model

class ApplicationRecord < ActiveRecord::Base
  include RailsScopy
end

and

User.not_admin

User.first_name_contains('Test')

Scopes available

SQL type	Scope method	Description
All	#{column}_eq(value)	equal
All	#{column}_not_eq(value)	not equal
All	#{column}_null	is null
All	#{column}_not_null	is not null
All	#{column}_present	not null and not empty
All	#{column}_blank	null or empty
All	ascend_by_#{column}	ascending order
All	descend_by_#{column}	descending order
boolean	#{column}	true
boolean	not_#{column}	false
json	#{column}_has_key(value)	key present in json
json	not_#{column}_has_not_key(value)	key doesn't present in json
boolean	#{column}	true
boolean	not_#{column}	false
date, datetime, time	#{column}_to(value)	<= to
date, datetime, time	#{column}_from(value)	from >=
date, datetime, time	#{column}_after(value)	after >
date, datetime, time	#{column}_before(value)	< before
date, datetime, time	#{column}_between(value)	from >= <= to
string, text	#{column}_contains(value)	contains
string, text	#{column}_not_contains(value)	doesn't contains
string, text	#{column}_starts_with(value)	start with
string, text	#{column}_not_starts_with(value)	doesn't start with
string, text	#{column}_ends_with(value)	end with
string, text	#{column}_not_ends_with(value)	doesn't end with
string, text	#{column}_length(value)	length eql
string, text	#{column}_between_length(value)	from >= <= to (length)
integer, float	#{column}_to(value)	<= to
integer, float	#{column}_from(value)	from >=
integer, float	#{column}_above(value)	above >
integer, float	#{column}_below(value)	< below
integer, float	#{column}_between(value)	from >= <= to
float	#{column}_scale(value)	scale eql (Number of decimal digits)

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/OpenGems/rails_scopy. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.

License

The gem is available as open source under the terms of the MIT License.