sl@0: // Copyright (c) 2006-2009 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 <sqldb.h>
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: static RFs TheFs;
sl@0: RTest TheTest(_L("t_sqlood test"));
sl@0: 
sl@0: #if  defined __WINSCW__ || defined __WINS__
sl@0: 
sl@0: 	//The C: drive may be too big and may be used concurently by other applications. 
sl@0: 	//The T: drive is more suitable for the test if running on the emulator
sl@0: 	const TInt KTestDrive = EDriveT;
sl@0: 	_LIT(KTestDir, "t:\\test\\");
sl@0: 	_LIT(KTestDatabase, "t:\\test\\t_sql_ood.db");
sl@0: 	
sl@0: #elif defined __X86GCC__
sl@0: 
sl@0: 	const TInt KTestDrive = EDriveG;
sl@0: 	_LIT(KTestDir, "g:\\test\\");
sl@0: 	_LIT(KTestDatabase, "g:\\test\\t_sql_ood.db");
sl@0: 	
sl@0: #else
sl@0: 
sl@0: 	const TInt KTestDrive = EDriveE;
sl@0: 	_LIT(KTestDir, "e:\\test\\");
sl@0: 	_LIT(KTestDatabase, "e:\\test\\t_sql_ood.db");
sl@0: 	
sl@0: #endif
sl@0: 
sl@0: //One or more files with KLargeFileName name and ".<n>" extension, where n is 
sl@0: //000, 001, 002, 003...
sl@0: //will be created and they will occupy almost all available disk space.
sl@0: //The idea is to perform after that one "delete"
sl@0: //transaction, which must to fail, because there won't be enough available disk space to complete the transaction.
sl@0: #if  defined __WINSCW__ || defined __WINS__
sl@0: 
sl@0: 	_LIT(KLargeFileName, "t:\\test\\DeleteMe");
sl@0: 
sl@0: #elif defined __X86GCC__
sl@0: 
sl@0: 	_LIT(KLargeFileName, "g:\\test\\DeleteMe");
sl@0: 
sl@0: #else
sl@0: 
sl@0: 	_LIT(KLargeFileName, "e:\\test\\DeleteMe");
sl@0: 
sl@0: #endif
sl@0: 
sl@0: _LIT8(KDatabasePageSizeConfig, "page_size=1024");
sl@0: 
sl@0: const TInt KMaxTestRecordsCount = 350;
sl@0: TInt TestRecordsCount = 0;
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: //Assemblesd a file name from "aFileName" and "aFileNumber" parameters and places the resulting string in "aResultPath".
sl@0: void AssembleLargeFileName(const TDesC& aFileName, TInt aFileNumber, TDes& aResultPath)
sl@0: 	{
sl@0: 	_LIT(KFormatStr, "%S.%03d");
sl@0: 	aResultPath.Format(KFormatStr, &aFileName, aFileNumber);
sl@0: 	}
sl@0: 
sl@0: //Deletes all created large data files.
sl@0: void DeleteLargeDataFiles()
sl@0: 	{
sl@0: 	TInt err = KErrNone;
sl@0: 	TInt i = -1;
sl@0: 	while(err == KErrNone)
sl@0: 		{
sl@0: 		TBuf<KMaxFileName> filePath;
sl@0: 		::AssembleLargeFileName(KLargeFileName, ++i, filePath);
sl@0: 		err = TheFs.Delete(filePath);
sl@0: 		}
sl@0: 	}
sl@0: 
sl@0: //Deletes all created test files.
sl@0: void DeleteTestFiles()
sl@0: 	{
sl@0: 	DeleteLargeDataFiles();
sl@0: 	(void)RSqlDatabase::Delete(KTestDatabase);
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: //Test macros and functions
sl@0: void Check1(TInt aValue, TInt aLine)
sl@0: 	{
sl@0: 	if(!aValue)
sl@0: 		{
sl@0: 		DeleteTestFiles();
sl@0: 		RDebug::Print(_L("*** Line %d\r\n"), aLine);
sl@0: 		TheTest(EFalse, aLine);
sl@0: 		}
sl@0: 	}
sl@0: void Check2(TInt aValue, TInt aExpected, TInt aLine)
sl@0: 	{
sl@0: 	if(aValue != aExpected)
sl@0: 		{
sl@0: 		DeleteTestFiles();
sl@0: 		RDebug::Print(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);
sl@0: 		TheTest(EFalse, aLine);
sl@0: 		}
sl@0: 	}
sl@0: #define TEST(arg) ::Check1((arg), __LINE__)
sl@0: #define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: //Creates file session instance and the test directory
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: 	if(err != KErrNone)
sl@0: 	    {
sl@0: 	    RDebug::Print(_L("*** CreateTestEnv(), RFs::MkDir(), err=%d\r\n"), err);
sl@0: 	    }
sl@0: 	TEST(err == KErrNone || err == KErrAlreadyExists);
sl@0: 	}
sl@0: 
sl@0: //Creates one or more large files with the total size near to the size of the available disk space.
sl@0: //The idea is to cause an "out of disk space" condition.
sl@0: void FillLargeDataFile(RFile& aFile, TInt aSize)
sl@0: 	{
sl@0: 	TInt err = KErrDiskFull;
sl@0: 	while(err == KErrDiskFull)
sl@0: 		{
sl@0: 		err = aFile.SetSize(aSize);
sl@0: 		aSize -= 100;
sl@0: 		if(aSize <= 0)
sl@0: 			{
sl@0: 			break;
sl@0: 			}
sl@0: 		}
sl@0: 	TEST(err == KErrNone || err == KErrDiskFull);
sl@0: 	}
sl@0: 
sl@0: //Gets and returns the available disk space of the tested drive.
sl@0: TInt64 FreeDiskSpace()
sl@0: 	{
sl@0: 	TVolumeInfo volInfoBefore;
sl@0: 	TInt err = TheFs.Volume(volInfoBefore, KTestDrive);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	return volInfoBefore.iFree;
sl@0: 	}
sl@0: 
sl@0: //Creates a large data file with aSize size (in bytes).
sl@0: void DoCreateLargeFile(const TDesC& aPath, TInt aSize)
sl@0: 	{
sl@0: 	RFile file;
sl@0: 	TInt err = file.Replace(TheFs, aPath, EFileRead | EFileWrite);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	FillLargeDataFile(file, aSize);
sl@0: 	err = file.Flush();
sl@0: 	TEST2(err, KErrNone);
sl@0: 	file.Close();
sl@0: 	}
sl@0: 
sl@0: //Creates enough number of large data files to fill the available disk space.
sl@0: void CreateLargeFile()
sl@0: 	{
sl@0: 	TInt fileNo = 0;
sl@0: 	const TInt KLargeFileSize = 1000000000;
sl@0: 	TInt64 diskSpace = ::FreeDiskSpace();
sl@0: 	RDebug::Print(_L("CreateLargeFile: free space before = %ld\r\n"), diskSpace);
sl@0: 	TBuf<KMaxFileName> filePath;
sl@0: 	while(diskSpace > KLargeFileSize)
sl@0: 		{
sl@0: 		AssembleLargeFileName(KLargeFileName, fileNo++, filePath);
sl@0: 		DoCreateLargeFile(filePath, KLargeFileSize);
sl@0: 		diskSpace = ::FreeDiskSpace();
sl@0: 		RDebug::Print(_L("----CreateLargeFile, step %d, free space = %ld\r\n"), fileNo, diskSpace);
sl@0: 		}
sl@0: 	//Reserve almost all disk space, except a small amount - 200 bytes.
sl@0: 	if(diskSpace > 0)
sl@0: 		{
sl@0: 		::AssembleLargeFileName(KLargeFileName, fileNo++, filePath);
sl@0: 		const TInt64 KSpaceLeft = 200;
sl@0: 		TInt64 lastFileSize = diskSpace - KSpaceLeft;
sl@0:         TInt lastFileSize32 = I64LOW(lastFileSize);
sl@0: 		RDebug::Print(_L("----file size32 = %d\r\n"), lastFileSize32);
sl@0: 		::DoCreateLargeFile(filePath, lastFileSize32);
sl@0: 		RDebug::Print(_L("----CreateLargeFile, last step (%d), file size = %ld\r\n"), fileNo, lastFileSize);
sl@0: 		}
sl@0: 	diskSpace = ::FreeDiskSpace();
sl@0: 	RDebug::Print(_L("CreateLargeFile: free space after = %ld\r\n"), diskSpace);
sl@0: 	}
sl@0: 
sl@0: 
sl@0: // Number of bytes in the default journal header size.
sl@0: const TInt KJournalHeaderSize = 0x200;
sl@0: 
sl@0: // Number of bytes added to each database page in the journal.
sl@0: const TInt KJournalPageOverhead = 8; 
sl@0: 
sl@0: // The default amount of reserved space provided by the ReserveDriveSpace API
sl@0: const TInt KReserveDriveSpaceAmount = 64*1024;
sl@0: 
sl@0: //Creates and fills with some records a test database
sl@0: void CreateAndFillTestDatabase(RSqlDatabase& aDb)
sl@0: 	{
sl@0: 	TInt err = aDb.Create(KTestDatabase, &KDatabasePageSizeConfig);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = aDb.Exec(_L("CREATE TABLE A(Id INTEGER, Data TEXT)"));
sl@0: 	TEST(err >= 0);
sl@0: 
sl@0: 	//
sl@0: 	// Find the page size of the database on this media
sl@0: 	//
sl@0: 	TBuf<200> sql;
sl@0: 	sql.Copy(_L("PRAGMA page_size"));
sl@0: 	TSqlScalarFullSelectQuery q(aDb);
sl@0: 	TInt pageSize = 0;
sl@0: 	TRAP(err, pageSize = q.SelectIntL(sql););
sl@0: 	//RDebug::Print(_L("Error %d Page Size %d"),err,pageSize);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TEST(pageSize > 0);
sl@0: 	//RDebug::Print(_L("Page Size %d"),pageSize);
sl@0: 	
sl@0: 	//
sl@0: 	// Find the sector size of this media
sl@0: 	//
sl@0: 	TDriveInfo driveInfo;
sl@0: 	err = TheFs.Drive(driveInfo, KTestDrive);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TVolumeIOParamInfo volumeInfo;
sl@0: 	err = TheFs.VolumeIOParam(KTestDrive, volumeInfo);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TInt sectorSize = volumeInfo.iBlockSize;
sl@0: 	//RDebug::Print(_L("Sector Size %d"),sectorSize);	
sl@0: 
sl@0: 	TInt journalHeaderSize = Max(sectorSize, KJournalHeaderSize);
sl@0: 	//RDebug::Print(_L("Journal Header Size %d"),journalHeaderSize);
sl@0: 
sl@0: 	//
sl@0: 	// Keep adding to database until it is a size such that all the data can still be deleted within the reserved disk space size. 
sl@0: 	// Do this piece-wise not in a transaction.
sl@0: 	//
sl@0: 	TInt i;
sl@0: 	for(i=0;i<KMaxTestRecordsCount;++i)
sl@0: 		{
sl@0: 		sql.Format(_L("INSERT INTO A(Id, Data) VALUES(%d, 'A0123456789B0123456789C0123456789D0123456789E0123456789F0123456789G0123456789H0123456789')"), i + 1);
sl@0: 		err = aDb.Exec(sql);
sl@0: 		TEST2(err, 1);
sl@0: 
sl@0: 		TInt size = aDb.Size();
sl@0: 		TInt numberOfPages = size/pageSize;
sl@0: 		TInt predictedJournalSize = journalHeaderSize + numberOfPages * (pageSize + KJournalPageOverhead);
sl@0: 		//RDebug::Print(_L("Size %d, Pages %d, predictedJournalSize %d"),size, numberOfPages, predictedJournalSize);
sl@0: 		
sl@0: 		// Will another page take us over the limit ?
sl@0: 		if ((predictedJournalSize + (pageSize + KJournalPageOverhead)) >= (KReserveDriveSpaceAmount))
sl@0: 			{
sl@0: 			break;
sl@0: 			}
sl@0: 		}
sl@0: 	TestRecordsCount = i + 1;
sl@0: 	
sl@0: 	//RDebug::Print(_L("TestRecordsCount %d"),TestRecordsCount);
sl@0: 	
sl@0: 	}
sl@0: 
sl@0: //Tries to delete test database records
sl@0: TInt DeleteTestRecords(RSqlDatabase& aDb)
sl@0: 	{
sl@0: 	TInt err = aDb.Exec(_L("BEGIN TRANSACTION"));
sl@0: 	TEST(err >= 0);
sl@0: 	for(TInt i=0;i<TestRecordsCount;++i)
sl@0: 		{
sl@0: 		TBuf<100> sql;
sl@0: 		sql.Format(_L("DELETE FROM A WHERE Id = %d"), i + 1);
sl@0: 		err = aDb.Exec(sql);// May fail with KErrDiskFull
sl@0: 		if(err < 0)
sl@0: 			{
sl@0: 			(void)aDb.Exec(_L("ROLLBACK TRANSACTION"));
sl@0: 			return err;
sl@0: 			}
sl@0: 		}
sl@0: 	err = aDb.Exec(_L("COMMIT TRANSACTION"));// May fail with KErrDiskFull
sl@0: 	return err;
sl@0: 	}
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: //The function simply calls RSqlDatabase::ReserveDriveSpace(), RSqlDatabase::GetReserveAccess(),
sl@0: //RSqlDatabase::ReleaseReserveAccess() methods and checks the return values.
sl@0: //It might be usefull for debugging in case if something gets wrong.
sl@0: void SimpleCallsTest()
sl@0: 	{
sl@0: 	RSqlDatabase db, db2;
sl@0: 	TInt err = db.Create(KTestDatabase, &KDatabasePageSizeConfig);
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	err = db2.Open(KTestDatabase);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	
sl@0: 	//An attempt to get an access to the reserved space (which is not reserved yet).
sl@0: 	err = db.GetReserveAccess();
sl@0: 	TEST2(err, KErrNotFound);
sl@0: 
sl@0: 	//Reserve disk space
sl@0: 	err = db.ReserveDriveSpace(0);
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	//An attempt to re-reserve it
sl@0:    	err = db.ReserveDriveSpace(0);
sl@0: 	TEST2(err, KErrAlreadyExists);
sl@0: 
sl@0: 	//Get an access to the reserved disk space
sl@0: 	err = db.GetReserveAccess();
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	//Reserve disk space from the second connection
sl@0: 	err = db2.ReserveDriveSpace(0);
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	//An attempt to get an access to the reserved space twice.
sl@0: 	err = db.GetReserveAccess();
sl@0: 	TEST2(err, KErrInUse);
sl@0: 
sl@0: 	//An attempt to get an access to the reserved space from the second connection.
sl@0: 	err = db2.GetReserveAccess();
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	db.ReleaseReserveAccess();
sl@0: 
sl@0: 	//An attempt to release the reserved space twice.
sl@0: 	db.ReleaseReserveAccess();
sl@0: 
sl@0: 	//Free the reserved disk space
sl@0: 	db.FreeReservedSpace();
sl@0: 
sl@0: 	//Free the reserved disk space twice.
sl@0: 	db.FreeReservedSpace();
sl@0: 
sl@0: 	//Free the reserved disk space from the second connection.
sl@0: 	db2.FreeReservedSpace();
sl@0: 
sl@0: 	db2.Close();
sl@0: 	db.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDatabase);
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID			SYSLIB-SQL-CT-1649
sl@0: @SYMTestCaseDesc		SQL database "out of disk space" tests.
sl@0: 						The test creates and fills with some records a test database and then reserves a disk space.
sl@0: 						The second step: the test fills almost all available disk space creting large data files.
sl@0: 						The third step: the test attempts to delete all records from the test database and fails with
sl@0: 						KErrDiskFull error.
sl@0: 						The fourth step: the test gets an access to the reserved disk space and attempts to delete
sl@0: 						records again. This time the test should not fail.
sl@0: @SYMTestPriority		High
sl@0: @SYMTestActions			SQL database "out of disk space" tests.
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMREQ					REQ5792
sl@0:                         REQ5793
sl@0: */
sl@0: void DeleteTransactionTest()
sl@0: 	{
sl@0: 	TVolumeIOParamInfo volIoPrm;
sl@0: 	TInt err = TheFs.VolumeIOParam(KTestDrive, volIoPrm);
sl@0:     TEST2(err, KErrNone);
sl@0:     RDebug::Print(_L("--Drive %d. BlockSize=%d, ClusterSize=%d, RecReadBufSize=%d, RecWriteBufSize=%d\r\n"), KTestDrive, volIoPrm.iBlockSize, volIoPrm.iClusterSize, volIoPrm.iRecReadBufSize, volIoPrm.iRecWriteBufSize);
sl@0: 	/////////////////////////////////////////////////////////
sl@0:     RDebug::Print(_L("--Create and fill database \"%S\".\r\n"), &KTestDatabase);
sl@0: 	RSqlDatabase db;
sl@0: 	CreateAndFillTestDatabase(db);
sl@0: 	db.Close();//When the database gets closed, the persisted journal file will be deleted.
sl@0:     RDebug::Print(_L("--Close and reopen database \"%S\" (in order to get the persisted journal file deleted).\r\n"), &KTestDatabase);
sl@0:     err = db.Open(KTestDatabase);
sl@0:     TEST2(err, KErrNone);
sl@0:     RDebug::Print(_L("--Reserve disk space for database \"%S\".\r\n"), &KTestDatabase);
sl@0:     err = db.ReserveDriveSpace(0);
sl@0: 	TEST2(err, KErrNone);
sl@0:     RDebug::Print(_L("--Simulate an \"out of disk space\" situation with creating a very large data file, which occupies almost the all the available disk space.\r\n"));
sl@0: 	CreateLargeFile();
sl@0: 	RDebug::Print(_L("--Attempt to delete test data records. The transaction must fail, because of \"out of disk space\".\r\n"));
sl@0: 	err = DeleteTestRecords(db);
sl@0: 	TEST2(err, KErrDiskFull);
sl@0:     RDebug::Print(_L("--Get an access to the reserved disk space.\r\n"));
sl@0: 	err = db.GetReserveAccess();
sl@0: 	TEST2(err, KErrNone);
sl@0:     TInt64 diskSpace = ::FreeDiskSpace();
sl@0:     RDebug::Print(_L("After GetReserveAccess(), free disk space = %ld. Try again \"Delete records\" transaction. The transaction must not fail.\r\n"), diskSpace);
sl@0: 	err = DeleteTestRecords(db);
sl@0: 	RDebug::Print(_L("--DeleteTestRecords() returned %d error.\r\n"), err);
sl@0: 	TEST(err >= 0);
sl@0: 	//Releases the access to the reserved disk space
sl@0: 	db.ReleaseReserveAccess();
sl@0: 	//Frees the reserved disk space
sl@0: 	db.FreeReservedSpace();
sl@0:     //Free the resources, used in the test
sl@0: 	DeleteLargeDataFiles();
sl@0: 	//Verify that the records have been deleted
sl@0: 	RSqlStatement stmt;
sl@0: 	err = stmt.Prepare(db, _L("SELECT COUNT(*) FROM A"));
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = stmt.Next();
sl@0: 	TEST2(err, KSqlAtRow);
sl@0: 	TInt recCount = stmt.ColumnInt(0);
sl@0: 	TEST2(recCount, 0);
sl@0: 	stmt.Close();
sl@0: 	db.Close();
sl@0: 	(void)RSqlDatabase::Delete(KTestDatabase);
sl@0: 	}
sl@0: 
sl@0: //OOD API tests with more than one connection to the same SQL database.
sl@0: //The test calls ReserveDriveSpace/GetReserveAccess/ReleaseReserveAccess in a different
sl@0: //combinations on four RSqlDatabase objects, connected to the same database .
sl@0: //The test should not fail or panic.
sl@0: void MultiDbTest()
sl@0:     {
sl@0:     RSqlDatabase db1;
sl@0: 	CreateAndFillTestDatabase(db1);
sl@0: 
sl@0:     RSqlDatabase db2;
sl@0:     TInt err = db2.Open(KTestDatabase);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Play with "ReserveDriveSpace" on both sessions
sl@0:     err = db1.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0:     err = db2.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0:     db2.FreeReservedSpace();
sl@0:     err = db2.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Get an access to the reserved space through db2
sl@0: 	err = db2.GetReserveAccess();
sl@0:     TEST2(err, KErrNone);
sl@0:     //Free/re-reserve disk space for db1.
sl@0:     db1.FreeReservedSpace();
sl@0:     err = db1.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     RSqlDatabase db4;
sl@0:     err = db4.Open(KTestDatabase);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Try to reserve space for db4.
sl@0:     err = db4.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     RSqlDatabase db3;
sl@0:     err = db3.Open(KTestDatabase);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Try to reserve space for session db3.
sl@0:     err = db3.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Release and free db2 access to the reserved space.
sl@0:     db2.ReleaseReserveAccess();
sl@0:     db2.FreeReservedSpace();
sl@0: 
sl@0:     db3.FreeReservedSpace();
sl@0:     db3.Close();
sl@0: 
sl@0:     db4.FreeReservedSpace();
sl@0:     db4.Close();
sl@0: 
sl@0:     //Get an access to the reserved space through db2.
sl@0:     //But it was freed, so the call will fail.
sl@0: 	err = db2.GetReserveAccess();
sl@0:     TEST2(err, KErrNotFound);
sl@0: 
sl@0:     //Free/re-reserve disk space for db1.
sl@0:     db1.FreeReservedSpace();
sl@0:     err = db1.ReserveDriveSpace(0);
sl@0:     TEST2(err, KErrNone);
sl@0: 
sl@0:     //Get/release the access to the reserved space for db1.
sl@0: 	err = db1.GetReserveAccess();
sl@0:     TEST2(err, KErrNone);
sl@0:     db1.ReleaseReserveAccess();
sl@0: 
sl@0:     //Get an access to the reserved space for db2.
sl@0:     //The call will fail because there is no reserved disk space for db2.
sl@0: 	err = db2.GetReserveAccess();
sl@0:     TEST2(err, KErrNotFound);
sl@0: 
sl@0:     //Free the reserved space - db1
sl@0:     db1.FreeReservedSpace();
sl@0: 
sl@0: 	db2.Close();
sl@0: 	db1.Close();
sl@0: 
sl@0: 	(void)RSqlDatabase::Delete(KTestDatabase);
sl@0:     }
sl@0: 
sl@0: void DoTests()
sl@0: 	{
sl@0: 	TheTest.Start(_L(" \"Simple calls\" OOD test "));
sl@0: 	SimpleCallsTest();
sl@0: 
sl@0: 	TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-1649 \"Delete transaction\" OOD test "));
sl@0: 	DeleteTransactionTest();
sl@0: 
sl@0: 	TheTest.Next(_L(" Multi db OOD test "));
sl@0: 	MultiDbTest();
sl@0: 	}
sl@0: 
sl@0: TInt E32Main()
sl@0: 	{
sl@0: 	TheTest.Title();
sl@0: 
sl@0: 	CTrapCleanup* tc = CTrapCleanup::New();
sl@0: 
sl@0: 	__UHEAP_MARK;
sl@0: 
sl@0: 	CreateTestEnv();
sl@0: 	DeleteTestFiles();
sl@0: 	DoTests();
sl@0: 	DeleteTestFiles();
sl@0: 	TheFs.Close();
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: 	}