/*
* Copyright (c) 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:
*
*/
/*
 * castoragetestlocalization.cpp
 *
 *  Created on: Dec 2, 2009
 *      Author: michal.wojcik
 */


#include "castoragetest.h"
#include "castoragefactory.h"
#include "castorage.h"
#include "caarraycleanup.inl"
#include "cainnerentry.h"
#include "calocalizationentry.h"
#include "casqlquery.h"
#include "casqlitestorage.h"
#include "castoragetestsqlcommands.h"
#include "casqlcommands.h"

// ============================ MEMBER FUNCTIONS ===============================

// ---------------------------------------------------------------------------
//
// ---------------------------------------------------------------------------
//
void CCAStorageTest::testRemoveFromLocalizationAfterNameChange()
{
    TInt err(KErrGeneral);

    __UHEAP_MARK;
    TRAP(err,
         // Check before test
         CCaSqlQuery *query = CCaSqlQuery::NewL(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         CleanupStack::PushL(query);
         query->SetQueryL(KSQLCountFromLocalizationTable);
         query->PrepareL();
         TInt countLocalizationBefore(0);
         query->ExecuteL(countLocalizationBefore);
         CleanupStack::PopAndDestroy(query);

         // Update Collection Name;
         //    CCaInnerEntry* innerEntry = CCaInnerEntry::NewLC();
         //    innerEntry->SetId( 5 );
         //    innerEntry->SetTextL( KTestName );
         //    mStorage->AddL( innerEntry );
         //    CleanupStack::PopAndDestroy( innerEntry );

         mStorage->RemoveFromLocalizationL(5);


         // Check result after name entry name update
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLCountFromLocalizationTable);
         query->PrepareL();
         TInt countLocalizationAfter(0);
         query->ExecuteL(countLocalizationAfter);
         CleanupStack::PopAndDestroy(query);
    if ((countLocalizationBefore - countLocalizationAfter) == 1) {
    err = KErrNone;
}
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

void CCAStorageTest::testGetLocalizations()
{
    TInt err(KErrGeneral);

    __UHEAP_MARK;
    TRAP(err,
         // Check before test
         CCaSqlQuery *query = CCaSqlQuery::NewL(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         CleanupStack::PushL(query);
         query->SetQueryL(KSQLCountFromLocalizationTable);
         query->PrepareL();
         TInt countLocalization(0);
         query->ExecuteL(countLocalization);
         CleanupStack::PopAndDestroy(query);

         // Get Localizations from db
         RPointerArray<CCaLocalizationEntry> resultContainer;
         CleanupResetAndDestroyPushL(resultContainer);
         mStorage->GetLocalizationsL(resultContainer);

        if (resultContainer.Count() == countLocalization) {
            err = KErrNone;
        }

        CleanupStack::PopAndDestroy(&resultContainer);
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

void CCAStorageTest::testLocalizeEntry()
{
    TInt err(KErrGeneral);

    __UHEAP_MARK;
    TRAP(err,
         CCaLocalizationEntry *localizationEntry = CCaLocalizationEntry::NewLC();

         const TInt KOfficeId = 5;

         _LIT(KAttributeName, "EN_TEXT");
         localizationEntry->SetAttributeNameL(KAttributeName);
         _LIT(KNewLocalizedString, "Biurowe smietnisko");
         localizationEntry->SetLocalizedStringL(KNewLocalizedString);
         localizationEntry->SetRowId(KOfficeId);   // office
         _LIT(KTableName, "CA_ENTRY");
         localizationEntry->SetTableNameL(KTableName);
         localizationEntry->SetTextId(KOfficeId);    // office

         // test localize entry
         mStorage->LocalizeEntryL(*localizationEntry);

         // get this entry from db - office
         CCaInnerQuery *innerQuery = CCaInnerQuery::NewLC();
         RArray<TInt> idArray;
         CleanupClosePushL(idArray);
         idArray.AppendL(KOfficeId);
         innerQuery->SetIdsL(idArray);

         RPointerArray<CCaInnerEntry> resultArray;
         CleanupResetAndDestroyPushL(resultArray);
         mStorage->GetEntriesL(innerQuery, resultArray);

         // check results
    if (!resultArray[0]->GetText().CompareC(KNewLocalizedString)) {
    err = KErrNone;
}

CleanupStack::PopAndDestroy(&resultArray);
CleanupStack::PopAndDestroy(&idArray);
CleanupStack::PopAndDestroy(innerQuery);

CleanupStack::PopAndDestroy(localizationEntry);
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}


//-------------------------------------------------------------------------
void CCAStorageTest::testAddLocalizationEntry()
{
    TInt err(KErrGeneral);
    TInt countLocalization1(0);
    TInt countLocalization2(0);

    __UHEAP_MARK;
    TRAP(err,
         // Check before test

        countLocalization1 = locEntriesCount();
         // Get Localizations from db
        CCaLocalizationEntry* locEntry = CCaLocalizationEntry::NewLC();
        locEntry->SetTableNameL(_L("TestTable"));
        locEntry->SetAttributeNameL(_L("TestAttName"));
        locEntry->SetStringIdL(_L("TestStrId"));
        locEntry->SetQmFilenameL(_L("TestQmFilename"));
        locEntry->SetRowId(6667);
        mStorage->AddLocalizationL(*locEntry);
        countLocalization2 =locEntriesCount();
        CleanupStack::PopAndDestroy(locEntry);

        );
    QCOMPARE(err, KErrNone); 
    QCOMPARE(countLocalization1+1 , countLocalization2);
         
    __UHEAP_MARKEND;
    
}

//-------------------------------------------------------------------------
void CCAStorageTest::testUpdateLocalizationEntry()
{
    TInt err(KErrGeneral);
    TInt countLocalization1(0);
    TInt countLocalization2(0);
    
    __UHEAP_MARK;
    TRAP(err,
         // Get Localizations from db
         CCaLocalizationEntry* locEntry = CCaLocalizationEntry::NewLC();
         locEntry->SetTableNameL(_L("TestTable"));
         locEntry->SetAttributeNameL(_L("TestAttName"));
         locEntry->SetStringIdL(_L("TestStrId"));
         locEntry->SetQmFilenameL(_L("TestQmFilename"));
         locEntry->SetRowId(6668);
         mStorage->AddLocalizationL(*locEntry);
         
         countLocalization1 = locEntriesCount();

         locEntry->SetTableNameL(_L("TestTable"));
         locEntry->SetAttributeNameL(_L("TestAttName"));
         locEntry->SetStringIdL(_L("TestStrId2"));
         locEntry->SetQmFilenameL(_L("TestQmFilename2"));
         locEntry->SetRowId(6668);
         mStorage->AddLocalizationL(*locEntry);

         countLocalization2 = locEntriesCount();
         
         CleanupStack::PopAndDestroy(locEntry);
       
        );
    QCOMPARE(err, KErrNone); 
    QCOMPARE(countLocalization1 , countLocalization2);
         
    __UHEAP_MARKEND;
    
}
//-------------------------------------------------------------------------
TInt CCAStorageTest::locEntriesCount()
{
    TInt count(0);
    CCaSqlQuery *query = CCaSqlQuery::NewL(((CCaSqLiteStorage *)mStorage)->iSqlDb);
    CleanupStack::PushL(query);
    query->SetQueryL(KSQLCountFromLocalizationTable);
    query->PrepareL();
    query->ExecuteL(count);
    CleanupStack::PopAndDestroy(query);
    return count;
}