/*
* 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:
*
*/
/*
 * castoragetesttouch.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"

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

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

    __UHEAP_MARK;
    TRAP(err,
         // check database before touch
         CCaSqlQuery *query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchBeforeTouch(0);
         query->ExecuteL(countLaunchBeforeTouch);
         CleanupStack::PopAndDestroy(query);

         // Id 14 - Clock app
         mStorage->TouchL(14, ETrue);

         // check database after touch
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchAfterTouch(0);
         query->ExecuteL(countLaunchAfterTouch);
         CleanupStack::PopAndDestroy(query);

         // flag should be set to EUsed on 1 Entry
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetUsedFlagCountFromEntryTable);
         query->PrepareL();
         query->BindValuesForLaunchL(0,0);
         TInt countEntriesWithUsedFlag(0);
         query->ExecuteL(countEntriesWithUsedFlag);
         CleanupStack::PopAndDestroy(query);

    if (((countLaunchAfterTouch - countLaunchBeforeTouch) == 1) && (countEntriesWithUsedFlag == 1)) {
    err = KErrNone;
} else {
    err = KErrGeneral;
}
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

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

    __UHEAP_MARK;
    TRAP(err,
         // check database before touch
         CCaSqlQuery *query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchBeforeTouch(0);
         query->ExecuteL(countLaunchBeforeTouch);
         CleanupStack::PopAndDestroy(query);

         // Id 14 - Clock app
         mStorage->TouchL(14, ETrue);//removable application
         User::After(1000000); // 1 sec
         mStorage->TouchL(14, ETrue);

         // check database after touch
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchAfterTouch(0);
         query->ExecuteL(countLaunchAfterTouch);
         CleanupStack::PopAndDestroy(query);

         // flag should be set to EUsed on 1 Entry
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetUsedFlagCountFromEntryTable);
         query->PrepareL();
         query->BindValuesForLaunchL(0,0);
         TInt countEntriesWithUsedFlag(0);
         query->ExecuteL(countEntriesWithUsedFlag);
         CleanupStack::PopAndDestroy(query);

    if (((countLaunchAfterTouch - countLaunchBeforeTouch) == 2) && (countEntriesWithUsedFlag == 1)) {
    err = KErrNone;
} else {
    err = KErrGeneral;
}
    );

    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

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

    __UHEAP_MARK;

    TRAP(err,
         // check database before touch
         CCaSqlQuery *query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchBeforeTouch(0);
         query->ExecuteL(countLaunchBeforeTouch);
         CleanupStack::PopAndDestroy(query);
        //all apps are not removeable
         mStorage->TouchL(9, EFalse);  // calendar
         mStorage->TouchL(10, EFalse); // calculator
         mStorage->TouchL(16, EFalse); // music player
         mStorage->TouchL(20, EFalse); // photos
         mStorage->TouchL(21, EFalse); // video center

         // check database after touch
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchAfterTouch(0);
         query->ExecuteL(countLaunchAfterTouch);
         CleanupStack::PopAndDestroy(query);

         // flag should be set to EUsed on 5 Entries
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetUsedFlagCountFromEntryTable);
         query->PrepareL();
         query->BindValuesForLaunchL(0,0);
         TInt countEntriesWithUsedFlag(0);
         query->ExecuteL(countEntriesWithUsedFlag);
         CleanupStack::PopAndDestroy(query);

    if (((countLaunchAfterTouch - countLaunchBeforeTouch) == 5) && (countEntriesWithUsedFlag == 0)) {
    err = KErrNone;
} else {
    err = KErrGeneral;
}
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

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

    __UHEAP_MARK;
    TRAP(err,
         // prepare time older than 30 days
         TTime presentTime;
         presentTime.UniversalTime();
         TTime outOfDateTime = presentTime - (TTimeIntervalDays(30 + 5));

         // prepare item with launch time older than 30 days
         CCaSqlQuery *query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLInsertToLaunch);
         query->PrepareL();
         // change launch time for calculator app to older than 30 days
         query->BindValuesForLaunchL(10, outOfDateTime.Int64());
         query->ExecuteL();
         CleanupStack::PopAndDestroy(query);
         // prepare 2 items with launch time newer than 30 days
         mStorage->TouchL(20, EFalse); // photos
         mStorage->TouchL(21, EFalse); // video center

         // check database before remove old launch
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchBeforeRemove(0);
         query->ExecuteL(countLaunchBeforeRemove);
         CleanupStack::PopAndDestroy(query);

         // remove launches older than 30 days
         ((CCaSqLiteStorage *)mStorage)->RemoveOldEntriesFromLaunchTableL(30);

         // check database after remove old launches
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchAfterRemove(0);
         query->ExecuteL(countLaunchAfterRemove);
         CleanupStack::PopAndDestroy(query);

    if ((countLaunchBeforeRemove - countLaunchAfterRemove) == 1) {
    err = KErrNone;
} else {
    err = KErrGeneral;
}
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}

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

    __UHEAP_MARK;
    TRAP(err,
         // prepare time older than 30 days
         TTime presentTime;
         presentTime.UniversalTime();
         TTime outOfDateTime = presentTime - (TTimeIntervalDays(30 + 5));

         // prepare item with launch time older than 30 days
         CCaSqlQuery *query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLInsertToLaunch);
         query->PrepareL();
         // change launch time for calculator app to older than 30 days
         query->BindValuesForLaunchL(10, outOfDateTime.Int64());
         query->ExecuteL();
         CleanupStack::PopAndDestroy(query);
         // prepare 2 items with launch time newer than 30 days
         mStorage->TouchL(10, EFalse); // launch the same app again - time newer than 30 days

         // check database before remove old launch
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchBeforeRemove(0);
         query->ExecuteL(countLaunchBeforeRemove);
         CleanupStack::PopAndDestroy(query);

         // remove launches older than 30 days
         ((CCaSqLiteStorage *)mStorage)->RemoveOldEntriesFromLaunchTableL(30);

         // check database after remove old launches
         query = CCaSqlQuery::NewLC(((CCaSqLiteStorage *)mStorage)->iSqlDb);
         query->SetQueryL(KSQLGetIdCountFromLaunchTable);
         query->PrepareL();
         TInt countLaunchAfterRemove(0);
         query->ExecuteL(countLaunchAfterRemove);
         CleanupStack::PopAndDestroy(query);

    if ((countLaunchBeforeRemove - countLaunchAfterRemove) == 1) {
    err = KErrNone;
} else {
    err = KErrGeneral;
}
    );
    __UHEAP_MARKEND;

    QCOMPARE(err, KErrNone);
}