1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dbplatsecperf.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,324 @@
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 +// DBMS security policy - performance tests
1.18 +// Please, ensure that t_dbenvcreate test is executed before t_dbplatsec<N>/t_dbplatsecperf tests!
1.19 +// Please, ensure that t_dbenvdestroy test is executed after t_dbplatsec<N>/t_dbplatsecperf tests!
1.20 +//
1.21 +//
1.22 +
1.23 +#include <e32test.h>
1.24 +#include "t_dbplatsecutl.h"
1.25 +
1.26 +static RTest TheTest(_L("t_dbplatsecperf: DBMS platform security - Performance test"));
1.27 +
1.28 +static RDbs TheDbs;
1.29 +static RDbNamedDatabase TheDb;
1.30 +
1.31 +const TUid KSecureDbUid = {0x11335579};
1.32 +_LIT(KSecure, "SECURE");
1.33 +_LIT(KDbNameC, "C:TestDB.DB");
1.34 +_LIT(KTblNameA, "A");
1.35 +_LIT(KTblNameB, "B");
1.36 +_LIT(KTblNameC, "C");
1.37 +_LIT(KDbDirNSC, "C:\\DBMS-TST\\");
1.38 +_LIT(KDbNameNSC,"C:\\DBMS-TST\\TestDB.DB");
1.39 +
1.40 +static void DeleteNsDb()
1.41 + {
1.42 + RFs fileSess;
1.43 + if(fileSess.Connect() == KErrNone)
1.44 + {
1.45 + fileSess.Delete(KDbNameNSC);
1.46 + }
1.47 + fileSess.Close();
1.48 + }
1.49 +
1.50 +static void CleanupTest()
1.51 + {
1.52 + ::DeleteNsDb();
1.53 + }
1.54 +
1.55 +TDBSCUtils TheDbscUtils(TheTest, &CleanupTest);
1.56 +
1.57 +const TInt KGetPolicyCallCnt = 10000;
1.58 +const TInt KInsertRecCnt = 10000;
1.59 +
1.60 +//Measures the performance of RDbs::GetDatabasePolicy() and RDbs::GetTablePolicy() calls.
1.61 +//The DBMS server session kept alive during the test.
1.62 +static void GetPolicyTest1()
1.63 + {
1.64 + TUint time = User::TickCount();
1.65 + RDbs::TPolicyType tblPolicyType[2] = {RDbs::EReadPolicy, RDbs::EWritePolicy};
1.66 + TSecurityPolicy dbPolicy;
1.67 + TSecurityPolicy tblPolicy;
1.68 + TInt i, k;
1.69 + for(i=0,k=0;i<KGetPolicyCallCnt;++i,k=(k+1)%2)
1.70 + {
1.71 + TInt err = TheDbs.GetDatabasePolicy(KSecureDbUid, tblPolicyType[k], dbPolicy);
1.72 + TEST2(err, KErrNone);
1.73 + err = TheDbs.GetTablePolicy(KSecureDbUid, KTblNameA, tblPolicyType[k], tblPolicy);
1.74 + TEST2(err, KErrNone);
1.75 + }
1.76 + time = User::TickCount() - time;
1.77 + TheTest.Printf(_L("GetDatabasePolicy(), GetTablePolicy(). Time=%d\r\n"), time);
1.78 + }
1.79 +
1.80 +//Measures the performance of RDbs::GetTablePolicies() call.
1.81 +//The DBMS server session connected before each GetTablePolicies() call and disconnected
1.82 +//after the call.
1.83 +static void GetPolicyTest2()
1.84 + {
1.85 + TheDbs.Close();
1.86 + TUint time = User::TickCount();
1.87 + RDbs::TPolicyType tblPolicyType[2] = {RDbs::EReadPolicy, RDbs::EWritePolicy};
1.88 + TSecurityPolicy dbPolicy;
1.89 + TSecurityPolicy tblPolicy;
1.90 + TInt i, k;
1.91 + for(i=0,k=0;i<KGetPolicyCallCnt;++i,k=(k+1)%2)
1.92 + {
1.93 + TInt err = TheDbs.Connect();
1.94 + TEST2(err, KErrNone);
1.95 + err = TheDbs.GetTablePolicies(KSecureDbUid, KTblNameA, tblPolicyType[k], dbPolicy, tblPolicy);
1.96 + TEST2(err, KErrNone);
1.97 + TheDbs.Close();
1.98 + }
1.99 + time = User::TickCount() - time;
1.100 + TheTest.Printf(_L("GetTablePolicies(). Time=%d\r\n"), time);
1.101 + TInt err = TheDbs.Connect();
1.102 + TEST2(err, KErrNone);
1.103 + }
1.104 +
1.105 +//Measures the performance of RDbs::GetTablePolicies() call.
1.106 +//The DBMS server session kept alive during the test.
1.107 +static void GetPolicyTest3()
1.108 + {
1.109 + TUint time = User::TickCount();
1.110 + RDbs::TPolicyType tblPolicyType[2] = {RDbs::EReadPolicy, RDbs::EWritePolicy};
1.111 + TSecurityPolicy dbPolicy;
1.112 + TSecurityPolicy tblPolicy;
1.113 + TInt i, k;
1.114 + for(i=0,k=0;i<KGetPolicyCallCnt;++i,k=(k+1)%2)
1.115 + {
1.116 + TInt err = TheDbs.GetTablePolicies(KSecureDbUid, KTblNameA, tblPolicyType[k], dbPolicy, tblPolicy);
1.117 + TEST2(err, KErrNone);
1.118 + }
1.119 + time = User::TickCount() - time;
1.120 + TheTest.Printf(_L("GetTablePolicies(). Time=%d\r\n"), time);
1.121 + }
1.122 +
1.123 +static void CreateNonsecureDbL()
1.124 + {
1.125 + TColDef const KColumns[]=
1.126 + {
1.127 + {_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
1.128 + {_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
1.129 + {_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
1.130 + {0}
1.131 + };
1.132 + RFs fileSess;
1.133 + CleanupClosePushL(fileSess);
1.134 + TInt err = fileSess.Connect();
1.135 + TEST2(err, KErrNone);
1.136 +
1.137 + err = fileSess.MkDir(KDbDirNSC);
1.138 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.139 +
1.140 + RDbNamedDatabase db;
1.141 + err = db.Create(fileSess, KDbNameNSC);
1.142 + TEST2(err, KErrNone);
1.143 + CleanupClosePushL(db);
1.144 + err = db.Open(fileSess, KDbNameNSC);
1.145 +
1.146 + CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
1.147 + err = db.CreateTable(KTblNameA, *colset);
1.148 + TEST2(err, KErrNone);
1.149 + err = db.CreateTable(KTblNameB, *colset);
1.150 + TEST2(err, KErrNone);
1.151 + err = db.CreateTable(KTblNameC, *colset);
1.152 + TEST2(err, KErrNone);
1.153 +
1.154 + CleanupStack::PopAndDestroy(colset);
1.155 + CleanupStack::PopAndDestroy(&db);
1.156 + CleanupStack::PopAndDestroy(&fileSess);
1.157 + }
1.158 +
1.159 +static void DoInsertRecL(RDbNamedDatabase& aDb, RDbTable& aTbl)
1.160 + {
1.161 + TUint time = User::TickCount();
1.162 + TInt err = aDb.Begin();
1.163 + TEST2(err, KErrNone);
1.164 + for(TInt i=0;i<KInsertRecCnt;++i)
1.165 + {
1.166 + aTbl.InsertL();
1.167 + aTbl.SetColL(2, i);
1.168 + aTbl.SetColL(3, i);
1.169 + aTbl.PutL();
1.170 + }
1.171 + err = aDb.Commit();
1.172 + TEST2(err, KErrNone);
1.173 + time = User::TickCount() - time;
1.174 + TheTest.Printf(_L("Insert. Time=%d\r\n"), time);
1.175 + }
1.176 +
1.177 +//Measures the performance of "Insert" operations in a non-secure database.
1.178 +static void InsertRec1L()
1.179 + {
1.180 + RDbNamedDatabase db;
1.181 + CleanupClosePushL(db);
1.182 + TInt err = db.Open(TheDbs, KDbNameNSC);
1.183 + TEST2(err, KErrNone);
1.184 +
1.185 + RDbTable tblA;
1.186 + CleanupClosePushL(tblA);
1.187 + err = tblA.Open(db, KTblNameA);
1.188 + TEST2(err, KErrNone);
1.189 +
1.190 + ::DoInsertRecL(db, tblA);
1.191 +
1.192 + CleanupStack::PopAndDestroy(&tblA);
1.193 + CleanupStack::PopAndDestroy(&db);
1.194 + }
1.195 +
1.196 +//Measures the performance of "Insert" operations in a secure shared database.
1.197 +static void InsertRec2L()
1.198 + {
1.199 + TBuf<32> format;
1.200 + format.Copy(KSecure);
1.201 + format.Append(KSecureDbUid.Name());
1.202 +
1.203 + CleanupClosePushL(TheDb);
1.204 + TInt err = TheDb.Open(TheDbs, KDbNameC, format);
1.205 + TEST2(err, KErrNone);
1.206 +
1.207 + RDbTable tblA;
1.208 + CleanupClosePushL(tblA);
1.209 + err = tblA.Open(TheDb, KTblNameA);
1.210 + TEST2(err, KErrNone);
1.211 +
1.212 + ::DoInsertRecL(TheDb, tblA);
1.213 +
1.214 + CleanupStack::PopAndDestroy(&tblA);
1.215 + CleanupStack::PopAndDestroy(&TheDb);
1.216 + }
1.217 +
1.218 +//Measures the performance of "Update" SQL operations in a non-secure database.
1.219 +static void UpdateRec1L()
1.220 + {
1.221 + RDbNamedDatabase db;
1.222 + CleanupClosePushL(db);
1.223 + TInt err = db.Open(TheDbs, KDbNameNSC);
1.224 + TEST2(err, KErrNone);
1.225 +
1.226 + TUint time = User::TickCount();
1.227 +
1.228 + err = db.Begin();
1.229 + TEST2(err, KErrNone);
1.230 +
1.231 + TInt cnt = db.Execute(_L("UPDATE A SET DATA1=10, DATA2=20 WHERE ID >= 0"));
1.232 + TEST(cnt > 0);
1.233 +
1.234 + err = db.Commit();
1.235 + TEST2(err, KErrNone);
1.236 +
1.237 + time = User::TickCount() - time;
1.238 + TheTest.Printf(_L("Update. Time=%d\r\n"), time);
1.239 +
1.240 + CleanupStack::PopAndDestroy(&db);
1.241 + }
1.242 +
1.243 +//Measures the performance of "Update" SQL operations in a secure shared database.
1.244 +static void UpdateRec2L()
1.245 + {
1.246 + TBuf<32> format;
1.247 + format.Copy(KSecure);
1.248 + format.Append(KSecureDbUid.Name());
1.249 +
1.250 + CleanupClosePushL(TheDb);
1.251 + TInt err = TheDb.Open(TheDbs, KDbNameC, format);
1.252 + TEST2(err, KErrNone);
1.253 +
1.254 + TUint time = User::TickCount();
1.255 +
1.256 + err = TheDb.Begin();
1.257 + TEST2(err, KErrNone);
1.258 +
1.259 + TInt cnt = TheDb.Execute(_L("UPDATE A SET DATA1=10, DATA2=20 WHERE ID >= 0"));
1.260 + TEST(cnt > 0);
1.261 +
1.262 + err = TheDb.Commit();
1.263 + TEST2(err, KErrNone);
1.264 +
1.265 + time = User::TickCount() - time;
1.266 + TheTest.Printf(_L("Update. Time=%d\r\n"), time);
1.267 +
1.268 + CleanupStack::PopAndDestroy(&TheDb);
1.269 + }
1.270 +
1.271 +/**
1.272 +@SYMTestCaseID SYSLIB-DBMS-CT-0020
1.273 +@SYMTestCaseDesc DBMS security - performance tests. Insert/Update and Get<AAA>Policy
1.274 + operations performance measured for non-secure and secure shared database.
1.275 +@SYMTestPriority High
1.276 +@SYMTestActions RDbs::GetDatabasePolicy(), Rdbs::GetTablePolicy() and RDbs::GetTablePolicies()
1.277 + calls measured.
1.278 + RDBTable: insert operation measured, SQL: update operation measured.
1.279 +@SYMTestExpectedResults The test must not fail.
1.280 +@SYMREQ REQ2429
1.281 + DBMS shall provide an API to apply security policies to database tables.
1.282 +*/
1.283 +static void DoRunL()
1.284 + {
1.285 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0020 GetPolicy performance test "));
1.286 + ::GetPolicyTest1();
1.287 + ::GetPolicyTest2();
1.288 + ::GetPolicyTest3();
1.289 +
1.290 + ::CreateNonsecureDbL();
1.291 +
1.292 + TheTest.Next(_L("Insert records performance test"));
1.293 + InsertRec1L();
1.294 + InsertRec2L();
1.295 +
1.296 + TheTest.Next(_L("Update records performance test"));
1.297 + ::UpdateRec1L();
1.298 + ::UpdateRec2L();
1.299 + }
1.300 +
1.301 +TInt E32Main()
1.302 + {
1.303 + __UHEAP_MARK;
1.304 + CTrapCleanup* tc = CTrapCleanup::New();
1.305 + TEST(tc != NULL);
1.306 +
1.307 + TInt err = TheDbs.Connect();
1.308 + TEST2(err, KErrNone);
1.309 +
1.310 + ::DeleteNsDb();
1.311 +
1.312 + TRAP(err, ::DoRunL());
1.313 + TEST2(err, KErrNone);
1.314 +
1.315 + TheDb.Close();
1.316 + TheDbs.Close();
1.317 + ::CleanupTest();
1.318 +
1.319 + TheTest.End();
1.320 + TheTest.Close();
1.321 +
1.322 + delete tc;
1.323 +
1.324 + __UHEAP_MARKEND;
1.325 + User::Heap().Check();
1.326 + return KErrNone;
1.327 + }