/*

* 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:

*

*/

/*

 * castoragetestproperties.cpp

 *

 *  Created on: 2009-08-17

 *      Author: michal.wojcik

 */

#include "castoragetest.h"

#include "castoragefactory.h"

#include "castorage.h"

#include "cainnerentry.h"

#include "casqlquery.h"

#include "casqlitestorage.h"

#include "castoragetestsqlcommands.h"

#include "casqlcommands.h"

#include "cadef.h"

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

// ---------------------------------------------------------------------------

//

// ---------------------------------------------------------------------------

//

void CCAStorageTest::testPropertyGetDbVersion()

{

    TInt err(KErrGeneral);

    __UHEAP_MARK;

    _LIT(KProperty, "Version");

    _LIT(KPropertyValue, "00001");

    _LIT(KPropertyValue2, "00002");

    TRAP(err,

         // set db version property - 00001

         mStorage->SetDBPropertyL(KProperty, KPropertyValue);

         TBuf<20> propertyValue;

         mStorage->DbPropertyL(KProperty, propertyValue);

    if (!propertyValue.CompareC(KPropertyValue)) {

    err = KErrNone;

}

// set db version property - 00002

mStorage->SetDBPropertyL(KProperty, KPropertyValue2);

TBuf<20> propertyValue2;

mStorage->DbPropertyL(KProperty, propertyValue2);

// check results

if (err == KErrNone) {

    if (!propertyValue2.CompareC(KPropertyValue2)) {

            err = KErrNone;

        } else {

            err = KErrGeneral;

        }

    }

        );

    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);

}

void CCAStorageTest::testPropertyGetLanguage()

{

    TInt err(KErrGeneral);

    __UHEAP_MARK;

    _LIT(KProperty, "Language");

    _LIT(KPropertyValue, "en_GB");

    _LIT(KPropertyValue2, "pl_PL");

    TRAP(err,

         // set lanquage property - en_GB

         mStorage->SetDBPropertyL(KProperty, KPropertyValue);

         TBuf<20> propertyValue;

         mStorage->DbPropertyL(KProperty, propertyValue);

    if (!propertyValue.CompareC(KPropertyValue)) {

    err = KErrNone;

}

// set lanquage property - pl_PL

mStorage->SetDBPropertyL(KProperty, KPropertyValue2);

TBuf<20> propertyValue2;

mStorage->DbPropertyL(KProperty, propertyValue2);

// check results

if (err == KErrNone) {

    if (!propertyValue2.CompareC(KPropertyValue2)) {

            err = KErrNone;

        } else {

            err = KErrGeneral;

        }

    }

        );

    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);

}

void CCAStorageTest::testLoadDBFromROM()

{

    TInt err(KErrGeneral);

    delete mStorage;

    mStorage = NULL;

    //we copy corrupted db

    QFile corruptedfile("c:/testing/data/t_castorage/corruptedcastoragedb");

    QFile file("c:/castorage.db");

    bool ok = corruptedfile.open(QIODevice::ReadOnly);

    ok = file.open(QIODevice::ReadWrite) && ok;

    ok = file.remove() && ok;

    ok = corruptedfile.copy("c:/castorage.db") && ok;

    QCOMPARE(ok, true);

    corruptedfile.close();

    file.close();

    TRAP(err,

         mStorage = CaStorageFactory::NewDatabaseL();

        );

    CCaSqLiteStorage *storage = dynamic_cast<CCaSqLiteStorage *>(mStorage);

    storage->iPrivatePathZDriveDb.Copy(_L("c:\\testing\\data\\t_castorage\\castorage.db"));

    TRAP(err,

         mStorage->LoadDataBaseFromRomL();

        );

    QCOMPARE(err, KErrNone);

    testGetEntriesById();// to check that db is accesible

}

// not stable to use due to impossibilty to dynamically load db to rom

/*void CCAStorageTest::testBadDBVersion()

{

    TInt err(KErrGeneral);

    delete mStorage;

    mStorage = NULL;

    //we copy db with bad version db

    QFile badversionfile("c:/testing/data/t_castorage/versioncastoragedb");

    QFile file("c:/castorage.db");

    bool ok = badversionfile.open(QIODevice::ReadOnly);

    ok = file.open(QIODevice::ReadWrite) && ok;

    ok = file.remove() && ok;

    ok = badversionfile.copy("c:/castorage.db") && ok;

    QCOMPARE(ok, true);

    badversionfile.close();

    file.close();

    //we would like to copy good db to rom

    //but we can only assume that it is already there

    QFile goodversionfile("c:/testing/data/t_castorage/castorage.db");

    QFile file2("z:/castorage.db");

    ok = goodversionfile.open(QIODevice::ReadOnly);

    ok = file2.open(QIODevice::ReadWrite) && ok;

    ok = file2.remove() && ok;

    ok = goodversionfile.copy("z:/castorage.db") && ok;

    QCOMPARE(ok, true);

    badversionfile.close();

    file2.close();

    TRAP(err,

         mStorage = CaStorageFactory::NewDatabaseL();

        );

    //check id good version was loaded instead

    CCaSqLiteStorage* castorage = dynamic_cast<CCaSqLiteStorage *>(mStorage);

    TBuf<KCaMaxAttrNameLen> versionValue;

    castorage->DbPropertyL(KCaDbPropVersion, versionValue);

    TInt res = versionValue.CompareC( KCaDbVersion );

    QVERIFY(res == 0);

}*/