sl@0: // Copyright (c) 2007-2010 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 <e32test.h>
sl@0: #include <sqldb.h>
sl@0: //#include "SqlUtil.h"
sl@0: #include "SqlSrvConfig.h"
sl@0: #include "SqlResourceTester.h"
sl@0: 
sl@0: /////////////////////////////////////////////////////////////////////////////////////////////////
sl@0: /// This test works only if the whole SQL component is built with SYSLIBS_TEST macro defined! ///
sl@0: /////////////////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: RTest TheTest(_L("t_sqlconfigfile test"));
sl@0: 
sl@0: #ifdef SYSLIBS_TEST	
sl@0: 
sl@0: RFs TheFs;
sl@0: RSqlDatabase TheDb;
sl@0: 
sl@0: _LIT(KTestDir, "c:\\test\\");
sl@0: _LIT(KTestDbName, "c:\\test\\t_sqlconfigfile.db");
sl@0: _LIT(KSqlSrvConfigFile, "c:\\test\\t_sqlserver.cfg");
sl@0: _LIT(KSqlSrvName, "sqlsrv.exe");
sl@0: 
sl@0: enum TConfigParamType {EPrmCacheSize, EPrmPageSize, EPrmDbEncoding};
sl@0: 
sl@0: //Default configuration parameter values, defined in ../test/sqlserver.cfg file
sl@0: //(the same as the build-time configuration parameter values)
sl@0: const TInt KDefaultPageSize = 1024;
sl@0: const TInt KDefaultCacheSize = (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / KDefaultPageSize;
sl@0: const TSqlSrvConfigParams::TDbEncoding KDefaultEncoding = TSqlSrvConfigParams::EEncUtf16;
sl@0: 
sl@0: TInt KillProcess(const TDesC& aProcessName);
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: // Destroy functions
sl@0: 
sl@0: TInt KillProcess(const TDesC& aProcessName)
sl@0: 	{
sl@0: 	TFullName name;
sl@0: 	//RDebug::Print(_L("Find and kill \"%S\" process.\n"), &aProcessName);
sl@0: 	TBuf<64> pattern(aProcessName);
sl@0: 	TInt length = pattern.Length();
sl@0: 	pattern += _L("*");
sl@0: 	TFindProcess procFinder(pattern);
sl@0: 
sl@0: 	while (procFinder.Next(name) == KErrNone)
sl@0: 		{
sl@0: 		if (name.Length() > length)
sl@0: 			{//If found name is a string containing aProcessName string.
sl@0: 			TChar c(name[length]);
sl@0: 			if (c.IsAlphaDigit() ||
sl@0: 				c == TChar('_') ||
sl@0: 				c == TChar('-'))
sl@0: 				{
sl@0: 				// If the found name is other valid application name
sl@0: 				// starting with aProcessName string.
sl@0: 				//RDebug::Print(_L(":: Process name: \"%S\".\n"), &name);
sl@0: 				continue;
sl@0: 				}
sl@0: 			}
sl@0: 		RProcess proc;
sl@0: 		if (proc.Open(name) == KErrNone)
sl@0: 			{
sl@0: 			proc.Kill(0);
sl@0: 			//RDebug::Print(_L("\"%S\" process killed.\n"), &name);
sl@0: 			}
sl@0: 		proc.Close();
sl@0: 		}
sl@0: 	return KErrNone;
sl@0: 	}
sl@0: 
sl@0: void DestroyTestEnv()
sl@0: 	{
sl@0: 	TheDb.Close();
sl@0: 	(void)KillProcess(KSqlSrvName);
sl@0: 	(void)TheFs.Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	TheFs.Close();
sl@0: 	}
sl@0: 	
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: // Test macros and functions
sl@0: 
sl@0: void Check(TInt aValue, TInt aLine)
sl@0: 	{
sl@0: 	if(!aValue)
sl@0: 		{
sl@0: 		DestroyTestEnv();
sl@0: 		TheTest(EFalse, aLine);
sl@0: 		}
sl@0: 	}
sl@0: void Check(TInt aValue, TInt aExpected, TInt aLine)
sl@0: 	{
sl@0: 	if(aValue != aExpected)
sl@0: 		{
sl@0: 		DestroyTestEnv();
sl@0: 		RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
sl@0: 		TheTest(EFalse, aLine);
sl@0: 		}
sl@0: 	}
sl@0: #define TEST(arg) ::Check((arg), __LINE__)
sl@0: #define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
sl@0: 
sl@0: // OOM test functions
sl@0: 
sl@0: static TInt TheHandleCount1;
sl@0: static TInt TheHandleCount2;
sl@0: static TInt TheAllocatedCellsCount;
sl@0: 
sl@0: void MarkHandles()
sl@0: 	{
sl@0: 	RThread().HandleCount(TheHandleCount1, TheHandleCount2);
sl@0: 	}
sl@0: 
sl@0: void CheckHandles()
sl@0: 	{
sl@0: 	TInt endHandleCount1;
sl@0: 	TInt endHandleCount2;
sl@0: 
sl@0: 	RThread().HandleCount(endHandleCount1, endHandleCount2);
sl@0: 
sl@0: 	TEST(TheHandleCount1 == endHandleCount1);
sl@0: 	TEST(TheHandleCount2 == endHandleCount2);
sl@0: 	}
sl@0: 
sl@0: void MarkAllocatedCells()
sl@0: 	{
sl@0: 	TheAllocatedCellsCount = User::CountAllocCells();
sl@0: 	}
sl@0: 
sl@0: void CheckAllocatedCells()
sl@0: 	{
sl@0: 	TInt allocatedCellsCount = User::CountAllocCells();
sl@0: 	TEST(allocatedCellsCount == TheAllocatedCellsCount);
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: // Set up functions
sl@0: 
sl@0: TInt DoCreateSecurityPolicy(RSqlSecurityPolicy& securityPolicy)
sl@0: 	{
sl@0: 	const TSecurityPolicy KDefaultPolicy(TSecurityPolicy::EAlwaysPass);
sl@0: 	if((KErrNone != securityPolicy.Create(KDefaultPolicy))
sl@0: 	   ||
sl@0: 	   (KErrNone != securityPolicy.SetDbPolicy(RSqlSecurityPolicy::ESchemaPolicy, KDefaultPolicy))
sl@0: 	   ||
sl@0: 	   (KErrNone != securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KDefaultPolicy))
sl@0: 	   ||
sl@0: 	   (KErrNone != securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EReadPolicy, KDefaultPolicy)))
sl@0: 		{
sl@0: 		return KErrGeneral;
sl@0: 		}
sl@0: 		
sl@0: 	return KErrNone;
sl@0: 	}
sl@0: 	
sl@0: void SetupTestEnv()
sl@0:     {
sl@0: 	TInt err = TheFs.Connect();
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	err = TheFs.MkDir(KTestDir);
sl@0: 	TEST(err == KErrNone || err == KErrAlreadyExists);
sl@0: 
sl@0: 	err = TheFs.CreatePrivatePath(EDriveC);
sl@0: 	TEST(err == KErrNone || err == KErrAlreadyExists);
sl@0: 
sl@0: 	(void)TheFs.Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: // Parameter check functions
sl@0: 
sl@0: TInt DoGetConfigParamValueL(RSqlDatabase& aDb, TConfigParamType aPrmType)
sl@0: 	{
sl@0: 	TSqlScalarFullSelectQuery q(aDb);
sl@0: 	TInt res = 0;
sl@0: 	switch(aPrmType)
sl@0: 		{
sl@0: 		case EPrmCacheSize:
sl@0: 			res = q.SelectIntL(_L8("PRAGMA cache_size"));
sl@0: 			break;
sl@0: 		case EPrmPageSize:
sl@0: 			res = q.SelectIntL(_L8("PRAGMA page_size"));
sl@0: 			break;
sl@0: 		case EPrmDbEncoding:
sl@0: 			{
sl@0: 			TBuf<20> dbEncodingText;
sl@0: 			res = q.SelectTextL(_L8("PRAGMA encoding"), dbEncodingText);
sl@0: 			TEST2(res, KErrNone);
sl@0: 			if(dbEncodingText.FindF(_L("UTF-16")) >= 0)
sl@0: 				{
sl@0: 				res = TSqlSrvConfigParams::EEncUtf16;	
sl@0: 				}
sl@0: 			else if(dbEncodingText.FindF(_L("UTF-8")) >= 0)
sl@0: 				{
sl@0: 				res = TSqlSrvConfigParams::EEncUtf8;	
sl@0: 				}
sl@0: 			else
sl@0: 				{
sl@0: 				TEST2(0, 1);
sl@0: 				}
sl@0: 			}
sl@0: 			break;
sl@0: 		default:
sl@0: 			TEST2(0, 1);
sl@0: 			break;
sl@0: 		}
sl@0: 	return res;
sl@0: 	}
sl@0: 
sl@0: TInt GetConfigParamValue(RSqlDatabase& aDb, TConfigParamType aPrmType)
sl@0: 	{
sl@0: 	TInt res = 0;
sl@0: 	TRAPD(err, res = DoGetConfigParamValueL(aDb, aPrmType));
sl@0: 	TEST2(err, KErrNone);
sl@0: 	return res;
sl@0: 	}
sl@0: 
sl@0: void AssertConfigPrmValues(RSqlDatabase& aDb, TInt aExpectedCacheSize, TInt aExpectedPageSize, TInt aExpectedDbEncoding)
sl@0: 	{
sl@0: 	TInt cacheSize = GetConfigParamValue(aDb, EPrmCacheSize);
sl@0: 	TInt pageSize = GetConfigParamValue(aDb, EPrmPageSize);
sl@0: 	TInt dbEncoding = GetConfigParamValue(aDb, EPrmDbEncoding);
sl@0: 	TEST2(cacheSize, aExpectedCacheSize);
sl@0: 	TEST2(pageSize, aExpectedPageSize);
sl@0: 	TEST2(dbEncoding, aExpectedDbEncoding);
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: // Config file replacement functions
sl@0: 
sl@0: // File config strings are 16-bit.
sl@0: void ReplaceConfigFile(const TDesC16& aConfig)
sl@0: 	{
sl@0: 	(void)KillProcess(KSqlSrvName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	RFile file;
sl@0: 	TInt err = file.Create(TheFs, KSqlSrvConfigFile, EFileRead | EFileWrite);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TPtrC8 p((const TUint8*)aConfig.Ptr(), aConfig.Length() * sizeof(TUint16));
sl@0: 	err = file.Write(p);
sl@0: 	file.Close();
sl@0: 	TEST2(err, KErrNone);
sl@0: 	}
sl@0: 	
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: //
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3603
sl@0: @SYMTestCaseDesc		Bad config file test
sl@0: 						The test creates bad config files like:
sl@0: 							- empty config file;
sl@0: 							- "\n" config file;
sl@0: 							- "\r\n" config file;
sl@0: 							- config file with comment lines only;
sl@0: 						Then the test restarts the SQL server and checks that the bad config file is detected and 
sl@0: 						appropriate error code - returned to the caller (during "database create" operation).
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Bad config file test
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0: */
sl@0: void BadCfgFileTest()
sl@0: 	{
sl@0: 	//Empty config file	
sl@0: 	ReplaceConfigFile(_L(""));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrEof);//BC kept - an empty config file is treated as invalid
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"\n" config file	
sl@0: 	ReplaceConfigFile(_L("\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrEof);//BC compatible
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"\r\n" config file	
sl@0: 	ReplaceConfigFile(_L("\r\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrEof);//BC compatible
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"        \r\n" config file	
sl@0: 	ReplaceConfigFile(_L("        \r\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrEof);//BC compatible
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"  # \r\n" config file
sl@0: 	ReplaceConfigFile(_L("  # \r\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrEof);//BC compatible
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"  # \r\na=b\r\n" config file
sl@0: 	ReplaceConfigFile(_L("  # \r\na=b\r\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"  # \r\n   a=b   \r\n" config file
sl@0: 	ReplaceConfigFile(_L("  # \r\n   a=b   \r\n"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"  # \r\n   a=b  " config file
sl@0: 	ReplaceConfigFile(_L("  # \r\n   a=b  "));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3604
sl@0: @SYMTestCaseDesc		Config file with bad parameters test
sl@0: 						The test creates config files with bad parameters like:
sl@0: 							- negative cache size;
sl@0: 							- non-numeric cache size value;
sl@0: 							- empty cache size value;
sl@0: 							- negative page size;
sl@0: 							- non-numeric page size value;
sl@0: 							- empty page size value;
sl@0: 							- negative soft heap limit size;
sl@0: 							- non-numeric soft heap limit value;
sl@0: 							- empty soft heap limit value;
sl@0: 							- too small soft heap limit value;
sl@0: 							- too big soft heap limit value;
sl@0: 							- negative free page threshold value;
sl@0: 							- empty free page threshold value;
sl@0: 							- non-numeric free page threshold value;
sl@0: 						Then the test restarts the SQL server and checks that the bad config file is detected and 
sl@0: 						appropriate error code - returned to the caller (during "database create" operation).
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Config file with bad parameters test
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0:                         REQ10271
sl@0: */
sl@0: void BadCfgFileParametersTest()
sl@0: 	{
sl@0: 	/////////////// cache_size  ////////////////
sl@0: 	//"cache_size=-20;" config file
sl@0: 	ReplaceConfigFile(_L("cache_size=-20;"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"cache_size=456.90" config file
sl@0: 	ReplaceConfigFile(_L("cache_size=456.90"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"cache_size='dfjkhdfjk';" config file
sl@0: 	ReplaceConfigFile(_L("cache_size='dfjkhdfjk';"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"cache_size=;" config file
sl@0: 	ReplaceConfigFile(_L("cache_size=;"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	/////////////// page_size  ////////////////
sl@0: 	//"page_size=-55" config file
sl@0: 	ReplaceConfigFile(_L("page_size=-55"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"page_size=25.89" config file
sl@0: 	ReplaceConfigFile(_L("page_size=25.89"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);//BC compatible
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"page_size=gffgrtj" config file
sl@0: 	ReplaceConfigFile(_L("page_size=gffgrtj"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"page_size=" config file
sl@0: 	ReplaceConfigFile(_L("page_size="));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	////////   soft_heap_limit_kb    ///////////
sl@0: 	//"soft_heap_limit_kb=-10" config file
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=-10"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=5" config file (bellow min limit - 8Kb when SYSLIBS_TEST macro is defined)
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=5"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=8" config file (the min limit - 8Kb when SYSLIBS_TEST macro is defined)
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=8"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=2000000000" config file (above max limit)
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=2000000000"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=KMaxTInt/1024" config file (the max limit)
sl@0: 	TBuf<32> configBuf;
sl@0: 	configBuf.Copy(_L("soft_heap_limit_kb="));
sl@0: 	TInt maxSoftHeapLimit = KMaxTInt / 1024;
sl@0: 	configBuf.AppendNum(maxSoftHeapLimit);
sl@0: 	ReplaceConfigFile(configBuf);
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=sdfcvyua" config file
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=sdfcvyua"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=" config file
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb="));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=1023.456" config file
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=1023.456"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	////////   free_space_threshold_kb    ///////////
sl@0: 	//"free_space_threshold_kb=-10" config file
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb=-10"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"free_space_threshold_kb=0" config file
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb=0"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"free_space_threshold_kb=" config file
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb="));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"free_space_threshold_kb=34.56" config file
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb=34.56"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"free_space_threshold_kb=gfghfg" config file
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb=gfghfg"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	/////////////////////////////////////////////
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3605
sl@0: @SYMTestCaseDesc		Config parameters conflict test.
sl@0: 						1) The test creates a database with cache size parameter value specified in both the config file and the
sl@0: 							config string. The expectation is that the config string parameter will be used.
sl@0: 						2) The test creates a database with page size parameter value specified in both the config file and the
sl@0: 							config string. The expectation is that the config string parameter will be used.
sl@0: 						3) The test creates a database with encoding parameter value specified in both the config file and the
sl@0: 							config string. The expectation is that the config string parameter will be used.
sl@0: 						4) The test creates a database with soft heap limit value specified in both the config file and the
sl@0: 							config string. The expectation is that the database creation will fail (the soft heap limit
sl@0: 							cannot be configured using a config string).
sl@0: 						5) The test creates a database with free page threshold value specified in both the config file and the
sl@0: 							config string. The expectation is that the database creation will succeeds. The free page threshold
sl@0: 							value from the config file will be used.
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Config parameters conflict test
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0:                         REQ10271
sl@0: */
sl@0: void CfgFileConflictTest()
sl@0: 	{
sl@0: 	//"cache_size=200" config file
sl@0: 	//"cache_size=100" client config string
sl@0: 	ReplaceConfigFile(_L("cache_size=200"));
sl@0: 	_LIT8(KConfigStr1, "cache_size=100");
sl@0: 	TInt err = TheDb.Create(KTestDbName, &KConfigStr1);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, 100, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"page_size=512" config file
sl@0: 	//"page_size=8192" client config string
sl@0: 	ReplaceConfigFile(_L("page_size=512"));
sl@0: 	_LIT8(KConfigStr2, "page_size=8192");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr2);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (TSqlSrvConfigParams::KDefaultSoftHeapLimitKb * 1024) / 8192, 8192, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"encoding=UTF-16" config file
sl@0: 	//"encoding=UTF-8" client config string
sl@0: 	ReplaceConfigFile(_L("encoding=UTF-16"));
sl@0: 	_LIT8(KConfigStr3, "encoding=UTF-8");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr3);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, KDefaultCacheSize, KDefaultPageSize, TSqlSrvConfigParams::EEncUtf8);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=900" config file
sl@0: 	//"soft_heap_limit_kb=800" client config string
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=900"));
sl@0: 	_LIT8(KConfigStr4, "soft_heap_limit_kb=800");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr4);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"free_space_threshold_kb=100" config file
sl@0: 	//"free_space_threshold_kb=200" client config string
sl@0: 	ReplaceConfigFile(_L("free_space_threshold_kb=100"));
sl@0: 	_LIT8(KConfigStr5, "free_space_threshold_kb=200");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr5);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3606
sl@0: @SYMTestCaseDesc		Soft Heap Limit - functional test.
sl@0: 						The test attempts to create a database with the soft heap limit value specified in the config file
sl@0: 						and different combinations of the page size and cache size parameters in both config file and client
sl@0: 						config string. The expectation is that when the cache size parameter value is not specified explicitly
sl@0: 						in the config file or in the config string, the cache size value will be calculated, using the soft
sl@0: 						heap limit and the database page size.
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Soft Heap Limit - functional test.
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0: */
sl@0: void SoftHeapLimitFunctionalTest1()
sl@0: 	{
sl@0: 	///////////////////// CREATE DATABASE /////////////////////////////////////////////////////////
sl@0: 	//"soft_heap_limit_kb=512" config file. (512 is the min soft heap limit value)
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/page_size;
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / KDefaultPageSize, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=KMaxTInt/1024" config file. (KMaxTInt / 1024 is the max soft heap limit value)
sl@0: 	//Expected result: the database cache size will be KMaxTInt/page_size;
sl@0: 	TBuf<32> configBuf;
sl@0: 	configBuf.Copy(_L("soft_heap_limit_kb="));
sl@0: 	TInt maxSoftHeapLimit = KMaxTInt / 1024;
sl@0: 	configBuf.AppendNum(maxSoftHeapLimit);
sl@0: 	ReplaceConfigFile(configBuf);
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, KMaxTInt / KDefaultPageSize, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512;page_size=2048" config file.
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/2048. The page size value from the config file is used.
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512;page_size=2048"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / 2048, 2048, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512" config file.
sl@0: 	//"page_size=4096" client config string.
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/4096. The page size value from the client config string is used.
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512;"));
sl@0: 	_LIT8(KConfigStr1, "page_size=4096");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr1);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / 4096, 4096, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512;page_size=8192" config file.
sl@0: 	//"page_size=2048" client config string.
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/2048. The page size value from the client config string is used.
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512;page_size=8192"));
sl@0: 	_LIT8(KConfigStr2, "page_size=2048");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr2);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / 2048, 2048, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512;page_size=2048;encoding=UTF-8" config file.
sl@0: 	//"cache_size=100" client config string.
sl@0: 	//Expected result: the database cache size will be 100. The soft heap limit is not used for the cache size calculation.
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512;page_size=2048;encoding=UTF-8"));
sl@0: 	_LIT8(KConfigStr3, "cache_size=100");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr3);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, 100, 2048, TSqlSrvConfigParams::EEncUtf8);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3607
sl@0: @SYMTestCaseDesc		Soft Heap Limit - functional test.
sl@0: 						The test attempts to open a database with the soft heap limit value specified in the config file
sl@0: 						and different combinations of the page size and cache size parameters in both config file and client
sl@0: 						config string. The expectation is that when the cache size parameter value is not specified explicitly
sl@0: 						in the config file or in the config string, the cache size value will be calculated, using the soft
sl@0: 						heap limit and the database page size (read from the database, not from the config file or string).
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Soft Heap Limit - functional test.
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0: */
sl@0: void SoftHeapLimitFunctionalTest2()
sl@0: 	{
sl@0: 	///////////////////// OPEN DATABASE /////////////////////////////////////////////////////////
sl@0: 	//"soft_heap_limit_kb=512;page_size=2048" config file.
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/2048. The database page size value is used (not the built-time one).
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512;page_size=2048"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / 2048, 2048, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=1024;page_size=8192"));
sl@0: 	err = TheDb.Open(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (1024 * 1024) / 2048, 2048, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512" config file.
sl@0: 	//"page_size=4096" client config string.
sl@0: 	//Expected result: the database cache size will be (512 * 1024)/4096. The database page size value is used (not the built-time one).
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512"));
sl@0: 	_LIT8(KConfigStr1, "page_size=4096");
sl@0: 	err = TheDb.Create(KTestDbName, &KConfigStr1);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (512 * 1024) / 4096, 4096, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=1024;page_size=8192"));
sl@0: 	err = TheDb.Open(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (1024 * 1024) / 4096, 4096, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	//"soft_heap_limit_kb=512" config file.
sl@0: 	//"page_size=4096" client config string when openning the database.
sl@0: 	//Expected result: the database cache size will be 512. The database page size value is used (the built-time one).
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=512"));
sl@0: 	err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, 512, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=1024;page_size=512"));
sl@0: 	_LIT8(KConfigStr2, "page_size=4096");
sl@0: 	err = TheDb.Open(KTestDbName, &KConfigStr2);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, 1024, KDefaultPageSize, KDefaultEncoding);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3608
sl@0: @SYMTestCaseDesc		Soft Heap Limit - file I/O failure simulation test.
sl@0: 						The test creates a database with very small soft heap limit value (8Kb).
sl@0: 						Then the test attempts to insert a record in an explicit transaction while doing
sl@0: 						file I/O failure simulation.
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Soft Heap Limit - file I/O failure simulation test.
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0:                         REQ10271
sl@0: */
sl@0: void FileIOFailureTest()
sl@0: 	{
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=8;cache_size=16;page_size=512;free_space_threshold_kb=100"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.Exec(_L("CREATE TABLE A(Id INTEGER,Name TEXT)"));
sl@0: 	TEST(err >= 0);
sl@0: 	TheDb.Close();
sl@0: 	err = -1;
sl@0: 	const TInt KTestRecCnt = 100;
sl@0: 	for(TInt cnt=0;err<KErrNone;++cnt)
sl@0: 		{		
sl@0: 		TheTest.Printf(_L("%d \r"), cnt);		
sl@0: 		err = TheDb.Open(KTestDbName);
sl@0: 		TEST2(err, KErrNone);
sl@0: 		TInt recCntBegin = 0;
sl@0: 		TSqlScalarFullSelectQuery q1(TheDb);
sl@0: 		TRAP(err, recCntBegin = q1.SelectIntL(_L("SELECT COUNT (*) FROM A")));
sl@0: 		TEST2(err, KErrNone);
sl@0: 		(void)TheFs.SetErrorCondition(KErrGeneral, cnt);
sl@0: 		err = TheDb.Exec(_L("BEGIN TRANSACTION"));
sl@0: 		if(err == KErrNone)
sl@0: 			{
sl@0: 			for(TInt i=0;i<KTestRecCnt;++i)
sl@0: 				{
sl@0: 				TBuf<300> sql;
sl@0: 				sql.Format(_L("INSERT INTO A(Id,Name) VALUES(%d, 'A1234567890B1234567890C1234567890D1234567890E1234567890F1234567890G1234567890H1234567890I1234567890J1234567890K1234567890L1234567890M1234567890N1234567890O1234567890P1234567890Q1234567890R1234567890')"), cnt);
sl@0: 				err = TheDb.Exec(sql);
sl@0: 				TEST(err == 1 || err < 0);
sl@0: 				if(err < 0)
sl@0: 					{
sl@0: 					break;
sl@0: 					}
sl@0: 				}
sl@0: 			if(err == 1)
sl@0: 				{
sl@0: 				err = TheDb.Exec(_L("COMMIT TRANSACTION"));
sl@0: 				}
sl@0: 			else if(TheDb.InTransaction()) //the transaction may have been rolled back automatically
sl@0: 				{
sl@0: 				err = TheDb.Exec(_L("ROLLBACK TRANSACTION"));
sl@0: 				}
sl@0: 			if(err == 0)
sl@0: 				{
sl@0: 				err = 1;	
sl@0: 				}
sl@0: 			}
sl@0: 		(void)TheFs.SetErrorCondition(KErrNone);
sl@0: 		if(err < 1)
sl@0: 			{
sl@0: 			TheDb.Close();//close the database to recover from the last error
sl@0: 			TInt err2 = TheDb.Open(KTestDbName);
sl@0: 			TEST2(err2, KErrNone);
sl@0: 			}
sl@0: 		TSqlScalarFullSelectQuery q2(TheDb);
sl@0: 		TInt recCntEnd = 0;
sl@0: 		TRAPD(err3, recCntEnd = q2.SelectIntL(_L("SELECT COUNT (*) FROM A")));
sl@0: 		TheDb.Close();
sl@0: 		TEST2(err3, KErrNone);
sl@0: 		//check the database content - all bets are off in a case of an I/O error. 
sl@0: 		//The new records may have actually been inserted.
sl@0: 		TEST(recCntEnd == recCntBegin || recCntEnd == (recCntBegin + KTestRecCnt));
sl@0: 		}
sl@0: 	(void)TheFs.SetErrorCondition(KErrNone);
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-3609
sl@0: @SYMTestCaseDesc		Soft Heap Limit - OOM test.
sl@0: 						The test creates a database with very small soft heap limit value (8Kb).
sl@0: 						The the test attempts to insert a record in an explicit transaction while doing
sl@0: 						OOM simulation.
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			Soft Heap Limit - OOM test.
sl@0: @SYMTestExpectedResults The test must not fail
sl@0: @SYMREQ					REQ8162
sl@0:                         REQ10271
sl@0: */
sl@0: void OOMtest()
sl@0: 	{
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	ReplaceConfigFile(_L("soft_heap_limit_kb=8;cache_size=16;page_size=512;free_space_threshold_kb=150"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.Exec(_L("CREATE TABLE A(Id INTEGER,Name TEXT)"));
sl@0: 	TEST(err >= 0);
sl@0: 	TheDb.Close();
sl@0: 
sl@0: 	const TInt KOomIterationCount = 1000;//Instead fo doing the OOM test while "err == KErrNoMemory", the test is
sl@0: 										 //performed KOomIterationCount times, because the "soft heap limit" will
sl@0: 										 //force the SQLite library to reuse some of the already allocated but not used pages.
sl@0: 	TInt failingAllocationNo = 0;
sl@0: 	while(failingAllocationNo < KOomIterationCount)
sl@0: 		{
sl@0: 		__UHEAP_MARK;
sl@0: 
sl@0: 		const TInt KDelayedDbHeapFailureMask = 0x1000;
sl@0: 		TSqlResourceTester::SetDbHeapFailure(RHeap::EFailNext | KDelayedDbHeapFailureMask, ++failingAllocationNo);
sl@0: 
sl@0: 		err = TheDb.Open(KTestDbName);
sl@0: 		TEST2(err, KErrNone);
sl@0: 
sl@0: 		err = TheDb.Exec(_L("BEGIN TRANSACTION"));
sl@0: 		if(err == KErrNone)
sl@0: 			{
sl@0: 			const TInt KTestRecCnt = 4;
sl@0: 			for(TInt i=0;i<KTestRecCnt;++i)
sl@0: 				{
sl@0: 				err = TheDb.Exec(_L("INSERT INTO A(Id,Name) VALUES(1, 'A1234567890B1234567890C1234567890D1234567890E1234567890F1234567890G1234567890H1234567890I1234567890J1234567890K1234567890L1234567890M1234567890N1234567890O1234567890P1234567890Q1234567890R1234567890')"));
sl@0: 				if(err < 1)
sl@0: 					{
sl@0: 					break;
sl@0: 					}
sl@0: 				}
sl@0: 			if(err == 1)
sl@0: 				{
sl@0: 				err = TheDb.Exec(_L("COMMIT TRANSACTION"));
sl@0: 				}
sl@0: 			else if(TheDb.InTransaction()) //the transaction may have been rolled back automatically
sl@0: 				{
sl@0: 				err = TheDb.Exec(_L("ROLLBACK TRANSACTION"));
sl@0: 				}
sl@0: 			}
sl@0: 		
sl@0: 		TSqlResourceTester::SetDbHeapFailure(RHeap::ENone, 0);
sl@0: 	
sl@0: 		TheDb.Close();	
sl@0: 
sl@0: 		TheTest.Printf(_L("%d/%d   \r"), failingAllocationNo, err);
sl@0: 		
sl@0: 		__UHEAP_MARKEND;
sl@0: 		
sl@0: 		TEST(err >= 0 || err == KErrNoMemory);
sl@0: 		}
sl@0: 	TEST(err >= 0);
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-4081
sl@0: @SYMTestCaseDesc		Background compaction, free page threshold - functional test.
sl@0: 						The test creates a server config file, where the free page threshold is set to be 20 Kb.
sl@0: 						Then the test creates a database. The test inserts 40 pages (40 Kb) into the database, closes and 
sl@0: 						reopens the database. Then the test deletes some records from the database.
sl@0: 						But the space in the free pages is not big enough to kick-off the background compaction.
sl@0: 						The test checks that no compaction has occurred after the deletions.
sl@0: 						The test deletes more records and the free page threshold is reached.
sl@0: 						The test checks that after the last deletion the database really has been compacted.
sl@0: @SYMTestPriority		Medium
sl@0: @SYMTestActions			Background compaction, free page threshold - functional test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ10271
sl@0: */
sl@0: void FreePageThresholdTest()
sl@0: 	{
sl@0: 	const TInt KFreePageThresholdSrvCfgKb = 20;
sl@0: 	TBuf<50> cfgBuf1;
sl@0: 	cfgBuf1.Format(_L("free_space_threshold_kb=%d"), KFreePageThresholdSrvCfgKb);
sl@0: 	ReplaceConfigFile(cfgBuf1);
sl@0: 	
sl@0: 	const TInt KPageSize = 1024;
sl@0: 	TBuf8<50> cfgBuf2;
sl@0: 	cfgBuf2.Format(_L8("page_size=%d;"), KPageSize);
sl@0: 	//Create a database and insert some records. At the end the database size is bigger than the free pages threshold.
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	TInt err = TheDb.Create(KTestDbName, &cfgBuf2);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.Exec(_L("CREATE TABLE A(B BLOB)"));
sl@0: 	TEST2(err, 1);
sl@0: 	TBuf8<(KPageSize - 150) * 2> blob;
sl@0: 	blob.SetLength((KPageSize - 150) * 2);
sl@0: 	blob.Fill(TChar('A'));
sl@0: 	for(TInt i=0;i<KFreePageThresholdSrvCfgKb*2;++i)
sl@0: 		{
sl@0: 		TBuf8<KPageSize * 2> sql;
sl@0: 		sql.Format(_L8("INSERT INTO A VALUES(x'%S')"), &blob);
sl@0: 		err = TheDb.Exec(sql);
sl@0: 		TEST2(err, 1);
sl@0: 		}
sl@0: 	TheDb.Close();
sl@0: 	//Reopen the database and delete some records. The free spave is not big enough to kick-off the background compaction.
sl@0: 	err = TheDb.Open(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	for(TInt i=0;i<10;++i)
sl@0: 		{
sl@0: 		TBuf8<50> sql;
sl@0: 		sql.Format(_L8("DELETE FROM A WHERE ROWID=%d"), i + 1);
sl@0: 		err = TheDb.Exec(sql);
sl@0: 		TEST2(err, 1);
sl@0: 		}
sl@0: 	User::After(1000000);
sl@0: 	RSqlDatabase::TSize size;
sl@0: 	err = TheDb.Size(size);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TEST(size.iFree > 0);
sl@0: 	//Delete more records, the free page threshold is reached, the background compaction - kicked-off.
sl@0: 	for(TInt i=10;i<20;++i)
sl@0: 		{
sl@0: 		TBuf8<50> sql;
sl@0: 		sql.Format(_L8("DELETE FROM A WHERE ROWID=%d"), i + 1);
sl@0: 		err = TheDb.Exec(sql);
sl@0: 		TEST2(err, 1);
sl@0: 		}
sl@0: 	User::After(1000000);
sl@0: 	err = TheDb.Size(size);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TEST2(size.iFree, 0);
sl@0: 	//
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	(void)TheFs.Delete(KSqlSrvConfigFile);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-UT-4075
sl@0: @SYMTestCaseDesc		Server configuration file, large string test.
sl@0: 						The test creates a server config file, where all parameters are used
sl@0: 						and checks the the parameter values are processed normally.
sl@0: @SYMTestPriority		Medium
sl@0: @SYMTestActions			Server configuration file, large string test.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ10271
sl@0: */
sl@0: void LargeStringTest()
sl@0: 	{
sl@0: 	ReplaceConfigFile(_L("page_size=32768;cache_size=2048;encoding=UTF-16;soft_heap_limit_kb=2048;free_space_threshold_kb=100000000;compaction=background"));
sl@0: 	TInt err = TheDb.Create(KTestDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	AssertConfigPrmValues(TheDb, (2048 * 1024) / 32768, 32768, TSqlSrvConfigParams::EEncUtf16);
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDbName);
sl@0: 	}
sl@0: 
sl@0: void DoTests()
sl@0: 	{
sl@0: 	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3603 Bad config file "));
sl@0: 	BadCfgFileTest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3604 Config file - bad parameters "));
sl@0: 	BadCfgFileParametersTest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3605 Config file - conflict test "));
sl@0: 	CfgFileConflictTest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3606 Soft heap limit - functional test (\"create database\") "));
sl@0:  	SoftHeapLimitFunctionalTest1();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3607 Soft heap limit - functional test (\"open database\") "));
sl@0:  	SoftHeapLimitFunctionalTest2();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3608 Soft heap limit - file I/O failure "));
sl@0:     FileIOFailureTest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-3609 Soft heap limit - OOM failure "));
sl@0: 	OOMtest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-4081 SQL server configuration file + free page threshold - functional test "));
sl@0:  	FreePageThresholdTest();
sl@0:  	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-UT-4075 SQL server configuration file + large string "));
sl@0:  	LargeStringTest();
sl@0: 	}
sl@0: 	
sl@0: #endif	//SYSLIBS_TEST
sl@0: 
sl@0: TInt E32Main()
sl@0: 	{
sl@0: 	TheTest.Title();
sl@0: 	
sl@0: 	CTrapCleanup* tc = CTrapCleanup::New();
sl@0: 	TheTest(tc != NULL);
sl@0: 	
sl@0: 	__UHEAP_MARK;
sl@0: 
sl@0: #ifdef SYSLIBS_TEST	
sl@0: 	TheTest.Start(_L("t_sqlconfigfile tests"));
sl@0: 
sl@0: 	SetupTestEnv();
sl@0: 	DoTests();
sl@0:  	DestroyTestEnv();
sl@0: 	
sl@0: 	TheTest.End();
sl@0: #else
sl@0:  	TheTest.Start(_L("This test works only if the whole SQL component is built with SYSLIBS_TEST macro defined!"));
sl@0: 	TheTest.End();
sl@0: #endif	
sl@0: 	
sl@0: 	__UHEAP_MARKEND;
sl@0: 	
sl@0: 	TheTest.Close();
sl@0: 	
sl@0: 	delete tc;
sl@0: 	
sl@0: 	User::Heap().Check();
sl@0: 	return KErrNone;
sl@0: 	}