1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/t_sqlattach2.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,698 @@
1.4 +// Copyright (c) 2008-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 +// Note: Only runs on hardware as you cannot remove MMC card on emulator
1.18 +//
1.19 +//
1.20 +
1.21 +#include <e32test.h>
1.22 +#include <bautils.h>
1.23 +#include <s32stor.h>
1.24 +#include <sqldb.h>
1.25 +
1.26 +///////////////////////////////////////////////////////////////////////////////////////
1.27 +
1.28 +static RFs TheFs;
1.29 +RTest TheTest(_L("t_sqlattach2 test"));
1.30 +RSqlDatabase TheDb;
1.31 +RSqlDatabase TheDb2;
1.32 +_LIT(KTestMMCDir, "c:\\test\\");
1.33 +_LIT(KTestDir, "E:\\test\\");
1.34 +_LIT(KTestDatabase1, "c:\\test\\t_sqlattach2_1.db");
1.35 +_LIT(KTestMMCDatabase1, "E:\\test\\t_sqlattach2_2.db");
1.36 +_LIT(KTestMMCDatabase2, "E:\\test\\t_sqlattach2_3.db");
1.37 +
1.38 +
1.39 +_LIT(KTxtInsertMMCTxt," Insert MMC card\r\n");
1.40 +_LIT(KTxtRemoveMMCTxt," Remove MMC card\r\n");
1.41 +_LIT(KTxtPressAnyKey," [press any key to continue]\r\n");
1.42 +_LIT(KTxtDefectTitle,"DEF116630 SQL, Missing test scenario: Open db, attach db on external media, remove media");
1.43 +
1.44 +
1.45 +///////////////////////////////////////////////////////////////////////////////////////
1.46 +///////////////////////////////////////////////////////////////////////////////////////
1.47 +//Test macros and functions
1.48 +void Check1(TInt aValue, TInt aLine)
1.49 + {
1.50 + if(!aValue)
1.51 + {
1.52 + RDebug::Print(_L("*** Line %d\r\n"), aLine);
1.53 + TheTest(EFalse, aLine);
1.54 + }
1.55 + }
1.56 +void Check2(TInt aValue, TInt aExpected, TInt aLine)
1.57 + {
1.58 + if(aValue != aExpected)
1.59 + {
1.60 + RDebug::Print(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);
1.61 + TheTest(EFalse, aLine);
1.62 + }
1.63 + }
1.64 +#define TEST(arg) ::Check1((arg), __LINE__)
1.65 +#define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)
1.66 +
1.67 +///////////////////////////////////////////////////////////////////////////////////////
1.68 +
1.69 +//Creates file session instance and the test directory
1.70 +void CreateTestEnv()
1.71 + {
1.72 + TInt err = TheFs.Connect();
1.73 + TEST2(err, KErrNone);
1.74 +
1.75 + err = TheFs.MkDir(KTestDir);
1.76 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.77 + err = TheFs.MkDir(KTestMMCDir);
1.78 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.79 + }
1.80 +
1.81 +
1.82 +/**
1.83 +@SYMTestCaseID SYSLIB-SQL-CT-4021
1.84 +@SYMTestCaseDesc Determine the result of union select operations on an external media located attached database
1.85 + when the external media is removed.
1.86 +@SYMTestPriority Medium
1.87 +
1.88 +@SYMTestActions Create database one on internal media and database two on external media.
1.89 + Insert records into both databases.
1.90 + Attach database two which resides on MMC card to database one.
1.91 + Prepare a union SELECT sql statement1 to retrieve records from the internal and attached database with database two listed before database one.
1.92 + Prepare a union SELECT sql statement2 to retrieve records from the internal and attached database with database one listed before database two
1.93 + Pauses and prompts the removal of the MMC card.
1.94 + Exec union select statement1 across databases.
1.95 + Exec union select statement2 across databases.
1.96 +
1.97 +@SYMTestExpectedResults Databases are created and populated successfully.
1.98 + Database are attached sucessfully.
1.99 + Union statement1 operations return KErrNotReady
1.100 + Union statement2 operations return one record from internal database.
1.101 +@SYMDEF DEF116630
1.102 +*/
1.103 +void SqlAttachMMCDb2InternalDbUnionTestL()
1.104 + {
1.105 +
1.106 + CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
1.107 + CleanupStack::PushL(console);
1.108 + console->Printf(KTxtInsertMMCTxt);
1.109 + console->Printf(KTxtPressAnyKey);
1.110 + console->Getch(); // get and ignore character
1.111 +
1.112 + //Initially remove any preexisting database;
1.113 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.114 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.115 +
1.116 + TInt err = TheDb.Create(KTestDatabase1);
1.117 + TEST2(err, KErrNone);
1.118 + err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
1.119 + TEST(err >= 0);
1.120 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
1.121 + TEST2(err, 1);
1.122 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
1.123 + TEST2(err, 1);
1.124 + TheDb.Close();
1.125 +
1.126 + err = TheDb.Create(KTestMMCDatabase1);
1.127 + TEST2(err, KErrNone);
1.128 + err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
1.129 + TEST(err >= 0);
1.130 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
1.131 + TEST2(err, 1);
1.132 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
1.133 + TEST2(err, 1);
1.134 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
1.135 + TEST2(err, 1);
1.136 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.137 + TEST2(err, 1);
1.138 + TheDb.Close();
1.139 +
1.140 + err = TheDb.Open(KTestDatabase1);
1.141 + TEST2(err, KErrNone);
1.142 + err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
1.143 + TEST2(err, KErrNone);
1.144 +
1.145 + RSqlStatement stmt;
1.146 + err = stmt.Prepare(TheDb, _L8("SELECT * FROM B union all Select * from A"));
1.147 + TEST2(err, KErrNone);
1.148 +
1.149 + RSqlStatement stmt2;
1.150 + err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A union all Select * from B"));
1.151 + TEST2(err, KErrNone);
1.152 +
1.153 + console->Printf(KTxtRemoveMMCTxt);
1.154 + console->Printf(KTxtPressAnyKey);
1.155 + console->Getch(); // get and ignore character
1.156 +
1.157 + err = stmt.Next();
1.158 + TEST2(err, KSqlAtRow);
1.159 + stmt.Close();
1.160 +
1.161 + err = stmt2.Next();
1.162 + TEST2(err, KSqlAtRow);
1.163 + stmt2.Close();
1.164 +
1.165 + err = TheDb.Detach(_L("Db2"));
1.166 + TEST2(err, KErrNone);
1.167 +
1.168 + TheDb.Close();
1.169 +
1.170 + CleanupStack::PopAndDestroy(); // close console
1.171 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.172 + }
1.173 +
1.174 +
1.175 +/**
1.176 +@SYMTestCaseID SYSLIB-SQL-CT-4022
1.177 +@SYMTestCaseDesc Determine the result of operations on an external media located attached database
1.178 + when the external media is removed.
1.179 +
1.180 +@SYMTestPriority Medium
1.181 +@SYMTestActions Create database one on internal media and database two on external media.
1.182 + Insert records into both databases.
1.183 + Attach database two which resides on MMC card to database one.
1.184 + Prepare a SELECT sql statement to retrieve records from the attached database two.
1.185 + Retrieve a record from database 2.
1.186 + Pauses and prompts the removal of the MMC card.
1.187 + Attempt to insert two records into database two.
1.188 + Prepare a SELECT sql statement to retrieve records from the attached database one.
1.189 + Attempt to select a record from dabase one.
1.190 + Attempt to insert record into database one.
1.191 + Reinsert the MMC card.
1.192 + Attempt to insert record in database one.
1.193 + Attempt to insert a record in database two.
1.194 +
1.195 +@SYMTestExpectedResults Databases are created and populated successfully.
1.196 + Database are attached sucessfully.
1.197 + Select operations on database one are successful
1.198 + After MMC removal
1.199 + Disk write for database two return KErrNotReady.
1.200 + Select operations on database two are successful
1.201 + Select operations on database one are successful
1.202 + Write operations for database one are successful.
1.203 + After MMC re-insert
1.204 + Inserting a record into database one are succesful.
1.205 + Inserting a record into database two are successful
1.206 +
1.207 +@SYMDEF DEF116630
1.208 +*/
1.209 +void SqlAttachMMCDb2InternalDbTestL()
1.210 + {
1.211 +
1.212 + CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
1.213 + CleanupStack::PushL(console);
1.214 + console->Printf(KTxtInsertMMCTxt);
1.215 + console->Printf(KTxtPressAnyKey);
1.216 + console->Getch(); // get and ignore character
1.217 +
1.218 + //Initially remove any preexisting database;
1.219 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.220 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.221 +
1.222 + TInt err = TheDb.Create(KTestDatabase1);
1.223 + TEST2(err, KErrNone);
1.224 + err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
1.225 + TEST(err >= 0);
1.226 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
1.227 + TEST2(err, 1);
1.228 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
1.229 + TEST2(err, 1);
1.230 + TheDb.Close();
1.231 +
1.232 + err = TheDb.Create(KTestMMCDatabase1);
1.233 + TEST2(err, KErrNone);
1.234 + err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
1.235 + TEST(err >= 0);
1.236 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
1.237 + TEST2(err, 1);
1.238 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
1.239 + TEST2(err, 1);
1.240 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
1.241 + TEST2(err, 1);
1.242 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.243 + TEST2(err, 1);
1.244 + TheDb.Close();
1.245 +
1.246 + err = TheDb.Open(KTestDatabase1);
1.247 + TEST2(err, KErrNone);
1.248 + err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
1.249 + TEST2(err, KErrNone);
1.250 +
1.251 + RSqlStatement stmt;
1.252 + err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
1.253 + TEST2(err, KErrNone);
1.254 +
1.255 + err = stmt.Next();
1.256 + TEST2(err, KSqlAtRow);
1.257 +
1.258 + console->Printf(KTxtRemoveMMCTxt);
1.259 + console->Printf(KTxtPressAnyKey);
1.260 + console->Getch(); // get and ignore character
1.261 +
1.262 + err = stmt.Next();
1.263 + TEST2(err, KSqlAtRow);
1.264 +
1.265 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.266 + TEST2(err, KErrNotReady);
1.267 +
1.268 +
1.269 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
1.270 + TEST2(err, KErrNotReady);
1.271 +
1.272 +
1.273 + err = stmt.Next();
1.274 + TEST2(err, KSqlAtRow);
1.275 + stmt.Close();
1.276 +//Check that you can still perform operations on internal media based database
1.277 + RSqlStatement stmt2;
1.278 + err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
1.279 + TEST2(err, KErrNone);
1.280 + err = stmt2.Next();
1.281 + TEST2(err, KSqlAtRow);
1.282 +
1.283 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
1.284 + TEST2(err, 1);
1.285 +
1.286 + err = stmt2.Next();
1.287 + TEST2(err, KSqlAtRow);
1.288 + stmt2.Close();
1.289 +
1.290 + //Check that databases start working again when mmc card reinserted.
1.291 + console->Printf(KTxtInsertMMCTxt);
1.292 + console->Printf(KTxtPressAnyKey);
1.293 + console->Getch(); // get and ignore character
1.294 +
1.295 + err = TheDb.Detach(_L("Db2"));
1.296 + TEST2(err, KErrNone);
1.297 +
1.298 + TheDb.Close();
1.299 +
1.300 + err = TheDb2.Open(KTestDatabase1);
1.301 + TEST2(err, KErrNone);
1.302 + err = TheDb2.Attach(KTestMMCDatabase1, _L("Db2"));
1.303 + TEST2(err, KErrNone);
1.304 +
1.305 +
1.306 + err = TheDb2.Exec(_L8("INSERT INTO A(Id) VALUES(50)"));
1.307 + TEST2(err, 1);
1.308 + err = TheDb2.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
1.309 + TEST2(err, 1);
1.310 +
1.311 + err = TheDb2.Detach(_L("Db2"));
1.312 + TEST2(err, KErrNone);
1.313 +
1.314 + TheDb2.Close();
1.315 + CleanupStack::PopAndDestroy(); // close console
1.316 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.317 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.318 + }
1.319 +
1.320 +/**
1.321 +@SYMTestCaseID SYSLIB-SQL-CT-4023
1.322 +@SYMTestCaseDesc Determine the result of multiple disk write operations on an internal and
1.323 + external media located database when the attached external media is removed.
1.324 +@SYMTestPriority Medium
1.325 +
1.326 +@SYMTestActions Create database 1 on internal media and database two on external media.
1.327 + Insert records into both databases.
1.328 + Attaches database 2 which resides on MMC card to database 1.
1.329 + Prepare a SELECT sql statement to retrieve records from database 1.
1.330 + Retrieve a record from database 1.
1.331 + Pause and prompts the removal of the MMC card.
1.332 + Attempt to insert a record into database one.
1.333 + Attempt to select records from dabase one.
1.334 + Attempt to prepare a select statement on database two.
1.335 + Attempt to retrieve a record from database two.
1.336 + Attempts to insert record into database two.
1.337 +@SYMTestExpectedResults Databases are created and populated successfully.
1.338 + Database are attached sucessfully.
1.339 + Prepare and select operations on database one are successful
1.340 + MMC Removed
1.341 + Write operations on database one are successful.
1.342 + Select operations on database one are successful.
1.343 + Prepare statement on database two are successful
1.344 + Disk read/write operations on database two return KErrNotReady.
1.345 +
1.346 +@SYMDEF DEF116630
1.347 +*/
1.348 +void SqlAttachMMCDb2InternalDbAndDoDiskOpsTestL()
1.349 + {
1.350 +
1.351 + CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
1.352 + CleanupStack::PushL(console);
1.353 + console->Printf(KTxtInsertMMCTxt);
1.354 + console->Printf(KTxtPressAnyKey);
1.355 + console->Getch(); // get and ignore character
1.356 +
1.357 + //Initially remove any preexisting database;
1.358 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.359 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.360 +
1.361 + TInt err = TheDb.Create(KTestDatabase1);
1.362 + TEST2(err, KErrNone);
1.363 + err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
1.364 + TEST(err >= 0);
1.365 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
1.366 + TEST2(err, 1);
1.367 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
1.368 + TEST2(err, 1);
1.369 + TheDb.Close();
1.370 +
1.371 + err = TheDb.Create(KTestMMCDatabase1);
1.372 + TEST2(err, KErrNone);
1.373 + err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
1.374 + TEST(err >= 0);
1.375 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
1.376 + TEST2(err, 1);
1.377 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
1.378 + TEST2(err, 1);
1.379 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
1.380 + TEST2(err, 1);
1.381 + TheDb.Close();
1.382 +
1.383 + err = TheDb.Open(KTestDatabase1);
1.384 + TEST2(err, KErrNone);
1.385 + err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
1.386 + TEST2(err, KErrNone);
1.387 +
1.388 + RSqlStatement stmt;
1.389 + err = stmt.Prepare(TheDb, _L8("SELECT * FROM A"));
1.390 + TEST2(err, KErrNone);
1.391 + err = stmt.Next();
1.392 + TEST2(err, KSqlAtRow);
1.393 +
1.394 + console->Printf(KTxtRemoveMMCTxt);
1.395 + console->Printf(KTxtPressAnyKey);
1.396 + console->Getch(); // get and ignore character
1.397 +
1.398 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
1.399 + TEST2(err, 1);
1.400 +
1.401 + err = stmt.Next();
1.402 + TEST2(err, KSqlAtRow);
1.403 +
1.404 + stmt.Close();
1.405 +
1.406 +//Check that you can still perform operations on external media based database
1.407 + RSqlStatement stmt2;
1.408 + err = stmt2.Prepare(TheDb, _L8("SELECT * FROM B"));
1.409 + TEST2(err, KErrNone);
1.410 + err = stmt2.Next();
1.411 + TEST2(err,KSqlAtRow);
1.412 +
1.413 + stmt2.Close();
1.414 +
1.415 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.416 + TEST2(err, KErrNotReady);
1.417 +
1.418 + err = TheDb.Detach(_L("Db2"));
1.419 + TEST2(err, KErrNone);
1.420 +
1.421 + TheDb.Close();
1.422 + CleanupStack::PopAndDestroy(); // close console
1.423 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.424 + }
1.425 +
1.426 +/**
1.427 +@SYMTestCaseID SYSLIB-SQL-CT-4024
1.428 +@SYMTestCaseDesc Determine the result of operations on an internal media located attached database
1.429 + to a external media database
1.430 + when the external media is removed.
1.431 +@SYMTestPriority Medium
1.432 +
1.433 +@SYMTestActions Create database 1 on internal media and database two on external media.
1.434 + Insert records into both databases.
1.435 + Attempt to Attach database 1 to database two which resides on MMC card.
1.436 + Attempt to Prepare a SELECT statement to retrieve records from the attached database 2.
1.437 + Attempt to retrieve record from database two.
1.438 + Pause and prompts the removal of the MMC card.
1.439 + Attempt to SELECT a record from database two.
1.440 + Attempt to insert a record into database two.
1.441 + Attempt to SELECT a record from database two.
1.442 + Attempt to prepare a select statement on database one.
1.443 + Attempt to select records from dabase one.
1.444 + Attempt to insert record into database one.
1.445 +
1.446 +@SYMTestExpectedResults Databases are created and populated successfully.
1.447 + Database are attached sucessfully.
1.448 + Select operations on database two are successful
1.449 + MMC Removed
1.450 + Select operation on database two is successful
1.451 + Operations involving a disk write for database 2 return KErrNotReady.
1.452 + Select operation on database two is successful
1.453 + Prepare select operations on database on is successful
1.454 + Select operations on database one are successful
1.455 + Insert operations on database one are successful
1.456 +@SYMDEF DEF116630
1.457 +*/
1.458 +void SqlAttachInternalDb2MMCDbTestL()
1.459 + {
1.460 +
1.461 + CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
1.462 + CleanupStack::PushL(console);
1.463 + console->Printf(KTxtInsertMMCTxt);
1.464 + console->Printf(KTxtPressAnyKey);
1.465 + console->Getch(); // get and ignore character
1.466 +
1.467 + //Initially remove any preexisting database;
1.468 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.469 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.470 +
1.471 + TInt err = TheDb.Create(KTestDatabase1);
1.472 + TEST2(err, KErrNone);
1.473 + err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
1.474 + TEST(err >= 0);
1.475 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
1.476 + TEST2(err, 1);
1.477 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
1.478 + TEST2(err, 1);
1.479 + TheDb.Close();
1.480 +
1.481 + err = TheDb.Create(KTestMMCDatabase1);
1.482 + TEST2(err, KErrNone);
1.483 + err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
1.484 + TEST(err >= 0);
1.485 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
1.486 + TEST2(err, 1);
1.487 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
1.488 + TEST2(err, 1);
1.489 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
1.490 + TEST2(err, 1);
1.491 + TheDb.Close();
1.492 +
1.493 + err = TheDb.Open(KTestMMCDatabase1);
1.494 + TEST2(err, KErrNone);
1.495 + err = TheDb.Attach(KTestDatabase1, _L("Db2"));
1.496 + TEST2(err, KErrNone);
1.497 +
1.498 + RSqlStatement stmt;
1.499 + err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
1.500 + TEST2(err, KErrNone);
1.501 + err = stmt.Next();
1.502 + TEST2(err, KSqlAtRow);
1.503 +
1.504 + console->Printf(KTxtRemoveMMCTxt);
1.505 + console->Printf(KTxtPressAnyKey);
1.506 + console->Getch(); // get and ignore character
1.507 +
1.508 + err = stmt.Next();
1.509 + TEST2(err, KSqlAtRow);
1.510 +
1.511 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.512 + TEST2(err, KErrNotReady);
1.513 +
1.514 + err = stmt.Next();
1.515 + TEST2(err, KSqlAtRow);
1.516 + stmt.Close();
1.517 +
1.518 +//Check that you can still perform operations on internal media based database
1.519 + RSqlStatement stmt2;
1.520 + err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
1.521 + TEST2(err, KErrNone);
1.522 + err = stmt2.Next();
1.523 + TEST2(err, KSqlAtRow);
1.524 +
1.525 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
1.526 + TEST2(err, 1);
1.527 +
1.528 + err = stmt2.Next();
1.529 + TEST2(err, KSqlAtRow);
1.530 + stmt2.Close();
1.531 +
1.532 + err = TheDb.Detach(_L("Db2"));
1.533 + TEST2(err, KErrNone);
1.534 +
1.535 + TheDb.Close();
1.536 + CleanupStack::PopAndDestroy(); // close console
1.537 + (void)RSqlDatabase::Delete(KTestDatabase1);
1.538 + }
1.539 +
1.540 +/**
1.541 +@SYMTestCaseID SYSLIB-SQL-CT-4025
1.542 +@SYMTestCaseDesc Determine the result of operations on an external media located attached database
1.543 + to another external media database when the external media is removed.
1.544 +@SYMTestPriority Medium
1.545 +@SYMTestActions Create database one and database two on external media.
1.546 + Insert records into both databases.
1.547 + Attach database two to database one
1.548 + Prepare a select statement on database two.
1.549 + Retrieve a record from database two.
1.550 + Pause and prompts the removal of the MMC card.
1.551 + Retrieve a record from database two.
1.552 + Attempt to insert a record into database two.
1.553 + Attempt to insert another record into database two.
1.554 + Retrieve a record from database two.
1.555 + Prepare a select statement on database one.
1.556 + Attempt to retrieve record from database one.
1.557 + Attempt to insert a record into database one.
1.558 + Attempt to retrieve record from database one.
1.559 +
1.560 +@SYMTestExpectedResults Databases are created and populated successfully.
1.561 + Database are attached sucessfully.
1.562 + Select operations on database two are successful
1.563 + MMC Removed.
1.564 + Read operations are successful on database two.
1.565 + First Insert operation return KErrNotReady for database two.
1.566 + Second Insert operation return KErrNotReady for database two.
1.567 + Read operations are still successful on database two.
1.568 + Read operations are still successful on database one.
1.569 + Insert operation returns KErrNotReady.
1.570 + Read operations are still successful on database one.
1.571 +@SYMDEF DEF116630
1.572 +*/
1.573 +void SqlAttachMMCDb12MMCDb2TestL()
1.574 + {
1.575 +
1.576 + CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
1.577 + CleanupStack::PushL(console);
1.578 + console->Printf(KTxtInsertMMCTxt);
1.579 + console->Printf(KTxtPressAnyKey);
1.580 + console->Getch(); // get and ignore character
1.581 +
1.582 + //Initially remove any preexisting database;
1.583 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.584 + (void)RSqlDatabase::Delete(KTestMMCDatabase2);
1.585 +
1.586 + TInt err = TheDb.Create(KTestMMCDatabase1);
1.587 + TEST2(err, KErrNone);
1.588 + err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
1.589 + TEST(err >= 0);
1.590 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
1.591 + TEST2(err, 1);
1.592 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
1.593 + TEST2(err, 1);
1.594 + TheDb.Close();
1.595 +
1.596 + err = TheDb.Create(KTestMMCDatabase2);
1.597 + TEST2(err, KErrNone);
1.598 + err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
1.599 + TEST(err >= 0);
1.600 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
1.601 + TEST2(err, 1);
1.602 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
1.603 + TEST2(err, 1);
1.604 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
1.605 + TEST2(err, 1);
1.606 + TheDb.Close();
1.607 +
1.608 + err = TheDb.Open(KTestMMCDatabase1);
1.609 + TEST2(err, KErrNone);
1.610 + err = TheDb.Attach(KTestMMCDatabase2, _L("Db2"));
1.611 + TEST2(err, KErrNone);
1.612 +
1.613 + RSqlStatement stmt;
1.614 + err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
1.615 + TEST2(err, KErrNone);
1.616 + err = stmt.Next();
1.617 + TEST2(err, KSqlAtRow);
1.618 +
1.619 + console->Printf(KTxtRemoveMMCTxt);
1.620 + console->Printf(KTxtPressAnyKey);
1.621 + console->Getch(); // get and ignore character
1.622 +
1.623 + err = stmt.Next();
1.624 + TEST2(err, KSqlAtRow);
1.625 +
1.626 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
1.627 + TEST2(err, KErrNotReady);
1.628 +
1.629 + err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
1.630 + TEST2(err, KErrNotReady);
1.631 +
1.632 + err = stmt.Next();
1.633 + TEST2(err, KSqlAtRow);
1.634 + stmt.Close();
1.635 +
1.636 +//Check the error conditions when you attempt operations on the other database
1.637 + RSqlStatement stmt2;
1.638 + err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
1.639 + TEST2(err, KErrNone);
1.640 + err = stmt2.Next();
1.641 + TEST2(err, KSqlAtRow);
1.642 +
1.643 + err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
1.644 + TEST2(err, KErrNotReady);
1.645 +
1.646 + err = stmt2.Next();
1.647 + TEST2(err, KSqlAtRow);
1.648 + stmt2.Close();
1.649 +
1.650 + TheDb.Close();
1.651 +
1.652 + //Initially remove any preexisting database;
1.653 + (void)RSqlDatabase::Delete(KTestMMCDatabase1);
1.654 + (void)RSqlDatabase::Delete(KTestMMCDatabase2);
1.655 +
1.656 + CleanupStack::PopAndDestroy(); // close console
1.657 + }
1.658 +
1.659 +
1.660 +
1.661 +void DoTestsL()
1.662 + {
1.663 + TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4022 \"SQL against attached MMC db when MMC removed\" test "));
1.664 + SqlAttachMMCDb2InternalDbTestL();
1.665 +
1.666 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4024 SQL against MMC db with attached internal database when MMC removed "));
1.667 + SqlAttachInternalDb2MMCDbTestL();
1.668 +
1.669 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4025 SQL against MMC based db with attached MMC based database when MMC removed "));
1.670 + SqlAttachMMCDb12MMCDb2TestL();
1.671 +
1.672 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4023 SQL against internal database with attached MMC db when MMC removed "));
1.673 + SqlAttachMMCDb2InternalDbAndDoDiskOpsTestL();
1.674 +
1.675 + TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4021 SQL UNION against internal database with attached MMC db when MMC removed "));
1.676 + SqlAttachMMCDb2InternalDbUnionTestL();
1.677 +
1.678 + }
1.679 +
1.680 +TInt E32Main()
1.681 + {
1.682 + TheTest.Title();
1.683 +
1.684 + CTrapCleanup* tc = CTrapCleanup::New();
1.685 +
1.686 + __UHEAP_MARK;
1.687 + CreateTestEnv();
1.688 + TRAPD(err, DoTestsL());
1.689 + TheFs.Close();
1.690 + TEST2(err, KErrNone);
1.691 +
1.692 + __UHEAP_MARKEND;
1.693 +
1.694 + TheTest.End();
1.695 + TheTest.Close();
1.696 +
1.697 + delete tc;
1.698 +
1.699 + User::Heap().Check();
1.700 + return KErrNone;
1.701 + }