archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/view/SQLQueryView.java

   1 package net.sourceforge.phpdt.sql.view;
   2
   3 import java.util.LinkedList;
   4 import java.util.NoSuchElementException;
   5 import java.util.Vector;
   6
   7 import org.eclipse.jface.action.Action;
   8 import org.eclipse.swt.SWT;
   9 import org.eclipse.swt.custom.ExtendedModifyEvent;
  10 import org.eclipse.swt.custom.ExtendedModifyListener;
  11 import org.eclipse.swt.custom.StyleRange;
  12 import org.eclipse.swt.custom.StyledText;
  13 import org.eclipse.swt.dnd.Clipboard;
  14 import org.eclipse.swt.events.SelectionEvent;
  15 import org.eclipse.swt.events.SelectionListener;
  16 import org.eclipse.swt.graphics.Color;
  17 import org.eclipse.swt.graphics.Image;
  18 import org.eclipse.swt.layout.GridData;
  19 import org.eclipse.swt.layout.GridLayout;
  20 import org.eclipse.swt.widgets.Composite;
  21 import org.eclipse.swt.widgets.Label;
  22 import org.eclipse.swt.widgets.ProgressBar;
  23 import org.eclipse.swt.widgets.ToolBar;
  24 import org.eclipse.swt.widgets.ToolItem;
  25 import org.eclipse.ui.IActionBars;
  26 import org.eclipse.ui.IWorkbenchActionConstants;
  27 import org.eclipse.ui.part.ViewPart;
  28
  29 import net.sourceforge.phpdt.sql.IConstants;
  30 import net.sourceforge.phpdt.sql.Messages;
  31 import net.sourceforge.phpdt.sql.PHPEclipseSQLPlugin;
  32 import net.sourceforge.phpdt.sql.actions.ExecuteAction;
  33 import net.sourceforge.phpdt.sql.actions.ExportQueryAction;
  34 import net.sourceforge.phpdt.sql.actions.GeneratePHPAction;
  35 import net.sourceforge.phpdt.sql.actions.ImportQueryAction;
  36 import net.sourceforge.phpdt.sql.sql.MultiSQLServer;
  37 import net.sourceforge.phpdt.sql.sql.parser.SQLLexx;
  38 import net.sourceforge.phpdt.sql.sql.parser.Token;
  39 import net.sourceforge.phpdt.sql.view.bookmark.BookmarkNode;
  40
  41 public class SQLQueryView extends ViewPart implements IConstants {
  42         ExecuteAction executeAction;
  43         ImportQueryAction importQueryAction;
  44         ExportQueryAction exportQueryAction;
  45         GeneratePHPAction generatePHPAction;
  46         private Clipboard clip;
  47         private Label statusImage;
  48         private Label status;
  49         private ProgressBar progress;
  50         private static SQLQueryView instance = null;
  51         private StyledText widget;
  52         private Color STRING_LITERAL;
  53         private Color KEYWORD;
  54         private Color COMMENT;
  55         private Color NUMERIC;
  56         private Color DEFAULT;
  57         private long parseTime = 0;
  58         private long fullTime = 0;
  59         public SQLQueryView() {
  60                 super();
  61         }
  62         public void setFocus() {
  63                 widget.setFocus();
  64         }
  65         public static SQLQueryView getInstance() {
  66                 return instance;
  67         }
  68
  69         public void createPartControl(org.eclipse.swt.widgets.Composite parent) {
  70                 instance = this;
  71                 initActions();
  72                 KEYWORD = new Color(parent.getShell().getDisplay(), 126, 0, 75);
  73                 STRING_LITERAL = new Color(parent.getShell().getDisplay(), 0, 0, 255);
  74                 COMMENT = new Color(parent.getShell().getDisplay(), 88, 148, 64);
  75                 NUMERIC = new Color(parent.getShell().getDisplay(), 255, 0, 0);
  76             DEFAULT = new Color(parent.getShell().getDisplay(), 0, 0, 0);
  77                 clip = new Clipboard(getSite().getShell().getDisplay());
  78                 Composite main = new Composite(parent, SWT.NONE);
  79                 GridLayout layout = new GridLayout(1, false);
  80                 layout.horizontalSpacing = 0;
  81                 layout.verticalSpacing = 0;
  82                 main.setLayout(layout);
  83                 ToolBar toolbar = new ToolBar(main, SWT.HORIZONTAL);
  84                 ToolItem item = new ToolItem(toolbar, SWT.PUSH);
  85                 item.setImage(PHPEclipseSQLPlugin.getImage("play.gif")); //$NON-NLS-1$
  86                 item.setToolTipText(Messages.getString("sqlqueryview.executeQuery")); //$NON-NLS-1$
  87                 item.addSelectionListener(new SelectionListener() {
  88                         public void widgetDefaultSelected(SelectionEvent e) {
  89                         }
  90                         public void widgetSelected(SelectionEvent e) {
  91                                 executeAction.run();
  92                         }
  93                 });
  94                 item = new ToolItem(toolbar, SWT.SEPARATOR);
  95                 item = new ToolItem(toolbar, SWT.PUSH);
  96                 item.setImage(PHPEclipseSQLPlugin.getImage("import.gif")); //$NON-NLS-1$
  97                 item.setToolTipText(Messages.getString("sqlqueryview.importQuery")); //$NON-NLS-1$
  98                 item.addSelectionListener(new SelectionListener() {
  99                         public void widgetDefaultSelected(SelectionEvent e) {
 100                         }
 101                         public void widgetSelected(SelectionEvent e) {
 102                                 importQueryAction.run();
 103                         }
 104                 });
 105                 item = new ToolItem(toolbar, SWT.PUSH);
 106                 item.setImage(PHPEclipseSQLPlugin.getImage("export.gif")); //$NON-NLS-1$
 107                 item.setToolTipText(Messages.getString("sqlqueryview.exportQuery")); //$NON-NLS-1$
 108                 item.addSelectionListener(new SelectionListener() {
 109                         public void widgetDefaultSelected(SelectionEvent e) {
 110                         }
 111                         public void widgetSelected(SelectionEvent e) {
 112                                 exportQueryAction.run();
 113                         }
 114                 });
 115                 item = new ToolItem(toolbar, SWT.PUSH);
 116                 item.setImage(PHPEclipseSQLPlugin.getImage("php.gif")); //$NON-NLS-1$
 117                 item.setToolTipText(Messages.getString("sqlqueryview.generatePHP")); //$NON-NLS-1$
 118                 item.addSelectionListener(new SelectionListener() {
 119                         public void widgetDefaultSelected(SelectionEvent e) {
 120                         }
 121                         public void widgetSelected(SelectionEvent e) {
 122                                 generatePHPAction.run();
 123                         }
 124                 });
 125                 item = new ToolItem(toolbar, SWT.PUSH);
 126                 item.setImage(PHPEclipseSQLPlugin.getImage("clear.gif")); //$NON-NLS-1$
 127                 item.setToolTipText(Messages.getString("sqlqueryview.clear")); //$NON-NLS-1$
 128                 item.addSelectionListener(new SelectionListener() {
 129                         public void widgetDefaultSelected(SelectionEvent e) {
 130                         }
 131                         public void widgetSelected(SelectionEvent e) {
 132                                 setQuery(""); //$NON-NLS-1$
 133                         }
 134                 });
 135
 136                 item = new ToolItem(toolbar, SWT.SEPARATOR);
 137
 138                 item = new ToolItem(toolbar, SWT.PUSH);
 139                 final ToolItem commit = item;
 140                 item.setImage(PHPEclipseSQLPlugin.getImage("commit.gif")); //$NON-NLS-1$
 141                 item.setToolTipText(Messages.getString("SQLQueryView.Commit")); //$NON-NLS-1$
 142                 item.addSelectionListener(new SelectionListener() {
 143                         public void widgetDefaultSelected(SelectionEvent e) {
 144                         }
 145                         public void widgetSelected(SelectionEvent e) {
 146                                 BookmarkNode node = BookmarkView.getInstance().getCurrentBookmark();
 147                                 MultiSQLServer.getInstance().commit(node.getConnection());
 148                         }
 149                 });
 150                 item.setEnabled(false);
 151
 152                 item = new ToolItem(toolbar, SWT.PUSH);
 153                 final ToolItem rollback = item;
 154                 item.setImage(PHPEclipseSQLPlugin.getImage("rollback.gif")); //$NON-NLS-1$
 155                 item.setToolTipText(Messages.getString("SQLQueryView.RollBack")); //$NON-NLS-1$
 156                 item.addSelectionListener(new SelectionListener() {
 157                         public void widgetDefaultSelected(SelectionEvent e) {
 158                         }
 159                         public void widgetSelected(SelectionEvent e) {
 160                                 BookmarkNode node = BookmarkView.getInstance().getCurrentBookmark();
 161                                 MultiSQLServer.getInstance().rollback(node.getConnection());
 162                         }
 163                 });
 164                 item.setEnabled(false);
 165
 166                 item = new ToolItem(toolbar, SWT.CHECK);
 167                 final ToolItem autocommit = item;
 168                 item.setImage(PHPEclipseSQLPlugin.getImage("autocommit.gif")); //$NON-NLS-1$
 169                 item.setToolTipText(Messages.getString("SQLQueryView.AutoCommit")); //$NON-NLS-1$
 170                 item.addSelectionListener(new SelectionListener() {
 171                         public void widgetDefaultSelected(SelectionEvent e) {
 172                         }
 173                         public void widgetSelected(SelectionEvent e) {
 174                                 BookmarkNode node = BookmarkView.getInstance().getCurrentBookmark();
 175
 176                                 MultiSQLServer.getInstance().setAutoCommit(node.getConnection(), autocommit.getSelection());
 177                                 if (autocommit.getSelection()) {
 178                                         commit.setEnabled(false);
 179                                         rollback.setEnabled(false);
 180                                 } else {
 181                                         commit.setEnabled(true);
 182                                         rollback.setEnabled(true);
 183                                 }
 184                         }
 185                 });
 186                 item.setSelection(true);
 187
 188                 widget = new StyledText(main, SWT.H_SCROLL | SWT.V_SCROLL);
 189
 190                 IActionBars bars = this.getViewSite().getActionBars();
 191                 bars.setGlobalActionHandler(IWorkbenchActionConstants.CUT, cutAction);
 192                 bars.setGlobalActionHandler(IWorkbenchActionConstants.COPY, copyAction);
 193                 bars.setGlobalActionHandler(IWorkbenchActionConstants.PASTE, pasteAction);
 194                 bars.setGlobalActionHandler(IWorkbenchActionConstants.SELECT_ALL, selectAllAction);
 195
 196                 widget.setEditable(true);
 197                 widget.addExtendedModifyListener(modifyListener);
 198
 199                 GridData gridData = new GridData();
 200                 gridData.horizontalAlignment = GridData.FILL;
 201                 gridData.verticalAlignment = GridData.FILL;
 202                 gridData.grabExcessHorizontalSpace = true;
 203                 gridData.grabExcessVerticalSpace = true;
 204                 widget.setLayoutData(gridData);
 205
 206                 Composite bottomStatus = new Composite(main, SWT.NONE);
 207                 gridData = new GridData();
 208                 gridData.horizontalAlignment = GridData.FILL;
 209                 gridData.grabExcessHorizontalSpace = true;
 210                 bottomStatus.setLayoutData(gridData);
 211
 212                 GridLayout horizontal = new GridLayout(3, false);
 213                 layout.horizontalSpacing = 0;
 214                 layout.verticalSpacing = 0;
 215                 layout.marginHeight = 0;
 216                 layout.marginWidth = 0;
 217                 bottomStatus.setLayout(horizontal);
 218
 219                 statusImage = new Label(bottomStatus, SWT.NONE);
 220                 status = new Label(bottomStatus, SWT.NONE);
 221                 gridData = new GridData();
 222                 gridData.horizontalAlignment = GridData.FILL;
 223                 gridData.grabExcessHorizontalSpace = true;
 224                 status.setLayoutData(gridData);
 225
 226                 progress = new ProgressBar(bottomStatus, SWT.HORIZONTAL);
 227
 228                 status.setText(Messages.getString("sqlqueryview.done")); //$NON-NLS-1$
 229                 statusImage.setImage(PHPEclipseSQLPlugin.getImage("success.gif")); //$NON-NLS-1$
 230                 progress.setMinimum(0);
 231         }
 232
 233         public void setProgress(int increment, int max) {
 234                 progress.setMaximum(max);
 235                 progress.setSelection(increment);
 236         }
 237
 238         private void initActions() {
 239                 executeAction = new ExecuteAction();
 240                 executeAction.init(this);
 241                 importQueryAction = new ImportQueryAction();
 242                 importQueryAction.init(this);
 243                 exportQueryAction = new ExportQueryAction();
 244                 exportQueryAction.init(this);
 245                 generatePHPAction = new GeneratePHPAction();
 246                 generatePHPAction.init(this);
 247         }
 248
 249         public void setStatus(String text) {
 250                 statusImage.setImage(null);
 251                 status.setText(text);
 252         }
 253
 254         public void setStatus(Image img, String text) {
 255                 statusImage.setImage(img);
 256                 status.setText(text);
 257         }
 258
 259         public String getQuery() {
 260                 return widget.getText();
 261         }
 262
 263         public void setQuery(String text) {
 264                 widget.setText(text);
 265         }
 266
 267         private String[] keywords = {"SELECT", "DROP", "FROM",  //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
 268                 "INSERT", "INTO", "VALUES", //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
 269                 "CREATE", "TABLE", "VIEW", "SEQUENCE", //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
 270                 "UPDATE", "SET", "WHERE"}; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
 271
 272         SyntaxHighlighter textUpdater = new SyntaxHighlighter();
 273
 274         private class UpdateRequest {
 275                 public UpdateRequest(String text, int start, int length) {
 276                         this.text = text;
 277                         this.start = start;
 278                         this.length = length;
 279                 }
 280                 public String text;
 281                 public int start;
 282                 public int length;
 283         }
 284
 285         private class SyntaxHighlighter extends Thread {
 286                 private boolean running = true;
 287                 private LinkedList requests = new LinkedList();
 288                 public SyntaxHighlighter() {
 289                         super();
 290                         setPriority(Thread.MIN_PRIORITY);
 291                         start();
 292                 }
 293                 public synchronized void updateText(String text, int start, int length) {
 294                         requests.add(new UpdateRequest(text, start, length));
 295                         notify();
 296                 }
 297                 public synchronized void shutdown() {
 298                         running = false;
 299                         interrupt();
 300                 }
 301                 public void run() {
 302                         while (running) {
 303                                 try {
 304                                         synchronized (this) {
 305                                                 if (requests.size() <= 0) {
 306                                                         wait();
 307                                                 } else {
 308                                                         Thread.sleep(10);
 309                                                 }
 310                                         }
 311                                         UpdateRequest request = (UpdateRequest) requests.removeFirst();
 312                                         String text = request.text.toUpperCase();
 313                                         int dirtyStart = request.start;
 314                                         int dirtyEnd = request.start + request.length;
 315                                         StyleRange styleRange;
 316                                         long startTime = System.currentTimeMillis();
 317                                         Vector tokens = SQLLexx.parse(text);
 318                                         long subTime = System.currentTimeMillis();
 319                                         Vector styles = new Vector();
 320                                         int min = Integer.MAX_VALUE;
 321                                         int max = 0;
 322                                         for (int i = 0; i < tokens.size(); i++) {
 323                                                 Token t = (Token) tokens.elementAt(i);
 324                                                 String value = t.getValue();
 325                                                 int start = t.getStart();
 326                                                 int length = t.getEnd() - t.getStart();
 327                                                 styleRange = new StyleRange();
 328                                                 styleRange.start = start;
 329                                                 styleRange.length = value.length();
 330                                                 styleRange.fontStyle = SWT.NULL;
 331                                                 styleRange.foreground = DEFAULT;
 332                                                 boolean upper = start <= dirtyEnd && start >= dirtyStart;
 333                                                 boolean lower = ((start + length) >= dirtyStart && (start + length) <= dirtyEnd);
 334                                                 boolean both = (start <= dirtyStart && (start + length) >= dirtyEnd);
 335                                                 if (upper || lower || both) {
 336                                                         min = Math.min(start, min);
 337                                                         max = Math.max(max, start + length);
 338                                                         if (t.getType() == Token.IDENTIFIER) {
 339                                                                 boolean keyword = false;
 340                                                                 for (int index = 0; index < keywords.length; index++) {
 341                                                                         if (value.equals(keywords[index])) {
 342                                                                                 keyword = true;
 343                                                                         }
 344                                                                 }
 345                                                                 if (keyword) {
 346                                                                         styleRange.fontStyle = SWT.BOLD;
 347                                                                         styleRange.foreground = KEYWORD;
 348                                                                 } else {
 349                                                                         styleRange.foreground = DEFAULT;
 350                                                                 }
 351                                                                 styles.addElement(styleRange);
 352                                                         } else if (t.getType() == Token.COMMENT) {
 353                                                                 styleRange.foreground = COMMENT;
 354                                                                 styles.addElement(styleRange);
 355                                                         } else if (t.getType() == Token.LITERAL) {
 356                                                                 styleRange.foreground = STRING_LITERAL;
 357                                                                 styles.addElement(styleRange);
 358                                                         } else if (t.getType() == Token.NUMERIC) {
 359                                                                 styleRange.foreground = NUMERIC;
 360                                                                 styles.addElement(styleRange);
 361                                                         } else {
 362                                                                 styles.addElement(styleRange);
 363                                                         }
 364                                                 }
 365                                         }
 366                                         StyleRange[] ranges = new StyleRange[styles.size()];
 367                                         for (int k = 0; k < ranges.length; k++) {
 368                                                 ranges[k] = (StyleRange) styles.elementAt(k);
 369                                         }
 370                                         if (max >= 0 && ranges.length > 0) {
 371                                                 setStyles(ranges, min, max - min);
 372                                         }
 373                                         long endTime = System.currentTimeMillis();
 374                                         parseTime = subTime - startTime;
 375                                         fullTime = endTime - startTime;
 376                                 } catch (NoSuchElementException e) {
 377                                         // ignore a missing request
 378                                 } catch (InterruptedException e) {
 379                                         // ignore any interruptions
 380                                 }
 381                         }
 382                 }
 383         }
 384         public void setStyles(final StyleRange[] styles, final int start, final int length) {
 385                 getViewSite().getShell().getDisplay().asyncExec(new Runnable() {
 386                         public void run() {
 387                                 try {
 388                                         for (int i = 0; i < styles.length; i++) {
 389                                                 widget.setStyleRange(styles[i]);
 390                                         }
 391                                 } catch (Throwable t) {
 392                                         System.out.println("Error with styles: " + t.getClass().toString()); //$NON-NLS-1$
 393                                         // ignore any errors
 394                                 }
 395                         }
 396                 });
 397         }
 398
 399         ExtendedModifyListener modifyListener = new ExtendedModifyListener() {
 400                 public void modifyText(ExtendedModifyEvent event) {
 401                         textUpdater.updateText(getQuery(), event.start, event.length);
 402                 }
 403         };
 404
 405         private Action cutAction = new Action() {
 406                 public void run() {
 407                         widget.cut();
 408                 }
 409         };
 410         private Action copyAction = new Action() {
 411                 public void run() {
 412                         widget.copy();
 413                 }
 414         };
 415         private Action pasteAction = new Action() {
 416                 public void run() {
 417                         widget.paste();
 418                 }
 419         };
 420         private Action selectAllAction = new Action() {
 421                 public void run() {
 422                         widget.selectAll();
 423                 }
 424         };
 425 }