/*
 *  RapidMiner
 *
 *  Copyright (C) 2001-2011 by Rapid-I and the contributors
 *
 *  Complete list of developers available at our web site:
 *
 *       http://rapid-i.com
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU Affero 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 Affero General Public License for more details.
 *
 *  You should have received a copy of the GNU Affero General Public License
 *  along with this program.  If not, see http://www.gnu.org/licenses/.
 */
package com.rapidminer.gui.tools.dialogs.wizards.dataimport;

import java.io.File;
import java.sql.SQLException;

import com.rapidminer.example.ExampleSet;
import com.rapidminer.gui.RapidMinerGUI;
import com.rapidminer.gui.tools.ProgressThread;
import com.rapidminer.gui.tools.SwingTools;
import com.rapidminer.gui.tools.dialogs.wizards.AbstractWizard;
import com.rapidminer.gui.tools.dialogs.wizards.dataimport.access.AccessImportWizard;
import com.rapidminer.operator.OperatorException;
import com.rapidminer.operator.io.AbstractExampleSource;
import com.rapidminer.operator.nio.CSVImportWizard;
import com.rapidminer.operator.nio.ExcelImportWizard;
import com.rapidminer.repository.RepositoryException;
import com.rapidminer.repository.RepositoryLocation;
import com.rapidminer.repository.RepositoryManager;
import com.rapidminer.tools.ProgressListener;

/**
 * @author Tobias Malbrecht
 */
public class DataImportWizard extends AbstractWizard {
    private static final long serialVersionUID = 6361602131820283501L;

    public DataImportWizard(String key, Object... arguments) {
        super(RapidMinerGUI.getMainFrame(), key, arguments);
    }

    protected boolean transferData(final AbstractExampleSource reader, final String repositoryLocationPath) {
        if (repositoryLocationPath == null) {
            return false;
        }
        final RepositoryLocation location;
        try {
            location = new RepositoryLocation(repositoryLocationPath);
        } catch (Exception e) {
            SwingTools.showSimpleErrorMessage("malformed_rep_location", e, repositoryLocationPath);
            return false;
        }

        ProgressThread t = new ProgressThread("import_data", true) {
            @Override
            public void run() {
                ProgressListener l = getProgressListener();
                l.setTotal(100);
                l.setCompleted(10);
                ExampleSet exampleSet;
                try {
                    exampleSet = reader.createExampleSet();
                } catch (OperatorException e) {
                    SwingTools.showSimpleErrorMessage("could not read from access file", e);
                    return;
                }

                l.setCompleted(55);
                try {
                    RepositoryManager.getInstance(null).store(exampleSet, location, null);
                    l.setCompleted(95);
                } catch (RepositoryException ex) {
                    SwingTools.showSimpleErrorMessage("cannot_store_obj_at_location", ex, repositoryLocationPath);
                    return;
                }
                l.setCompleted(100);
            }
        };
        t.start();
        return true;
    }

    public static void importData(File file, RepositoryLocation location) {
        try {
            int dot = file.getName().lastIndexOf('.');
            if (dot != -1) {
                String extension = file.getName().substring(dot + 1);
                if ("csv".equals(extension)) {
                    new CSVImportWizard(file, location).setVisible(true);
                } else if ("xls".equals(extension)) {
                    new ExcelImportWizard(file, location).setVisible(true);
                } else if ("mdb".equals(extension)) {
                    try {
                        new AccessImportWizard("import_access_table", file, location).setVisible(true);
                    } catch (SQLException e) {
                        SwingTools.showSimpleErrorMessage("db_connection_failed_simple", e, e.getMessage());
                    }
                } else {
                    SwingTools.showVerySimpleErrorMessage("importwizard.filetype_not_supported", extension);
                }
            } else {
                SwingTools.showVerySimpleErrorMessage("importwizard.filetype_not_supported", file.getName());
            }
        } catch (OperatorException e) {
            SwingTools.showSimpleErrorMessage("importwizard.unknown_error", e, e.getMessage());
        }
    }
}