Application: gvSIG desktop

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 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, 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.exportto.swing.prov.jdbc.panel;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.util.Iterator;

import java.util.List;

import javax.swing.DefaultListModel;

import javax.swing.JComponent;

import javax.swing.JOptionPane;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.exportto.swing.prov.jdbc.ExporttoJDBCProvider;

import org.gvsig.exportto.swing.spi.ExporttoPanelValidationException;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

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

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

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

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.i18n.I18nManager;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * @author gvSIG Team

 * @version $Id$

 *

 */

public class SelectTableNamePanel extends SelectTableNamePanelLayout implements ExporttoSwingProviderPanel {

    private static final Logger logger = LoggerFactory.getLogger(SelectTableNamePanel.class);

    private static final long serialVersionUID = 6269512983586358017L;

    private final ExporttoJDBCProvider provider;

    private static class TableItem {

        private JDBCStoreParameters params;

        private String label;

        public TableItem(String label, JDBCStoreParameters params) {

            this.params = params;

            this.label = label;

        }

        public TableItem(JDBCStoreParameters params) {

            this(params.getSchema() + "." + params.getTable(), params);

        }

        public String toString() {

            return this.label;

        }

        public JDBCStoreParameters getParams() {

            return this.params;

        }

    }

    public SelectTableNamePanel(ExporttoJDBCProvider provider) {

        this.provider = provider;

        initComponents();

    }

    private void initComponents() {

        this.rdoCreateTable.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                onChangeRadioSelecion();

            }

        });

        this.rdoInsert.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {

                onChangeRadioSelecion();

            }

        });

        this.rdoCreateTable.setSelected(true);

    }

    public boolean canCreateTable() {

        return this.rdoCreateTable.isSelected();

    }

    public String getSchema() {

        if (this.canCreateTable()) {

            return StringUtils.defaultIfBlank(this.txtSchema.getText(), null);

        }

        JDBCStoreParameters table = (JDBCStoreParameters) this.lstTables.getSelectedValue();

        if( table == null ) {

            return null;

        }

        return table.getSchema();

    }

    public String getTableName() {

        if (this.canCreateTable()) {

            return StringUtils.defaultIfBlank(this.txtSchema.getText(), null);

        }

        JDBCStoreParameters table = (JDBCStoreParameters) this.lstTables.getSelectedValue();

        if( table == null ) {

            return null;

        }

        return table.getTable();

    }

    public String getPanelTitle() {

        I18nManager i18nManager = ToolsLocator.getI18nManager();

        return i18nManager.getTranslation("intro_tablename");

    }

    public boolean isValidPanel() throws ExporttoPanelValidationException {

        if (this.getTableName() == null) {

            throw new ExporttoPanelValidationException(

                    "The table cannot be empty");

        }

        if (this.getSchema() == null) {

            throw new ExporttoPanelValidationException(

                    "The schema cannot be empty");

        }

        return true;

    }

    public void enterPanel() {

        this.fillTablesList();

    }

    public JComponent asJComponent() {

        return this;

    }

    public void onChangeRadioSelecion() {

        if (this.rdoCreateTable.isSelected()) {

            this.txtSchema.setEnabled(true);

            this.txtTableName.setEnabled(true);

            this.lstTables.setEnabled(false);

        } else {

            this.txtSchema.setEnabled(false);

            this.txtTableName.setEnabled(false);

            this.lstTables.setEnabled(true);

        }

    }

    private void fillTablesList() {

        JDBCServerExplorerParameters explorerParameters = this.provider.getExplorerParameters();

        if (explorerParameters == null) {

            return;

        }

        DefaultListModel lmodel = new DefaultListModel();

        DataManager dataManager = DALLocator.getDataManager();

        try {

            explorerParameters.setShowInformationDBTables(false);

            JDBCServerExplorer explorer = (JDBCServerExplorer) dataManager.openServerExplorer(

                    explorerParameters.getExplorerName(),

                    explorerParameters

            );

            List<JDBCStoreParameters> tables = explorer.list();

            Iterator<JDBCStoreParameters> it = tables.iterator();

            while (it.hasNext()) {

                JDBCStoreParameters table = it.next();

                lmodel.addElement(new TableItem(table));

            }

            this.lstTables.setModel(lmodel);

        } catch (Exception ex) {

            // Esto es llamado desde el enterPanel que ya atrapa los errores

            // volcandolos al log y presentandolos al usuario adecuadamente.

            throw new RuntimeException(ex);

        }

    }

}