1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dblimit.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,311 @@
1.4 +// Copyright (c) 1998-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 +// MSVC++ up to 5.0 has problems with expanding inline functions
1.20 +// This disables the mad warnings for the whole project
1.21 +#if defined(NDEBUG) && defined(__VC32__) && _MSC_VER<=1100
1.22 +#pragma warning(disable : 4710) // function not expanded. MSVC 5.0 is stupid
1.23 +#endif
1.24 +
1.25 +#include <d32dbms.h>
1.26 +#include <e32test.h>
1.27 +#include <s32file.h>
1.28 +
1.29 +LOCAL_D CTrapCleanup* TheTrapCleanup;
1.30 +LOCAL_D RFs TheFs;
1.31 +LOCAL_D RDbs TheDbs;
1.32 +LOCAL_D RDbNamedDatabase TheDatabase;
1.33 +LOCAL_D RDbTable TheTable;
1.34 +LOCAL_D RDbView TheView;
1.35 +
1.36 +const TInt KTestCleanupStack=0x20;
1.37 +const TPtrC KTestDatabase=_L("C:\\DBMS-TST\\T_LIMIT.DB");
1.38 +const TPtrC KTableName(_S("TestTable"));
1.39 +
1.40 +const TPtrC KColFormat=_L("c%d");
1.41 +
1.42 +LOCAL_D RTest test(_L("t_dblimit - testing table limits"));
1.43 +
1.44 +const TInt KRecordLimit=8200;
1.45 +const TInt KMinInlineLimit=16;
1.46 +const TInt KMaxInlineLimit=255;
1.47 +
1.48 +// expected maxima for record structure
1.49 +const TInt KMaxColInt64NN=1025;
1.50 +const TInt KMaxColText8=32;
1.51 +const TInt KMaxColText16=16;
1.52 +const TInt KMaxColLongText8=504;
1.53 +
1.54 +
1.55 +LOCAL_C TBool FitBlob(TInt aCount)
1.56 +//
1.57 +// Matches heuristics in DBMS
1.58 +//
1.59 + {
1.60 + TInt used=(aCount*(2+(KMinInlineLimit<<3))+7)>>3;
1.61 + return used<=KRecordLimit;
1.62 + }
1.63 +
1.64 +LOCAL_C TInt InlineLimit(TInt aCount)
1.65 +//
1.66 +// Matches heuristics in DBMS
1.67 +//
1.68 + {
1.69 + TInt used=(aCount*(2+(KMinInlineLimit<<3))+7)>>3;
1.70 + TInt space=(KRecordLimit-used);//>>1;
1.71 + TInt inl=space/aCount+KMinInlineLimit-1;
1.72 + return Min(inl,KMaxInlineLimit);
1.73 + }
1.74 +
1.75 +LOCAL_C void OpenDatabase()
1.76 +//
1.77 +// Open the database
1.78 +//
1.79 + {
1.80 + test (TheDatabase.Open(TheDbs,KTestDatabase)==KErrNone);
1.81 + }
1.82 +
1.83 +LOCAL_C void CloseDatabase()
1.84 + {
1.85 + TheDatabase.Close();
1.86 + }
1.87 +
1.88 +LOCAL_C void CreateDatabase()
1.89 +//
1.90 +// Create the database-in-a-store
1.91 +//
1.92 + {
1.93 + test (TheDatabase.Replace(TheFs,KTestDatabase)==KErrNone);
1.94 + CloseDatabase();
1.95 + OpenDatabase();
1.96 + }
1.97 +
1.98 +LOCAL_C void DestroyDatabase()
1.99 + {
1.100 + test (TheDatabase.Destroy()==KErrNone);
1.101 + }
1.102 +
1.103 +LOCAL_C CDbColSet* SetLC(TDbCol& aCol,TInt aCount)
1.104 + {
1.105 + CDbColSet* set=CDbColSet::NewLC();
1.106 + TDbColName name;
1.107 + while (--aCount>=0)
1.108 + {
1.109 + name.Format(KColFormat,aCount);
1.110 + aCol.iName=name;
1.111 + set->AddL(aCol);
1.112 + }
1.113 + return set;
1.114 + }
1.115 +
1.116 +LOCAL_C TBool TestL(TDbCol& aCol,TInt aCount)
1.117 + {
1.118 + test.Printf(_L("\rtesting %d "),aCount);
1.119 + CDbColSet* set=SetLC(aCol,aCount);
1.120 + TInt r;
1.121 + r=TheDatabase.CreateTable(KTableName,*set);
1.122 + if (r==KErrNone)
1.123 + {
1.124 + CDbColSet* comp=TheDatabase.ColSetL(KTableName);
1.125 + test (comp->Count()==aCount);
1.126 + delete comp;
1.127 + }
1.128 + CleanupStack::PopAndDestroy();
1.129 + if (r==KErrTooBig)
1.130 + return EFalse;
1.131 + test (r==KErrNone);
1.132 + test (TheDatabase.DropTable(KTableName)==KErrNone);
1.133 + return ETrue;
1.134 + }
1.135 +
1.136 +/**
1.137 +See how many columns of this sort can be used
1.138 +
1.139 +@SYMTestCaseID SYSLIB-DBMS-CT-0631
1.140 +@SYMTestCaseDesc Tests for maximum limits on a Table
1.141 +@SYMTestPriority Medium
1.142 +@SYMTestActions Tests for creating a table with maximum number of columns
1.143 +@SYMTestExpectedResults Test must not fail
1.144 +@SYMREQ REQ0000
1.145 +*/
1.146 +LOCAL_C TInt TestTypeL(TDbCol& aCol)
1.147 + {
1.148 + CreateDatabase();
1.149 + TInt ii=1;
1.150 + for (;;)
1.151 + {
1.152 + if (!TestL(aCol,ii))
1.153 + break;
1.154 + ii<<=1;
1.155 + }
1.156 + TInt lim=ii>>=1;
1.157 + test (lim>0);
1.158 + while ((ii>>=1)>0)
1.159 + { // ok<=max<ok+ii*2
1.160 + if (TestL(aCol,lim+ii))
1.161 + lim+=ii;
1.162 + }
1.163 + DestroyDatabase();
1.164 + test.Printf(_L("\r create %d \n"),lim);
1.165 + return lim;
1.166 + }
1.167 +
1.168 +LOCAL_C void StretchRecordL()
1.169 + {
1.170 + CreateDatabase();
1.171 + TDbCol col;
1.172 + col.iType=EDbColLongText8;
1.173 + col.iMaxLength=KDbUndefinedLength;
1.174 + col.iAttributes=0;
1.175 + for (TInt ii=4;FitBlob(ii);ii+=4)
1.176 + {
1.177 + test.Printf(_L("\rtesting %d "),ii);
1.178 + CDbColSet* set=SetLC(col,ii);
1.179 + if (ii==4)
1.180 + test (TheDatabase.CreateTable(KTableName,*set)==KErrNone);
1.181 + else
1.182 + test (TheDatabase.AlterTable(KTableName,*set)==KErrNone);
1.183 + CleanupStack::PopAndDestroy();
1.184 + test (TheTable.Open(TheDatabase,KTableName)==KErrNone);
1.185 + if (ii==4)
1.186 + TheTable.InsertL();
1.187 + else
1.188 + {
1.189 + TheTable.FirstL();
1.190 + TheTable.UpdateL();
1.191 + }
1.192 + TBuf8<256> buf;
1.193 + buf.Fill('-',InlineLimit(ii)/*>>1*/);
1.194 + TPtrC8 ptr((const TUint8*)buf.Ptr(),buf.Size());
1.195 + TheTable.SetColL(ii-3,ptr);
1.196 + TheTable.SetColL(ii-2,ptr);
1.197 + TheTable.SetColL(ii-1,ptr);
1.198 + TheTable.SetColL(ii,ptr);
1.199 + TheTable.PutL();
1.200 + TheTable.Close();
1.201 +// if ((ii&0x1c)==0)
1.202 +// test (TheDatabase.Compact()==KErrNone);
1.203 + }
1.204 + test (TheDatabase.Compact()==KErrNone);
1.205 + test.Printf(_L("\n"));
1.206 + CloseDatabase();
1.207 + }
1.208 +
1.209 +LOCAL_C void doMainL()
1.210 + {
1.211 + test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0631 TInt64 NOT NULL "));
1.212 + TDbCol col;
1.213 + col.iType=EDbColInt64;
1.214 + col.iMaxLength=KDbUndefinedLength;
1.215 + col.iAttributes=TDbCol::ENotNull;
1.216 + test (TestTypeL(col)==KMaxColInt64NN);
1.217 + test.Next(_L("Text8"));
1.218 + col.iType=EDbColText8;
1.219 + col.iAttributes=0;
1.220 + test (TestTypeL(col)==KMaxColText8);
1.221 + test.Next(_L("Text16"));
1.222 + col.iType=EDbColText16;
1.223 + test (TestTypeL(col)==KMaxColText16);
1.224 + test.Next(_L("LongText8"));
1.225 + col.iType=EDbColLongText8;
1.226 + test (TestTypeL(col)==KMaxColLongText8);
1.227 + test.Next(_L("Stretching the record"));
1.228 + StretchRecordL();
1.229 + }
1.230 +
1.231 +LOCAL_C void setupTestDirectory()
1.232 +//
1.233 +// Prepare the test directory.
1.234 +//
1.235 + {
1.236 + TInt r=TheFs.Connect();
1.237 + test(r==KErrNone);
1.238 +//
1.239 + r=TheFs.MkDir(KTestDatabase);
1.240 + test(r==KErrNone || r==KErrAlreadyExists);
1.241 + }
1.242 +
1.243 +LOCAL_C void setupCleanup()
1.244 +//
1.245 +// Initialise the cleanup stack.
1.246 +//
1.247 + {
1.248 + TheTrapCleanup=CTrapCleanup::New();
1.249 + test(TheTrapCleanup!=NULL);
1.250 + TRAPD(r,\
1.251 + {\
1.252 + for (TInt i=KTestCleanupStack;i>0;i--)\
1.253 + CleanupStack::PushL((TAny*)0);\
1.254 + CleanupStack::Pop(KTestCleanupStack);\
1.255 + });
1.256 + test(r==KErrNone);
1.257 + }
1.258 +
1.259 +LOCAL_C void DeleteDataFile(const TDesC& aFullName)
1.260 + {
1.261 + RFs fsSession;
1.262 + TInt err = fsSession.Connect();
1.263 + if(err == KErrNone)
1.264 + {
1.265 + TEntry entry;
1.266 + if(fsSession.Entry(aFullName, entry) == KErrNone)
1.267 + {
1.268 + RDebug::Print(_L("Deleting \"%S\" file.\n"), &aFullName);
1.269 + err = fsSession.SetAtt(aFullName, 0, KEntryAttReadOnly);
1.270 + if(err != KErrNone)
1.271 + {
1.272 + RDebug::Print(_L("Error %d changing \"%S\" file attributes.\n"), err, &aFullName);
1.273 + }
1.274 + err = fsSession.Delete(aFullName);
1.275 + if(err != KErrNone)
1.276 + {
1.277 + RDebug::Print(_L("Error %d deleting \"%S\" file.\n"), err, &aFullName);
1.278 + }
1.279 + }
1.280 + fsSession.Close();
1.281 + }
1.282 + else
1.283 + {
1.284 + RDebug::Print(_L("Error %d connecting file session. File: %S.\n"), err, &aFullName);
1.285 + }
1.286 + }
1.287 +
1.288 +GLDEF_C TInt E32Main()
1.289 +//
1.290 +// Test streaming conversions.
1.291 +//
1.292 + {
1.293 + test.Title();
1.294 + setupTestDirectory();
1.295 + setupCleanup();
1.296 + test (TheDbs.Connect()==KErrNone);
1.297 + __UHEAP_MARK;
1.298 +//
1.299 + TRAPD(r,doMainL();)
1.300 + test(r==KErrNone);
1.301 +
1.302 + ::DeleteDataFile(KTestDatabase); //deletion of data files must be done before call to end - DEF047652
1.303 + test.End();
1.304 +//
1.305 + __UHEAP_MARKEND;
1.306 + delete TheTrapCleanup;
1.307 +
1.308 +
1.309 +
1.310 + TheDbs.Close();
1.311 + TheFs.Close();
1.312 + test.Close();
1.313 + return 0;
1.314 + }