/**
@SYMTestCaseID SYSLIB-DBMS-CT-0637
@SYMTestCaseDesc Streaming conversions test
@SYMTestPriority Medium
@SYMTestActions Test the database definition and enquiry functions
@SYMTestExpectedResults Test must not fail
@SYMREQ REQ0000
*/
LOCAL_C void Test()
{
test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0637 Build without transactions "));
CreateDatabaseL();
TUint time1,size1;
BuildTable(KRecords,EFalse,time1,size1);
CloseDatabaseL();
test.Next(_L("Build with transactions"));
CreateDatabaseL();
TUint time2,size2;
BuildTable(KRecords,ETrue,time2,size2);
test.Printf(_L("Transaction performance: time %4.2f, size %4.2f\n"),TReal(time1)/TReal(time2),TReal(size1)/TReal(size2));
test.Next(_L("Build Int index"));
Execute(_L("create unique index int on table (int)"));
test.Next(_L("Break index"));
BreakIndex();
test.Next(_L("Build Text index"));
Execute(_L("create unique index text on table (text)"));
test.Next(_L("Recover"));
test (TheDatabase.IsDamaged());
CloseDatabaseL();
OpenDatabase();
test (TheDatabase.IsDamaged());
Recover();
test.Next(_L("Drop table"));
Execute(_L("drop table table"));
CloseDatabaseL();
}
/**
* Test Step postamble function, part of cleanup activity for the test step
*/
TVerdict CTestContactViewDatabaseUtilitiesStep::doTestStepPostambleL()
{
iPimTestServer.Close();
CloseDatabaseL();
UnInstallActiveSchedularL();
return TestStepResult();
}
/**
@SYMTestCaseID SYSLIB-DBMS-CT-0579
@SYMTestCaseDesc Tests the database definition and enquiry functions
@SYMTestPriority Medium
@SYMTestActions Executes the index and bookmark tests
@SYMTestExpectedResults Test must not fail
@SYMREQ REQ0000
*/
LOCAL_C void BigTestL()
{
test.Start(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-0579 Table "));
CreateDatabaseL();
BuildTable(KRecords);
test(TheTable.Open(TheDatabase,KTableName)==KErrNone);
TheTable.EndL();
IterateL(TheTable.EPrevious);
TheTable.BeginningL();
IterateL(TheTable.ENext);
TheTable.EndL();
IterateL(TheTable.EPrevious);
TheTable.Close();
test.Next(_L("Int32 Index"));
CDbKey *key=CDbKey::NewLC();
key->AddL(KColumnInt);
key->MakeUnique();
TestIndex(KIndexInt,*key);
test.Next(_L("Text[200] Index"));
key->Clear();
key->AddL(KColumnText);
key->MakeUnique();
TestIndex(KIndexText,*key);
test.Next(_L("Bookmarks"));
TestBookmark();
test.Next(_L("Int32 Index"));
#ifndef __TOOLS2__
TheTimer.Start(_L("drop"));
#endif
test(TheDatabase.DropIndex(KIndexInt,KTableName)==KErrNone);
#ifndef __TOOLS2__
TheTimer.Stop();
#endif
key->Clear();
key->AddL(KColumnInt);
key->MakeUnique();
TestIndex(KIndexInt,*key);
CleanupStack::PopAndDestroy();
test.Next(_L("Break & Recover"));
BreakIndex();
Recover();
test.Next(_L("Drop Indexes"));
DropIndexes();
test.Next(_L("Delete all records"));
DeleteTable();
CloseDatabaseL();
test.End();
}
/**
* Adds contact cards and groups in the database
*/
void CTestContactViewCRUDOperationsStep::CreateContactItemsL()
{
_LIT(KAddContacts, "add");
TBool addContacts = EFalse;
GetBoolFromConfig(ConfigSection(), KAddContacts, addContacts);
if(!addContacts)
{
return;
}
// Add contacts and groups in the main thread and validate the view count and view notifications
// in the contact views thread
TPtrC currentOperation(KAddContactOperations);
SetCurrentOperation(currentOperation);
AddContactEntriesL();
CloseDatabaseL();
OpenDataBaseL();
ResumeContactViewsThreadL();
}
/**
* Deletes contact items in the database
*/
void CTestContactViewCRUDOperationsStep::RemoveContactItemsL()
{
_LIT(KDeleteContacts, "delete");
TBool deleteContacts = EFalse;
GetBoolFromConfig(ConfigSection(), KDeleteContacts, deleteContacts);
if(!deleteContacts)
{
return;
}
// Delete Contacts in the main thread and validate the view count and view notifications
// in the contact views thread
TPtrC currentOperation(KRemoveContactsOperations);
SetCurrentOperation(currentOperation);
DeleteContactCardsL();
CloseDatabaseL();
OpenDataBaseL();
ResumeContactViewsThreadL();
}
/**
@SYMTestCaseID SYSLIB-DBMS-CT-1317
@SYMTestCaseDesc Deleting a table from the database
@SYMTestPriority Medium
@SYMTestActions Delete the rows from the rowset.Check for empty rows in the rowset.
@SYMTestExpectedResults Test must not fail
@SYMREQ REQ0000
*/
LOCAL_C void DeleteTable()
{
test.Next(_L(" @SYMTestCaseID:SYSLIB-DBMS-CT-1317 "));
const TInt KTenthRecords=KRecords/10;
test (TheTable.Open(TheDatabase,KTableName)==KErrNone);
TheDatabase.Begin();
TInt ii;
for (ii=0;ii<15;++ii)
{
TheTable.NextL();
TheTable.DeleteL();
}
TheTable.NextL();
TDbBookmark mark=TheTable.Bookmark();
TheTable.Close();
TheDatabase.Commit();
CloseDatabaseL();
OpenDatabaseL();
#ifndef __TOOLS2__
TheTimer.Start(_L("delete table"));
#endif
test (TheTable.Open(TheDatabase,KTableName)==KErrNone);
TheDatabase.Begin();
TheTable.GotoL(mark);
TheTable.DeleteL();
for (ii=0;ii<KTenthRecords*2-16;++ii)
{
TheTable.NextL();
TheTable.DeleteL();
}
TheTable.EndL();
for (ii=0;ii<KTenthRecords*2;++ii)
{
TheTable.PreviousL();
TheTable.DeleteL();
}
TheTable.BeginningL();
for (ii=0;ii<KTenthRecords*3;++ii)
TheTable.NextL();
for (ii=0;ii<KTenthRecords*2;++ii)
{
TheTable.NextL();
TheTable.DeleteL();
}
for (ii=0;ii<KTenthRecords*2;++ii)
{
TheTable.PreviousL();
TheTable.DeleteL();
}
for (ii=0;ii<KTenthRecords;++ii)
{
TheTable.NextL();
TheTable.DeleteL();
}
for (ii=0;ii<KTenthRecords;++ii)
{
TheTable.PreviousL();
TheTable.DeleteL();
}
test (TheTable.CountL()==0);
test (!TheTable.NextL());
test (!TheTable.PreviousL());
test (TheDatabase.Commit()==KErrNone);
TheTable.Close();
#ifndef __TOOLS2__
TheTimer.Stop();
#endif
}
