+++ /dev/null
-/**********************************************************************
- 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.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.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.PHPEditor;
-import net.sourceforge.phpeclipse.phpeditor.PHPSyntaxRdr;
-import net.sourceforge.phpeclipse.ui.IPreferenceConstants;
-import net.sourceforge.phpeclipse.ui.overlaypages.Util;
-
-import org.eclipse.core.resources.IFile;
-import org.eclipse.core.resources.IProject;
-import org.eclipse.jface.text.BadLocationException;
-import org.eclipse.jface.text.IDocument;
-import org.eclipse.jface.text.IRegion;
-import org.eclipse.jface.text.ITextViewer;
-import org.eclipse.jface.text.Region;
-import org.eclipse.jface.text.TextPresentation;
-import org.eclipse.jface.text.contentassist.ICompletionProposal;
-import org.eclipse.jface.text.contentassist.IContentAssistProcessor;
-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.
- */
- protected static class Validator implements IContextInformationValidator, IContextInformationPresenter {
- protected int fInstallOffset;
-
- /*
- * @see IContextInformationValidator#isContextInformationValid(int)
- */
- public boolean isContextInformationValid(int offset) {
- return Math.abs(fInstallOffset - offset) < 5;
- }
-
- /*
- * @see IContextInformationValidator#install(IContextInformation, ITextViewer, int)
- */
- public void install(IContextInformation info, ITextViewer viewer, int offset) {
- fInstallOffset = offset;
- }
-
- /*
- * @see org.eclipse.jface.text.contentassist.IContextInformationPresenter#updatePresentation(int, TextPresentation)
- */
- public boolean updatePresentation(int documentPosition, TextPresentation presentation) {
- return false;
- }
- };
-
- private static class ContextInformationWrapper implements IContextInformation, IContextInformationExtension {
- private final IContextInformation fContextInformation;
-
- private int fPosition;
-
- public ContextInformationWrapper(IContextInformation contextInformation) {
- fContextInformation = contextInformation;
- }
-
- /*
- * @see IContextInformation#getContextDisplayString()
- */
- public String getContextDisplayString() {
- return fContextInformation.getContextDisplayString();
- }
-
- /*
- * @see IContextInformation#getImage()
- */
- public Image getImage() {
- return fContextInformation.getImage();
- }
-
- /*
- * @see IContextInformation#getInformationDisplayString()
- */
- public String getInformationDisplayString() {
- return fContextInformation.getInformationDisplayString();
- }
-
- /*
- * @see IContextInformationExtension#getContextInformationPosition()
- */
- public int getContextInformationPosition() {
- return fPosition;
- }
-
- public void setContextInformationPosition(int position) {
- fPosition = position;
- }
- };
-
- private class TableName {
- String fTableName;
-
- TableName() {
- fTableName = null;
- }
-
- /**
- * @return Returns the tableName.
- */
- public String getTableName() {
- if (fTableName == null) {
- return "<!--no-table-->";
- }
- 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;
-
- private IEditorPart fEditor;
-
- protected IWorkingCopyManager fManager;
-
- 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
- * <code>true</code> 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.
- *
- * @param activationSet
- * the activation set
- */
- public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
- fProposalAutoActivationSet = activationSet;
- }
-
- /*
- * (non-Javadoc) Method declared on IContentAssistProcessor
- */
- public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer, int documentOffset) {
- int contextInformationPosition = guessContextInformationPosition(viewer, documentOffset);
- return internalComputeCompletionProposals(viewer, documentOffset, contextInformationPosition);
- }
-
- private int getLastToken(ITextViewer viewer, int completionPosition, JavaContext context, TableName tableName) {
- IDocument document = viewer.getDocument();
- int start = context.getStart();
- int end = context.getEnd();
- String startText;
- int lastSignificantToken = ITerminalSymbols.TokenNameEOF;
- try {
- // begin search 2 lines behind of this
- int j = start;
- if (j != 0) {
- char ch;
- while (j-- > 0) {
- ch = document.getChar(j);
- if (ch == '\n') {
- break;
- }
- }
- while (j-- > 0) {
- ch = document.getChar(j);
- if (ch == '\n') {
- break;
- }
- }
- }
- if (j != start) {
- // scan the line for the dereferencing operator '->'
- startText = document.get(j, start - j);
- 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 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) {
- }
- switch (lastToken) {
- case ITerminalSymbols.TokenNameMINUS_GREATER:
- // dereferencing operator '->' found
- lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
- if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
- lastSignificantToken = ITerminalSymbols.TokenNameVariable;
- }
- break;
- case ITerminalSymbols.TokenNamenew:
- lastSignificantToken = ITerminalSymbols.TokenNamenew;
- break;
- }
- }
- } catch (BadLocationException e) {
- }
- 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 "<!--no-table-->";
- }
-
- /**
- * 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;
- if (fEditor != null && (fEditor instanceof PHPEditor)) {
- editor = (PHPEditor) fEditor;
- file = ((IFileEditorInput) editor.getEditorInput()).getFile();
- project = file.getProject();
- }
- }
-
- 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) {
- }
- }
-
- 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 ((!useClassMembers) && identifiers != null) {
- IdentifierEngine identifierEngine;
- JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
- "php"); //$NON-NLS-1$
- if (contextType != null) {
- identifierEngine = new IdentifierEngine(contextType);
- identifierEngine.complete(viewer, offset, identifiers, unit);
- identifierResults = identifierEngine.getResults();
- }
- }
- // declarations stored in file project.index on project level
- IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
- if (project != null) {
- 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();
- 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();
- IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
- if ((!useClassMembers) && syntaxbuffer != null) {
- BuiltInEngine builtinEngine;
- String proposal;
- JavaContextType contextType = (JavaContextType) PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
- "php"); //$NON-NLS-1$
- if (contextType != null) {
- builtinEngine = new BuiltInEngine(contextType);
- builtinEngine.complete(viewer, offset, syntaxbuffer, unit);
- builtinResults = builtinEngine.getResults();
- }
- }
- IPHPCompletionProposal[] sqlResults = new IPHPCompletionProposal[0];
- if (project != null) {
- sqlResults = getSQLProposals(viewer, project, context, prefix, sqlTable, sqlResults);
- }
- // concatenate the result arrays
- IPHPCompletionProposal[] total;
- 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(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.
- */
- 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 IPHPCompletionProposal[] getSQLProposals(ITextViewer viewer, IProject project, DocumentTemplateContext context,
- String prefix, TableName sqlTable, IPHPCompletionProposal[] sqlResults) {
- // 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 (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();
- // reader.configureBackwardReader(document, offset, true, true);
- //
- // int nestingLevel= 0;
- //
- // int curr= reader.read();
- // while (curr != PHPCodeReader.EOF) {
- //
- // if (')' == (char) curr)
- // ++ nestingLevel;
- //
- // else if ('(' == (char) curr) {
- // -- nestingLevel;
- //
- // if (nestingLevel < 0) {
- // int start= reader.getOffset();
- // if (looksLikeMethod(reader))
- // return start + 1;
- // }
- // }
- //
- // curr= reader.read();
- // }
- // } catch (IOException e) {
- // }
- return contextPosition;
- }
-
- /**
- * @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
- */
- public IContextInformation[] computeContextInformation(ITextViewer viewer, int offset) {
- int contextInformationPosition = guessContextInformationPosition(viewer, offset);
- List result = addContextInformations(viewer, contextInformationPosition);
- return (IContextInformation[]) result.toArray(new IContextInformation[result.size()]);
- }
-
- 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();
- if (contextInformation != null) {
- ContextInformationWrapper wrapper = new ContextInformationWrapper(contextInformation);
- wrapper.setContextInformationPosition(offset);
- result.add(wrapper);
- }
- }
- return result;
- }
-
- /**
- * Order the given proposals.
- */
- private ICompletionProposal[] order(ICompletionProposal[] proposals) {
- Arrays.sort(proposals, fComparator);
- return proposals;
- }
-
- /*
- * (non-Javadoc) Method declared on IContentAssistProcessor
- */
- public char[] getCompletionProposalAutoActivationCharacters() {
- return fProposalAutoActivationSet;
- // return null; // new char[] { '$' };
- }
-
- /*
- * (non-Javadoc) Method declared on IContentAssistProcessor
- */
- public char[] getContextInformationAutoActivationCharacters() {
- return new char[] {};
- }
-
- /*
- * (non-Javadoc) Method declared on IContentAssistProcessor
- */
- public IContextInformationValidator getContextInformationValidator() {
- return fValidator;
- }
-
- /*
- * (non-Javadoc) Method declared on IContentAssistProcessor
- */
- public String getErrorMessage() {
- return null;
- }
-}
\ No newline at end of file
git://secure.phpeclipse.com / phpeclipse.git / blobdiff