5d50deea7261196b89b0a7ca7fb10f50811f1b14
[phpeclipse.git] / net.sourceforge.phpeclipse / src / net / sourceforge / phpeclipse / phpeditor / php / PHPCompletionProcessor.java
1 /**********************************************************************
2  Copyright (c) 2000, 2002 IBM Corp. and others.
3  All rights reserved. This program and the accompanying materials
4  are made available under the terms of the Common Public License v1.0
5  which accompanies this distribution, and is available at
6  http://www.eclipse.org/legal/cpl-v10.html
7
8  Contributors:
9  IBM Corporation - Initial implementation
10  Klaus Hartlage - www.eclipseproject.de
11  **********************************************************************/
12 package net.sourceforge.phpeclipse.phpeditor.php;
13
14 import java.sql.Connection;
15 import java.sql.DatabaseMetaData;
16 import java.sql.ResultSet;
17 import java.sql.SQLException;
18 import java.util.ArrayList;
19 import java.util.Arrays;
20 import java.util.List;
21 import java.util.SortedMap;
22
23 import net.sourceforge.phpdt.core.ICompilationUnit;
24 import net.sourceforge.phpdt.core.ToolFactory;
25 import net.sourceforge.phpdt.core.compiler.ITerminalSymbols;
26 import net.sourceforge.phpdt.core.compiler.InvalidInputException;
27 import net.sourceforge.phpdt.internal.compiler.parser.Scanner;
28 import net.sourceforge.phpdt.internal.corext.template.php.CompilationUnitContextType;
29 import net.sourceforge.phpdt.internal.corext.template.php.JavaContext;
30 import net.sourceforge.phpdt.internal.corext.template.php.JavaContextType;
31 import net.sourceforge.phpdt.internal.ui.PHPUiImages;
32 import net.sourceforge.phpdt.internal.ui.text.java.IPHPCompletionProposal;
33 import net.sourceforge.phpdt.internal.ui.text.java.PHPCompletionProposalComparator;
34 import net.sourceforge.phpdt.internal.ui.text.template.BuiltInEngine;
35 import net.sourceforge.phpdt.internal.ui.text.template.DeclarationEngine;
36 import net.sourceforge.phpdt.internal.ui.text.template.IdentifierEngine;
37 import net.sourceforge.phpdt.internal.ui.text.template.SQLProposal;
38 import net.sourceforge.phpdt.internal.ui.text.template.contentassist.TemplateEngine;
39 import net.sourceforge.phpdt.ui.IWorkingCopyManager;
40 import net.sourceforge.phpeclipse.PHPeclipsePlugin;
41 import net.sourceforge.phpeclipse.builder.IdentifierIndexManager;
42 import net.sourceforge.phpeclipse.phpeditor.PHPEditor;
43 import net.sourceforge.phpeclipse.phpeditor.PHPSyntaxRdr;
44 import net.sourceforge.phpeclipse.ui.IPreferenceConstants;
45 import net.sourceforge.phpeclipse.ui.overlaypages.Util;
46
47 import org.eclipse.core.resources.IFile;
48 import org.eclipse.core.resources.IProject;
49 import org.eclipse.jface.text.BadLocationException;
50 import org.eclipse.jface.text.IDocument;
51 import org.eclipse.jface.text.IRegion;
52 import org.eclipse.jface.text.ITextViewer;
53 import org.eclipse.jface.text.Region;
54 import org.eclipse.jface.text.TextPresentation;
55 import org.eclipse.jface.text.contentassist.ICompletionProposal;
56 import org.eclipse.jface.text.contentassist.IContentAssistProcessor;
57 import org.eclipse.jface.text.contentassist.IContextInformation;
58 import org.eclipse.jface.text.contentassist.IContextInformationExtension;
59 import org.eclipse.jface.text.contentassist.IContextInformationPresenter;
60 import org.eclipse.jface.text.contentassist.IContextInformationValidator;
61 import org.eclipse.jface.text.templates.TemplateContextType;
62 import org.eclipse.swt.graphics.Image;
63 import org.eclipse.swt.graphics.Point;
64 import org.eclipse.ui.IEditorPart;
65 import org.eclipse.ui.IFileEditorInput;
66
67 import com.quantum.model.Bookmark;
68 import com.quantum.model.BookmarkCollection;
69 import com.quantum.model.NotConnectedException;
70 import com.quantum.util.connection.ConnectionUtil;
71
72 /**
73  * Example PHP completion processor.
74  */
75 public class PHPCompletionProcessor implements IContentAssistProcessor {
76   /**
77    * Simple content assist tip closer. The tip is valid in a range of 5
78    * characters around its popup location.
79    */
80   protected static class Validator implements IContextInformationValidator,
81       IContextInformationPresenter {
82     protected int fInstallOffset;
83
84     /*
85      * @see IContextInformationValidator#isContextInformationValid(int)
86      */
87     public boolean isContextInformationValid(int offset) {
88       return Math.abs(fInstallOffset - offset) < 5;
89     }
90
91     /*
92      * @see IContextInformationValidator#install(IContextInformation,
93      *      ITextViewer, int)
94      */
95     public void install(IContextInformation info, ITextViewer viewer, int offset) {
96       fInstallOffset = offset;
97     }
98
99     /*
100      * @see org.eclipse.jface.text.contentassist.IContextInformationPresenter#updatePresentation(int,
101      *      TextPresentation)
102      */
103     public boolean updatePresentation(int documentPosition,
104         TextPresentation presentation) {
105       return false;
106     }
107   };
108
109   private static class ContextInformationWrapper implements
110       IContextInformation, IContextInformationExtension {
111     private final IContextInformation fContextInformation;
112
113     private int fPosition;
114
115     public ContextInformationWrapper(IContextInformation contextInformation) {
116       fContextInformation = contextInformation;
117     }
118
119     /*
120      * @see IContextInformation#getContextDisplayString()
121      */
122     public String getContextDisplayString() {
123       return fContextInformation.getContextDisplayString();
124     }
125
126     /*
127      * @see IContextInformation#getImage()
128      */
129     public Image getImage() {
130       return fContextInformation.getImage();
131     }
132
133     /*
134      * @see IContextInformation#getInformationDisplayString()
135      */
136     public String getInformationDisplayString() {
137       return fContextInformation.getInformationDisplayString();
138     }
139
140     /*
141      * @see IContextInformationExtension#getContextInformationPosition()
142      */
143     public int getContextInformationPosition() {
144       return fPosition;
145     }
146
147     public void setContextInformationPosition(int position) {
148       fPosition = position;
149     }
150   };
151
152   private class TableName {
153     String fTableName;
154
155     TableName() {
156       fTableName = null;
157     }
158
159     /**
160      * @return Returns the tableName.
161      */
162     public String getTableName() {
163       if (fTableName == null) {
164         return "<!--no-table-->";
165       }
166       return fTableName;
167     }
168
169     /**
170      * @param tableName
171      *          The tableName to set.
172      */
173     public void setTableName(String tableName) {
174       fTableName = tableName;
175     }
176   }
177
178   private char[] fProposalAutoActivationSet;
179
180   protected IContextInformationValidator fValidator = new Validator();
181
182   private TemplateEngine fTemplateEngine;
183
184   private PHPCompletionProposalComparator fComparator;
185
186   private int fNumberOfComputedResults = 0;
187
188   private IEditorPart fEditor;
189
190   protected IWorkingCopyManager fManager;
191
192   public PHPCompletionProcessor(IEditorPart editor) {
193     fEditor = editor;
194     fManager = PHPeclipsePlugin.getDefault().getWorkingCopyManager();
195     TemplateContextType contextType = PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
196         "php"); //$NON-NLS-1$
197     if (contextType != null)
198       fTemplateEngine = new TemplateEngine(contextType);
199     fComparator = new PHPCompletionProposalComparator();
200   }
201
202   /**
203    * Tells this processor to order the proposals alphabetically.
204    * 
205    * @param order
206    *          <code>true</code> if proposals should be ordered.
207    */
208   public void orderProposalsAlphabetically(boolean order) {
209     fComparator.setOrderAlphabetically(order);
210   }
211
212   /**
213    * Sets this processor's set of characters triggering the activation of the
214    * completion proposal computation.
215    * 
216    * @param activationSet
217    *          the activation set
218    */
219   public void setCompletionProposalAutoActivationCharacters(char[] activationSet) {
220     fProposalAutoActivationSet = activationSet;
221   }
222
223   /*
224    * (non-Javadoc) Method declared on IContentAssistProcessor
225    */
226   public ICompletionProposal[] computeCompletionProposals(ITextViewer viewer,
227       int documentOffset) {
228     int contextInformationPosition = guessContextInformationPosition(viewer,
229         documentOffset);
230     return internalComputeCompletionProposals(viewer, documentOffset,
231         contextInformationPosition);
232   }
233
234   private int getLastToken(ITextViewer viewer, int completionPosition,
235       JavaContext context, TableName tableName) {
236     IDocument document = viewer.getDocument();
237     int start = context.getStart();
238     int end = context.getEnd();
239     String startText;
240     int lastSignificantToken = ITerminalSymbols.TokenNameEOF;
241     try {
242       // begin search 2 lines behind of this
243       int j = start;
244       if (j != 0) {
245         char ch;
246         while (j-- > 0) {
247           ch = document.getChar(j);
248           if (ch == '\n') {
249             break;
250           }
251         }
252         while (j-- > 0) {
253           ch = document.getChar(j);
254           if (ch == '\n') {
255             break;
256           }
257         }
258       }
259       if (j != start) {
260         // scan the line for the dereferencing operator '->'
261         startText = document.get(j, start - j);
262         if (Scanner.DEBUG) {
263           System.out.println(startText);
264         }
265         int token = ITerminalSymbols.TokenNameEOF;
266         //        token = getLastSQLToken(startText);
267         tableName.setTableName(getLastSQLTableName(startText));
268         Scanner scanner = ToolFactory.createScanner(false, false, false);
269         scanner.setSource(startText.toCharArray());
270         scanner.setPHPMode(true);
271         int beforeLastToken = ITerminalSymbols.TokenNameEOF;
272         int lastToken = ITerminalSymbols.TokenNameEOF;
273         char[] ident;
274         try {
275           token = scanner.getNextToken();
276           lastToken = token;
277           while (token != ITerminalSymbols.TokenNameERROR
278               && token != ITerminalSymbols.TokenNameEOF) {
279             beforeLastToken = lastToken;
280             if (lastToken==ITerminalSymbols.TokenNameVariable) {
281               ident = scanner.getCurrentTokenSource();
282               if (ident.length==5 &&
283                   ident[0]=='$' &&
284                   ident[1]=='t' &&
285                   ident[2]=='h' &&
286                   ident[3]=='i' &&
287                   ident[4]=='s') {
288                 beforeLastToken = ITerminalSymbols.TokenNamethis_PHP_COMPLETION;
289               }
290             }
291             lastToken = token;
292             //                                                          System.out.println(scanner.toStringAction(lastToken));
293             token = scanner.getNextToken();
294           }
295         } catch (InvalidInputException e1) {
296         }
297         switch (lastToken) {
298         case ITerminalSymbols.TokenNameMINUS_GREATER:
299           // dereferencing operator '->' found
300           lastSignificantToken = ITerminalSymbols.TokenNameMINUS_GREATER;
301           if (beforeLastToken == ITerminalSymbols.TokenNameVariable) {
302             lastSignificantToken = ITerminalSymbols.TokenNameVariable;
303           }
304           break;
305         case ITerminalSymbols.TokenNamenew:
306           lastSignificantToken = ITerminalSymbols.TokenNamenew;
307           break;
308         }
309       }
310     } catch (BadLocationException e) {
311     }
312     return lastSignificantToken;
313   }
314
315   String getSQLTableName(String sqlText, int start) {
316     int tableNameStart = -1;
317     int currentCharacterPosition = start + 1;
318     char ch;
319     try {
320       while (true) {
321         ch = sqlText.charAt(currentCharacterPosition++);
322         if (tableNameStart == -1 && Character.isJavaIdentifierStart(ch)) {
323           tableNameStart = currentCharacterPosition - 1;
324         } else {
325           if (!Character.isJavaIdentifierPart(ch)) {
326             return sqlText.substring(tableNameStart,
327                 currentCharacterPosition - 1);
328           }
329         }
330       }
331     } catch (IndexOutOfBoundsException e) {
332       if (tableNameStart >= 0) {
333         return sqlText.substring(tableNameStart, currentCharacterPosition - 1);
334       }
335     }
336     return "";
337   }
338
339   private String getLastSQLTableName(String startText) {
340     int token;
341     // scan for sql identifiers
342     char ch = ' ';
343     int currentSQLPosition = startText.length();
344     int identEnd = -1;
345     String ident = null;
346     boolean whiteSpace = true;
347     try {
348       while (true) {
349         ch = startText.charAt(--currentSQLPosition);
350         if (ch >= 'A' && ch <= 'Z') {
351           if (identEnd < 0) {
352             identEnd = currentSQLPosition + 1;
353           }
354         } else if (ch >= 'a' && ch <= 'z') {
355           if (identEnd < 0) {
356             identEnd = currentSQLPosition + 1;
357           }
358         } else if (identEnd >= 0) {
359           ident = startText.substring(currentSQLPosition + 1, identEnd);
360           // select -- from -- where --
361           // update -- set -- where --
362           // insert into -- ( -- ) values ( -- )
363           if (ident.length() >= 4 && ident.length() <= 6) {
364             ident = ident.toLowerCase();
365             switch (ident.length()) {
366             //              case 3 :
367             //                if (ident.equals("set")) {
368             //                  // System.out.println("set");
369             //                  token = ITerminalSymbols.TokenNameSQLset;
370             //                  return token;
371             //                }
372             //                break;
373             case 4:
374               if (ident.equals("from")) {
375                 //                  System.out.println("from");
376                 token = ITerminalSymbols.TokenNameSQLfrom;
377                 return getSQLTableName(startText, identEnd);
378               } else if (ident.equals("into")) {
379                 //                System.out.println("into");
380                 token = ITerminalSymbols.TokenNameSQLinto;
381                 return getSQLTableName(startText, identEnd);
382               }
383               break;
384             //              case 5 :
385             //                if (ident.equals("where")) {
386             //                  // System.out.println("where");
387             //                  token = ITerminalSymbols.TokenNameSQLwhere;
388             //                  return token;
389             //                }
390             //                break;
391             case 6:
392               //                if (ident.equals("select")) {
393               //                  // System.out.println("select");
394               //                  token = ITerminalSymbols.TokenNameSQLselect;
395               //                  return token;
396               //                } else if (ident.equals("insert")) {
397               //                  // System.out.println("insert");
398               //                  token = ITerminalSymbols.TokenNameSQLinsert;
399               //                  return token;
400               //                } else
401               if (ident.equals("update")) {
402                 //                  System.out.println("update");
403                 token = ITerminalSymbols.TokenNameSQLupdate;
404                 return getSQLTableName(startText, identEnd);
405               }
406               //                else if (ident.equals("values")) {
407               //                  // System.out.println("values");
408               //                  token = ITerminalSymbols.TokenNameSQLvalues;
409               //                  return token;
410               //                }
411               break;
412             }
413           }
414           whiteSpace = false;
415           identEnd = -1;
416         } else if (Character.isWhitespace(ch)) {
417         } else {
418           whiteSpace = false;
419         }
420       }
421     } catch (IndexOutOfBoundsException e) {
422     }
423     return "<!--no-table-->";
424   }
425
426   /**
427    * Detect the last significant SQL token in the text before the completion
428    * 
429    * @param startText
430    */
431   private int getLastSQLToken(String startText) {
432     int token;
433     // scan for sql identifiers
434     char ch = ' ';
435     int currentSQLPosition = startText.length();
436     int identEnd = -1;
437     String ident = null;
438     boolean whiteSpace = true;
439     try {
440       while (true) {
441         ch = startText.charAt(--currentSQLPosition);
442         if (ch >= 'A' && ch <= 'Z') {
443           if (identEnd < 0) {
444             identEnd = currentSQLPosition + 1;
445           }
446         } else if (ch >= 'a' && ch <= 'z') {
447           if (identEnd < 0) {
448             identEnd = currentSQLPosition + 1;
449           }
450         } else if (identEnd >= 0) {
451           ident = startText.substring(currentSQLPosition + 1, identEnd);
452           // select -- from -- where --
453           // update -- set -- where --
454           // insert into -- ( -- ) values ( -- )
455           if (ident.length() >= 3 && ident.length() <= 6) {
456             ident = ident.toLowerCase();
457             switch (ident.length()) {
458             case 3:
459               if (ident.equals("set")) {
460                 //                  System.out.println("set");
461                 token = ITerminalSymbols.TokenNameSQLset;
462                 return token;
463               }
464               break;
465             case 4:
466               if (ident.equals("from")) {
467                 //                  System.out.println("from");
468                 token = ITerminalSymbols.TokenNameSQLfrom;
469                 //getSQLTableName();
470                 return token;
471               } else if (ident.equals("into")) {
472                 //                System.out.println("into");
473                 token = ITerminalSymbols.TokenNameSQLinto;
474                 return token;
475               }
476               break;
477             case 5:
478               if (ident.equals("where")) {
479                 //                  System.out.println("where");
480                 token = ITerminalSymbols.TokenNameSQLwhere;
481                 return token;
482               }
483               break;
484             case 6:
485               if (ident.equals("select")) {
486                 //                  System.out.println("select");
487                 token = ITerminalSymbols.TokenNameSQLselect;
488                 return token;
489               } else if (ident.equals("insert")) {
490                 //                  System.out.println("insert");
491                 token = ITerminalSymbols.TokenNameSQLinsert;
492                 return token;
493               } else if (ident.equals("update")) {
494                 //                  System.out.println("update");
495                 token = ITerminalSymbols.TokenNameSQLupdate;
496                 return token;
497               } else if (ident.equals("values")) {
498                 //                System.out.println("values");
499                 token = ITerminalSymbols.TokenNameSQLvalues;
500                 return token;
501               }
502               break;
503             }
504           }
505           whiteSpace = false;
506           identEnd = -1;
507         } else if (Character.isWhitespace(ch)) {
508         } else {
509           whiteSpace = false;
510         }
511       }
512     } catch (IndexOutOfBoundsException e) {
513     }
514     return ITerminalSymbols.TokenNameEOF;
515   }
516
517   private ICompletionProposal[] internalComputeCompletionProposals(
518       ITextViewer viewer, int offset, int contextOffset) {
519     ICompilationUnit unit= fManager.getWorkingCopy(fEditor.getEditorInput());
520     IDocument document = viewer.getDocument();
521     Object[] identifiers = null;
522     IFile file = null;
523     IProject project = null;
524     if (offset > 0) {
525       PHPEditor editor = null;
526       if (fEditor != null && (fEditor instanceof PHPEditor)) {
527         editor = (PHPEditor) fEditor;
528         file = ((IFileEditorInput) editor.getEditorInput()).getFile();
529         project = file.getProject();
530       }
531     }
532     
533     Point selection= viewer.getSelectedRange();
534
535         // remember selected text
536         String selectedText= null;
537         if (selection.y != 0) {
538                 try {
539                         selectedText= document.get(selection.x, selection.y);
540                 } catch (BadLocationException e) {}
541         }
542
543     JavaContextType phpContextType = (JavaContextType)PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
544     "php"); //$NON-NLS-1$
545 //    ((CompilationUnitContextType) phpContextType).setContextParameters(
546 //        document, offset, 0);
547     JavaContext context = (JavaContext) phpContextType.createContext(document, offset,selection.y,unit);
548     context.setVariable("selection", selectedText); //$NON-NLS-1$
549     String prefix = context.getKey();
550     TableName sqlTable = new TableName();
551     int lastSignificantToken = getLastToken(viewer, offset, context, sqlTable);
552     boolean useClassMembers = (lastSignificantToken == ITerminalSymbols.TokenNameMINUS_GREATER)
553         || (lastSignificantToken == ITerminalSymbols.TokenNameVariable)
554         || (lastSignificantToken == ITerminalSymbols.TokenNamenew)
555         || (lastSignificantToken == ITerminalSymbols.TokenNamethis_PHP_COMPLETION);
556     boolean emptyPrefix = prefix == null || prefix.equals("");
557     if (fTemplateEngine != null) {
558       IPHPCompletionProposal[] templateResults = new IPHPCompletionProposal[0];
559       ICompletionProposal[] results;
560       if (!emptyPrefix) {
561         fTemplateEngine.reset();
562         fTemplateEngine.complete(viewer, offset, unit);
563         templateResults = fTemplateEngine.getResults();
564       }
565       IPHPCompletionProposal[] identifierResults = new IPHPCompletionProposal[0];
566       if ((!useClassMembers) && identifiers != null) {
567         IdentifierEngine identifierEngine;
568         JavaContextType contextType = (JavaContextType)PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
569         "php"); //$NON-NLS-1$
570         if (contextType != null) {
571           identifierEngine = new IdentifierEngine(contextType);
572           identifierEngine.complete(viewer, offset, identifiers,unit);
573           identifierResults = identifierEngine.getResults();
574         }
575       }
576       // declarations stored in file project.index on project level
577       IPHPCompletionProposal[] declarationResults = new IPHPCompletionProposal[0];
578       if (project != null) {
579         DeclarationEngine declarationEngine;
580         JavaContextType contextType = (JavaContextType)PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
581         "php"); //$NON-NLS-1$
582         if (contextType != null) {
583           IdentifierIndexManager indexManager = PHPeclipsePlugin.getDefault()
584               .getIndexManager(project);
585           SortedMap sortedMap = indexManager.getIdentifierMap();
586           declarationEngine = new DeclarationEngine(project, contextType,
587               lastSignificantToken, file);
588           declarationEngine.complete(viewer, offset, sortedMap,unit);
589           declarationResults = declarationEngine.getResults();
590         }
591       }
592       // built in function names from phpsyntax.xml
593       ArrayList syntaxbuffer = PHPSyntaxRdr.getSyntaxData();
594       IPHPCompletionProposal[] builtinResults = new IPHPCompletionProposal[0];
595       if ((!useClassMembers) && syntaxbuffer != null) {
596         BuiltInEngine builtinEngine;
597         String proposal;
598         JavaContextType contextType = (JavaContextType)PHPeclipsePlugin.getDefault().getTemplateContextRegistry().getContextType(
599         "php"); //$NON-NLS-1$
600         if (contextType != null) {
601           builtinEngine = new BuiltInEngine(contextType);
602           builtinEngine.complete(viewer, offset, syntaxbuffer, unit);
603           builtinResults = builtinEngine.getResults();
604         }
605       }
606       IPHPCompletionProposal[] sqlResults = new IPHPCompletionProposal[0];
607       if (project != null) {
608         // Get The Database bookmark from the Quantum SQL plugin:
609         BookmarkCollection sqlBookMarks = BookmarkCollection.getInstance();
610         if (sqlBookMarks != null) {
611           String bookmarkString = Util.getMiscProjectsPreferenceValue(project,
612               IPreferenceConstants.PHP_BOOKMARK_DEFAULT);
613           if (bookmarkString != null && !bookmarkString.equals("")) {
614             Bookmark bookmark = sqlBookMarks.find(bookmarkString);
615             ArrayList sqlList = new ArrayList();
616             if (bookmark != null && !bookmark.isConnected()) {
617               new ConnectionUtil().connect(bookmark, null);
618             }
619             if (bookmark != null && bookmark.isConnected()) {
620               try {
621                 Connection connection = bookmark.getConnection();
622                 DatabaseMetaData metaData = connection.getMetaData();
623
624                 if (metaData != null) {
625                   int start = context.getStart();
626                   int end = context.getEnd();
627                   String foundSQLTableName = sqlTable.getTableName();
628                   String tableName;
629                   String columnName;
630                   String prefixWithoutDollar = prefix;
631                   boolean isDollarPrefix = false;
632                   if (prefix.length() > 0 && prefix.charAt(0) == '$') {
633                     prefixWithoutDollar = prefix.substring(1);
634                     isDollarPrefix = true;
635                   }
636                   IRegion region = new Region(start, end - start);
637                   ResultSet set;
638                   if (!isDollarPrefix) {
639                     set = metaData.getTables(null, null, prefixWithoutDollar
640                         + "%", null);
641                     while (set.next()) {
642                       //                  String tempSchema = set.getString("TABLE_SCHEM");
643                       //                  tempSchema = (tempSchema == null) ? "" :
644                       // tempSchema.trim();
645                       tableName = set.getString("TABLE_NAME");
646                       tableName = (tableName == null) ? "" : tableName.trim();
647                       if (tableName != null && tableName.length() > 0) {
648                         sqlList.add(new SQLProposal(tableName, context, region,
649                             viewer, PHPUiImages.get(PHPUiImages.IMG_TABLE)));
650                       }
651                     }
652                     set.close();
653                   }
654                   set = metaData.getColumns(null, null, "%",
655                       prefixWithoutDollar + "%");
656                   SQLProposal sqlProposal;
657                   while (set.next()) {
658                     columnName = set.getString("COLUMN_NAME");
659                     columnName = (columnName == null) ? "" : columnName.trim();
660                     tableName = set.getString("TABLE_NAME");
661                     tableName = (tableName == null) ? "" : tableName.trim();
662                     if (tableName != null && tableName.length() > 0
663                         && columnName != null && columnName.length() > 0) {
664                       if (isDollarPrefix) {
665                         sqlProposal = new SQLProposal(tableName, "$"
666                             + columnName, context, region, viewer, PHPUiImages
667                             .get(PHPUiImages.IMG_COLUMN));
668                       } else {
669                         sqlProposal = new SQLProposal(tableName, columnName,
670                             context, region, viewer, PHPUiImages
671                                 .get(PHPUiImages.IMG_COLUMN));
672                       }
673                       if (tableName.equals(foundSQLTableName)) {
674                         sqlProposal.setRelevance(90);
675                       } else if (tableName.indexOf(foundSQLTableName) >= 0) {
676                         sqlProposal.setRelevance(75);
677                       }
678                       sqlList.add(sqlProposal);
679                     }
680                   }
681                   set.close();
682                   sqlResults = new IPHPCompletionProposal[sqlList.size()];
683                   for (int i = 0; i < sqlList.size(); i++) {
684                     sqlResults[i] = (SQLProposal) sqlList.get(i);
685                   }
686                 }
687               } catch (NotConnectedException e) {
688                 // ignore this - not mission critical
689               } catch (SQLException e) {
690                 e.printStackTrace();
691               }
692             }
693           }
694         }
695       }
696       // concatenate the result arrays
697       IPHPCompletionProposal[] total;
698       total = new IPHPCompletionProposal[templateResults.length
699           + identifierResults.length + builtinResults.length
700           + declarationResults.length + sqlResults.length];
701       System.arraycopy(templateResults, 0, total, 0, templateResults.length);
702       System.arraycopy(identifierResults, 0, total, templateResults.length,
703           identifierResults.length);
704       System.arraycopy(builtinResults, 0, total, templateResults.length
705           + identifierResults.length, builtinResults.length);
706       System.arraycopy(declarationResults, 0, total, templateResults.length
707           + identifierResults.length + builtinResults.length,
708           declarationResults.length);
709       System.arraycopy(sqlResults, 0, total, templateResults.length
710           + identifierResults.length + builtinResults.length
711           + declarationResults.length, sqlResults.length);
712       results = total;
713       fNumberOfComputedResults = (results == null ? 0 : results.length);
714       /*
715        * Order here and not in result collector to make sure that the order
716        * applies to all proposals and not just those of the compilation unit.
717        */
718       return order(results);
719     }
720     return new IPHPCompletionProposal[0];
721   }
722
723   private int guessContextInformationPosition(ITextViewer viewer, int offset) {
724     int contextPosition = offset;
725     IDocument document = viewer.getDocument();
726     //    try {
727     //
728     //      PHPCodeReader reader= new PHPCodeReader();
729     //      reader.configureBackwardReader(document, offset, true, true);
730     //  
731     //      int nestingLevel= 0;
732     //
733     //      int curr= reader.read();
734     //      while (curr != PHPCodeReader.EOF) {
735     //
736     //        if (')' == (char) curr)
737     //          ++ nestingLevel;
738     //
739     //        else if ('(' == (char) curr) {
740     //          -- nestingLevel;
741     //        
742     //          if (nestingLevel < 0) {
743     //            int start= reader.getOffset();
744     //            if (looksLikeMethod(reader))
745     //              return start + 1;
746     //          }
747     //        }
748     //
749     //        curr= reader.read();
750     //      }
751     //    } catch (IOException e) {
752     //    }
753     return contextPosition;
754   }
755
756   /*
757    * (non-Javadoc) Method declared on IContentAssistProcessor
758    */
759   //  public IContextInformation[] computeContextInformation(ITextViewer viewer,
760   // int documentOffset) {
761   //    IContextInformation[] result = new IContextInformation[5];
762   //    for (int i = 0; i < result.length; i++)
763   //      result[i] = new
764   // ContextInformation(MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.display.pattern"),
765   // new Object[] { new Integer(i), new Integer(documentOffset)}),
766   // //$NON-NLS-1$
767   //      MessageFormat.format(PHPEditorMessages.getString("CompletionProcessor.ContextInfo.value.pattern"),
768   // new Object[] { new Integer(i), new Integer(documentOffset - 5), new
769   // Integer(documentOffset + 5)})); //$NON-NLS-1$
770   //    return result;
771   //  }
772   /**
773    * @see IContentAssistProcessor#computeContextInformation(ITextViewer, int)
774    */
775   public IContextInformation[] computeContextInformation(ITextViewer viewer,
776       int offset) {
777     int contextInformationPosition = guessContextInformationPosition(viewer,
778         offset);
779     List result = addContextInformations(viewer, contextInformationPosition);
780     return (IContextInformation[]) result
781         .toArray(new IContextInformation[result.size()]);
782   }
783
784   private List addContextInformations(ITextViewer viewer, int offset) {
785     ICompletionProposal[] proposals = internalComputeCompletionProposals(
786         viewer, offset, -1);
787     List result = new ArrayList();
788     for (int i = 0; i < proposals.length; i++) {
789       IContextInformation contextInformation = proposals[i]
790           .getContextInformation();
791       if (contextInformation != null) {
792         ContextInformationWrapper wrapper = new ContextInformationWrapper(
793             contextInformation);
794         wrapper.setContextInformationPosition(offset);
795         result.add(wrapper);
796       }
797     }
798     return result;
799   }
800
801   /**
802    * Order the given proposals.
803    */
804   private ICompletionProposal[] order(ICompletionProposal[] proposals) {
805     Arrays.sort(proposals, fComparator);
806     return proposals;
807   }
808
809   /*
810    * (non-Javadoc) Method declared on IContentAssistProcessor
811    */
812   public char[] getCompletionProposalAutoActivationCharacters() {
813     return fProposalAutoActivationSet;
814     //    return null; // new char[] { '$' };
815   }
816
817   /*
818    * (non-Javadoc) Method declared on IContentAssistProcessor
819    */
820   public char[] getContextInformationAutoActivationCharacters() {
821     return new char[] {};
822   }
823
824   /*
825    * (non-Javadoc) Method declared on IContentAssistProcessor
826    */
827   public IContextInformationValidator getContextInformationValidator() {
828     return fValidator;
829   }
830
831   /*
832    * (non-Javadoc) Method declared on IContentAssistProcessor
833    */
834   public String getErrorMessage() {
835     return null;
836   }
837 }