sl@0: // Copyright (c) 2010 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: RSqlDatabase TheDb;
sl@0: RTest TheTest(_L("t_sqlsecurity6 test"));
sl@0: 
sl@0: ///////////////////////////////////////////////////////////////////////////////////////
sl@0: 
sl@0: void DestroyTestEnv()
sl@0: 	{
sl@0: 	TheDb.Close();
sl@0: 	(void)RSqlDatabase::Delete(_L("c:[00009876]"));
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: 		DestroyTestEnv();
sl@0: 		RDebug::Print(_L("*** Boolean expression evaluated to false. 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: 		DestroyTestEnv();
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: /**
sl@0: @SYMTestCaseID          PDS-SQL-CT-4199
sl@0: @SYMTestCaseDesc        Invalid secure database UIDs test.
sl@0: @SYMTestPriority        High
sl@0: @SYMTestActions         The test attempts to create a secure database using invalid UIDs:
sl@0: 						- with length less than 8 hes digits;
sl@0: 						- with invalid characters in the UID;
sl@0: 						- wiht database name containing the UID only;
sl@0: @SYMTestExpectedResults Test must not fail
sl@0: @SYMDEF                 DEF145236
sl@0: */  
sl@0: void InvalidSecureUidsTest()
sl@0: 	{
sl@0: 	RSqlSecurityPolicy policy;
sl@0: 	TInt err = policy.Create(TSecurityPolicy::EAlwaysPass);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	
sl@0: 	//The UID in the database name is too short. It must be 8 hex digits UID. 
sl@0: 	err = TheDb.Create(_L("c:[9876]t_sqlsecurity6.db"), policy);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	
sl@0: 	//Short UID, used as a database name. 
sl@0: 	err = TheDb.Create(_L("c:[9876]"), policy);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 
sl@0: 	//Invalid UID. 
sl@0: 	err = TheDb.Create(_L("c:[KH0A0Q0J]"), policy);
sl@0: 	TEST2(err, KErrArgument);
sl@0: 	
sl@0: 	//UID, used as a database name. 
sl@0: 	err = TheDb.Create(_L("c:[00009876]"), policy);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.Exec(_L("CREATE TABLE A(I INTEGER)"));
sl@0: 	TEST(err >= 0);
sl@0: 	TheDb.Close();
sl@0: 	err = RSqlDatabase::Delete(_L("c:[00009876]"));
sl@0: 	TEST2(err, KErrNone);
sl@0: 	
sl@0: 	policy.Close();
sl@0: 	}
sl@0: 
sl@0: void DoTestsL()
sl@0: 	{
sl@0: 	TheTest.Start(_L("@SYMTestCaseID:PDS-SQL-CT-4199 Invalid secure UIDs test"));
sl@0: 	InvalidSecureUidsTest();
sl@0: 	}
sl@0: 
sl@0: TInt E32Main()
sl@0: 	{
sl@0: 	TheTest.Title();
sl@0: 	
sl@0: 	CTrapCleanup* tc = CTrapCleanup::New();
sl@0: 	TheTest(tc != NULL);
sl@0: 	
sl@0: 	__UHEAP_MARK;
sl@0: 		
sl@0: 	TRAPD(err, DoTestsL());
sl@0: 	DestroyTestEnv();
sl@0: 	TEST2(err, KErrNone);
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: 	}