Example usage for org.eclipse.jface.dialogs MessageDialog openConfirm

List of usage examples for org.eclipse.jface.dialogs MessageDialog openConfirm

  1. HOME
  2. Java
  3. org.eclipse.jface
  4. org.eclipse.jface.dialogs.*
  5. MessageDialog
  6. openConfirm

Introduction

In this page you can find the example usage for org.eclipse.jface.dialogs MessageDialog openConfirm.

Prototype

public static boolean openConfirm(Shell parent, String title, String message)

Source Link

Document

Convenience method to open a simple confirm (OK/Cancel) dialog.

Usage

From source file:com.hangum.tadpole.rdb.core.actions.object.ObjectDeleteAction.java

License:Open Source License

@Override
public void run() {

    if (actionType == DB_ACTION.TABLES) {
        TableDAO dao = (TableDAO) sel.getFirstElement();

        if (DBDefine.getDBDefine(userDB.getTypes()) != DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_2,
                    dao.getName() + Messages.ObjectDeleteAction_3)) {
                try {
                    TadpoleSystemCommons.executSQL(getUserDB(), "drop table " + dao.getName()); //$NON-NLS-1$
                    refreshTable();//w w  w. j  av  a  2 s  .  co m
                } catch (Exception e) {
                    logger.error(Messages.ObjectDeleteAction_5, e);
                    exeMessage(Messages.ObjectDeleteAction_0, e);
                }
            }

        } else if (DBDefine.getDBDefine(userDB.getTypes()) == DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_2,
                    dao.getName() + Messages.ObjectDeleteAction_3)) {
                try {
                    MongoDBQuery.dropCollection(getUserDB(), dao.getName());
                    refreshTable();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == DB_ACTION.VIEWS) {

        String viewName = (String) sel.getFirstElement();
        if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_8,
                viewName + Messages.ObjectDeleteAction_9)) {
            try {
                TadpoleSystemCommons.executSQL(getUserDB(), "drop view " + viewName); //$NON-NLS-1$

                refreshView();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_11, e);
                exeMessage(Messages.ObjectDeleteAction_1, e);
            }
        }
    } else if (actionType == DB_ACTION.INDEXES) {
        if (sel.getFirstElement() instanceof InformationSchemaDAO) {
            InformationSchemaDAO indexDAO = (InformationSchemaDAO) sel.getFirstElement();
            if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_14,
                    indexDAO.getTABLE_NAME() + Messages.ObjectDeleteAction_15 + indexDAO.getINDEX_NAME()
                            + Messages.ObjectDeleteAction_16)) {

                try {
                    if (DBDefine.getDBDefine(userDB.getTypes()) != DBDefine.POSTGRE_DEFAULT) {
                        TadpoleSystemCommons.executSQL(getUserDB(),
                                "drop index " + indexDAO.getINDEX_NAME() + " on " + indexDAO.getTABLE_NAME()); //$NON-NLS-1$ //$NON-NLS-2$
                    } else {
                        TadpoleSystemCommons.executSQL(getUserDB(),
                                "drop index " + indexDAO.getINDEX_NAME() + ";"); //$NON-NLS-1$ //$NON-NLS-2$
                    }

                    refreshIndexes();
                } catch (Exception e) {
                    logger.error(Messages.ObjectDeleteAction_19, e);
                    exeMessage(Messages.ObjectDeleteAction_4, e);
                }
            }
        } else {
            MongoDBIndexDAO indexDAO = (MongoDBIndexDAO) sel.getFirstElement();
            if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_14,
                    indexDAO.getNs() + " [ " + indexDAO.getName() + "] " + Messages.ObjectDeleteAction_16)) { //$NON-NLS-1$ //$NON-NLS-2$
                try {
                    MongoDBQuery.dropIndex(getUserDB(), indexDAO.getNs(), indexDAO.getName());
                    refreshIndexes();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == DB_ACTION.PROCEDURES) {
        ProcedureFunctionDAO procedureDAO = (ProcedureFunctionDAO) sel.getFirstElement();
        if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_23,
                procedureDAO.getName() + Messages.ObjectDeleteAction_24)) {
            try {
                TadpoleSystemCommons.executSQL(getUserDB(), "drop procedure " + procedureDAO.getName()); //$NON-NLS-1$

                refreshProcedure();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_26, e);
                exeMessage(Messages.ObjectDeleteAction_10, e);
            }
        }
    } else if (actionType == DB_ACTION.FUNCTIONS) {
        ProcedureFunctionDAO functionDAO = (ProcedureFunctionDAO) sel.getFirstElement();
        if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_29,
                functionDAO.getName() + Messages.ObjectDeleteAction_30)) {
            try {
                TadpoleSystemCommons.executSQL(getUserDB(), "drop function " + functionDAO.getName()); //$NON-NLS-1$

                refreshFunction();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_32, e);
                exeMessage(Messages.ObjectDeleteAction_17, e);
            }
        }
    } else if (actionType == DB_ACTION.TRIGGERS) {
        TriggerDAO triggerDAO = (TriggerDAO) sel.getFirstElement();
        if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_35,
                triggerDAO.getTrigger() + Messages.ObjectDeleteAction_36)) {
            try {
                TadpoleSystemCommons.executSQL(getUserDB(), "drop trigger " + triggerDAO.getTrigger()); //$NON-NLS-1$

                refreshTrigger();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_38, e);
                exeMessage(Messages.ObjectDeleteAction_18, e);
            }
        }
    } else if (actionType == DB_ACTION.JAVASCRIPT) {
        MongoDBServerSideJavaScriptDAO jsDAO = (MongoDBServerSideJavaScriptDAO) sel.getFirstElement();
        if (MessageDialog.openConfirm(window.getShell(), Messages.ObjectDeleteAction_35,
                jsDAO.getName() + Messages.ObjectDeleteAction_42)) {
            try {
                MongoDBQuery.deleteJavaScirpt(userDB, jsDAO.getName());
                refreshJS();
            } catch (Exception e) {
                logger.error("MongoDB ServerSide JavaScript delelte", e); //$NON-NLS-1$
                exeMessage("JavaScript", e); //$NON-NLS-1$
            }
        }
    }

}

From source file:com.hangum.tadpole.rdb.core.actions.object.rdb.object.ObjectDeleteAction.java

License:Open Source License

@Override
public void run(IStructuredSelection selection, UserDBDAO userDB, DB_ACTION actionType) {
    if (actionType == PublicTadpoleDefine.DB_ACTION.TABLES) {
        TableDAO dao = (TableDAO) selection.getFirstElement();

        if (userDB.getDBDefine() != DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_2,
                    Messages.ObjectDeleteAction_3)) {
                String strSQL = "drop table " + dao.getSysName();
                try {
                    if (DBDefine.TAJO_DEFAULT == userDB.getDBDefine()) {
                        new TajoConnectionManager().executeUpdate(userDB, strSQL);
                    } else {
                        TadpoleSystemCommons.executSQL(userDB, strSQL); //$NON-NLS-1$
                    }/*from w  ww .java2s  .c o m*/

                    //
                    TadpoleSystem_SchemaHistory.save(SessionManager.getSeq(), userDB, strSQL);

                    refreshTable();
                } catch (Exception e) {
                    logger.error(Messages.ObjectDeleteAction_5, e);
                    exeMessage(Messages.ObjectDeleteAction_0, e);
                }
            }

        } else if (userDB.getDBDefine() == DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_2,
                    Messages.ObjectDeleteAction_3)) {
                try {
                    MongoDBQuery.dropCollection(userDB, dao.getName());
                    refreshTable();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.VIEWS) {

        String viewName = (String) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_8,
                Messages.ObjectDeleteAction_9)) {
            try {
                TadpoleSystemCommons.executSQL(userDB, "drop view " + viewName); //$NON-NLS-1$

                refreshView();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_11, e);
                exeMessage(Messages.ObjectDeleteAction_1, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.SYNONYM) {

        OracleSynonymDAO dao = (OracleSynonymDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_8,
                Messages.ObjectDeleteAction_synonym)) {
            try {
                TadpoleSystemCommons.executSQL(userDB,
                        "drop synonym " + dao.getTable_owner() + "." + dao.getSynonym_name()); //$NON-NLS-1$

                refreshSynonym();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_11, e);
                exeMessage(Messages.ObjectDeleteAction_1, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.INDEXES) {
        if (selection.getFirstElement() instanceof InformationSchemaDAO) {
            InformationSchemaDAO indexDAO = (InformationSchemaDAO) selection.getFirstElement();
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_14,
                    Messages.ObjectDeleteAction_16)) {

                try {
                    if (userDB.getDBDefine() != DBDefine.POSTGRE_DEFAULT) {
                        TadpoleSystemCommons.executSQL(userDB,
                                "drop index " + indexDAO.getINDEX_NAME() + " on " + indexDAO.getTABLE_NAME()); //$NON-NLS-1$ //$NON-NLS-2$
                    } else {
                        TadpoleSystemCommons.executSQL(userDB, "drop index " + indexDAO.getINDEX_NAME() + ";"); //$NON-NLS-1$ //$NON-NLS-2$
                    }

                    refreshIndexes();
                } catch (Exception e) {
                    logger.error(Messages.ObjectDeleteAction_19, e);
                    exeMessage(Messages.ObjectDeleteAction_4, e);
                }
            }
        } else {
            MongoDBIndexDAO indexDAO = (MongoDBIndexDAO) selection.getFirstElement();
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_14,
                    Messages.ObjectDeleteAction_16)) { //$NON-NLS-1$ //$NON-NLS-2$
                try {
                    MongoDBQuery.dropIndex(userDB, indexDAO.getNs(), indexDAO.getName());
                    refreshIndexes();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.PROCEDURES) {
        ProcedureFunctionDAO procedureDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_23,
                Messages.ObjectDeleteAction_24)) {
            try {
                TadpoleSystemCommons.executSQL(userDB, "drop procedure " + procedureDAO.getName()); //$NON-NLS-1$

                refreshProcedure();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_26, e);
                exeMessage(Messages.ObjectDeleteAction_10, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.PACKAGES) {
        ProcedureFunctionDAO procedureDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_23,
                Messages.ObjectDeleteAction_24)) {
            try {
                try {
                    TadpoleSystemCommons.executSQL(userDB, "drop package body " + procedureDAO.getName()); //$NON-NLS-1$
                } catch (Exception e) {
                    // package body ? ? ?.
                }
                TadpoleSystemCommons.executSQL(userDB, "drop package " + procedureDAO.getName()); //$NON-NLS-1$

                refreshPackage();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_26, e);
                exeMessage(Messages.ObjectDeleteAction_10, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.FUNCTIONS) {
        ProcedureFunctionDAO functionDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_29,
                Messages.ObjectDeleteAction_30)) {
            try {
                TadpoleSystemCommons.executSQL(userDB, "drop function " + functionDAO.getName()); //$NON-NLS-1$

                refreshFunction();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_32, e);
                exeMessage(Messages.ObjectDeleteAction_17, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.TRIGGERS) {
        TriggerDAO triggerDAO = (TriggerDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_35,
                Messages.ObjectDeleteAction_36)) {
            try {
                TadpoleSystemCommons.executSQL(userDB, "drop trigger " + triggerDAO.getTrigger()); //$NON-NLS-1$

                refreshTrigger();
            } catch (Exception e) {
                logger.error(Messages.ObjectDeleteAction_38, e);
                exeMessage(Messages.ObjectDeleteAction_18, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.DB_ACTION.JAVASCRIPT) {
        MongoDBServerSideJavaScriptDAO jsDAO = (MongoDBServerSideJavaScriptDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.ObjectDeleteAction_35,
                Messages.ObjectDeleteAction_42)) {
            try {
                MongoDBQuery.deleteJavaScirpt(userDB, jsDAO.getName());
                refreshJS();
            } catch (Exception e) {
                logger.error("MongoDB ServerSide JavaScript delelte", e); //$NON-NLS-1$
                exeMessage("JavaScript", e); //$NON-NLS-1$
            }
        }
    }

}

From source file:com.hangum.tadpole.rdb.core.actions.object.rdb.object.ObjectDropAction.java

License:Open Source License

@Override
public void run(IStructuredSelection selection, UserDBDAO userDB, OBJECT_TYPE actionType) {
    try {/*  w  w w  .  jav a 2 s  .co m*/
        if (!GrantCheckerUtils.ifExecuteQuery(userDB))
            return;
    } catch (Exception e) {
        MessageDialog.openError(getWindow().getShell(), Messages.get().Error, e.getMessage());
        return;
    }

    if (actionType == PublicTadpoleDefine.OBJECT_TYPE.TABLES) {
        TableDAO dao = (TableDAO) selection.getFirstElement();

        if (userDB.getDBDefine() != DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                    Messages.get().ObjectDeleteAction_3)) {
                for (Object selObjec : selection.toList()) {
                    TableDAO selTableDao = (TableDAO) selObjec;
                    String strSQL = "drop table " + SQLUtil.getTableName(userDB, selTableDao);// dao.getSysName(); //$NON-NLS-1$
                    try {
                        if (DBDefine.TAJO_DEFAULT == userDB.getDBDefine()) {
                            new TajoConnectionManager().executeUpdate(userDB, strSQL);
                        } else {
                            executeSQL(userDB, strSQL);
                        }
                    } catch (Exception e) {
                        logger.error("drop table", e);
                        exeMessage(Messages.get().ObjectDeleteAction_0, e);
                    }
                }

                refreshTable();
            }

        } else if (userDB.getDBDefine() == DBDefine.MONGODB_DEFAULT) {
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                    Messages.get().ObjectDeleteAction_3)) {
                try {
                    MongoDBQuery.dropCollection(userDB, dao.getName());
                    refreshTable();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.VIEWS) {

        TableDAO viewDao = (TableDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_9)) {
            try {
                executeSQL(userDB, "drop view " + viewDao.getSysName()); //$NON-NLS-1$

                refreshView();
            } catch (Exception e) {
                logger.error("drop view", e);
                exeMessage(Messages.get().ObjectDeleteAction_1, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.SYNONYM) {

        OracleSynonymDAO dao = (OracleSynonymDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_synonym)) {
            try {
                executeSQL(userDB, "drop synonym " + dao.getTable_owner() + "." + dao.getSynonym_name()); //$NON-NLS-1$ //$NON-NLS-2$

                refreshSynonym();
            } catch (Exception e) {
                logger.error("drop synoym", e);
                exeMessage(Messages.get().ObjectDeleteAction_1, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.INDEXES) {
        if (selection.getFirstElement() instanceof InformationSchemaDAO) {
            InformationSchemaDAO indexDAO = (InformationSchemaDAO) selection.getFirstElement();
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                    Messages.get().ObjectDeleteAction_16)) {

                try {
                    if (userDB.getDBDefine() != DBDefine.POSTGRE_DEFAULT
                            || userDB.getDBDefine() == DBDefine.ALTIBASE_DEFAULT) {
                        executeSQL(userDB,
                                "drop index " + indexDAO.getINDEX_NAME() + " on " + indexDAO.getTABLE_NAME()); //$NON-NLS-1$ //$NON-NLS-2$
                    } else {
                        executeSQL(userDB, "drop index " + indexDAO.getINDEX_NAME() + ";"); //$NON-NLS-1$ //$NON-NLS-2$
                    }

                    refreshIndexes();
                } catch (Exception e) {
                    logger.error("Delete index", e);
                    exeMessage(Messages.get().ObjectDeleteAction_4, e);
                }
            }
        } else {
            MongoDBIndexDAO indexDAO = (MongoDBIndexDAO) selection.getFirstElement();
            if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                    Messages.get().ObjectDeleteAction_16)) { //$NON-NLS-1$ //$NON-NLS-2$
                try {
                    MongoDBQuery.dropIndex(userDB, indexDAO.getNs(), indexDAO.getName());
                    refreshIndexes();
                } catch (Exception e) {
                    logger.error("Collection Delete", e); //$NON-NLS-1$
                    exeMessage("Collection", e); //$NON-NLS-1$
                }
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.CONSTRAINTS) {
        TableConstraintsDAO constraintDAO = (TableConstraintsDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                "Do you want to drop Constraints?")) {

            try {
                if (userDB.getDBDefine() != DBDefine.POSTGRE_DEFAULT
                        || userDB.getDBDefine() == DBDefine.ALTIBASE_DEFAULT) {
                    executeSQL(userDB, "drop constraints " + constraintDAO.getCONSTRAINT_NAME() + " on " //$NON-NLS-1$//$NON-NLS-2$
                            + constraintDAO.getTABLE_NAME());
                } else {
                    executeSQL(userDB, "drop constraints " + constraintDAO.getCONSTRAINT_NAME() + ";"); //$NON-NLS-1$ //$NON-NLS-2$
                }

                this.refreshConstraints();
            } catch (Exception e) {
                logger.error("Delete constraints", e);
                exeMessage("CONSTRAINTS", e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.PROCEDURES) {
        ProcedureFunctionDAO procedureDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_24)) {

            try {
                if (userDB.getDBDefine() == DBDefine.POSTGRE_DEFAULT) {
                    StringBuffer sbQuery = new StringBuffer("drop function " + procedureDAO.getName() + "(");

                    ProcedureExecuterManager pm = new ProcedureExecuterManager(userDB, procedureDAO);
                    pm.isExecuted(procedureDAO, userDB);
                    List<InOutParameterDAO> inList = pm.getExecuter().getInParameters();
                    InOutParameterDAO inOutParameterDAO = inList.get(0);
                    String[] inParams = StringUtils.split(inOutParameterDAO.getRdbType(), ",");
                    for (int i = 0; i < inParams.length; i++) {
                        String name = StringUtils.trimToEmpty(inParams[i]);

                        if (i == (inParams.length - 1))
                            sbQuery.append(String.format("%s", name));
                        else
                            sbQuery.append(String.format("%s, ", name));
                    }
                    sbQuery.append(")");
                    if (logger.isDebugEnabled())
                        logger.debug("=[PROCEDURES]===> " + sbQuery);

                    executeSQL(userDB, sbQuery.toString()); //$NON-NLS-1$
                } else {
                    executeSQL(userDB, "drop procedure " + procedureDAO.getName()); //$NON-NLS-1$
                }

                refreshProcedure();
            } catch (Exception e) {
                logger.error("drop procedure", e);
                exeMessage(Messages.get().ObjectDeleteAction_10, e);
            }

        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.PACKAGES) {
        ProcedureFunctionDAO procedureDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDropAction_1)) {
            try {
                try {
                    executeSQL(userDB, "drop package body " + procedureDAO.getName()); //$NON-NLS-1$
                } catch (Exception e) {
                    // package body ? ? ?.
                }
                executeSQL(userDB, "drop package " + procedureDAO.getName()); //$NON-NLS-1$

                refreshPackage();
            } catch (Exception e) {
                logger.error("drop package", e);
                exeMessage(Messages.get().ObjectDeleteAction_10, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.FUNCTIONS) {
        ProcedureFunctionDAO functionDAO = (ProcedureFunctionDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_30)) {
            try {
                if (userDB.getDBDefine() == DBDefine.ALTIBASE_DEFAULT) {
                    executeSQL(userDB,
                            "drop function " + functionDAO.getDefiner() + "." + functionDAO.getName());
                } else if (userDB.getDBDefine() == DBDefine.POSTGRE_DEFAULT) {
                    StringBuffer sbQuery = new StringBuffer("drop function " + functionDAO.getName() + "(");

                    ProcedureExecuterManager pm = new ProcedureExecuterManager(userDB, functionDAO);
                    pm.isExecuted(functionDAO, userDB);
                    List<InOutParameterDAO> inList = pm.getExecuter().getInParameters();
                    InOutParameterDAO inOutParameterDAO = inList.get(0);
                    String[] inParams = StringUtils.split(inOutParameterDAO.getRdbType(), ",");
                    for (int i = 0; i < inParams.length; i++) {
                        String name = StringUtils.trimToEmpty(inParams[i]);

                        if (i == (inParams.length - 1))
                            sbQuery.append(String.format("%s", name));
                        else
                            sbQuery.append(String.format("%s, ", name));
                    }
                    sbQuery.append(")");
                    if (logger.isDebugEnabled())
                        logger.debug("=[FUNCTIONS]===> " + sbQuery);

                    executeSQL(userDB, sbQuery.toString()); //$NON-NLS-1$
                } else {
                    executeSQL(userDB, "drop function " + functionDAO.getName()); //$NON-NLS-1$
                }

                refreshFunction();
            } catch (Exception e) {
                logger.error("drop function", e);
                exeMessage(Messages.get().ObjectDeleteAction_17, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.TRIGGERS) {
        TriggerDAO triggerDAO = (TriggerDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_36)) {
            try {
                if (userDB.getDBDefine() == DBDefine.POSTGRE_DEFAULT) {
                    executeSQL(userDB,
                            "drop trigger " + triggerDAO.getTrigger() + " on " + triggerDAO.getTable_name()); //$NON-NLS-1$
                } else {
                    executeSQL(userDB, "drop trigger " + triggerDAO.getTrigger()); //$NON-NLS-1$
                }

                refreshTrigger();
            } catch (Exception e) {
                logger.error("drop trigger", e);
                exeMessage(Messages.get().ObjectDeleteAction_18, e);
            }
        }
    } else if (actionType == PublicTadpoleDefine.OBJECT_TYPE.JAVASCRIPT) {
        MongoDBServerSideJavaScriptDAO jsDAO = (MongoDBServerSideJavaScriptDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), Messages.get().Confirm,
                Messages.get().ObjectDeleteAction_42)) {
            try {
                MongoDBQuery.deleteJavaScirpt(userDB, jsDAO.getName());
                refreshJS();
            } catch (Exception e) {
                logger.error("MongoDB ServerSide JavaScript delelte", e); //$NON-NLS-1$
                exeMessage("JavaScript", e); //$NON-NLS-1$
            }
        }
    }

}

From source file:com.hangum.tadpole.rdb.core.actions.object.rdb.object.ObjectRenameAction.java

License:Open Source License

@Override
public void run(IStructuredSelection selection, UserDBDAO userDB, OBJECT_TYPE actionType) {
    TableDAO dao = (TableDAO) selection.getFirstElement();

    ObjectRenameValidator fv = new ObjectRenameValidator(dao.getName());
    final Shell activeShell = PlatformUI.getWorkbench().getActiveWorkbenchWindow().getShell();
    InputDialog dialog = new InputDialog(activeShell, Messages.get().ObjectRenameAction_0, dao.getName(),
            dao.getName(), fv);/*from w  ww .j  a  va 2s .  c o  m*/
    if (dialog.open() == Window.OK) {
        String newTableNm = dialog.getValue();

        if (!MessageDialog.openConfirm(null, Messages.get().Confirm,
                String.format(Messages.get().ObjectRenameAction_2, newTableNm)))
            return;
        try {
            TadpoleObjectQuery.renameTable(userDB, dao, newTableNm);
            refreshTable(newTableNm);
        } catch (Exception e) {
            logger.error("rename table", e);

            TDBErroDialog errDialog = new TDBErroDialog(null, Messages.get().ObjectDeleteAction_25,
                    e.getMessage());
            errDialog.open();
        }
    }
}

From source file:com.hangum.tadpole.rdb.core.actions.object.rdb.object.SetGraphPathAction.java

License:Open Source License

@Override
public void run(IStructuredSelection selection, UserDBDAO userDB, OBJECT_TYPE actionType) {
    try {//from  w w  w  .  j a  v  a 2  s .  c o m
        if (!GrantCheckerUtils.ifExecuteQuery(userDB))
            return;
    } catch (Exception e) {
        MessageDialog.openError(getWindow().getShell(), CommonMessages.get().Error, e.getMessage());
        return;
    }

    if (actionType == PublicTadpoleDefine.OBJECT_TYPE.GRAPHPATH) {
        AgensGraphPathDAO dao = (AgensGraphPathDAO) selection.getFirstElement();
        if (MessageDialog.openConfirm(getWindow().getShell(), CommonMessages.get().Confirm,
                "Set graph path?")) {
            try {

                executeSQL(userDB, "SET GRAPH_PATH = " + dao.getGraphname()); //$NON-NLS-1$ //$NON-NLS-2$

            } catch (Exception e) {
                logger.error("set graph path", e);
            }
        }
    }

}

From source file:com.hangum.tadpole.rdb.core.actions.object.rdb.object.TableColumnDeleteAction.java

License:Open Source License

@Override
public void run(IStructuredSelection selection, UserDBDAO userDB, OBJECT_TYPE actionType) {
    if (selection.isEmpty())
        return;/*  w  ww .j  ava2 s .c  o m*/
    if (!MessageDialog.openConfirm(PlatformUI.getWorkbench().getActiveWorkbenchWindow().getShell(),
            Messages.get().Confirm, Messages.get().TableColumnDeleteAction_2))
        return;

    try {
        TableColumnObjectQuery.deleteColumn(userDB, selection.toList());
    } catch (Exception e) {
        logger.error("Table delete column", e);
        MessageDialog.openError(null, Messages.get().Error,
                Messages.get().TableColumnDeleteAction_3 + "\n" + e.getMessage());
    }

    // ? ?  .
    refreshTableColumn();
}

From source file:com.hangum.tadpole.rdb.core.dialog.dbconnect.composite.AbstractLoginComposite.java

License:Open Source License

/**
 * DB /*from  w w  w  . j  a  v a2  s . c o m*/
 * 
 * @return
 * @throws Exception
 */
public boolean connection() {
    if (!testConnection(false))
        return false;

    //  ?? ??
    if (getDataActionStatus() == DATA_STATUS.MODIFY) {
        if (!MessageDialog.openConfirm(null, "Confirm", Messages.SQLiteLoginComposite_13)) //$NON-NLS-1$
            return false;

        try {
            TadpoleSystem_UserDBQuery.updateUserDB(userDB, oldUserDB, SessionManager.getSeq());
        } catch (Exception e) {
            logger.error(Messages.SQLiteLoginComposite_8, e);
            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), "Error", Messages.SQLiteLoginComposite_5, //$NON-NLS-1$
                    errStatus);

            return false;
        }

        //  ?? .
    } else {
        try {
            TadpoleSystem_UserDBQuery.newUserDB(userDB, SessionManager.getSeq());
        } catch (Exception e) {
            logger.error(Messages.AbstractLoginComposite_0, e);
            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), "Error", Messages.MySQLLoginComposite_2, //$NON-NLS-1$
                    errStatus);

            return false;
        }
    }

    return true;
}

From source file:com.hangum.tadpole.rdb.core.dialog.dbconnect.composite.AbstractLoginComposite.java

License:Open Source License

/**
 * db ? ?  .//from w  w  w .  j a v  a 2  s  .  co  m
 * 
 * @param userDBDao
 * @param searchTable ? ? ??  
 * @return
 */
private boolean isAlreadExistDB(UserDBDAO userDBDao) {

    try {
        //  ?? ??
        if (getDataActionStatus() == DATA_STATUS.MODIFY) {
            //    ? ? ?  .
            //  display_name???  .
            if (TadpoleSystem_UserDBQuery.isOldDBValidate(SessionManager.getSeq(), userDBDao, oldUserDB)) {
                MessageDialog.openError(null, Messages.DBLoginDialog_23, Messages.AbstractLoginComposite_4);
                return false;
            }

        } else {
            //    ? ? ?  .
            //  display_name???  .
            if (TadpoleSystem_UserDBQuery.isNewDBValidate(SessionManager.getSeq(), userDBDao)) {
                MessageDialog.openError(null, Messages.DBLoginDialog_23, Messages.AbstractLoginComposite_4);

                return false;
            }

            // ?? ,   ? ? ??  ? .
            if (TadpoleSystem_UserDBQuery.isAlreadyExistDB(SessionManager.getSeq(), userDBDao)) {

                //   ? ?? ?? .
                if (MessageDialog.openConfirm(null, Messages.DBLoginDialog_23,
                        Messages.AbstractLoginComposite_2)) {
                    return true;
                }

                return false;
            }
        }

    } catch (Exception e) {
        logger.error("DB Connecting... ", e); //$NON-NLS-1$
        MessageDialog.openError(null, Messages.DBLoginDialog_26,
                Messages.DBLoginDialog_27 + "\n" + e.getMessage()); //$NON-NLS-1$

        return false;
    }

    return true;
}

From source file:com.hangum.tadpole.rdb.core.dialog.dbconnect.composite.AbstractLoginComposite.java

License:Open Source License

/**
 * db ?? ? ./*www . ja v a 2 s .  c o  m*/
 * 
 * @param loginInfo
 * @param isTest
 * @return
 */
private boolean checkDatabase(final UserDBDAO loginInfo, boolean isTest) {
    try {
        if (DBDefine.getDBDefine(loginInfo) == DBDefine.MONGODB_DEFAULT) {
            MongoConnectionManager.getInstance(userDB);

        } else if (DBDefine.getDBDefine(loginInfo) == DBDefine.TAJO_DEFAULT) {
            new TajoConnectionManager().connectionCheck(loginInfo);

        } else if (DBDefine.getDBDefine(loginInfo) == DBDefine.SQLite_DEFAULT) {
            String strFileLoc = StringUtils.difference(
                    StringUtils.remove(loginInfo.getDBDefine().getDB_URL_INFO(), "%s"), loginInfo.getUrl());
            File fileDB = new File(strFileLoc);
            if (fileDB.exists()) {
                List<String> strArr = FileUtils.readLines(fileDB);

                if (!StringUtils.contains(strArr.get(0), "SQLite format")) {
                    throw new SQLException("Doesn't SQLite files.");
                }
            }

        } else {
            SqlMapClient sqlClient = TadpoleSQLManager.getInstance(loginInfo);
            sqlClient.queryForList("connectionCheck", loginInfo.getDb()); //$NON-NLS-1$
        }

        return true;
    } catch (Exception e) {
        logger.error("DB Connecting... [url]" + loginInfo.getUrl(), e); //$NON-NLS-1$
        // If UserDBDao is not invalid, remove UserDBDao at internal cache
        TadpoleSQLManager.removeInstance(loginInfo);

        // mssql ??? ?  ?? ?.  .
        // https://github.com/hangum/TadpoleForDBTools/issues/512 
        if (!isTest) {// && loginInfo.getDBDefine() != DBDefine.MSSQL_DEFAULT) {
            if (MessageDialog.openConfirm(null, Messages.DBLoginDialog_26, Messages.AbstractLoginComposite_3
                    + PublicTadpoleDefine.DOUBLE_LINE_SEPARATOR + e.getMessage()))
                return true;
        } else {
            MessageDialog.openError(null, "Confirm", Messages.AbstractLoginComposite_1
                    + PublicTadpoleDefine.DOUBLE_LINE_SEPARATOR + e.getMessage());
        }

        return false;
    }
}

From source file:com.hangum.tadpole.rdb.core.dialog.dbconnect.composite.MSSQLLoginComposite.java

License:Open Source License

@Override
public boolean connection() {
    if (!testConnection(false))
        return false;

    //  ?? ??//from   www  . j av  a2  s.c  om
    if (getDataActionStatus() == DATA_STATUS.MODIFY) {
        if (!MessageDialog.openConfirm(null, "Confirm", Messages.SQLiteLoginComposite_13)) //$NON-NLS-1$
            return false;

        try {
            TadpoleSystem_UserDBQuery.updateUserDB(userDB, oldUserDB, SessionManager.getSeq());
        } catch (Exception e) {
            logger.error(Messages.SQLiteLoginComposite_8, e);
            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), "Error", Messages.SQLiteLoginComposite_5, //$NON-NLS-1$
                    errStatus);

            return false;
        }

        //  ?? .
    } else {

        int intVersion = 0;

        try {
            SqlMapClient sqlClient = TadpoleSQLManager.getInstance(userDB);
            //  ? .
            DBInfoDAO dbInfo = (DBInfoDAO) sqlClient.queryForObject("findDBInfo"); //$NON-NLS-1$
            intVersion = Integer.parseInt(StringUtils.substringBefore(dbInfo.getProductversion(), "."));

        } catch (Exception e) {
            logger.error("MSSQL Connection", e); //$NON-NLS-1$
            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), "Error", Messages.MSSQLLoginComposite_8, //$NON-NLS-1$
                    errStatus);

            return false;
        }

        try {
            if (intVersion <= 8) {
                userDB.setDbms_types(DBDefine.MSSQL_8_LE_DEFAULT.getDBToString());
            }

            TadpoleSystem_UserDBQuery.newUserDB(userDB, SessionManager.getSeq());
        } catch (Exception e) {
            logger.error("MSSQL", e); //$NON-NLS-1$
            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), "Error", Messages.MSSQLLoginComposite_10, //$NON-NLS-1$
                    errStatus);

            return false;
        }
    }

    return true;
}