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