Klaus Hartlage - www.eclipseproject.de
**********************************************************************/
package net.sourceforge.phpeclipse.phpeditor.php;
+
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
+import java.util.Map;
import java.util.SortedMap;
+
+import net.sourceforge.phpdt.core.IBuffer;
+import net.sourceforge.phpdt.core.ICompilationUnit;
+import net.sourceforge.phpdt.core.IJavaProject;
+import net.sourceforge.phpdt.core.JavaModelException;
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.IProblemFactory;
+import net.sourceforge.phpdt.internal.compiler.SourceElementParser;
+import net.sourceforge.phpdt.internal.compiler.impl.CompilerOptions;
import net.sourceforge.phpdt.internal.compiler.parser.Scanner;
+import net.sourceforge.phpdt.internal.compiler.problem.DefaultProblemFactory;
+import net.sourceforge.phpdt.internal.core.CompilationUnit;
+import net.sourceforge.phpdt.internal.core.CompilationUnitStructureRequestor;
+import net.sourceforge.phpdt.internal.core.JavaModelManager;
+import net.sourceforge.phpdt.internal.core.JavaProject;
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.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.IdentifierProposal;
+import net.sourceforge.phpdt.internal.ui.text.template.SQLProposal;
import net.sourceforge.phpdt.internal.ui.text.template.TemplateEngine;
+import net.sourceforge.phpdt.ui.IWorkingCopyManager;
import net.sourceforge.phpeclipse.IPreferenceConstants;
import net.sourceforge.phpeclipse.PHPeclipsePlugin;
import net.sourceforge.phpeclipse.builder.IdentifierIndexManager;
+import net.sourceforge.phpeclipse.internal.compiler.ast.CompilationUnitDeclaration;
+import net.sourceforge.phpeclipse.overlaypages.Util;
import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
import net.sourceforge.phpeclipse.phpeditor.PHPSyntaxRdr;
+
import org.eclipse.core.resources.IFile;
import org.eclipse.core.resources.IProject;
import org.eclipse.jface.text.BadLocationException;
import org.eclipse.swt.graphics.Image;
import org.eclipse.ui.IEditorPart;
import org.eclipse.ui.IFileEditorInput;
-import net.sourceforge.phpeclipse.overlaypages.Util;
+
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.
*/
* 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 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)
return false;
}
};
- private static class ContextInformationWrapper
- implements
- IContextInformation,
- IContextInformationExtension {
+
+ 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;
- public PHPCompletionProcessor() {
+
+ private IEditorPart fEditor;
+
+ protected IWorkingCopyManager fManager;
+
+ public PHPCompletionProcessor(IEditorPart editor) {
+ fEditor = editor;
+ fManager = PHPeclipsePlugin.getDefault().getWorkingCopyManager();
ContextType contextType = ContextTypeRegistry.getInstance().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.
+ * <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
+ * the activation set
*/
public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
fProposalAutoActivationSet = activationSet;
}
+
/*
* (non-Javadoc) Method declared on IContentAssistProcessor
*/
return internalComputeCompletionProposals(viewer, documentOffset,
contextInformationPosition);
}
+
private int getLastToken(ITextViewer viewer, int completionPosition,
- PHPUnitContext context) {
+ PHPUnitContext context, TableName tableName) {
IDocument document = viewer.getDocument();
int start = context.getStart();
int end = context.getEnd();
System.out.println(startText);
}
int token = ITerminalSymbols.TokenNameEOF;
-
- token = getLastSQLToken(startText);
-
+ // 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;
try {
} 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;
+ 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
*
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;
- 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;
+ 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;
}
return ITerminalSymbols.TokenNameEOF;
}
-
+
private ICompletionProposal[] internalComputeCompletionProposals(
ITextViewer viewer, int offset, int contextOffset) {
+
IDocument document = viewer.getDocument();
Object[] identifiers = null;
IFile file = null;
IProject project = null;
if (offset > 0) {
PHPEditor editor = null;
- // JavaOutlinePage outlinePage = null;
- IEditorPart targetEditor = PHPeclipsePlugin.getActiveWorkbenchWindow()
- .getActivePage().getActiveEditor();
- if (targetEditor != null && (targetEditor instanceof PHPEditor)) {
- editor = (PHPEditor) targetEditor;
+ if (fEditor != null && (fEditor instanceof PHPEditor)) {
+ editor = (PHPEditor) fEditor;
file = ((IFileEditorInput) editor.getEditorInput()).getFile();
project = file.getProject();
// outlinePage = editor.getfOutlinePage();
// }
}
}
+
+ final ICompilationUnit unit = fManager.getWorkingCopy(fEditor
+ .getEditorInput());
+
+ // get buffer contents
+ final IBuffer buffer;
+ CompilationUnitDeclaration unitDecl=null;
+ try {
+ buffer = unit.getBuffer();
+
+ if (project != null && buffer != null) {
+
+ // final char[] contents = buffer == null ? null :
+ // buffer.getCharacters();
+ //
+ // // generate structure and compute syntax problems if needed
+ // CompilationUnitStructureRequestor requestor = new
+ // CompilationUnitStructureRequestor(this, unitInfo, newElements);
+ // JavaModelManager.PerWorkingCopyInfo perWorkingCopyInfo =
+ // getPerWorkingCopyInfo();
+ // IJavaProject project = getJavaProject();
+ // boolean computeProblems =
+ // JavaProject.hasJavaNature(project.getProject()) && perWorkingCopyInfo
+ // != null && perWorkingCopyInfo.isActive();
+ IProblemFactory problemFactory = new DefaultProblemFactory();
+ // Map options = project.getOptions(true);
+ SourceElementParser parser = new SourceElementParser(null,
+ problemFactory, new CompilerOptions(null));
+ //, true/*report local declarations*/);
+ unitDecl = parser.parseCompletionUnit(
+ new net.sourceforge.phpdt.internal.compiler.env.ICompilationUnit() {
+ public char[] getContents() {
+ return buffer.getCharacters();
+ }
+
+ public char[] getMainTypeName() {
+ return null;
+ }
+
+ public char[][] getPackageName() {
+ return null;
+ }
+
+ public char[] getFileName() {
+ return null;
+ }
+ }, true /* full parse to find local elements */);
+
+ }
+// System.out.println(unit.toString());
+ } catch (Exception e1) {
+ // TODO Auto-generated catch block
+ e1.printStackTrace();
+ }
+
ContextType phpContextType = ContextTypeRegistry.getInstance()
.getContextType("php"); //$NON-NLS-1$
((CompilationUnitContextType) phpContextType).setContextParameters(
document, offset, 0);
PHPUnitContext context = (PHPUnitContext) phpContextType.createContext();
String prefix = context.getKey();
- int lastSignificantToken = getLastToken(viewer, offset, context);
+ TableName sqlTable = new TableName();
+ int lastSignificantToken = getLastToken(viewer, offset, context, sqlTable);
boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
|| (lastSignificantToken == ITerminalSymbols.TokenNameVariable)
|| (lastSignificantToken == ITerminalSymbols.TokenNamenew);
IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
if (bookmarkString != null && !bookmarkString.equals("")) {
Bookmark bookmark = sqlBookMarks.find(bookmarkString);
- ArrayList list = new ArrayList();
+ ArrayList sqlList = new ArrayList();
if (bookmark != null && !bookmark.isConnected()) {
new ConnectionUtil().connect(bookmark, null);
}
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 = metaData.getTables(null, null, prefix + "%",
- null);
- while (set.next()) {
- // String tempSchema = set.getString("TABLE_SCHEM");
- // tempSchema = (tempSchema == null) ? "" :
- // tempSchema.trim();
- String tableName = set.getString("TABLE_NAME");
- tableName = (tableName == null) ? "" : tableName.trim();
- if (tableName != null && tableName.length() > 0) {
- list.add(tableName);
+ 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.close();
- set = metaData.getColumns(null, null, "%", prefix + "%");
+ set = metaData.getColumns(null, null, "%",
+ prefixWithoutDollar + "%");
+ SQLProposal sqlProposal;
while (set.next()) {
- String tableName = set.getString("COLUMN_NAME");
- tableName = (tableName == null) ? "" : tableName.trim();
- if (tableName != null && tableName.length() > 0) {
- list.add(tableName);
- }
+ 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) {
- list.add(tableName);
+ 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[list.size()];
- for (int i = 0; i < list.size(); i++) {
- sqlResults[i] = new IdentifierProposal(
- (String) list.get(i), context, region, viewer,
- PHPUiImages.get(PHPUiImages.IMG_FUN), PHPUiImages
- .get(PHPUiImages.IMG_VAR));
+ sqlResults = new IPHPCompletionProposal[sqlList.size()];
+ for (int i = 0; i < sqlList.size(); i++) {
+ sqlResults[i] = (SQLProposal) sqlList.get(i);
}
}
} catch (NotConnectedException e) {
}
return new IPHPCompletionProposal[0];
}
+
private int guessContextInformationPosition(ITextViewer viewer, int offset) {
int contextPosition = offset;
IDocument document = viewer.getDocument();
// }
return contextPosition;
}
+
/*
* (non-Javadoc) Method declared on IContentAssistProcessor
*/
return (IContextInformation[]) result
.toArray(new IContextInformation[result.size()]);
}
+
private List addContextInformations(ITextViewer viewer, int offset) {
ICompletionProposal[] proposals = internalComputeCompletionProposals(
viewer, offset, -1);
}
return result;
}
+
/**
* Order the given proposals.
*/
Arrays.sort(proposals, fComparator);
return proposals;
}
+
/*
* (non-Javadoc) Method declared on IContentAssistProcessor
*/
return fProposalAutoActivationSet;
// return null; // new char[] { '$' };
}
+
/*
* (non-Javadoc) Method declared on IContentAssistProcessor
*/
public char[] getContextInformationAutoActivationCharacters() {
- return new char[]{};
+ 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