gvSIG projects pool

====

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2012 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 2

    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.

====

Put into this folder the resources needed by your classes.

This folder is added to the classpath, so you can load any resources 

through the ClassLoader.

By default, in this folder you can find an example of log4j configuration,

prepared to log messages through the console, so logging works when you

run your classes.

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2012 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 2

    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.

-->

<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<!-- 

Log4J configuration file for unit tests execution.

 -->

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

	<!-- Appender configuration to show logging messages through the console -->

	<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%d{HH:mm:ss,SSS} %-5p [%c{2}.%M()]  %m%n" />

		</layout>

	</appender>

	<!-- 

	Activate logging messages of DEBUG level of higher only for the

	org.gvsig.tools packages.

	You can put full classes names or packages instead, to configure

	logging for all the classes and subpackages of the package.

	-->

	<category name="org.gvsig">

		<priority value="WARN" />

	</category>

	<category name="org.cresques">

		<priority value="WARN" />

	</category>

	<!-- 

	By default, show only logging messages of INFO level or higher, 

	through the previously configured CONSOLE appender. 

	-->

	<root>

		<priority value="INFO" />

		<appender-ref ref="CONSOLE" />

	</root>

</log4j:configuration>

<assembly>

    <id>package-main</id>

    <formats>

        <format>dir</format>

        <format>zip</format>

    </formats>

    <baseDirectory>${project.artifactId}</baseDirectory>

    <includeBaseDirectory>false</includeBaseDirectory>

    <files>

        <file>

            <source>target/${project.artifactId}-${project.version}.jar</source>

            <outputDirectory>.</outputDirectory>

        </file>

    </files>

    <fileSets>

        <fileSet>

            <directory>src/main/resources/data</directory>

            <outputDirectory>data</outputDirectory>

        </fileSet>

    </fileSets>

    <dependencySets>

        <dependencySet>

            <useProjectArtifact>false</useProjectArtifact>

            <useTransitiveDependencies>true</useTransitiveDependencies>

            <outputDirectory>lib</outputDirectory>

        </dependencySet>

    </dependencySets>

</assembly>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright ? 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 2

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

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

/**

 * Main executable class of vcsgis tool.

 *

 * @author gvSIG Team

 */

public class Main {

    public static void main(String args[]) {

        new DefaultLibrariesInitializer().fullInitialize();

    }

}

<?xml version="1.0" encoding="ISO-8859-1"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <artifactId>org.gvsig.vcsgis.main</artifactId>

    <packaging>jar</packaging>

    <name>${project.artifactId}</name>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.vcsgis</artifactId>

        <version>1.0.0-SNAPSHOT</version>

    </parent>

    <build>

        <plugins>

            <plugin>

                <artifactId>maven-assembly-plugin</artifactId>

                <executions>

                    <execution>

                        <id>package-main</id>

                        <phase>package</phase>

                        <goals>

                            <goal>single</goal>

                        </goals>

                        <configuration>

                            <ignoreDirFormatExtensions>true</ignoreDirFormatExtensions>

                            <appendAssemblyId>false</appendAssemblyId>

                            <finalName>${project.artifactId}-${project.version}</finalName>

                            <descriptors>

                                <descriptor>src/main/assembly/package-main.xml</descriptor>

                            </descriptors>

                        </configuration>

                    </execution>

                </executions>

            </plugin>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-jar-plugin</artifactId>

                <configuration>

                    <archive>

                        <manifest>

                            <addClasspath>true</addClasspath>

                            <mainClass>org.gvsig.vcsgis.main.Main</mainClass>

                            <classpathPrefix>lib</classpathPrefix>

                        </manifest>

                    </archive>

                </configuration>

            </plugin>

        </plugins>

    </build>

    <dependencies>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.vcsgis.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.vcsgis.swing.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <!-- runtime dependencies -->

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.vcsgis.lib.impl</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.vcsgis.swing.impl</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.metadata.lib.basic.impl}</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.impl</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.spi</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.file.lib</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.file.shp</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.file.dbf</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db.lib</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db.h2</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.timesupport.lib.api</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.timesupport.lib.impl}</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.compat.impl}</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.fmap.geometry.impl}</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>            

            <artifactId>${org.gvsig.proj.lib.impl}</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.swing.api</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.swing.impl</artifactId>

            <scope>runtime</scope>

        </dependency>

    </dependencies>

</project>

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisCommitServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createCommitHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisRowDeleteServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createRowUpdateHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisRowUpdateServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createRowUpdateHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisRowCreateServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createRowCreateHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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;

import javax.servlet.http.HttpServlet;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters;

import org.gvsig.vcsgis.lib.VCSGisLocator;

import org.gvsig.vcsgis.lib.VCSGisManager;

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

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

/**

 *

 * @author gvSIG Team

 */

public abstract class VCSGisServlet extends HttpServlet {

    protected VCSGisServerController createVCSGisServerController() {

        VCSGisManager manager = VCSGisLocator.getVCSGisManager();

        JDBCServerExplorerParameters dbconn = (JDBCServerExplorerParameters) this.getServletContext().getAttribute(VCSGisServerUtils.VCSGIS_CONFIG_DBPARAMS);

        VCSGisRepository repository = manager.openRepository(dbconn);

        VCSGisServerController serverController = manager.createServerController(repository);

        return serverController;

    }

}

/*

 * 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;

import java.io.File;

import java.net.URL;

import org.apache.commons.io.FileUtils;

import org.apache.commons.math.stat.inference.TestUtils;

import org.eclipse.jetty.server.Server;

import org.eclipse.jetty.server.handler.ShutdownHandler;

import org.eclipse.jetty.servlet.ServletContextHandler;

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

import org.eclipse.jetty.server.handler.HandlerCollection;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters;

import org.gvsig.tools.util.HasAFile;

import org.gvsig.vcsgis.lib.VCSGisLocator;

import org.gvsig.vcsgis.lib.VCSGisManager;

/**

 *

 * @author gvSIG Team

 */

public class VCSGisServerUtils {

    /*

    https://www.eclipse.org/jetty/documentation/current/

    */

    public static final String VCSGIS_CONFIG_DBPARAMS = "org.gvsig.vcsgis.server.params";

    public static final String PROVIDER_NAME = DataStore.H2SPATIAL_PROVIDER_NAME;

    public static final String DB_NAME = "vcsgisserver";

    public static final int SERVER_PORT = 9810;

    public static Server createServer(

            JDBCServerExplorerParameters dbparams, 

            String shutdownpass

        ) {

        return createServer(SERVER_PORT, dbparams, shutdownpass);

    }

    public static Server createServer(JDBCServerExplorerParameters dbparams) {

        return createServer(SERVER_PORT, dbparams, null);

    }

    public static Server createServer(

            int port, 

            JDBCServerExplorerParameters dbparams, 

            String shutdownpass

        ) {

        Server server = new Server(port);

        ServletContextHandler context = new ServletContextHandler(

                ServletContextHandler.NO_SECURITY | ServletContextHandler.NO_SESSIONS

        );

        context.setAttribute(VCSGIS_CONFIG_DBPARAMS, dbparams);

        context.addServlet(HelloServlet.class, "/hello");

        context.addServlet(VCSGisEntitiesServlet.class, "/entities");

        context.addServlet(VCSGisCommitServlet.class, "/commit");

        context.addServlet(VCSGisCheckoutServlet.class, "/checkout");

        context.addServlet(VCSGisRowCreateServlet.class, "/rowcreate");

        context.addServlet(VCSGisRowUpdateServlet.class, "/rowupdate");

        context.addServlet(VCSGisRowDeleteServlet.class, "/rowdelete");

        HandlerCollection handlers = new HandlerCollection();

        handlers.addHandler(context);

        if( shutdownpass!=null ) {

            handlers.addHandler(new ShutdownHandler(shutdownpass));

        }

        server.setHandler(handlers);

        return server;

    }

    public static void main(String[] args) throws Exception

    {

        new DefaultLibrariesInitializer().fullInitialize();

        VCSGisManager manager = VCSGisLocator.getVCSGisManager();

        JDBCServerExplorerParameters dbparams = getDBParameters(DB_NAME);

        manager.initRepository(dbparams, null);

        Server server = createServer(

                SERVER_PORT, 

                dbparams,

                "pass"

        );

        server.start();

        server.join();

    }

    private static JDBCServerExplorerParameters getDBParameters(String dbname)  {

        try {

            DataManager dataManager = DALLocator.getDataManager();

            JDBCServerExplorerParameters conn = (JDBCServerExplorerParameters) dataManager.createServerExplorerParameters(PROVIDER_NAME);

            File dbfile = getResource(String.format("test-dbs/%s",dbname));

            FileUtils.forceMkdir(dbfile.getParentFile());

            ((HasAFile)conn).setFile(dbfile);

            return conn;

        } catch (Exception ex) {

            return null;

        }

    }

    private static File getTargetFolder() throws Exception {

        URL url = TestUtils.class.getResource("/");

        File x = new File(url.toURI());

        File target = x.getParentFile();

        return target;

    }

    private static File getResource(String name) throws Exception {

        File x = new File(getTargetFolder(), name);

        return x;

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisUpdateServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createUpdateHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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.naming.InitialContext;

import javax.naming.NamingException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class HelloServlet extends HttpServlet {

    @Override

    protected void doGet(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        response.setStatus(HttpServletResponse.SC_OK);

        response.setContentType("text/html");

        response.setCharacterEncoding("utf-8");

        response.getWriter().println("<h1>Hello from HelloServlet</h1>");

        response.getWriter().println(this.getServletContext().getClass().getName()+"<br>");

        response.getWriter().println("VCSGisDatabaseParameters="+(this.getServletContext().getAttribute(VCSGisServerUtils.VCSGIS_CONFIG_DBPARAMS))+"<br>");

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisEntitiesServlet extends VCSGisServlet {

    @Override

    protected void doGet(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createEntitiesHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createEntitiesHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

/*

 * 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 java.io.InputStream;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.io.IOUtils;

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

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

public class VCSGisCheckoutServlet extends VCSGisServlet {

    @Override

    protected void doPost(HttpServletRequest request,

            HttpServletResponse response) throws IOException {

        try {

            VCSGisServerController vcsgisserver = this.createVCSGisServerController();

            VCSGisServerHandler handler = vcsgisserver.createCheckoutHandler();

            InputStream response_stream = handler.handle(request.getInputStream());

            IOUtils.copy(response_stream, response.getWriter());

//            vcsgisserver.dispose();

            response.setStatus(HttpServletResponse.SC_OK);

            response.setContentType("application/json");

            response.setCharacterEncoding("utf-8");

        } catch (Exception ex) {

            throw new IOException(ex);

        }

    }

}

org.gvsig.vcsgis.lib.VCSGisLibraryImpl

@begin createRepositoryIndex1

create index if not exists idx_data_1 on VCSGISREPO_DATA (COD_ENTITY ASC, DAT_REVNUMBER ASC)

@end createRepositoryIndex1

@begin createRepositoryIndex2

create index if not exists idx_data_2 on VCSGISREPO_DATA (DAT_FEATURERELATEDCODE ASC, DAT_REVNUMBER ASC, DAT_OPERATION ASC)

@end createRepositoryIndex2

@begin getDataOfEntityFromRevisionNumber

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_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_REVNUMBER" > %1$d 

where 

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

  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" > %1$d 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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_REVNUMBER" < MAXREV)

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

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

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@end getDataOfEntityFromRevisionNumber

@begin getDataOfEntityToRevisionNumber

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_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_REVNUMBER" <= %1$d 

where 

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

  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" <= %1$d 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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_REVNUMBER" < MAXREV)

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

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

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@end getDataOfEntityToRevisionNumber

@begin getDataOfEntityFromEfectiveDate

-- TABLE_NAME,

-- efectiveDate,

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

@end getDataOfEntityFromEfectiveDate

@begin dateFormat

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

@end dateFormat

@begin createWorkspaceIndex1

create index if not exists idx_wschanges_1 on VCSGIS_WSCHANGES (COD_ENTITY ASC, WSCH_OPERATION DESC, COD_WSCHANGE ASC)

@end createWorkspaceIndex1

@begin createWorkspaceIndex2

create index if not exists idx_wschanges_2 on VCSGIS_WSCHANGES (WSCH_SELECTED ASC, WSCH_OPERATION ASC)

@end createWorkspaceIndex2

@begin createWorkspaceIndex3

create index if not exists idx_remotechanges_3 on VCSGIS_REMOTECHANGES (COD_ENTITY ASC, RCH_SELECTED ASC)

@end createWorkspaceIndex3

@begin updateStateFromLocalChanges

-- status

update VCSGIS_REMOTECHANGES 

set RCH_STATUS = %1$d 

where exists (select 1 from VCSGIS_WSCHANGES where RCH_DATACODE = WSCH_FEATURECODE LIMIT 1)

@end updateStateFromLocalChanges

@begin removeLocalChangesRelatedToSelectedRemoteChanges

-- entityCode

delete from VCSGIS_WSCHANGES 

where COD_ENTITY = '%1$s' and WSCH_FEATURECODE in (

    select RCH_DATACODE from VCSGIS_REMOTECHANGES where RCH_DATACODE = WSCH_FEATURECODE and CAST(RCH_SELECTED as INT)=1)

@end removeLocalChangesRelatedToSelectedRemoteChanges

@begin getChangesWidthUserData

-- EntityName

-- FeatureIdFieldName (VCSGISCODE)

-- RelatedFeatureCode

-- filter

SELECT * FROM VCSGIS_WSCHANGES left join "%1$s" on WSCH_FEATURECODE = "%2$s" WHERE "%2$s" <> '%3$s' AND (%4$s)

@end getChangesWidthUserData

@begin alterTableAddColumnVCSGISCODE

-- EntityName

ALTER TABLE "%1$s" ADD COLUMN "VCSGISCODE" VARCHAR(40)

@end alterTableAddColumnVCSGISCODE

@begin alterTableDropPrimaryKey

-- EntityName

ALTER TABLE "%1$s" DROP PRIMARY KEY

@end alterTableDropPrimaryKey

@begin alterTableAlterColumnVCSGISCODESetNotNull

-- EntityName

ALTER TABLE "%1$s" ALTER COLUMN "VCSGISCODE" SET NOT NULL

@end alterTableAlterColumnVCSGISCODESetNotNull

@begin alterTableAddPrimaryKeyVCSGISCODE

-- EntityName

ALTER TABLE "%1$s" ADD PRIMARY KEY ("VCSGISCODE")

@end alterTableAddPrimaryKeyVCSGISCODE

@begin createRepositoryIndex1

create index if not exists idx_data_1 on VCSGISREPO_DATA (COD_ENTITY ASC, DAT_REVNUMBER ASC)

@end createRepositoryIndex1

@begin createRepositoryIndex2

create index if not exists idx_data_2 on VCSGISREPO_DATA (DAT_FEATURERELATEDCODE ASC, DAT_REVNUMBER ASC, DAT_OPERATION ASC)

@end createRepositoryIndex2

@begin getDataOfEntityFromRevisionNumber

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_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_REVNUMBER" > %1$d 

where 

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

  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" > %1$d 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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_REVNUMBER" < MAXREV)

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

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

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@end getDataOfEntityFromRevisionNumber

@begin getDataOfEntityToRevisionNumber

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_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_REVNUMBER" <= %1$d 

where 

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

  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" <= %1$d 

group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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_REVNUMBER" < MAXREV)

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

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

order by "VCSGISREPO_DATA1"."DAT_OPERATION" desc

@end getDataOfEntityToRevisionNumber

@begin getDataOfEntityFromEfectiveDate

-- TABLE_NAME,

-- efectiveDate,

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

@end getDataOfEntityFromEfectiveDate

@begin dateFormat

yyyy-MM-dd HH:mm:ss

@end dateFormat

@begin createWorkspaceIndex1

create index if not exists idx_wschanges_1 on VCSGIS_WSCHANGES (COD_ENTITY ASC, WSCH_OPERATION DESC, COD_WSCHANGE ASC)

@end createWorkspaceIndex1

@begin createWorkspaceIndex2

create index if not exists idx_wschanges_2 on VCSGIS_WSCHANGES (WSCH_SELECTED ASC, WSCH_OPERATION ASC)

@end createWorkspaceIndex2

@begin createWorkspaceIndex3

create index if not exists idx_remotechanges_3 on VCSGIS_REMOTECHANGES (COD_ENTITY ASC, RCH_SELECTED ASC)

@end createWorkspaceIndex3

@begin updateStateFromLocalChanges

-- status

update VCSGIS_REMOTECHANGES 

set RCH_STATUS = %1$d 

where exists (select 1 from VCSGIS_WSCHANGES where RCH_DATACODE = WSCH_FEATURECODE LIMIT 1)

@end updateStateFromLocalChanges

@begin removeLocalChangesRelatedToSelectedRemoteChanges

-- entityCode

delete from VCSGIS_WSCHANGES 

where COD_ENTITY = '%1$s' and WSCH_FEATURECODE in (

    select RCH_DATACODE from VCSGIS_REMOTECHANGES where RCH_DATACODE = WSCH_FEATURECODE and CAST(RCH_SELECTED as INT)=1)

@end removeLocalChangesRelatedToSelectedRemoteChanges

@begin getChangesWidthUserData

-- EntityName

-- FeatureIdFieldName (VCSGISCODE)

-- RelatedFeatureCode

-- filter

SELECT * FROM VCSGIS_WSCHANGES left join "%1$s" on WSCH_FEATURECODE = "%2$s" WHERE "%2$s" <> '%3$s' AND (%4$s)

@end getChangesWidthUserData

@begin alterTableAddColumnVCSGISCODE

-- EntityName

ALTER TABLE "%1$s" ADD COLUMN "VCSGISCODE" VARCHAR(40)

@end alterTableAddColumnVCSGISCODE

@begin alterTableDropPrimaryKey

-- EntityName

ALTER TABLE "%1$s" DROP PRIMARY KEY

@end alterTableDropPrimaryKey

@begin alterTableAlterColumnVCSGISCODESetNotNull

-- EntityName

ALTER TABLE "%1$s" ALTER COLUMN "VCSGISCODE" SET NOT NULL

@end alterTableAlterColumnVCSGISCODESetNotNull

@begin alterTableAddPrimaryKeyVCSGISCODE

-- EntityName

ALTER TABLE "%1$s" ADD PRIMARY KEY ("VCSGISCODE")

@end alterTableAddPrimaryKeyVCSGISCODE

@begin createRepositoryIndex1

create index idx_data_1 on VCSGISREPO_DATA (COD_ENTITY ASC, DAT_REVNUMBER ASC)

@end createRepositoryIndex1

@begin createRepositoryIndex2

create index idx_data_2 on VCSGISREPO_DATA (DAT_FEATURERELATEDCODE ASC, DAT_REVNUMBER ASC, DAT_OPERATION ASC)

@end createRepositoryIndex2

@begin getDataOfEntityFromRevisionNumber

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_REVNUMBER" > %1$d 

	where 

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

	  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" > %1$d   

	group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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_REVNUMBER" < max("VCSGISREPO_DATA2"."DAT_REVNUMBER"))

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

)

order by "VCSGISREPO_DATA"."DAT_OPERATION" desc

@end getDataOfEntityFromRevisionNumber

@begin getDataOfEntityToRevisionNumber

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_REVNUMBER" <= %1$d 

	where 

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

	  and "VCSGISREPO_DATA1"."DAT_REVNUMBER" <= %1$d   

	group by "VCSGISREPO_DATA1"."DAT_FEATURERELATEDCODE", "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 )