// Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).

// All rights reserved.

// This component and the accompanying materials are made available

// under the terms of "Eclipse Public License v1.0"

// which accompanies this distribution, and is available

// at the URL "http://www.eclipse.org/legal/epl-v10.html".

//

// Initial Contributors:

// Nokia Corporation - initial contribution.

//

// Contributors:

//

// Description:

// 

//

#include <e32test.h>

#include <bautils.h>

#include <sqldb.h>

///////////////////////////////////////////////////////////////////////////////////////

RSqlDatabase TheDb;

RTest TheTest(_L("t_sqlsecurity6 test"));

///////////////////////////////////////////////////////////////////////////////////////

void DestroyTestEnv()

	{

	TheDb.Close();

	(void)RSqlDatabase::Delete(_L("c:[00009876]"));

	}

///////////////////////////////////////////////////////////////////////////////////////

//Test macros and functions

void Check1(TInt aValue, TInt aLine)

	{

	if(!aValue)

		{

		DestroyTestEnv();

		RDebug::Print(_L("*** Boolean expression evaluated to false. Line %d\r\n"), aLine);

		TheTest(EFalse, aLine);

		}

	}

void Check2(TInt aValue, TInt aExpected, TInt aLine)

	{

	if(aValue != aExpected)

		{

		DestroyTestEnv();

		RDebug::Print(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);

		TheTest(EFalse, aLine);

		}

	}

#define TEST(arg) ::Check1((arg), __LINE__)

#define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)

///////////////////////////////////////////////////////////////////////////////////////

/**

@SYMTestCaseID          PDS-SQL-CT-4199

@SYMTestCaseDesc        Invalid secure database UIDs test.

@SYMTestPriority        High

@SYMTestActions         The test attempts to create a secure database using invalid UIDs:

						- with length less than 8 hes digits;

						- with invalid characters in the UID;

						- wiht database name containing the UID only;

@SYMTestExpectedResults Test must not fail

@SYMDEF                 DEF145236

*/  

void InvalidSecureUidsTest()

	{

	RSqlSecurityPolicy policy;

	TInt err = policy.Create(TSecurityPolicy::EAlwaysPass);

	TEST2(err, KErrNone);

	//The UID in the database name is too short. It must be 8 hex digits UID. 

	err = TheDb.Create(_L("c:[9876]t_sqlsecurity6.db"), policy);

	TEST2(err, KErrArgument);

	//Short UID, used as a database name. 

	err = TheDb.Create(_L("c:[9876]"), policy);

	TEST2(err, KErrArgument);

	//Invalid UID. 

	err = TheDb.Create(_L("c:[KH0A0Q0J]"), policy);

	TEST2(err, KErrArgument);

	//UID, used as a database name. 

	err = TheDb.Create(_L("c:[00009876]"), policy);

	TEST2(err, KErrNone);

	err = TheDb.Exec(_L("CREATE TABLE A(I INTEGER)"));

	TEST(err >= 0);

	TheDb.Close();

	err = RSqlDatabase::Delete(_L("c:[00009876]"));

	TEST2(err, KErrNone);

	policy.Close();

	}

void DoTestsL()

	{

	TheTest.Start(_L("@SYMTestCaseID:PDS-SQL-CT-4199 Invalid secure UIDs test"));

	InvalidSecureUidsTest();

	}

TInt E32Main()

	{

	TheTest.Title();

	CTrapCleanup* tc = CTrapCleanup::New();

	TheTest(tc != NULL);

	__UHEAP_MARK;

	TRAPD(err, DoTestsL());

	TEST2(err, KErrNone);

	__UHEAP_MARKEND;

	TheTest.End();

	TheTest.Close();

	delete tc;

	User::Heap().Check();

	return KErrNone;

	}