org.polymap.biotop.model.importer.MdbImportPage.java Source code

Introduction

Here is the source code for org.polymap.biotop.model.importer.MdbImportPage.java

Source

/*
 * polymap.org
 * Copyright 2011, Falko Brutigam, and other contributors as
 * indicated by the @authors tag. All rights reserved.
 *
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 2.1 of
 * the License, or (at your option) any later version.
 *
 * This software 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
 * Lesser General Public License for more details.
 */
package org.polymap.biotop.model.importer;

import java.util.TreeSet;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.log4j.lf5.util.StreamUtils;

import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.Table;

import org.eclipse.swt.SWT;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.layout.FormAttachment;
import org.eclipse.swt.layout.FormData;
import org.eclipse.swt.layout.FormLayout;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.List;

import org.eclipse.rwt.widgets.Upload;
import org.eclipse.rwt.widgets.UploadEvent;
import org.eclipse.rwt.widgets.UploadItem;
import org.eclipse.rwt.widgets.UploadListener;

import org.eclipse.jface.wizard.IWizardPage;
import org.eclipse.jface.wizard.WizardPage;

import org.polymap.core.data.DataPlugin;
import org.polymap.core.runtime.Polymap;
import org.polymap.core.workbench.PolymapWorkbench;

/**
 *
 *
 * @author <a href="http://www.polymap.de">Falko Brutigam</a>
 */
public class MdbImportPage extends WizardPage implements IWizardPage, UploadListener {

    private static Log log = LogFactory.getLog(MdbImportPage.class);

    public static final String ID = "MdbImportPage";

    File dbFile;

    String[] tableNames;

    private Upload upload;

    private List tablesList;

    protected MdbImportPage() {
        super(ID);
        setTitle("Datenbank-Datei auswhlen.");
        setDescription("Whlen Sie eine *.mdb Datei fr den Import aus.");
    }

    public void createControl(Composite parent) {
        Composite fileSelectionArea = new Composite(parent, SWT.NONE);
        FormLayout layout = new FormLayout();
        layout.spacing = 5;
        fileSelectionArea.setLayout(layout);

        upload = new Upload(fileSelectionArea, SWT.BORDER, /*Upload.SHOW_PROGRESS |*/ Upload.SHOW_UPLOAD_BUTTON);
        upload.setBrowseButtonText("Datei");
        upload.setUploadButtonText("Laden");
        upload.addUploadListener(this);
        FormData data = new FormData();
        data.left = new FormAttachment(0);
        data.right = new FormAttachment(100);
        upload.setLayoutData(data);

        tablesList = new List(fileSelectionArea, SWT.BORDER | SWT.MULTI | SWT.V_SCROLL);
        data = new FormData();
        data.top = new FormAttachment(upload);
        data.bottom = new FormAttachment(100);
        data.left = new FormAttachment(0);
        data.right = new FormAttachment(100);
        tablesList.setLayoutData(data);
        tablesList.addSelectionListener(new SelectionAdapter() {
            public void widgetSelected(SelectionEvent ev) {
                tableNames = tablesList.getSelection();

                try {
                    Database db = Database.open(dbFile);
                    for (String name : tableNames) {
                        Table table = db.getTable(name);
                        MdbImportOperation.printSchema(table);
                    }
                    db.close();
                } catch (IOException e) {
                    throw new RuntimeException(e);
                }
                checkFinish();
            }
        });
        tablesList.setLayoutData(data);

        setControl(fileSelectionArea);
        checkFinish();
    }

    protected void checkFinish() {
        setPageComplete(dbFile != null && tableNames != null && tableNames.length > 0);
        getWizard().getContainer().updateButtons();
    }

    // UploadListener *************************************

    public void uploadInProgress(UploadEvent ev) {
    }

    public void uploadFinished(UploadEvent ev) {
        UploadItem item = upload.getUploadItem();
        try {
            log.info("Uploaded: " + item.getFileName() + ", path=" + item.getFilePath());

            File uploadDir = Polymap.getWorkspacePath().toFile();
            dbFile = new File(uploadDir, item.getFileName());
            FileOutputStream out = new FileOutputStream(dbFile);
            StreamUtils.copyThenClose(item.getFileInputStream(), out);
            log.info("### copied to: " + dbFile);

            Database db = Database.open(dbFile);
            log.info("Tables: " + db.getTableNames());

            TreeSet<String> sorted = new TreeSet<String>(db.getTableNames());
            tablesList.setItems(sorted.toArray(new String[sorted.size()]));
            db.close();
        } catch (IOException e) {
            PolymapWorkbench.handleError(DataPlugin.PLUGIN_ID, MdbImportPage.this, "Fehler beim Upload der Daten.",
                    e);
        }
        checkFinish();
    }

}