1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sqlite3api/TEST/t_sqlitewsdinsert.cpp	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,78 @@
     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 <e32test.h>
    1.20 +#include <e32uid.h>
    1.21 +#include <f32file.h>
    1.22 +#include <e32math.h>
    1.23 +#include <sqlite3.h>
    1.24 +#include "t_sqlitewsd.h"
    1.25 +
    1.26 +void DoInserts(TInt aProcId, TInt aRecId1, TInt aRecId2)
    1.27 +	{
    1.28 +	TEST(TheDb != 0);
    1.29 +	
    1.30 +	TTime now;
    1.31 +	now.UniversalTime();
    1.32 +	TInt64 seed = now.Int64();
    1.33 +	
    1.34 +	const TInt KMaxFailingAllocationNo = 20;
    1.35 +	TInt lockcnt = 0;
    1.36 +	
    1.37 +	for(TInt recno=0;recno<KTestRecordCnt;)
    1.38 +		{
    1.39 +		//Insert record 1 under OOM simulation
    1.40 +		TInt failingAllocationNo = Math::Rand(seed) % (KMaxFailingAllocationNo + 1);
    1.41 +		__UHEAP_SETFAIL(RHeap::EDeterministic, failingAllocationNo );
    1.42 +		TBuf8<100> sql;
    1.43 +		sql.Format(_L8("INSERT INTO A VALUES(%d)"), aRecId1);
    1.44 +		TInt err = sqlite3_exec(TheDb, (const char*)sql.PtrZ(), 0, 0, 0);
    1.45 +		__UHEAP_SETFAIL(RHeap::ENone, 0);	
    1.46 +		TEST(err == SQLITE_NOMEM || err == SQLITE_BUSY || err == SQLITE_OK);
    1.47 +		if(err == SQLITE_BUSY)
    1.48 +			{
    1.49 +			++lockcnt;
    1.50 +			User::After(1);
    1.51 +			continue;	
    1.52 +			}
    1.53 +		else if(err == SQLITE_OK)
    1.54 +			{
    1.55 +			++recno;
    1.56 +			if((recno % 100) == 0)
    1.57 +				{
    1.58 +				RDebug::Print(_L("Process %d: %d records inserted.\r\n"), aProcId, recno);	
    1.59 +				}
    1.60 +			continue;	
    1.61 +			}
    1.62 +		//Insert record 2
    1.63 +		sql.Format(_L8("INSERT INTO A VALUES(%d)"), aRecId2);
    1.64 +		err = sqlite3_exec(TheDb, (const char*)sql.PtrZ(), 0, 0, 0);
    1.65 +		TEST(err == SQLITE_BUSY || err == SQLITE_OK);
    1.66 +		if(err == SQLITE_BUSY)
    1.67 +			{
    1.68 +			++lockcnt;
    1.69 +			User::After(1);
    1.70 +			continue;	
    1.71 +			}
    1.72 +		//SQLITE_OK case
    1.73 +		++recno;
    1.74 +		if((recno % 100) == 0)
    1.75 +			{
    1.76 +			RDebug::Print(_L("Process %d: %d records inserted.\r\n"), aProcId, recno);	
    1.77 +			}
    1.78 +		}
    1.79 +	RDebug::Print(_L("Process %d inserted %d records. %d locks occured.\r\n"), aProcId, KTestRecordCnt, lockcnt);
    1.80 +	}
    1.81 +