/**
* This class is used for saving current editor's sql text into dbstructure composite. <br>
* $Id: SaveSQLAction,v 1.0 2006/11/15 05:38:28 ftang Exp $
*/
public class SaveAsSQLAction extends AbstractEditorAction {
private ImageDescriptor image = ImageUtil.getDescriptor("Images.SaveAsSQLIcon"); // $NON-NLS-1$
private RepositoryNode repositoryNode;
private Query query;
public SaveAsSQLAction(RepositoryNode repositoryNodeInput, ConnectionParameters query) {
this.query = query.getQueryObject();
this.repositoryNode = repositoryNodeInput;
SqlBuilderRepositoryObject o = (SqlBuilderRepositoryObject) repositoryNode.getObject();
boolean isBuildin = o.isBuildIn() || query.isNodeReadOnly();
setEnabled(!isBuildin);
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.action.Action#getImageDescriptor()
*/
public ImageDescriptor getImageDescriptor() {
return image;
}
/*
* (non-Javadoc)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#getText()
*/
public String getText() {
return Messages.getString("SQLEditor.Actions.SaveSQL"); // $NON-NLS-1$
}
/*
* (non-Javadoc)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#getToolTipText()
*/
public String getToolTipText() {
return Messages.getString("SQLEditor.Actions.SaveSQLToolTip"); // $NON-NLS-1$
}
/*
* (non-Javadoc)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#run()
*/
public void run() {
editor.doSaveSQL(query, true);
};
}
/**
* qzhang class global comment. Detailled comment <br>
* $Id: talend-code-templates.xml 1 2007-2-9 下午01:06:55 (星期五, 29 九月 2006) qzhang $
*/
public class GUIModificationQueryAction extends AbstractEditorAction {
private Preferences prefs = SqlBuilderPlugin.getDefault().getPluginPreferences();
private String queryDelimiter = prefs.getString(IConstants.QUERY_DELIMITER);
private String alternateDelimiter = prefs.getString(IConstants.ALTERNATE_DELIMITER);
private String commentDelimiter = prefs.getString(IConstants.COMMENT_DELIMITER);
private RepositoryNode currentNode;
private ISQLBuilderDialog dialog;
private ImageDescriptor image = ImageUtil.getDescriptor("Images.OpenSQLIcon"); // $NON-NLS-1$
private String currentSql;
private boolean isDesigner;
/** qzhang GUIModificationQuery constructor comment. */
public GUIModificationQueryAction(
RepositoryNode node, ConnectionParameters parameters, ISQLBuilderDialog dialog) {
this.currentNode = node;
this.dialog = dialog;
}
/*
* (non-Javadoc)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#getToolTipText()
*/
@Override
public String getToolTipText() {
if (isDesigner) {
return Messages.getString("GUIModificationQueryAction.TextDialog.TitleText"); // $NON-NLS-1$
}
return Messages.getString("GUIModificationQueryAction.ButtonText"); // $NON-NLS-1$
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.action.Action#getImageDescriptor()
*/
@Override
public ImageDescriptor getImageDescriptor() {
return image;
}
/*
* (non-Java)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#getText()
*/
@Override
public String getText() {
if (isDesigner) {
return Messages.getString("GUIModificationQueryAction.TextDialog.TitleText"); // $NON-NLS-1$
}
return Messages.getString("GUIModificationQueryAction.ButtonText"); // $NON-NLS-1$
}
/*
* (non-Java)
*
* @see org.talend.sqlbuilder.actions.AbstractEditorAction#run()
*/
@Override
public void run() {
currentSql = getEditor().getSQLToBeExecuted();
// QueryTokenizer qt = new QueryTokenizer(currentSql, queryDelimiter, alternateDelimiter,
// commentDelimiter);
// List<String> queryStrings = new ArrayList<String>();
// while (qt.hasQuery()) {
// String querySql = qt.nextQuery();
// // ignore commented lines.
// if (!querySql.startsWith("--")) { //$NON-NLS-1$
// queryStrings.add(querySql);
// }
// }
// if (queryStrings.size() < 1) {
// MessageDialog.openError(new Shell(), "Notice", "You must input one Sql Statement!");
// return;
// }
// if (queryStrings.size() > 1) {
// isForce = MessageDialog.openQuestion(new Shell(), "Notice",
// "You only modify first Sql Statement by GUI, Would you like to continue?");
// }
// String string = queryStrings.get(0).toLowerCase().replaceAll("\n", " ");
// string.replaceAll("\t", " ");
// if (!string.startsWith("select ")) {
// MessageDialog.openError(new Shell(), "Notice", "GUI Sql Editor only use for 'select'
// Statement !");
// return;
// }
// if (isForce != null && !isForce.booleanValue()) {
// return;
// }
if (dialog instanceof SQLBuilderDialog) {
SQLBuilderDialog d = (SQLBuilderDialog) dialog;
final CTabItem selection = d.getEditorComposite().getTabFolder().getSelection();
if (selection.getData("KEY") instanceof MultiPageSqlBuilderEditor) { // $NON-NLS-1$
MultiPageSqlBuilderEditor editor =
(MultiPageSqlBuilderEditor) selection.getData("KEY"); // $NON-NLS-1$
switch (editor.getActivePage()) {
case 1:
isDesigner = true;
break;
default:
isDesigner = false;
break;
}
}
}
String query = null;
if (isDesigner) {
SqlEditDialog textDialog =
new SqlEditDialog(
dialog.getShell(),
Messages.getString("GUIModificationQueryAction.TextDialog.TitleText"),
currentSql,
currentNode); //$NON-NLS-1$
if (Window.OK == textDialog.open()) {
query = textDialog.getSql();
}
} else {
List<IRepositoryNode> selectedNodes = null;
try {
selectedNodes =
EMFRepositoryNodeManager.getInstance().parseSqlStatement(currentSql, currentNode);
} catch (Exception e) {
MessageDialog.openError(
new Shell(),
Messages.getString("GUIModificationQueryAction.Error.Notice"),
Messages.getString(
"GUIModificationQueryAction.SqlStatement.ErrorMsg")); //$NON-NLS-1$ //$NON-NLS-2$
}
if (selectedNodes == null) {
return;
}
// String info = Messages.getString("MultiPageSqlBuilderEditor.Notice.InformationNotFull");
// MessageDialog.openInformation(new Shell(),
// Messages.getString("GUIModificationQueryAction.Information.Msg"), info); //$NON-NLS-1$
ErDiagramDialog erDiagramDialog =
new ErDiagramDialog(
dialog.getShell(),
Messages.getString("GUIModificationQueryAction.Dialog.TitleText"),
currentNode); //$NON-NLS-1$
erDiagramDialog.setDialog(dialog);
erDiagramDialog.setNodes(selectedNodes);
erDiagramDialog.setSqlText(currentSql);
EMFRepositoryNodeManager.getInstance().setRoot(currentNode);
if (Window.OK == erDiagramDialog.open()) {
query = erDiagramDialog.getSql();
}
}
if (query == null) {
return;
}
if (!query.endsWith(";\n") && !query.endsWith(";")) { // $NON-NLS-1$ //$NON-NLS-2$
query += ";\n"; // $NON-NLS-1$
}
String targetSql = ""; // $NON-NLS-1$
boolean isfirst = true;
QueryTokenizer qt =
new QueryTokenizer(currentSql, queryDelimiter, alternateDelimiter, commentDelimiter);
while (qt.hasQuery()) {
String querySql = qt.nextQuery();
if (querySql.startsWith("--") || !isfirst) { // $NON-NLS-1$
targetSql += querySql + ";\n"; // $NON-NLS-1$
} else {
targetSql += query;
isfirst = false;
}
}
if (!qt.hasQuery()) {
targetSql = query;
}
// currentSql = currentSql.replaceFirst(queryStrings.get(0), query);
getEditor().setEditorContent(targetSql);
}
public void setCurrentNode(RepositoryNode currentNode) {
this.currentNode = currentNode;
}
}
/**
* DOC dev class global comment. Detailled comment <br>
* $Id: SQLEditorLabelProvider.java,v 1.3 2006/11/06 08:28:00 qiang.zhang Exp $
*/
public class SQLEditorLabelProvider implements ILabelProvider {
private ImageDescriptor sqlEditor =
ImageUtil.getDescriptor("Images.SqlEditorIcon"); // $NON-NLS-1$
/** DOC dev SQLEditorLabelProvider constructor comment. */
public SQLEditorLabelProvider() {
super();
// TODO Auto-generated constructor stub
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.ILabelProvider#getImage(java.lang.Object)
*/
public Image getImage(Object element) {
Image i = null;
if (element instanceof SQLEditorAllProposal) {
i = ((SQLEditorAllProposal) element).getImage();
if (i != null) {
return i;
}
}
return ImageProvider.getImage(sqlEditor);
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.ILabelProvider#getText(java.lang.Object)
*/
public String getText(Object element) {
if (element instanceof SQLEditorAllProposal) {
return ((SQLEditorAllProposal) element).getLabel();
}
return ""; //$NON-NLS-1$
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.IBaseLabelProvider#addListener(org.eclipse.jface.viewers.ILabelProviderListener)
*/
public void addListener(ILabelProviderListener listener) {
// TODO Auto-generated method stub
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.IBaseLabelProvider#dispose()
*/
public void dispose() {
// TODO Auto-generated method stub
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.IBaseLabelProvider#isLabelProperty(java.lang.Object, java.lang.String)
*/
public boolean isLabelProperty(Object element, String property) {
// TODO Auto-generated method stub
return false;
}
/*
* (non-Javadoc)
*
* @see org.eclipse.jface.viewers.IBaseLabelProvider#removeListener(org.eclipse.jface.viewers.ILabelProviderListener)
*/
public void removeListener(ILabelProviderListener listener) {
// TODO Auto-generated method stub
}
}