sl@0: // Copyright (c) 2004-2009 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: //The test uses C:TESTDB.DB secure shared database, which creates tables A, B and C.
sl@0: #include <e32test.h>
sl@0: #include <d32dbms.h>
sl@0: #include "t_dbplatsecutl.h"
sl@0: 
sl@0: //The .spd file has the following capabilities:
sl@0: //	Schema	None
sl@0: //	Read	SurroundingsDD
sl@0: //	Write	UserEnvironment
sl@0: const TUid KSecureDbUid = {0x12344321};
sl@0: 
sl@0: _LIT(KSecure,	"SECURE");
sl@0: _LIT(KDbName,	"C:TestDB.DB");
sl@0: _LIT(KTblNameA,	"A");
sl@0: _LIT(KTblNameB,	"B");
sl@0: _LIT(KTblNameC,	"C");
sl@0: 
sl@0: static RTest 				TheTest(_L("t_dbnewcap1"));
sl@0: static RDbs 				TheDbs;
sl@0: static RDbNamedDatabase 	TheDb;
sl@0: static RDbTable 			TheTbl;
sl@0: 
sl@0: TDBSCUtils 	TheDbscUtils(TheTest, NULL);
sl@0: 
sl@0: static TColDef const KColumns[]=
sl@0: 	{
sl@0: 	{_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
sl@0: 	{_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
sl@0: 	{_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
sl@0: 	{0}
sl@0: 	};
sl@0: 
sl@0: /**
sl@0: @SYMTestCaseID SYSLIB-DBMS-CT-1361
sl@0: @SYMTestCaseDesc Checking to make sure the .spd file used in this test has been created correctly and
sl@0: functions as it should.
sl@0: @SYMTestPriority Medium
sl@0: @SYMTestActions Creating a database and 3 tables (A, B & C), running 3 actions on it and then deleting
sl@0: the database (5 actions in total). Whether the actions are allowed or not is decided on the capabilities
sl@0: that the database has (stated in the MMP file) relative to the capabilities that are needed to perform
sl@0: certain actions (stated in the .spd file).
sl@0: @SYMTestExpectedResults The test must not fail.
sl@0: @SYMDEF DEF065282
sl@0: */
sl@0: static void DefectTestL()
sl@0: 	{
sl@0: 	TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-1361 An app with \"UserEnvironment\" capabilities set\n "));
sl@0: 
sl@0: 	TheTest.Printf(_L("Test 1: Create tables\n"));
sl@0: 	//The tests must pass, because the test app has "SCHEMA" capability
sl@0: 	CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
sl@0: 	TInt err = TheDb.CreateTable(KTblNameA, *colset);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.CreateTable(KTblNameB, *colset);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	err = TheDb.CreateTable(KTblNameC, *colset);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	CleanupStack::PopAndDestroy(colset);
sl@0: 
sl@0: 	TheTest.Printf(_L("Test 2: Opening the tables in insert-only mode\n"));
sl@0: 	//The tests must pass because the test app has "WRITE" capability
sl@0: 	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EInsertOnly);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheTbl.Close();
sl@0: 	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EInsertOnly);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheTbl.Close();
sl@0: 	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EInsertOnly);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheTbl.Close();
sl@0: 
sl@0: 	TheTest.Printf(_L("Test 3: An attempt to open tables in read-only mode\n"));
sl@0: 	//The tests must not pass because the test app does not have "READ" capability.
sl@0: 	err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
sl@0: 	TEST2(err, KErrPermissionDenied);
sl@0: 	TheTbl.Close();
sl@0: 	}
sl@0: 
sl@0: TInt E32Main()
sl@0:     {
sl@0: 	__UHEAP_MARK;
sl@0: 	CTrapCleanup* tc = CTrapCleanup::New();
sl@0: 	TEST(tc != NULL);
sl@0: 
sl@0: 	TInt err = TheDbs.Connect();
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TBuf<32> format;
sl@0: 	format.Copy(KSecure);
sl@0: 	format.Append(KSecureDbUid.Name());
sl@0: 
sl@0: 	//Make sure there is no previous instance of the database.
sl@0: 	TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
sl@0: 	TheTest.Printf(_L("Create a database\n"));
sl@0: 	err = TheDb.Create(TheDbs, KDbName, format);
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TRAP(err, ::DefectTestL());
sl@0: 	TEST2(err, KErrNone);
sl@0: 
sl@0: 	TheTbl.Close();
sl@0: 	TheDb.Close();
sl@0: 	// Remove the database that was created during the tests
sl@0: 	TheTest.Printf(_L("Delete the database\n"));
sl@0: 	err = TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
sl@0: 	TEST2(err, KErrNone);
sl@0: 	TheDbs.Close();
sl@0: 
sl@0: 	TheTest.End();
sl@0: 	TheTest.Close();
sl@0: 
sl@0: 	delete tc;
sl@0: 
sl@0: 	__UHEAP_MARKEND;
sl@0: 	User::Heap().Check();
sl@0: 	return KErrNone;
sl@0:     }