Method: Engine2::StarToManyListAction#list_context

Defined in:

lib/engine2/action/list.rb

#list_context(query, handler) ⇒ Object

# File 'lib/engine2/action/list.rb', line 217

def list_context query, handler
    handler.permit parent = handler.params[:parent_id]
    model = assets[:model]
    assoc = assets[:assoc]
    parent_keys = split_keys(parent)
    case assoc[:type]
    when :one_to_many
        keys = assoc[:keys]
        condition = parent_keys.all?(&:empty?) ? false : Hash[keys.map{|k| model.table_name.q(k)}.zip(parent_keys)]
        if handler.params[:negate]
            query = query.exclude(condition)
            query = query.or(Hash[keys.zip([nil])]) if keys.all?{|k|model.db_schema[k][:allow_null] == true} # type_info[:required] ?
            query
        else
            query.where(condition)
        end
    when :many_to_many
        q_pk = model.primary_keys_qualified
        j_table = assoc[:join_table]
        l_keys = assoc[:left_keys].map{|k| j_table.q(k)}
        r_keys = assoc[:right_keys].map{|k| j_table.q(k)}
        r_keys_vals = Hash[r_keys.zip(q_pk)]
        l_keys_vals = parent_keys.all?(&:empty?) ? false : Hash[l_keys.zip(parent_keys)]

        if handler.params[:negate]
            query.exclude(model.db[j_table].select(nil).where(r_keys_vals & l_keys_vals).exists)
        else
            # query.qualify.join(j_table, [r_keys_vals, l_keys_vals])
            if joins = query.opts[:join] and joins.find{|j|j.table == j_table}
                query
            else
                query.qualify.left_join(j_table, r_keys_vals)
            end.filter(l_keys_vals)
        end
    else unsupported_association
    end
end