1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dbplatsectbl.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 - testing new APIs - table level.
1.18 +// All tests assume that drive C is presented in the system and is not a ROM drive.
1.19 +//
1.20 +//
1.21 +
1.22 +#include "t_dbplatsecutl.h"
1.23 +#include "t_dbplatsecdef.h"
1.24 +#include "t_dbplatsectbl.h"
1.25 +
1.26 +static TColDef const KColumns[]=
1.27 + {
1.28 + {_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
1.29 + {_S("DATA1"), EDbColInt32, TDbCol::ENotNull},
1.30 + {_S("DATA2"), EDbColInt32, TDbCol::ENotNull},
1.31 + {0}
1.32 + };
1.33 +
1.34 +static TColDef const KColumns2[]=
1.35 + {
1.36 + {_S("ID"), EDbColInt32, TDbCol::ENotNull | TDbCol::EAutoIncrement},
1.37 + {_S("DATA1"), EDbColLongBinary},
1.38 + {0}
1.39 + };
1.40 +
1.41 +static void TblCallTestL()
1.42 + {
1.43 + TheTest.Next(_L("Open()"));
1.44 + TInt err = TheTbl1.Open(TheDb1, KTableName1);
1.45 + TEST2(err, KErrNone);
1.46 +
1.47 + TheTest.Next(_L("ColSetL()"));
1.48 + CDbColSet* colset = TheTbl1.ColSetL();
1.49 + TInt cnt = colset->Count();
1.50 + TInt i;
1.51 + for(i=0;i<cnt;++i)
1.52 + {
1.53 + const TDbCol& dbc = (*colset)[i + 1];
1.54 + TheTest.Printf(_L("%02d, %S\n"), i + 1, &dbc.iName);
1.55 + }
1.56 + delete colset;
1.57 +
1.58 + TheTest.Next(_L("ColDef()"));
1.59 + TDbCol dbcol = TheTbl1.ColDef(1);
1.60 + TheTest.Printf(_L("%S\n"), &dbcol.iName);
1.61 +
1.62 + TheTest.Next(_L("InsertL()/SetColL()/PutL()"));
1.63 + TheTbl1.InsertL();
1.64 + TheTbl1.SetColL(2, 1);
1.65 + TheTbl1.SetColL(3, 2);
1.66 + TheTbl1.PutL();
1.67 + TheTbl1.InsertL();
1.68 + TheTbl1.SetColL(2, 3);
1.69 + TheTbl1.SetColL(3, 4);
1.70 + TheTbl1.PutL();
1.71 +
1.72 + TheTest.Next(_L("AtRow()/AtBeginning()/AtEnd()"));
1.73 + (void)TheTbl1.AtRow();
1.74 + (void)TheTbl1.AtBeginning();
1.75 + (void)TheTbl1.AtEnd();
1.76 +
1.77 + TheTest.Next(_L("BeginningL()/EndL()"));
1.78 + TheTbl1.BeginningL();
1.79 + TheTbl1.EndL();
1.80 +
1.81 + TheTest.Next(_L("FirstL()/LastL()/PreviousL()/PreviousL()"));
1.82 + TBool res = TheTbl1.FirstL();
1.83 + TEST(res);
1.84 + TheTbl1.GetL();
1.85 + TInt32 val1 = TheTbl1.ColInt32(1);
1.86 + TInt32 val2 = TheTbl1.ColInt32(2);
1.87 + TInt32 val3 = TheTbl1.ColInt32(3);
1.88 + TEST(val1 == 0);
1.89 + TEST(val2 == 1);
1.90 + TEST(val3 == 2);
1.91 +
1.92 + res = TheTbl1.LastL();
1.93 + TEST(res);
1.94 + TheTbl1.GetL();
1.95 + val1 = TheTbl1.ColInt32(1);
1.96 + val2 = TheTbl1.ColInt32(2);
1.97 + val3 = TheTbl1.ColInt32(3);
1.98 + TEST(val1 == 1);
1.99 + TEST(val2 == 3);
1.100 + TEST(val3 == 4);
1.101 +
1.102 + res = TheTbl1.PreviousL();
1.103 + TEST(res);
1.104 + TheTbl1.GetL();
1.105 + val1 = TheTbl1.ColInt32(1);
1.106 + val2 = TheTbl1.ColInt32(2);
1.107 + val3 = TheTbl1.ColInt32(3);
1.108 + TEST(val1 == 0);
1.109 + TEST(val2 == 1);
1.110 + TEST(val3 == 2);
1.111 +
1.112 + res = TheTbl1.NextL();
1.113 + TEST(res);
1.114 + TheTbl1.GetL();
1.115 + val1 = TheTbl1.ColInt32(1);
1.116 + val2 = TheTbl1.ColInt32(2);
1.117 + val3 = TheTbl1.ColInt32(3);
1.118 + TEST(val1 == 1);
1.119 + TEST(val2 == 3);
1.120 + TEST(val3 == 4);
1.121 +
1.122 + TheTest.Next(_L("UpdateL()"));
1.123 + TheTbl1.UpdateL();
1.124 + TheTbl1.SetColL(2, 33);
1.125 + TheTbl1.SetColL(3, 44);
1.126 + TheTbl1.PutL();
1.127 +
1.128 + TheTest.Next(_L("Cancel()"));
1.129 + TheTbl1.UpdateL();
1.130 + TheTbl1.SetColL(2, 36);
1.131 + TheTbl1.SetColL(3, 47);
1.132 + TheTbl1.Cancel();
1.133 +
1.134 + TheTest.Next(_L("DeleteL()"));
1.135 + TheTbl1.DeleteL();
1.136 +
1.137 + TheTest.Next(_L("IsColNull()"));
1.138 + CDbColSet* colset2 = TDBSCUtils::CreateColSetLC(KColumns2);
1.139 + _LIT(KTempTblName, "TempTbl");
1.140 + err = TheDb1.CreateTable(KTempTblName, *colset2);
1.141 + TEST2(err, KErrNone);
1.142 + CleanupStack::PopAndDestroy(colset2);
1.143 +
1.144 + err = TheTbl2.Open(TheDb1, KTempTblName);
1.145 + TEST2(err, KErrNone);
1.146 +
1.147 + TheTbl2.InsertL();
1.148 + _LIT8(KTestData, "");
1.149 + TheTbl2.SetColL(2, KTestData);
1.150 + TheTbl2.PutL();
1.151 +
1.152 + TheTbl2.Close();
1.153 + err = TheTbl2.Open(TheDb1, KTempTblName);
1.154 + TEST2(err, KErrNone);
1.155 + res = TheTbl2.FirstL();
1.156 + TEST(res);
1.157 + TheTbl2.GetL();
1.158 + res = TheTbl2.IsColNull(2);
1.159 + TEST(res);
1.160 + TheTbl2.Close();
1.161 +
1.162 + TheTest.Next(_L("ColSize()"));
1.163 + res = TheTbl1.FirstL();
1.164 + TEST(res);
1.165 + TheTbl1.GetL();
1.166 + res = TheTbl1.ColSize(1);
1.167 + TEST(res);
1.168 +
1.169 + TheTest.Next(_L("ColLength()"));
1.170 + TInt len = TheTbl1.ColLength(1);
1.171 + TEST(len > 0);
1.172 +
1.173 + TheTbl1.InsertL();
1.174 + TheTbl1.SetColL(2, 3);
1.175 + TheTbl1.SetColL(3, 4);
1.176 + TheTbl1.PutL();
1.177 +
1.178 + TheTest.Next(_L("GotoL(TPosition)"));
1.179 + res = TheTbl1.GotoL(RDbRowSet::EFirst);
1.180 + TEST(res);
1.181 +
1.182 + TheTest.Next(_L("Bookmark()/GotoL(TDbBookmark)"));
1.183 + TDbBookmark bkmk = TheTbl1.Bookmark();
1.184 + res = TheTbl1.NextL();
1.185 + TEST(res);
1.186 + TheTbl1.GotoL(bkmk);
1.187 + TheTbl1.GetL();
1.188 + val1 = TheTbl1.ColInt32(1);
1.189 + TEST(val1 == 0);
1.190 +
1.191 + TheTest.Next(_L("CountL()/IsEmptyL()"));
1.192 + cnt = TheTbl1.CountL();
1.193 + TEST(cnt == 2);
1.194 + res = TheTbl1.IsEmptyL();
1.195 + TEST(!res);
1.196 +
1.197 + TheTest.Next(_L("MatchL()"));
1.198 + RDbRowConstraint match;
1.199 + CleanupClosePushL(match);
1.200 + err = match.Open(TheTbl1, TDbQuery(_L("ID > 0")));
1.201 + TEST2(err, KErrNone);
1.202 + res = EFalse;
1.203 + TheTbl1.BeginningL();
1.204 + while(TheTbl1.NextL())
1.205 + {
1.206 + if(TheTbl1.MatchL(match))
1.207 + {
1.208 + res = ETrue;
1.209 + }
1.210 + }
1.211 + CleanupStack::PopAndDestroy(&match);
1.212 + TEST(res);
1.213 +
1.214 + TheTest.Next(_L("FindL()"));
1.215 + res = TheTbl1.FirstL();
1.216 + TEST(res);
1.217 + err = TheTbl1.FindL(RDbRowSet::EForwards, TDbQuery(_L("ID <> 0")));
1.218 + TEST(err >= 0);
1.219 + TheTbl1.GetL();
1.220 + val1 = TheTbl1.ColInt32(1);
1.221 + TEST(val1 > 0);
1.222 +
1.223 + _LIT8(KTestData2, "0123456789");
1.224 + HBufC8* buf = HBufC8::NewLC(10000);
1.225 + TPtr8 ptr = buf->Des();
1.226 + for(i=0;i<1000;++i)
1.227 + {
1.228 + ptr += KTestData2();
1.229 + }
1.230 +
1.231 + TheTest.Next(_L("RDbColReadStream"));
1.232 + err = TheTbl2.Open(TheDb1, KTempTblName);
1.233 + TEST2(err, KErrNone);
1.234 +
1.235 + TheTbl2.InsertL();
1.236 + TheTbl2.SetColL(2, *buf);
1.237 + TheTbl2.PutL();
1.238 +
1.239 + TheTbl2.InsertL();
1.240 + TheTbl2.SetColL(2, KTestData2);
1.241 + TheTbl2.PutL();
1.242 +
1.243 + res = TheTbl2.PreviousL();
1.244 + TEST(res);
1.245 + TheTbl2.GetL();
1.246 + RDbColReadStream rstream;
1.247 + rstream.OpenLC(TheTbl2, 2);
1.248 + ptr.Zero();
1.249 + rstream.ReadL(ptr, ptr.MaxLength());
1.250 + CleanupStack::PopAndDestroy(&rstream);
1.251 + TEST(ptr.Length() == ptr.MaxLength());
1.252 +
1.253 + TheTest.Next(_L("RDbColWriteStream"));
1.254 + TheTbl2.InsertL();
1.255 + RDbColWriteStream wstream;
1.256 + wstream.OpenLC(TheTbl2, 2);
1.257 + wstream.WriteL(ptr, ptr.Length());
1.258 + wstream.CommitL();
1.259 + CleanupStack::PopAndDestroy(&wstream);
1.260 + TheTbl2.PutL();
1.261 +
1.262 + TheTbl2.Close();
1.263 + CleanupStack::PopAndDestroy(buf);
1.264 +
1.265 + TheTbl1.Close();
1.266 + }
1.267 +
1.268 +static void ViewTestL()
1.269 + {
1.270 + RDbView view;
1.271 + CleanupClosePushL(view);
1.272 +
1.273 + TheTest.Next(_L("Prepare()"));
1.274 + TInt err = view.Prepare(TheDb1, TDbQuery(_L("SELECT * FROM ATbl")));
1.275 + TEST2(err, KErrNone);
1.276 +
1.277 + TheTest.Next(_L("Update()"));
1.278 + TBool res = view.FirstL();
1.279 + TEST(res);
1.280 + view.GetL();
1.281 + view.UpdateL();
1.282 + view.SetColL(2, 100);
1.283 + view.SetColL(3, 200);
1.284 + view.PutL();
1.285 +
1.286 + CleanupStack::PopAndDestroy(&view);
1.287 +
1.288 + TheTest.Next(_L("Prepare() with an update sql"));
1.289 + CleanupClosePushL(view);
1.290 + err = view.Prepare(TheDb1, TDbQuery(_L("UPDATE ATbl SET DATA1 = 400 WHERE ID = 0")));
1.291 + TEST2(err, KErrArgument);
1.292 + CleanupStack::PopAndDestroy(&view);
1.293 + }
1.294 +
1.295 +/**
1.296 +@SYMTestCaseID SYSLIB-DBMS-CT-0021
1.297 +@SYMTestCaseDesc RDbTable method calls test for a secure shared database.
1.298 + Every method of RDbTable class and its base class too, is called
1.299 + and the result - asserted.
1.300 +@SYMTestPriority High
1.301 +@SYMTestActions RDbTable method calls test.
1.302 +@SYMTestExpectedResults The test must not fail.
1.303 +@SYMREQ REQ2429
1.304 + DBMS shall provide an API to apply security policies to database tables.
1.305 +*/
1.306 +void DoTblTestL()
1.307 + {
1.308 + TheTest.Next(_L(" @SYMTestCaseID SYSLIB-DBMS-CT-0021 "));
1.309 +
1.310 + TDBSCUtils::DeleteDatabase(TheDbs, KSecureDbUid, KDb1Name);
1.311 +
1.312 + TheDb1.Close();
1.313 + TheDb1 = TDBSCUtils::CreateDatabase(TheDbs, KSecureDbUid, KDb1Name);
1.314 +
1.315 + CDbColSet* colset = TDBSCUtils::CreateColSetLC(KColumns);
1.316 + TInt err = TheDb1.CreateTable(KTableName1, *colset);
1.317 + TEST2(err, KErrNone);
1.318 + CleanupStack::PopAndDestroy(colset);
1.319 +
1.320 + TheTest.Next(_L("Table calls test"));
1.321 + ::TblCallTestL();
1.322 +
1.323 + TheTest.Next(_L("View test"));
1.324 + ::ViewTestL();
1.325 +
1.326 + TheDb1.Close();
1.327 + }