sl@0: // Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).
sl@0: // All rights reserved.
sl@0: // This component and the accompanying materials are made available
sl@0: // under the terms of "Eclipse Public License v1.0"
sl@0: // which accompanies this distribution, and is available
sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: //
sl@0: // Initial Contributors:
sl@0: // Nokia Corporation - initial contribution.
sl@0: //
sl@0: // Contributors:
sl@0: //
sl@0: // Description:
sl@0: //
sl@0: 
sl@0: #include <e32std.h>
sl@0: #include "SqlSrvStrings.h"
sl@0: 
sl@0: _LIT(KCreateSql, "CREATE");
sl@0: _LIT(KIndexSql,  "INDEX");
sl@0: _LIT(KIfSql,     "IF");
sl@0: _LIT(KNotSql,    "NOT");
sl@0: _LIT(KExistsSql, "EXISTS");
sl@0: _LIT(KDotSql,    ".");
sl@0: 
sl@0: 
sl@0: /**
sl@0: Determines whether the specified string is an SQL statement that is supported as a config operation.
sl@0: Currently only 'CREATE INDEX' SQL statements are supported. If necessary adds qualifyed DB name  to index name.
sl@0: 
sl@0: @param aStatementIn The string to be checked to determine if it is a supported SQL statement
sl@0: @param aDbName Logical database name: "main" for the main database or attached database name
sl@0: @param aStatementOut Output parameter. Buffer for the constructed statement (if the statement is supported).
sl@0: 
sl@0: @return True if the aStatementIn statement is supported, aStatementOut will contain the zero-terminated
sl@0: 		aStatementIn statement with the database name in it, if aDbName is a name of an attached database
sl@0: */	
sl@0: TBool IsStatementSupported(const TDesC& aStatementIn, const TDesC& aDbName, TDes& aStatementOut)
sl@0: 	{	
sl@0: 	//'CREATE INDEX' is the only statement currently supported.
sl@0: 	//We must allow for whitespace between the 'CREATE' and the 'INDEX'
sl@0: 	TLex stmtParser(aStatementIn);
sl@0: 	TPtrC firstToken = stmtParser.NextToken(); // extract the first token of the statement
sl@0: 	if(firstToken.CompareF(KCreateSql()) != 0)
sl@0: 		{
sl@0: 		return EFalse;	
sl@0: 		}
sl@0: 	//The first token is 'CREATE', now skip any whitespace between 
sl@0: 	//it and the next token and ensure that the next token is 'INDEX'
sl@0: 	TPtrC secondToken = stmtParser.NextToken(); // skip any whitespace and extract the next token
sl@0: 	if(secondToken.CompareF(KIndexSql()) != 0)
sl@0: 		{
sl@0: 		return EFalse;	
sl@0: 		}
sl@0: 	//The second token is 'INDEX'
sl@0: 	TPtrC curToken = stmtParser.NextToken();
sl@0: 	// skip optional [IF NOT EXISTS]
sl@0: 	if(curToken.CompareF(KIfSql()) == 0)
sl@0: 		{
sl@0: 		curToken.Set(stmtParser.NextToken());
sl@0: 		if(curToken.CompareF(KNotSql()) != 0)
sl@0: 			{
sl@0: 			return EFalse;	
sl@0: 			}
sl@0: 		curToken.Set(stmtParser.NextToken());
sl@0: 		if(curToken.CompareF(KExistsSql()) != 0)
sl@0: 			{
sl@0: 			return EFalse;	
sl@0: 			}
sl@0: 		curToken.Set(stmtParser.NextToken());
sl@0: 		}
sl@0: 	// we got '[database-name.]index-name'
sl@0: 	if(curToken.Find(KDotSql)==KErrNotFound && aDbName.CompareF(KMainDb16) != 0) // just index-name
sl@0: 		{
sl@0: 		// Add DB name prefix before table name in the case of CREATE INDEX
sl@0: 		aStatementOut.Copy(aStatementIn.Ptr(), curToken.Ptr()-aStatementIn.Ptr());
sl@0: 		aStatementOut.Append(aDbName);
sl@0: 		aStatementOut.Append(KDotSql);
sl@0: 		aStatementOut.Append(curToken);
sl@0: 		aStatementOut.Append(stmtParser.Remainder());
sl@0: 		}
sl@0: 	else
sl@0: 		{
sl@0: 		aStatementOut.Copy(aStatementIn);
sl@0: 		}
sl@0: 	aStatementOut.Append(TChar(0)); // SQLite requires statements to be zero-terminated
sl@0: 	return ETrue;
sl@0: 	}