/*
* 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:  Meta data video access
*
*/


#ifndef CMMMTPDPMETADATAVIDEOACCESS_H
#define CMMMTPDPMETADATAVIDEOACCESS_H

#include <e32base.h>
#include <f32file.h>
#include <s32file.h>    // for CPermanentFileStore
#include <d32dbms.h>

/*
* Mapping property code to db column name
*/
typedef struct
    {
    TMTPObjectPropertyCode iPropCode;
    const TDesC& iDbColumnName;
    } TColumnNameTable;

class CMmMtpDpMetadataVideoAccess : public CBase
    {
public:
    static CMmMtpDpMetadataVideoAccess* NewL( RFs& aRfs );

    /**
    * Destructor
    */
    ~CMmMtpDpMetadataVideoAccess();

    /*
    * Called when the MTP session is initialised
    */
    void OpenSessionL();

    /*
    * Cleanup db and notify CFL
    */
    void CloseSessionL();

    /*
    * Set root for db to manipulate relevant ".db" file
    */
    void SetStorageRootL( const TDesC& aStorageRoot );

    /**
    * Adds Video info to Video DB
    * @param aFullFileName, full file name of Media file
    */
    void AddVideoL( const TDesC& aFullFileName );

    /*
    * Gets a piece of metadata from permanent store
    * @aPropCode
    * @aNewData, output param, store the value get from db
    * @aObjectMetaData, source to get properties
    */
    void GetObjectMetadataValueL( const TUint16 aPropCode,
        MMTPType& aNewData,
        const CMTPObjectMetaData& aObjectMetaData );

    /**
    * Set object property and updated object in DB according property code,
    * only for update, not for creation
    * @param aPropCode, property code of aObjectMetaData
    * @param aNewData, object property value which will be set into
    *     aObjectMetaData
    * @param aObjectMetaData, owner of the property which should be
    *     updated into database
    */
    void SetObjectMetadataValueL( const TUint16 aPropCode,
            const MMTPType& aNewData,
            const CMTPObjectMetaData& aObjectMetaData );

    /*
    * Rename the record acording to full file name
    * @aOldFileName, specify the object which need to be changed
    * @aNewFileName, specify the new name which will be changed into
    */
    void RenameRecordL( const TDesC& aOldFileName, const TDesC& aNewFileName );

    /**
    * Remove the file from DB
    * @param aFullFileName, the file to remove
    */
    void DeleteRecordL( const TDesC& aFullFileName );

    /**
    * Remove all records from DB
    */
    void DeleteAllRecordsL();    // Removes all metadata from the database

    /**
    * set image specific properties specific to videos
    * @param aFullFileName, the fullFileName of object
    * @param aWidth,  the width of an object in pixels to set
    * @parem aHeight,  the height of an object in pixels to set
    */
    void SetImageObjPropL( const TDesC& aFullFileName,
        const TUint32 aWidth,
        const TUint32 aHeight );

    /**
    * get image specific properties specific to videos
    * @param aFullFileName, the fullFileName of object
    * @param aWidth,  the width of an object in pixels to get
    * @parem aHeight,  the height of an object in pixels to get
    */
    void GetImageObjPropL( const TDesC& aFullFileName,
            TUint32& aWidth,
            TUint32& aHeight );

    /**
    * Cleanup Database
    */
    void CleanupDatabaseL();

private:

    enum TMtpDbState
        {
        ENoRecord,
        ERecordRead,
        ERecordWrite,
        EFailedWrite
        };

    CMmMtpDpMetadataVideoAccess( RFs& aRfs );
    void ConstructL();

    TInt OpenDatabase();
    void OpenDatabaseL();
    void CreateDatabaseTablesL();
    void CompactDbIfNecessaryL();
    void CleanupDbIfNecessaryL();

    void IdentifyDeletedFilesL();

    HBufC* ReadLongTextL( const TDesC& aColumn);
    void WriteLongTextL( const TDesC& aColumn, const TDesC& aValue);

    void ExecuteQueryL( const TDesC& aSelectThese,
    const TDesC& aFromTable,
    const TDesC& aColumnToMatch = KNullDesC,
    const TDesC& aMatchCriteria = KNullDesC,
    const TBool aIfNot = EFalse,
    const TBool aNeedQuote = ETrue );

    void SetRecordL( const TDesC& aFullFileName, TMtpDbState aState ); // Updates the iRecord to the selected file
    void SetMetadataL( const TUint16 aPropCode, const MMTPType& aNewData );

    inline TBool IsDatabaseOpened()
        {
        return iDbOpened;
        }

    const TDesC& ColumnNameFromPropCodeL( const TUint16 aPropCode );

    TBool FileExists( const TDesC& aFullFileName );

private: // Data

    RFs iRfs;

    CPermanentFileStore* iFileStore;
    TMtpDbState iDbState;
    TFileName iCurrentFileName;

    RDbs iDbsSession;
    RDbView iRecordSet;
    HBufC* iQueryText;
    CDbColSet* iColSet;
    RDbStoreDatabase iDatabase;
    TBool iDbOpened;
    TInt iRecordCount;  // Used to compact the database every KMtpCompactInterval
    TInt iStoreNum;

    };

#endif // CMMMTPDPMETADATAVIDEOACCESS_H