X-Git-Url: http://git.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 fbddc52..0ccf4c7 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 @@ -78,8 +78,8 @@ import org.eclipse.swt.graphics.Point; import org.eclipse.ui.IEditorPart; import org.eclipse.ui.IFileEditorInput; -import com.quantum.ExternalInterface; -import com.quantum.util.connection.NotConnectedException; +//import com.quantum.ExternalInterface; +// import com.quantum.util.connection.NotConnectedException; /** * Example PHP completion processor. @@ -650,23 +650,25 @@ public class PHPCompletionProcessor implements IContentAssistProcessor { builtinResults = builtinEngine.getResults(); } } - ICompletionProposal[] sqlResults = new ICompletionProposal[0]; - if (project != null) { - sqlResults = getSQLProposals(viewer, project, context, prefix, sqlTable); - } +// ICompletionProposal[] sqlResults = new ICompletionProposal[0]; +// if (project != null) { +// sqlResults = getSQLProposals(viewer, project, context, prefix, sqlTable); +// } // concatenate the result arrays IPHPCompletionProposal[] total; total = new IPHPCompletionProposal[localVariableResults.length + templateResults.length + identifierResults.length - + builtinResults.length + declarationResults.length + sqlResults.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(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); System.arraycopy(localVariableResults, 0, total, templateResults.length + identifierResults.length + builtinResults.length - + declarationResults.length + sqlResults.length, localVariableResults.length); + + declarationResults.length, localVariableResults.length); results = total; fNumberOfComputedResults = (results == null ? 0 : results.length); /* @@ -814,111 +816,71 @@ public class PHPCompletionProcessor implements IContentAssistProcessor { * @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("")) { - String[] bookmarks = ExternalInterface.getBookmarkNames(); - boolean foundBookmark = false; - for (int i = 0; i < bookmarks.length; i++) { - if (bookmarks[i].equals(bookmarkString)) { - foundBookmark = true; - } - } - if (!foundBookmark) { - return sqlResults; - } - // Bookmark bookmark = sqlBookMarks.find(bookmarkString); - ArrayList sqlList = new ArrayList(); - if (!ExternalInterface.isBookmarkConnected(bookmarkString)) { - ExternalInterface.connectBookmark(bookmarkString, null); - if (!ExternalInterface.isBookmarkConnected(bookmarkString)) { - return sqlResults; - } - } - // if (ExternalInterface.isBookmarkConnected(bookmarkString)) { - 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) { - String[] tableNames = ExternalInterface.getMatchingTableNames(null, bookmarkString, prefixWithoutDollar, null, false); - for (int i = 0; i < tableNames.length; i++) { - sqlList.add(new SQLProposal(tableNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE))); - } - - // 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(new SQLProposal(tableName, context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE))); - // } - // } - // set.close(); - } - - String[] columnNames = ExternalInterface.getMatchingColumnNames(null, bookmarkString, prefixWithoutDollar, null, false); - for (int i = 0; i < columnNames.length; i++) { - sqlList.add(new SQLProposal(columnNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE))); - } - // 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 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("")) { +// String[] bookmarks = ExternalInterface.getBookmarkNames(); +// boolean foundBookmark = false; +// for (int i = 0; i < bookmarks.length; i++) { +// if (bookmarks[i].equals(bookmarkString)) { +// foundBookmark = true; +// } +// } +// if (!foundBookmark) { +// return sqlResults; +// } +// // Bookmark bookmark = sqlBookMarks.find(bookmarkString); +// ArrayList sqlList = new ArrayList(); +// if (!ExternalInterface.isBookmarkConnected(bookmarkString)) { +// ExternalInterface.connectBookmark(bookmarkString, null); +// if (!ExternalInterface.isBookmarkConnected(bookmarkString)) { +// return sqlResults; +// } +// } +// // if (ExternalInterface.isBookmarkConnected(bookmarkString)) { +// try { +// 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) { +// String[] tableNames = ExternalInterface.getMatchingTableNames(null, bookmarkString, prefixWithoutDollar, null, false); +// for (int i = 0; i < tableNames.length; i++) { +// sqlList.add(new SQLProposal(tableNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE))); +// } +// } +// +// String[] columnNames = ExternalInterface.getMatchingColumnNames(null, bookmarkString, prefixWithoutDollar, null, false); +// for (int i = 0; i < columnNames.length; i++) { +// sqlList.add(new SQLProposal(columnNames[i], context, region, viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE))); +// } +// +// sqlResults = new IPHPCompletionProposal[sqlList.size()]; +// for (int i = 0; i < sqlList.size(); i++) { +// sqlResults[i] = (SQLProposal) sqlList.get(i); +// } +// } catch (Exception /* NotConnectedException */ e) { +// +// } +// // } +// } +// // } +// return sqlResults; +// } private boolean looksLikeMethod(PHPCodeReader reader) throws IOException { int curr = reader.read();