Skip to content

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

License

Notifications You must be signed in to change notification settings

OpenGems/rails_scopy

Repository files navigation

RailsScopy

Gem Version Maintainability Build Status security Gem Coverage Status

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.