1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283
|
require 'mongoid'
require 'rails_admin/config/sections/list'
require 'rails_admin/adapters/mongoid/abstract_object'
require 'rails_admin/adapters/mongoid/association'
require 'rails_admin/adapters/mongoid/property'
module RailsAdmin
module Adapters
module Mongoid
DISABLED_COLUMN_TYPES = ['Range', 'Moped::BSON::Binary', 'BSON::Binary', 'Mongoid::Geospatial::Point']
def new(params = {})
AbstractObject.new(model.new(params))
end
def get(id)
AbstractObject.new(model.find(id))
rescue => e
raise e if %w(
BSON::InvalidObjectId
Mongoid::Errors::DocumentNotFound
Mongoid::Errors::InvalidFind
Moped::Errors::InvalidObjectId
).exclude?(e.class.to_s)
end
def scoped
model.scoped
end
def first(options = {}, scope = nil)
all(options, scope).first
end
def all(options = {}, scope = nil)
scope ||= scoped
scope = scope.includes(*options[:include]) if options[:include]
scope = scope.limit(options[:limit]) if options[:limit]
scope = scope.any_in(_id: options[:bulk_ids]) if options[:bulk_ids]
scope = scope.where(query_conditions(options[:query])) if options[:query]
scope = scope.where(filter_conditions(options[:filters])) if options[:filters]
if options[:page] && options[:per]
scope = scope.send(Kaminari.config.page_method_name, options[:page]).per(options[:per])
end
scope = sort_by(options, scope) if options[:sort]
scope
end
def count(options = {}, scope = nil)
all(options.merge(limit: false, page: false), scope).count
end
def destroy(objects)
Array.wrap(objects).each(&:destroy)
end
def primary_key
'_id'
end
def associations
model.relations.values.collect do |association|
Association.new(association, model)
end
end
def properties
fields = model.fields.reject { |_name, field| DISABLED_COLUMN_TYPES.include?(field.type.to_s) }
fields.collect { |_name, field| Property.new(field, model) }
end
def table_name
model.collection_name.to_s
end
def encoding
'UTF-8'
end
def embedded?
model.relations.values.detect { |a| a.macro.to_sym == :embedded_in }
end
def cyclic?
model.cyclic?
end
def adapter_supports_joins?
false
end
private
def build_statement(column, type, value, operator)
StatementBuilder.new(column, type, value, operator).to_statement
end
def make_field_conditions(field, value, operator)
conditions_per_collection = {}
field.searchable_columns.each do |column_infos|
collection_name, column_name = parse_collection_name(column_infos[:column])
value = parse_field_value(field, value)
statement = build_statement(column_name, column_infos[:type], value, operator)
next unless statement
conditions_per_collection[collection_name] ||= []
conditions_per_collection[collection_name] << statement
end
conditions_per_collection
end
def query_conditions(query, fields = config.list.fields.select(&:queryable?))
statements = []
fields.each do |field|
value = parse_field_value(field, query)
conditions_per_collection = make_field_conditions(field, value, field.search_operator)
statements.concat make_condition_for_current_collection(field, conditions_per_collection)
end
if statements.any?
{'$or' => statements}
else
{}
end
end
# filters example => {"string_field"=>{"0055"=>{"o"=>"like", "v"=>"test_value"}}, ...}
# "0055" is the filter index, no use here. o is the operator, v the value
def filter_conditions(filters, fields = config.list.fields.select(&:filterable?))
statements = []
filters.each_pair do |field_name, filters_dump|
filters_dump.each do |_, filter_dump|
field = fields.detect { |f| f.name.to_s == field_name }
next unless field
value = parse_field_value(field, filter_dump[:v])
conditions_per_collection = make_field_conditions(field, value, (filter_dump[:o] || 'default'))
field_statements = make_condition_for_current_collection(field, conditions_per_collection)
if field_statements.many?
statements << {'$or' => field_statements}
elsif field_statements.any?
statements << field_statements.first
end
end
end
if statements.any?
{'$and' => statements}
else
{}
end
end
def parse_collection_name(column)
collection_name, column_name = column.split('.')
if [:embeds_one, :embeds_many].include?(model.relations[collection_name].try(:macro).try(:to_sym))
[table_name, column]
else
[collection_name, column_name]
end
end
def make_condition_for_current_collection(target_field, conditions_per_collection)
result = []
conditions_per_collection.each do |collection_name, conditions|
if collection_name == table_name
# conditions referring current model column are passed directly
result.concat conditions
else
# otherwise, collect ids of documents that satisfy search condition
result.concat perform_search_on_associated_collection(target_field.name, conditions)
end
end
result
end
def perform_search_on_associated_collection(field_name, conditions)
target_association = associations.detect { |a| a.name == field_name }
return [] unless target_association
model = target_association.klass
case target_association.type
when :belongs_to, :has_and_belongs_to_many
[{target_association.foreign_key.to_s => {'$in' => model.where('$or' => conditions).all.collect { |r| r.send(target_association.primary_key) }}}]
when :has_many
[{target_association.primary_key.to_s => {'$in' => model.where('$or' => conditions).all.collect { |r| r.send(target_association.foreign_key) }}}]
end
end
def sort_by(options, scope)
return scope unless options[:sort]
case options[:sort]
when String
field_name, collection_name = options[:sort].split('.').reverse
if collection_name && collection_name != table_name
fail('sorting by associated model column is not supported in Non-Relational databases')
end
when Symbol
field_name = options[:sort].to_s
end
if options[:sort_reverse]
scope.asc field_name
else
scope.desc field_name
end
end
class StatementBuilder < RailsAdmin::AbstractModel::StatementBuilder
protected
def unary_operators
{
'_blank' => {@column => {'$in' => [nil, '']}},
'_present' => {@column => {'$nin' => [nil, '']}},
'_null' => {@column => nil},
'_not_null' => {@column => {'$ne' => nil}},
'_empty' => {@column => ''},
'_not_empty' => {@column => {'$ne' => ''}},
}
end
private
def build_statement_for_type
case @type
when :boolean then build_statement_for_boolean
when :integer, :decimal, :float then build_statement_for_integer_decimal_or_float
when :string, :text then build_statement_for_string_or_text
when :enum then build_statement_for_enum
when :belongs_to_association, :bson_object_id then build_statement_for_belongs_to_association_or_bson_object_id
end
end
def build_statement_for_boolean
return {@column => false} if %w(false f 0).include?(@value)
return {@column => true} if %w(true t 1).include?(@value)
end
def column_for_value(value)
{@column => value}
end
def build_statement_for_string_or_text
return if @value.blank?
@value = begin
case @operator
when 'default', 'like'
Regexp.compile(Regexp.escape(@value), Regexp::IGNORECASE)
when 'starts_with'
Regexp.compile("^#{Regexp.escape(@value)}", Regexp::IGNORECASE)
when 'ends_with'
Regexp.compile("#{Regexp.escape(@value)}$", Regexp::IGNORECASE)
when 'is', '='
@value.to_s
else
return
end
end
{@column => @value}
end
def build_statement_for_enum
return if @value.blank?
{@column => {'$in' => Array.wrap(@value)}}
end
def build_statement_for_belongs_to_association_or_bson_object_id
{@column => @value} if @value
end
def range_filter(min, max)
if min && max
{@column => {'$gte' => min, '$lte' => max}}
elsif min
{@column => {'$gte' => min}}
elsif max
{@column => {'$lte' => max}}
end
end
end
end
end
end
|