Application: gvSIG desktop

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_MAP;

            stmt = theGrammar.createStatement("MAP");

            stmt.addRule(stmt.require_any_token("MAP"));

            stmt.addRule(stmt.require_any_token("("));

            stmt.addRule(stmt.repeat()

                    .addRule(stmt.require_identifier().capture_as("NAME#"))

                    .addRule(stmt.require_any_token("="))

                    .addRule(stmt.require_expression().capture_as("VALUE#"))

                    .addRule(stmt.optional_any_token(",")

                            .addRuleOnFalse(stmt.break_loop())

                    )

            );      

            stmt.addRule(stmt.require_any_token(")"));

            stmt.code(FUNCTION_MAP,stmt.args_names("NAME#", "VALUE#"));

            theGrammar.addStatement(stmt);

import org.gvsig.expressionevaluator.impl.function.programming.EvalFunction;

import org.gvsig.expressionevaluator.impl.function.programming.MapFunction;

        this.addFunction(new EvalFunction());

        this.addFunction(new MapFunction());

package org.gvsig.expressionevaluator.impl.function.programming;

import java.util.HashMap;

import java.util.Map;

import org.apache.commons.lang3.Range;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_MAP;

import org.gvsig.expressionevaluator.Function;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.spi.AbstractFunction;

public class MapFunction extends AbstractFunction {

    public MapFunction() {

        super(Function.GROUP_PROGRAMMING, 

                FUNCTION_MAP, 

                Range.between(0, Integer.MAX_VALUE),

                null,

                null,

                null,

                "MAP",

                false

        );

    }

    @Override

    public boolean allowConstantFolding() {

        return false;

    }

    @Override

    public Object call(Interpreter interpreter, Object[] args) throws Exception {

      Map<Object,Object> map = new HashMap<>();

      for (int i_key = 0, i_val = args.length/2; i_key < args.length/2; i_key++, i_val++) {

        Object key = args[i_key];

        Object value = args[i_val];

        map.put(key, value);

      }

      return map;

    }

}

    public static final String FUNCTION_MAP = "MAP";

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.expressionevaluator.impl.function.dataaccess;

import org.apache.commons.lang3.Range;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.impl.DALFunctions;

import org.gvsig.expressionevaluator.spi.AbstractFunction;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_EXISTS_TABLE;

import org.gvsig.fmap.dal.DataStoreParameters;

/**

 *

 * @author jjdelcerro

 */

public class ExistsTableFunction extends AbstractFunction {

  public ExistsTableFunction() {

    super(DALFunctions.SYMBOLTABLE_NAME,

            FUNCTION_EXISTS_TABLE,

            Range.is(1),

            "Check if a table exists in the applicacion.",

            FUNCTION_EXISTS_TABLE,

            null,

            "Boolean",

            false

    );

  }

  @Override

  public boolean allowConstantFolding() {

    return false;

  }

  @Override

  public Object call(Interpreter interpreter, Object[] args) throws Exception {

    DataManager dataManager = DALLocator.getDataManager();  

    DataStoreParameters p = dataManager.getStoresRepository().get(getStr(args,0));

    return p!=null;

  }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.expressionevaluator.impl.function.dataaccess;

import java.util.Collections;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import java.util.Set;

import org.apache.commons.lang3.Range;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.impl.DALFunctions;

import org.gvsig.expressionevaluator.spi.AbstractFunction;

import org.gvsig.fmap.dal.AbstractStoresRepository;

import org.gvsig.fmap.dal.BaseStoresRepository;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_CREATE_IN_MEMORY_TABLE;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_EXISTS_TABLE;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.StoresRepository;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.tools.util.UnmodifiableBasicSet;

import org.gvsig.tools.util.UnmodifiableBasicSetAdapter;

/**

 *

 * @author jjdelcerro

 */

public class CreateInMemoryTableFunction extends AbstractFunction {

  public CreateInMemoryTableFunction() {

    super(DALFunctions.SYMBOLTABLE_NAME,

            FUNCTION_CREATE_IN_MEMORY_TABLE,

            Range.is(2),

            "",

            FUNCTION_CREATE_IN_MEMORY_TABLE,

            null,

            "Table",

            false

    );

  }

  @Override

  public boolean allowConstantFolding() {

    return false;

  }

  @Override

  public Object call(Interpreter interpreter, Object[] args) throws Exception {

    DataManager dataManager = DALLocator.getDataManager();  

    StoresRepository storesRepository = dataManager.getStoresRepository();

    MemoryStoresRepository repo = (MemoryStoresRepository) storesRepository.getSubrepository("Temporary");

    if( repo == null ) {

      repo = new MemoryStoresRepository("Temporary");

      storesRepository.addRepository(repo);

    }

    String targetName = getStr(args,0);

    String sourceName = getStr(args,1);

    FeatureStore source = (FeatureStore) storesRepository.getStore(sourceName);

    if( source == null ) {

      throw new ExpressionRuntimeException("Can't locate source table '"+sourceName+"'.");    

    }

    EditableFeatureType featureType = source.getDefaultFeatureType().getEditable();

    FeatureStore target = dataManager.createMemoryStore(null);

    target.edit();

    target.update(featureType);

    target.finishEditing();

    repo.add(targetName, target);

    return target;

  }

  private class MemoryStoresRepository extends AbstractStoresRepository {

    private final Map<String,FeatureStore> repository;

    public MemoryStoresRepository(String name) {

      super(name);

      this.repository = new HashMap<>();

    }

    public void add(String name, FeatureStore store) {

      this.repository.put(name, store);

    }

    @Override

    protected DataStoreParameters getMyParameters(String name) {

      FeatureStore store = this.repository.get(name);

      return store.getParameters();

    }

    @Override

    protected boolean isEmptyMyRepository() {

      return this.repository.isEmpty();

    }

    @Override

    protected int getMySize() {

      return this.repository.size();

    }

    @Override

    protected UnmodifiableBasicSet<String> getMyKeySet() {

        Set<String> keyset = this.repository.keySet();

        if( keyset == null || keyset.isEmpty() ) {

            return UnmodifiableBasicSet.EMPTY_UNMODIFIABLEBASICSET;

        }

        return new UnmodifiableBasicSetAdapter<>(keyset);

    }

    @Override

    public DataStore getStore(String name) {

      FeatureStore store = this.repository.get(name);

      return store;

    }

    @Override

    public void add(String name, DataStoreParameters parameters) {

    }

    @Override

    public boolean contains(DataStoreParameters parameters) {

      return false;

    }

    @Override

    public boolean containsKey(String key) {

      return this.repository.containsKey(key);

    }

    @Override

    public Iterator<DataStoreParameters> iterator() {

      return Collections.EMPTY_LIST.iterator();

    }

    @Override

    public void remove(String name) {

      this.repository.remove(name);

    }

  }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.expressionevaluator.impl.function.dataaccess;

import java.util.Objects;

import org.apache.commons.lang3.Range;

import org.gvsig.expressionevaluator.Codes;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.impl.DALFunctions;

import static org.gvsig.expressionevaluator.impl.function.programming.FileFunction.NAME;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.feature.Feature;

/**

 *

 * @author jjdelcerro

 */

public class SetRowTagFunction extends AbstractFeatureFunction {

  public SetRowTagFunction() {

    super(DALFunctions.SYMBOLTABLE_NAME,

            DataManager.FUNCTION_SET_ROW_TAG,

            Range.is(1),

            "Assign a value associated with a label of the current row. This value is not persistent.",

            DataManager.FUNCTION_SET_ROW_TAG+"({{name}}, value)",

            null,

            "Object",

            false

    );

  }

  @Override

  public boolean allowConstantFolding() {

    return false;

  }

  @Override

  public boolean useArgumentsInsteadObjects() {

    return false;

  }

  @Override

  public Object call(Interpreter interpreter, Object[] args) throws Exception {

    Feature f = this.current_row(interpreter);

    if( f!=null ) {

      String name = getStr(args,0);

      f.setExtraValue(name, args[0]);

    }

    return args[0];

  }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.expressionevaluator.impl.function.dataaccess;

import java.util.Map;

import java.util.Objects;

import org.apache.commons.lang3.Range;

import org.gvsig.expressionevaluator.Code;

import org.gvsig.expressionevaluator.Codes;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.impl.DALFunctions;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.feature.Feature;

import org.gvsig.tools.util.GetItemByKey;

/**

 *

 * @author jjdelcerro

 */

public class RowTagFunction extends AbstractFeatureFunction {

  public RowTagFunction() {

    super(DALFunctions.SYMBOLTABLE_NAME,

            DataManager.FUNCTION_ROW_TAG,

            Range.between(1,2),

            "Retrieves a value associated with a tag from the current line.",

            DataManager.FUNCTION_ROW_TAG+"({{name}})",

            null,

            "Object",

            false

    );

  }

  @Override

  public boolean allowConstantFolding() {

    return false;

  }

  @Override

  public boolean useArgumentsInsteadObjects() {

    return true;

  }

  @Override

  public Object call(Interpreter interpreter, Object[] args) throws Exception {

    return null;

  }

  @Override

  public Object call(Interpreter interpreter, Codes args) throws Exception {

    Feature f = this.current_row(interpreter);

    if( f==null ) {

      return null;

    }

    String name = Objects.toString(getObject(interpreter, args, 0),null);

    if( name == null ) {

      throw new ExpressionRuntimeException("The first argument of '"+DataManager.FUNCTION_SET_ROW_TAG+"' can't be null.");    

    }

    if( args.size()==2 ) {

      if( !f.hasExtraValue(name) ) {

        Object map = Objects.toString(getObject(interpreter, args, 1),null);

        if( map instanceof Map) {

          for (Map.Entry<Object, Object> entry : ((Map<Object,Object>)map).entrySet()) {

            String key = Objects.toString(entry.getKey(),null);

            Object val = entry.getValue();

            if( key!=null ) {

              f.setExtraValue(key, val);

            }

          }

  //      } else if( map instanceof GetItemByKey && map instanceof GetKeys ) {

  //        for (String key : ((GetKeys<String>)map).getKeys() ) {

  //          Object val = ((GetItemByKey<String,Object>)map).get(key);

  //          f.setExtraValue(key, val);

  //        }

        }

      }

    }

   return f.getExtraValue(name);

  }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.expressionevaluator.impl.function.dataaccess;

import java.util.ArrayList;

import java.util.List;

import java.util.Objects;

import org.apache.commons.lang3.Range;

import org.apache.commons.lang3.StringUtils;

import org.apache.commons.lang3.tuple.ImmutablePair;

import org.apache.commons.lang3.tuple.Pair;

import org.gvsig.expressionevaluator.Code;

import org.gvsig.expressionevaluator.CodeBuilder;

import org.gvsig.expressionevaluator.Codes;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_GETATTR;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_TUPLE;

import org.gvsig.expressionevaluator.ExpressionRuntimeException;

import org.gvsig.expressionevaluator.ExpressionUtils;

import org.gvsig.expressionevaluator.Interpreter;

import org.gvsig.expressionevaluator.Optimizer;

import org.gvsig.expressionevaluator.SymbolTable;

import org.gvsig.expressionevaluator.impl.DALFunctions;

import org.gvsig.expressionevaluator.spi.AbstractFunction;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_EXISTS_TABLE;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.expressionevaluator.ExpressionEvaluator;

import static org.gvsig.fmap.dal.expressionevaluator.FeatureSymbolTable.SYMBOL_CURRENT_TABLE;

import org.gvsig.fmap.dal.expressionevaluator.TableAttributeHandler;

import org.gvsig.fmap.dal.feature.EditableFeature;

import org.gvsig.fmap.dal.feature.Feature;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureQueryOrder;

import org.gvsig.fmap.dal.feature.FeatureSet;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.impl.expressionevaluator.DefaultExpressionEvaluator;

import org.gvsig.tools.dispose.DisposeUtils;

import org.gvsig.tools.exception.BaseException;

/**

 *

 * @author jjdelcerro

 */

public class InsertIntoTableFunction 

        extends AbstractFunction 

        implements Optimizer.FunctionOptimizer

  {

  public InsertIntoTableFunction() {

    super(DALFunctions.SYMBOLTABLE_NAME,

            DataManager.FUNCTION_INSERT_INTO_TABLE,

            Range.is(7),

            "",

            DataManager.FUNCTION_INSERT_INTO_TABLE,

            null,

            "Number",

            false

    );

  }

  @Override

  public boolean allowConstantFolding() {

    return false;

  }

  @Override

  public boolean useArgumentsInsteadObjects() {

    return true;

  }

  @Override

  public Object call(Interpreter interpreter, Object[] args) throws Exception {

    throw new UnsupportedOperationException();

  }

  private static final int COLUMNS = 1;

  private static final int TABLE = 2;

  private static final int WHERE = 3;

  private static final int ORDER = 4;

  private static final int ORDER_MODE = 5;

  private static final int LIMIT = 6;

  private Code.Callable getTupleOrNull(Codes args, int argn) {

    Code code = args.get(argn);

    if( code.code()==Code.CONSTANT ) {

      if( ((Code.Constant)code).value()!=null ) {

        throw new ExpressionRuntimeException("Tupple or null expected in argument "+argn+ " of function '" + FUNCTION_SELECT + "'.");

      }

      return null;

    }

    if( code.code()!=Code.CALLABLE ) {

      throw new ExpressionRuntimeException("Tupple or null expected in argument "+argn+ " of function '" + FUNCTION_SELECT + "'.");

    }

    Code.Callable caller = (Code.Callable) code;

    if( !StringUtils.equalsIgnoreCase(FUNCTION_TUPLE, caller.name()) ) {

      throw new ExpressionRuntimeException("Tupple or null expected in argument "+argn+ " of function '" + FUNCTION_SELECT + "'.");

    }

    return caller;

  }

  @Override

  @SuppressWarnings("UseSpecificCatch")

  public Object call(Interpreter interpreter, Codes args) throws Exception {

    FeatureStore targetStore = null;

    FeatureStore sourceStore = null;

    try {

      String targetTableName = Objects.toString(getObject(interpreter, args, 0),null);

      if( targetTableName == null ) {

        throw new ExpressionRuntimeException("Target table name can't be null.");    

      }

      DataManager dataManager = DALLocator.getDataManager();  

      targetStore = (FeatureStore) dataManager.getStoresRepository().getStore(targetTableName);

      if( targetStore==null ) {

        throw new ExpressionRuntimeException("Can't locate target table '"+targetTableName+"'.");    

      }

      Code.Identifier storeName =  (Code.Identifier) args.get(TABLE);

      Code columns = getTupleOrNull(args, COLUMNS);

      Code where = args.get(WHERE);

      Number limit = (Number) getObject(interpreter, args, LIMIT);

      Code.Callable order = getTupleOrNull(args, ORDER);

      Code.Callable order_mode = getTupleOrNull(args, ORDER_MODE);

      FeatureQueryOrder queryOrder = null;

      if( order!=null || order_mode!=null ) {

        for( int n=0 ; n<order.parameters().size(); n++) {

          String member = (String) interpreter.run(order.parameters().get(n));

          Boolean mode = (Boolean) interpreter.run(order_mode.parameters().get(n));

          if( queryOrder == null ) {

            queryOrder = new FeatureQueryOrder();

          }

          queryOrder.add(member, mode);

        }

      }

      // FIXME: add columns to query.addAttributeName() 

      DataStore store = this.getStore(storeName.name());

      if (store == null ) {

        throw new ExpressionRuntimeException("Cant locate the store '" + storeName + "' in function '" + FUNCTION_SELECT + "'.");

      }

      if (!(store instanceof FeatureStore)) {

        throw new ExpressionRuntimeException("The store'" + storeName + "' is not valid for function '" + FUNCTION_SELECT + "', a FeatureStore is required.");

      }

      sourceStore = (FeatureStore) store;

      FeatureSet features;

      if (where == null && queryOrder == null && limit==null ) {

        features = sourceStore.getFeatureSet();

      } else {

        FeatureQuery query = sourceStore.createFeatureQuery();

        if (where != null) {

          removeOuterTablesReferences(interpreter, where);

          ExpressionEvaluator filter = new DefaultExpressionEvaluator(where.toString());

          filter.getSymbolTable().addSymbolTable(interpreter.getSymbolTable());

          query.addFilter(filter);

        }

        if (queryOrder != null) {

          query.getOrder().copyFrom(queryOrder);

        }

        if( limit!=null ) {

          query.setLimit(limit.longValue());

        }

        query.retrievesAllAttributes();

        features = sourceStore.getFeatureSet(query);

      }

      long count = 0;

      targetStore.edit(FeatureStore.MODE_APPEND);

      for (Feature feature : features) {

        EditableFeature f = targetStore.createNewFeature();

        f.copyFrom(feature);

        targetStore.insert(f);

        count++;

      }

      targetStore.finishEditing();

      return count;

    } catch (ExpressionRuntimeException ex) {

      throw ex;

    } catch (Exception ex) {

      if( targetStore!=null && targetStore.isAppending() ) {

        targetStore.cancelEditing();

      }

      DisposeUtils.disposeQuietly(targetStore);

      DisposeUtils.disposeQuietly(sourceStore);

      throw new ExpressionRuntimeException("Problems calling '" + FUNCTION_SELECT + "' function", ex);

    }

  }

  protected DataStore getStore(String storeName) {

    DataManager dataManager = DALLocator.getDataManager();

    DataStore store = dataManager.getStoresRepository().getStore(storeName);

    return store;

  }

  private void removeOuterTablesReferences(Interpreter interpreter, Code where) {

    try {

      SymbolTable symbolTable = interpreter.getSymbolTable();

      TableAttributeHandler table = (TableAttributeHandler) symbolTable.value(SYMBOL_CURRENT_TABLE);

      List<Pair<Code,Code>>replaces = new ArrayList<>();

      CodeBuilder codeBuilder = ExpressionUtils.createCodeBuilder();

      where.accept((Object o) -> {

        Code code = (Code) o;

        if( code!=null && code.code() == Code.CALLABLE ) {

          Code.Callable caller = (Code.Callable) code;

          if( StringUtils.equalsIgnoreCase(caller.name(),FUNCTION_GETATTR) ) {

            Codes args = caller.parameters();

            Code arg0 = args.get(0);

            Code arg1 = args.get(1);

            if( arg0 instanceof Code.Identifier && arg1 instanceof Code.Identifier ) {

              Object tt = symbolTable.value(((Code.Identifier)arg0).name());

              if( tt instanceof TableAttributeHandler && 

                  StringUtils.equalsIgnoreCase(((TableAttributeHandler)tt).getName(), table.getName()) ) {

                String columnName = Objects.toString(((Code.Identifier)arg1).name(), null);

                if( columnName!=null ) {

                  Object value = table.get(columnName);

                  replaces.add(

                          new ImmutablePair<>(

                                  caller,

                                  codeBuilder.constant(value)

                          )

                  );

                }

              }

            }

          }

        }

      });

      for (Pair<Code, Code> replace : replaces) {

        if( replace!=null ) {

          where.replace(replace.getLeft(), replace.getRight());

        }

      }

    } catch (BaseException ex) {

      throw new ExpressionRuntimeException("Can't remove references to outer tables.", ex);

    }

  }

  @Override

  public Code optimize(Optimizer optimizer, Code.Callable caller) {

    return caller; // Don't optimize SELECT

  }

}

      CodeBuilder codeBuilder = context.getCodeBuilder();

      BaseCodes args = (BaseCodes) codeBuilder.args();

      return build(context,args);

    }

    public Codes build(StatementContext context, BaseCodes args) {

  private static class InsertIntoArgsBuilder 

          extends SelectArgsBuilder

          implements ArgsBuilder 

  {

    public InsertIntoArgsBuilder() {

    }

    @Override

    public String toString() {

      return "insert_into_args()";

    }

    @Override

    public Codes build(StatementContext context) {

      context.trace(this.toString() + ".build");

      CodeBuilder codeBuilder = context.getCodeBuilder();

      BaseCodes args = (BaseCodes) codeBuilder.args();

      Code table = context.getCode("TARGETTABLE");

      args.add(codeBuilder.identifier((String) ((Code.Constant) table).value()));

      return build(context,args);

    }

  }

      stmt = theGrammar.createStatement("CREATE_IN_MEMORY_TABLE");

      stmt.addRule(stmt.require_any_token("CREATE"));

      stmt.addRule(stmt.require_any_token("IN"));

      stmt.addRule(stmt.require_any_token("MEMORY"));

      stmt.addRule(stmt.require_any_token("TABLE"));

      stmt.addRule(stmt.require_identifier().capture_as("NEWTABLE"));

      stmt.addRule(stmt.require_any_token("FROM"));

      stmt.addRule(stmt.require_identifier().capture_as("SOURCETABLE"));

      stmt.code(

              FUNCTION_FOREING_VALUE,

              stmt.args_names("NEWTABLE","SOURCETABLE")

      );

      theGrammar.addStatement(stmt);

      stmt = theGrammar.createStatement("INSERT_INTO");

      stmt.addRule(stmt.require_any_token("INSERT"));

      stmt.addRule(stmt.require_any_token("INTO"));

      stmt.addRule(stmt.require_identifier().capture_as("TARGETTABLE"));

      stmt.addRule(stmt.require_any_token("SELECT"));

      stmt.addRule(stmt.optional_any_token("*")

              .addRuleOnTrue(stmt.set_expression("COLUMNS", codeBuilder.tuple()))

              .addRuleOnFalse(stmt.require_identifiers(",").capture_as("COLUMNS"))

      );

      stmt.addRule(stmt.require_any_token("FROM"));

      stmt.addRule(stmt.require_identifier().capture_as("TABLE"));

      stmt.addRule(stmt.optional_any_token("WHERE")

              .addRuleOnTrue(stmt.require_expression().capture_as("WHERE"))

      );

      stmt.addRule(stmt.optional_any_token("ORDER")

              .addRuleOnTrue(stmt.require_any_token("BY"))

              .addRuleOnTrue(stmt.repeat()

                      .addRule(stmt.require_expression().capture_as("ORDER#"))

                      .addRule(stmt.switch_token()

                              .addCase("ASC", stmt.set_expression("ORDER_MODE#", true))

                              .addCase("DESC", stmt.set_expression("ORDER_MODE#", false))

                              .addDefault(stmt.set_expression("ORDER_MODE#", true))

                      )

                      .addRule(stmt.optional_any_token(",")

                              .addRuleOnFalse(stmt.break_loop())

                      )

              )

      );

      stmt.addRule(stmt.optional_any_token("LIMIT")

              .addRuleOnTrue(stmt.require_expression().capture_as("LIMIT"))

      );

      stmt.addRule(stmt.optional_any_token(";"));

      stmt.code(

              FUNCTION_SELECT,

              new InsertIntoArgsBuilder()

      );

      theGrammar.addStatement(stmt);

import org.gvsig.expressionevaluator.impl.function.dataaccess.CreateInMemoryTableFunction;

import org.gvsig.expressionevaluator.impl.function.dataaccess.InsertIntoTableFunction;

import org.gvsig.expressionevaluator.impl.function.dataaccess.RowTagFunction;

import org.gvsig.expressionevaluator.impl.function.dataaccess.SetRowTagFunction;

        this.addFunction(new CreateInMemoryTableFunction());

        this.addFunction(new InsertIntoTableFunction());

        this.addFunction(new RowTagFunction());

        this.addFunction(new SetRowTagFunction());

import java.util.HashMap;

  private Object[] extraValuesData;

  private Map<String,Object> extraValues; // not persistent

    @Override

    public void setExtraValue(String name, Object value) {

      if( this.extraValues==null ) {

        this.extraValues = new HashMap<>();

      }

      this.extraValues.put(name, value);

    }

    @Override

        if( this.extraValues!=null ) {

          if( this.extraValues.containsKey(name) ) {

            return this.extraValues.get(name);

          }

        }

        if( this.extraValues!=null ) {

          if( this.extraValues.containsKey(name) ) {

            return true;

          }

        }

    public static final String FUNCTION_EXISTS_TABLE = "EXISTS_TABLE";

    public static final String FUNCTION_ROW_TAG = "ROW_TAG";

    public static final String FUNCTION_SET_ROW_TAG = "SET_ROW_TAG";

    public static final String FUNCTION_CREATE_IN_MEMORY_TABLE = "CREATE_IN_MEMORY_TABLE";

    public static final String FUNCTION_INSERT_INTO_TABLE = "INSERT_INTO_TABLE";

  public void setExtraValue(String name, Object value);