gvSIG projects pool

    public VCSGisServerHandler createHistoryHandler();

            "Description":null,

package org.gvsig.vcsgis.lib.impl;

import java.io.File;

import java.sql.Timestamp;

import java.util.List;

import junit.framework.TestCase;

import static junit.framework.TestCase.assertEquals;

import org.apache.commons.io.FileUtils;

import org.codehaus.plexus.util.StringUtils;

import org.gvsig.expressionevaluator.Expression;

import org.gvsig.fmap.dal.exception.DataException;

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

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

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

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

import org.gvsig.tools.dispose.DisposeUtils;

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

import org.gvsig.vcsgis.lib.SequentialCodeGenerator;

import org.gvsig.vcsgis.lib.VCSGisEntity;

import org.gvsig.vcsgis.lib.VCSGisLocator;

import org.gvsig.vcsgis.lib.VCSGisManager;

import static org.gvsig.vcsgis.lib.VCSGisManager.ERR_NO_ERROR;

import org.gvsig.vcsgis.lib.repository.VCSGisRepository;

import org.gvsig.vcsgis.lib.repository.VCSGisRepositoryChange;

import org.gvsig.vcsgis.lib.workspace.VCSGisWorkspace;

import org.gvsig.vcsgis.lib.workspace.VCSGisWorkspaceChanges;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class Test20ExportToEffectiveDate extends TestCase {

    private static final Logger LOGGER = LoggerFactory.getLogger(Test20ExportToEffectiveDate.class);

    public Test20ExportToEffectiveDate(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() {}

    private void insert(FeatureStore store, int id, String text) throws DataException{

        EditableFeature ef = store.createNewFeature();

        ef.set("id",id);

        ef.set("text",text);

        store.insert(ef);

    }

    private void update(FeatureStore store, int id, String text) throws DataException{

        Feature f = store.findFirst("id="+id);

        EditableFeature ef = f.getEditable();

        ef.set("text", text);

        store.update(ef);

    }

    private void delete(FeatureStore store, int id, String text) throws DataException{

        Feature f = store.findFirst("id="+id);

        store.delete(f);

    }

    private void check(List<Feature> features, int index, int id, String text){

        assertEquals(id    , features.get(index).getInt("id"));

        assertEquals(text, features.get(index).getString("text"));

    }

    private void check(FeatureStore store2, String relatedFeatureCode, int id, String text) throws Exception {

        Feature f = store2.findFirst("VCSGISCODE = '"+relatedFeatureCode+"'");

        assertEquals(id, f.getInt("id"));

        assertEquals(text, f.getString("text"));

    }

    public void testExportToEffectiveDateConsecutive() throws Exception {

        VCSGisManager manager = VCSGisLocator.getVCSGisManager();

        manager.setCodeGenerator(new SequentialCodeGenerator());

        JDBCServerExplorer server = TestUtils.openServerExplorer("srv-update");

        File ws1file = TestUtils.getFile(FileUtils.getFile("test-dbs","ws1-update")); 

        File ws2file = TestUtils.getFile(FileUtils.getFile("test-dbs","ws2-update")); 

        int r;

        Feature f;

        EditableFeature ef;

        List<Feature> features;

        FeatureStore store1;

        FeatureStore store2;

        // ------------------------------------------------------------

        // Inicializamos el repositorio y lo abrimos

        r = manager.initRepository(server.getParameters(), null);

        assertEquals("init_server status", ERR_NO_ERROR, r);

        VCSGisRepository repo = manager.openRepository(server.getParameters());

        TestUtils.h2sql_repository(repo);

        // ------------------------------------------------------------

        // Creamos workspace1 y lo abrimos.

        r = manager.initWorkspace(ws1file, repo, "Test update1",null);

        assertEquals("init_ws1 status", ERR_NO_ERROR, r);

        VCSGisWorkspace ws1 = manager.openWorkspace(ws1file);

        TestUtils.h2sql_workspace(ws1);

        // ------------------------------------------------------------

        // Adicionamos al workspace1 la tabla "test" y la commitamos.

        //REV 0

        FeatureStore sourceTest = TestUtils.openSourceStore2();

        r = ws1.add("test", sourceTest, "text");

        DisposeUtils.disposeQuietly(sourceTest);

        assertEquals("ws1.add status", ERR_NO_ERROR, r);

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 4, "DDD");

        insert(store1, 5, "EEE");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-01-01 00:00:00.000"), "2021-01-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 1

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 6, "FFF");

        insert(store1, 7, "GGG");

        insert(store1, 8, "HHH");

        insert(store1, 9, "III");

        insert(store1, 10, "JJJ");

        delete(store1, 5, "EEE");

        update(store1, 2, "BB2");

        update(store1, 4, "DD2");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-02-01 00:00:00.000"), "2021-02-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 2

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 11, "KKK");

        insert(store1, 12, "LLL");

        insert(store1, 13, "MMM");

        delete(store1, 4, "DD2");

        delete(store1, 7, "GGG");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-03-01 00:00:00.000"), "2021-03-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 3

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 14, "NNN");

        insert(store1, 15, "OOO");

        insert(store1, 16, "PPP");

        insert(store1, 17, "QQQ");

        delete(store1, 3, "CCC");

        delete(store1, 10, "JJJ");

        update(store1, 13, "MM2");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-04-01 00:00:00.000"), "2021-04-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 4

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 18, "RRR");

        insert(store1, 19, "SSS");

        insert(store1, 20, "TTT");

        insert(store1, 21, "UUU");

        delete(store1, 9, "III");

        update(store1, 17, "QQ2");

        delete(store1, 16, "PPP");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-05-01 00:00:00.000"), "2021-05-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 5

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 22, "VVV");

        insert(store1, 23, "WWW");

        insert(store1, 24, "XXX");

        insert(store1, 25, "YYY");

        insert(store1, 26, "ZZZ");

        delete(store1, 13, "MM2");

        delete(store1, 19, "SSS");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-06-01 00:00:00.000"), "2021-06-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //Export enero

        r = ws1.export("test", "exp_enero", null, Timestamp.valueOf("2021-01-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_enero");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BBB");

        check(features, 2, 3, "CCC");

        check(features, 3, 4, "DDD");

        check(features, 4, 5, "EEE");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export febrero

        r = ws1.export("test", "exp_febrero", null, Timestamp.valueOf("2021-02-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_febrero");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 3, "CCC");

        check(features, 3, 4, "DD2");

        check(features, 4, 6, "FFF");

        check(features, 5, 7, "GGG");

        check(features, 6, 8, "HHH");

        check(features, 7, 9, "III");

        check(features, 8, 10, "JJJ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export marzo

        r = ws1.export("test", "exp_marzo", null, Timestamp.valueOf("2021-03-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_marzo");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 3, "CCC");

        check(features, 3, 6, "FFF");

        check(features, 4, 8, "HHH");

        check(features, 5, 9, "III");

        check(features, 6, 10, "JJJ");

        check(features, 7, 11, "KKK");

        check(features, 8, 12, "LLL");

        check(features, 9, 13, "MMM");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export abril

        r = ws1.export("test", "exp_abril", null, Timestamp.valueOf("2021-04-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_abril");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 9, "III");

        check(features, 5, 11, "KKK");

        check(features, 6, 12, "LLL");

        check(features, 7, 13, "MM2");

        check(features, 8, 14, "NNN");

        check(features, 9, 15, "OOO");

        check(features, 10, 16, "PPP");

        check(features, 11, 17, "QQQ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export mayo

        r = ws1.export("test", "exp_mayo", null, Timestamp.valueOf("2021-05-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_mayo");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 11, "KKK");

        check(features, 5, 12, "LLL");

        check(features, 6, 13, "MM2");

        check(features, 7, 14, "NNN");

        check(features, 8, 15, "OOO");

        check(features, 9, 17, "QQ2");

        check(features, 10, 18, "RRR");

        check(features, 11, 19, "SSS");

        check(features, 12, 20, "TTT");

        check(features, 13, 21, "UUU");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export junio

        r = ws1.export("test", "exp_junio", null, Timestamp.valueOf("2021-06-15 00:00:00.000"), null);

        assertEquals("ws1.export-2 status", 0, r);

        store2 = ws1.openFeatureStore("exp_junio");

        features = store2.getFeatures((Expression)null, "id", true);

        int n=0;

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 11, "KKK");

        check(features, 5, 12, "LLL");

        check(features, 6, 14, "NNN");

        check(features, 7, 15, "OOO");

        check(features, 8, 17, "QQ2");

        check(features, 9, 18, "RRR");

        check(features, 10, 20, "TTT");

        check(features, 11, 21, "UUU");

        check(features, 12, 22, "VVV");

        check(features, 13, 23, "WWW");

        check(features, 14, 24, "XXX");

        check(features, 15, 25, "YYY");

        check(features, 16, 26, "ZZZ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

    }

    public void testExportToEffectiveDateAlteredOrder() throws Exception {

        VCSGisManager manager = VCSGisLocator.getVCSGisManager();

        manager.setCodeGenerator(new SequentialCodeGenerator());

        JDBCServerExplorer server = TestUtils.openServerExplorer("srv-update");

        File ws1file = TestUtils.getFile(FileUtils.getFile("test-dbs","ws1-update")); 

        File ws2file = TestUtils.getFile(FileUtils.getFile("test-dbs","ws2-update")); 

        int r;

        Feature f;

        EditableFeature ef;

        List<Feature> features;

        FeatureStore store1;

        FeatureStore store2;

        // ------------------------------------------------------------

        // Inicializamos el repositorio y lo abrimos

        r = manager.initRepository(server.getParameters(), null);

        assertEquals("init_server status", ERR_NO_ERROR, r);

        VCSGisRepository repo = manager.openRepository(server.getParameters());

        TestUtils.h2sql_repository(repo);

        // ------------------------------------------------------------

        // Creamos workspace1 y lo abrimos.

        r = manager.initWorkspace(ws1file, repo, "Test update1",null);

        assertEquals("init_ws1 status", ERR_NO_ERROR, r);

        VCSGisWorkspace ws1 = manager.openWorkspace(ws1file);

        TestUtils.h2sql_workspace(ws1);

        // ------------------------------------------------------------

        // Adicionamos al workspace1 la tabla "test" y la commitamos.

        //REV 0

        FeatureStore sourceTest = TestUtils.openSourceStore2();

        r = ws1.add("test", sourceTest, "text");

        DisposeUtils.disposeQuietly(sourceTest);

        assertEquals("ws1.add status", ERR_NO_ERROR, r);

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 4, "DDD");

        insert(store1, 5, "EEE");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-01-01 00:00:00.000"), "2021-01-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 1

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 6, "FFF");

        insert(store1, 7, "GGG");

        insert(store1, 8, "HHH");

        insert(store1, 9, "III");

        insert(store1, 10, "JJJ");

        delete(store1, 5, "EEE");

        update(store1, 2, "BB2");

        update(store1, 4, "DD2");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-02-01 00:00:00.000"), "2021-02-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 2

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 11, "KKK");

        insert(store1, 12, "LLL");

        insert(store1, 13, "MMM");

        delete(store1, 4, "DD2");

        delete(store1, 7, "GGG");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-04-01 00:00:00.000"), "2021-04-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 3

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 14, "NNN");

        insert(store1, 15, "OOO");

        insert(store1, 16, "PPP");

        insert(store1, 17, "QQQ");

        delete(store1, 3, "CCC");

        delete(store1, 10, "JJJ");

        update(store1, 13, "MM2");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-03-01 00:00:00.000"), "2021-03-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 4

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 18, "RRR");

        insert(store1, 19, "SSS");

        insert(store1, 20, "TTT");

        insert(store1, 21, "UUU");

        delete(store1, 9, "III");

        update(store1, 17, "QQ2");

        delete(store1, 16, "PPP");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-06-01 00:00:00.000"), "2021-06-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //REV 5

        store1 = ws1.getFeatureStore("test");

        store1.edit();

        insert(store1, 22, "VVV");

        insert(store1, 23, "WWW");

        insert(store1, 24, "XXX");

        insert(store1, 25, "YYY");

        insert(store1, 26, "ZZZ");

        delete(store1, 13, "MM2");

        delete(store1, 19, "SSS");

        store1.finishEditing();

        DisposeUtils.disposeQuietly(store1);

        r = ws1.commit(null, Timestamp.valueOf("2021-05-01 00:00:00.000"), "2021-05-01 00:00:00.000", null);

        assertEquals("ws1.commit-1 status", ERR_NO_ERROR, r);

        //Export enero

        r = ws1.export("test", "exp_enero", null, Timestamp.valueOf("2021-01-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_enero");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BBB");

        check(features, 2, 3, "CCC");

        check(features, 3, 4, "DDD");

        check(features, 4, 5, "EEE");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export febrero

        r = ws1.export("test", "exp_febrero", null, Timestamp.valueOf("2021-02-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_febrero");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 3, "CCC");

        check(features, 3, 4, "DD2");

        check(features, 4, 6, "FFF");

        check(features, 5, 7, "GGG");

        check(features, 6, 8, "HHH");

        check(features, 7, 9, "III");

        check(features, 8, 10, "JJJ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export marzo

        r = ws1.export("test", "exp_marzo", null, Timestamp.valueOf("2021-03-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_marzo");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 4, "DD2");

        check(features, 3, 6, "FFF");

        check(features, 4, 7, "GGG");

        check(features, 5, 8, "HHH");

        check(features, 6, 9, "III");

        check(features, 7, 13, "MM2");

        check(features, 8, 14, "NNN");

        check(features, 9, 15, "OOO");

        check(features, 10, 16, "PPP");

        check(features, 11, 17, "QQQ");

//        update(store1, 13, "MM2");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export abril

        r = ws1.export("test", "exp_abril", null, Timestamp.valueOf("2021-04-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_abril");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 9, "III");

        check(features, 5, 11, "KKK");

        check(features, 6, 12, "LLL");

        check(features, 7, 13, "MM2");

        check(features, 8, 14, "NNN");

        check(features, 9, 15, "OOO");

        check(features, 10, 16, "PPP");

        check(features, 11, 17, "QQQ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export mayo

        r = ws1.export("test", "exp_mayo", null, Timestamp.valueOf("2021-05-15 00:00:00.000"), null);

        assertEquals("ws1.export-1 status", 0, r);

        store2 = ws1.openFeatureStore("exp_mayo");

        features = store2.getFeatures((Expression)null, "id", true);

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 9, "III");

        check(features, 5, 11, "KKK");

        check(features, 6, 12, "LLL");

        check(features, 7, 14, "NNN");

        check(features, 8, 15, "OOO");

        check(features, 9, 16, "PPP");

        check(features, 10, 17, "QQQ");

        check(features, 11, 22, "VVV");

        check(features, 12, 23, "WWW");

        check(features, 13, 24, "XXX");

        check(features, 14, 25, "YYY");

        check(features, 15, 26, "ZZZ");

//        delete(store1, 13, "MM2");

//        delete(store1, 19, "SSS");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

        //Export junio

        r = ws1.export("test", "exp_junio", null, Timestamp.valueOf("2021-06-15 00:00:00.000"), null);

        assertEquals("ws1.export-2 status", 0, r);

        store2 = ws1.openFeatureStore("exp_junio");

        features = store2.getFeatures((Expression)null, "id", true);

        int n=0;

        check(features, 0, 1, "AAA");

        check(features, 1, 2, "BB2");

        check(features, 2, 6, "FFF");

        check(features, 3, 8, "HHH");

        check(features, 4, 11, "KKK");

        check(features, 5, 12, "LLL");

        check(features, 6, 14, "NNN");

        check(features, 7, 15, "OOO");

        check(features, 8, 17, "QQ2");

        check(features, 9, 18, "RRR");

        check(features, 10, 20, "TTT");

        check(features, 11, 21, "UUU");

        check(features, 12, 22, "VVV");

        check(features, 13, 23, "WWW");

        check(features, 14, 24, "XXX");

        check(features, 15, 25, "YYY");

        check(features, 16, 26, "ZZZ");

        DisposeUtils.disposeQuietly(features);

        DisposeUtils.disposeQuietly(store2);

    }

}

select 

  "VCSGISREPO_DATA1"."COD_DATA", 

  "VCSGISREPO_DATA1"."COD_REVISION", 

  "VCSGISREPO_DATA1"."COD_ENTITY", 

  case when "VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and max("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 then 2 else "VCSGISREPO_DATA1"."DAT_OPERATION" end as "DAT_OPERATION",

  "VCSGISREPO_DATA1"."DAT_REVNUMBER", 

  "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE", 

  "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", 

  "VCSGISREPO_DATA1"."DAT_GEOM", 

  "VCSGISREPO_DATA1"."DAT_DATA", 

  (case when min("VCSGISREPO_DATA2"."DAT_OPERATION") = 0 then 1 else 0 end) as "DEL",

  (case when max("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 or min("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 then 1 else 0 end) as "UPD",

  (case when max("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 then 1 else 0 end) as "INS",

  max("VCSGISREPO_DATA2"."DAT_EFECTIVEDATE") as MAXEFFECTIVEDATE,

  max("VCSGISREPO_DATA2"."DAT_REVNUMBER") as MAXREV

from "VCSGISREPO_DATA" as "VCSGISREPO_DATA1"

  left join "VCSGISREPO_DATA" as "VCSGISREPO_DATA2" on

    "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE" = "VCSGISREPO_DATA2"."DAT_FEATURERELATEDCODE"

    and "VCSGISREPO_DATA2"."DAT_EFECTIVEDATE" <= to_timestamp('%2$s', 'YYYY-MM-DD HH24:MI:SS') 

    and "VCSGISREPO_DATA2"."DAT_REVNUMBER" != "VCSGISREPO_DATA1"."DAT_REVNUMBER"

where 

  "VCSGISREPO_DATA1"."COD_ENTITY" = '%1$s' 

  and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= to_timestamp('%2$s', 'YYYY-MM-DD HH24:MI:SS') 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE", "VCSGISREPO_DATA1"."DAT_REVNUMBER", "VCSGISREPO_DATA1"."DAT_OPERATION", "VCSGISREPO_DATA1"."DAT_DATA"

having not (

  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and ( "INS" = 1 ))

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and "DEL" = 1)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and ("DEL" = 1 or "UPD" = 1))

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and "DEL" = 0 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and "UPD" = 1 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and "INS" = 1 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)  )

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@begin dateFormat

yyyy-MM-dd HH:mm:ss

@end dateFormat

select * from "VCSGISREPO_DATA" where "VCSGISREPO_DATA"."COD_DATA" in (

	select 

	  MIN("VCSGISREPO_DATA1"."COD_DATA")

	from "VCSGISREPO_DATA" "VCSGISREPO_DATA1"

	  left join "VCSGISREPO_DATA" "VCSGISREPO_DATA2" on

	    "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE" = "VCSGISREPO_DATA2"."DAT_FEATURERELATEDCODE"

	    and "VCSGISREPO_DATA2"."DAT_EFECTIVEDATE" <= to_date('%2$s', 'YYYY-MM-DD HH24:MI:SS') 

	where 

	  "VCSGISREPO_DATA1"."COD_ENTITY" = '%1$s'

	  and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= to_date('%2$s', 'YYYY-MM-DD HH24:MI:SS')   

	group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE", "VCSGISREPO_DATA1"."DAT_REVNUMBER", "VCSGISREPO_DATA1"."DAT_OPERATION"

	having not (

	  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and MAX("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 )

	  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and MIN("VCSGISREPO_DATA2"."DAT_OPERATION") = 0 )

	  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and (MIN("VCSGISREPO_DATA2"."DAT_OPERATION") = 0  or max("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 or min("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 ))

	  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and MIN("VCSGISREPO_DATA2"."DAT_OPERATION") <> 0  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" < max("VCSGISREPO_DATA2"."DAT_REVNUMBER"))

	  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and (max("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 or min("VCSGISREPO_DATA2"."DAT_OPERATION") = 1) and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= max("VCSGISREPO_DATA2"."DAT_EFECTIVEDATE") and "VCSGISREPO_DATA1"."DAT_REVNUMBER" < max("VCSGISREPO_DATA2"."DAT_REVNUMBER"))

	  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and max("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= max("VCSGISREPO_DATA2"."DAT_EFECTIVEDATE") and "VCSGISREPO_DATA1"."DAT_REVNUMBER" < max("VCSGISREPO_DATA2"."DAT_REVNUMBER"))  )

)

@begin dateFormat

yyyy-MM-dd HH:mm:ss

@end dateFormat

select 

  "VCSGISREPO_DATA1"."COD_DATA", 

  "VCSGISREPO_DATA1"."COD_REVISION", 

  "VCSGISREPO_DATA1"."COD_ENTITY", 

  case when "VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and max("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 then 2 else "VCSGISREPO_DATA1"."DAT_OPERATION" end as "DAT_OPERATION",

  "VCSGISREPO_DATA1"."DAT_REVNUMBER", 

  "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE", 

  "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", 

  "VCSGISREPO_DATA1"."DAT_GEOM", 

  "VCSGISREPO_DATA1"."DAT_DATA", 

  (case when min("VCSGISREPO_DATA2"."DAT_OPERATION") = 0 then 1 else 0 end) as "DEL",

  (case when max("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 or min("VCSGISREPO_DATA2"."DAT_OPERATION") = 1 then 1 else 0 end) as "UPD",

  (case when max("VCSGISREPO_DATA2"."DAT_OPERATION") = 2 then 1 else 0 end) as "INS",

  max("VCSGISREPO_DATA2"."DAT_EFECTIVEDATE") as MAXEFFECTIVEDATE,

  max("VCSGISREPO_DATA2"."DAT_REVNUMBER") as MAXREV

from "VCSGISREPO_DATA" as "VCSGISREPO_DATA1"

  left join "VCSGISREPO_DATA" as "VCSGISREPO_DATA2" on

    "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE" = "VCSGISREPO_DATA2"."DAT_FEATURERELATEDCODE"

    and "VCSGISREPO_DATA2"."DAT_EFECTIVEDATE" <= '%2$s'

    and "VCSGISREPO_DATA2"."DAT_REVNUMBER" != "VCSGISREPO_DATA1"."DAT_REVNUMBER"

where 

  "VCSGISREPO_DATA1"."COD_ENTITY" = '%1$s' 

  and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= '%2$s' 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE", "VCSGISREPO_DATA1"."DAT_REVNUMBER", "VCSGISREPO_DATA1"."DAT_OPERATION", "VCSGISREPO_DATA1"."DAT_DATA"

having not (

  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and ( "INS" = 1 ))

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and "DEL" = 1)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and ("DEL" = 1 or "UPD" = 1))

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 0 and "DEL" = 0 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 1 and "UPD" = 1 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)

  or  ("VCSGISREPO_DATA1"."DAT_OPERATION" = 2 and "INS" = 1 and "VCSGISREPO_DATA1"."DAT_EFECTIVEDATE" <= MAXEFFECTIVEDATE and "VCSGISREPO_DATA1"."DAT_REVNUMBER" != MAXREV)  )

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@begin dateFormat

yyyy-MM-dd HH:mm:ss.S

@end dateFormat

import org.gvsig.vcsgis.lib.server.handlers.HistoryHandler;

    public VCSGisServerHandler createHistoryHandler() {

        VCSGisServerHandler handler = new HistoryHandler(repository);

        return handler;

    }

    @Override

import java.util.Objects;

        builder.add("EfectiveDate", Objects.toString(revision.getEfectiveDate(), null));

        builder.add("RevisionDate", Objects.toString(revision.getRevisionDate(), null));

import java.util.Objects;

            parametersBuilder.add("EfectiveDate", Objects.toString(this.getEfectiveDate(),null));

import java.util.Objects;

import org.gvsig.vcsgis.lib.repository.requests.VCSGisHistoryRequest;

    public HistoryRequestClient(VCSGisRepositoryClient repository, String entityName) {

                new HistoryRequestHelper(repository, entityName),

            parametersBuilder.add("MaxDate", Objects.toString(this.getMaxDate(), null));

            parametersBuilder.add("MinDate", Objects.toString(this.getMinDate(), null)); //DataTypeUtils.toTimestamp....

import org.gvsig.vcsgis.lib.repository.remoteclient.requests.HistoryRequestClient;

        return new HistoryRequestClient(this, entityName); //null; //new LogRequestLocaldb(this, entityName);

import java.text.SimpleDateFormat;

        SimpleDateFormat dateFormat = new SimpleDateFormat(

                VCSGisUtils.getSqlTemplate(

                        repository.getServerExplorer().getProviderName(),

                        "dateFormat")

        );

                    dateFormat.format(efectiveDate)

/*

 * 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, see <https://www.gnu.org/licenses/>. 

 * 

 * 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.vcsgis.server.lib;

/**

 *

 * @author gvSIG Team

 */

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.gvsig.vcsgis.lib.server.VCSGisServerController;

import org.gvsig.vcsgis.lib.server.VCSGisServerHandler;

public class VCSGisHistoryServlet extends AbstractVCSGisServlet {

    @Override

    protected VCSGisServerHandler createHandler(VCSGisServerController vcsgisserver) {

        return vcsgisserver.createHistoryHandler();

    }

    @Override

    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        doPost(req, resp);

    }

}

        context.addServlet(VCSGisHistoryServlet.class, "/history");

   <at name="id">/home/fdiaz/projects/gvSIG/org.gvsig.vcsgis/org.gvsig.vcsgis.swing/org.gvsig.vcsgis.swing.impl/src/main/java/org/gvsig/vcsgis/swing/impl/export/VCSGisJExportView.xml</at>

   <at name="rowspecs">CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,FILL:DEFAULT:GROW(1.0),CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:MIN(16PX;DEFAULT):NONE,CENTER:MIN(16PX;DEFAULT):NONE,CENTER:MIN(16PX;DEFAULT):NONE,CENTER:2DLU:NONE</at>

            <at name="width">67</at>

            <at name="height">14</at>

            <at name="width">1178</at>

            <at name="height">20</at>

            <at name="width">16</at>

            <at name="height">18</at>

            <at name="width">67</at>

            <at name="height">14</at>

            <at name="width">1256</at>

            <at name="height">20</at>

            <at name="width">1281</at>

            <at name="height">258</at>

            <at name="width">1283</at>

            <at name="height">16</at>

            <at name="width">1283</at>

            <at name="height">16</at>

            <at name="width">16</at>

            <at name="height">18</at>

           <at name="row">18</at>

            <at name="width">1283</at>

            <at name="height">14</at>

           <at name="row">21</at>

            <at name="width">1263</at>

           <at name="row">22</at>

            <at name="width">1263</at>

           <at name="row">23</at>

            <at name="width">1263</at>

        <at name="id">embedded.1021904144</at>

                 <at name="width">1229</at>

                 <at name="height">20</at>

                 <at name="width">16</at>

                 <at name="height">18</at>

            <at name="name"/>

              <at name="border">

               <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                <super classname="com.jeta.forms.store.properties.BorderProperty">

                 <at name="name">border</at>

                </super>

                <at name="borders">

                 <object classname="java.util.LinkedList">

                  <item >

                   <at name="value">

                    <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                     <super classname="com.jeta.forms.store.properties.BorderProperty">

                      <at name="name">border</at>

                     </super>

                    </object>

                   </at>

                  </item>

                 </object>

                </at>

               </object>

              </at>

        <at name="id">embedded.2075886119</at>

                 <at name="width">1229</at>

                 <at name="height">20</at>

                 <at name="width">16</at>

                 <at name="height">18</at>

            <at name="name"/>

           <at name="row">20</at>

        <at name="id">embedded.1835273475</at>

        <at name="colspecs">FILL:22PX:NONE,FILL:DEFAULT:NONE,FILL:4DLU:NONE,FILL:DEFAULT:GROW(1.0)</at>

                <at name="colspan">3</at>

                 <at name="width">1256</at>

                 <at name="height">16</at>

                <at name="colspan">3</at>