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.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.DALLocator;

import org.gvsig.fmap.dal.DataManager;

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

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.expressionevaluator.ExpressionEvaluator;

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

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

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

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

import org.gvsig.tools.dispose.DisposeUtils;

/**

 *

 * @author jjdelcerro

 */

@SuppressWarnings("UseSpecificCatch")

public class SelectCountFunction extends AbstractSelectFunction {

    public SelectCountFunction() {

        super(DALFunctions.GROUP_DATA_ACCESS,

                FUNCTION_SELECT_COUNT,

                Range.between(1, 2),

                "Returns the number of features of the table by applying the filter indicated.\n"

                + "The syntax is:\n\n"

                + "SELECT COUNT(*) FROM table WHERE boolean_expression;\n\n"

                + "Indicate a filter expression with WHERE is optional.\n"

                + "The SELECT statement must always end with a semicolon.",

                "SELECT COUNT(*) FROM {{table}} WHERE filter ;",

                new String[]{

                    "table - Name of the table",

                    "filter - boolean expression with the filter to apply",},

                "Long",

                false

        );

    }

    @Override

    public boolean isHidden() {

        return 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 TABLE = 0;

    private static final int WHERE = 1;

    @Override

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

        String storeName = this.getTableName(args, TABLE);

        Code where = this.getWhereCode(args, WHERE);

        FeatureStore featureStore = null;

        FeatureSet set = null;

        try {

            featureStore = this.getFeatureStore(storeName);

            if (featureStore == null) {

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

            }

            if (where == null) {

                set = featureStore.getFeatureSet();

            } else {

                FeatureQuery query = featureStore.createFeatureQuery();

                Code where2 = removeOuterTablesReferences(interpreter, where);

                ExpressionEvaluator filter = new DefaultFeatureExpressionEvaluator(where2.toString());

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

                query.addFilter(filter);

                query.retrievesAllAttributes();

                set = featureStore.getFeatureSet(query);

            }

            return set.getSize();

        } catch (ExpressionRuntimeException ex) {

            throw ex;

        } catch (Exception ex) {

            throw new ExpressionRuntimeException("Problems calling '" + this.name() + "' function", ex);

        } finally {

            DisposeUtils.disposeQuietly(set);

            DisposeUtils.disposeQuietly(featureStore);

        }

    }

}