Application: gvSIG desktop

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

import java.io.File;

import java.sql.Timestamp;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.LocalTime;

import java.time.ZoneId;

import java.util.Date;

import java.util.List;

import junit.framework.TestCase;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionUtils;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorer;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.DataTypeUtils;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

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

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

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

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

import org.gvsig.fmap.dal.serverexplorer.filesystem.FilesystemStoreParameters;

import org.gvsig.fmap.dal.store.dbf.utils.FieldFormatter;

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

public class TestExpressionField extends TestCase {

    public TestExpressionField(String testName) {

        super(testName);

    }

    @Override

    protected void setUp() throws Exception {

        super.setUp();

        new DefaultLibrariesInitializer().fullInitialize();

    }

    @Override

    protected void tearDown() throws Exception {

        super.tearDown();

    }

    // TODO add test methods here. The name must begin with 'test'. For example:

    // public void testHello() {}

    protected String getProviderName() {

        return DataStore.DBASE_PROVIDER_NAME;

    }

    protected String getTargetFilename() {

        return "testExpressionField1.dbf";

    }

    protected FeatureStore openTargetStore1() throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        File f = TestUtils.getResource(getTargetFilename());

        FeatureStore store = (FeatureStore) dataManager.openStore(

                getProviderName(), 

                "DbfFile",f

        );

        return store;

    }

    protected void createFrom(FeatureStore sourceStore) throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        DataServerExplorer explorer = dataManager.openServerExplorer(

                DataServerExplorer.FILESYSTEM_SERVER_EXPLORER_NAME, 

                "root", TestUtils.getTargetFolder()

        );

        NewFeatureStoreParameters params = (NewFeatureStoreParameters) explorer.getAddParameters(

                getProviderName()

        );

        ((FilesystemStoreParameters)params).setFile(TestUtils.getResource(getTargetFilename()));

        EditableFeatureType ft = params.getDefaultFeatureType();

        ft.addAll(sourceStore.getDefaultFeatureType());

        explorer.add(getProviderName(), params, true);

    }

    protected void copyFrom(FeatureStore sourceStore, int mode) throws Exception {

        FeatureStore targetStore = openTargetStore1();

        targetStore.edit(mode);

        try {

            for (Feature sourceFeature : sourceStore.getFeatureSet()) {

                EditableFeature targetFeature = targetStore.createNewFeature(sourceFeature);

                targetStore.insert(targetFeature);

            }

        } finally {

            targetStore.finishEditing();

        }

    }

    public void testTimestamp() throws Exception {

      DataManager dataManager = DALLocator.getDataManager();

      FeatureStore sourceStore = TestUtils.openSourceStore1();

      createFrom(sourceStore);        

      copyFrom(sourceStore, FeatureStore.MODE_APPEND);

      FeatureStore targetStore = openTargetStore1();

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

      FeatureAttributeEmulatorExpression emulator = dataManager.createFeatureAttributeEmulatorExpression(

              featureType, 

              ExpressionUtils.createExpression("TO_TIMESTAMP(TOINTEGER(RANDOM()*(20-10)+10)||'/1/2020','dd/MM/yyyy')")

      );

      targetStore.edit();

      featureType.add("cct", DataTypes.TIMESTAMP, emulator);

      targetStore.update(featureType);

      targetStore.finishEditing();

      targetStore.dispose();

      targetStore = openTargetStore1();

      for (Feature feature : targetStore.getFeatureSet()) {

        Date cct = feature.getTimestamp("cct");

        assertEquals(true, cct.getDate()>=10 && cct.getDate()<=20);

        assertEquals(0, cct.getMonth());

        // The java Date does not go well with 2020 and does not return 

        // a good year, so we use a LocalDateTime to get the year.

        assertEquals(2020, LocalDateTime.ofInstant(cct.toInstant(), ZoneId.systemDefault()).getYear() );

      }

    }

}