/*FreeMind - A Program for creating and viewing Mindmaps
 *Copyright (C) 2000-2008  Joerg Mueller, Daniel Polansky, Christian Foltin and others.
 *
 *See COPYING for Details
 *
 *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 2
 *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., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 * Created on 28.12.2008
 */


package plugins.collaboration.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Collection;
import java.util.Iterator;
import java.util.Vector;

import freemind.common.NumberProperty;
import freemind.common.StringProperty;
import freemind.extensions.PermanentNodeHook;
import freemind.modes.mindmapmode.MindMapController;

/**
 * @author foltin
 * 
 */
public class DatabaseConnector extends DatabaseBasics {

	private static final String HOST_PROPERTY = "plugins.collaboration.database.host";

	/**
     *
     */

	public void startupMapHook() {
		super.startupMapHook();
		MindMapController controller = getMindMapController();
		try {
			DatabaseConnectionHook connectionHook = isConnected();
			if (connectionHook != null) {
				// I'm already present, so remove me.
				logger.info("Deregister filter, so that the hook isn't reported to the database.");
				UpdateThread updateThread = connectionHook.getUpdateThread();
				updateThread.deregisterFilter();
				updateThread.removeUser();
				logger.info("Shutting down the permanent hook.");
				togglePermanentHook(controller);
				return;
			}
			logger.info("Connect...");
			Class.forName("org.hsqldb.jdbcDriver");
			StringProperty passwordProperty = new StringProperty(
					PASSWORD_DESCRIPTION, PASSWORD);
			StringProperty hostProperty = new StringProperty(HOST_DESCRIPTION,
					HOST);
			NumberProperty portProperty = getPortProperty();
			// get last value
			hostProperty.setValue(controller.getFrame().getProperty(
					HOST_PROPERTY));
			Vector controls = new Vector();
			controls.add(passwordProperty);
			controls.add(hostProperty);
			controls.add(portProperty);
			FormDialog dialog = new FormDialog(controller);
			dialog.setUp(controls);
			if (!dialog.isSuccess())
				return;
			setPortProperty(portProperty);
			// store value for next time.
			controller.getFrame().setProperty(HOST_PROPERTY,
					hostProperty.getValue());
			String password = passwordProperty.getValue();
			Connection connection = DriverManager.getConnection(
					"jdbc:hsqldb:hsql://" + hostProperty.getValue() + ":"
							+ portProperty.getValue() + "/xdb", "sa", password);
			logger.info("Starting update thread...");
			mUpdateThread = new UpdateThread(connection, controller);
			mUpdateThread.setPort(portProperty.getValue());
			mUpdateThread.setHost(hostProperty.getValue());
			mUpdateThread.insertUser();
			mUpdateThread.start();
		} catch (Exception e) {
			freemind.main.Resources.getInstance().logException(e);
			// TODO: Need a better message here.
			controller.getController().errorMessage(e.getLocalizedMessage());
			return;
		}
	}

	private DatabaseConnectionHook isConnected() {
		Collection activatedHooks = getMindMapController().getRootNode()
				.getActivatedHooks();
		for (Iterator it = activatedHooks.iterator(); it.hasNext();) {
			PermanentNodeHook hook = (PermanentNodeHook) it.next();
			if (hook instanceof DatabaseConnectionHook) {
				return (DatabaseConnectionHook) hook;
			}
		}
		return null;
	}

	public Integer getRole() {
		return ROLE_SLAVE;
	}

}