/* * * * Copyright 2014 Orient Technologies LTD (info(at)orientechnologies.com) * * * * Licensed under the Apache License, Version 2.0 (the "License"); * * you may not use this file except in compliance with the License. * * You may obtain a copy of the License at * * * * http://www.apache.org/licenses/LICENSE-2.0 * * * * Unless required by applicable law or agreed to in writing, software * * distributed under the License is distributed on an "AS IS" BASIS, * * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * * See the License for the specific language governing permissions and * * limitations under the License. * * * * For more information: http://www.orientechnologies.com * */ package com.orientechnologies.orient.core.sql.functions.misc; import com.orientechnologies.common.collection.OMultiValue; import com.orientechnologies.orient.core.command.OCommandContext; import com.orientechnologies.orient.core.db.record.OIdentifiable; import com.orientechnologies.orient.core.record.impl.ODocument; import com.orientechnologies.orient.core.sql.method.misc.OAbstractSQLMethod; import java.util.ArrayList; import java.util.List; import java.util.Map; /** * Filter the content by including only some fields. If the content is a document, then creates a copy with only the included * fields. If it's a collection of documents it acts against on each single entry. * * <p> * Syntax: <blockquote> * * <pre> * include(<field|value|expression> [,<field-name>]* ) * </pre> * * </blockquote> * * <p> * Examples: <blockquote> * * <pre> * SELECT <b>include(roles, 'name')</b> FROM OUser * </pre> * * </blockquote> * * @author Luca Garulli (l.garulli--at--orientechnologies.com) */ public class OSQLMethodInclude extends OAbstractSQLMethod { public static final String NAME = "include"; public OSQLMethodInclude() { super(NAME, 1, -1); } @Override public String getSyntax() { return "Syntax error: include([<field-name>][,]*)"; } @Override public Object execute(Object iThis, OIdentifiable iCurrentRecord, OCommandContext iContext, Object ioResult, Object[] iParams) { if (iParams[0] != null) { if(iThis instanceof OIdentifiable){ iThis = ((OIdentifiable) iThis).getRecord(); } if (iThis instanceof ODocument) { // ACT ON SINGLE DOCUMENT return copy((ODocument) iThis, iParams); } else if (iThis instanceof Map) { // ACT ON MAP return copy((Map) iThis, iParams); } else if (OMultiValue.isMultiValue(iThis)) { // ACT ON MULTIPLE DOCUMENTS final List<Object> result = new ArrayList<Object>(OMultiValue.getSize(iThis)); for (Object o : OMultiValue.getMultiValueIterable(iThis, false)) { if (o instanceof OIdentifiable) { result.add(copy((ODocument) ((OIdentifiable) o).getRecord(), iParams)); } } return result; } } // INVALID, RETURN NULL return null; } private Object copy(final ODocument document, final Object[] iFieldNames) { final ODocument doc = new ODocument(); for (int i = 0; i < iFieldNames.length; ++i) { if (iFieldNames[i] != null) { final String fieldName = (String) iFieldNames[i].toString(); doc.field(fieldName, document.field(fieldName)); } } return doc; } private Object copy(final Map map, final Object[] iFieldNames) { final ODocument doc = new ODocument(); for (int i = 0; i < iFieldNames.length; ++i) { if (iFieldNames[i] != null) { final String fieldName = (String) iFieldNames[i].toString(); doc.field(fieldName, map.get(fieldName)); } } return doc; } }