1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/t_sqlfilesrvcrash2.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,152 @@
1.4 +// Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +//
1.18 +
1.19 +/**
1.20 +Instructions:
1.21 +
1.22 +This is a manual test created to verify DEFXXXXX, 2 executables needs to be run to do this test
1.23 +1) t_sqlfilesrvcrash1.exe - Generate a corrupted journal file, this will cause the device to reset.
1.24 +2) t_sqlfilesrvcrash2.exe - After the reboot, tests if SQL can handle the courrpted journal file.
1.25 +
1.26 +This test requires a non-rugged drive to store the database file and therefore will only work in hardware mode
1.27 +*/
1.28 +
1.29 +#include <e32test.h>
1.30 +#include <f32file.h>
1.31 +#include <sqldb.h>
1.32 +
1.33 +RTest TheTest(_L("t_sqlfilesrvcrash2 test"));
1.34 +
1.35 +#if !defined __WINS__ && !defined __WINSCW__
1.36 +
1.37 +RFs TheFs;
1.38 +RSqlDatabase TheDb;
1.39 +
1.40 +_LIT(KDbName, "E:\\test\\t_sqlfilesrvcrash.db");
1.41 +_LIT(KJournalName, "E:\\test\t_sqlfilesrvcrash.db-journal");
1.42 +///////////////////////////////////////////////////////////////////////////////////////
1.43 +//Deletes all created test files.
1.44 +void DeleteTestFiles()
1.45 + {
1.46 + TheDb.Close();
1.47 + (void)RSqlDatabase::Delete(KDbName);
1.48 + }
1.49 +
1.50 +///////////////////////////////////////////////////////////////////////////////////////
1.51 +//Test macros and functions
1.52 +void Check(TInt aValue, TInt aLine)
1.53 + {
1.54 + if(!aValue)
1.55 + {
1.56 + RDebug::Print(_L("*** Line %d\r\n"), aLine);
1.57 + TheTest(EFalse, aLine);
1.58 + }
1.59 + }
1.60 +void Check(TInt aValue, TInt aExpected, TInt aLine)
1.61 + {
1.62 + if(aValue != aExpected)
1.63 + {
1.64 + RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
1.65 + TheTest(EFalse, aLine);
1.66 + }
1.67 + }
1.68 +
1.69 +#define TEST(arg) ::Check((arg), __LINE__)
1.70 +#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
1.71 +///////////////////////////////////////////////////////////////////////////////////////
1.72 +//Creates file session instance and the test directory
1.73 +void CreateTestEnv()
1.74 + {
1.75 + TInt err = TheFs.Connect();
1.76 + TEST2(err, KErrNone);
1.77 +
1.78 + RFile file;
1.79 + err = file.Open(TheFs, KJournalName, EFileRead);
1.80 + TEST2(err, KErrNone);
1.81 +
1.82 + TInt size;
1.83 + err = file.Size(size);
1.84 + TEST2(err, KErrNone);
1.85 + TEST(size > SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT);
1.86 + file.Close();
1.87 + }
1.88 +///////////////////////////////////////////////////////////////////////////////////////
1.89 +/**
1.90 +@SYMTestCaseID PDS-SQL-CT-4165
1.91 +@SYMTestCaseDesc Tests for DEF144027: SQL Open returns error if the reported and actual file size are different
1.92 + Requires a corrupted journal file to be created using t_sqlfilesrvcrash1.exe before running
1.93 + this test. If a corrupted journal file exists then check that the opening the database does not
1.94 + return an error.
1.95 +@SYMTestActions DEF144027: SQL Open returns error if the reported and actual file size are different
1.96 +@SYMTestExpectedResults The RSqlDatabase::Open operation should not fail
1.97 +@SYMTestPriority Medium
1.98 +@SYMDEF DEF144027
1.99 + DEF144238
1.100 +*/
1.101 +void DEF144027()
1.102 + {
1.103 + TInt err = TheDb.Open(KDbName);
1.104 + TEST2(err, KErrNone);
1.105 +
1.106 + //Lets perform a simple operation to make sure it works
1.107 + err = TheDb.Exec(_L("BEGIN"));
1.108 + TEST(err >= 0);
1.109 +
1.110 + err = TheDb.Exec(_L("INSERT INTO t1(NUM) VALUES (55)"));
1.111 + TEST2(err, 1);
1.112 +
1.113 + err = TheDb.Exec(_L("INSERT INTO t2(NUM) VALUES (55)"));
1.114 + TEST2(err, 1);
1.115 +
1.116 + err = TheDb.Exec(_L("COMMIT"));
1.117 + TEST(err >= 0);
1.118 +
1.119 + TheDb.Close();
1.120 + }
1.121 +
1.122 +void DoTests()
1.123 + {
1.124 + TheTest.Start(_L(" @SYMTestCaseID:PDS-SQL-CT-4165 DEF144027: SQL Open returns error if the reported and actual file size are different"));
1.125 + DEF144027();
1.126 + }
1.127 +#endif //#if !defined __WINS__ && !defined __WINSCW__
1.128 +
1.129 +TInt E32Main()
1.130 + {
1.131 + TheTest.Title();
1.132 +
1.133 + CTrapCleanup* tc = CTrapCleanup::New();
1.134 +
1.135 + __UHEAP_MARK;
1.136 +
1.137 +#if !defined __WINS__ && !defined __WINSCW__
1.138 + DoTests();
1.139 + DeleteTestFiles();
1.140 + TheFs.Close();
1.141 + TheTest.End();
1.142 +#else
1.143 + TheTest.Start(_L("This test works only works on hardware!"));
1.144 + TheTest.End();
1.145 +#endif
1.146 +
1.147 + __UHEAP_MARKEND;
1.148 +
1.149 + TheTest.Close();
1.150 +
1.151 + delete tc;
1.152 +
1.153 + User::Heap().Check();
1.154 + return KErrNone;
1.155 + }