1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dbnewcap1.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,136 @@
1.4 +// Copyright (c) 2004-2009 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +//
1.18 +
1.19 +//The test uses C:TESTDB.DB secure shared database, which creates tables A, B and C.
1.20 +#include <e32test.h>
1.21 +#include <d32dbms.h>
1.22 +#include "t_dbplatsecutl.h"
1.23 +
1.24 +//The .spd file has the following capabilities:
1.25 +// Schema None
1.26 +// Read SurroundingsDD
1.27 +// Write UserEnvironment
1.28 +const TUid KSecureDbUid = {0x12344321};
1.29 +
1.30 +_LIT(KSecure, "SECURE");
1.31 +_LIT(KDbName, "C:TestDB.DB");
1.32 +_LIT(KTblNameA, "A");
1.33 +_LIT(KTblNameB, "B");
1.34 +_LIT(KTblNameC, "C");
1.35 +
1.36 +static RTest TheTest(_L("t_dbnewcap1"));
1.37 +static RDbs TheDbs;
1.38 +static RDbNamedDatabase TheDb;
1.39 +static RDbTable TheTbl;
1.40 +
1.41 +TDBSCUtils TheDbscUtils(TheTest, NULL);
1.42 +
1.43 +static TColDef const KColumns[]=
1.44 + {
1.45 + {_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
1.46 + {_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
1.47 + {_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
1.48 + {0}
1.49 + };
1.50 +
1.51 +/**
1.52 +@SYMTestCaseID SYSLIB-DBMS-CT-1361
1.53 +@SYMTestCaseDesc Checking to make sure the .spd file used in this test has been created correctly and
1.54 +functions as it should.
1.55 +@SYMTestPriority Medium
1.56 +@SYMTestActions Creating a database and 3 tables (A, B & C), running 3 actions on it and then deleting
1.57 +the database (5 actions in total). Whether the actions are allowed or not is decided on the capabilities
1.58 +that the database has (stated in the MMP file) relative to the capabilities that are needed to perform
1.59 +certain actions (stated in the .spd file).
1.60 +@SYMTestExpectedResults The test must not fail.
1.61 +@SYMDEF DEF065282
1.62 +*/
1.63 +static void DefectTestL()
1.64 + {
1.65 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-1361 An app with \"UserEnvironment\" capabilities set\n "));
1.66 +
1.67 + TheTest.Printf(_L("Test 1: Create tables\n"));
1.68 + //The tests must pass, because the test app has "SCHEMA" capability
1.69 + CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
1.70 + TInt err = TheDb.CreateTable(KTblNameA, *colset);
1.71 + TEST2(err, KErrNone);
1.72 + err = TheDb.CreateTable(KTblNameB, *colset);
1.73 + TEST2(err, KErrNone);
1.74 + err = TheDb.CreateTable(KTblNameC, *colset);
1.75 + TEST2(err, KErrNone);
1.76 + CleanupStack::PopAndDestroy(colset);
1.77 +
1.78 + TheTest.Printf(_L("Test 2: Opening the tables in insert-only mode\n"));
1.79 + //The tests must pass because the test app has "WRITE" capability
1.80 + err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EInsertOnly);
1.81 + TEST2(err, KErrNone);
1.82 + TheTbl.Close();
1.83 + err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EInsertOnly);
1.84 + TEST2(err, KErrNone);
1.85 + TheTbl.Close();
1.86 + err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EInsertOnly);
1.87 + TEST2(err, KErrNone);
1.88 + TheTbl.Close();
1.89 +
1.90 + TheTest.Printf(_L("Test 3: An attempt to open tables in read-only mode\n"));
1.91 + //The tests must not pass because the test app does not have "READ" capability.
1.92 + err = TheTbl.Open(TheDb, KTblNameA, RDbRowSet::EReadOnly);
1.93 + TEST2(err, KErrPermissionDenied);
1.94 + err = TheTbl.Open(TheDb, KTblNameB, RDbRowSet::EReadOnly);
1.95 + TEST2(err, KErrPermissionDenied);
1.96 + err = TheTbl.Open(TheDb, KTblNameC, RDbRowSet::EReadOnly);
1.97 + TEST2(err, KErrPermissionDenied);
1.98 + TheTbl.Close();
1.99 + }
1.100 +
1.101 +TInt E32Main()
1.102 + {
1.103 + __UHEAP_MARK;
1.104 + CTrapCleanup* tc = CTrapCleanup::New();
1.105 + TEST(tc != NULL);
1.106 +
1.107 + TInt err = TheDbs.Connect();
1.108 + TEST2(err, KErrNone);
1.109 +
1.110 + TBuf<32> format;
1.111 + format.Copy(KSecure);
1.112 + format.Append(KSecureDbUid.Name());
1.113 +
1.114 + //Make sure there is no previous instance of the database.
1.115 + TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
1.116 + TheTest.Printf(_L("Create a database\n"));
1.117 + err = TheDb.Create(TheDbs, KDbName, format);
1.118 + TEST2(err, KErrNone);
1.119 +
1.120 + TRAP(err, ::DefectTestL());
1.121 + TEST2(err, KErrNone);
1.122 +
1.123 + TheTbl.Close();
1.124 + TheDb.Close();
1.125 + // Remove the database that was created during the tests
1.126 + TheTest.Printf(_L("Delete the database\n"));
1.127 + err = TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDbName);
1.128 + TEST2(err, KErrNone);
1.129 + TheDbs.Close();
1.130 +
1.131 + TheTest.End();
1.132 + TheTest.Close();
1.133 +
1.134 + delete tc;
1.135 +
1.136 + __UHEAP_MARKEND;
1.137 + User::Heap().Check();
1.138 + return KErrNone;
1.139 + }