Application: gvSIG desktop

package org.gvsig.geodb.databaseworkspace;

import java.awt.BorderLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JComponent;

import javax.swing.JOptionPane;

import javax.swing.event.ChangeEvent;

import org.apache.commons.lang.StringUtils;

import org.gvsig.featureform.swing.JFeaturesForm;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.DatabaseWorkspaceManager;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.CONFIG_NAME_STORESREPOSITORYID;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.CONFIG_NAME_STORESREPOSITORYLABEL;

import org.gvsig.fmap.dal.StoresRepository;

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

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

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

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

import org.gvsig.fmap.dal.swing.DALSwingLocator;

import org.gvsig.fmap.dal.swing.DataSwingManager;

import org.gvsig.fmap.dal.swing.dataStoreParameters.DataStoreParametersPanel;

import org.gvsig.fmap.dal.swing.dataStoreParameters.DataStoreParametersPanelManager;

import org.gvsig.fmap.dal.swing.searchpanel.FeatureStoreSearchPanel;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.i18n.I18nManager;

import org.gvsig.tools.swing.api.Component;

import org.gvsig.tools.swing.api.ToolsSwingLocator;

import org.gvsig.tools.swing.api.ToolsSwingUtils;

import org.gvsig.tools.swing.api.pickercontroller.PickerController;

import org.gvsig.tools.swing.api.windowmanager.Dialog;

import org.gvsig.tools.swing.api.windowmanager.WindowManager;

import org.gvsig.tools.swing.api.windowmanager.WindowManager_v2;

import org.gvsig.tools.util.LabeledValue;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 *

 * @author jjdelcerro

 */

@SuppressWarnings("UseSpecificCatch")

public class WorkspaceConfigurationPanel

        extends WorkspaceConfigurationPanelView

        implements Component {

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

    private FeatureStoreSearchPanel configurationSearch;

    private FeatureStoreSearchPanel repositorySearch;

    private FeatureStoreSearchPanel resourcesSearch;

    private class TableController {

        private final JButton btnCreate;

        private final JButton btnDrop;

//        private final JButton btnSearch;

        private final JButton btnShowForm;

        private final int tableid;

        public TableController(

                int tableid,

                JButton btnCreate,

                JButton btnDrop //                , JButton btnSearch

                ,

                 JButton btnShowForm

        ) {

            this.tableid = tableid;

            this.btnCreate = btnCreate;

            this.btnDrop = btnDrop;

//            this.btnSearch = btnSearch;

            this.btnShowForm = btnShowForm;

            this.btnCreate.addActionListener(new ActionListener() {

                @Override

                public void actionPerformed(ActionEvent e) {

                    doCreate();

                }

            });

            this.btnDrop.addActionListener(new ActionListener() {

                @Override

                public void actionPerformed(ActionEvent e) {

                    doDrop();

                }

            });

            this.btnShowForm.addActionListener(new ActionListener() {

                @Override

                public void actionPerformed(ActionEvent e) {

                    doShowForm();

                }

            });

//            this.btnSearch.addActionListener(new ActionListener() {

//                @Override

//                public void actionPerformed(ActionEvent e) {

//                    doSearch();

//                }

//            });

        }

        private void doCreate() {

            DataManager dataManager = DALLocator.getDataManager();

            DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

            if (workspace.existsTable(this.tableid)) {

                return;

            }

            workspace.createTable(this.tableid);

        }

        private void doShowForm() {

            try {

                DataManager dataManager = DALLocator.getDataManager();

                DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

                if (!workspace.existsTable(this.tableid)) {

                    return;

                }

                FeatureStore store = workspace.getTable(this.tableid);

                DataSwingManager dalSwingManager = DALSwingLocator.getSwingManager();

                JFeaturesForm form = dalSwingManager.createJFeaturesForm(store);

                WindowManager winManager = ToolsSwingLocator.getWindowManager();

                winManager.showWindow(

                        form.asJComponent(),

                        "Resources",

                        WindowManager.MODE.WINDOW

                );

            } catch (Exception ex) {

                LOGGER.warn("Can't show form of resources table.", ex);

            }

        }

        private void doDrop() {

            DataManager dataManager = DALLocator.getDataManager();

            DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

            if (!workspace.existsTable(this.tableid)) {

                return;

            }

            workspace.dropTable(this.tableid);

        }

//        private void doSearch() {

//            try {

//                DataManager dataManager = DALLocator.getDataManager();

//                DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

//                if (!workspace.existsTable(this.tableid)) {

//                    return;

//                }

//                FeatureStore store = workspace.getTable(this.tableid);

//                DataSwingManager dalSwingManager = DALSwingLocator.getSwingManager();

//                FeatureStoreSearchPanel search = dalSwingManager.createFeatureStoreSearchPanel(store);

//                WindowManager winManager = ToolsSwingLocator.getWindowManager();

//                winManager.showWindow(

//                        search.asJComponent(),

//                        "Resources",

//                        WindowManager.MODE.WINDOW

//                );

//            } catch (Exception ex) {

//                LOGGER.warn("Can't show search panel for resources table.", ex);

//            }

//        }

        public void setEnabled(boolean enabled) {

            this.btnCreate.setEnabled(enabled);

            this.btnDrop.setEnabled(enabled);

//            this.btnSearch.setEnabled(enabled);

            this.btnShowForm.setEnabled(enabled);

        }

    }

    private TableController resourcesTableController;

    private TableController repositoryTableController;

    private TableController configurationTableController;

    private PickerController<JDBCServerExplorerParameters> connectionPicker;

    public WorkspaceConfigurationPanel() {

        this.initComponents();

    }

    private void initComponents() {

        this.connectionPicker = DALSwingLocator.getSwingManager().createJDBCConnectionPickerController(

                this.cboConnections,

                this.btnAddConnection

        );

        this.connectionPicker.addChangeListener((ChangeEvent e) -> {

            doUpdateEnableComponents();

            doUpdateStoresRepositoryInfo();

        });

        this.resourcesTableController = new TableController(

                DatabaseWorkspaceManager.TABLE_RESOURCES,

                btnCreateResourceTable,

                btnDropResourceTable,

                btnShowResourceTable

        );

        this.repositoryTableController = new TableController(

                DatabaseWorkspaceManager.TABLE_REPOSITORY,

                btnCreateRepositoryTable,

                btnDropRepositoryTable,

                btnShowRepositoryTable

        );

        this.configurationTableController = new TableController(

                DatabaseWorkspaceManager.TABLE_CONFIGURATION,

                btnCreateConfigurationTable,

                btnDropConfigurationTable,

                btnShowConfigurationTable

        );

        this.btnRepositoryAddTable.addActionListener((ActionEvent e) -> {

            doAddTableToRepository();

        });

        this.btnConnectToRepository.addActionListener((ActionEvent e) -> {

            doConnectToRepository();

        });

        this.btnShowRepositoryTableParameters.addActionListener((ActionEvent e) -> {

            doShowParametersOfRepositoryTable();

        });

        this.btnFixRepositoryEntries.addActionListener((ActionEvent e) -> {

            doFixRepositoryEntriesToSelectedConnection();

        });

        this.pnlConfiguration.setLayout(new BorderLayout());

        this.pnlRepository.setLayout(new BorderLayout());

        this.pnlResorces.setLayout(new BorderLayout());

        ToolsSwingUtils.ensureRowsCols(this, 20, 150, 25, 200);

        doUpdateEnableComponents();

    }

    @Override

    public JComponent asJComponent() {

        return this;

    }

    public JDBCServerExplorerParameters getConnection() {

        JDBCServerExplorerParameters conn = this.connectionPicker.get();

        return conn;

    }

    private void doUpdateEnableComponents() {

        boolean theEnabled = this.getConnection() != null;

        this.repositoryTableController.setEnabled(theEnabled);

        this.resourcesTableController.setEnabled(theEnabled);

        this.configurationTableController.setEnabled(theEnabled);

        this.btnRepositoryAddTable.setEnabled(theEnabled);

        this.btnConnectToRepository.setEnabled(theEnabled);

    }

    private void doAddTableToRepository() {

        final RepositoryAddTablePanel panel = new RepositoryAddTablePanel();

        WindowManager_v2 winManager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

        final Dialog dialog = winManager.createDialog(

                panel,

                "Add table to repository",

                null,

                WindowManager_v2.BUTTONS_OK_CANCEL

        );

        dialog.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                if (dialog.getAction() == WindowManager_v2.BUTTON_OK) {

                    DataManager dataManager = DALLocator.getDataManager();

                    DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

                    for (LabeledValue<DataStoreParameters> p : panel.getDataStoreParameters()) {

                        if (p == null) {

                            continue;

                        }

                        if (!workspace.writeStoresRepositoryEntry(p.getLabel(), p.getValue())) {

                            LOGGER.warn("Can't add table '" + p.getLabel() + "' to repository");

                            // TODO: mensaje al usuario,no se ha podido crear

                        }

                    }

                }

            }

        });

        dialog.show(WindowManager.MODE.DIALOG);

    }

    private void doUpdateStoresRepositoryInfo() {

        DataManager dataManager = DALLocator.getDataManager();

        DataSwingManager dataSwingManager = DALSwingLocator.getDataSwingManager();

        DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

        String id = workspace.get(CONFIG_NAME_STORESREPOSITORYID);

        String label = workspace.get(CONFIG_NAME_STORESREPOSITORYLABEL);

        this.txtStoresRepositoryId.setText(StringUtils.defaultIfBlank(id, ""));

        this.txtStoresRepositoryLabel.setText(StringUtils.defaultIfBlank(label, ""));

        this.btnConnectToRepository.setEnabled(!StringUtils.isBlank(id));

        try {

            this.pnlConfiguration.removeAll();

            this.configurationSearch = dataSwingManager.createFeatureStoreSearchPanel(

                    workspace.getTable(DatabaseWorkspaceManager.TABLE_CONFIGURATION)

            );

            this.pnlConfiguration.add(this.configurationSearch.asJComponent(), BorderLayout.CENTER);

            this.configurationSearch.setFilterOnlyMode(true);

            this.configurationSearch.setShowActions(false);

//            this.configurationSearch.setAllowCollapseSearchCondition(true);

//            this.configurationSearch.setCollapseSearchCondition(true);

        } catch (Exception ex) {

        }

        try {

            this.pnlRepository.removeAll();

            this.repositorySearch = dataSwingManager.createFeatureStoreSearchPanel(

                    workspace.getTable(DatabaseWorkspaceManager.TABLE_REPOSITORY)

            );

            this.pnlRepository.add(this.repositorySearch.asJComponent(), BorderLayout.CENTER);

            this.repositorySearch.setFilterOnlyMode(true);

            this.repositorySearch.setShowActions(false);

//            this.repositorySearch.setAllowCollapseSearchCondition(true);

//            this.repositorySearch.setCollapseSearchCondition(true);

        } catch (Exception ex) {

        }

        try {

            this.pnlResorces.removeAll();

            this.resourcesSearch = dataSwingManager.createFeatureStoreSearchPanel(

                    workspace.getTable(DatabaseWorkspaceManager.TABLE_RESOURCES)

            );

            this.resourcesSearch.setFilterOnlyMode(true);

            this.resourcesSearch.setShowActions(false);

//            this.resourcesSearch.setAllowCollapseSearchCondition(true);

//            this.resourcesSearch.setCollapseSearchCondition(true);

            this.pnlResorces.add(this.resourcesSearch.asJComponent(), BorderLayout.CENTER);

        } catch (Exception ex) {

        }

        this.invalidate();

    }

    private void doConnectToRepository() {

        DataManager dataManager = DALLocator.getDataManager();

        DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

        StoresRepository repo = workspace.getStoresRepository();

        dataManager.getStoresRepository().addRepository(repo);

    }

    private void doShowParametersOfRepositoryTable() {

        try {

            DataManager dataManager = DALLocator.getDataManager();

            DataStoreParametersPanelManager manager = DALSwingLocator.getDataStoreParametersPanelManager();

            FeatureStore store = this.repositorySearch.getStore();

            Feature f = store.findFirst(this.repositorySearch.getFilterForSelectedFeature());

            if (f == null) {

                return;

            }

            String name = f.getString(DatabaseWorkspaceManager.FIELD_REPOSITORY_NAME);

            DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(getConnection());

            StoresRepository repository = workspace.getStoresRepository();

            DataStoreParameters parameters = repository.get(name);

            DataStoreParametersPanel panel = manager.createDataStoreParametersPanel(parameters);

            Dialog dialog = manager.createPropertiesDialog(parameters, panel);

            dialog.addActionListener((ActionEvent ae) -> {

                switch(ae.getID() ) {

                    case WindowManager_v2.BUTTON_APPLY:

                        manager.showAdvancedPropertiesDialog(parameters);

                        break;

                    case WindowManager_v2.BUTTON_OK:

                        panel.fetchParameters(parameters);

                        workspace.writeStoresRepositoryEntry(name, parameters);

                        break;

                    case WindowManager_v2.BUTTON_CANCEL:

                        break;

                }

            });

            dialog.show(WindowManager.MODE.WINDOW);

        } catch (Exception ex) {

            LOGGER.warn("Can't show parameters of repository table", ex);

        }

    }

    private void doFixRepositoryEntriesToSelectedConnection() {

        DataManager dataManager = DALLocator.getDataManager();

        I18nManager i18n = ToolsLocator.getI18nManager();

        JDBCServerExplorerParameters conn = getConnection();

        DatabaseWorkspaceManager workspace = dataManager.createDatabaseWorkspaceManager(conn);

        StoresRepository repository = workspace.getStoresRepository();

        int n = 0;

        for (String name : repository.keySet()) {

            DataStoreParameters params = repository.get(name);

            if( params instanceof JDBCStoreParameters ) {

                ((JDBCStoreParameters) params).setHost(conn.getHost());

                ((JDBCStoreParameters) params).setPort(conn.getPort());

                ((JDBCStoreParameters) params).setSchema(conn.getSchema());

                ((JDBCStoreParameters) params).setDBName(conn.getDBName());

                ((JDBCStoreParameters) params).setCatalog(conn.getCatalog());

                ((JDBCStoreParameters) params).setUser(conn.getUser());

                ((JDBCStoreParameters) params).setPassword(conn.getPassword());

                ((JDBCStoreParameters) params).setUrl(null);

                workspace.writeStoresRepositoryEntry(name, params);

                n++;

            }

        }

        ToolsSwingLocator.getThreadSafeDialogsManager().messageDialog(

                "Total updateds entries "+n, 

                i18n.getTranslation("_Manage_Dabatase_workspace"), 

                JOptionPane.INFORMATION_MESSAGE

        );

    }

}