persistentstorage/sql/TEST/t_sqlfilesrvcrash2.cpp
branchRCL_3
changeset 10 fa9941cf3867
child 51 7d4490026038
equal deleted inserted replaced
6:5ffdb8f2067f 10:fa9941cf3867
       
     1 // Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
       
     2 // All rights reserved.
       
     3 // This component and the accompanying materials are made available
       
     4 // under the terms of "Eclipse Public License v1.0"
       
     5 // which accompanies this distribution, and is available
       
     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".
       
     7 //
       
     8 // Initial Contributors:
       
     9 // Nokia Corporation - initial contribution.
       
    10 //
       
    11 // Contributors:
       
    12 //
       
    13 // Description:
       
    14 //
       
    15 
       
    16 /**
       
    17 Instructions:
       
    18 
       
    19 This is a manual test created to verify DEFXXXXX, 2 executables needs to be run to do this test
       
    20 1) t_sqlfilesrvcrash1.exe - Generate a corrupted journal file, this will cause the device to reset. 
       
    21 2) t_sqlfilesrvcrash2.exe - After the reboot, tests if SQL can handle the courrpted journal file.
       
    22 
       
    23 This test requires a non-rugged drive to store the database file and therefore will only work in hardware mode
       
    24 */
       
    25 
       
    26 #include <e32test.h>
       
    27 #include <f32file.h>
       
    28 #include <Sqldb.h>
       
    29 
       
    30 RTest TheTest(_L("t_sqlfilesrvcrash2 test"));
       
    31 
       
    32 #if !defined __WINS__ && !defined __WINSCW__
       
    33 
       
    34 RFs TheFs;
       
    35 RSqlDatabase TheDb;
       
    36 
       
    37 _LIT(KDbName, "E:\\test\\t_sqlfilesrvcrash.db");
       
    38 _LIT(KJournalName,  "E:\\test\t_sqlfilesrvcrash.db-journal");
       
    39 ///////////////////////////////////////////////////////////////////////////////////////
       
    40 //Deletes all created test files.
       
    41 void DeleteTestFiles()
       
    42     {
       
    43     TheDb.Close();
       
    44     (void)RSqlDatabase::Delete(KDbName);
       
    45     }
       
    46 
       
    47 ///////////////////////////////////////////////////////////////////////////////////////
       
    48 //Test macros and functions
       
    49 void Check(TInt aValue, TInt aLine)
       
    50     {
       
    51     if(!aValue)
       
    52         {
       
    53         RDebug::Print(_L("*** Line %d\r\n"), aLine);
       
    54         TheTest(EFalse, aLine);
       
    55         }
       
    56     }
       
    57 void Check(TInt aValue, TInt aExpected, TInt aLine)
       
    58     {
       
    59     if(aValue != aExpected)
       
    60         {
       
    61         RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
       
    62         TheTest(EFalse, aLine);
       
    63         }
       
    64     }
       
    65 
       
    66 #define TEST(arg) ::Check((arg), __LINE__)
       
    67 #define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
       
    68 ///////////////////////////////////////////////////////////////////////////////////////
       
    69 //Creates file session instance and the test directory
       
    70 void CreateTestEnv()
       
    71     {
       
    72     TInt  err = TheFs.Connect();
       
    73     TEST2(err, KErrNone);
       
    74     
       
    75     RFile file;
       
    76     err = file.Open(TheFs, KJournalName, EFileRead);
       
    77     TEST2(err, KErrNone);
       
    78     
       
    79     TInt size;
       
    80     err = file.Size(size);
       
    81     TEST2(err, KErrNone);
       
    82     TEST(size > SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT);
       
    83     file.Close();
       
    84     }
       
    85 ///////////////////////////////////////////////////////////////////////////////////////
       
    86 /**
       
    87 @SYMTestCaseID          PDS-SQL-CT-4165
       
    88 @SYMTestCaseDesc        Tests for DEF144027: SQL Open returns error if the reported and actual file size are different
       
    89                         Requires a corrupted journal file to be created using t_sqlfilesrvcrash1.exe before running 
       
    90                         this test. If a corrupted journal file exists then check that the opening the database does not
       
    91                         return an error.
       
    92 @SYMTestActions         DEF144027: SQL Open returns error if the reported and actual file size are different
       
    93 @SYMTestExpectedResults The RSqlDatabase::Open operation should not fail
       
    94 @SYMTestPriority        Medium
       
    95 @SYMDEF                 DEF144027
       
    96                         DEF144238
       
    97 */
       
    98 void DEF144027()
       
    99 	{
       
   100     TInt err = TheDb.Open(KDbName);
       
   101     TEST2(err, KErrNone);
       
   102     
       
   103     //Lets perform a simple operation to make sure it works
       
   104     err = TheDb.Exec(_L("BEGIN"));
       
   105     TEST(err >= 0);
       
   106     
       
   107     err = TheDb.Exec(_L("INSERT INTO t1(NUM) VALUES (55)"));
       
   108     TEST2(err, 1);
       
   109     
       
   110     err = TheDb.Exec(_L("INSERT INTO t2(NUM) VALUES (55)"));
       
   111     TEST2(err, 1);
       
   112         
       
   113     err = TheDb.Exec(_L("COMMIT"));
       
   114     TEST(err >= 0);
       
   115         
       
   116     TheDb.Close();
       
   117 	}
       
   118 
       
   119 void DoTests()
       
   120     {    
       
   121     TheTest.Start(_L(" @SYMTestCaseID:PDS-SQL-CT-4165 DEF144027: SQL Open returns error if the reported and actual file size are different"));
       
   122     DEF144027();    
       
   123     }
       
   124 #endif //#if !defined __WINS__ && !defined __WINSCW__
       
   125 
       
   126 TInt E32Main()
       
   127     {
       
   128     TheTest.Title();
       
   129     
       
   130     CTrapCleanup* tc = CTrapCleanup::New();
       
   131     
       
   132     __UHEAP_MARK;
       
   133     
       
   134 #if !defined __WINS__ && !defined __WINSCW__
       
   135     DoTests();
       
   136     DeleteTestFiles();
       
   137     TheFs.Close();
       
   138     TheTest.End();
       
   139 #else
       
   140     TheTest.Start(_L("This test works only works on hardware!"));
       
   141     TheTest.End();
       
   142 #endif  
       
   143  
       
   144     __UHEAP_MARKEND;
       
   145     
       
   146     TheTest.Close();
       
   147     
       
   148     delete tc;
       
   149 
       
   150     User::Heap().Check();
       
   151     return KErrNone;
       
   152     }