Application: gvSIG desktop

/**

 * 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 static org.gvsig.fmap.dal.DataManager.FUNCTION_EXECUTESQL;

import org.gvsig.fmap.dal.DataServerExplorer;

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

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

import org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer;

/**

 *

 * @author jjdelcerro

 */

public class ExecuteSQLFunction extends AbstractFeatureFunction {

  public ExecuteSQLFunction() {

    super(

            DALFunctions.GROUP_DATA_ACCESS, 

            FUNCTION_EXECUTESQL, 

            Range.is(1), 

            "Execute para parameter as a SQL statement", 

            FUNCTION_EXECUTESQL+"( {{sql}})", 

            null, 

            "Object",

            false

    );

  }

  @Override

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

      String sql = this.getStr(args, 0);

      FeatureStore store = this.current_store(interpreter);

      if( store == null ) {

          return null;

      }

      DataServerExplorer explorer = store.getExplorer();

      if( !(explorer instanceof JDBCServerExplorer) ) {

          return null;

      }

      Object x = ((JDBCServerExplorer)explorer).execute(sql);

      return x;

  }

}