1 // Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).

     2 // All rights reserved.

     3 // This component and the accompanying materials are made available

     4 // under the terms of "Eclipse Public License v1.0"

     5 // which accompanies this distribution, and is available

     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     7 //

     8 // Initial Contributors:

     9 // Nokia Corporation - initial contribution.

    10 //

    11 // Contributors:

    12 //

    13 // Description:

    14 //

    15 

    16 #include <e32std.h>

    17 #include "sqlite3.h"

    18 

    19 //This function searches aString argument for ';' occurences.

    20 //Every time when it finds a ';' character, the function places a 0 right after the ';' and

    21 //tests the just created, zero-terminated substring if it is a comlpete SQL statement.

    22 //

    23 //If it is a SQL statement, the function replaces the found ';' character with 0 and returns the just created

    24 //zero-terminated substring.Also the function modifies aString argument to point right after the found

    25 //SQL string. If it is not SQL statement, the function will continue the searching.

    26 //

    27 //If there is no ';' inside aString argument, the function returns the same string as a return result and

    28 //modifies aString argument - sets it to TPtr(NULL, 0, 0).

    29 //

    30 //The function expects aString argument to be zero-terminated.

    31 TPtrC GetFirstSqlStmt(TPtr& aString)

    32 	{

    33 	const TChar KDelimitier(';');

    34 	TPtr str(const_cast <TUint16*> (aString.Ptr()), aString.Length(), aString.Length());

    35 	TInt afterDelimitierPos = 0;

    36 	TInt pos;

    37 	while((pos = str.Locate(KDelimitier) + 1) > 0 && pos < str.Length())

    38 		{

    39 		//There is a possibility that the string which terminates with the found ';' is SQL statement.

    40 		//Zero terminate the string placing a zero right after ';' character and test it using sqlite3_complete16()

    41 		//call. If it is not SQL string, restore the original character and continue searching.

    42 		afterDelimitierPos += pos;

    43 		TChar ch = aString[afterDelimitierPos];

    44 		aString[afterDelimitierPos] = 0;

    45 		TInt res = sqlite3_complete16(aString.Ptr());

    46 		aString[afterDelimitierPos] = ch;

    47 		if(res)

    48 			{

    49 			str.Set(const_cast <TUint16*> (aString.Ptr()), afterDelimitierPos, afterDelimitierPos);	

    50 			//Replace the found ';' character with 0.

    51 			str[afterDelimitierPos - 1] = 0;

    52 			aString.Set(const_cast <TUint16*> (aString.Ptr()) + afterDelimitierPos, aString.Length() - afterDelimitierPos, aString.Length() - afterDelimitierPos);

    53 			return str;

    54 			}

    55 		str.Set(const_cast <TUint16*> (str.Ptr()) + pos, str.Length() - pos, str.Length() - pos);	

    56 		}

    57 	//aString argument does not contain valid SQL statement or there is no ';' character inside aString.

    58 	//Set aString to TPtr(NULL, 0, 0) and return the original string.

    59 	aString.Set(NULL, 0, 0);

    60 	return str;

    61 	}