/home/bifh2/fremantle-i386-fremantle-pe1.cs2007q3/work/calendar-backend-0.8/include/CCalendarDB.h

/*
 * This file is part of calendar-backend
 *
 * Copyright (C) 2008 Nokia Corporation and/or its subsidiary(-ies).
 *
 * Contact: Ilias Biris <ilias.biris@nokia.com>
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public License
 * version 2.1 as published by the Free Software Foundation.
 *
 * This library is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA
 *
 */

#ifndef __CALDB_H__
#define __CALDB_H__

/* SQlite header file */
#include <sqlite3.h>

/* Headers for DBUS */
#include <dbus/dbus.h>
#include <string>
using namespace std;
using std::string;

/* Structure to hold the data which was fetched from database and
 * to pass them to the higher level*/
#ifndef _QRESULT__
#define _QRESULT__
typedef struct _QueryResult QueryResult;

struct _QueryResult {
  public:
    char **pResult;
    int iRow;
    int iColumn;
};
#endif

class CCalendarDB {

  public:
    int setAutocommitOff();
    int initDB();

    void setApplicationName (string appName);

    sqlite3 *getDb();

    int insertRows(sqlite3_stmt* preparedStmt,int& iSqliteError);

    bool updateDB(sqlite3_stmt * preparedStmt,int& iSqliteError);
    void sqliteErrorMapper(int iSqliteError, int& pErrorCode );


    bool rollbackDB();

    bool commitDB(string szMessage);

    bool closeDB();

    QueryResult *getRecords(char *pQuery, int& iSqliteError);

    static CCalendarDB *Instance();


    bool sendDBusMessage (string szSendMessage);

    bool initializeDBus ();

    //Destructor
    ~CCalendarDB();
    void InstanceDestroy();

    int execSQL(const char *pQuery);

  private:

     CCalendarDB();

    //Copy constructor dummy so that 
    //multiple instances are not created
     CCalendarDB(CCalendarDB & calendardb);

    // Overloading for assignment operator
     CCalendarDB & operator=(CCalendarDB & calendardb);

    sqlite3 * pDb; 
    DBusConnection *pBus; 
    static CCalendarDB *pCalendarDb; 
    // semaphore increment
    void sem_p(void);
    //semaphore decrement
    void sem_v(void);
    //semaphore id
    int sem_id;

    static bool validateDbFile(const std::string& szDbFilename);

    static bool moveToBackup(const std::string& szDbFilename);


    bool checkTimezoneTable();

    bool fillTimezoneTable(int& iSqliteError);

    bool insertTimezoneInfo(string tzId,
                            string location,
                            time_t dtstartStd,
                            time_t dtstartDst,
                            int offsetStd,
                            int offsetDst,
                            int dstflag,
                            string tzname,
                            string rruleStd,
                            string rruleDst);

};

#endif

---