X-Git-Url: http://secure.phpeclipse.com
diff --git a/net.sourceforge.phpeclipse/src/net/sourceforge/phpeclipse/phpeditor/php/PHPCompletionProcessor.java b/net.sourceforge.phpeclipse/src/net/sourceforge/phpeclipse/phpeditor/php/PHPCompletionProcessor.java
index 976f385..c8755e0 100644
--- a/net.sourceforge.phpeclipse/src/net/sourceforge/phpeclipse/phpeditor/php/PHPCompletionProcessor.java
+++ b/net.sourceforge.phpeclipse/src/net/sourceforge/phpeclipse/phpeditor/php/PHPCompletionProcessor.java
@@ -1,41 +1,51 @@
/**********************************************************************
-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:
- IBM Corporation - Initial implementation
- Klaus Hartlage - www.eclipseproject.de
-**********************************************************************/
+ 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:
+ IBM Corporation - Initial implementation
+ **********************************************************************/
package net.sourceforge.phpeclipse.phpeditor.php;
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.ResultSet;
+import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
+import java.util.HashSet;
import java.util.List;
import java.util.SortedMap;
+import net.sourceforge.phpdt.core.ICompilationUnit;
+import net.sourceforge.phpdt.core.IJavaElement;
+import net.sourceforge.phpdt.core.IMethod;
+import net.sourceforge.phpdt.core.ISourceRange;
import net.sourceforge.phpdt.core.ToolFactory;
import net.sourceforge.phpdt.core.compiler.ITerminalSymbols;
import net.sourceforge.phpdt.core.compiler.InvalidInputException;
import net.sourceforge.phpdt.internal.compiler.parser.Scanner;
-import net.sourceforge.phpdt.internal.corext.template.ContextType;
-import net.sourceforge.phpdt.internal.corext.template.ContextTypeRegistry;
-import net.sourceforge.phpdt.internal.corext.template.php.CompilationUnitContextType;
-import net.sourceforge.phpdt.internal.corext.template.php.PHPUnitContext;
+import net.sourceforge.phpdt.internal.corext.template.php.JavaContext;
+import net.sourceforge.phpdt.internal.corext.template.php.JavaContextType;
+import net.sourceforge.phpdt.internal.ui.PHPUiImages;
import net.sourceforge.phpdt.internal.ui.text.java.IPHPCompletionProposal;
import net.sourceforge.phpdt.internal.ui.text.java.PHPCompletionProposalComparator;
import net.sourceforge.phpdt.internal.ui.text.template.BuiltInEngine;
import net.sourceforge.phpdt.internal.ui.text.template.DeclarationEngine;
import net.sourceforge.phpdt.internal.ui.text.template.IdentifierEngine;
-import net.sourceforge.phpdt.internal.ui.text.template.TemplateEngine;
+import net.sourceforge.phpdt.internal.ui.text.template.LocalVariableProposal;
+import net.sourceforge.phpdt.internal.ui.text.template.SQLProposal;
+import net.sourceforge.phpdt.internal.ui.text.template.contentassist.TemplateEngine;
+import net.sourceforge.phpdt.ui.IWorkingCopyManager;
import net.sourceforge.phpeclipse.PHPeclipsePlugin;
import net.sourceforge.phpeclipse.builder.IdentifierIndexManager;
-import net.sourceforge.phpeclipse.phpeditor.AbstractContentOutlinePage;
-import net.sourceforge.phpeclipse.phpeditor.PHPContentOutlinePage;
import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
import net.sourceforge.phpeclipse.phpeditor.PHPSyntaxRdr;
+import net.sourceforge.phpeclipse.ui.IPreferenceConstants;
+import net.sourceforge.phpeclipse.ui.overlaypages.ProjectPrefUtil;
import org.eclipse.core.resources.IFile;
import org.eclipse.core.resources.IProject;
@@ -51,21 +61,26 @@ import org.eclipse.jface.text.contentassist.IContextInformation;
import org.eclipse.jface.text.contentassist.IContextInformationExtension;
import org.eclipse.jface.text.contentassist.IContextInformationPresenter;
import org.eclipse.jface.text.contentassist.IContextInformationValidator;
+import org.eclipse.jface.text.templates.DocumentTemplateContext;
+import org.eclipse.jface.text.templates.TemplateContextType;
import org.eclipse.swt.graphics.Image;
+import org.eclipse.swt.graphics.Point;
import org.eclipse.ui.IEditorPart;
import org.eclipse.ui.IFileEditorInput;
+import com.quantum.model.Bookmark;
+import com.quantum.model.BookmarkCollection;
+import com.quantum.model.NotConnectedException;
+import com.quantum.util.connection.ConnectionUtil;
+
/**
* Example PHP completion processor.
*/
public class PHPCompletionProcessor implements IContentAssistProcessor {
-
/**
- * Simple content assist tip closer. The tip is valid in a range
- * of 5 characters around its popup location.
+ * Simple content assist tip closer. The tip is valid in a range of 5 characters around its popup location.
*/
protected static class Validator implements IContextInformationValidator, IContextInformationPresenter {
-
protected int fInstallOffset;
/*
@@ -91,8 +106,8 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
};
private static class ContextInformationWrapper implements IContextInformation, IContextInformationExtension {
-
private final IContextInformation fContextInformation;
+
private int fPosition;
public ContextInformationWrapper(IContextInformation contextInformation) {
@@ -107,8 +122,8 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
}
/*
- * @see IContextInformation#getImage()
- */
+ * @see IContextInformation#getImage()
+ */
public Image getImage() {
return fContextInformation.getImage();
}
@@ -132,208 +147,91 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
}
};
- // public final class VariablesCompletionProposal implements IJavaCompletionProposal {
- // private String fDisplayString;
- // private String fReplacementString;
- // private int fReplacementOffset;
- // private int fReplacementLength;
- // private int fCursorPosition;
- // private Image fImage;
- // private IContextInformation fContextInformation;
- // private String fAdditionalProposalInfo;
- //
- // /**
- // * Creates a new completion proposal based on the provided information. The replacement string is
- // * considered being the display string too. All remaining fields are set to null.
- // *
- // * @param replacementString the actual string to be inserted into the document
- // * @param replacementOffset the offset of the text to be replaced
- // * @param replacementLength the length of the text to be replaced
- // * @param cursorPosition the position of the cursor following the insert relative to replacementOffset
- // */
- // public VariablesCompletionProposal(
- // String replacementString,
- // int replacementOffset,
- // int replacementLength,
- // int cursorPosition) {
- // this(replacementString, replacementOffset, replacementLength, cursorPosition, null, null, null, null);
- // }
- //
- // /**
- // * Creates a new completion proposal. All fields are initialized based on the provided information.
- // *
- // * @param replacementString the actual string to be inserted into the document
- // * @param replacementOffset the offset of the text to be replaced
- // * @param replacementLength the length of the text to be replaced
- // * @param cursorPosition the position of the cursor following the insert relative to replacementOffset
- // * @param image the image to display for this proposal
- // * @param displayString the string to be displayed for the proposal
- // * @param contentInformation the context information associated with this proposal
- // * @param additionalProposalInfo the additional information associated with this proposal
- // */
- // public VariablesCompletionProposal(
- // String replacementString,
- // int replacementOffset,
- // int replacementLength,
- // int cursorPosition,
- // Image image,
- // String displayString,
- // IContextInformation contextInformation,
- // String additionalProposalInfo) {
- // // Assert.isNotNull(replacementString);
- // // Assert.isTrue(replacementOffset >= 0);
- // // Assert.isTrue(replacementLength >= 0);
- // // Assert.isTrue(cursorPosition >= 0);
- //
- // fReplacementString = replacementString;
- // fReplacementOffset = replacementOffset;
- // fReplacementLength = replacementLength;
- // fCursorPosition = cursorPosition;
- // fImage = image;
- // fDisplayString = displayString;
- // fContextInformation = contextInformation;
- // fAdditionalProposalInfo = additionalProposalInfo;
- // }
- //
- // /*
- // * @see ICompletionProposal#apply
- // */
- // public void apply(IDocument document) {
- // try {
- // document.replace(fReplacementOffset, fReplacementLength, fReplacementString);
- // } catch (BadLocationException x) {
- // // ignore
- // }
- // }
- //
- // /*
- // * @see ICompletionProposal#getSelection
- // */
- // public Point getSelection(IDocument document) {
- // return new Point(fReplacementOffset + fCursorPosition, 0);
- // }
- //
- // /*
- // * @see ICompletionProposal#getContextInformation()
- // */
- // public IContextInformation getContextInformation() {
- // return fContextInformation;
- // }
- //
- // /*
- // * @see ICompletionProposal#getImage()
- // */
- // public Image getImage() {
- // return fImage;
- // }
- //
- // /*
- // * @see ICompletionProposal#getDisplayString()
- // */
- // public String getDisplayString() {
- // if (fDisplayString != null)
- // return fDisplayString;
- // return fReplacementString;
- // }
- //
- // /*
- // * @see ICompletionProposal#getAdditionalProposalInfo()
- // */
- // public String getAdditionalProposalInfo() {
- // return fAdditionalProposalInfo;
- // }
- // /**
- // * Returns the relevance of the proposal.
- // */
- // public int getRelevance() {
- // return 0;
- // }
- // }
-
-// protected final static String[] fgProposals = PHPFunctionNames.FUNCTION_NAMES;
+ private class TableName {
+ String fTableName;
+
+ TableName() {
+ fTableName = null;
+ }
+
+ /**
+ * @return Returns the tableName.
+ */
+ public String getTableName() {
+ if (fTableName == null) {
+ return "";
+ }
+ return fTableName;
+ }
+
+ /**
+ * @param tableName
+ * The tableName to set.
+ */
+ public void setTableName(String tableName) {
+ fTableName = tableName;
+ }
+ }
private char[] fProposalAutoActivationSet;
+
protected IContextInformationValidator fValidator = new Validator();
+
private TemplateEngine fTemplateEngine;
+
private PHPCompletionProposalComparator fComparator;
+
private int fNumberOfComputedResults = 0;
- public PHPCompletionProcessor() {
+ private IEditorPart fEditor;
+
+ protected IWorkingCopyManager fManager;
- ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+ public PHPCompletionProcessor(IEditorPart editor) {
+ fEditor = editor;
+ fManager = PHPeclipsePlugin.getDefault().getWorkingCopyManager();
+ TemplateContextType contextType = PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType("php"); //$NON-NLS-1$
if (contextType != null)
fTemplateEngine = new TemplateEngine(contextType);
-
fComparator = new PHPCompletionProposalComparator();
}
/**
* Tells this processor to order the proposals alphabetically.
*
- * @param order true if proposals should be ordered.
+ * @param order
+ * true if proposals should be ordered.
*/
public void orderProposalsAlphabetically(boolean order) {
fComparator.setOrderAlphabetically(order);
}
/**
- * Sets this processor's set of characters triggering the activation of the
- * completion proposal computation.
+ * Sets this processor's set of characters triggering the activation of the completion proposal computation.
*
- * @param activationSet the activation set
+ * @param activationSet
+ * the activation set
*/
public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
fProposalAutoActivationSet = activationSet;
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
+
+ /*
+ * (non-Javadoc) Method declared on IContentAssistProcessor
*/
public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer, int documentOffset) {
- // IDocument document = viewer.getDocument();
- // if (documentOffset > 0) {
- // try {
- // ICompletionProposal[] result;
- // char character = document.getChar(documentOffset - 1);
- // if (character == '$') {
- ////viewer. .getActivePage().getActiveEditor();
- // result = new ICompletionProposal[fgProposals.length];
- // for (int i = 0; i < fgProposals.length; i++) {
- // IContextInformation info = new ContextInformation(fgProposals[i], MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
- // result[i] = new CompletionProposal(fgProposals[i], documentOffset, 0, fgProposals[i].length(), null, fgProposals[i], info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
- // }
- // return result;
- // }
- // } catch (BadLocationException e) {
- // return new ICompletionProposal[0];
- // }
- // }
- //
- // ICompletionProposal[] result = new ICompletionProposal[fgProposals.length];
- // for (int i = 0; i < fgProposals.length; i++) {
- // IContextInformation info = new ContextInformation(fgProposals[i], MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
- // result[i] = new CompletionProposal(fgProposals[i], documentOffset, 0, fgProposals[i].length(), null, fgProposals[i], info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { fgProposals[i] })); //$NON-NLS-1$
- // }
- // return result;
int contextInformationPosition = guessContextInformationPosition(viewer, documentOffset);
return internalComputeCompletionProposals(viewer, documentOffset, contextInformationPosition);
-
}
- private boolean isReference(ITextViewer viewer, int completionPosition) {
+ private int getLastToken(ITextViewer viewer, int completionPosition, JavaContext context, TableName tableName) {
IDocument document = viewer.getDocument();
- ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
- ((CompilationUnitContextType) contextType).setContextParameters(document, completionPosition, 0);
-
- PHPUnitContext context = (PHPUnitContext) contextType.createContext();
int start = context.getStart();
int end = context.getEnd();
- String prefix = context.getKey();
- IRegion region = new Region(start, end - start);
-
String startText;
- boolean useClassEntries = false;
+ int lastSignificantToken = ITerminalSymbols.TokenNameEOF;
try {
- // search begin of 2 lines behind this
+ // begin search 2 lines behind of this
int j = start;
if (j != 0) {
char ch;
@@ -353,152 +251,524 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
if (j != start) {
// scan the line for the dereferencing operator '->'
startText = document.get(j, start - j);
- // System.out.println(startText);
+ if (Scanner.DEBUG) {
+ System.out.println(startText);
+ }
+ int token = ITerminalSymbols.TokenNameEOF;
+ // token = getLastSQLToken(startText);
+ tableName.setTableName(getLastSQLTableName(startText));
Scanner scanner = ToolFactory.createScanner(false, false, false);
scanner.setSource(startText.toCharArray());
scanner.setPHPMode(true);
- int token = ITerminalSymbols.TokenNameEOF;
+ int beforeLastToken = ITerminalSymbols.TokenNameEOF;
int lastToken = ITerminalSymbols.TokenNameEOF;
-
+ char[] ident;
try {
token = scanner.getNextToken();
lastToken = token;
while (token != ITerminalSymbols.TokenNameERROR && token != ITerminalSymbols.TokenNameEOF) {
+ beforeLastToken = lastToken;
+ if (lastToken == ITerminalSymbols.TokenNameVariable) {
+ ident = scanner.getCurrentTokenSource();
+ if (ident.length == 5 && ident[0] == '$' && ident[1] == 't' && ident[2] == 'h' && ident[3] == 'i' && ident[4] == 's') {
+ beforeLastToken = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
+ }
+ }
lastToken = token;
// System.out.println(scanner.toStringAction(lastToken));
token = scanner.getNextToken();
}
} catch (InvalidInputException e1) {
}
- if (lastToken == ITerminalSymbols.TokenNameMINUS_GREATER) {
+ switch (lastToken) {
+ case ITerminalSymbols.TokenNameMINUS_GREATER:
// dereferencing operator '->' found
- useClassEntries = true;
- // System.out.println("useClassEntries = true");
+ lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
+ if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
+ lastSignificantToken = ITerminalSymbols.TokenNameVariable;
+ }
+ break;
+ case ITerminalSymbols.TokenNamenew:
+ lastSignificantToken = ITerminalSymbols.TokenNamenew;
+ break;
}
}
} catch (BadLocationException e) {
}
- return useClassEntries;
+ return lastSignificantToken;
+ }
+
+ String getSQLTableName(String sqlText, int start) {
+ int tableNameStart = -1;
+ int currentCharacterPosition = start + 1;
+ char ch;
+ try {
+ while (true) {
+ ch = sqlText.charAt(currentCharacterPosition++);
+ if (tableNameStart == -1 && Character.isJavaIdentifierStart(ch)) {
+ tableNameStart = currentCharacterPosition - 1;
+ } else {
+ if (!Character.isJavaIdentifierPart(ch)) {
+ return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
+ }
+ }
+ }
+ } catch (IndexOutOfBoundsException e) {
+ if (tableNameStart >= 0) {
+ return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
+ }
+ }
+ return "";
}
-
+
+ private String getLastSQLTableName(String startText) {
+ int token;
+ // scan for sql identifiers
+ char ch = ' ';
+ int currentSQLPosition = startText.length();
+ int identEnd = -1;
+ String ident = null;
+ boolean whiteSpace = true;
+ try {
+ while (true) {
+ ch = startText.charAt(--currentSQLPosition);
+ if (ch >= 'A' && ch <= 'Z') {
+ if (identEnd < 0) {
+ identEnd = currentSQLPosition + 1;
+ }
+ } else if (ch >= 'a' && ch <= 'z') {
+ if (identEnd < 0) {
+ identEnd = currentSQLPosition + 1;
+ }
+ } else if (identEnd >= 0) {
+ ident = startText.substring(currentSQLPosition + 1, identEnd);
+ // select -- from -- where --
+ // update -- set -- where --
+ // insert into -- ( -- ) values ( -- )
+ if (ident.length() >= 4 && ident.length() <= 6) {
+ ident = ident.toLowerCase();
+ switch (ident.length()) {
+ // case 3 :
+ // if (ident.equals("set")) {
+ // // System.out.println("set");
+ // token = ITerminalSymbols.TokenNameSQLset;
+ // return token;
+ // }
+ // break;
+ case 4:
+ if (ident.equals("from")) {
+ // System.out.println("from");
+ token = ITerminalSymbols.TokenNameSQLfrom;
+ return getSQLTableName(startText, identEnd);
+ } else if (ident.equals("into")) {
+ // System.out.println("into");
+ token = ITerminalSymbols.TokenNameSQLinto;
+ return getSQLTableName(startText, identEnd);
+ }
+ break;
+ // case 5 :
+ // if (ident.equals("where")) {
+ // // System.out.println("where");
+ // token = ITerminalSymbols.TokenNameSQLwhere;
+ // return token;
+ // }
+ // break;
+ case 6:
+ // if (ident.equals("select")) {
+ // // System.out.println("select");
+ // token = ITerminalSymbols.TokenNameSQLselect;
+ // return token;
+ // } else if (ident.equals("insert")) {
+ // // System.out.println("insert");
+ // token = ITerminalSymbols.TokenNameSQLinsert;
+ // return token;
+ // } else
+ if (ident.equals("update")) {
+ // System.out.println("update");
+ token = ITerminalSymbols.TokenNameSQLupdate;
+ return getSQLTableName(startText, identEnd);
+ }
+ // else if (ident.equals("values")) {
+ // // System.out.println("values");
+ // token = ITerminalSymbols.TokenNameSQLvalues;
+ // return token;
+ // }
+ break;
+ }
+ }
+ whiteSpace = false;
+ identEnd = -1;
+ } else if (Character.isWhitespace(ch)) {
+ } else {
+ whiteSpace = false;
+ }
+ }
+ } catch (IndexOutOfBoundsException e) {
+ }
+ return "";
+ }
+
+ /**
+ * Detect the last significant SQL token in the text before the completion
+ *
+ * @param startText
+ */
+ private int getLastSQLToken(String startText) {
+ int token;
+ // scan for sql identifiers
+ char ch = ' ';
+ int currentSQLPosition = startText.length();
+ int identEnd = -1;
+ String ident = null;
+ boolean whiteSpace = true;
+ try {
+ while (true) {
+ ch = startText.charAt(--currentSQLPosition);
+ if (ch >= 'A' && ch <= 'Z') {
+ if (identEnd < 0) {
+ identEnd = currentSQLPosition + 1;
+ }
+ } else if (ch >= 'a' && ch <= 'z') {
+ if (identEnd < 0) {
+ identEnd = currentSQLPosition + 1;
+ }
+ } else if (identEnd >= 0) {
+ ident = startText.substring(currentSQLPosition + 1, identEnd);
+ // select -- from -- where --
+ // update -- set -- where --
+ // insert into -- ( -- ) values ( -- )
+ if (ident.length() >= 3 && ident.length() <= 6) {
+ ident = ident.toLowerCase();
+ switch (ident.length()) {
+ case 3:
+ if (ident.equals("set")) {
+ // System.out.println("set");
+ token = ITerminalSymbols.TokenNameSQLset;
+ return token;
+ }
+ break;
+ case 4:
+ if (ident.equals("from")) {
+ // System.out.println("from");
+ token = ITerminalSymbols.TokenNameSQLfrom;
+ //getSQLTableName();
+ return token;
+ } else if (ident.equals("into")) {
+ // System.out.println("into");
+ token = ITerminalSymbols.TokenNameSQLinto;
+ return token;
+ }
+ break;
+ case 5:
+ if (ident.equals("where")) {
+ // System.out.println("where");
+ token = ITerminalSymbols.TokenNameSQLwhere;
+ return token;
+ }
+ break;
+ case 6:
+ if (ident.equals("select")) {
+ // System.out.println("select");
+ token = ITerminalSymbols.TokenNameSQLselect;
+ return token;
+ } else if (ident.equals("insert")) {
+ // System.out.println("insert");
+ token = ITerminalSymbols.TokenNameSQLinsert;
+ return token;
+ } else if (ident.equals("update")) {
+ // System.out.println("update");
+ token = ITerminalSymbols.TokenNameSQLupdate;
+ return token;
+ } else if (ident.equals("values")) {
+ // System.out.println("values");
+ token = ITerminalSymbols.TokenNameSQLvalues;
+ return token;
+ }
+ break;
+ }
+ }
+ whiteSpace = false;
+ identEnd = -1;
+ } else if (Character.isWhitespace(ch)) {
+ } else {
+ whiteSpace = false;
+ }
+ }
+ } catch (IndexOutOfBoundsException e) {
+ }
+ return ITerminalSymbols.TokenNameEOF;
+ }
+
private ICompletionProposal[] internalComputeCompletionProposals(ITextViewer viewer, int offset, int contextOffset) {
+ ICompilationUnit unit = fManager.getWorkingCopy(fEditor.getEditorInput());
IDocument document = viewer.getDocument();
Object[] identifiers = null;
+ IFile file = null;
IProject project = null;
if (offset > 0) {
-
PHPEditor editor = null;
- AbstractContentOutlinePage outlinePage = null;
-
- IEditorPart targetEditor = PHPeclipsePlugin.getActiveWorkbenchWindow().getActivePage().getActiveEditor();
- if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
- editor = (PHPEditor) targetEditor;
- IFile f = ((IFileEditorInput) editor.getEditorInput()).getFile();
- project = f.getProject();
- outlinePage = editor.getfOutlinePage();
- if (outlinePage instanceof PHPContentOutlinePage) {
- identifiers = ((PHPContentOutlinePage) outlinePage).getVariables();
- }
+ if (fEditor != null && (fEditor instanceof PHPEditor)) {
+ editor = (PHPEditor) fEditor;
+ file = ((IFileEditorInput) editor.getEditorInput()).getFile();
+ project = file.getProject();
}
}
- if (fTemplateEngine != null) {
- ICompletionProposal[] results;
- // try {
- fTemplateEngine.reset();
- fTemplateEngine.complete(viewer, offset); //, unit);
- // } catch (JavaModelException x) {
- // Shell shell= viewer.getTextWidget().getShell();
- // ErrorDialog.openError(shell, JavaTextMessages.getString("CompletionProcessor.error.accessing.title"), JavaTextMessages.getString("CompletionProcessor.error.accessing.message"), x.getStatus()); //$NON-NLS-2$ //$NON-NLS-1$
- // }
+ Point selection = viewer.getSelectedRange();
+
+ // remember selected text
+ String selectedText = null;
+ if (selection.y != 0) {
+ try {
+ selectedText = document.get(selection.x, selection.y);
+ } catch (BadLocationException e) {
+ }
+ }
- IPHPCompletionProposal[] templateResults = fTemplateEngine.getResults();
+ JavaContextType phpContextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+ "php"); //$NON-NLS-1$
+ JavaContext context = (JavaContext) phpContextType.createContext(document, offset, selection.y, unit);
+ context.setVariable("selection", selectedText); //$NON-NLS-1$
+ String prefix = context.getKey();
+ boolean emptyPrefix = prefix == null || prefix.equals("");
+ IPHPCompletionProposal[] localVariableResults = new IPHPCompletionProposal[0];
+ if (!emptyPrefix && prefix.length() >= 1 && prefix.charAt(0) == '$') { // php Variable ?
+ HashSet localVariables = getLocalVariableProposals(viewer, project, context, prefix);
+ if (localVariables.size() > 0) {
+ localVariableResults = (IPHPCompletionProposal[]) localVariables.toArray(new IPHPCompletionProposal[localVariables.size()]);
+ }
+ }
+
+ TableName sqlTable = new TableName();
+ int lastSignificantToken = getLastToken(viewer, offset, context, sqlTable);
+ boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
+ || (lastSignificantToken == ITerminalSymbols.TokenNameVariable) || (lastSignificantToken == ITerminalSymbols.TokenNamenew)
+ || (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION);
+ if (fTemplateEngine != null) {
+ IPHPCompletionProposal[] templateResults = new IPHPCompletionProposal[0];
+ ICompletionProposal[] results;
+ if (!emptyPrefix) {
+ fTemplateEngine.reset();
+ fTemplateEngine.complete(viewer, offset, unit);
+ templateResults = fTemplateEngine.getResults();
+ }
IPHPCompletionProposal[] identifierResults = new IPHPCompletionProposal[0];
- if (identifiers != null) {
+ if ((!useClassMembers) && identifiers != null) {
IdentifierEngine identifierEngine;
- String proposal;
- // int j = 0;
- // for (int i = templateResults.length; i < templateResults.length + variables.length; i++) {
- // proposal = (String) variables[j++];
- // IContextInformation info = new ContextInformation(proposal, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.ContextInfo.pattern"), new Object[] { proposal })); //$NON-NLS-1$
- // results[i] = new VariablesCompletionProposal(proposal, offset, 0, proposal.length(), null, proposal, info, MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.Proposal.hoverinfo.pattern"), new Object[] { proposal })); //$NON-NLS-1$
- // }
-
- ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+ JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+ "php"); //$NON-NLS-1$
if (contextType != null) {
identifierEngine = new IdentifierEngine(contextType);
- identifierEngine.complete(viewer, offset, identifiers);
+ identifierEngine.complete(viewer, offset, identifiers, unit);
identifierResults = identifierEngine.getResults();
}
}
-
- boolean useClassEntries = isReference(viewer, offset);
+ // declarations stored in file project.index on project level
IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
if (project != null) {
- DeclarationEngine identifierEngine;
- String proposal;
-
- ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+ DeclarationEngine declarationEngine;
+ JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+ "php"); //$NON-NLS-1$
if (contextType != null) {
IdentifierIndexManager indexManager = PHPeclipsePlugin.getDefault().getIndexManager(project);
SortedMap sortedMap = indexManager.getIdentifierMap();
-
- identifierEngine = new DeclarationEngine(contextType, useClassEntries);
- identifierEngine.complete(viewer, offset, sortedMap);
- identifierResults = identifierEngine.getResults();
+ declarationEngine = new DeclarationEngine(project, contextType, lastSignificantToken, file);
+ declarationEngine.complete(viewer, offset, sortedMap, unit);
+ declarationResults = declarationEngine.getResults();
}
}
-
// built in function names from phpsyntax.xml
- ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
+ ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
- if ((!useClassEntries)&&syntaxbuffer != null) {
+ if ((!useClassMembers) && syntaxbuffer != null) {
BuiltInEngine builtinEngine;
String proposal;
-
- ContextType contextType = ContextTypeRegistry.getInstance().getContextType("php"); //$NON-NLS-1$
+ JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
+ "php"); //$NON-NLS-1$
if (contextType != null) {
builtinEngine = new BuiltInEngine(contextType);
- builtinEngine.complete(viewer, offset, syntaxbuffer);
+ builtinEngine.complete(viewer, offset, syntaxbuffer, unit);
builtinResults = builtinEngine.getResults();
}
}
-
- // concatenate arrays
+ ICompletionProposal[] sqlResults = new ICompletionProposal[0];
+ if (project != null) {
+ sqlResults = getSQLProposals(viewer, project, context, prefix, sqlTable);
+ }
+ // concatenate the result arrays
IPHPCompletionProposal[] total;
- total =
- new IPHPCompletionProposal[templateResults.length
- + identifierResults.length
- + builtinResults.length
- + declarationResults.length];
+ total = new IPHPCompletionProposal[localVariableResults.length + templateResults.length + identifierResults.length
+ + builtinResults.length + declarationResults.length + sqlResults.length];
System.arraycopy(templateResults, 0, total, 0, templateResults.length);
System.arraycopy(identifierResults, 0, total, templateResults.length, identifierResults.length);
System.arraycopy(builtinResults, 0, total, templateResults.length + identifierResults.length, builtinResults.length);
- System.arraycopy(
- declarationResults,
- 0,
- total,
- templateResults.length + identifierResults.length + builtinResults.length,
- declarationResults.length);
-
+ System.arraycopy(declarationResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length,
+ declarationResults.length);
+ System.arraycopy(sqlResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length
+ + declarationResults.length, sqlResults.length);
+ System.arraycopy(localVariableResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length
+ + declarationResults.length + sqlResults.length, localVariableResults.length);
results = total;
-
fNumberOfComputedResults = (results == null ? 0 : results.length);
/*
- * Order here and not in result collector to make sure that the order
- * applies to all proposals and not just those of the compilation unit.
+ * Order here and not in result collector to make sure that the order applies to all proposals and not just those of the
+ * compilation unit.
*/
return order(results);
}
return new IPHPCompletionProposal[0];
}
+ /**
+ * @param viewer
+ * @param project
+ * @param context
+ * @param prefix
+ * @return
+ */
+ private HashSet getLocalVariableProposals(ITextViewer viewer, IProject project, JavaContext context, String prefix) {
+ HashSet localVariables = new HashSet();
+ try {
+ IMethod method = (IMethod) context.findEnclosingElement(IJavaElement.METHOD);
+ int start = context.getStart();
+ int end = context.getEnd();
+ IRegion region = new Region(start, end - start);
+ char[] varName;
+ boolean matchesVarName;
+ if (method != null) {
+ ISourceRange range = method.getSourceRange();
+ char[] source = method.getSource().toCharArray();
+ Scanner scanner = new Scanner();
+ scanner.setSource(source);
+ scanner.phpMode = true;
+ int token = Scanner.TokenNameWHITESPACE;
+ while ((token = scanner.getNextToken()) != Scanner.TokenNameEOF) {
+ if (token == Scanner.TokenNameVariable) {
+ varName = scanner.getCurrentTokenSource();
+ if (varName.length >= prefix.length()) {
+ matchesVarName = true;
+ for (int i = 0; i < prefix.length(); i++) {
+ if (prefix.charAt(i) != varName[i]) {
+ matchesVarName = false;
+ break;
+ }
+ }
+ if (matchesVarName) {
+ LocalVariableProposal prop = new LocalVariableProposal(new String(varName), region, viewer);
+ if (varName.length == prefix.length()) {
+ prop.setRelevance(98);
+ }
+ localVariables.add(prop);
+ }
+ }
+ }
+ }
+ }
+ } catch (Throwable e) {
+ // ignore - Syntax exceptions could occur, if there are syntax errors !
+ }
+ return localVariables;
+ }
+
+ /**
+ * @param viewer
+ * @param project
+ * @param context
+ * @param prefix
+ * @param sqlTable
+ * @param sqlResults
+ * @return
+ */
+ private ICompletionProposal[] getSQLProposals(ITextViewer viewer, IProject project, DocumentTemplateContext context,
+ String prefix, TableName sqlTable) {
+ ICompletionProposal[] sqlResults = new ICompletionProposal[0];
+ // Get The Database bookmark from the Quantum SQL plugin:
+ BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
+ if (sqlBookMarks != null) {
+ String bookmarkString = ProjectPrefUtil.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 (metaData != null) {
+ int start = context.getStart();
+ int end = context.getEnd();
+ String foundSQLTableName = sqlTable.getTableName();
+ String tableName;
+ String columnName;
+ String prefixWithoutDollar = prefix;
+ boolean isDollarPrefix = false;
+ if (prefix.length() > 0 && prefix.charAt(0) == '$') {
+ prefixWithoutDollar = prefix.substring(1);
+ isDollarPrefix = true;
+ }
+ IRegion region = new Region(start, end - start);
+ ResultSet set;
+ if (!isDollarPrefix) {
+ set = metaData.getTables(null, null, prefixWithoutDollar + "%", null);
+ while (set.next()) {
+ // String tempSchema = set.getString("TABLE_SCHEM");
+ // tempSchema = (tempSchema == null) ? "" :
+ // tempSchema.trim();
+ tableName = set.getString("TABLE_NAME");
+ tableName = (tableName == null) ? "" : tableName.trim();
+ if (tableName != null && tableName.length() > 0) {
+ sqlList.add(new SQLProposal(tableName, context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE)));
+ }
+ }
+ set.close();
+ }
+ set = metaData.getColumns(null, null, "%", prefixWithoutDollar + "%");
+ SQLProposal sqlProposal;
+ while (set.next()) {
+ columnName = set.getString("COLUMN_NAME");
+ columnName = (columnName == null) ? "" : columnName.trim();
+ tableName = set.getString("TABLE_NAME");
+ tableName = (tableName == null) ? "" : tableName.trim();
+ if (tableName != null && tableName.length() > 0 && columnName != null && columnName.length() > 0) {
+ if (isDollarPrefix) {
+ sqlProposal = new SQLProposal(tableName, "$" + columnName, context, region, viewer, PHPUiImages
+ .get(PHPUiImages.IMG_COLUMN));
+ } else {
+ sqlProposal = new SQLProposal(tableName, columnName, context, region, viewer, PHPUiImages
+ .get(PHPUiImages.IMG_COLUMN));
+ }
+ if (tableName.equals(foundSQLTableName)) {
+ sqlProposal.setRelevance(90);
+ } else if (tableName.indexOf(foundSQLTableName) >= 0) {
+ sqlProposal.setRelevance(75);
+ }
+ sqlList.add(sqlProposal);
+ }
+ }
+ set.close();
+ sqlResults = new IPHPCompletionProposal[sqlList.size()];
+ for (int i = 0; i < sqlList.size(); i++) {
+ sqlResults[i] = (SQLProposal) sqlList.get(i);
+ }
+ }
+ } catch (NotConnectedException e) {
+ // ignore this - not mission critical
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ }
+ }
+ return sqlResults;
+ }
+
private int guessContextInformationPosition(ITextViewer viewer, int offset) {
int contextPosition = offset;
-
IDocument document = viewer.getDocument();
-
// try {
//
// PHPCodeReader reader= new PHPCodeReader();
@@ -506,7 +776,7 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
//
// int nestingLevel= 0;
//
- // int curr= reader.read();
+ // int curr= reader.read();
// while (curr != PHPCodeReader.EOF) {
//
// if (')' == (char) curr)
@@ -519,27 +789,16 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
// int start= reader.getOffset();
// if (looksLikeMethod(reader))
// return start + 1;
- // }
+ // }
// }
//
- // curr= reader.read();
+ // curr= reader.read();
// }
// } catch (IOException e) {
// }
-
return contextPosition;
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
- */
- // public IContextInformation[] computeContextInformation(ITextViewer viewer, int documentOffset) {
- // IContextInformation[] result = new IContextInformation[5];
- // for (int i = 0; i < result.length; i++)
- // result[i] = new ContextInformation(MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.display.pattern"), new Object[] { new Integer(i), new Integer(documentOffset)}), //$NON-NLS-1$
- // MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.value.pattern"), new Object[] { new Integer(i), new Integer(documentOffset - 5), new Integer(documentOffset + 5)})); //$NON-NLS-1$
- // return result;
- // }
/**
* @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
*/
@@ -551,7 +810,6 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
private List addContextInformations(ITextViewer viewer, int offset) {
ICompletionProposal[] proposals = internalComputeCompletionProposals(viewer, offset, -1);
-
List result = new ArrayList();
for (int i = 0; i < proposals.length; i++) {
IContextInformation contextInformation = proposals[i].getContextInformation();
@@ -572,33 +830,32 @@ public class PHPCompletionProcessor implements IContentAssistProcessor {
return proposals;
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
+ /*
+ * (non-Javadoc) Method declared on IContentAssistProcessor
*/
public char[] getCompletionProposalAutoActivationCharacters() {
return fProposalAutoActivationSet;
// return null; // new char[] { '$' };
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
+ /*
+ * (non-Javadoc) Method declared on IContentAssistProcessor
*/
public char[] getContextInformationAutoActivationCharacters() {
- return new char[] {
- };
+ return new char[] {};
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
+ /*
+ * (non-Javadoc) Method declared on IContentAssistProcessor
*/
public IContextInformationValidator getContextInformationValidator() {
return fValidator;
}
- /* (non-Javadoc)
- * Method declared on IContentAssistProcessor
+ /*
+ * (non-Javadoc) Method declared on IContentAssistProcessor
*/
public String getErrorMessage() {
return null;
}
-}
+}
\ No newline at end of file