org.polymap.kaps.importer.MdbImportPage.java Source code

Introduction

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

Source

/*
 * polymap.org Copyright 2013 Polymap GmbH. 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.kaps.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.Column;
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">Steffen Stundzig</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 zum importieren 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("Browse");
        upload.setUploadButtonText("Upload");
        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);
                        printSchema(table);
                    }
                    db.close();
                } catch (IOException e) {
                    throw new RuntimeException(e);
                }
                checkFinish();
            }
        });
        tablesList.setLayoutData(data);

        setControl(fileSelectionArea);
        checkFinish();
    }

    public static void printSchema(Table table) {
        log.info("Table: " + table.getName());
        for (Column col : table.getColumns()) {
            log.info("\n\n// TODO " + col.getName() + " - " + col.getType());
            log.info("@Optional");
            log.info("@ImportColumn(\"" + col.getName() + "\")");
            log.info("Property<" + col.getType() + "> " + col.getName() + "();");
        }
    }

    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();
    }

}