OracleObjectCompileAction.java

/*******************************************************************************
 * Copyright (c) 2013 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.rdb.core.actions.object.rdb.object;

import org.apache.log4j.Logger;
import org.eclipse.core.runtime.IStatus;
import org.eclipse.core.runtime.Status;
import org.eclipse.jface.dialogs.MessageDialog;
import org.eclipse.jface.viewers.IStructuredSelection;
import org.eclipse.ui.IWorkbenchWindow;

import com.hangum.tadpole.commons.exception.dialog.ExceptionDetailsErrorDialog;
import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine.OBJECT_TYPE;
import com.hangum.tadpole.commons.libs.core.message.CommonMessages;
import com.hangum.tadpole.engine.define.DBGroupDefine;
import com.hangum.tadpole.engine.query.dao.mysql.ProcedureFunctionDAO;
import com.hangum.tadpole.engine.query.dao.mysql.TableDAO;
import com.hangum.tadpole.engine.query.dao.mysql.TriggerDAO;
import com.hangum.tadpole.engine.query.dao.rdb.OracleJavaDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.sql.util.OracleObjectCompileUtils;
import com.hangum.tadpole.rdb.core.Activator;
import com.hangum.tadpole.rdb.core.Messages;
import com.hangum.tadpole.rdb.core.actions.object.AbstractObjectSelectAction;
import com.hangum.tadpole.rdb.core.dialog.msg.TDBInfoDialog;

/**
 * Object Explorer에서 사용하는 공통 action
 * 
 * @author hangum
 *
 */
public class OracleObjectCompileAction extends AbstractObjectSelectAction {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(OracleObjectCompileAction.class);

	public final static String ID = "com.hangum.db.browser.rap.core.actions.object.compile"; //$NON-NLS-1$
	
	public OracleObjectCompileAction(IWorkbenchWindow window, PublicTadpoleDefine.OBJECT_TYPE actionType, String title) {
		super(window, actionType);
		setId(ID + actionType.toString());
		setText(title);
		window.getSelectionService().addSelectionListener(this);
	}

	@Override
	public void run(IStructuredSelection selection, UserDBDAO userDB, OBJECT_TYPE actionType) {
		if (DBGroupDefine.ORACLE_GROUP != userDB.getDBGroup()) return;
		
		if(actionType == PublicTadpoleDefine.OBJECT_TYPE.TABLES) {			
			
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.VIEWS) {
			TableDAO tableDao = (TableDAO)selection.getFirstElement();
			viewCompile(tableDao, userDB);	
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.INDEXES) {
		
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.PROCEDURES) {
			ProcedureFunctionDAO dao = (ProcedureFunctionDAO)selection.getFirstElement();
			otherObjectCompile(PublicTadpoleDefine.QUERY_DDL_TYPE.PROCEDURE, "PROCEDURE", dao.getName(), userDB);			 //$NON-NLS-1$
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.PACKAGES) {
			packageCompile((ProcedureFunctionDAO)selection.getFirstElement(), userDB);
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.FUNCTIONS) {
			ProcedureFunctionDAO dao = (ProcedureFunctionDAO)selection.getFirstElement();
			otherObjectCompile(PublicTadpoleDefine.QUERY_DDL_TYPE.FUNCTION, "FUNCTION",  dao.getName(), userDB);			 //$NON-NLS-1$
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.TRIGGERS) {
			TriggerDAO dao = (TriggerDAO)selection.getFirstElement();
			otherObjectCompile(PublicTadpoleDefine.QUERY_DDL_TYPE.TRIGGER, "TRIGGER",  dao.getName(), userDB);			 //$NON-NLS-1$
		} else if(actionType == PublicTadpoleDefine.OBJECT_TYPE.JAVA) {
			OracleJavaDAO dao = (OracleJavaDAO)selection.getFirstElement();
			otherObjectCompile(PublicTadpoleDefine.QUERY_DDL_TYPE.JAVA, dao.getObjectType(),  dao.getObjectName(), userDB);			 //$NON-NLS-1$
		}
	}
	
	/**
	 * view compile
	 * 
	 * @param tableDao
	 * @param userDB
	 */
	public void viewCompile(TableDAO tableDao, UserDBDAO userDB) {
		try {
			String result = OracleObjectCompileUtils.viewCompile(tableDao.getFullName(), userDB);
			showMessage(result);
			
		} catch (Exception e) {
			logger.error(tableDao.getName() + " compile", e); //$NON-NLS-1$
			
			Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
			ExceptionDetailsErrorDialog.openError(null,CommonMessages.get().Error, tableDao.getName() + Messages.get().OracleObjectCompileAction_5, errStatus); //$NON-NLS-1$
		} finally {
			refreshObject(PublicTadpoleDefine.QUERY_DDL_TYPE.VIEW, tableDao.getName(), userDB);
		}
	}
	
	/**
	 * other object compile
	 * 
	 * @param actionType 
	 * @param objType
	 * @param objName
	 * @param userDB
	 */
	public void otherObjectCompile(PublicTadpoleDefine.QUERY_DDL_TYPE actionType, String objType, String objName, UserDBDAO userDB) {
		try {
			String result = OracleObjectCompileUtils.otherObjectCompile(actionType, objType, objName, userDB);
			showMessage(result);
			
		} catch (Exception e) {
			logger.error(objName + " compile", e); //$NON-NLS-1$
			
			Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
			ExceptionDetailsErrorDialog.openError(null,CommonMessages.get().Error, objName + Messages.get().OracleObjectCompileAction_5, errStatus); //$NON-NLS-1$
		} finally {
			refreshObject(actionType, objName, userDB);
		}
	}
	
	/**
	 * package compile
	 * 
	 * @param procedureDAO
	 * @param userDB
	 */
	public void packageCompile(ProcedureFunctionDAO procedureDAO, UserDBDAO userDB) {
		try {
			String result = OracleObjectCompileUtils.packageCompile(procedureDAO.getFullName(), userDB);
			showMessage(result);
			
		} catch (Exception e) {
			logger.error(procedureDAO.getName() + " compile", e); //$NON-NLS-1$
			
			Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
			ExceptionDetailsErrorDialog.openError(null,CommonMessages.get().Error, procedureDAO.getName() + Messages.get().OracleObjectCompileAction_5, errStatus); //$NON-NLS-1$
		} finally {
			refreshObject(PublicTadpoleDefine.QUERY_DDL_TYPE.PACKAGE, procedureDAO.getName(), userDB);
		}
	}
	
	/**
	 * show message
	 * 
	 * @param result
	 */
	private void showMessage(String result) {
		if("".equals(result)) { //$NON-NLS-1$
			MessageDialog.openInformation(null, Messages.get().OracleObjectCompileAction_11, Messages.get().OracleObjectCompileAction_12);
		} else {
			TDBInfoDialog dialog = new TDBInfoDialog(null, Messages.get().OracleObjectCompileAction_13, result);
			dialog.open();
		}
	}
	
}