Application: gvSIG desktop

package org.gvsig.fmap.dal.store.jdbc2;

import java.util.List;

import junit.framework.TestCase;

import static junit.framework.TestCase.assertEquals;

import org.gvsig.expressionevaluator.ExpressionUtils;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

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

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

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.ResultSetForSetProviderOperation;

import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public abstract class AbstractTestJsonValue extends TestCase {

    protected static final Logger LOGGER = LoggerFactory.getLogger(AbstractTestJsonValue.class);

    protected AbstractTestUtils utils;

    public AbstractTestJsonValue(String testName) {

        super(testName);

    }

    @Override

    protected void setUp() throws Exception {

        super.setUp();

        new DefaultLibrariesInitializer().fullInitialize();

    }

    @Override

    protected void tearDown() throws Exception {

        super.tearDown();

    }

    public AbstractTestUtils utils() {

        if (this.utils == null) {

            this.utils = this.createUtils();

        }

        return this.utils;

    }

    protected abstract AbstractTestUtils createUtils();

    public void testJsonValue() throws Exception {

        try {

            if (!utils().isTheDatabaseAvailable()) {

                return;

            }

            JDBCHelper helper = utils().createJDBCHelper();

            JDBCSQLBuilderBase sqlbuilder = helper.createSQLBuilder();

            OperationsFactory operations = helper.getOperations();

            List<String> expectedSQLs = utils().getExpectedSQLs("testJsonValue.sql"); //getSQLs("resultSetForSetProvider.sql");

            FeatureStore sourceStore = utils().openSourceStore1();

            OperationsFactory.TableReference table = operations.createTableReference(

                    "dbtest",

                    sqlbuilder.default_schema(),

                    "test",

                    null

            );

            FeatureType featureType = sourceStore.getDefaultFeatureType();

            FeatureQuery query = sourceStore.createFeatureQuery("JSON_VALUE(String,'$.acc_cit')=1");

            EditableFeatureAttributeDescriptor extraColumn1

                    = query.getExtraColumn().add("JsonValue1", DataTypes.INTEGER);

            extraColumn1.setFeatureAttributeEmulator(

                    new DefaultFeatureAttributeEmulatorExpression(

                            featureType,

                            ExpressionUtils.createExpression("JSON_VALUE(String,'$.acc_cit')")));

            ResultSetForSetProviderOperation resultSetForSetProvider = operations.createResultSetForSetProvider(

                    table,

                    null,

                    null,

                    query,

                    featureType,

                    featureType,

                    0,

                    0,

                    0

            );

            String sql = resultSetForSetProvider.getSQL();

            System.out.println("###### testJsonValue(0)");

            System.out.println("###### SQL:" + sql + ";");

            System.out.println("###### EXP:" + expectedSQLs.get(0) + ";");

            assertEquals("ResultSetForSetProvider SQL", expectedSQLs.get(0), sql);

        } catch (Throwable th) {

            LOGGER.warn("", th);

            throw th;

        }

    }

}