1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/SRC/Server/SqlSrvCheckStatement.cpp	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,88 @@
     1.4 +// Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).
     1.5 +// All rights reserved.
     1.6 +// This component and the accompanying materials are made available
     1.7 +// under the terms of "Eclipse Public License v1.0"
     1.8 +// which accompanies this distribution, and is available
     1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
    1.10 +//
    1.11 +// Initial Contributors:
    1.12 +// Nokia Corporation - initial contribution.
    1.13 +//
    1.14 +// Contributors:
    1.15 +//
    1.16 +// Description:
    1.17 +//
    1.18 +
    1.19 +#include <e32std.h>
    1.20 +#include "SqlSrvStrings.h"
    1.21 +
    1.22 +_LIT(KCreateSql, "CREATE");
    1.23 +_LIT(KIndexSql,  "INDEX");
    1.24 +_LIT(KIfSql,     "IF");
    1.25 +_LIT(KNotSql,    "NOT");
    1.26 +_LIT(KExistsSql, "EXISTS");
    1.27 +_LIT(KDotSql,    ".");
    1.28 +
    1.29 +
    1.30 +/**
    1.31 +Determines whether the specified string is an SQL statement that is supported as a config operation.
    1.32 +Currently only 'CREATE INDEX' SQL statements are supported. If necessary adds qualifyed DB name  to index name.
    1.33 +
    1.34 +@param aStatementIn The string to be checked to determine if it is a supported SQL statement
    1.35 +@param aDbName Logical database name: "main" for the main database or attached database name
    1.36 +@param aStatementOut Output parameter. Buffer for the constructed statement (if the statement is supported).
    1.37 +
    1.38 +@return True if the aStatementIn statement is supported, aStatementOut will contain the zero-terminated
    1.39 +		aStatementIn statement with the database name in it, if aDbName is a name of an attached database
    1.40 +*/	
    1.41 +TBool IsStatementSupported(const TDesC& aStatementIn, const TDesC& aDbName, TDes& aStatementOut)
    1.42 +	{	
    1.43 +	//'CREATE INDEX' is the only statement currently supported.
    1.44 +	//We must allow for whitespace between the 'CREATE' and the 'INDEX'
    1.45 +	TLex stmtParser(aStatementIn);
    1.46 +	TPtrC firstToken = stmtParser.NextToken(); // extract the first token of the statement
    1.47 +	if(firstToken.CompareF(KCreateSql()) != 0)
    1.48 +		{
    1.49 +		return EFalse;	
    1.50 +		}
    1.51 +	//The first token is 'CREATE', now skip any whitespace between 
    1.52 +	//it and the next token and ensure that the next token is 'INDEX'
    1.53 +	TPtrC secondToken = stmtParser.NextToken(); // skip any whitespace and extract the next token
    1.54 +	if(secondToken.CompareF(KIndexSql()) != 0)
    1.55 +		{
    1.56 +		return EFalse;	
    1.57 +		}
    1.58 +	//The second token is 'INDEX'
    1.59 +	TPtrC curToken = stmtParser.NextToken();
    1.60 +	// skip optional [IF NOT EXISTS]
    1.61 +	if(curToken.CompareF(KIfSql()) == 0)
    1.62 +		{
    1.63 +		curToken.Set(stmtParser.NextToken());
    1.64 +		if(curToken.CompareF(KNotSql()) != 0)
    1.65 +			{
    1.66 +			return EFalse;	
    1.67 +			}
    1.68 +		curToken.Set(stmtParser.NextToken());
    1.69 +		if(curToken.CompareF(KExistsSql()) != 0)
    1.70 +			{
    1.71 +			return EFalse;	
    1.72 +			}
    1.73 +		curToken.Set(stmtParser.NextToken());
    1.74 +		}
    1.75 +	// we got '[database-name.]index-name'
    1.76 +	if(curToken.Find(KDotSql)==KErrNotFound && aDbName.CompareF(KMainDb16) != 0) // just index-name
    1.77 +		{
    1.78 +		// Add DB name prefix before table name in the case of CREATE INDEX
    1.79 +		aStatementOut.Copy(aStatementIn.Ptr(), curToken.Ptr()-aStatementIn.Ptr());
    1.80 +		aStatementOut.Append(aDbName);
    1.81 +		aStatementOut.Append(KDotSql);
    1.82 +		aStatementOut.Append(curToken);
    1.83 +		aStatementOut.Append(stmtParser.Remainder());
    1.84 +		}
    1.85 +	else
    1.86 +		{
    1.87 +		aStatementOut.Copy(aStatementIn);
    1.88 +		}
    1.89 +	aStatementOut.Append(TChar(0)); // SQLite requires statements to be zero-terminated
    1.90 +	return ETrue;
    1.91 +	}