sl@0: // Copyright (c) 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: /**
sl@0: Instructions:
sl@0: 
sl@0: This is a manual test created to verify DEFXXXXX, 2 executables needs to be run to do this test
sl@0: 1) t_sqlfilesrvcrash1.exe - Generate a corrupted journal file, this will cause the device to reset. 
sl@0: 2) t_sqlfilesrvcrash2.exe - After the reboot, tests if SQL can handle the courrpted journal file.
sl@0: 
sl@0: This test requires a non-rugged drive to store the database file and therefore will only work in hardware mode
sl@0: */
sl@0: 
sl@0: #include <e32test.h>
sl@0: #include <f32file.h>
sl@0: #include <sqldb.h>
sl@0: 
sl@0: RTest TheTest(_L("t_sqlfilesrvcrash2 test"));
sl@0: 
sl@0: #if !defined __WINS__ && !defined __WINSCW__
sl@0: 
sl@0: RFs TheFs;
sl@0: RSqlDatabase TheDb;
sl@0: 
sl@0: _LIT(KDbName, "E:\\test\\t_sqlfilesrvcrash.db");
sl@0: _LIT(KJournalName,  "E:\\test\t_sqlfilesrvcrash.db-journal");
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: //Deletes all created test files.
sl@0: void DeleteTestFiles()
sl@0:     {
sl@0:     TheDb.Close();
sl@0:     (void)RSqlDatabase::Delete(KDbName);
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:         RDebug::Print(_L("*** Line %d\r\n"), aLine);
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:         RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
sl@0:         TheTest(EFalse, aLine);
sl@0:         }
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: //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:     RFile file;
sl@0:     err = file.Open(TheFs, KJournalName, EFileRead);
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     TInt size;
sl@0:     err = file.Size(size);
sl@0:     TEST2(err, KErrNone);
sl@0:     TEST(size > SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT);
sl@0:     file.Close();
sl@0:     }
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: /**
sl@0: @SYMTestCaseID          PDS-SQL-CT-4165
sl@0: @SYMTestCaseDesc        Tests for DEF144027: SQL Open returns error if the reported and actual file size are different
sl@0:                         Requires a corrupted journal file to be created using t_sqlfilesrvcrash1.exe before running 
sl@0:                         this test. If a corrupted journal file exists then check that the opening the database does not
sl@0:                         return an error.
sl@0: @SYMTestActions         DEF144027: SQL Open returns error if the reported and actual file size are different
sl@0: @SYMTestExpectedResults The RSqlDatabase::Open operation should not fail
sl@0: @SYMTestPriority        Medium
sl@0: @SYMDEF                 DEF144027
sl@0:                         DEF144238
sl@0: */
sl@0: void DEF144027()
sl@0: 	{
sl@0:     TInt err = TheDb.Open(KDbName);
sl@0:     TEST2(err, KErrNone);
sl@0:     
sl@0:     //Lets perform a simple operation to make sure it works
sl@0:     err = TheDb.Exec(_L("BEGIN"));
sl@0:     TEST(err >= 0);
sl@0:     
sl@0:     err = TheDb.Exec(_L("INSERT INTO t1(NUM) VALUES (55)"));
sl@0:     TEST2(err, 1);
sl@0:     
sl@0:     err = TheDb.Exec(_L("INSERT INTO t2(NUM) VALUES (55)"));
sl@0:     TEST2(err, 1);
sl@0:         
sl@0:     err = TheDb.Exec(_L("COMMIT"));
sl@0:     TEST(err >= 0);
sl@0:         
sl@0:     TheDb.Close();
sl@0: 	}
sl@0: 
sl@0: void DoTests()
sl@0:     {    
sl@0:     TheTest.Start(_L(" @SYMTestCaseID:PDS-SQL-CT-4165 DEF144027: SQL Open returns error if the reported and actual file size are different"));
sl@0:     DEF144027();    
sl@0:     }
sl@0: #endif //#if !defined __WINS__ && !defined __WINSCW__
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: #if !defined __WINS__ && !defined __WINSCW__
sl@0:     DoTests();
sl@0:     DeleteTestFiles();
sl@0:     TheFs.Close();
sl@0:     TheTest.End();
sl@0: #else
sl@0:     TheTest.Start(_L("This test works only works on hardware!"));
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:     }