Application: gvSIG desktop

package org.gvsig.xml2db.lib.impl;

import java.io.File;

import java.io.InputStream;

import java.util.Locale;

import org.apache.commons.io.FilenameUtils;

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

import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

import org.gvsig.xml2db.lib.api.Xml2dbManager;

import org.gvsig.xml2db.lib.api.xmlinfo.XMLInfo;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

@SuppressWarnings("UseSpecificCatch")

public class TestCopyXml2db extends AbstractLibraryAutoInitTestCase {

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

    private TestUtilsXml2db utils;

    public TestCopyXml2db(String testName) {

        super(testName);

    }

    @Override

    protected void doSetUp() throws Exception {

    }

    public TestUtilsXml2db utils() {

        if( this.utils == null ) {

            this.utils =  new TestUtilsXml2db();

        }

        return this.utils;

    }

    public void testCopyDeclaracion() throws Exception {

        try {

            Xml2dbManager manager = new DefaultXml2dbManager();

            InputStream xml = this.getClass().getResourceAsStream("Declaracion4.xml");

            XMLInfo xmlinfo = manager.extractStructure(xml, null, null, Locale.getDefault(), null, null);

            File dbfile = utils().getFile(new File("databases/declaracion4"));

            JDBCServerExplorerParameters dbparams = manager.createDatabase(null, dbfile, xmlinfo, null);

            xml = this.getClass().getResourceAsStream("Declaracion4.xml");

            manager.copyXml2Db(xml, null, dbparams, null, null);

        } catch (Throwable t) {

            t.printStackTrace();

            throw t;

        }

    }

    public void testCopyDeclaracion2() throws Exception {

        try {

            Xml2dbManager manager = new DefaultXml2dbManager();

            String xmlfname = "Declaracion4.xml";

            InputStream xml = this.getClass().getResourceAsStream(xmlfname);

            XMLInfo xmlinfo = manager.extractStructure(xml, null, null, Locale.getDefault(), "dec_", null);

            File dbfile = utils().getFile(new File("databases/declaracion_r10"));

            JDBCServerExplorerParameters dbparams = manager.createDatabase(null, dbfile, xmlinfo, null);

            xml = this.getClass().getResourceAsStream(xmlfname);

            manager.copyXml2Db(xml, null, dbparams, "dec_", null);

            //importaci?n de otra estructura sobre esta

            xmlfname = "r10graf.xml";

            xml = this.getClass().getResourceAsStream(xmlfname);

            xmlinfo = manager.extractStructure(xml, null, null, Locale.getDefault(), "r10g_", null);

            dbparams = manager.addToDatabase(null, dbfile, xmlinfo, null);

            xml = this.getClass().getResourceAsStream(xmlfname);

            manager.copyXml2Db(xml, null, dbparams, "r10g_", null);

        } catch (Throwable t) {

            t.printStackTrace();

            throw t;

        }

    }

    public void testCopyR10graf() throws Exception {

        testCopyR10graf(null);

    }

    public void testCopyR10grafWithTablesPrefix(String tablesPrefix) throws Exception {

        testCopyR10graf("R10G_");

    }

    public void testCopyR10graf(String tablesPrefix) throws Exception {

//        String xmlfname = "BDA_R10_graf18_1728062018_004.xml";

//        String xmlfname = "BDA_R10_graf18_1728062018_002.xml";

        String xmlfname = "r10graf.xml";

        try {

            Xml2dbManager manager = new DefaultXml2dbManager();

            InputStream xml = this.getClass().getResourceAsStream(xmlfname);

            XMLInfo xmlinfo = manager.extractStructure(xml, null, null, Locale.getDefault(), tablesPrefix, null);

            File dbfile = utils().getFile(new File("databases/"+FilenameUtils.removeExtension(xmlfname)));

            JDBCServerExplorerParameters dbparams = manager.createDatabase(null, dbfile, xmlinfo, null);

            xml = this.getClass().getResourceAsStream(xmlfname);

            manager.copyXml2Db(xml, null, dbparams, tablesPrefix, null);

        } catch(Throwable t) {

            LOGGER.warn("Test testCopyR10graf failed",t);

            throw t;

        }

    }

    public void testCopyArena2() throws Exception {

//     Fallan cosas del estilo de la linea 281 o 282, parece que no reconoce el 

//     StructureStractor a PRES_INFRAC_VEL_COND como una tabla.

//     Hay que repasar tambien que pasa con cosas como la linea 497.  

        try {

            Xml2dbManager manager = new DefaultXml2dbManager();

            InputStream xml = this.getClass().getResourceAsStream("victimas.xml");

            XMLInfo xmlinfo = manager.extractStructure(xml, null, null, Locale.getDefault(), null, null);

            File dbfile = utils().getFile(new File("databases/victimas"));

            JDBCServerExplorerParameters dbparams = manager.createDatabase(null, dbfile, xmlinfo, null);

            xml = this.getClass().getResourceAsStream("victimas.xml");

//            manager.copyXml2Db(xml, null, dbparams);

        } catch(Throwable t) {

            LOGGER.warn("Test testCopyArena2 failed",t);

            throw t;

        }

    }

    public void testCopyR10grafAndExpedienteEnric() throws Exception {

//        String xmlfname = "BDA_R10_graf18_1728062018_004.xml";

//        String xmlfname = "BDA_R10_graf18_1728062018_002.xml";

        String xmlfname1 = "r10graf.xml";

        String xmlfname2 = "export-expedientes.xml";

        try {            

            Xml2dbManager manager = new DefaultXml2dbManager();

            File dbfile = utils().getFile(new File("databases/"+FilenameUtils.removeExtension("r10graf+exp")));

            InputStream xml1 = this.getClass().getResourceAsStream(xmlfname1);

            XMLInfo xmlinfo1 = manager.extractStructure(xml1, null, null, Locale.getDefault(), "R10G_", null);

            JDBCServerExplorerParameters dbparams1 = manager.createDatabase(null, dbfile, xmlinfo1, null);

            xml1 = this.getClass().getResourceAsStream(xmlfname1);

            manager.copyXml2Db(xml1, null, dbparams1, "R10G_", null);

            InputStream xml2 = this.getClass().getResourceAsStream(xmlfname2);

            XMLInfo xmlinfo2 = manager.extractStructure(xml2, null, null, Locale.getDefault(), "EXP_", null);

            JDBCServerExplorerParameters dbparams2 = manager.createDatabase(null, dbfile, xmlinfo2, null);

            xml2 = this.getClass().getResourceAsStream(xmlfname2);

            manager.copyXml2Db(xml2, null, dbparams2, "EXP_", null);

        } catch(Throwable t) {

            LOGGER.warn("Test testCopyR10graf failed",t);

            throw t;

        }

    }

}