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 fb18a6a..54fe5a6 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 @@ -842,11 +842,7 @@ public class PHPCompletionProcessor implements IContentAssistProcessor { } // if (ExternalInterface.isBookmarkConnected(bookmarkString)) { try { - // Connection connection = bookmark.getConnection(); - // DatabaseMetaData metaData = connection.getMetaData(); - - // if (metaData != null) { - int start = context.getStart(); + int start = context.getStart(); int end = context.getEnd(); String foundSQLTableName = sqlTable.getTableName(); String tableName; @@ -864,55 +860,19 @@ public class PHPCompletionProcessor implements IContentAssistProcessor { 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 (Exception /* NotConnectedException */ e) { - // ignore this - not mission critical - // } catch (SQLException e) { - // e.printStackTrace(); + } // } }