Open PHP perspective automatically then a new PHP Project is created
[phpeclipse.git] / net.sourceforge.phpeclipse / src / net / sourceforge / phpeclipse / actions / PHPOpenSQLTableEditorAction.java
index 848a1ca..5eda806 100644 (file)
@@ -1,28 +1,21 @@
-/*******************************************************************************
- * Copyright (c) 2000, 2002 IBM Corp. and others. All rights reserved. This
- * program and the accompanying materials are made available under the terms of
- * the Common Public License v1.0 which accompanies this distribution, and is
- * available at http://www.eclipse.org/legal/cpl-v10.html
+/***********************************************************************************************************************************
+ * Copyright (c) 2000, 2002 IBM Corp. and others. All rights reserved. This program and the accompanying materials are made
+ * available under the terms of the Common Public License v1.0 which accompanies this distribution, and is available at
+ * http://www.eclipse.org/legal/cpl-v10.html
  * 
- * Contributors: Klaus Hartlage - www.eclipseproject.de
- ******************************************************************************/
+ * Contributors: www.phpeclipse.de
+ **********************************************************************************************************************************/
 package net.sourceforge.phpeclipse.actions;
 
-import java.sql.Connection;
-import java.sql.DatabaseMetaData;
-import java.sql.ResultSet;
 import java.sql.SQLException;
-import java.util.ArrayList;
 
-import net.sourceforge.phpeclipse.IPreferenceConstants;
-import net.sourceforge.phpeclipse.PHPeclipsePlugin;
-import net.sourceforge.phpeclipse.overlaypages.Util;
 import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
+import net.sourceforge.phpeclipse.ui.WebUI;
+import net.sourceforge.phpeclipse.ui.overlaypages.ProjectPrefUtil;
 
 import org.eclipse.core.resources.IContainer;
 import org.eclipse.core.resources.IFile;
 import org.eclipse.core.resources.IProject;
-import org.eclipse.core.runtime.CoreException;
 import org.eclipse.core.runtime.Path;
 import org.eclipse.jface.action.IAction;
 import org.eclipse.jface.text.BadLocationException;
@@ -30,8 +23,6 @@ import org.eclipse.jface.text.IDocument;
 import org.eclipse.jface.text.ITextSelection;
 import org.eclipse.jface.text.TextSelection;
 import org.eclipse.jface.viewers.ISelection;
-import org.eclipse.jface.viewers.LabelProvider;
-import org.eclipse.jface.window.Window;
 import org.eclipse.swt.graphics.Point;
 import org.eclipse.ui.IEditorActionDelegate;
 import org.eclipse.ui.IEditorPart;
@@ -41,244 +32,286 @@ import org.eclipse.ui.IWorkbenchPage;
 import org.eclipse.ui.IWorkbenchWindow;
 import org.eclipse.ui.PartInitException;
 import org.eclipse.ui.actions.ActionDelegate;
-import org.eclipse.ui.dialogs.ListSelectionDialog;
-import org.eclipse.ui.internal.dialogs.ListContentProvider;
 
+import com.quantum.ExternalInterface;
 import com.quantum.QuantumPlugin;
-import com.quantum.model.Bookmark;
-import com.quantum.model.BookmarkCollection;
-import com.quantum.model.Entity;
-import com.quantum.model.EntityFactory;
 import com.quantum.model.NotConnectedException;
-import com.quantum.util.connection.ConnectionUtil;
 import com.quantum.view.tableview.TableView;
 
-public class PHPOpenSQLTableEditorAction extends ActionDelegate
-               implements
-                       IEditorActionDelegate {
+public class PHPOpenSQLTableEditorAction extends ActionDelegate implements IEditorActionDelegate {
 
-       private IWorkbenchWindow fWindow;
-       private PHPEditor fEditor;
-       private IProject fProject;
+  private IWorkbenchWindow fWindow;
 
-       public void dispose() {
-       }
+  private PHPEditor fEditor;
 
-       public void init(IWorkbenchWindow window) {
-               this.fWindow = window;
-       }
+  private IProject fProject;
 
-       public void selectionChanged(IAction action, ISelection selection) {
-               if (!selection.isEmpty()) {
-                       if (selection instanceof TextSelection) {
-                               action.setEnabled(true);
-                       } else if (fWindow.getActivePage() != null
-                                       && fWindow.getActivePage().getActivePart() != null) {
-                               //
-                       }
-               }
-       }
-       private IWorkbenchPage getActivePage() {
-               IWorkbenchWindow workbenchWindow = fEditor.getEditorSite()
-                               .getWorkbenchWindow();
-               IWorkbenchPage page = workbenchWindow.getActivePage();
-               return page;
-       }
-       public IContainer getWorkingLocation(IFileEditorInput editorInput) {
-               if (editorInput == null || editorInput.getFile() == null) {
-                       return null;
-               }
-               return editorInput.getFile().getParent();
-       }
-       private IFile getIncludeFile(IProject project,
-                       IFileEditorInput editorInput, String relativeFilename) {
-               //              IContainer container = getWorkingLocation(editorInput);
-               //              String fullPath = project.getLocation().toString();
-               Path path = new Path(relativeFilename);
-               IFile file = project.getFile(path);
-               return file;
-       }
+  public void dispose() {
+  }
 
-       public void run(IAction action) {
-               if (fEditor == null) {
-                       IEditorPart targetEditor = fWindow.getActivePage()
-                                       .getActiveEditor();
-                       if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
-                               fEditor = (PHPEditor) targetEditor;
-                       }
-               }
-               if (fEditor != null) {
-                       //                      TableView view = TableView.getInstance();
+  public void init(IWorkbenchWindow window) {
+    this.fWindow = window;
+  }
 
-                       //                      determine the current Project from a (file-based) Editor
-                       IFile f = ((IFileEditorInput) fEditor.getEditorInput()).getFile();
-                       fProject = f.getProject();
+  public void selectionChanged(IAction action, ISelection selection) {
+    if (!selection.isEmpty()) {
+      if (selection instanceof TextSelection) {
+        action.setEnabled(true);
+      } else if (fWindow.getActivePage() != null && fWindow.getActivePage().getActivePart() != null) {
+        //
+      }
+    }
+  }
 
-                       ITextSelection selection = (ITextSelection) fEditor
-                                       .getSelectionProvider().getSelection();
-                       IDocument doc = fEditor.getDocumentProvider().getDocument(
-                                       fEditor.getEditorInput());
-                       int pos = selection.getOffset();
-                       //  System.out.println(selection.getText());
-                       String tableName = getSQLTableName(doc, pos);
+  private IWorkbenchPage getActivePage() {
+    fWindow = fEditor.getEditorSite().getWorkbenchWindow();
+    IWorkbenchPage page = fWindow.getActivePage();
+    return page;
+  }
 
-                       IViewPart viewPart = null;
-                       String view = "com.quantum.view.tableview.TableView";
-                       try {
-                               IWorkbenchPage page = QuantumPlugin.getDefault()
-                                               .getActivePage();
-                               viewPart = page.findView(view);
-                               if (viewPart == null) {
-                                       viewPart = page.showView(view);
-                               }
-                               page.bringToTop(viewPart);
-                               getTables((TableView) viewPart, fProject, tableName);
-                       } catch (PartInitException e) {
-                               e.printStackTrace();
-                       }
+  public IContainer getWorkingLocation(IFileEditorInput editorInput) {
+    if (editorInput == null || editorInput.getFile() == null) {
+      return null;
+    }
+    return editorInput.getFile().getParent();
+  }
 
-               }
-       }
+  private IFile getIncludeFile(IProject project, IFileEditorInput editorInput, String relativeFilename) {
+    //         IContainer container = getWorkingLocation(editorInput);
+    //         String fullPath = project.getLocation().toString();
+    Path path = new Path(relativeFilename);
+    IFile file = project.getFile(path);
+    return file;
+  }
 
-       public void setActiveEditor(IAction action, IEditorPart targetEditor) {
-               if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
-                       fEditor = (PHPEditor) targetEditor;
-               }
-       }
+  public void run(IAction action) {
+    if (fEditor == null) {
+      IEditorPart targetEditor = fWindow.getActivePage().getActiveEditor();
+      if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
+        fEditor = (PHPEditor) targetEditor;
+      }
+    }
+    if (fEditor != null) {
+      fWindow = fEditor.getEditorSite().getWorkbenchWindow();
+      IFile f = ((IFileEditorInput) fEditor.getEditorInput()).getFile();
+      fProject = f.getProject();
+      String bookmarkString = ProjectPrefUtil.getMiscProjectsPreferenceValue(fProject, WebUI.PHP_BOOKMARK_DEFAULT);
+      if (bookmarkString != null && !bookmarkString.equals("")) {
+        ITextSelection selection = (ITextSelection) fEditor.getSelectionProvider().getSelection();
+        IDocument doc = fEditor.getDocumentProvider().getDocument(fEditor.getEditorInput());
+        int pos = selection.getOffset();
+        //  System.out.println(selection.getText());
+        String tableName = getSQLTableName(doc, pos);
+        if (tableName != null && tableName.length() > 0)
+          try {
+            ExternalInterface.displayTable(bookmarkString, tableName);
+            
+            IViewPart viewPart = null;
+            String view = "com.quantum.view.tableview.TableView";
+            try {
+              IWorkbenchPage page = QuantumPlugin.getDefault().getActivePage();
+              viewPart = page.findView(view);
+              if (viewPart == null) {
+                viewPart = page.showView(view);
+              }
+              page.bringToTop(viewPart);
+            } catch (PartInitException e) {
+              e.printStackTrace();
+            }
+          } catch (NotConnectedException e) {
+            // TODO Auto-generated catch block
+            e.printStackTrace();
+          } catch (SQLException e) {
+            // TODO Auto-generated catch block
+            e.printStackTrace();
+          }
+      }
 
-       private String getSQLTableName(IDocument doc, int pos) {
-               Point word = null;
-               int start = -1;
-               int end = -1;
+      //
+      //      IViewPart viewPart = null;
+      //      String view = "com.quantum.view.tableview.TableView";
+      //      try {
+      //        IWorkbenchPage page = QuantumPlugin.getDefault().getActivePage();
+      //        viewPart = page.findView(view);
+      //        if (viewPart == null) {
+      //          viewPart = page.showView(view);
+      //        }
+      //        page.bringToTop(viewPart);
+      //        getTables((TableView) viewPart, fProject, tableName);
+      //      } catch (PartInitException e) {
+      //        e.printStackTrace();
+      //      }
 
-               try {
+    }
+  }
 
-                       int position = pos;
-                       char character;
+  public void setActiveEditor(IAction action, IEditorPart targetEditor) {
+    if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
+      fEditor = (PHPEditor) targetEditor;
+    }
+  }
 
-                       while (position >= 0) {
-                               character = doc.getChar(position);
-                               if (Character.isWhitespace(character) || (character == '\"')
-                                               || (character == '\'') || (character == '\r')
-                                               || (character == '\n'))
-                                       break;
-                               --position;
-                       }
+  private String getSQLTableName(IDocument doc, int pos) {
+    Point word = null;
+    int start = -1;
+    int end = -1;
 
-                       start = position;
+    try {
 
-                       position = pos;
-                       int length = doc.getLength();
+      int position = pos;
+      char character;
 
-                       while (position < length) {
-                               character = doc.getChar(position);
-                               if (Character.isWhitespace(character) || (character == '\"')
-                                               || (character == '\'') || (character == '\r')
-                                               || (character == '\n'))
-                                       break;
-                               ++position;
-                       }
+      while (position >= 0) {
+        character = doc.getChar(position);
+        if (Character.isWhitespace(character) || (character == '\"') || (character == '\'') || (character == '\r')
+            || (character == '\n'))
+          break;
+        --position;
+      }
 
-                       start++;
-                       end = position;
+      start = position;
 
-                       if (end > start)
-                               word = new Point(start, end - start);
+      position = pos;
+      int length = doc.getLength();
 
-               } catch (BadLocationException x) {
-               }
+      while (position < length) {
+        character = doc.getChar(position);
+        if (Character.isWhitespace(character) || (character == '\"') || (character == '\'') || (character == '\r')
+            || (character == '\n'))
+          break;
+        ++position;
+      }
 
-               if (word != null) {
-                       try {
-                               return doc.get(word.x, word.y);
-                       } catch (BadLocationException e) {
-                       }
-               }
-               return "";
-       }
+      start++;
+      end = position;
 
-       public void getTables(TableView tableView, IProject project,
-                       String tableName) {
-               // Get The Database bookmark from the Quantum SQL plugin:
-               BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
-               if (sqlBookMarks != null) {
-                       String bookmarkString = Util.getMiscProjectsPreferenceValue(
-                                       project, IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
-                       if (bookmarkString != null && !bookmarkString.equals("")) {
-                               Bookmark bookmark = sqlBookMarks.find(bookmarkString);
-                               ArrayList sqlList = new ArrayList();
-                               if (bookmark != null && !bookmark.isConnected()) {
-                                       new ConnectionUtil().connect(bookmark, null);
-                               }
-                               if (bookmark != null && bookmark.isConnected()) {
-                                       try {
-                                               Connection connection = bookmark.getConnection();
-                                               DatabaseMetaData metaData = connection.getMetaData();
+      if (end > start)
+        word = new Point(start, end - start);
 
-                                               if (metaData != null) {
-                                                       String columnName;
-                                                       String prefixWithoutDollar = tableName;
-                                                       if (prefixWithoutDollar.charAt(0) == '$') {
-                                                               prefixWithoutDollar = prefixWithoutDollar
-                                                                               .substring(1);
-                                                       }
-                                                       ResultSet set;
-                                                       set = metaData.getTables(null, null, "%"
-                                                                       + prefixWithoutDollar+"%", null);
-                                                       while (set.next()) {
-                                                               tableName = set.getString("TABLE_NAME");
-                                                               tableName = (tableName == null)
-                                                                               ? ""
-                                                                               : tableName.trim();
-                                                               if (tableName != null && tableName.length() > 0) {
-                                                                       sqlList.add(tableName);
-                                                               }
-                                                       }
-                                                       set.close();
-                                                       EntityFactory entityFactory = EntityFactory
-                                                                       .getInstance();
-                                                       if (sqlList.size() == 1) {
-                                                               tableView.loadTable(entityFactory.create(
-                                                                               bookmark, null,
-                                                                               (String) sqlList.get(0),
-                                                                               Entity.TABLE_TYPE));
-                                                       } else if (sqlList.size() > 1) {
-                                                               ListSelectionDialog listSelectionDialog = new ListSelectionDialog(
-                                                                               PHPeclipsePlugin.getDefault()
-                                                                                               .getWorkbench()
-                                                                                               .getActiveWorkbenchWindow()
-                                                                                               .getShell(), sqlList,
-                                                                               new ListContentProvider(),
-                                                                               new LabelProvider(),
-                                                                               "Select the SQL to open.");
-                                                               listSelectionDialog
-                                                                               .setTitle("Multiple tablenames found");
-                                                               if (listSelectionDialog.open() == Window.OK) {
-                                                                       Object[] locations = listSelectionDialog
-                                                                                       .getResult();
-                                                                       if (locations != null) {
-                                                                               for (int i = 0; i < locations.length; i++) {
-                                                                                       tableView
-                                                                                                       .loadTable(entityFactory
-                                                                                                                       .create(
-                                                                                                                                       bookmark,
-                                                                                                                                       null,
-                                                                                                                                       (String) locations[i],
-                                                                                                                                       Entity.TABLE_TYPE));    
-                                                                               }
+    } catch (BadLocationException x) {
+    }
 
-                                                                       }
-                                                               }
-                                                       }
-                                               }
-                                       } catch (NotConnectedException e) {
-                                               // ignore this - not mission critical
-                                       } catch (SQLException e) {
-                                               e.printStackTrace();
-                                       }
-                               }
-                       }
-               }
-       }
+    if (word != null) {
+      try {
+        return doc.get(word.x, word.y);
+      } catch (BadLocationException e) {
+      }
+    }
+    return "";
+  }
+
+  //  public void getTables(TableView tableView, IProject project, String tableName) {
+  //    // Get The Database bookmark from the Quantum SQL plugin:
+  //    BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
+  //    if (sqlBookMarks != null) {
+  //      String bookmarkString = ProjectPrefUtil.getMiscProjectsPreferenceValue(project,
+  //          WebUI.PHP_BOOKMARK_DEFAULT);
+  //      if (bookmarkString != null && !bookmarkString.equals("")) {
+  //        Bookmark bookmark = sqlBookMarks.find(bookmarkString);
+  //        ArrayList sqlList = new ArrayList();
+  //        if (bookmark != null && !bookmark.isConnected()) {
+  //          new ConnectionUtil().connect(bookmark, null);
+  //        }
+  //        if (bookmark != null && bookmark.isConnected()) {
+  //          try {
+  //            Connection connection = bookmark.getConnection();
+  //            DatabaseMetaData metaData = connection.getMetaData();
+  //            ConnectionUtil connectionUtil = new ConnectionUtil();
+  //            Entity entity;
+  //            DatabaseAdapter adapter;
+  //
+  //            if (metaData != null) {
+  //              String columnName;
+  //              String prefixWithoutDollar = tableName;
+  //              if (prefixWithoutDollar.charAt(0) == '$') {
+  //                prefixWithoutDollar = prefixWithoutDollar.substring(1);
+  //              }
+  //              ResultSet set;
+  //              set = metaData.getTables(null, null, "%" + prefixWithoutDollar
+  //                  + "%", null);
+  //              while (set.next()) {
+  //                tableName = set.getString("TABLE_NAME");
+  //                tableName = (tableName == null) ? "" : tableName.trim();
+  //                if (tableName != null && tableName.length() > 0) {
+  //                  sqlList.add(tableName);
+  //                }
+  //              }
+  //              set.close();
+  //              EntityFactory entityFactory = EntityFactory.getInstance();
+  //              if (sqlList.size() == 1) {
+  //                adapter = bookmark.getAdapter();
+  //                entity = entityFactory.create(bookmark, null, (String) sqlList
+  //                    .get(0), Entity.TABLE_TYPE, false);
+  //                String query = adapter.getTableQuery(entity.getQualifiedName());
+  //
+  //                try {
+  //                  SQLResults results = MultiSQLServer.getInstance().execute(
+  //                      bookmark, connectionUtil.connect(bookmark, fWindow.getShell()),
+  //                      entity, query);
+  //
+  //                  if (results != null && results.isResultSet()) {
+  //                    SQLResultSetCollection.getInstance().addSQLResultSet(
+  //                        (SQLResultSetResults) results);
+  //                  }
+  //                } catch (SQLException e) {
+  //                  ExceptionDisplayDialog.openError(fWindow.getShell(), null, null, e);
+  //                }
+  //                // tableView.loadTable(entityFactory.create(
+  //                // bookmark, null,
+  //                // (String) sqlList.get(0),
+  //                // Entity.TABLE_TYPE));
+  //              } else if (sqlList.size() > 1) {
+  //                ListSelectionDialog listSelectionDialog = new ListSelectionDialog(
+  //                    PHPeclipsePlugin.getDefault().getWorkbench()
+  //                        .getActiveWorkbenchWindow().getShell(), sqlList,
+  //                    new ListContentProvider(), new LabelProvider(),
+  //                    "Select the SQL table to open.");
+  //                listSelectionDialog.setTitle("Multiple tablenames found");
+  //                if (listSelectionDialog.open() == Window.OK) {
+  //                  Object[] locations = listSelectionDialog.getResult();
+  //                  if (locations != null) {
+  //                    for (int i = 0; i < locations.length; i++) {
+  //                      adapter = bookmark.getAdapter();
+  //                      entity = entityFactory.create(bookmark, null,
+  //                          (String) locations[i], Entity.TABLE_TYPE, false);
+  //                      String query = adapter.getTableQuery(entity
+  //                          .getQualifiedName());
+  //
+  //                      try {
+  //                        SQLResults results = MultiSQLServer.getInstance()
+  //                            .execute(bookmark,
+  //                                connectionUtil.connect(bookmark, fWindow.getShell()),
+  //                                entity, query);
+  //
+  //                        if (results != null && results.isResultSet()) {
+  //                          SQLResultSetCollection.getInstance().addSQLResultSet(
+  //                              (SQLResultSetResults) results);
+  //                        }
+  //                      } catch (SQLException e) {
+  //                        ExceptionDisplayDialog.openError(fWindow.getShell(), null, null, e);
+  //                      }
+  //
+  //                      // tableView
+  //                      // .loadTable(entityFactory
+  //                      // .create(
+  //                      // bookmark,
+  //                      // null,
+  //                      // (String) locations[i],
+  //                      // Entity.TABLE_TYPE));
+  //                    }
+  //
+  //                  }
+  //                }
+  //              }
+  //            }
+  //          } catch (NotConnectedException e) {
+  //            // ignore this - not mission critical
+  //          } catch (SQLException e) {
+  //            e.printStackTrace();
+  //          }
+  //        }
+  //      }
+  //    }
+  //  }
 
 }
\ No newline at end of file