// Copyright (c) 1998-2009 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 <e32std.h>

#include <d32dbms.h>

#include <e32test.h>

LOCAL_D CTrapCleanup* TheTrapCleanup;

LOCAL_D RTest test(_L("t_dbclient"));

LOCAL_D const TPtrC KColName(_S("A_column_name"));

LOCAL_D TDbColName VarName(_S("Column_A"));

const TInt KTestCleanupStack=0x20;

const TInt KLeaveError=-4000;

const TInt KColCount=26;

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0586

@SYMTestCaseDesc        Tests for TDbCol class

@SYMTestPriority        Medium

@SYMTestActions        	Tests for column name and type after creating them.

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestTDbCol()

	{

	test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0586 Testing TDbCol "));

	TDbCol c1(KColName,EDbColText8);

	test(c1.iName==KColName);

	test(c1.iType==EDbColText8);

	test(c1.iMaxLength==KDbDefaultTextColLength);

	test(c1.iAttributes==0);

	TDbCol c2(KColName,EDbColText8,1234);

	test(c2.iName==KColName);

	test(c2.iType==EDbColText8);

	test(c2.iMaxLength==1234);

	test(c2.iAttributes==0);

	TDbCol c3(KColName,EDbColBit);

	test(c3.iName==KColName);

	test(c3.iType==EDbColBit);

	test(c3.iMaxLength==KDbUndefinedLength);

	test(c3.iAttributes==0);

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0587

@SYMTestCaseDesc        CDbColSet class test

@SYMTestPriority        Medium

@SYMTestActions        	Tests for creation of a CDbColSet column set object

                        Tests for adding and removing columns to the column set

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestCDbColSetL()

	{

	TInt r;

	test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0587 ctor and dtor "));

	CDbColSet* c=CDbColSet::NewL();		// assume it will succeed

	test(c!=NULL);

	test (c->Count()==0);

	delete c;

	__UHEAP_CHECK(0);

#if defined(_DEBUG)

	__UHEAP_FAILNEXT(1);

	TRAP(r,c=CDbColSet::NewL());

	test(r!=KErrNone);

	__UHEAP_CHECK(0);

#endif

	c=CDbColSet::NewLC();

	test(c!=NULL);

	CleanupStack::PopAndDestroy();

	__UHEAP_CHECK(0);

	c=CDbColSet::NewL();

	TDbCol col(KColName,EDbColText,20);

	c->AddL(col);

	delete c;

	__UHEAP_CHECK(0);

	TRAP(r,c=CDbColSet::NewLC();c->AddL(col);User::Leave(KLeaveError););

	test(r==KLeaveError);

	__UHEAP_CHECK(0);

//

	test.Next(_L("Add columns"));

	c=CDbColSet::NewLC();

	TInt ii;

	for (ii=1;ii<=KColCount;ii++)

		{

		VarName[7]=(TUint8)('A'-1+ii);

		test(c->Col(VarName)==NULL);

		TDbCol column(VarName,EDbColInt32);

		c->AddL(column);

		test(c->Count()==ii);

		test(c->ColNo(VarName)!=KDbNullColNo);

		test(c->Col(VarName)!=NULL);

		}

	test.Next(_L("Check columns: operator[] and ColNo()"));

	for (ii=1;ii<=KColCount;ii++)

		{

		const TDbCol& col=(*c)[ii];

		test(c->ColNo(col.iName)==ii);

		}

	test.Next(_L("Remove columns"));

	for (ii=1;ii<=KColCount;ii+=2)

		{

		VarName[7]=(TUint8)('A'-1+ii);

		c->Remove(VarName);

		}

	test(c->Count()==13);

	test.Next(_L("Clear"));

	c->Clear();

	test(c->Count()==0);

	CleanupStack::PopAndDestroy();

	__UHEAP_CHECK(0);

	test.End();

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0588

@SYMTestCaseDesc        Tests for TDbColSetIter class

@SYMTestPriority        Medium

@SYMTestActions        	Tests for iterate over the contents of a column set

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestTDbColSetIterL()

	{

	test.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0588 Testing TDbColSetIter "));

	CDbColSet* c=CDbColSet::NewLC();

	TInt ii;

	for (ii=0;ii<KColCount;++ii)

		{

		VarName[7]=(TUint8)('A'-1+ii);

		c->AddL(TDbCol(VarName,EDbColInt32));

		}

	TDbColSetIter iter1(*c);

	TDbColSetIter iter2(iter1);

	ii=0;

	for (;;)

		{

		test(iter1.Col()==++ii);

		test(iter1.operator->()==&iter1.operator*());

		test(&*iter1++==&*iter2);

		if (!iter1)

			break;

		test(&*iter1==&*++iter2);

		}

	test(!++iter2);

	test(ii==KColCount);

	CleanupStack::PopAndDestroy();

	__UHEAP_CHECK(0);

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0589

@SYMTestCaseDesc        Tests for TDbCol,CDbColSet,TDbColSetIter classes

@SYMTestPriority        Medium

@SYMTestActions        	Executes the tests of TDbCol,CDbColSet,TDbColSetIter

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestColSetL()

	{

	test.Next(_L("@SYMTestCaseID:SYSLIB-DBMS-CT-0589 "));

	TestTDbCol();

	test.Next(_L("Testing CDbColSet"));

	TestCDbColSetL();

	TestTDbColSetIterL();

	test.End();

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0590

@SYMTestCaseDesc        Tests for TDbKeyCol class

@SYMTestPriority        Medium

@SYMTestActions         Attempts to test for attributes of the key column together.

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestTDbKeyCol()

	{

	test.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0590 Testing TDbKeyCol "));

	TDbKeyCol c1(KColName);

	test(c1.iName==KColName);

	test(c1.iOrder==TDbKeyCol::EAsc);

	TDbKeyCol c2(KColName,TDbKeyCol::EDesc);

	test(c2.iName==KColName);

	test(c2.iOrder==TDbKeyCol::EDesc);

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0591

@SYMTestCaseDesc        Tests the CDbKey class

@SYMTestPriority        Medium

@SYMTestActions         Tests for the new CDbKey creation using NewL and NewLC functions

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestCDbKeyL()

	{

	TInt r;

	test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0591 ctor and dtor "));

	CDbKey* k=CDbKey::NewL();		// assume it will succeed

	test(k!=NULL);

	delete k;

	__UHEAP_CHECK(0);

#if defined(_DEBUG)

	__UHEAP_FAILNEXT(1);

	TRAP(r,k=CDbKey::NewL());

	test(r!=KErrNone);

	__UHEAP_CHECK(0);

#endif

	k=CDbKey::NewLC();

	test(k!=NULL);

	CleanupStack::PopAndDestroy();

	__UHEAP_CHECK(0);

	k=CDbKey::NewL();

	k->AddL(VarName);

	delete k;

	__UHEAP_CHECK(0);

	TRAP(r,k=CDbKey::NewLC();k->AddL(KColName);User::Leave(KLeaveError););

	test(r==KLeaveError);

	__UHEAP_CHECK(0);

//

	test.Next(_L("Add key columns"));

	k=CDbKey::NewLC();

	TInt ii;

	for (ii=1;ii<=KColCount;++ii)

		{

		VarName[7]=(TUint8)('A'-1+ii);

		k->AddL(VarName);

		test(k->Count()==ii);

		test((*k)[ii-1].iName==VarName);

		}

	test.Next(_L("Remove key columns"));

	for (ii=1;ii<=KColCount;ii+=2)

		{

		VarName[7]=TUint8('A'-1+ii);

		k->Remove(VarName);

		}

	test(k->Count()==KColCount/2);

	test.Next(_L("Clear"));

	k->Clear();

	test(k->Count()==0);

	test.Next(_L("Unique flag"));

	test(!k->IsUnique());

	k->MakeUnique();

	test(k->IsUnique());

	k->MakeUnique();

	test(k->IsUnique());

	CleanupStack::PopAndDestroy();

	__UHEAP_CHECK(0);

	test.End();

	}

/**

@SYMTestCaseID          SYSLIB-DBMS-CT-0592

@SYMTestCaseDesc        Tests the TDbKeyCol,CDbKey classes

@SYMTestPriority        Medium

@SYMTestActions         Executes the TDbKeyCol,CDbKey tests

@SYMTestExpectedResults Test must not fail

@SYMREQ                 REQ0000

*/

LOCAL_C void TestKeyL()

	{

	test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0592 "));

	TestTDbKeyCol();

	test.Next(_L("Testing CDbKey"));

	TestCDbKeyL();

	test.End();

	}

LOCAL_C void setupCleanup()

//

// Initialise the cleanup stack.

//

    {

	TheTrapCleanup=CTrapCleanup::New();

	test(TheTrapCleanup!=NULL);

	TRAPD(r,\

		{\

		for (TInt i=KTestCleanupStack;i>0;i--)\

			CleanupStack::PushL((TAny*)0);\

		CleanupStack::Pop(KTestCleanupStack);\

		});

	test(r==KErrNone);

	}

GLDEF_C TInt E32Main()

//

// Test Client-side objects

//

    {

	test.Title();

	setupCleanup();

	__UHEAP_MARK;

//

	test.Start(_L("Test the Column Set"));

	TRAPD(r,TestColSetL();)

	test(r==KErrNone);

	__UHEAP_CHECK(0);

	test.Next(_L("Test the Key"));

	TRAP(r,TestKeyL();)

	test(r==KErrNone);

	test.End();

//

	__UHEAP_MARKEND;

	delete TheTrapCleanup;

	test.Close();

	return 0;

    }