--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/TEST/t_sqlattach2.cpp Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,698 @@
+// Copyright (c) 2008-2009 Nokia Corporation and/or its subsidiary(-ies).
+// All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of "Eclipse Public License v1.0"
+// which accompanies this distribution, and is available
+// at the URL "http://www.eclipse.org/legal/epl-v10.html".
+//
+// Initial Contributors:
+// Nokia Corporation - initial contribution.
+//
+// Contributors:
+//
+// Description:
+// Note: Only runs on hardware as you cannot remove MMC card on emulator
+//
+//
+
+#include <e32test.h>
+#include <bautils.h>
+#include <s32stor.h>
+#include <sqldb.h>
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+static RFs TheFs;
+RTest TheTest(_L("t_sqlattach2 test"));
+RSqlDatabase TheDb;
+RSqlDatabase TheDb2;
+_LIT(KTestMMCDir, "c:\\test\\");
+_LIT(KTestDir, "E:\\test\\");
+_LIT(KTestDatabase1, "c:\\test\\t_sqlattach2_1.db");
+_LIT(KTestMMCDatabase1, "E:\\test\\t_sqlattach2_2.db");
+_LIT(KTestMMCDatabase2, "E:\\test\\t_sqlattach2_3.db");
+
+
+_LIT(KTxtInsertMMCTxt," Insert MMC card\r\n");
+_LIT(KTxtRemoveMMCTxt," Remove MMC card\r\n");
+_LIT(KTxtPressAnyKey," [press any key to continue]\r\n");
+_LIT(KTxtDefectTitle,"DEF116630 SQL, Missing test scenario: Open db, attach db on external media, remove media");
+
+
+///////////////////////////////////////////////////////////////////////////////////////
+///////////////////////////////////////////////////////////////////////////////////////
+//Test macros and functions
+void Check1(TInt aValue, TInt aLine)
+ {
+ if(!aValue)
+ {
+ RDebug::Print(_L("*** Line %d\r\n"), aLine);
+ TheTest(EFalse, aLine);
+ }
+ }
+void Check2(TInt aValue, TInt aExpected, TInt aLine)
+ {
+ if(aValue != aExpected)
+ {
+ RDebug::Print(_L("*** Line %d, Expected error: %d, got: %d\r\n"), aLine, aExpected, aValue);
+ TheTest(EFalse, aLine);
+ }
+ }
+#define TEST(arg) ::Check1((arg), __LINE__)
+#define TEST2(aValue, aExpected) ::Check2(aValue, aExpected, __LINE__)
+
+///////////////////////////////////////////////////////////////////////////////////////
+
+//Creates file session instance and the test directory
+void CreateTestEnv()
+ {
+ TInt err = TheFs.Connect();
+ TEST2(err, KErrNone);
+
+ err = TheFs.MkDir(KTestDir);
+ TEST(err == KErrNone || err == KErrAlreadyExists);
+ err = TheFs.MkDir(KTestMMCDir);
+ TEST(err == KErrNone || err == KErrAlreadyExists);
+ }
+
+
+/**
+@SYMTestCaseID SYSLIB-SQL-CT-4021
+@SYMTestCaseDesc Determine the result of union select operations on an external media located attached database
+ when the external media is removed.
+@SYMTestPriority Medium
+
+@SYMTestActions Create database one on internal media and database two on external media.
+ Insert records into both databases.
+ Attach database two which resides on MMC card to database one.
+ Prepare a union SELECT sql statement1 to retrieve records from the internal and attached database with database two listed before database one.
+ Prepare a union SELECT sql statement2 to retrieve records from the internal and attached database with database one listed before database two
+ Pauses and prompts the removal of the MMC card.
+ Exec union select statement1 across databases.
+ Exec union select statement2 across databases.
+
+@SYMTestExpectedResults Databases are created and populated successfully.
+ Database are attached sucessfully.
+ Union statement1 operations return KErrNotReady
+ Union statement2 operations return one record from internal database.
+@SYMDEF DEF116630
+*/
+void SqlAttachMMCDb2InternalDbUnionTestL()
+ {
+
+ CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
+ CleanupStack::PushL(console);
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+
+ TInt err = TheDb.Create(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Create(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Open(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt;
+ err = stmt.Prepare(TheDb, _L8("SELECT * FROM B union all Select * from A"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt2;
+ err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A union all Select * from B"));
+ TEST2(err, KErrNone);
+
+ console->Printf(KTxtRemoveMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+ stmt.Close();
+
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+ stmt2.Close();
+
+ err = TheDb.Detach(_L("Db2"));
+ TEST2(err, KErrNone);
+
+ TheDb.Close();
+
+ CleanupStack::PopAndDestroy(); // close console
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+ }
+
+
+/**
+@SYMTestCaseID SYSLIB-SQL-CT-4022
+@SYMTestCaseDesc Determine the result of operations on an external media located attached database
+ when the external media is removed.
+
+@SYMTestPriority Medium
+@SYMTestActions Create database one on internal media and database two on external media.
+ Insert records into both databases.
+ Attach database two which resides on MMC card to database one.
+ Prepare a SELECT sql statement to retrieve records from the attached database two.
+ Retrieve a record from database 2.
+ Pauses and prompts the removal of the MMC card.
+ Attempt to insert two records into database two.
+ Prepare a SELECT sql statement to retrieve records from the attached database one.
+ Attempt to select a record from dabase one.
+ Attempt to insert record into database one.
+ Reinsert the MMC card.
+ Attempt to insert record in database one.
+ Attempt to insert a record in database two.
+
+@SYMTestExpectedResults Databases are created and populated successfully.
+ Database are attached sucessfully.
+ Select operations on database one are successful
+ After MMC removal
+ Disk write for database two return KErrNotReady.
+ Select operations on database two are successful
+ Select operations on database one are successful
+ Write operations for database one are successful.
+ After MMC re-insert
+ Inserting a record into database one are succesful.
+ Inserting a record into database two are successful
+
+@SYMDEF DEF116630
+*/
+void SqlAttachMMCDb2InternalDbTestL()
+ {
+
+ CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
+ CleanupStack::PushL(console);
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+
+ TInt err = TheDb.Create(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Create(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Open(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt;
+ err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
+ TEST2(err, KErrNone);
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ console->Printf(KTxtRemoveMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, KErrNotReady);
+
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
+ TEST2(err, KErrNotReady);
+
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+ stmt.Close();
+//Check that you can still perform operations on internal media based database
+ RSqlStatement stmt2;
+ err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
+ TEST2(err, KErrNone);
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
+ TEST2(err, 1);
+
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+ stmt2.Close();
+
+ //Check that databases start working again when mmc card reinserted.
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = TheDb.Detach(_L("Db2"));
+ TEST2(err, KErrNone);
+
+ TheDb.Close();
+
+ err = TheDb2.Open(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb2.Attach(KTestMMCDatabase1, _L("Db2"));
+ TEST2(err, KErrNone);
+
+
+ err = TheDb2.Exec(_L8("INSERT INTO A(Id) VALUES(50)"));
+ TEST2(err, 1);
+ err = TheDb2.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
+ TEST2(err, 1);
+
+ err = TheDb2.Detach(_L("Db2"));
+ TEST2(err, KErrNone);
+
+ TheDb2.Close();
+ CleanupStack::PopAndDestroy(); // close console
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+ }
+
+/**
+@SYMTestCaseID SYSLIB-SQL-CT-4023
+@SYMTestCaseDesc Determine the result of multiple disk write operations on an internal and
+ external media located database when the attached external media is removed.
+@SYMTestPriority Medium
+
+@SYMTestActions Create database 1 on internal media and database two on external media.
+ Insert records into both databases.
+ Attaches database 2 which resides on MMC card to database 1.
+ Prepare a SELECT sql statement to retrieve records from database 1.
+ Retrieve a record from database 1.
+ Pause and prompts the removal of the MMC card.
+ Attempt to insert a record into database one.
+ Attempt to select records from dabase one.
+ Attempt to prepare a select statement on database two.
+ Attempt to retrieve a record from database two.
+ Attempts to insert record into database two.
+@SYMTestExpectedResults Databases are created and populated successfully.
+ Database are attached sucessfully.
+ Prepare and select operations on database one are successful
+ MMC Removed
+ Write operations on database one are successful.
+ Select operations on database one are successful.
+ Prepare statement on database two are successful
+ Disk read/write operations on database two return KErrNotReady.
+
+@SYMDEF DEF116630
+*/
+void SqlAttachMMCDb2InternalDbAndDoDiskOpsTestL()
+ {
+
+ CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
+ CleanupStack::PushL(console);
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+
+ TInt err = TheDb.Create(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Create(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Open(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Attach(KTestMMCDatabase1, _L("Db2"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt;
+ err = stmt.Prepare(TheDb, _L8("SELECT * FROM A"));
+ TEST2(err, KErrNone);
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ console->Printf(KTxtRemoveMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
+ TEST2(err, 1);
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ stmt.Close();
+
+//Check that you can still perform operations on external media based database
+ RSqlStatement stmt2;
+ err = stmt2.Prepare(TheDb, _L8("SELECT * FROM B"));
+ TEST2(err, KErrNone);
+ err = stmt2.Next();
+ TEST2(err,KSqlAtRow);
+
+ stmt2.Close();
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, KErrNotReady);
+
+ err = TheDb.Detach(_L("Db2"));
+ TEST2(err, KErrNone);
+
+ TheDb.Close();
+ CleanupStack::PopAndDestroy(); // close console
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+ }
+
+/**
+@SYMTestCaseID SYSLIB-SQL-CT-4024
+@SYMTestCaseDesc Determine the result of operations on an internal media located attached database
+ to a external media database
+ when the external media is removed.
+@SYMTestPriority Medium
+
+@SYMTestActions Create database 1 on internal media and database two on external media.
+ Insert records into both databases.
+ Attempt to Attach database 1 to database two which resides on MMC card.
+ Attempt to Prepare a SELECT statement to retrieve records from the attached database 2.
+ Attempt to retrieve record from database two.
+ Pause and prompts the removal of the MMC card.
+ Attempt to SELECT a record from database two.
+ Attempt to insert a record into database two.
+ Attempt to SELECT a record from database two.
+ Attempt to prepare a select statement on database one.
+ Attempt to select records from dabase one.
+ Attempt to insert record into database one.
+
+@SYMTestExpectedResults Databases are created and populated successfully.
+ Database are attached sucessfully.
+ Select operations on database two are successful
+ MMC Removed
+ Select operation on database two is successful
+ Operations involving a disk write for database 2 return KErrNotReady.
+ Select operation on database two is successful
+ Prepare select operations on database on is successful
+ Select operations on database one are successful
+ Insert operations on database one are successful
+@SYMDEF DEF116630
+*/
+void SqlAttachInternalDb2MMCDbTestL()
+ {
+
+ CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
+ CleanupStack::PushL(console);
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+
+ TInt err = TheDb.Create(KTestDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Create(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Open(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Attach(KTestDatabase1, _L("Db2"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt;
+ err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
+ TEST2(err, KErrNone);
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ console->Printf(KTxtRemoveMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, KErrNotReady);
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+ stmt.Close();
+
+//Check that you can still perform operations on internal media based database
+ RSqlStatement stmt2;
+ err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
+ TEST2(err, KErrNone);
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
+ TEST2(err, 1);
+
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+ stmt2.Close();
+
+ err = TheDb.Detach(_L("Db2"));
+ TEST2(err, KErrNone);
+
+ TheDb.Close();
+ CleanupStack::PopAndDestroy(); // close console
+ (void)RSqlDatabase::Delete(KTestDatabase1);
+ }
+
+/**
+@SYMTestCaseID SYSLIB-SQL-CT-4025
+@SYMTestCaseDesc Determine the result of operations on an external media located attached database
+ to another external media database when the external media is removed.
+@SYMTestPriority Medium
+@SYMTestActions Create database one and database two on external media.
+ Insert records into both databases.
+ Attach database two to database one
+ Prepare a select statement on database two.
+ Retrieve a record from database two.
+ Pause and prompts the removal of the MMC card.
+ Retrieve a record from database two.
+ Attempt to insert a record into database two.
+ Attempt to insert another record into database two.
+ Retrieve a record from database two.
+ Prepare a select statement on database one.
+ Attempt to retrieve record from database one.
+ Attempt to insert a record into database one.
+ Attempt to retrieve record from database one.
+
+@SYMTestExpectedResults Databases are created and populated successfully.
+ Database are attached sucessfully.
+ Select operations on database two are successful
+ MMC Removed.
+ Read operations are successful on database two.
+ First Insert operation return KErrNotReady for database two.
+ Second Insert operation return KErrNotReady for database two.
+ Read operations are still successful on database two.
+ Read operations are still successful on database one.
+ Insert operation returns KErrNotReady.
+ Read operations are still successful on database one.
+@SYMDEF DEF116630
+*/
+void SqlAttachMMCDb12MMCDb2TestL()
+ {
+
+ CConsoleBase* console=Console::NewL(KTxtDefectTitle,TSize(KConsFullScreen,KConsFullScreen));
+ CleanupStack::PushL(console);
+ console->Printf(KTxtInsertMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestMMCDatabase2);
+
+ TInt err = TheDb.Create(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE A(Id INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(1)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(2)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Create(KTestMMCDatabase2);
+ TEST2(err, KErrNone);
+ err = TheDb.Exec(_L8("CREATE TABLE B(N INTEGER)"));
+ TEST(err >= 0);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(10)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(20)"));
+ TEST2(err, 1);
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(30)"));
+ TEST2(err, 1);
+ TheDb.Close();
+
+ err = TheDb.Open(KTestMMCDatabase1);
+ TEST2(err, KErrNone);
+ err = TheDb.Attach(KTestMMCDatabase2, _L("Db2"));
+ TEST2(err, KErrNone);
+
+ RSqlStatement stmt;
+ err = stmt.Prepare(TheDb, _L8("SELECT * FROM B"));
+ TEST2(err, KErrNone);
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ console->Printf(KTxtRemoveMMCTxt);
+ console->Printf(KTxtPressAnyKey);
+ console->Getch(); // get and ignore character
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(40)"));
+ TEST2(err, KErrNotReady);
+
+ err = TheDb.Exec(_L8("INSERT INTO B(N) VALUES(50)"));
+ TEST2(err, KErrNotReady);
+
+ err = stmt.Next();
+ TEST2(err, KSqlAtRow);
+ stmt.Close();
+
+//Check the error conditions when you attempt operations on the other database
+ RSqlStatement stmt2;
+ err = stmt2.Prepare(TheDb, _L8("SELECT * FROM A"));
+ TEST2(err, KErrNone);
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+
+ err = TheDb.Exec(_L8("INSERT INTO A(Id) VALUES(40)"));
+ TEST2(err, KErrNotReady);
+
+ err = stmt2.Next();
+ TEST2(err, KSqlAtRow);
+ stmt2.Close();
+
+ TheDb.Close();
+
+ //Initially remove any preexisting database;
+ (void)RSqlDatabase::Delete(KTestMMCDatabase1);
+ (void)RSqlDatabase::Delete(KTestMMCDatabase2);
+
+ CleanupStack::PopAndDestroy(); // close console
+ }
+
+
+
+void DoTestsL()
+ {
+ TheTest.Start(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4022 \"SQL against attached MMC db when MMC removed\" test "));
+ SqlAttachMMCDb2InternalDbTestL();
+
+ TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4024 SQL against MMC db with attached internal database when MMC removed "));
+ SqlAttachInternalDb2MMCDbTestL();
+
+ TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4025 SQL against MMC based db with attached MMC based database when MMC removed "));
+ SqlAttachMMCDb12MMCDb2TestL();
+
+ TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4023 SQL against internal database with attached MMC db when MMC removed "));
+ SqlAttachMMCDb2InternalDbAndDoDiskOpsTestL();
+
+ TheTest.Next(_L(" @SYMTestCaseID:SYSLIB-SQL-CT-4021 SQL UNION against internal database with attached MMC db when MMC removed "));
+ SqlAttachMMCDb2InternalDbUnionTestL();
+
+ }
+
+TInt E32Main()
+ {
+ TheTest.Title();
+
+ CTrapCleanup* tc = CTrapCleanup::New();
+
+ __UHEAP_MARK;
+ CreateTestEnv();
+ TRAPD(err, DoTestsL());
+ TheFs.Close();
+ TEST2(err, KErrNone);
+
+ __UHEAP_MARKEND;
+
+ TheTest.End();
+ TheTest.Close();
+
+ delete tc;
+
+ User::Heap().Check();
+ return KErrNone;
+ }