/*******************************************************************************
 * Copyright (c) 2004 Actuate Corporation.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *  Actuate Corporation  - initial API and implementation
 *******************************************************************************/

package org.eclipse.birt.report.data.oda.jdbc.ui.editors;

import org.eclipse.jface.text.rules.ICharacterScanner;
import org.eclipse.jface.text.rules.IPredicateRule;
import org.eclipse.jface.text.rules.IToken;
import org.eclipse.jface.text.rules.Token;

/**
 * TODO: Please document
 * 
 * @version $Revision: 1.2 $ $Date: 2005/05/30 07:04:35 $
 */

public class SQLKeywordRule implements IPredicateRule
{

	protected IToken token = null;

	protected String[] keywords = {
			"select", //$NON-NLS-1$
			"from", //$NON-NLS-1$
			"where", //$NON-NLS-1$
			"group by", //$NON-NLS-1$
			"order by", //$NON-NLS-1$
			"having", //$NON-NLS-1$
			"compute", //$NON-NLS-1$
			"selecting" //$NON-NLS-1$
	};

	StringBuffer buf = null;

	/**
	 *  
	 */
	public SQLKeywordRule( IToken _token, String[] keywords )
	{
		super( );
		token = _token;
		buf = new StringBuffer( );
		this.keywords = keywords;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.eclipse.jface.text.rules.IPredicateRule#evaluate(org.eclipse.jface.text.rules.ICharacterScanner,
	 *      boolean)
	 */
	public IToken evaluate( ICharacterScanner scanner, boolean resume )
	{
		int column = scanner.getColumn( );
		int iCh = ' ';//Default it to space. This will be checked if the column
		// is zero
		//First check whether we are at the first column
		if ( column > 0 )
		{
			//if not unread and read the character
			scanner.unread( );
			iCh = scanner.read( );
		}
		IToken tokenToReturn = Token.UNDEFINED;
		buf.setLength( 0 );
		//We should only apply this rule if we have a valid preceding character
		if ( isValidPrecedingCharacter( iCh ) )
		{
			do
			{
				//Read the character
				iCh = scanner.read( );
				//append it to the buffer
				buf.append( Character.toLowerCase( (char) iCh ) );
			} while ( isKeywordStart( buf.toString( ) )
					&& iCh != ICharacterScanner.EOF );
		}

		//Check whether there is anything in the buffer
		if ( buf.length( ) > 0 )
		{
			//System.out.println("buffer contains " + buf.toString());
			//Check whether the last character read was the EOF character
			//or a space character
			if ( isValidTerminatingCharacter( iCh ) )
			{
				//If the length of the buffer is greater than 1
				if ( buf.length( ) > 1 )
				{
					//Strip out the last character
					String sToCompare = buf.substring( 0, buf.length( ) - 1 );
					//System.out.println("String is " + sToCompare);

					//Now check whether it is a keyword
					if ( isKeyword( sToCompare ) )
					{
						tokenToReturn = token;
					}
				}
			}

			if ( tokenToReturn.isUndefined( ) )
			{
				//if the token is undefined
				//then just unread the buffer
				unreadBuffer( scanner );
			}
		}

		return tokenToReturn;
	}

	private final boolean isValidPrecedingCharacter( int iCh )
	{
		return ( iCh == ' ' || iCh == '\r' || iCh == '\n' );
	}

	private final boolean isValidTerminatingCharacter( int iCh )
	{
		return ( isValidPrecedingCharacter( iCh ) || iCh == ICharacterScanner.EOF );
	}

	/**
	 * @param scanner
	 */
	private void unreadBuffer( ICharacterScanner scanner )
	{
		for ( int i = buf.length( ) - 1; i >= 0; i-- )
		{
			scanner.unread( );
		}
	}

	private boolean isKeywordStart( String keyword )
	{
		for ( int n = 0; n < keywords.length; n++ )
		{
			//System.out.println("comparing " + keywords[n] + " = " + keyword);
			if ( keywords[n].startsWith( keyword ) )
			{
				return true;
			}
		}
		return false;
	}

	private boolean isKeyword( String keyword )
	{
		for ( int n = 0; n < keywords.length; n++ )
		{
			if ( keyword.equals( keywords[n] ) )
			{
				return true;
			}
		}
		return false;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.eclipse.jface.text.rules.IPredicateRule#getSuccessToken()
	 */
	public IToken getSuccessToken( )
	{
		return token;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.eclipse.jface.text.rules.IRule#evaluate(org.eclipse.jface.text.rules.ICharacterScanner)
	 */
	public IToken evaluate( ICharacterScanner scanner )
	{
		return evaluate( scanner, false );
	}
}
@@ -836,17 +836,17 @@
 sion: 1.
-2
+1
  $ $Date
@@ -854,24 +854,24 @@
  200
-5/05/30 07:04:35
+6/03/28 10:43:48
  $%0A 
@@ -3296,16 +3296,31 @@
 %7C iCh ==
+ '%5Ct' %7C%7C iCh ==
  '%5Cr' %7C%7C

Fix bugzilla bug 131928 :tabs in the sql editor for a dataset break the syntax highlighting for the next keyword