1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/dbms/tdbms/t_dbsql.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,1194 @@
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 <f32file.h>
1.27 +#include <e32test.h>
1.28 +#include <e32math.h>
1.29 +
1.30 +// constructing literal TInt64 from compiler 64 bit integer rep
1.31 +
1.32 +#ifndef I64LIT
1.33 +#if defined __GCC32__ || defined __EABI__
1.34 +#define _LINT64(val) MAKE_TINT64(TUint(val##LL>>32),TUint(val##LL&0xffffffffu))
1.35 +#else
1.36 +#define _LINT64(val) MAKE_TINT64(TUint(__int64(val)>>32),TUint(__int64(val)&0xffffffffu))
1.37 +#endif
1.38 +#else // I64LIT
1.39 +#define _LINT64 I64LIT
1.40 +#endif // I64LIT
1.41 +
1.42 +LOCAL_D RTest TheTest(_L("t_dbsql: DBMS SQL parsing and execution tests"));
1.43 +
1.44 +LOCAL_D RFs TheFs;
1.45 +LOCAL_D CTrapCleanup* TheTrapCleanup;
1.46 +LOCAL_D RDbs TheDbs;
1.47 +LOCAL_D RDbNamedDatabase TheDatabase;
1.48 +LOCAL_D RDbTable TheTable;
1.49 +LOCAL_D RDbView TheView;
1.50 +LOCAL_D TBuf<1024> TheSql;
1.51 +
1.52 +const TInt KTestCleanupStack=0x20;
1.53 +const TPtrC KTestDatabase=_L("c:\\dbms-tst\\t_sql.db");
1.54 +
1.55 +#define elementsof(array) (sizeof(array)/sizeof(array[0]))
1.56 +
1.57 +LOCAL_C void TestCleanup()
1.58 + {
1.59 + TheTable.Close();
1.60 + TheView.Close();
1.61 + TheDatabase.Close();
1.62 + TheDbs.Close();
1.63 + TheFs.Close();
1.64 + /////////////
1.65 + RFs fsSession;
1.66 + TInt err = fsSession.Connect();
1.67 + if(err == KErrNone)
1.68 + {
1.69 + TEntry entry;
1.70 + if(fsSession.Entry(KTestDatabase, entry) == KErrNone)
1.71 + {
1.72 + RDebug::Print(_L("Deleting \"%S\" file.\n"), &KTestDatabase);
1.73 + err = fsSession.SetAtt(KTestDatabase, 0, KEntryAttReadOnly);
1.74 + if(err != KErrNone)
1.75 + {
1.76 + RDebug::Print(_L("Error %d changing \"%S\" file attributes.\n"), err, &KTestDatabase);
1.77 + }
1.78 + err = fsSession.Delete(KTestDatabase);
1.79 + if(err != KErrNone)
1.80 + {
1.81 + RDebug::Print(_L("Error %d deleting \"%S\" file.\n"), err, &KTestDatabase);
1.82 + }
1.83 + }
1.84 + fsSession.Close();
1.85 + }
1.86 + else
1.87 + {
1.88 + RDebug::Print(_L("Error %d connecting file session. File: %S.\n"), err, &KTestDatabase);
1.89 + }
1.90 + }
1.91 +
1.92 +LOCAL_C void CloseDatabase()
1.93 + {
1.94 + TheDatabase.Close();
1.95 + }
1.96 +
1.97 +LOCAL_C void Disconnect()
1.98 + {
1.99 + TheDbs.ResourceCheck();
1.100 + TheDbs.Close();
1.101 + }
1.102 +
1.103 +///////////////////////////////////////////////////////////////////////////////////////
1.104 +///////////////////////////////////////////////////////////////////////////////////////
1.105 +//Tests macros and functions.
1.106 +//If (!aValue) then the test will be panicked, the test data files will be deleted.
1.107 +static void Check(TInt aValue, TInt aLine)
1.108 + {
1.109 + if(!aValue)
1.110 + {
1.111 + RDebug::Print(_L("*** Expression evaluated to false\r\n"));
1.112 + ::TestCleanup();
1.113 + TheTest(EFalse, aLine);
1.114 + }
1.115 + }
1.116 +//If (aValue != aExpected) then the test will be panicked, the test data files will be deleted.
1.117 +static void Check(TInt aValue, TInt aExpected, TInt aLine)
1.118 + {
1.119 + if(aValue != aExpected)
1.120 + {
1.121 + RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
1.122 + ::TestCleanup();
1.123 + TheTest(EFalse, aLine);
1.124 + }
1.125 + }
1.126 +//Use these to test conditions.
1.127 +#define TEST(arg) ::Check((arg), __LINE__)
1.128 +#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
1.129 +
1.130 +///////////////////////////////////////////////////////////////////////////////////////
1.131 +///////////////////////////////////////////////////////////////////////////////////////
1.132 +
1.133 +// Create the database
1.134 +LOCAL_C void CreateDatabase()
1.135 + {
1.136 + TInt r=TheDatabase.Replace(TheFs,KTestDatabase);
1.137 + TEST2(r, KErrNone);
1.138 + }
1.139 +
1.140 +LOCAL_C void Connect()
1.141 + {
1.142 + TInt r=TheDbs.Connect();
1.143 + TEST2(r, KErrNone);
1.144 + TheDbs.ResourceMark();
1.145 + }
1.146 +
1.147 +// Open the database through the server
1.148 +LOCAL_C void ShareDatabase()
1.149 + {
1.150 + TInt r=TheDatabase.Open(TheDbs,KTestDatabase);
1.151 + TEST2(r, KErrNone);
1.152 + }
1.153 +
1.154 +struct TSelectTest
1.155 + {
1.156 + const TText* iSearchCondition;
1.157 + TUint iResultSet;
1.158 + };
1.159 +#define ROWS(n,m) (((~0u)<<(n))&((2u<<(m))-1))
1.160 +#define ROW(n) ROWS(n,n)
1.161 +#define NO_ROWS 0
1.162 +#define ALL_ROWS (~1u) // all rows which are not NULL
1.163 +
1.164 +class TestPredicateBase
1.165 + {
1.166 +protected:
1.167 + static void Create(const TText* aType);
1.168 + static void Test(const TSelectTest* aTest,TInt aCount,TInt aRows, TBool aLog);
1.169 + static void TestViewL(const TSelectTest* aTest,TInt aCount,TInt aRows, TBool aLog=EFalse);
1.170 + };
1.171 +
1.172 +// Create the table for the predicate tests
1.173 +void TestPredicateBase::Create(const TText* aType)
1.174 + {
1.175 + TheTest.Next(TPtrC(aType));
1.176 + TheDatabase.Begin();
1.177 + TheSql.Format(_L("CREATE TABLE Compare (Id COUNTER,Test %s)"),aType);
1.178 + TInt r=TheDatabase.Execute(TheSql);
1.179 + TEST2(r, KErrNone);
1.180 + r=TheTable.Open(TheDatabase,_L("Compare"),TheTable.EInsertOnly);
1.181 + TEST2(r, KErrNone);
1.182 + }
1.183 +
1.184 +// Test the predicate on the table, then on the indexed table
1.185 +void TestPredicateBase::Test(const TSelectTest* aTest,TInt aCount,TInt aRows, TBool aLog)
1.186 + {
1.187 + if(aLog)
1.188 + {
1.189 + TheTest.Printf(_L("TestPredicateBase::Test\r\n"));
1.190 + }
1.191 + TheTable.Close();
1.192 + TInt r=TheDatabase.Commit();
1.193 + if(aLog)
1.194 + {
1.195 + TheTest.Printf(_L("Commit %d\r\n"), r);
1.196 + }
1.197 + TEST2(r, KErrNone);
1.198 + TRAPD(errCode, TestViewL(aTest,aCount,aRows, aLog));
1.199 + if(aLog)
1.200 + {
1.201 + TheTest.Printf(_L("TestViewL %d"), errCode);
1.202 + }
1.203 +
1.204 + TEST2(errCode, KErrNone);
1.205 + r=TheDatabase.Execute(_L("CREATE INDEX Key ON Compare (Test)"));
1.206 + if(aLog)
1.207 + {
1.208 + TheTest.Printf(_L("Execute %d"), r);
1.209 + }
1.210 +
1.211 + TEST2(r, KErrNone);
1.212 + TRAP(errCode,TestViewL(aTest,aCount,aRows, aLog));
1.213 + if(aLog)
1.214 + {
1.215 + TheTest.Printf(_L("TestViewL %d"), errCode);
1.216 + }
1.217 +
1.218 + TEST2(errCode, KErrNone);
1.219 + r=TheDatabase.Execute(_L("DROP TABLE Compare"));
1.220 + if(aLog)
1.221 + {
1.222 + TheTest.Printf(_L("Execute %d"), r);
1.223 + }
1.224 +
1.225 + TEST2(r, KErrNone);
1.226 + }
1.227 +
1.228 +// Test the predicate on the table
1.229 +void TestPredicateBase::TestViewL(const TSelectTest* aTest,TInt aCount,TInt aRows, TBool /*aLog*/)
1.230 + {
1.231 + TUint rowMask=(2u<<aRows)-1;
1.232 + for (;--aCount>=0;++aTest)
1.233 + {
1.234 + TheSql.Format(_L("SELECT Id FROM Compare WHERE Test %s"),aTest->iSearchCondition);
1.235 + TInt r=TheView.Prepare(TheDatabase,TheSql,TheView.EReadOnly);
1.236 + if(r!=KErrNone)
1.237 + {
1.238 + TheTest.Printf(_L("Prepare r= %d aCount= %d statement %S\r\n"), r, aCount, &TheSql);
1.239 + }
1.240 + TEST2(r, KErrNone);
1.241 + TBool ignoreRow0=TheView.Unevaluated();
1.242 + r=TheView.EvaluateAll();
1.243 + TEST2(r, KErrNone);
1.244 + TUint rows=0;
1.245 + while (TheView.NextL())
1.246 + {
1.247 + TheView.GetL();
1.248 + rows|=1u<<TheView.ColUint(1);
1.249 + }
1.250 + if (ignoreRow0)
1.251 + {
1.252 + TEST((rows&~ROW(0))==(aTest->iResultSet&rowMask&~ROW(0)));
1.253 + }
1.254 + else
1.255 + {
1.256 + TEST(rows==(aTest->iResultSet&rowMask));
1.257 + }
1.258 + TheView.Close();
1.259 + }
1.260 + }
1.261 +
1.262 +typedef void (*FSetColL)(TDbColNo aCol,const TAny* aVal);
1.263 +
1.264 +void WriteRowsL(const TAny* aValues,TInt aRows,TInt aSize,FSetColL aSetColL, TBool aLog)
1.265 + {
1.266 + for (TInt row=0;row<=aRows;++row)
1.267 + {
1.268 + if(aLog)
1.269 + {
1.270 + TheTest.Printf(_L("row = %d"), row);
1.271 + }
1.272 + TheTable.InsertL();
1.273 + TEST(TheTable.ColUint(1)==TUint(row));
1.274 + if (row>0)
1.275 + { // first row is always null
1.276 + aSetColL(2,aValues);
1.277 + aValues=PtrAdd(aValues,aSize);
1.278 + }
1.279 + TheTable.PutL();
1.280 + }
1.281 + }
1.282 +
1.283 +template <class T>
1.284 +struct SetCol
1.285 + {
1.286 + static void SetColL(TDbColNo aCol,const TAny* aVal)
1.287 + {
1.288 + TheTable.SetColL(aCol,*(const T*)aVal);
1.289 + }
1.290 + };
1.291 +
1.292 +template <class T>
1.293 +inline void WriteRowsL(const T* aValues,TUint aRows, TBool aLog)
1.294 + {
1.295 + WriteRowsL(aValues,aRows,sizeof(T),&SetCol<T>::SetColL, aLog);
1.296 + }
1.297 +
1.298 +template <class T>
1.299 +class TestPredicate : public TestPredicateBase
1.300 + {
1.301 +public:
1.302 + static void RunL();
1.303 + };
1.304 +
1.305 +// Test the Predicate operators for all types
1.306 +template <class T>
1.307 +void TestPredicate<T>::RunL()
1.308 + {
1.309 + Create(T::KType);
1.310 + TBool log = EFalse;
1.311 + if((TPtrC(T::KType)).CompareF(_L("TIME"))==0)
1.312 + {
1.313 + log = ETrue;
1.314 + }
1.315 + WriteRowsL(T::KValues,elementsof(T::KValues), log);
1.316 + Test(T::KTests,elementsof(T::KTests),elementsof(T::KValues),log);
1.317 + }
1.318 +
1.319 +struct TypeBit
1.320 + {
1.321 +public:
1.322 + static const TText* const KType;
1.323 + static const TUint KValues[];
1.324 + static const TSelectTest KTests[];
1.325 + };
1.326 +const TText* const TypeBit::KType=_S("BIT");
1.327 +const TUint TypeBit::KValues[]={0,1};
1.328 +const TSelectTest TypeBit::KTests[]=
1.329 + {
1.330 + {_S("IS NULL"),ROW(0)},
1.331 + {_S("IS NOT NULL"),ALL_ROWS},
1.332 + {_S("=0"),ROW(1)},
1.333 + {_S("<>0"),ROW(2)},
1.334 + {_S(">0"),ROW(2)},
1.335 + {_S("<0"),NO_ROWS},
1.336 + {_S("<=0"),ROW(1)},
1.337 + {_S(">=0"),ALL_ROWS},
1.338 + {_S("=1"),ROW(2)},
1.339 + {_S("<>1"),ROW(1)},
1.340 + {_S(">1"),NO_ROWS},
1.341 + {_S("<1"),ROW(1)},
1.342 + {_S("<=1"),ALL_ROWS},
1.343 + {_S(">=1"),ROW(2)}
1.344 + };
1.345 +
1.346 +struct TypeUint8
1.347 + {
1.348 +public:
1.349 + static const TText* const KType;
1.350 + static const TUint KValues[];
1.351 + static const TSelectTest KTests[];
1.352 + };
1.353 +const TText* const TypeUint8::KType=_S("UNSIGNED TINYINT");
1.354 +const TUint TypeUint8::KValues[]={0,1,127,128,254,255};
1.355 +const TSelectTest TypeUint8::KTests[]=
1.356 + {
1.357 + {_S("IS NULL"),ROW(0)},
1.358 + {_S("IS NOT NULL"),ALL_ROWS},
1.359 + {_S("=0"),ROW(1)},
1.360 + {_S("=3"),NO_ROWS},
1.361 + {_S("<2"),ROWS(1,2)},
1.362 + {_S(">=0"),ALL_ROWS},
1.363 + {_S("<128"),ROWS(1,3)},
1.364 + {_S("<>1"),ALL_ROWS-ROW(2)},
1.365 + {_S(">255"),NO_ROWS}
1.366 + };
1.367 +
1.368 +struct TypeUint16
1.369 + {
1.370 +public:
1.371 + static const TText* const KType;
1.372 + static const TUint KValues[];
1.373 + static const TSelectTest KTests[];
1.374 + };
1.375 +const TText* const TypeUint16::KType=_S("UNSIGNED SMALLINT");
1.376 +const TUint TypeUint16::KValues[]={0,1,5000,32767,32768,65534,65535};
1.377 +const TSelectTest TypeUint16::KTests[]=
1.378 + {
1.379 + {_S("IS NULL"),ROW(0)},
1.380 + {_S("IS NOT NULL"),ALL_ROWS},
1.381 + {_S("=0"),ROW(1)},
1.382 + {_S("=3"),NO_ROWS},
1.383 + {_S("<2"),ROWS(1,2)},
1.384 + {_S(">=32768"),ROWS(5,7)},
1.385 + {_S("<32767"),ROWS(1,3)},
1.386 + {_S("<>1"),ALL_ROWS-ROW(2)},
1.387 + {_S(">65535"),NO_ROWS}
1.388 + };
1.389 +
1.390 +struct TypeUint32
1.391 + {
1.392 +public:
1.393 + static const TText* const KType;
1.394 + static const TUint KValues[];
1.395 + static const TSelectTest KTests[];
1.396 + };
1.397 +const TText* const TypeUint32::KType=_S("UNSIGNED INTEGER");
1.398 +const TUint TypeUint32::KValues[]={0,1,2147483647u,2147483648u,3000000000u,4294967294u,4294967295u};
1.399 +const TSelectTest TypeUint32::KTests[]=
1.400 + {
1.401 + {_S("IS NULL"),ROW(0)},
1.402 + {_S("IS NOT NULL"),ALL_ROWS},
1.403 + {_S("=0"),ROW(1)},
1.404 + {_S("=3"),NO_ROWS},
1.405 + {_S("<2"),ROWS(1,2)},
1.406 + {_S(">=2147483648"),ROWS(4,7)},
1.407 + {_S("<2147483647"),ROWS(1,2)},
1.408 + {_S("<>3000000000"),ALL_ROWS-ROW(5)},
1.409 + {_S(">4294967295"),NO_ROWS}
1.410 + };
1.411 +
1.412 +struct TypeInt8
1.413 + {
1.414 +public:
1.415 + static const TText* const KType;
1.416 + static const TInt KValues[];
1.417 + static const TSelectTest KTests[];
1.418 + };
1.419 +const TText* const TypeInt8::KType=_S("TINYINT");
1.420 +const TInt TypeInt8::KValues[]={-128,-1,0,1,127};
1.421 +const TSelectTest TypeInt8::KTests[]=
1.422 + {
1.423 + {_S("IS NULL"),ROW(0)},
1.424 + {_S("IS NOT NULL"),ALL_ROWS},
1.425 + {_S("=0"),ROW(3)},
1.426 + {_S("=-1"),ROW(2)},
1.427 + {_S("<2"),ROWS(1,4)},
1.428 + {_S(">=-128"),ALL_ROWS},
1.429 + {_S("<128"),ALL_ROWS},
1.430 + {_S("<>1"),ALL_ROWS-ROW(4)}
1.431 + };
1.432 +
1.433 +struct TypeInt16
1.434 + {
1.435 +public:
1.436 + static const TText* const KType;
1.437 + static const TInt KValues[];
1.438 + static const TSelectTest KTests[];
1.439 + };
1.440 +const TText* const TypeInt16::KType=_S("SMALLINT");
1.441 +const TInt TypeInt16::KValues[]={-32768,-32767,-1,0,1,32766,32767};
1.442 +const TSelectTest TypeInt16::KTests[]=
1.443 + {
1.444 + {_S("IS NULL"),ROW(0)},
1.445 + {_S("IS NOT NULL"),ALL_ROWS},
1.446 + {_S("=0"),ROW(4)},
1.447 + {_S("<>0"),ALL_ROWS-ROW(4)},
1.448 + {_S("=-1"),ROW(3)},
1.449 + {_S("<2"),ROWS(1,5)},
1.450 + {_S(">=-40000"),ALL_ROWS},
1.451 + {_S("<32766"),ROWS(1,5)},
1.452 + {_S("=40"),NO_ROWS}
1.453 + };
1.454 +
1.455 +struct TypeInt32
1.456 + {
1.457 +public:
1.458 + static const TText* const KType;
1.459 + static const TInt KValues[];
1.460 + static const TSelectTest KTests[];
1.461 + };
1.462 +const TText* const TypeInt32::KType=_S("INTEGER");
1.463 +const TInt TypeInt32::KValues[]={0x80000000/*-2147483648*/,-2147483647,-1,0,1,2147483646,2147483647};
1.464 +const TSelectTest TypeInt32::KTests[]=
1.465 + {
1.466 + {_S("IS NULL"),ROW(0)},
1.467 + {_S("IS NOT NULL"),ALL_ROWS},
1.468 + {_S("=0"),ROW(4)},
1.469 + {_S("<>0"),ALL_ROWS-ROW(4)},
1.470 + {_S("=-1"),ROW(3)},
1.471 + {_S("<2"),ROWS(1,5)},
1.472 + {_S(">=-2147483648"),ALL_ROWS},
1.473 + {_S("<2147483646"),ROWS(1,5)},
1.474 + {_S(">2147483647"),NO_ROWS},
1.475 + {_S("=40"),NO_ROWS}
1.476 + };
1.477 +
1.478 +struct TypeInt64
1.479 + {
1.480 +public:
1.481 + static const TText* const KType;
1.482 + static const TInt64 KValues[];
1.483 + static const TSelectTest KTests[];
1.484 + };
1.485 +const TText* const TypeInt64::KType=_S("BIGINT");
1.486 +const TInt64 TypeInt64::KValues[]=
1.487 + {
1.488 + MAKE_TINT64(0x80000000, 0x00000000), // min int64
1.489 + _LINT64(-4294967296),
1.490 + TInt(0x80000000), // -2147483648!
1.491 + -1,
1.492 + 0u,
1.493 + 1u,
1.494 + 2147483647u,
1.495 + _LINT64(2147483648),
1.496 + _LINT64(4294967295),
1.497 + _LINT64(4294967296),
1.498 + _LINT64(9223372036854775807) // max int64
1.499 + };
1.500 +const TSelectTest TypeInt64::KTests[]=
1.501 + {
1.502 + {_S("IS NULL"),ROW(0)},
1.503 + {_S("IS NOT NULL"),ALL_ROWS},
1.504 + {_S("=0"),ROW(5)},
1.505 + {_S("<>0"),ALL_ROWS-ROW(5)},
1.506 + {_S("=-1"),ROW(4)},
1.507 + {_S("<2"),ROWS(1,6)},
1.508 + {_S(">=-9223372036854775808"),ALL_ROWS},
1.509 + {_S("<4294967296"),ROWS(1,9)},
1.510 + {_S(">9223372036854775806"),ROW(11)},
1.511 + {_S("=40"),NO_ROWS}
1.512 + };
1.513 +
1.514 +struct TypeReal32
1.515 + {
1.516 +public:
1.517 + static const TText* const KType;
1.518 + static const TReal32 KValues[];
1.519 + static const TSelectTest KTests[];
1.520 + };
1.521 +const TText* const TypeReal32::KType=_S("REAL");
1.522 +const TReal32 TypeReal32::KValues[]=
1.523 + {
1.524 + -KMaxTReal32,
1.525 + -1.0f,
1.526 + -KMinTReal32,
1.527 + 0.0f,
1.528 + KMinTReal32,
1.529 + 1.0f,
1.530 + KMaxTReal32
1.531 + };
1.532 +const TSelectTest TypeReal32::KTests[]=
1.533 + {
1.534 + {_S("IS NULL"),ROW(0)},
1.535 + {_S("IS NOT NULL"),ALL_ROWS},
1.536 + {_S("=0"),ROW(4)},
1.537 + {_S("<>0.0"),ALL_ROWS-ROW(4)},
1.538 + {_S("=-1"),ROW(2)},
1.539 + {_S("<2e1"),ROWS(1,6)},
1.540 + {_S(">=-100000000000000"),ROWS(2,7)},
1.541 + {_S("<1e-36"),ROWS(1,5)},
1.542 + {_S(">1e15"),ROW(7)},
1.543 + {_S("=.5"),NO_ROWS},
1.544 + {_S("<=-.0"),ROWS(1,4)},
1.545 + {_S("<1e40"),ALL_ROWS}
1.546 + };
1.547 +
1.548 +struct TypeReal64
1.549 + {
1.550 +public:
1.551 + static const TText* const KType;
1.552 + static const TReal64 KValues[];
1.553 + static const TSelectTest KTests[];
1.554 + };
1.555 +const TText* const TypeReal64::KType=_S("DOUBLE");
1.556 +const TReal64 TypeReal64::KValues[]=
1.557 + {
1.558 + -KMaxTReal64,
1.559 + -1.0f,
1.560 + -KMinTReal64,
1.561 + 0.0f,
1.562 + KMinTReal64,
1.563 + 1.0f,
1.564 + KMaxTReal64
1.565 + };
1.566 +const TSelectTest TypeReal64::KTests[]=
1.567 + {
1.568 + {_S("IS NULL"),ROW(0)},
1.569 + {_S("IS NOT NULL"),ALL_ROWS},
1.570 + {_S("=0"),ROW(4)},
1.571 + {_S("<>0"),ALL_ROWS-ROW(4)},
1.572 + {_S("=-1"),ROW(2)},
1.573 + {_S("<2"),ROWS(1,6)},
1.574 + {_S(">=-100000000000000"),ROWS(2,7)},
1.575 + {_S("<1e-300"),ROWS(1,5)},
1.576 + {_S(">1e15"),ROW(7)},
1.577 + {_S("=.5"),NO_ROWS},
1.578 + {_S("<=0"),ROWS(1,4)},
1.579 + {_S("<1e40"),ROWS(1,6)}
1.580 + };
1.581 +
1.582 +struct TypeTime
1.583 + {
1.584 +public:
1.585 + static const TText* const KType;
1.586 + static const TTime KValues[];
1.587 + static const TSelectTest KTests[];
1.588 + };
1.589 +const TText* const TypeTime::KType=_S("TIME");
1.590 +const TTime TypeTime::KValues[]=
1.591 + {
1.592 + TInt64(0u), // zero date/time
1.593 + _L(":085815"), // 8:58:15am
1.594 + _L("19181010:110000"), // 11am, 11 Nov 1918
1.595 + _L("19750226:"), // midnight, 27 Mar 1975
1.596 + _L("19961130:235959"), // 11:59:59pm, 31 Dec 1996
1.597 + _L("19970000:"), // midnight, 1 Jan 1997
1.598 + _L("19970611:210000"), // 9pm, 12 July 1997
1.599 + _L("19980309:214500"), // 9:45pm, 10 April 1998
1.600 + _L("20700608:") // midnight, 9 July 2070
1.601 + };
1.602 +const TSelectTest TypeTime::KTests[]=
1.603 + {
1.604 + {_S("IS NULL"),ROW(0)},
1.605 + {_S("IS NOT NULL"),ALL_ROWS},
1.606 + {_S("=#12am#"),ROW(1)},
1.607 + {_S("<#Jan 1 2100#"),ALL_ROWS},
1.608 + {_S("<>#31/12/1996 23:59:59#"),ALL_ROWS-ROW(5)},
1.609 + {_S("<#9a#"),ROWS(1,2)},
1.610 + {_S(">=#11:59:59pm, 31 Dec 1996#"),ROWS(5,9)},
1.611 + {_S("=#9:45pm 10 April, 1998#"),ROW(8)},
1.612 + {_S("=#8:58:15#"),ROW(2)}
1.613 + };
1.614 +
1.615 +struct TypeText
1.616 + {
1.617 +public:
1.618 + static const TText* const KType;
1.619 + static const TText* const KValues[];
1.620 + static TSelectTest KTests[];
1.621 + };
1.622 +const TText* const TypeText::KType=_S("VARCHAR(100)");
1.623 +const TText* const TypeText::KValues[]=
1.624 + {
1.625 + _S(""), // this should be equivalent to NULL
1.626 + _S("a"),
1.627 + _S("aa"),
1.628 + _S("aba"),
1.629 + _S("like"),
1.630 + _S("abcdefghijklmnopqrstuvwxyzlike"),
1.631 + _S("likeabcdefghijklmnopqrstuvwxyz"),
1.632 + _S("abcdefghijklmnopqrstuvwxyzlikeabcdefghijklmnopqrstuvwxyz"),
1.633 + _S("abcdefghijklmnopqrstuvwxyzliveabcdefghijklmnopqrstuvwxyz"),
1.634 + _S("l'ke"),
1.635 + _S("'Tis")
1.636 + };
1.637 +TSelectTest TypeText::KTests[]=
1.638 + {
1.639 + {_S("IS NULL"),ROWS(0,1)},
1.640 + {_S("IS NOT NULL"),ALL_ROWS-ROW(1)},
1.641 +//
1.642 + {_S("=''"),ROWS(0,1)}, // equivalent to IS NULL
1.643 + {_S("<>''"),ALL_ROWS-ROW(1)}, // equivalent to IS NOT NULL
1.644 + {_S(">''"),ALL_ROWS-ROW(1)}, // equivalent to IS NOT NULL
1.645 + {_S("<''"),NO_ROWS}, // expression is trivially false
1.646 + {_S("<=''"),ROWS(0,1)},
1.647 + {_S(">=''"),ALL_ROWS+ROW(0)}, // expression is trivially true
1.648 +//
1.649 + {_S("LIKE ''"),ROWS(0,1)}, // synonomous with IS NULL
1.650 + {_S("NOT LIKE ''"),ALL_ROWS-ROW(1)},
1.651 + {_S("LIKE '?*'"),ALL_ROWS-ROW(1)}, // synonomous with IS NOT NULL
1.652 + {_S("NOT LIKE '?*'"),ROWS(0,1)},
1.653 + {_S("LIKE '*'"),ALL_ROWS+ROW(0)}, // trivially true
1.654 + {_S("NOT LIKE '*'"),NO_ROWS},
1.655 +//
1.656 + {_S("='a'"),ROW(2)},
1.657 + {_S("<'ab'"),ROWS(0,3)+ROW(11)},
1.658 + {_S("<'abc'"),ROWS(0,4)+ROW(11)},
1.659 + {_S("<'b'"),ROWS(0,4)+ROW(6)+ROWS(8,9)+ROW(11)},
1.660 + {_S(">'abc'"),ROWS(5,10)},
1.661 + {_S("='like'"),ROW(5)},
1.662 + {_S("='l''ke'"),ROW(10)},
1.663 + {_S("='''Tis'"),ROW(11)},
1.664 +//
1.665 + {_S("LIKE 'a'"),ROW(2)},
1.666 + {_S("LIKE 'a*'"),ROWS(2,4)+ROW(6)+ROWS(8,9)},
1.667 + {_S("LIKE '*a'"),ROWS(2,4)},
1.668 + {_S("LIKE 'a*a'"),ROWS(3,4)},
1.669 + {_S("LIKE '*a*'"),ROWS(2,4)+ROWS(6,9)},
1.670 +//
1.671 + {_S("LIKE 'like'"),ROW(5)},
1.672 + {_S("LIKE 'l?ke'"),ROW(5)+ROW(10)},
1.673 + {_S("LIKE 'like*'"),ROW(5)+ROW(7)},
1.674 + {_S("LIKE '*like'"),ROWS(5,6)},
1.675 + {_S("LIKE '*like*'"),ROWS(5,8)},
1.676 + {_S("LIKE '*likeit*'"),NO_ROWS},
1.677 + {_S("LIKE '*li?e*'"),ROWS(5,9)},
1.678 + {_S("LIKE '?*li?e*'"),ROW(6)+ROWS(8,9)},
1.679 + {_S("LIKE '*li?e*?'"),ROWS(7,9)},
1.680 + {_S("LIKE '?*li?e*?'"),ROWS(8,9)},
1.681 + {_S("LIKE '*?k?*'"),ROWS(5,10)},
1.682 + {_S("LIKE '*?i?e*'"),ROWS(5,9)},
1.683 +//
1.684 + {_S("LIKE '*e*'"),ROWS(5,10)},
1.685 + {_S("LIKE '*z*k*e*'"),ROW(6)+ROW(8)},
1.686 + {_S("LIKE '\?\?k?'"),ROW(5)+ROW(10)},
1.687 + {_S("LIKE '\?\?k*'"),ROW(5)+ROW(7)+ROW(10)},
1.688 + {_S("LIKE '*''*'"),ROWS(10,11)},
1.689 + {_S("LIKE '?''\?\?'"),ROW(10)},
1.690 + {_S("LIKE '?'"),ROW(2)},
1.691 + {_S("LIKE '\?\?\?\?'"),ROW(5)+ROWS(10,11)},
1.692 + {_S("LIKE '\?\?*\?\?'"),ROWS(5,11)},
1.693 + {_S("LIKE '''*'"),ROW(11)}
1.694 + };
1.695 +
1.696 +TEMPLATE_SPECIALIZATION struct SetCol<const TText* const>
1.697 + {
1.698 + static void SetColL(TDbColNo aCol,const TAny* aVal)
1.699 + {
1.700 + TheTable.SetColL(aCol,TPtrC(*(const TText* const*)aVal));
1.701 + }
1.702 + };
1.703 +TEMPLATE_SPECIALIZATION struct SetCol<const TText*>
1.704 + {
1.705 + static void SetColL(TDbColNo aCol,const TAny* aVal)
1.706 + {
1.707 + TheTable.SetColL(aCol,TPtrC(*(const TText* const*)aVal));
1.708 + }
1.709 + };
1.710 +
1.711 +struct TypeLongText
1.712 + {
1.713 +public:
1.714 + static const TText* const KType;
1.715 + };
1.716 +const TText* const TypeLongText::KType=_S("LONG VARCHAR");
1.717 +
1.718 +class TestPredicate2 : public TestPredicateBase
1.719 + {
1.720 +public:
1.721 + static void RunL();
1.722 + };
1.723 +
1.724 +// write rows equivalent to TypeText and use its tests
1.725 +void TestPredicate2::RunL()
1.726 + {
1.727 + Create(TypeLongText::KType);
1.728 + TBuf<1022> fill=_S("abcdefghijklmnopqrstuvqxyz");
1.729 + fill.AppendFill('.',fill.MaxLength()-fill.Length());
1.730 +
1.731 + for (TInt row=0;row<=TInt(elementsof(TypeText::KValues));++row)
1.732 + {
1.733 + TheTable.InsertL();
1.734 + TheTable.SetColL(1,row);
1.735 + if (row>0)
1.736 + {
1.737 + RDbColWriteStream blob;
1.738 + blob.OpenLC(TheTable,2);
1.739 + switch (row)
1.740 + {
1.741 + case 0:
1.742 + break;
1.743 + case 1: case 2: case 3: case 4: case 5: case 10: case 11:
1.744 + blob.WriteL(TPtrC(TypeText::KValues[row-1]));
1.745 + break;
1.746 + case 6:
1.747 + blob.WriteL(fill);
1.748 + blob.WriteL(_L("like"));
1.749 + break;
1.750 + case 7:
1.751 + blob.WriteL(_L("like"));
1.752 + blob.WriteL(fill);
1.753 + break;
1.754 + case 8:
1.755 + blob.WriteL(fill);
1.756 + blob.WriteL(_L("like"));
1.757 + blob.WriteL(fill);
1.758 + break;
1.759 + case 9:
1.760 + blob.WriteL(fill);
1.761 + blob.WriteL(_L("live"));
1.762 + blob.WriteL(fill);
1.763 + break;
1.764 + }
1.765 + blob.CommitL();
1.766 + CleanupStack::PopAndDestroy();
1.767 + }
1.768 + TheTable.PutL();
1.769 + }
1.770 + TheTable.Close();
1.771 + TInt r=TheDatabase.Commit();
1.772 + TEST2(r, KErrNone);
1.773 + TestViewL(TypeText::KTests,elementsof(TypeText::KTests),elementsof(TypeText::KValues));
1.774 + CDbKey& key=*CDbKey::NewLC();
1.775 + key.AddL(TDbKeyCol(_L("Test"),120));
1.776 + r=TheDatabase.CreateIndex(_L("Key"),_L("Compare"),key);
1.777 + TEST2(r, KErrNone);
1.778 + CleanupStack::PopAndDestroy();
1.779 + TestViewL(TypeText::KTests,elementsof(TypeText::KTests),elementsof(TypeText::KValues));
1.780 + r=TheDatabase.Execute(_L("DROP TABLE Compare"));
1.781 + TEST2(r, KErrNone);
1.782 + }
1.783 +
1.784 +/**
1.785 +* Utility for DEF063276 fix.
1.786 +*/
1.787 +
1.788 +_LIT(KTypeTextKTests44, "Z:\\test\\TypeTextKTests44.dat");
1.789 +_LIT(KTypeTextKTests46, "Z:\\test\\TypeTextKTests46.dat");
1.790 +_LIT(KTypeTextKTests47, "Z:\\test\\TypeTextKTests47.dat");
1.791 +
1.792 +static void ReadDesc(TDes& aDes, const TDesC& aFilename, RFs& aFs)
1.793 + {
1.794 + TheTest.Printf(_L("---ReadDesc(), aFilename=%S\r\n"), &aFilename);
1.795 + RFile file;
1.796 + TInt err = file.Open(aFs, aFilename, EFileRead);
1.797 + TheTest.Printf(_L("Open file aFilename=%S err = %d\r\n"), &aFilename, err);
1.798 + TEST2(err, KErrNone);
1.799 +
1.800 + TPtr8 ptr(reinterpret_cast<TUint8*>(const_cast<TUint16*>(aDes.Ptr())), aDes.MaxSize());
1.801 + err = file.Read(ptr);
1.802 + TheTest.Printf(_L("Read file aFilename=%S err = %d\r\n"), &aFilename, err);
1.803 + TEST2(err, KErrNone);
1.804 + aDes.SetLength(ptr.Length() / sizeof(TText));
1.805 + file.Close();
1.806 + }
1.807 +
1.808 +/**
1.809 +@SYMTestCaseID SYSLIB-DBMS-CT-0633
1.810 +@SYMTestCaseDesc Tests the Predicate operators for all types
1.811 +@SYMTestPriority Medium
1.812 +@SYMTestActions Attempt to check with different types
1.813 +@SYMTestExpectedResults Test must not fail
1.814 +@SYMREQ REQ0000
1.815 +*/
1.816 +LOCAL_C void TestPredicatesL()
1.817 + {
1.818 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0633 init "));
1.819 + CreateDatabase();
1.820 + TestPredicate<TypeBit>::RunL();
1.821 + TestPredicate<TypeUint8>::RunL();
1.822 + TestPredicate<TypeUint16>::RunL();
1.823 + TestPredicate<TypeUint32>::RunL();
1.824 + TestPredicate<TypeInt8>::RunL();
1.825 + TestPredicate<TypeInt16>::RunL();
1.826 + TestPredicate<TypeInt32>::RunL();
1.827 + TestPredicate<TypeInt64>::RunL();
1.828 + TestPredicate<TypeReal32>::RunL();
1.829 + TestPredicate<TypeReal64>::RunL();
1.830 + TestPredicate<TypeTime>::RunL();
1.831 +
1.832 + /**
1.833 + * Work around for DEF063276.
1.834 + * These literals are now loaded from Z:\test\TypeTextKTests44.dat,
1.835 + * Z:\test\data\TypeTextKTests44.dat and Z:\test\TypeTextKTests44.dat respectively.
1.836 + * Bullseye Coverage corrupts these literals to avoid this they are stored in files as to not be touched by Bullseye Coverage.
1.837 + */
1.838 +
1.839 + TBuf<16> buf44;
1.840 + ReadDesc(buf44, KTypeTextKTests44, TheFs);
1.841 + TypeText::KTests[44].iSearchCondition = const_cast<TText*>(buf44.PtrZ());
1.842 +
1.843 + TBuf<32> buf46(TypeText::KTests[46].iSearchCondition);
1.844 + ReadDesc(buf46, KTypeTextKTests46, TheFs);
1.845 + TypeText::KTests[46].iSearchCondition = const_cast<TText*>(buf46.PtrZ());
1.846 +
1.847 + TBuf<32> buf47(TypeText::KTests[47].iSearchCondition);
1.848 + ReadDesc(buf47, KTypeTextKTests47, TheFs);
1.849 + TypeText::KTests[47].iSearchCondition = const_cast<TText*>(buf47.PtrZ());
1.850 +
1.851 + // End fix.
1.852 +
1.853 + TestPredicate<TypeText>::RunL();
1.854 + TestPredicate2::RunL();
1.855 + CloseDatabase();
1.856 + TheTest.End();
1.857 + }
1.858 +
1.859 +/**
1.860 +@SYMTestCaseID SYSLIB-DBMS-CT-0634
1.861 +@SYMTestCaseDesc DML Query test
1.862 + Test for RDbNamedDatabase::Execute() function
1.863 +@SYMTestPriority Medium
1.864 +@SYMTestActions Tests for CREATE TABLE,CREATE UNIQUE INDEX,INSET INTO,UPDATE,DELETE,DROP queries
1.865 +@SYMTestExpectedResults Test must not fail
1.866 +@SYMREQ REQ0000
1.867 +*/
1.868 +LOCAL_C void TestDataModificationlanguage()
1.869 + {
1.870 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0634 init "));
1.871 + Connect();
1.872 + ShareDatabase();
1.873 + TInt r=TheDatabase.Execute(_L("CREATE TABLE test (ID INTEGER NOT NULL,SALARY DOUBLE)"));
1.874 + TEST2(r, KErrNone);
1.875 + r=TheDatabase.Execute(_L("CREATE UNIQUE INDEX key ON test (ID)"));
1.876 + TEST2(r, KErrNone);
1.877 +
1.878 + TheTest.Next(_L("insert-statements"));
1.879 + r=TheDatabase.Execute(_L("INSERT INTO test VALUES (0,0)"));
1.880 + TEST(r==1);
1.881 + r=TheDatabase.Execute(_L("INSERT INTO test (ID) VALUES (1)"));
1.882 + TEST(r==1);
1.883 + r=TheDatabase.Execute(_L("INSERT INTO test (SALARY,ID) VALUES (20.4,2)"));
1.884 + TEST(r==1);
1.885 +
1.886 + TheTest.Next(_L("update-statements"));
1.887 + r=TheDatabase.Execute(_L("UPDATE test SET SALARY=30000 WHERE ID=1"));
1.888 + TEST(r==1);
1.889 +
1.890 + TheTest.Next(_L("delete-statements"));
1.891 + r=TheDatabase.Execute(_L("DELETE FROM test WHERE SALARY<40"));
1.892 + TEST(r==2);
1.893 + r=TheDatabase.Execute(_L("DELETE FROM test"));
1.894 + TEST(r==1);
1.895 + r=TheDatabase.Execute(_L("DROP TABLE test"));
1.896 + TEST2(r, KErrNone);
1.897 +//
1.898 + TheTest.Next(_L("larger table"));
1.899 + r=TheDatabase.Execute(_L("CREATE TABLE test (ID COUNTER,DATA INTEGER)"));
1.900 + TEST2(r, KErrNone);
1.901 +
1.902 + TheTest.Next(_L("insert"));
1.903 + r=TheDatabase.Begin();
1.904 + TEST2(r, KErrNone);
1.905 + TBuf<256> sql;
1.906 + for (TInt ii=0;ii<100;++ii)
1.907 + {
1.908 + sql.Format(_L("INSERT INTO test (DATA) VALUES (%D)"),100-ii);
1.909 + r=TheDatabase.Execute(sql);
1.910 + TEST(r==1);
1.911 + }
1.912 + r=TheDatabase.Commit();
1.913 + TEST2(r, KErrNone);
1.914 +
1.915 + TheTest.Next(_L("update"));
1.916 + r=TheDatabase.Execute(_L("UPDATE test SET DATA=200 WHERE ID>=40 AND ID<60"));
1.917 + TEST(r==20);
1.918 +
1.919 + TheTest.Next(_L("delete"));
1.920 + r=TheDatabase.Execute(_L("DELETE FROM test WHERE DATA>90"));
1.921 + TEST(r==30);
1.922 +
1.923 + TheTest.Next(_L("update"));
1.924 + r=TheDatabase.Execute(_L("UPDATE test SET DATA=-1"));
1.925 + TEST(r==70);
1.926 +
1.927 + TheTest.Next(_L("delete"));
1.928 + r=TheDatabase.Execute(_L("DELETE FROM test"));
1.929 + TEST(r==70);
1.930 + r=TheDatabase.Execute(_L("DROP TABLE test"));
1.931 + TEST2(r, KErrNone);
1.932 + CloseDatabase();
1.933 + Disconnect();
1.934 + TheTest.End();
1.935 + }
1.936 +
1.937 +/**
1.938 +@SYMTestCaseID SYSLIB-DBMS-CT-0635
1.939 +@SYMTestCaseDesc DBMS SQL parsing and execution tests.Tests for database index order
1.940 + Test for RDbNamedDatabase::Execute() function
1.941 +@SYMTestPriority Medium
1.942 +@SYMTestActions Tests for order by index
1.943 +@SYMTestExpectedResults Test must not fail
1.944 +@SYMREQ REQ0000
1.945 +*/
1.946 +LOCAL_C void TestOrderByL()
1.947 + {
1.948 + static const TReal TestDataSalary[]={10,34000,15000,53200,17800,240000};
1.949 + static const TText* const TestDataNames[]={_S("gopher"),_S("james '007' bond"),_S("moneypenny"),_S("Q"),_S("james '007' bond"),_S("M")};
1.950 +//
1.951 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0635 init "));
1.952 + Connect();
1.953 + ShareDatabase();
1.954 + TheDatabase.Begin();
1.955 + TInt r=TheDatabase.Execute(_L("CREATE TABLE test (ID INTEGER NOT NULL,SALARY DOUBLE,NAME VARCHAR)"));
1.956 + TEST2(r, KErrNone);
1.957 + r=TheDatabase.Execute(_L("CREATE UNIQUE INDEX key ON test (ID)"));
1.958 + TEST2(r, KErrNone);
1.959 +
1.960 + TheTest.Next(_L("insert data"));
1.961 + r=TheView.Prepare(TheDatabase,_L("SELECT ID,SALARY,NAME FROM test"),TheView.EInsertOnly);
1.962 + TEST2(r, KErrNone);
1.963 + TInt ii;
1.964 + for (ii=0;ii<6;++ii)
1.965 + {
1.966 + TheView.InsertL();
1.967 + TheView.SetColL(1,6-ii);
1.968 + TheView.SetColL(2,TestDataSalary[ii]);
1.969 + TheView.SetColL(3,TPtrC(TestDataNames[ii]));
1.970 + TheView.PutL();
1.971 + }
1.972 + r=TheDatabase.Commit();
1.973 + TEST2(r, KErrNone);
1.974 + TheView.Close();
1.975 +
1.976 + TheTest.Next(_L("Order by <index>"));
1.977 + // test the index is used here
1.978 + r=TheView.Prepare(TheDatabase,_L("SELECT ID FROM test ORDER BY ID"));
1.979 + TEST2(r, KErrNone);
1.980 + TEST(!TheView.Unevaluated());
1.981 + TInt c=0;
1.982 + if (TheView.FirstL())
1.983 + {
1.984 + ++c;
1.985 + TheView.GetL();
1.986 + TInt last=TheView.ColInt(1);
1.987 + while (TheView.NextL())
1.988 + {
1.989 + ++c;
1.990 + TheView.GetL();
1.991 + TInt v=TheView.ColInt(1);
1.992 + TEST(v>last);
1.993 + last=v;
1.994 + }
1.995 + }
1.996 + TEST(c==6);
1.997 + TEST(c==TheView.CountL());
1.998 + TheView.Close();
1.999 +
1.1000 + TheTest.Next(_L("Order by <no-index> 1"));
1.1001 + // test that no index is used here
1.1002 + r=TheView.Prepare(TheDatabase,_L("SELECT SALARY FROM test ORDER BY SALARY"));
1.1003 + TEST2(r, KErrNone);
1.1004 + TEST(TheView.Unevaluated());
1.1005 + r=TheView.EvaluateAll();
1.1006 + TEST2(r, KErrNone);
1.1007 + c=0;
1.1008 + if (TheView.FirstL())
1.1009 + {
1.1010 + ++c;
1.1011 + TheView.GetL();
1.1012 + TReal last=TheView.ColReal(1);
1.1013 + while (TheView.NextL())
1.1014 + {
1.1015 + ++c;
1.1016 + TheView.GetL();
1.1017 + TReal v=TheView.ColReal(1);
1.1018 + TEST(v>=last);
1.1019 + last=v;
1.1020 + }
1.1021 + }
1.1022 + TEST(c==6);
1.1023 + TEST(c==TheView.CountL());
1.1024 + TheView.Close();
1.1025 +
1.1026 + TheTest.Next(_L("Order by <no-index> 2"));
1.1027 + // test that no index is used here
1.1028 + r=TheView.Prepare(TheDatabase,_L("SELECT SALARY FROM test ORDER BY SALARY,NAME"));
1.1029 + TEST2(r, KErrNone);
1.1030 + TEST(TheView.Unevaluated());
1.1031 + r=TheView.EvaluateAll();
1.1032 + TEST2(r, KErrNone);
1.1033 + c=0;
1.1034 + if (TheView.FirstL())
1.1035 + {
1.1036 + ++c;
1.1037 + TheView.GetL();
1.1038 + TReal last=TheView.ColReal(1);
1.1039 + while (TheView.NextL())
1.1040 + {
1.1041 + ++c;
1.1042 + TheView.GetL();
1.1043 + TReal v=TheView.ColReal(1);
1.1044 + TEST(v>=last);
1.1045 + last=v;
1.1046 + }
1.1047 + }
1.1048 + TEST(c==6);
1.1049 + TEST(c==TheView.CountL());
1.1050 + TheView.Close();
1.1051 +
1.1052 + TheTest.Next(_L("Order by <no-index> 3"));
1.1053 + // test that no index is used here
1.1054 + r=TheView.Prepare(TheDatabase,_L("SELECT NAME FROM test ORDER BY NAME"));
1.1055 + TEST2(r, KErrNone);
1.1056 + TEST(TheView.Unevaluated());
1.1057 + r=TheView.EvaluateAll();
1.1058 + TEST2(r, KErrNone);
1.1059 + c=0;
1.1060 + if (TheView.FirstL())
1.1061 + {
1.1062 + ++c;
1.1063 + TheView.GetL();
1.1064 + TBuf<50> last=TheView.ColDes(1);
1.1065 + while (TheView.NextL())
1.1066 + {
1.1067 + ++c;
1.1068 + TheView.GetL();
1.1069 + TPtrC v=TheView.ColDes(1);
1.1070 + TEST(v>=last);
1.1071 + last=v;
1.1072 + }
1.1073 + }
1.1074 + TEST(c==6);
1.1075 + TEST(c==TheView.CountL());
1.1076 + TheView.Close();
1.1077 +
1.1078 + TheTest.Next(_L("Order by <no-index> 4"));
1.1079 + // test that no index is used here
1.1080 + r=TheView.Prepare(TheDatabase,_L("SELECT NAME FROM test ORDER BY NAME,SALARY"));
1.1081 + TEST2(r, KErrNone);
1.1082 + TEST(TheView.Unevaluated());
1.1083 + r=TheView.EvaluateAll();
1.1084 + TEST2(r, KErrNone);
1.1085 + c=0;
1.1086 + if (TheView.FirstL())
1.1087 + {
1.1088 + ++c;
1.1089 + TheView.GetL();
1.1090 + TBuf<50> last=TheView.ColDes(1);
1.1091 + while (TheView.NextL())
1.1092 + {
1.1093 + ++c;
1.1094 + TheView.GetL();
1.1095 + TPtrC v=TheView.ColDes(1);
1.1096 + TEST(v>=last);
1.1097 + last=v;
1.1098 + }
1.1099 + }
1.1100 + TEST(c==6);
1.1101 + TEST(c==TheView.CountL());
1.1102 + TheView.Close();
1.1103 +
1.1104 + TheTest.Next(_L("Order by + search <no-index>"));
1.1105 + // test that no index is used here
1.1106 + r=TheView.Prepare(TheDatabase,_L("SELECT ID,SALARY FROM test WHERE SALARY>30000 ORDER BY SALARY DESC"));
1.1107 + TEST2(r, KErrNone);
1.1108 + TEST(TheView.Unevaluated());
1.1109 + r=TheView.EvaluateAll();
1.1110 + TEST2(r, KErrNone);
1.1111 + c=0;
1.1112 + if (TheView.FirstL())
1.1113 + {
1.1114 + ++c;
1.1115 + TheView.GetL();
1.1116 + TReal last=TheView.ColReal(2);
1.1117 + while (TheView.NextL())
1.1118 + {
1.1119 + ++c;
1.1120 + TheView.GetL();
1.1121 + TReal v=TheView.ColReal(2);
1.1122 + TEST(v<=last);
1.1123 + last=v;
1.1124 + }
1.1125 + }
1.1126 + TEST(c==3);
1.1127 + TEST(c==TheView.CountL());
1.1128 + TheView.Close();
1.1129 +//
1.1130 + CloseDatabase();
1.1131 + Disconnect();
1.1132 +
1.1133 + TheTest.Next(_L("Order by <index> Finished"));
1.1134 + TheTest.End();
1.1135 + }
1.1136 +
1.1137 +LOCAL_C void doMain()
1.1138 + {
1.1139 + TheTest.Start(_L("Predicate tests"));
1.1140 + TRAPD(errCode, TestPredicatesL());
1.1141 + TEST2(errCode, KErrNone);
1.1142 +
1.1143 + TheTest.Next(_L("DML execution"));
1.1144 + TestDataModificationlanguage();
1.1145 +
1.1146 + TheTest.Next(_L("ORDER BY clause"));
1.1147 + TRAP(errCode, TestOrderByL());
1.1148 + TEST2(errCode, KErrNone);
1.1149 + TheTest.End();
1.1150 + }
1.1151 +
1.1152 +// Prepare the test directory.
1.1153 +LOCAL_C void setupTestDirectory()
1.1154 + {
1.1155 + TInt r=TheFs.Connect();
1.1156 + TEST2(r, KErrNone);
1.1157 +//
1.1158 + r=TheFs.MkDir(KTestDatabase);
1.1159 + TEST(r==KErrNone || r==KErrAlreadyExists);
1.1160 + }
1.1161 +
1.1162 +// Initialise the cleanup stack.
1.1163 +LOCAL_C void setupCleanup()
1.1164 + {
1.1165 + TheTrapCleanup=CTrapCleanup::New();
1.1166 + TEST(TheTrapCleanup!=NULL);
1.1167 + TRAPD(r,\
1.1168 + {\
1.1169 + for (TInt i=KTestCleanupStack;i>0;i--)\
1.1170 + CleanupStack::PushL((TAny*)0);\
1.1171 + CleanupStack::Pop(KTestCleanupStack);\
1.1172 + });
1.1173 + TEST2(r, KErrNone);
1.1174 + }
1.1175 +
1.1176 +// Test streaming conversions.
1.1177 +GLDEF_C TInt E32Main()
1.1178 + {
1.1179 + TheTest.Title();
1.1180 + setupTestDirectory();
1.1181 + setupCleanup();
1.1182 + __UHEAP_MARK;
1.1183 +//
1.1184 + TheTest.Start(_L("Standard database"));
1.1185 + doMain();
1.1186 +
1.1187 + // clean up data file used by this test - must be done before call to End() - DEF047652
1.1188 + ::TestCleanup();
1.1189 + TheTest.End();
1.1190 +//
1.1191 + __UHEAP_MARKEND;
1.1192 +
1.1193 +
1.1194 + delete TheTrapCleanup;
1.1195 + TheTest.Close();
1.1196 + return 0;
1.1197 + }