This Library set default params process for where query in ActiveRecord
- Params:
# rails 4 and above, default_where does nothing
params = { role_id: 1, age: 20 }
User.default_where(params)- params
User.belongs_to :role
params = { name: 'dhh', 'role.id': 2 }- Before use
default_where
User.includes(:student).where(name: params[:name], role: {id: params[:'role.id']})- After Use
default_where
User.default_where(params)- params
params = { 'role_id-lte': 2 }- Before use
default_where
User.where('role_id >= ?', params[:'role_id-lte'])- After use
default_where
User.default_where(params)- params
params = { age: '', role_id: 1 }- Before use
default_where
users = User.where(role_id: params[:role_id])
users = users.where(age: params[:age]) if params[:age]- After use
default_where
User.default_where(params)- Params
params = { o1: 'age-asc', o2: 'last_login_at-asc' }- Before use
default_where
User.order(age: :asc, last_login_at: :asc)- After use
default_where
User.default_where(params)- Params
{ name: 'dhh', 'role.id': 2, 'age-lte': 2, o1: 'age-asc', o2: 'last_login_at-asc' }- Before use
default_where
User.includes(:role).where(name: params[:name], 'roles.id': params[:'role.id']).order(age: :asc, last_login_at: :asc)- After use
default_where
User.default_where(params)It will generate the query scope to above params must use string key