// 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();