// Copyright (c) 2004-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:
//

//The test uses C:TESTDB.DB secure shared database, which creates tables A, B and C.
#include <e32test.h>
#include <d32dbms.h>
#include "t_dbplatsecutl.h"

//The .spd file has the following capabilities:
//	Schema	None
//	Read	SurroundingsDD
//	Write	UserEnvironment
const TUid KSecureDbUid = {0x12344321};

_LIT(KSecure,	"SECURE");
_LIT(KDbName,	"C:TestDB.DB");
_LIT(KTblNameA,	"A");
_LIT(KTblNameB,	"B");
_LIT(KTblNameC,	"C");

static RTest 				TheTest(_L("t_dbnewcap1"));
static RDbs 				TheDbs;
static RDbNamedDatabase 	TheDb;
static RDbTable 			TheTbl;

TDBSCUtils 	TheDbscUtils(TheTest, NULL);

static TColDef const KColumns[]=
	{
	{_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
	{_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
	{_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
	{0}
	};

/**
@SYMTestCaseID SYSLIB-DBMS-CT-1361
@SYMTestCaseDesc Checking to make sure the .spd file used in this test has been created correctly and
functions as it should.
@SYMTestPriority Medium
@SYMTestActions Creating a database and 3 tables (A, B & C), running 3 actions on it and then deleting
the database (5 actions in total). Whether the actions are allowed or not is decided on the capabilities
that the database has (stated in the MMP file) relative to the capabilities that are needed to perform
certain actions (stated in the .spd file).
@SYMTestExpectedResults The test must not fail.
@SYMDEF DEF065282
*/
static void DefectTestL()
	{
	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-1361 An app with \"UserEnvironment\" capabilities set\n "));

	TheTest.Printf(_L("Test 1: Create tables\n"));
	//The tests must pass, because the test app has "SCHEMA" capability
	CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
	TInt err = TheDb.CreateTable(KTblNameA, *colset);
	TEST2(err, KErrNone);
	err = TheDb.CreateTable(KTblNameB, *colset);
	TEST2(err, KErrNone);
	err = TheDb.CreateTable(KTblNameC, *colset);
	TEST2(err, KErrNone);
	CleanupStack::PopAndDestroy(colset);

	TheTest.Printf(_L("Test 2: Opening the tables in insert-only mode\n"));
	//The tests must pass because the test app has "WRITE" capability
	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EInsertOnly);
	TEST2(err, KErrNone);
	TheTbl.Close();
	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EInsertOnly);
	TEST2(err, KErrNone);
	TheTbl.Close();
	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EInsertOnly);
	TEST2(err, KErrNone);
	TheTbl.Close();

	TheTest.Printf(_L("Test 3: An attempt to open tables in read-only mode\n"));
	//The tests must not pass because the test app does not have "READ" capability.
	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
	TEST2(err, KErrPermissionDenied);
	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
	TEST2(err, KErrPermissionDenied);
	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
	TEST2(err, KErrPermissionDenied);
	TheTbl.Close();
	}

TInt E32Main()
    {
	__UHEAP_MARK;
	CTrapCleanup* tc = CTrapCleanup::New();
	TEST(tc != NULL);

	TInt err = TheDbs.Connect();
	TEST2(err, KErrNone);

	TBuf<32> format;
	format.Copy(KSecure);
	format.Append(KSecureDbUid.Name());

	//Make sure there is no previous instance of the database.
	TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
	TheTest.Printf(_L("Create a database\n"));
	err = TheDb.Create(TheDbs, KDbName, format);
	TEST2(err, KErrNone);

	TRAP(err, ::DefectTestL());
	TEST2(err, KErrNone);

	TheTbl.Close();
	TheDb.Close();
	// Remove the database that was created during the tests
	TheTest.Printf(_L("Delete the database\n"));
	err = TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
	TEST2(err, KErrNone);
	TheDbs.Close();

	TheTest.End();
	TheTest.Close();

	delete tc;

	__UHEAP_MARKEND;
	User::Heap().Check();
	return KErrNone;
    }