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
|
# File 'lib/engine2/action/list.rb', line 242
def list_context query, handler
changes = handler.param_to_json(:changes)
model = assets[:model]
unlinked = changes[:unlink].to_a + changes[:delete].to_a + changes[:modify].to_a.map{|m|join_keys(model.primary_keys.map{|k|m[k]})}
linked = changes[:link]
query = super(query, handler)
pks = model.primary_keys_qualified
if handler.params[:negate]
query = unlinked.reduce(query){|q, unl|q.or pks.zip(split_keys(unl))}
query = linked.reduce(query){|q, ln|q.where(pks.zip(split_keys(ln)).sql_negate)}
else
query = unlinked.reduce(query){|q, unl|q.where(pks.zip(split_keys(unl)).sql_negate)}
query = case assets[:assoc][:type]
when :one_to_many
linked.reduce(query){|q, ln|q.or pks.zip(split_keys(ln))}
when :many_to_many
linked.reduce(query){|q, ln|q.or pks.zip(split_keys(ln))}.distinct
else unsupported_association
end unless linked.empty?
end
added = changes[:create].to_a + changes[:modify].to_a
cols = get_query.columns
query = added.reduce query do |q, a|
q.union(model.db.select(*cols.map{|c|a[c]}), all: true, alias: model.table_name)
end
query
end
|