1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/t_sqlsecurity6.cpp	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,127 @@
     1.4 +// Copyright (c) 2010 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 +#include <e32test.h>
    1.20 +#include <bautils.h>
    1.21 +#include <sqldb.h>
    1.22 +
    1.23 +///////////////////////////////////////////////////////////////////////////////////////
    1.24 +
    1.25 +RSqlDatabase TheDb;
    1.26 +RTest TheTest(_L("t_sqlsecurity6 test"));
    1.27 +
    1.28 +///////////////////////////////////////////////////////////////////////////////////////
    1.29 +
    1.30 +void DestroyTestEnv()
    1.31 +	{
    1.32 +	TheDb.Close();
    1.33 +	(void)RSqlDatabase::Delete(_L("c:[00009876]"));
    1.34 +	}
    1.35 +
    1.36 +///////////////////////////////////////////////////////////////////////////////////////
    1.37 +//Test macros and functions
    1.38 +void Check1(TInt aValue, TInt aLine)
    1.39 +	{
    1.40 +	if(!aValue)
    1.41 +		{
    1.42 +		DestroyTestEnv();
    1.43 +		RDebug::Print(_L("*** Boolean expression evaluated to false. Line %d\r\n"), aLine);
    1.44 +		TheTest(EFalse, aLine);
    1.45 +		}
    1.46 +	}
    1.47 +void Check2(TInt aValue, TInt aExpected, TInt aLine)
    1.48 +	{
    1.49 +	if(aValue != aExpected)
    1.50 +		{
    1.51 +		DestroyTestEnv();
    1.52 +		RDebug::Print(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);
    1.53 +		TheTest(EFalse, aLine);
    1.54 +		}
    1.55 +	}
    1.56 +#define TEST(arg) ::Check1((arg), __LINE__)
    1.57 +#define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)
    1.58 +
    1.59 +///////////////////////////////////////////////////////////////////////////////////////
    1.60 +
    1.61 +/**
    1.62 +@SYMTestCaseID          PDS-SQL-CT-4199
    1.63 +@SYMTestCaseDesc        Invalid secure database UIDs test.
    1.64 +@SYMTestPriority        High
    1.65 +@SYMTestActions         The test attempts to create a secure database using invalid UIDs:
    1.66 +						- with length less than 8 hes digits;
    1.67 +						- with invalid characters in the UID;
    1.68 +						- wiht database name containing the UID only;
    1.69 +@SYMTestExpectedResults Test must not fail
    1.70 +@SYMDEF                 DEF145236
    1.71 +*/  
    1.72 +void InvalidSecureUidsTest()
    1.73 +	{
    1.74 +	RSqlSecurityPolicy policy;
    1.75 +	TInt err = policy.Create(TSecurityPolicy::EAlwaysPass);
    1.76 +	TEST2(err, KErrNone);
    1.77 +	
    1.78 +	//The UID in the database name is too short. It must be 8 hex digits UID. 
    1.79 +	err = TheDb.Create(_L("c:[9876]t_sqlsecurity6.db"), policy);
    1.80 +	TEST2(err, KErrArgument);
    1.81 +	
    1.82 +	//Short UID, used as a database name. 
    1.83 +	err = TheDb.Create(_L("c:[9876]"), policy);
    1.84 +	TEST2(err, KErrArgument);
    1.85 +
    1.86 +	//Invalid UID. 
    1.87 +	err = TheDb.Create(_L("c:[KH0A0Q0J]"), policy);
    1.88 +	TEST2(err, KErrArgument);
    1.89 +	
    1.90 +	//UID, used as a database name. 
    1.91 +	err = TheDb.Create(_L("c:[00009876]"), policy);
    1.92 +	TEST2(err, KErrNone);
    1.93 +	err = TheDb.Exec(_L("CREATE TABLE A(I INTEGER)"));
    1.94 +	TEST(err >= 0);
    1.95 +	TheDb.Close();
    1.96 +	err = RSqlDatabase::Delete(_L("c:[00009876]"));
    1.97 +	TEST2(err, KErrNone);
    1.98 +	
    1.99 +	policy.Close();
   1.100 +	}
   1.101 +
   1.102 +void DoTestsL()
   1.103 +	{
   1.104 +	TheTest.Start(_L("@SYMTestCaseID:PDS-SQL-CT-4199 Invalid secure UIDs test"));
   1.105 +	InvalidSecureUidsTest();
   1.106 +	}
   1.107 +
   1.108 +TInt E32Main()
   1.109 +	{
   1.110 +	TheTest.Title();
   1.111 +	
   1.112 +	CTrapCleanup* tc = CTrapCleanup::New();
   1.113 +	TheTest(tc != NULL);
   1.114 +	
   1.115 +	__UHEAP_MARK;
   1.116 +		
   1.117 +	TRAPD(err, DoTestsL());
   1.118 +	DestroyTestEnv();
   1.119 +	TEST2(err, KErrNone);
   1.120 +
   1.121 +	__UHEAP_MARKEND;
   1.122 +	
   1.123 +	TheTest.End();
   1.124 +	TheTest.Close();
   1.125 +	
   1.126 +	delete tc;
   1.127 +
   1.128 +	User::Heap().Check();
   1.129 +	return KErrNone;
   1.130 +	}