Application: gvSIG desktop

package org.gvsig.xml2db.lib.impl;

import java.io.File;

import java.io.InputStream;

import java.io.Reader;

import java.nio.charset.Charset;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.xml.parsers.SAXParser;

import javax.xml.parsers.SAXParserFactory;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang3.StringUtils;

import org.apache.commons.lang3.mutable.MutableInt;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataStoreParameters;

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

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

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

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

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

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

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

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

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

import org.gvsig.tools.dispose.DisposeUtils;

import org.gvsig.tools.task.SimpleTaskStatus;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.xml.sax.Attributes;

import org.xml.sax.InputSource;

import org.xml.sax.Locator;

import org.xml.sax.SAXException;

import org.xml.sax.helpers.DefaultHandler;

/**

 *

 * @author jjdelcerro

 */

@SuppressWarnings("UseSpecificCatch")

public class CopyXML2dbImpl {

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

    private static class TableInfo {

        private final Map<String,TableInfo> tables;

        private final JDBCStoreParameters openStoreParams;

        private final String tableName;

        private FeatureStore store;

        private EditableFeature current_row;

        private int pkcounter;

        private EditableFeature last_row;

        private TableInfo(Map<String,TableInfo> tables, JDBCStoreParameters openStoreParams) {

            this.tables = tables;

            this.openStoreParams = openStoreParams;

            this.tableName = openStoreParams.getTable();

            this.pkcounter = 1;

        }

        public void close() {

            try {

                this.insert();

                if( this.store!=null ) {

                    System.out.println("###: close("+this.tableName+")");

                    this.store.finishEditing();

                    DisposeUtils.dispose(this.store);

                }

            } catch(Throwable t) {

                throw new RuntimeException("Can't close table '"+this.getTableName()+"'.", t);

            }

        }

        public String getTableName() {

            return this.tableName;

        }

        public FeatureStore getStore() {

            if( this.store == null ) {

                try {

                    System.out.println("###: create store("+this.tableName+")");

                    DataManager dataManager = DALLocator.getDataManager();                

                    this.store = (FeatureStore) dataManager.openStore(

                            this.openStoreParams.getProviderName(), 

                            openStoreParams

                    );

                    this.store.edit(FeatureStore.MODE_APPEND);

                } catch(Throwable t) {

                    throw new RuntimeException("Can't open and start edit store '"+this.getTableName()+"'.", t);

                }

            }

            return this.store;

        }

        public Feature current_row() {

            return this.current_row;

        }

        private void createRow() {

            try {

                FeatureStore theStore = this.getStore();

//                System.out.println("###: create row("+this.tableName+")");

                this.current_row = theStore.createNewFeature();

                this.last_row = this.current_row;

                FeatureType ft = this.current_row.getType();

                for (FeatureAttributeDescriptor attrdesc : ft) {

                    if( attrdesc.isPrimaryKey() ) {

                       this.set(attrdesc.getName(), this.pkcounter++);

                    } else if( attrdesc.isForeingKey() ) {

                        ForeingKey fk = attrdesc.getForeingKey();

                        TableInfo table = this.tables.get(fk.getTableName().toLowerCase());

                        if( table != null ) {

                            this.set(attrdesc.getName(), table.getPkValue());

                        }

                    }

                }

            } catch(Throwable t) {

                throw new RuntimeException("Can't create feature of store '"+this.getTableName()+"'.", t);

            }

        }

        private void set(String name, Object value) {

            if( this.current_row != null ) {

//                System.out.println("###: set("+this.tableName+", "+name+", "+Objects.toString(value)+")");

                try {

                    if( StringUtils.equalsIgnoreCase("CONDICION_METEO", name) ) {

                        System.out.println("CONDICION_METEO...");

                    }

                    this.current_row.set(name, value);

                } catch(RuntimeException ex) {

                    LOGGER.info("Can't set attribute '"+name+"' in "+ this.getStore().getName()); //, ex);

                    throw ex;

                }

            }

        }

        private void insert() {

            if( this.store!=null && this.current_row!=null ) {

                try {

                    FeatureType ft = this.current_row.getType();

                    for (FeatureAttributeDescriptor attrdesc : ft) {

                        if( attrdesc.isForeingKey() ) {

                            ForeingKey fk = attrdesc.getForeingKey();

                            TableInfo table = this.tables.get(fk.getTableName().toLowerCase());

                            if( table != null ) {

                                if( current_row.isNull(attrdesc.getName())){

                                    this.set(attrdesc.getName(), table.getPkValue());

                                }

                            }

                        }

                    }

//                    System.out.println("###: insert("+this.tableName+")");

                    this.store.insert(current_row);

                } catch(Throwable t) {

                    throw new RuntimeException("Can't insert feature into store '"+this.getTableName()+"'.", t);

                }

            }

            this.current_row = null;

        }

        private Object getPkValue() {

            if( this.last_row==null ) {

                return null;

            }

            FeatureAttributeDescriptor[] attrdescs = this.last_row.getType().getPrimaryKey();

            return this.last_row.get(attrdescs[0].getName());

        }

    }

    public void copyData(InputSource is, JDBCServerExplorerParameters dbparams, long countLines, SimpleTaskStatus taskStatus) {

        if( is == null || is.getCharacterStream()==null ) {

            throw new IllegalArgumentException("reader is null");

        }

        DataManager dataManager = DALLocator.getDataManager();                        

        JDBCServerExplorer explorer = null;

        try {

            explorer = (JDBCServerExplorer) dataManager.openServerExplorer(dbparams.getProviderName(), dbparams);

        } catch (Exception ex) {

            throw new IllegalArgumentException("Can't open target database", ex);

        }

        MutableInt line = new MutableInt(0);

        MutableInt column = new MutableInt(0);

        try {

            taskStatus.message("Coping...");

            taskStatus.setRangeOfValues(0, countLines);

            SAXParserFactory spf = SAXParserFactory.newInstance();

            spf.setNamespaceAware(true);

            SAXParser saxParser = spf.newSAXParser();

            List<String> path = new ArrayList<>();

            Map<String,TableInfo> tables = new HashMap<>();

            for (DataStoreParameters openStoreParams0 : explorer.list()) {

                JDBCStoreParameters openStoreParams = (JDBCStoreParameters) openStoreParams0;

                TableInfo table = new TableInfo(tables, openStoreParams);

                tables.put(table.getTableName().toLowerCase(), table);

            }

            saxParser.parse(is, new DefaultHandler() {

                private Locator locator;

                private StringBuilder valueBuilder;

                @Override

                public void setDocumentLocator(Locator locator) {

                    this.locator = locator;

                }

                @Override

                public void startElement(String uri, String localName, String qName, Attributes attributes) throws SAXException {

                    line.setValue(this.locator.getLineNumber());

                    column.setValue(this.locator.getColumnNumber()-2-localName.length());

                    taskStatus.setCurValue(line.intValue());

                    try {

                        path.add(localName);

                        String path_s = StringUtils.join(path, "/");

                        String tableName1 = FilenameUtils.getBaseName(path_s).toLowerCase();

                        TableInfo table1 = tables.get(tableName1);

                        if( table1 != null ) {

                            table1.createRow();

                            for (int i = 0; i < attributes.getLength(); i++) {

                                String name = attributes.getLocalName(i);

                                String value = attributes.getValue(i);

                                table1.set(name, value);

                            }

                        }

                    } catch(Exception ex) {

                        LOGGER.warn("Can't process startElement (line "+line+", column "+column+")",ex);

                    }

                    this.valueBuilder = null;

                }

                @Override

                public void endElement(String uri, String localName, String qName) throws SAXException {

                    line.setValue(this.locator.getLineNumber());

                    column.setValue(this.locator.getColumnNumber()-2-localName.length());

                    taskStatus.setCurValue(line.intValue());

                    try {

                        String path_s = StringUtils.join(path, "/");

                        String tableName1 = FilenameUtils.getBaseName(path_s).toLowerCase();

                        TableInfo table1 = tables.get(tableName1);

                        if( table1 != null ) {

                            table1.insert();

                        } else if( path.size()>1 ) {

                            List<String> parentpath = path.subList(0, path.size()-1);

                            String parentpath_s = StringUtils.join(parentpath, "/");

                            String attrname = FilenameUtils.getBaseName(path_s);

//                            if( StringUtils.equalsIgnoreCase("CONDICION_FIRME", attrname) ) {

//                                System.out.println("CONDICION_FIRME...");

//                            }

                            String tableName2 = FilenameUtils.getBaseName(parentpath_s).toLowerCase();

                            TableInfo table2 = tables.get(tableName2);

                            if( table2!=null ) {

                                if( this.valueBuilder!=null ) {

                                    String value = StringUtils.trimToNull(this.valueBuilder.toString());  

                                    if( value != null ) {

                                        table2.set(attrname,value);

                                    }

                                }

                            }

                        }

                    } catch(Exception ex) {

                        LOGGER.warn("Can't process endElement (line "+line+", column "+column+")",ex);

                    }

                    this.valueBuilder = null;

                    path.remove(path.size()-1);

                }

                @Override

                public void characters(char[] ch, int start, int length) throws SAXException {

                    line.setValue(this.locator.getLineNumber());

                    taskStatus.setCurValue(line.intValue());

                    if( this.valueBuilder == null ) {

                        this.valueBuilder = new StringBuilder();

                    }

                    this.valueBuilder.append(ch, start, length);

                }

            });

            for (TableInfo table : tables.values() ) {

                table.close();

            }

        } catch (Exception ex) {

            throw new RuntimeException("Can't copy data (line "+line+", column "+column+").", ex);

        }

    }

    public void copyData(File xml, Charset charset, JDBCServerExplorerParameters dbparams, SimpleTaskStatus taskStatus) {

        long count = Xml2dbCommons.countLines(xml, charset, taskStatus);

        InputSource is = Xml2dbCommons.openReader(xml, charset);

        copyData(is, dbparams, count, taskStatus);

    }

    public void copyData(InputStream xml, Charset charset, JDBCServerExplorerParameters dbparams, SimpleTaskStatus taskStatus) {

        long count = Xml2dbCommons.countLines(xml, charset, taskStatus);

        InputSource is = Xml2dbCommons.openReader(xml, charset);

        copyData(is, dbparams, count, taskStatus);

    }

}