sl@0: // Copyright (c) 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 <bautils.h>
sl@0: #include "SqlSrvMain.h"
sl@0: #include "SqlSrvStartup.h"
sl@0: #include "SqlSrvUtil.h"
sl@0: #include "SqlSrvDatabase.h"
sl@0: #include "SqlSrvFileData.h"
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: RTest TheTest(_L("t_sqloom5 test"));
sl@0: RFs TheFs;
sl@0: 
sl@0: _LIT(KTestDir, "c:\\test\\");
sl@0: _LIT(KDbFile, "c:\\test\\t_sqloom5.db");
sl@0: _LIT(KDbFile2, "c:[10281E17]t_sqloom5.db");
sl@0: _LIT(KDbFile3, "c:[10281E17]t_sqloom5_2.db");
sl@0: _LIT(KDbFile4, "c:[10281E17]t_sqloom5_3.db");
sl@0: 
sl@0: _LIT8(KConfig, "encoding=UTF-8");
sl@0: 
sl@0: extern CSqlServer* TheServer;
sl@0: 
sl@0: static TInt TheProcessHandleCount = 0;
sl@0: static TInt TheThreadHandleCount = 0;
sl@0: static TInt TheAllocatedCellsCount = 0;
sl@0: 
sl@0: #ifdef _DEBUG
sl@0: static const TInt KBurstRate = 20;
sl@0: #endif
sl@0: 
sl@0: enum TSqlDbEncoding
sl@0:     {
sl@0:     ESqlDbUtf16,
sl@0:     ESqlDbUtf8
sl@0:     };
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: void DestroyTestEnv()
sl@0: 	{
sl@0:     (void)TheFs.Delete(KDbFile4);
sl@0:     (void)TheFs.Delete(KDbFile3);
sl@0:     (void)TheFs.Delete(KDbFile2);
sl@0:     (void)TheFs.Delete(KDbFile);
sl@0: 	TheFs.Close();
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: //Test macros and functions
sl@0: void Check(TInt aValue, TInt aLine)
sl@0: 	{
sl@0: 	if(!aValue)
sl@0: 		{
sl@0: 		DestroyTestEnv();
sl@0: 		RDebug::Print(_L("*** Expresssion evaluated to false\r\n"));
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: ////////////////////////////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: static void MarkHandles()
sl@0:     {
sl@0:     RThread().HandleCount(TheProcessHandleCount, TheThreadHandleCount);
sl@0:     }
sl@0: 
sl@0: static void MarkAllocatedCells()
sl@0:     {
sl@0:     TheAllocatedCellsCount = User::CountAllocCells();
sl@0:     }
sl@0: 
sl@0: static void CheckAllocatedCells()
sl@0:     {
sl@0:     TInt allocatedCellsCount = User::CountAllocCells();
sl@0:     TEST2(allocatedCellsCount, TheAllocatedCellsCount);
sl@0:     }
sl@0: 
sl@0: static void CheckHandles()
sl@0:     {
sl@0:     TInt endProcessHandleCount;
sl@0:     TInt endThreadHandleCount;
sl@0:     
sl@0:     RThread().HandleCount(endProcessHandleCount, endThreadHandleCount);
sl@0: 
sl@0:     TEST2(TheProcessHandleCount, endProcessHandleCount);
sl@0:     TEST2(TheThreadHandleCount, endThreadHandleCount);
sl@0:     }
sl@0: 
sl@0: static void OomPreStep(TInt
sl@0:                         #ifdef _DEBUG        
sl@0:                             aFailingAllocationNo
sl@0:                         #endif
sl@0:                       )
sl@0:     {
sl@0:     MarkHandles();
sl@0:     MarkAllocatedCells();
sl@0:     __UHEAP_MARK;
sl@0:     __UHEAP_SETBURSTFAIL(RAllocator::EBurstFailNext, aFailingAllocationNo, KBurstRate);
sl@0:     }
sl@0: 
sl@0: static void OomPostStep()
sl@0:     {
sl@0:     __UHEAP_RESET;
sl@0:     __UHEAP_MARKEND;
sl@0:     CheckAllocatedCells();
sl@0:     CheckHandles();
sl@0:     }
sl@0: 
sl@0: ////////////////////////////////////////////////////////////////////////////////////////////////////////////
sl@0: ////////////////////////////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: void CreateTestEnv()
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: 
sl@0: static CSqlServer* CreateSqlServerL()
sl@0:     {
sl@0:     CSqlServer* server = CSqlServer::NewLC();
sl@0:     CleanupStack::Pop(server);
sl@0:     return server;
sl@0:     }
sl@0: 
sl@0: void CreateDatabaseOomTest(TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     (void)TheFs.Delete(KDbFile);
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         RMessage2 msg;
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile().Length(), 0, KDbFile, aEncoding == ESqlDbUtf8 ? &KConfig : NULL));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             CSqlSrvDatabase* db = NULL;
sl@0:             TRAP(err, db = CSqlSrvDatabase::CreateL(fdata));
sl@0:             delete db;
sl@0:             }
sl@0:         OomPostStep();
sl@0:         }
sl@0: 
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:     
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::CreateL() OOM test succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4167
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::CreateL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::CreateL() in an OOM loop.
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577
sl@0: */  
sl@0: void Utf16CreateDatabaseOomTest()
sl@0:     {
sl@0:     CreateDatabaseOomTest(ESqlDbUtf16);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4182
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::CreateL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::CreateL() in an OOM loop.
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8CreateDatabaseOomTest()
sl@0:     {
sl@0:     CreateDatabaseOomTest(ESqlDbUtf8);
sl@0:     }
sl@0: 
sl@0: void OpenDatabaseOomTest()
sl@0:     {
sl@0:     //The database is created by the previous test: CreateDatabaseOomTest().
sl@0:     
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         RMessage2 msg;
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile().Length(), 0, KDbFile));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             CSqlSrvDatabase* db = NULL;
sl@0:             TRAP(err, db = CSqlSrvDatabase::OpenL(fdata));
sl@0:             delete db;
sl@0:             }
sl@0:         
sl@0:         OomPostStep();
sl@0:         }
sl@0:     
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:     
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::OpenL() [non-secure db] OOM test succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4168
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() OOM test - non-secure database.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577
sl@0: */  
sl@0: void Utf16OpenDatabaseOomTest()
sl@0:     {
sl@0:     OpenDatabaseOomTest();
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4183
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() OOM test - non-secure database.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8OpenDatabaseOomTest()
sl@0:     {
sl@0:     OpenDatabaseOomTest();
sl@0:     }
sl@0: 
sl@0: void CreateSecureDatabaseOomTest(TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     (void)TheFs.Delete(KDbFile2);
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:         
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         RMessage2 msg;
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile2().Length(), 0, KDbFile2, aEncoding == ESqlDbUtf8 ? &KConfig : NULL));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             TSecurityPolicy defaultPolicy(TSecurityPolicy::EAlwaysPass);
sl@0:             CSqlSecurityPolicy* policy = NULL;
sl@0:             TRAP(err, policy = CSqlSecurityPolicy::NewL(defaultPolicy));
sl@0:             if(err == KErrNone)
sl@0:                 {
sl@0:                 CSqlSrvDatabase* db = NULL;
sl@0:                 TRAP(err, db = CSqlSrvDatabase::CreateSecureL(fdata, policy));
sl@0:                 delete db;
sl@0:                 }
sl@0:             }
sl@0:         OomPostStep();
sl@0:         }
sl@0: 
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:     
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::CreateSecureL() OOM test succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4169
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::CreateSecureL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::CreateSecureL() in an OOM loop.
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577
sl@0: */  
sl@0: void Utf16CreateSecureDatabaseOomTest()
sl@0:     {
sl@0:     CreateSecureDatabaseOomTest(ESqlDbUtf16);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4184
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::CreateSecureL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::CreateSecureL() in an OOM loop.
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8CreateSecureDatabaseOomTest()
sl@0:     {
sl@0:     CreateSecureDatabaseOomTest(ESqlDbUtf8);
sl@0:     }
sl@0: 
sl@0: void OpenSecureDatabaseOomTest()
sl@0:     {
sl@0:     //The database is created by the previous test: CreateSecureDatabaseOomTest().
sl@0:     
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         RMessage2 msg;
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile2().Length(), 0, KDbFile2));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             CSqlSrvDatabase* db = NULL;
sl@0:             TRAP(err, db = CSqlSrvDatabase::OpenL(fdata));
sl@0:             delete db;
sl@0:             }
sl@0:         
sl@0:         OomPostStep();
sl@0:         }
sl@0:     
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:     
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::OpenL() [secure db] OOM test succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4170
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() OOM test - secure database.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577, PDEF44845
sl@0: */  
sl@0: void Utf16OpenSecureDatabaseOomTest()
sl@0:     {
sl@0:     OpenSecureDatabaseOomTest();
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4185
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() OOM test - secure database.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8OpenSecureDatabaseOomTest()
sl@0:     {
sl@0:     OpenSecureDatabaseOomTest();
sl@0:     }
sl@0: 
sl@0: /////////////////////////////////////////////////////////////
sl@0: 
sl@0: const TInt KDbConnCount = 7; 
sl@0: #ifdef _DEBUG
sl@0: const TInt KDbAttachedCount = 10;
sl@0: #endif
sl@0: TBuf<10> TheAttachedDbName;
sl@0: 
sl@0: //Declares KDbConnCount "CSqlSrvDatabase*" variables.  
sl@0: #define TEST_DECLARE_DB_VARS() \
sl@0:     CSqlSrvDatabase* db[KDbConnCount]; \
sl@0:     Mem::FillZ(db, sizeof(db));
sl@0: 
sl@0: //Declares all KDbConnCount "CSqlSrvDatabase*" objects.  
sl@0: #define TEST_DELETE_DB() \
sl@0:     for(TInt i=0;i<KDbConnCount;++i) \
sl@0:         { \
sl@0:         delete db[i]; \
sl@0:         }
sl@0: 
sl@0: //Creates CSqlSrvDatabase object where the database file is dbFile (the second macro parameter).
sl@0: //The CSqlSrvDatabase pointer db[N - 1] (N is the first macro parameter) will be set to point to 
sl@0: //the created CSqlSrvDatabase object. 
sl@0: //N is the number of the database to be opened, between 1 and KDbConnCount.
sl@0: #define TEST_OPEN_DB(N, dbFile) \
sl@0:     __ASSERT_DEBUG(N > 0 && N <= KDbConnCount, User::Invariant()); \
sl@0:     TRAP(err, fdata.SetL(msg, dbFile.Length(), 0, dbFile)); \
sl@0:     if(err != KErrNone) \
sl@0:         { \
sl@0:         goto Cleanup; \
sl@0:         } \
sl@0:     db[N - 1] = NULL; \
sl@0:     TRAP(err, db[N - 1] = CSqlSrvDatabase::OpenL(fdata)); \
sl@0:     if(err != KErrNone) \
sl@0:         { \
sl@0:         goto Cleanup; \
sl@0:         }
sl@0: 
sl@0: //Attaches the "dbFile" database to the database number specified by the first macro parameter.
sl@0: //The attached database name is "A<M>", where M is the third macro parameter.
sl@0: //N is the number of the database connection, between 1 and KDbConnCount.
sl@0: //M is the number of the database to be attached, between 1 and KDbAttachedCount.
sl@0: #define TEST_ATTACH_DB(N, dbFile, M) \
sl@0:     __ASSERT_DEBUG(N > 0 && N <= KDbConnCount, User::Invariant()); \
sl@0:     __ASSERT_DEBUG(M > 0 && M <= KDbAttachedCount, User::Invariant()); \
sl@0:     TRAP(err, fdata.SetL(msg, dbFile.Length(), 0, dbFile)); \
sl@0:     if(err != KErrNone) \
sl@0:         { \
sl@0:         goto Cleanup; \
sl@0:         } \
sl@0:     TheAttachedDbName.Copy(_L("A")); \
sl@0:     TheAttachedDbName.AppendNum(M); \
sl@0:     TRAP(err, db[N - 1]->AttachDbL(fdata, TheAttachedDbName)); \
sl@0:     if(err != KErrNone) \
sl@0:         { \
sl@0:         goto Cleanup; \
sl@0:         }
sl@0: 
sl@0: //Detaches database "A<M>" (M is the second macro parameter) from the database identified
sl@0: //by the number N - the first macro parameter.
sl@0: //N is the number of the database connection, between 1 and KDbConnCount.
sl@0: //M is the number of the database to be detached, between 1 and KDbAttachedCount.
sl@0: #define TEST_DETACH_DB(N, M) \
sl@0:     __ASSERT_DEBUG(N > 0 && N <= KDbConnCount, User::Invariant()); \
sl@0:     __ASSERT_DEBUG(M > 0 && M <= KDbAttachedCount, User::Invariant()); \
sl@0:     if(db[N - 1]) \
sl@0:         { \
sl@0:         TheAttachedDbName.Copy(_L("A")); \
sl@0:         TheAttachedDbName.AppendNum(M); \
sl@0:         TRAP_IGNORE(db[N - 1]->DetachDbL(TheAttachedDbName)); \
sl@0:         }
sl@0: 
sl@0: /////////////////////////////////////////////////////////////
sl@0: 
sl@0: void CreateSecureTestDb(const TDesC& aDbFile, TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     (void)TheFs.Delete(aDbFile);
sl@0:     
sl@0:     TSecurityPolicy defaultPolicy(TSecurityPolicy::EAlwaysPass);
sl@0:     CSqlSecurityPolicy* policy = NULL;
sl@0:     TRAPD(err, policy = CSqlSecurityPolicy::NewL(defaultPolicy));
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:     RMessage2 msg;
sl@0:     TRAP(err, fdata.SetL(msg, aDbFile.Length(), 0, aDbFile, aEncoding == ESqlDbUtf8 ? &KConfig : NULL));
sl@0:     
sl@0:     CSqlSrvDatabase* db = NULL;
sl@0:     TRAP(err, db = CSqlSrvDatabase::CreateSecureL(fdata, policy));
sl@0:     delete db;
sl@0:     TEST2(err, KErrNone);
sl@0:     }
sl@0:     
sl@0: void OpenAttachDatabaseOomTest(TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     //Part of the databases are created by the previous tests.
sl@0:         
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     CreateSecureTestDb(KDbFile3, aEncoding);
sl@0:     CreateSecureTestDb(KDbFile4, aEncoding);
sl@0:     
sl@0:     //The following 2 declarations are used by the macros in the OOM loop
sl@0:     RMessage2 msg;
sl@0:     TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:     
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         //Declare KDbConnCount "CSqlSrvDatabase*" variables.
sl@0:         TEST_DECLARE_DB_VARS();
sl@0:         //Create CSqlSrvDatabase object, the database name is the second parameter of the macro. 
sl@0:         //The related db[N - 1] variable will be set to point to the created object.
sl@0:         TEST_OPEN_DB(1, KDbFile2());
sl@0:         TEST_OPEN_DB(2, KDbFile2());
sl@0:         TEST_OPEN_DB(3, KDbFile3());
sl@0:         TEST_OPEN_DB(4, KDbFile3());
sl@0:         TEST_OPEN_DB(5, KDbFile3());
sl@0:         TEST_OPEN_DB(6, KDbFile());
sl@0:         TEST_OPEN_DB(7, KDbFile());
sl@0:         //Attach to the database with the number specified as first macro parameter, the database file, specified
sl@0:         //as second macro parameter. The logical name of the attached database is "A<M>", where M is the third macro parameter.
sl@0:         TEST_ATTACH_DB(1, KDbFile(), 1);
sl@0:         TEST_ATTACH_DB(2, KDbFile(), 2);
sl@0:         TEST_ATTACH_DB(2, KDbFile(), 3);
sl@0:         TEST_ATTACH_DB(5, KDbFile4(), 4);
sl@0:         TEST_ATTACH_DB(2, KDbFile4(), 5);
sl@0:         TEST_ATTACH_DB(2, KDbFile4(), 6);
sl@0:         TEST_ATTACH_DB(5, KDbFile4(), 7);
sl@0:         TEST_ATTACH_DB(5, KDbFile4(), 8);
sl@0:         TEST_ATTACH_DB(1, KDbFile4(), 9);
sl@0:         TEST_ATTACH_DB(1, KDbFile(), 10);
sl@0: Cleanup:
sl@0:         __UHEAP_SETBURSTFAIL(RAllocator::ENone, 0, 0);
sl@0:         //Detach from the database with the number specified as first macro parameter, the database         
sl@0:         //with name "A<M>", where M is the second macro parameter.
sl@0:         TEST_DETACH_DB(1, 9);
sl@0:         TEST_DETACH_DB(1, 1);
sl@0:         TEST_DETACH_DB(1, 10);
sl@0:         TEST_DETACH_DB(2, 2);
sl@0:         TEST_DETACH_DB(2, 3);
sl@0:         TEST_DETACH_DB(2, 5);
sl@0:         TEST_DETACH_DB(2, 6);
sl@0:         TEST_DETACH_DB(5, 4);
sl@0:         TEST_DETACH_DB(5, 7);
sl@0:         TEST_DETACH_DB(5, 8);
sl@0:         //Delete all created CSqlSrvDatabase objects.
sl@0:         TEST_DELETE_DB();        
sl@0:         
sl@0:         OomPostStep();
sl@0:         }
sl@0:     
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:     
sl@0:     (void)TheFs.Delete(KDbFile4);
sl@0:     (void)TheFs.Delete(KDbFile3);
sl@0:     
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4171
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::AttachDbL() in an OOM test.
sl@0:                         The test is a complex one - 7 (KDbConnCount constant) databases opened 
sl@0:                         (secure and non-secure), 10 (KDbAttachedCount constant) databases
sl@0:                         attached (secure and non-secure).
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577, DEF144603
sl@0: */  
sl@0: void Utf16OpenAttachDatabaseOomTest()
sl@0:     {
sl@0:     OpenAttachDatabaseOomTest(ESqlDbUtf16);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4186
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::AttachDbL() in an OOM test.
sl@0:                         The test is a complex one - 7 (KDbConnCount constant) databases opened 
sl@0:                         (secure and non-secure), 10 (KDbAttachedCount constant) databases
sl@0:                         attached (secure and non-secure).
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144603
sl@0: */  
sl@0: void Utf8OpenAttachDatabaseOomTest()
sl@0:     {
sl@0:     OpenAttachDatabaseOomTest(ESqlDbUtf8);
sl@0:     }
sl@0: 
sl@0: void OpenAttachDatabaseOomTest2(TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     CreateSecureTestDb(KDbFile3, aEncoding);
sl@0:     CreateSecureTestDb(KDbFile4, aEncoding);
sl@0:     
sl@0:     TInt failingAllocationNo = 0;
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0:     
sl@0:     RMessage2 msg;
sl@0:     TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:     
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile3().Length(), 0, KDbFile3));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             CSqlSrvDatabase* db = NULL;
sl@0:             TRAP(err, db = CSqlSrvDatabase::OpenL(fdata));
sl@0:             if(err == KErrNone)
sl@0:                 {
sl@0:                 TRAP(err, fdata.SetL(msg, KDbFile4().Length(), 0, KDbFile4));
sl@0:                 if(err == KErrNone)
sl@0:                     {
sl@0:                     TRAP(err, db->AttachDbL(fdata, _L("db2")));
sl@0:                     if(err == KErrNone)
sl@0:                         {
sl@0:                         TRAP(err, db->DetachDbL(_L("db2")));
sl@0:                         }
sl@0:                     }
sl@0:                 delete db;
sl@0:                 }
sl@0:             }
sl@0:         OomPostStep();
sl@0:         }
sl@0:     
sl@0:     (void)TheFs.Delete(KDbFile4);
sl@0:     (void)TheFs.Delete(KDbFile3);
sl@0:     
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:      
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test 2 succeeded at heap failure rate of %d ===\r\n"), failingAllocationNo);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4172
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::AttachDbL() in an OOM test.
sl@0:                         Two secure databases are created and then, in an OOM loop, the test executes this sequence of
sl@0:                         commands: open first database, attach the second database, detach the attached database,
sl@0:                         close the first database. 
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577, PDEF44845
sl@0: */  
sl@0: void Utf16OpenAttachDatabaseOomTest2()
sl@0:     {
sl@0:     OpenAttachDatabaseOomTest2(ESqlDbUtf16);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4187
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::AttachDbL() in an OOM test.
sl@0:                         Two secure databases are created and then, in an OOM loop, the test executes this sequence of
sl@0:                         commands: open first database, attach the second database, detach the attached database,
sl@0:                         close the first database. 
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8OpenAttachDatabaseOomTest2()
sl@0:     {
sl@0:     OpenAttachDatabaseOomTest2(ESqlDbUtf8);
sl@0:     }
sl@0: 
sl@0: void OpenCreateDatabaseOomTest(TSqlDbEncoding aEncoding)
sl@0:     {
sl@0:     TheServer = NULL; 
sl@0:     TRAPD(err, TheServer = CreateSqlServerL());
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     (void)TheFs.Delete(KDbFile2);
sl@0:     CreateSecureTestDb(KDbFile2, aEncoding);
sl@0:     
sl@0:     TheTest.Printf(_L("Iteration:\r\n"));
sl@0: 
sl@0:     //Open the database
sl@0:     TInt failingAllocationNo = 0;
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo);
sl@0:         OomPreStep(failingAllocationNo);
sl@0:         
sl@0:         RMessage2 msg;
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile2().Length(), 0, KDbFile2));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             CSqlSrvDatabase* db = NULL;
sl@0:             TRAP(err, db = CSqlSrvDatabase::OpenL(fdata));
sl@0:             if(err == KErrNone)
sl@0:                 {
sl@0:                 delete db;
sl@0:                 }
sl@0:             else
sl@0:                 {
sl@0:                 TEST(!db);
sl@0:                 }
sl@0:             }
sl@0:         OomPostStep();
sl@0:         }
sl@0:     TEST2(err, KErrNone);   
sl@0:     err = TheFs.Delete(KDbFile2);
sl@0:     TEST2(err, KErrNone);   
sl@0:     //Create the database
sl@0:     TInt failingAllocationNo2 = 0;
sl@0:     err = KErrNoMemory;
sl@0:     while(err == KErrNoMemory)
sl@0:         {
sl@0:         TheTest.Printf(_L(" %d"), ++failingAllocationNo2);
sl@0:         OomPreStep(failingAllocationNo2);
sl@0:         RMessage2 msg;
sl@0:         TSqlSrvFileData& fdata = TheServer->FileData();
sl@0:         TRAP(err, fdata.SetL(msg, KDbFile2().Length(), 0, KDbFile2, aEncoding == ESqlDbUtf8 ? &KConfig : NULL));
sl@0:         if(err == KErrNone)
sl@0:             {
sl@0:             TSecurityPolicy defaultPolicy(TSecurityPolicy::EAlwaysPass);
sl@0:             CSqlSecurityPolicy* policy = NULL;
sl@0:             TRAP(err, policy = CSqlSecurityPolicy::NewL(defaultPolicy));
sl@0:             if(err == KErrNone)
sl@0:                 {
sl@0:                 CSqlSrvDatabase* db = NULL;
sl@0:                 TRAP(err, db = CSqlSrvDatabase::CreateSecureL(fdata, policy));
sl@0:                 if(err == KErrNone)
sl@0:                     {
sl@0:                     delete db;
sl@0:                     }
sl@0:                 else
sl@0:                     {
sl@0:                     TEST(!db);
sl@0:                     }
sl@0:                 }
sl@0:             }
sl@0:         OomPostStep();
sl@0:         }
sl@0:     
sl@0:     (void)TheFs.Delete(KDbFile2);
sl@0:     
sl@0:     delete TheServer;
sl@0:     TheServer = NULL;
sl@0:      
sl@0:     TEST2(err, KErrNone);   
sl@0:     TheTest.Printf(_L("\r\n===CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::CreateSecureL() OOM test succeeded at heap failure rate of %d ===\r\n"), 
sl@0:                    failingAllocationNo + failingAllocationNo2);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4173
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::CreateSecureL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::CreateSecureL() in an OOM test.
sl@0:                         The test creates a secure database then executes CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         After that the database is deleted and the test executes CSqlSrvDatabase::CreateSecureL() in an OOM loop.
sl@0:                         The purpose of the test is to check that the CSqlSrver maps are properly updated when
sl@0:                         the database is closed.
sl@0:                         UTF16 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF144577, PDEF44845
sl@0: */  
sl@0: void Utf16OpenCreateDatabaseOomTest()
sl@0:     {
sl@0:     OpenCreateDatabaseOomTest(ESqlDbUtf16);
sl@0:     }
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-UT-4188
sl@0: @SYMTestCaseDesc        CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::CreateSecureL() OOM test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test runs CSqlSrvDatabase::OpenL() and CSqlSrvDatabase::CreateSecureL() in an OOM test.
sl@0:                         The test creates a secure database then executes CSqlSrvDatabase::OpenL() in an OOM loop.
sl@0:                         After that the database is deleted and the test executes CSqlSrvDatabase::CreateSecureL() in an OOM loop.
sl@0:                         The purpose of the test is to check that the CSqlSrver maps are properly updated when
sl@0:                         the database is closed.
sl@0:                         UTF8 encoded database is used.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145047
sl@0: */  
sl@0: void Utf8OpenCreateDatabaseOomTest()
sl@0:     {
sl@0:     OpenCreateDatabaseOomTest(ESqlDbUtf8);
sl@0:     }
sl@0: 
sl@0: void DoTests()
sl@0: 	{
sl@0: #ifndef _DEBUG
sl@0:     TheTest.Start(_L("This test can be run only in debug mode!"));
sl@0: #else	
sl@0:     CActiveScheduler* scheduler = new CActiveScheduler;
sl@0:     TEST(scheduler != NULL);
sl@0:     CActiveScheduler::Install(scheduler);
sl@0: 	
sl@0:     TheTest.Start(_L(" @SYMTestCaseID:PDS-SQL-UT-4167 CSqlSrvDatabase::CreateL() OOM unit test"));
sl@0:     Utf16CreateDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4168 CSqlSrvDatabase::OpenL() OOM unit test - non-secure database"));
sl@0:     Utf16OpenDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4169 CSqlSrvDatabase::CreateSecureL() OOM unit test"));
sl@0:     Utf16CreateSecureDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4170 CSqlSrvDatabase::OpenL() OOM unit test - secure database"));
sl@0:     Utf16OpenSecureDatabaseOomTest();
sl@0:     
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4171 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM unit test"));
sl@0:     Utf16OpenAttachDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4172 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM unit test - 2"));
sl@0:     Utf16OpenAttachDatabaseOomTest2();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4173 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::CreateL() OOM unit test"));
sl@0:     Utf16OpenCreateDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4182 CSqlSrvDatabase::CreateL() OOM unit test, UTF8 database"));
sl@0:     Utf8CreateDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4183 CSqlSrvDatabase::OpenL() OOM unit test - non-secure UTF8 database"));
sl@0:     Utf8OpenDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4184 CSqlSrvDatabase::CreateSecureL() OOM unit test, UTF8 database"));
sl@0:     Utf8CreateSecureDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4185 CSqlSrvDatabase::OpenL() OOM unit test - secure UTF8 database"));
sl@0:     Utf8OpenSecureDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4186 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM unit test, UTF8 database"));
sl@0:     Utf8OpenAttachDatabaseOomTest();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4187 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::AttachDbL() OOM unit test 2, UTF8 database"));
sl@0:     Utf8OpenAttachDatabaseOomTest2();
sl@0: 
sl@0:     TheTest.Next(_L(" @SYMTestCaseID:PDS-SQL-UT-4188 CSqlSrvDatabase::OpenL() & CSqlSrvDatabase::CreateL() OOM unit test, UTF8 database"));
sl@0:     Utf8OpenCreateDatabaseOomTest();
sl@0:     
sl@0:     delete scheduler;
sl@0: #endif //_DEBUG    
sl@0: 	}
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: 	CreateTestEnv();
sl@0: 	DoTests();
sl@0: 	DestroyTestEnv();
sl@0: 
sl@0: 	__UHEAP_MARKEND;
sl@0: 	
sl@0: 	TheTest.End();
sl@0: 	TheTest.Close();
sl@0: 	
sl@0: 	delete tc;
sl@0: 
sl@0: 	User::Heap().Check();
sl@0: 	return KErrNone;
sl@0: 	}