/*

* Copyright (c) 2008 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:      SQLite Connection class

*

*/

#ifndef C_CMDMSQLITECONNECTION_H

#define C_CMDMSQLITECONNECTION_H

#include <e32base.h>

#include "sqldb.h" // Symbian SQLite

#include "cmdmmain.h" // TCMQueryCmdType

/* Forward declarations. */

class CCmFillRule;

class CCmMediaServerFull;

class CCmStoreRule;

class CCmBaseListItem;

class CCmFillListItem;

class CCmStoreListItem;

class CCmDriveInfo;

// CLASS DECLARATION

 /**

 *  Class represents methods to communication with SQLite database API.

 *  @lib cmdatabasemanager.lib

 *  @since S60 5.1

 */

NONSHARABLE_CLASS( CCmDmSQLiteConnection ): public CBase

    {

public:

    // ID types

    enum TTypeOfID

        {

        ERuleGroupID = 1,

        ERuleID,

        ERuleParamID,

        EMediaServerID,

        EStoredID,

        EFilledID,

        EStoreRuleID,

        EStoreRuleParamID,

        EFillFileListId,

        EStoreFileListId

        };

    /**

     * Two-phased constructor.

     */

    static CCmDmSQLiteConnection* NewL();

    /**

     * Two-phased constructor.

     */

    static CCmDmSQLiteConnection* NewLC();

    /**

     * Destructor.

     */

    virtual ~CCmDmSQLiteConnection();

    /**

     * Open database (creates if doesn't exist)

     *

     * @since S60 5.1

     * @param aDb, Database filename and path

     * @return TInt, Error code

     */        

    TInt OpenDb( const TDesC& aDb );

    /**

     * Close opened database

     *

     * @since S60 5.1

     * @param None

     * @return None

     */        

    void CloseDb();

    /**

     * Initializes Database ids

     *

     * @since S60 5.1

     * @param None

     * @return None

     */        

    void InitIDs();

    /**

     * Initializes Database id

     *

     * @since S60 5.1

     * @param aType, ID type

     * @return None

     */           

    void SetID( TTypeOfID aType );

    /**

     * Backups id to database

     *

     * @since S60 5.1

     * @param aType, ID type

     * @param aID, ID value

     * @return None

     */            

    void BackUpIdL( TTypeOfID aType, TUint64 aID );

    /**

     * Loads Database ids

     *

     * @since S60 5.1

     * @param None

     * @return None

     */            

    void LoadIDs();

    /**

     * Loads Database id

     *

     * @since S60 5.1

     * @param aId, ID value

     * @param aType, ID type

     * @return None

     */        

    void LoadIDL( TUint64& aId, TTypeOfID aType );

    /**

     * Creates db file

     * @since S60 5.1

     * @param aDb, Database filename and path

     * @return TInt, error code

     */  

    TInt CreateDbFile( const TDesC& aDb ); 

    /**

     * Check Validity of database

     *

     * @since S60 5.1

     * @param None

     * @return ETrue if database is OK

     */            

    TBool Validate();

    /**

     * Execute sql command (not a query)

     *

     * @since S60 5.1

     * @param aCommand, SQL clause to be executed (can include wildcards)

     * @return TInt, KErrNone if successful, otherwise one of the error codes.

     */

    void ExecuteL( const TDesC8& aCommand );

    /**

     * Sets fill file list into db

     *

     * @since S60 5.1

     * @param aItems, fill list item array

     * @return TInt, Error code

     */            

    TInt SetFillFiles( RPointerArray<CCmFillListItem>& aItems );

    /**

     * Sets store file list into db

     *

     * @since S60 5.1

     * @param aItems, store list item array

     * @return TInt, Error code

     */    

    TInt SetStoreFilesL( RPointerArray<CCmStoreListItem>& aItems );

    /**

     * Set one store file into db

     *

     * @since S60 5.1

     * @param aItem, store list item

     * @return TInt, Error code

     */      

    TInt AddStoreFile( CCmStoreListItem& aItem );

    /**

     * Add stored media into database

     *

     * @since S60 5.1

     * @param aFileName, store file name

     * @param aUDN, mediaserver udn

     * @param aTimeStamp, timestamp

     * @return TInt, Error code

     */                

    TInt AddStoredL( 

        const TDesC& aFileName, 

        const TDesC8& aUDN, 

        TTime aTimeStamp );

    /**

     * Add fill rule into database

     *

     * @since S60 5.1

     * @param aFillRule, fill list

     * @return TInt, Error code

     */              

    TInt AddFillRuleL( CCmFillRule* aFillRule );

    /**

     * Add fill rule specific media servers

     *

     * @since S60 5.1

     * @param aFillRule, fill list

     * @return TInt, Error code

     */            

    TInt AddFillRuleMediaServersL( CCmFillRule* aFillRule );

    /**

     * Add fill rule informations and parameters

     *

     * @since S60 5.1

     * @param aFillRule, fill list

     * @return TInt, Error code

     */            

    TInt AddFillRuleRulesAndParamsL( CCmFillRule* aFillRule );

    /**

     * Add store rule

     *

     * @since S60 5.1

     * @param aStoreRule, store list

     * @return TInt, Error code

     */        

    TInt AddStoreRuleL( CCmStoreRule* aStoreRule );

    /**

     * Add store rule informations and parameters

     *

     * @since S60 5.1

     * @param aStoreRule, store list

     * @return TInt, Error code

     */        

    TInt AddStoreRuleParamsL( CCmStoreRule* aStoreRule );

    /**

     * Add store rule mediaServers

     *

     * @since S60 5.1

     * @param aStoreRule, store list

     * @return TInt, Error code

     */        

    TInt AddStoreRuleMediaServersL( CCmStoreRule* aStoreRule );

    /**

     * Add media server info into database

     *

     * @since S60 5.1

     * @param aMediaServer, media server

     * @return TInt, Error code

     */              

    TInt AddMediaServerL( CCmMediaServerFull* aMediaServer );

    /**

     * Add hash value

     *

     * @since S60 5.1

     * @param aMediaServer, media server id

     * @param aHashValue, hash value

     * @return TInt, Error code

     */

    TInt AddHashValue( TInt64 aMediaServerId, 

                                       CCmSearchResponseHash* aHashValue );

    /**

     * Query hash value

     *

     * @since S60 5.1

     * @param aMediaServer, media server id

     * @param aHashValues, hash values

     * @return TInt, Error code

     */    

    TInt QueryHashValuesL( TInt aMediaServer, 

        RPointerArray<CCmSearchResponseHash>& aHashValues );

    /**

     * Sets is active status of the media server

     * Sets the Media server's name

     * @since S60 5.1

     * @param aServers, server list

     * @return TInt, Error code 

     */        

    TInt SetMediaServersL( 

        RPointerArray<CCmMediaServerFull>& aServers );    

    /**

     * Sets last syncs time

     * @since S60 5.1

     * @param None

     * @return TInt, Error code 

     */    

     TInt SetSyncTime();

    /**

     * Gets last syncs time

     * @since S60 5.1

     * @param aTime last sync time

     * @return TInt, Error code 

     */        

    TInt GetSyncTime( TTime& aTime );

    /**

     * Sets Progress info

     * @since S60 5.1

     * @param aTransferred how many files transferred

     * @param aTotalCount how many will be trasferred

     * @return TInt, Error code 

     */    

    TInt SetProgressInfo( TInt aTransferred, TInt aTotalCount );

    /**

     * Gets Progress info

     * @since S60 5.1

     * @param aTransferred how many files transferred

     * @param aTotalCount how many will be trasferred

     * @return TInt, Error code 

     */    

    TInt GetProgressInfo( TInt& aTransferred, TInt& aTotalCount );

    /**

     * Sets Drives info

     * @since S60 5.1

     * @param aDrives, drives to be set into database

     * @return TInt, None

     */ 

    void SetDrivesL( RPointerArray<CCmDriveInfo>& aDrives );

    /**

     * Delete media server info from the database

     *

     * @since S60 5.1

     * @param aUDN, server udn

     * @return TInt, Error code

     */        

    TInt DeleteMediaServer( const TDesC8& aUDN );

    /**

     * Delete fill rule

     *

     * @since S60 5.1

     * @param aName, fill list name

     * @return TInt, Error code

     */            

    TInt DeleteFillRuleByName( const TDesC8& aName );

    /**

     * Delete all fill rules

     *

     * @since S60 5.1

     * @param None

     * @return TInt, Error code

     */                

    TInt DeleteAllFillRules();

    /**

     * Delete all store rules

     *

     * @since S60 5.1

     * @param None

     * @return TInt, Error code

     */    

    TInt DeleteAllStoreRules(); 

    /**

     * Delete all fill files

     *

     * @since S60 5.1

     * @param None

     * @return TInt, Error code

     */             

    TInt DeleteFillFiles();

    /**

     * Delete all store files

     *

     * @since S60 5.1

     * @param None

     * @return TInt, Error code

     */         

    TInt DeleteStoreFiles();

    /**

     * Delete deleted items 

     *

     * @since S60 5.1

     * @param None

     * @return None

     */     

    void DeleteDeletedItemsL();

    /**

     * Delete deleted media servers

     *

     * @since S60 5.1

     * @param None

     * @return None

     */      

    void DeleteDeletedMediaServersL();

    /**

    * Deletes hash values

    *

    * @since S60 5.1

    * @param aMediaServerId, media server id

    * @param aSearchIndex, search index

    * @return None

    */   

    void DeleteHashValuesL( const TInt aMediaserverId,

            const TInt aSearchIndex );

    /**

     * Update media server info

     *

     * @since S 60 5.1

     * @param aMediaServer, mediaserver

     * @return TInt, Error code

     */            

    TInt UpdateMediaServerInfo( CCmMediaServerFull* aMediaServer );

    /**

     * Update Fill rules selected state

     *

     * @since S60 5.1

     * @param aName, fill list name

     * @param aSelected, selection status

     * @return TInt, Error code

     */        

    TInt UpdateFillRuleSelected( const TDesC8& aName, TInt aSelected );

    /**

    * update the fill rule realsize and realcount field

    * @since S60 5.1

    * @return TInt, error code

    */      

    TInt UpdateFillRuleGroupInfo();

    /**

     * Update download history 

     *

     * @since S60 5.1

     * @param aMediaServerId, mediaserver id

     * @param aDownloadData, download data size

     * @param aDownloadTime, download time

     * @return TInt, Error code

     */          

    TInt UpdateDownloadHistory( TUint aMediaServerId, TInt64& aDownloadData,

                                TInt64& aDownloadTime );

    /**

     * Update upload history 

     *

     * @since S60 5.1

     * @param aMediaServerId, mediaserver id

     * @param aUploadData, upload data size

     * @param aUploadTime, upload time

     * @return TInt, Error code

     */                                     

    TInt UpdateUploadHistory( TUint aMediaServerId, TInt64& aUploadData, 

                            TInt64& aUploadTime );

    /**

     * Update status values

     *

     * @since S60 5.1

     * @param aStatusValues, item statuses

     * @return TInt, Error code 

     */

    TInt UpdateStatusValues( 

        RPointerArray<CCmBaseListItem>& aStatusValues );

    /**

     * Update fill list drive statuses

     *

     * @since S60 5.1

     * @param aDrive, drive info

     * @para aDriveSelected, if ETrue drive selected but slot changed

     * @return None 

     */     

    void UpdateFillListDriveStatusesL( CCmDriveInfo* aOrigDrive, 

        CCmDriveInfo* aNewDrive, TBool aDriveSelected ); 

    /**

     * Update fill list item priorities and status

     *

     * @since S60 5.1

     * @param aContainer, fill list container 

     * @return TInt, Error code 

     */

    TInt UpdateFillListItemPriority( CCmFillRuleContainer* aContainer );

    /**

     * Update fill selection state into fill file table

     *

     * @since S60 5.1

     * @param aListName, fill list name

     * @param aState, list status

     * @return None

     */

    void SetFillListStateL( const TUint aListName, 

        TCmFillRuleStatus aState );

    /**

     * Restoring file statuses

     *