/*

* 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:  Class that directly interacts with Sqlite database.

*

*/

#ifndef C_EVTDATABASE_H

#define C_EVTDATABASE_H

// System Includes

#include <sqldb.h>

// User Includes

#include "evtbasiceventinfo.h"

#include "evtevent.h"

#include "evtdbobserver.h"

#include "evtstoragedbobserver.h"

// Forward Declarations

class CEvtDbNotifier;

// extern data types

// global Functions

// constants

const TInt KTempStringLength=32;

/**

 *  Interface class to Location Events Database.

 *  This class allows for Events to be stored in persistent database

 *   - Sqlite. Events can be added, deleted and modified from 

 *  database.

 *

 *  @lib evtstorage.lib

 *  @since S60 v9.1

 */

class CEvtDatabase : public CBase, 

					   public MEvtDbObserver

    {   

public:  // Member Functions

    /**

     * Constructs a new instance of CEvtDatabase.

     *

     * @return The new instance of CEvtDatabase.

     * @leave System wide error code if the object creation fails.         

     */

    static CEvtDatabase* NewL( );

    /**

     * Constructs a new instance of Event Storage Manager interface.

     * Leaves the created instance on the cleanup stack.

     *

     * @return The new instance of CEvtDatabase.

     * @leave System wide error code if the object creation fails.         

     */

    static CEvtDatabase* NewLC( );  

    /**

    * Destructor.

    */

    virtual ~CEvtDatabase();

    /**

     * Get Events List based on status.

     */                

    void GetEventsL( TEvtEventStatus 	aEvtStatus,

                     RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );

    /**

     * Get Events List based on status.

     */                

    void GetEventsL( RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );

    /**

     * Get Event based on unique Id.

     */    

    CEvtEvent* GetEventL( TEvtEventId aEvtId  );

    /**

     * Update Event based on unique Id.

     */    

    void UpdateEventL( CEvtEvent& aEvtEvent );

    /**

     * Insert Event to database.

     */    

    void AddEventL( CEvtEvent&     aEvtEvent );

    /**

     * Remove Events from database.

     */    

    void RemoveEventsL( const RArray<TEvtEventId>& aEvtIdArray );

    /**

     * Update Event Status.

     */ 

    void UpdateEventsStatusL( const RArray<TEvtEventId>& aEventArray,  TEvtEventStatus  aEvtStatus );

    /**

     * Update Event Status based on unique Id.

     */    

    void UpdateEventStatusL( 

                            TEvtEventId      aEvtId,

                            TEvtEventStatus    aEvtStatus);

    /**

     * Remove Event from database based on unique Id.

     */    

    void RemoveEventL( TEvtEventId      aEvtId );	

    /**

     * Set the Observer fo Storage Database.

     */

    void SetObserver( MEvtStorageDbObserver* aStorageDbObserver );

	 // Inherited from MEvtDbObserver

    /**

     * Observer for TDbChangeType changes in Storage Database.

     */

    void HandleDbChangedL( );

private:

    /**

     * Open Database Connection.

     */

	void OpenDatabaseL( );

    /**

     * Create and Open Database Connection.

     */

	void CreateOpenDatabaseL( );

    /**

     * Close Database Connection.

     */

	void CloseDatabase();

    /**

     * Create the Schema for Events Storage.

     */

	void CreateSchemaL();

    /**

     * Create All the Tables.

     */

	void CreateTablesL();

    /**

     * Create All the Indexes.

     */

	void CreateIndexL();

    /**

     * Create All the related Triggers.

     */

	void CreateTriggerL();

    /**

     * Get Events based on Query String.

     */

    void GetEventsL( RSqlStatement& 	aStmt,

                     RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );

    /**

     * Update Event Table.

     */

    void UpdateEventTableL( CEvtEvent&          aEvtEvent );

    /**

     * Delete Event.

     */

	void DeleteEventL( TEvtEventId          aEventId );

    /**

     * check if Event is present.

     */

	TBool CheckIfEventPresentL( TEvtEventId          aId );

    /**

     * check if Action is present.

     */

	TBool CheckIfActionPresentL( TInt64          aId );

    /**

     * Get the action Id based on Event Id.

     */

	TInt64 GetActionId( TEvtEventId          aId );

    /**

     * Create Action.

     */

    void CreateActionL( CEvtAction&   aEvtAction );

    /**

     * Update Action.

     */

    void UpdateActionL( CEvtAction&   aEvtAction );

    /**

     * Delete Action.

     */

	void DeleteActionL( TEvtEventId          aEventId );

    /**

     * Default C++ Constructor.

     */

    CEvtDatabase( );

    /**

     * Second phase of the two phase constructor.

     */

    void ConstructL();

private: // data

    /**

     *  RSqlDatabase Instance

     */

    RSqlDatabase iDb;

    /**

     *  CEvtDbNotifier Instance

     */

    CEvtDbNotifier* iDbNotifier;

    /**

     *  CEvtDbNotifier Instance

     */

    MEvtStorageDbObserver* iStorageDbObserver;

    };

#endif // C_EVTDATABASE_H