GenerateStatmentDMLDialog.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.dialog.dml;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.eclipse.jface.dialogs.Dialog;
import org.eclipse.jface.dialogs.IDialogConstants;
import org.eclipse.jface.dialogs.MessageDialog;
import org.eclipse.jface.viewers.ArrayContentProvider;
import org.eclipse.jface.viewers.TableViewer;
import org.eclipse.jface.viewers.TableViewerColumn;
import org.eclipse.swt.SWT;
import org.eclipse.swt.events.ModifyEvent;
import org.eclipse.swt.events.ModifyListener;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.graphics.Point;
import org.eclipse.swt.layout.GridData;
import org.eclipse.swt.layout.GridLayout;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Control;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.Text;
import org.eclipse.ui.PlatformUI;

import com.hangum.tadpole.commons.google.analytics.AnalyticCaller;
import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
import com.hangum.tadpole.commons.libs.core.message.CommonMessages;
import com.hangum.tadpole.commons.util.GlobalImageUtils;
import com.hangum.tadpole.engine.query.dao.mysql.TableColumnDAO;
import com.hangum.tadpole.engine.query.dao.mysql.TableDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.sql.util.SQLUtil;
import com.hangum.tadpole.rdb.core.Messages;
import com.hangum.tadpole.rdb.core.viewers.object.sub.utils.TadpoleObjectQuery;
import com.hangum.tadpole.sql.format.SQLFormater;

/**
 * DMLGenerae Statement Dialog
 * 
 * @author nilriri
 *
 */
public class GenerateStatmentDMLDialog extends Dialog {
	private static final Logger logger = Logger.getLogger(GenerateStatmentDMLDialog.class);
	private boolean isEditorAdd = false;

	/** generation SQL string */
	private String genSQL = ""; //$NON-NLS-1$

	private UserDBDAO userDB;
	private TableDAO tableDAO;
	private TableViewer tableViewer;
	private Text textTableAlias;
	private Text textQuery;
	private Label lblTableName;

	private Button chkComment;

	private Button rdoSelect;
	private Button rdoUpdate;
	private Button rdoInsert;
	private Button rdoDelete;

	/**
	 * Create the dialog.
	 * 
	 * @param parentShell
	 */
	public GenerateStatmentDMLDialog(Shell parentShell, boolean isEditorAdd, UserDBDAO userDB, TableDAO tableDAO) {
		super(parentShell);
		setBlockOnOpen(isEditorAdd);
		setShellStyle(SWT.MAX | SWT.RESIZE | SWT.TITLE);

		this.isEditorAdd = isEditorAdd;
		this.userDB = userDB;
		this.tableDAO = tableDAO;
	}

	@Override
	protected void configureShell(Shell newShell) {
		super.configureShell(newShell);
		newShell.setText(tableDAO.getName() + Messages.get().TableInformation);
		newShell.setImage(GlobalImageUtils.getTadpoleIcon());
	}

	/**
	 * Create contents of the dialog.
	 * 
	 * @param parent
	 */
	@Override
	protected Control createDialogArea(Composite parent) {
		Composite container = (Composite) super.createDialogArea(parent);
		GridLayout gridLayout = (GridLayout) container.getLayout();
		gridLayout.verticalSpacing = 2;
		gridLayout.horizontalSpacing = 2;
		gridLayout.marginHeight = 2;
		gridLayout.marginWidth = 2;

		Composite compositeBody = new Composite(container, SWT.NONE);
		GridLayout gl_compositeBody = new GridLayout(1, false);
		gl_compositeBody.verticalSpacing = 2;
		gl_compositeBody.horizontalSpacing = 2;
		gl_compositeBody.marginHeight = 2;
		gl_compositeBody.marginWidth = 2;
		compositeBody.setLayout(gl_compositeBody);
		compositeBody.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));

		Composite compositeTable = new Composite(compositeBody, SWT.NONE);
		compositeTable.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, false, 1, 1));
		compositeTable.setLayout(new GridLayout(3, false));

		lblTableName = new Label(compositeTable, SWT.NONE);
		lblTableName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
		lblTableName.setText(SQLUtil.getTableName(userDB, tableDAO));

		Label lblAs = new Label(compositeTable, SWT.NONE);
		lblAs.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
		lblAs.setText(" as "); //$NON-NLS-1$

		textTableAlias = new Text(compositeTable, SWT.BORDER);
		textTableAlias.addModifyListener(new ModifyListener() {
			public void modifyText(ModifyEvent event) {
				if (tableViewer.getInput() != null) {
					for (ExtendTableColumnDAO dao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {

						dao.setTableAlias(textTableAlias.getText());
					}
					tableViewer.refresh();
					queryGenetation();
				}
			}
		});
		textTableAlias.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		new Label(compositeTable, SWT.NONE);
		new Label(compositeTable, SWT.NONE);

		Text textTBNameCmt = new Text(compositeTable, SWT.BORDER | SWT.WRAP | SWT.MULTI);
		GridData gd_textTBNameCmt = new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1);
		gd_textTBNameCmt.heightHint = 33;
		textTBNameCmt.setLayoutData(gd_textTBNameCmt);
		textTBNameCmt.setText(tableDAO.getComment());

		Composite compositeDML = new Composite(compositeBody, SWT.NONE);
		compositeDML.setLayout(new GridLayout(5, false));
		compositeDML.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

		Label lblDml = new Label(compositeDML, SWT.NONE);
		lblDml.setText("DML"); //$NON-NLS-1$

		rdoSelect = new Button(compositeDML, SWT.RADIO);
		rdoSelect.setSelection(true);
		rdoSelect.setText("SELECT"); //$NON-NLS-1$

		rdoUpdate = new Button(compositeDML, SWT.RADIO);
		rdoUpdate.setText("UPDATE"); //$NON-NLS-1$

		rdoInsert = new Button(compositeDML, SWT.RADIO);
		rdoInsert.setText("INSERT"); //$NON-NLS-1$

		rdoDelete = new Button(compositeDML, SWT.RADIO);
		rdoDelete.setText("DELETE"); //$NON-NLS-1$

		assignSelectionAdapter(rdoSelect);
		assignSelectionAdapter(rdoUpdate);
		assignSelectionAdapter(rdoInsert);
		assignSelectionAdapter(rdoDelete);

		tableViewer = new TableViewer(compositeBody, SWT.BORDER | SWT.FULL_SELECTION);
		Table table = tableViewer.getTable();
		table.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));
		table.setLinesVisible(true);
		table.setHeaderVisible(true);

		TableViewerColumn tvColumnName = new TableViewerColumn(tableViewer, SWT.NONE);
		TableColumn tcColumnName = tvColumnName.getColumn();
		tcColumnName.setWidth(130);
		tcColumnName.setText(Messages.get().ColumnName);
		tvColumnName.setEditingSupport(new DMLColumnEditingSupport(tableViewer, 0, this));

		TableViewerColumn tvColumnDataType = new TableViewerColumn(tableViewer, SWT.LEFT);
		TableColumn tcDataType = tvColumnDataType.getColumn();
		tcDataType.setWidth(85);
		tcDataType.setText(Messages.get().DataType);

		TableViewerColumn tvColumnKey = new TableViewerColumn(tableViewer, SWT.CENTER);
		TableColumn tcKey = tvColumnKey.getColumn();
		tcKey.setWidth(50);
		tcKey.setText(Messages.get().Key);

		TableViewerColumn tvColumnAlias = new TableViewerColumn(tableViewer, SWT.NONE);
		TableColumn tcAlias = tvColumnAlias.getColumn();
		tcAlias.setWidth(100);
		tcAlias.setText(Messages.get().Alias);
		tvColumnAlias.setEditingSupport(new DMLColumnEditingSupport(tableViewer, 3, this));

		TableViewerColumn tvColumnCmt = new TableViewerColumn(tableViewer, SWT.LEFT);
		TableColumn tcCmt = tvColumnCmt.getColumn();
		tcCmt.setWidth(300);
		tcCmt.setText(CommonMessages.get().Description);

		Composite composite_3 = new Composite(compositeBody, SWT.NONE);
		composite_3.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		GridLayout gl_composite_3 = new GridLayout(2, false);
		gl_composite_3.verticalSpacing = 2;
		gl_composite_3.horizontalSpacing = 2;
		gl_composite_3.marginHeight = 2;
		gl_composite_3.marginWidth = 2;
		composite_3.setLayout(gl_composite_3);

		final Button btnAllCheck = new Button(composite_3, SWT.CHECK);
		btnAllCheck.addSelectionListener(new SelectionAdapter() {
			@Override
			public void widgetSelected(SelectionEvent e) {
				for (ExtendTableColumnDAO dao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
					if ("*".equals(dao.getField())) { //$NON-NLS-1$
						dao.setCheck(!btnAllCheck.getSelection());
					} else {
						dao.setCheck(btnAllCheck.getSelection());
					}
				}
				tableViewer.refresh();
				queryGenetation();
			}
		});
		btnAllCheck.setText(Messages.get().AllColumn);

		chkComment = new Button(composite_3, SWT.CHECK);
		chkComment.setText(Messages.get().GenerateStatmentDMLDialog_15);
		assignSelectionAdapter(chkComment);

		Composite previewComposite = new Composite(compositeBody, SWT.BORDER);
		previewComposite.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		GridLayout gl_previewComposite = new GridLayout(1, false);
		gl_previewComposite.verticalSpacing = 2;
		gl_previewComposite.horizontalSpacing = 2;
		gl_previewComposite.marginHeight = 2;
		gl_previewComposite.marginWidth = 2;
		previewComposite.setLayout(gl_previewComposite);

		textQuery = new Text(previewComposite, SWT.BORDER | SWT.WRAP | SWT.H_SCROLL | SWT.V_SCROLL | SWT.CANCEL | SWT.MULTI);
		GridData gd_textQuery = new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1);
		gd_textQuery.minimumHeight = 120;
		textQuery.setLayoutData(gd_textQuery);

		tableViewer.setContentProvider(new ArrayContentProvider());
		tableViewer.setLabelProvider(new GenerateLabelProvider());

		initData();
		queryGenetation();

		// google analytic
		AnalyticCaller.track(this.getClass().getName());

		textTableAlias.setFocus();

		return container;
	}

	private void assignSelectionAdapter(Button button) {
		button.addSelectionListener(new SelectionAdapter() {
			@Override
			public void widgetSelected(SelectionEvent e) {
				queryGenetation();
			}
		});
	}

	public String queryGenetation() {
		String sql = ""; //$NON-NLS-1$

		if (rdoSelect.getSelection()) {
			sql = buildSelectSQL();
		} else if (rdoUpdate.getSelection()) {
			sql = buildUpdateSQL();
		} else if (rdoInsert.getSelection()) {
			sql = buildInsertSQL();
		} else if (rdoDelete.getSelection()) {
			sql = buildDeleteSQL();
		} else {
			sql = "/* DML generation error. */"; //$NON-NLS-1$
		}
		genSQL = sql;

		this.textQuery.setText(sql);

		return sql;

	}

	public String getDML() {
		return genSQL;
	}

	private void initData() {
		try {

			List<TableColumnDAO> showTableColumns = TadpoleObjectQuery.getTableColumns(userDB, tableDAO);

			//조회된 내용이 없고 스키마 정보가 없으면
			if (StringUtils.isEmpty(tableDAO.getSchema_name()) && showTableColumns.size() <= 0) {
				Map<String,String> paramMap = new HashMap<String,String>();
				paramMap.put("OBJECT_NAME", tableDAO.getName());
				SelectObjectDialog dialog = new SelectObjectDialog(PlatformUI.getWorkbench().getActiveWorkbenchWindow().getShell(), userDB, paramMap );

				if (dialog.getSelectObject().isEmpty() && dialog.getObjectCount() > 1) {
					//이름으로 검색한 결과가 1개이상이면 선택화면을 띄운다.
					dialog.open();
				} else if (dialog.getObjectCount() <= 0) {
					//해당 오브젝트를 찾을 수 없습니다.
					MessageDialog.openInformation(getShell(), CommonMessages.get().Information, Messages.get().NotFountObject);
				}
				Map<String, String> map = dialog.getSelectObject();
				tableDAO.setSchema_name(map.get("OBJECT_OWNER"));
				tableDAO.setTable_name(map.get("OBJECT_NAME"));
				this.lblTableName.setText(tableDAO.getSchema_name() + "." + tableDAO.getName());
				showTableColumns = TadpoleObjectQuery.getTableColumns(userDB, tableDAO);
			}
			
			List<ExtendTableColumnDAO> newTableColumns = new ArrayList<ExtendTableColumnDAO>();

			ExtendTableColumnDAO newTableDAO = new ExtendTableColumnDAO("*", "", "", textTableAlias.getText().trim()); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
			newTableDAO.setCheck(true);

			newTableColumns.add(newTableDAO);
			for (TableColumnDAO tableColumnDAO : showTableColumns) {
				String strSysName = SQLUtil.makeIdentifierName(userDB, tableColumnDAO.getField());
				newTableDAO = new ExtendTableColumnDAO(tableColumnDAO.getField(), tableColumnDAO.getType(), tableColumnDAO.getKey(), textTableAlias.getText().trim());
				newTableDAO.setSysName(strSysName);
				newTableDAO.setComment(tableColumnDAO.getComment());

				newTableColumns.add(newTableDAO);
			}

			tableViewer.setInput(newTableColumns);

			tableViewer.refresh();
		} catch (Exception e) {
			logger.error("DML Generate dialog", e);
		}

	}

	/**
	 * Generate SELECT statment
	 * 
	 * @return
	 */
	private String buildSelectSQL() {
		StringBuffer resultSQL = new StringBuffer();
		if (chkComment.getSelection()) {
			resultSQL.append(makeDefaultComment());
		}
		resultSQL.append("SELECT "); //$NON-NLS-1$
		int cnt = 0;

		StringBuffer sbColumn = new StringBuffer();
		for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
			if (allDao.isCheck()) {
				if (cnt != 0)
					sbColumn.append("\t, "); //$NON-NLS-1$

				if ("*".equals(allDao.getField())) { //$NON-NLS-1$
					sbColumn.append(allDao.getSysName());
				} else {
					String strTableAlias = !"".equals(textTableAlias.getText().trim()) ? //$NON-NLS-1$
					textTableAlias.getText().trim() + "." + allDao.getSysName() + " as " + allDao.getColumnAlias() : //$NON-NLS-1$ //$NON-NLS-2$
							allDao.getSysName() + " as " + allDao.getColumnAlias(); //$NON-NLS-1$

					sbColumn.append(strTableAlias);
					if (chkComment.getSelection()) {
						sbColumn.append(makeComment(allDao.getType(), allDao.getComment()));
					}
				}
				
				cnt++;
			}
		}
		if (StringUtils.isEmpty(StringUtils.trim(sbColumn.toString())))
			sbColumn.append(" * "); //$NON-NLS-1$

		resultSQL.append(sbColumn.toString());
		resultSQL.append(" FROM " + SQLUtil.getTableName(userDB, tableDAO) + " " + this.textTableAlias.getText().trim()); //$NON-NLS-1$ //$NON-NLS-2$
		cnt = 0;
		for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
			if ("PK".equals(allDao.getKey()) || "PRI".equals(allDao.getKey())) { //$NON-NLS-1$

				if (cnt == 0) resultSQL.append(" WHERE "); //$NON-NLS-1$
				 else resultSQL.append(" AND "); //$NON-NLS-1$
				
				resultSQL.append(allDao.getColumnNamebyTableAlias()).append(" = ? "); //$NON-NLS-1$
				if (chkComment.getSelection()) {
					resultSQL.append(makeComment(allDao.getType()));
				}
				cnt++;
			}
		}

		return lastSQLGen(resultSQL.toString());
	}

	/**
	 * Generate UPDATE statement
	 * 
	 * @return
	 */
	private String buildUpdateSQL() {
		StringBuffer resultSQL = new StringBuffer();
		if (chkComment.getSelection()) resultSQL.append(makeDefaultComment());

		int cnt = 0;

		resultSQL.append("UPDATE " + SQLUtil.getTableName(userDB, tableDAO) + " " + this.textTableAlias.getText().trim()); //$NON-NLS-1$ //$NON-NLS-2$

		ExtendTableColumnDAO firstDao = (ExtendTableColumnDAO) tableViewer.getElementAt(0);
		if (firstDao.isCheck()) {
			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if ("*".equals(allDao.getField()))continue; //$NON-NLS-1$

				if (cnt == 0) resultSQL.append(" SET "); //$NON-NLS-1$
				else resultSQL.append(" , "); //$NON-NLS-1$

				resultSQL.append(allDao.getColumnNamebyTableAlias()).append(" = ? "); //$NON-NLS-1$
				if (chkComment.getSelection()) {
					resultSQL.append(makeComment(allDao.getType(), allDao.getComment()));
				}
				cnt++;
			}

		} else {

			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if (allDao.isCheck()) {
					if (cnt == 0) resultSQL.append(" SET "); //$NON-NLS-1$
					else resultSQL.append(", "); //$NON-NLS-1$

					resultSQL.append(allDao.getColumnNamebyTableAlias()).append(" = ? "); //$NON-NLS-1$
					if (chkComment.getSelection()) {
						resultSQL.append(makeComment(allDao.getType(), allDao.getComment()));
					}
					cnt++;

				}
			}
		}
		cnt = 0;
		for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
			if ("PK".equals(allDao.getKey())) { //$NON-NLS-1$

				if (cnt == 0) resultSQL.append(" WHERE "); //$NON-NLS-1$
				else resultSQL.append(" AND "); //$NON-NLS-1$

				resultSQL.append(allDao.getColumnNamebyTableAlias()).append(" = ? "); //$NON-NLS-1$

				if (chkComment.getSelection()) {
					resultSQL.append(makeComment(allDao.getType()));
				}
				cnt++;
			}
		}

		return lastSQLGen(resultSQL.toString());
	}

	/**
	 * Generate INSERT statement
	 * 
	 * @return
	 */
	private String buildInsertSQL() {
		StringBuffer resultSQL = new StringBuffer();
		if (chkComment.getSelection()) resultSQL.append(makeDefaultComment());

		int cnt = 0;

		resultSQL.append("INSERT INTO " + SQLUtil.getTableName(userDB, tableDAO) + " ( "); //$NON-NLS-1$ //$NON-NLS-2$

		ExtendTableColumnDAO firstDao = (ExtendTableColumnDAO) tableViewer.getElementAt(0);
		if (firstDao.isCheck()) {
			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if ("*".equals(allDao.getField()))continue; //$NON-NLS-1$

				if (cnt > 0) resultSQL.append(", "); //$NON-NLS-1$
				resultSQL.append(allDao.getSysName());
				
				if (chkComment.getSelection()){
					resultSQL.append(makeComment(allDao.getComment()));
				}

				cnt++;
			}

		} else {

			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if (allDao.isCheck()) {
					if (cnt > 0) resultSQL.append(", "); //$NON-NLS-1$
					resultSQL.append(allDao.getSysName());
					
					if (chkComment.getSelection()) {
						resultSQL.append(makeComment(allDao.getComment()));
					}

					cnt++;
				}
			}
		}
		resultSQL.append(")" + PublicTadpoleDefine.LINE_SEPARATOR + "VALUES ( "); //$NON-NLS-1$ //$NON-NLS-2$
		cnt = 0;

		if (firstDao.isCheck()) {
			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if ("*".equals(allDao.getSysName()))continue; //$NON-NLS-1$

				if (cnt > 0) resultSQL.append(", "); //$NON-NLS-1$
				resultSQL.append("?"); //$NON-NLS-1$

				if (chkComment.getSelection()) {
					resultSQL.append(makeComment(allDao.getField(), allDao.getType()));
				}

				cnt++;
			}

		} else {

			for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
				if (allDao.isCheck()) {
					if (cnt > 0) resultSQL.append(", "); //$NON-NLS-1$

					resultSQL.append("?"); //$NON-NLS-1$
					if (chkComment.getSelection()) {
						resultSQL.append(makeComment(allDao.getField(), allDao.getType()));
					}
					cnt++;
				}
			}
		}

		resultSQL.append(")"); //$NON-NLS-1$

		return lastSQLGen(resultSQL.toString());
	}

	private String buildDeleteSQL() {
		StringBuffer resultSQL = new StringBuffer();
		if (chkComment.getSelection())
			resultSQL.append(makeDefaultComment());

		int cnt = 0;

		resultSQL.append("DELETE FROM  " + SQLUtil.getTableName(userDB, tableDAO)); //$NON-NLS-1$
		for (ExtendTableColumnDAO allDao : (List<ExtendTableColumnDAO>) tableViewer.getInput()) {
			if ("PK".equals(allDao.getKey())) { //$NON-NLS-1$

				if (cnt == 0) resultSQL.append("WHERE "); //$NON-NLS-1$
				else resultSQL.append("\t AND "); //$NON-NLS-1$

				resultSQL.append(allDao.getSysName()).append(" = ? "); //$NON-NLS-1$
				if (chkComment.getSelection()) {
					resultSQL.append(makeComment(allDao.getType()));
				}
				cnt++;
			}
		}

		return lastSQLGen(resultSQL.toString());
	}

	/**
	 * 쿼리 생성 후 후반작업을 합니다.
	 * 
	 * @param strSQL
	 * @return
	 */
	private String lastSQLGen(String strSQL) {
		String retSQL = strSQL + PublicTadpoleDefine.SQL_DELIMITER;
		try {
			retSQL = SQLFormater.format(retSQL);
		} catch (Exception e) {
			logger.error("SQL Formatting" + e); //$NON-NLS-1$
		}

		return retSQL;
	}
	
	/**
	 * 기본 커맨트를 리턴한다.
	 * @return
	 */
	private String makeDefaultComment() {
		return "/* Tadpole SQL Generator */";
	}
	
	/**
	 * 코드의 코멘트를 생성한다.
	 * 
	 * @param columnName
	 * @param columnType
	 * @return
	 */
	private String makeComment(String... comments) {
		StringBuffer sbComment = new StringBuffer("/* ");
		for (String comment : comments) {
			sbComment.append(comment + ", ");
		}
		return StringUtils.removeEnd(sbComment.toString(), ", ") + " */";
	}

	/**
	 * Create contents of the button bar.
	 * 
	 * @param parent
	 */
	@Override
	protected void createButtonsForButtonBar(Composite parent) {
		if (isEditorAdd) {
			createButton(parent, IDialogConstants.OK_ID, Messages.get().GenerateStatmentDMLDialog_2, false);
		}
		createButton(parent, IDialogConstants.CANCEL_ID, CommonMessages.get().Close, false);

	}

	/**
	 * Return the initial size of the dialog.
	 */
	@Override
	protected Point getInitialSize() {
		return new Point(500, 600);
	}
}