/*

#include<QString>

#include<QFile>

#include<QFileInfo>

#include<QDebug>

#include<QSqlQuery>

#include<QSqlError>

#include<QWidget>

#include<QtGui>

#include "bookmarksapi.h"

#include "BookmarksManager.h"

#include "BookmarkFav.h"

#include "BookmarkResults.h"

#include "TagResults.h"

#include "xbelreader.h"

#include "xbelwriter.h"

#include "defaultBookmarks.xml.h"

BookmarksManager::BookmarksManager(QWidget *parent) :

    QObject(parent)

{

    setObjectName("bookmarksManager");

    m_db = QSqlDatabase::database(BOOKMARKS_DB_NAME);

    if (!m_db.isValid()) {

        m_db = QSqlDatabase::addDatabase("QSQLITE", BOOKMARKS_DB_NAME);

        m_db.setDatabaseName(BOOKMARKS_DB_FILE);

    }

    if (m_db.open()) {

        // TODO: Do we need a flag so that this gets called only once OR when

        // creating a database tables "IF NOT EXISTS" is good enough

    }

}

    m_db.close();

    QSqlDatabase::removeDatabase(BOOKMARKS_DB_NAME);

}

/*

 * +-------------+       +----------+

 * |Bookmarks(ID)|* <-> *|Tags(BMID)|

 * +-------------+       +----------+

 */

    // Bookmarks

    if (!doQuery("CREATE TABLE IF NOT EXISTS bookmarks("

        // TODO: do some error handling here!

        return;

    }

    // Make sorting faster

        // TODO: do some error handling here!

        return;

    }

    // We do a lot of lookups by id

    if (!doQuery("CREATE INDEX IF NOT EXISTS bm_id_idx ON bookmarks(id ASC)")) {

        // TODO: do some error handling here!

        return;

    }

    // Tags

    // Note: foreign key constraints are not enforced in the current version of sqlite

    // that we are using.

    if (!doQuery("CREATE TABLE IF NOT EXISTS tags("

        // TODO: do some error handling here!

        return;

    }

    // We do a lot of lookups, both by bookmark id and by tag

    if (!doQuery("CREATE INDEX IF NOT EXISTS tags_bmid_idx ON tags(bmid ASC)")) {

        // TODO: do some error handling here!

        return;

    }

    if (!doQuery("CREATE INDEX IF NOT EXISTS tags_tag_idx ON tags(tag ASC)")) {

        // TODO: do some error handling here!

        return;

    }

}

// TODO refactor this - nothing except the schema creation can use it as is

#ifdef ENABLE_PERF_TRACE

    PERF_DEBUG() << __PRETTY_FUNCTION__ << query << "\n";

    unsigned int st = WrtPerfTracer::tracer()->startTimer();

#endif

    QSqlQuery db_query(m_db);

    bool ok = db_query.exec(query);

    if (!ok) {

    }

#ifdef ENABLE_PERF_TRACE

    PERF_DEBUG() << __PRETTY_FUNCTION__ << WrtPerfTracer::tracer()->elapsedTime(st) << "\n";

#endif

}

/**==============================================================

 * Description: Normalize a given url, if needed.

 * It adds http:// in front, if the url is relative.

 ================================================================*/

QString BookmarksManager::normalizeUrl(const QString& url)

{

    // If the URL is relative, add http in front

    QString updatedUrl = url;

    if (!url.contains("://")) {

        updatedUrl.prepend("http://");

    }

    return updatedUrl;

}

/**==============================================================

 * Description: Adds the bookmark to the database, given title and

 * url. 

 * Returns: Returns bookmarkID ( >0)else Failure (-1 or -2)

 ================================================================*/

int BookmarksManager::addBookmark(QString title, QString URL)

{

    int bookmarkId = 0;

    }

        // do some checking on parameters

        QString updatedTitle = title;

        QString updatedUrl = normalizeUrl(URL);

        int soIndex = 1;

        if (title.isEmpty()) {

            updatedTitle = "Untitled";

        }

        if (m_db.isOpen()) {

            QSqlQuery query(m_db);

            m_db.transaction();

            if (!query.exec("SELECT count(*) from bookmarks")) {

            }

            if(query.next()) {

            query.bindValue(":title", QVariant(updatedTitle));

            query.bindValue(":url",    QVariant(updatedUrl));

            query.bindValue(":sIndex",  QVariant(soIndex));

            if (!query.exec()) {

                lastErrMsg(query);

                m_db.rollback();

                return DATABASEERROR;

            bookmarkId = query.lastInsertId().toInt();

            if (!m_db.commit()) {

                qDebug() << m_db.lastError().text();

                m_db.rollback();

            }

        } else {

        }

      }

    return bookmarkId;

}

/**==============================================================

 * Import bookmarks from an XBEL file. If no filename is 

 * passed in a set of default bookmarks will be imported.

 * The default bookmarks used can be changed by updating

 * the file "defaultBookmarks.xml.cpp".

 * @param xbelFilePath - String containing the path to the

 * file to import.

 * @return SUCCESS or FAILURE depending on whether the 

 * import process was successful.

 ==============================================================*/

int BookmarksManager::importBookmarks(QString xbelFilePath)

{

    XbelReader *reader = new XbelReader(this);

    bool retVal = false;

        QFile file(xbelFilePath);

            file.remove();

        if (!file.open(QIODevice::WriteOnly | QIODevice::Text))

            return false;

        out << defaultBookmarksList;

        out.flush();

        file.close();

    QFile file(xbelFilePath);

        file.open(QIODevice::ReadOnly | QIODevice::Text);

        retVal = reader->read(&file);

        file.close();

    }

        delete reader;

    return retVal ? SUCCESS : FAILURE;

}

/**==============================================================

 * Exports all bookmarks in the database to an XBEL file. This function

 * expects a valid file path to be passed in. If the path is not valid

 * a default file path will be used. If a file with that name already 

 * exists at that location,

 * @param xbelFilePath String containing the path of the file to 

 * export to.

 * @return SUCCESS or FAILURE depending on whether the 

 * export process was successful.

 ==============================================================*/

int BookmarksManager::exportBookmarks(QString xbelFilePath)

{

    XbelWriter *writer = new XbelWriter(this);

    bool retVal = false;

        xbelFilePath = "c:\\data\\myBookmarks.xml";

    QFile file(xbelFilePath);

        file.remove(xbelFilePath);

    }

    file.open(QIODevice::WriteOnly | QIODevice::Text);

    retVal = writer->writeFile(&file);

    file.flush();

    file.close();

        delete writer;

    return retVal ? SUCCESS : FAILURE;

}

/**==============================================================

 * Description: Modify the existing bookmark. Given id of the bookmark

 * and new title or url, it modifies the existing bookmark.

 * Returns : Success(0) or Failure(-1 or -2).

 ================================================================*/

{

    int retVal = SUCCESS;

    // Client has to at least pass title or url

                query.bindValue(":newurl", normalizeUrl(newURL));

                query.bindValue(":bmId", origBookmarkId);

                query.bindValue(":newTitle", newTitle);

                query.bindValue(":bmId", origBookmarkId);

            } else {

                query.bindValue(":newurl", normalizeUrl(newURL));

                query.bindValue(":newTitle", newTitle);

                query.bindValue(":bmId", origBookmarkId);

            }

            if (!query.exec()) {

                lastErrMsg(query);

                return DATABASEERROR;

            if (query.numRowsAffected() == 0) {

                // No update happened - must be an invalid id

                // TODO: shall we return some other status

                retVal = FAILURE;

            }

            retVal = FAILURE;

    }

    return retVal;

}

/**===================================================================================

 * Description: Delete the bookmark item, also delete all the tags associated with it.

 * Returns: SUCCESS(0) or Failure(-1 or -2)

 ======================================================================================*/

int BookmarksManager::deleteBookmark(int bookmarkId)

{

    int retVal = SUCCESS;

        QSqlQuery query(m_db);

        // TODO: Need to think about whether we need to get sortIndex and update all the 

        // rows after the deletion or not

        // TODO: check if transaction() has been supported 

        // by calling hasfeature() function first

        m_db.transaction();

        query.prepare("DELETE FROM bookmarks WHERE id=:bmId");

        query.bindValue(":bmId", bookmarkId);

        if (!query.exec()) {

            lastErrMsg(query);

            m_db.rollback();

            return DATABASEERROR;

        }

        query.prepare("DELETE FROM tags WHERE bmid=:bmId");

        query.bindValue(":bmId", bookmarkId);

        if (!query.exec()) {

            lastErrMsg(query);

            m_db.rollback();

            return DATABASEERROR;

        if (!m_db.commit()) {

            qDebug() << m_db.lastError().text();

            m_db.rollback();

            return DATABASEERROR;

        retVal = FAILURE;

}

/**===================================================================================

 * Description: Delete all records from the bookmarks table as well as all the tags.

 * Returns: SUCCESS(0) or FAILURE(-1 or -2)

 ======================================================================================*/

int BookmarksManager::clearAll()

{

    int retVal = SUCCESS;

            lastErrMsg(query);

            m_db.rollback();

            retVal = DATABASEERROR;

            lastErrMsg(query);

            m_db.rollback();

            retVal = DATABASEERROR;

        retVal = FAILURE;

}

/**==============================================================

 * Description: Deletes a single tag associated with the bookmark

 * Returns: SUCCESS(0) or FAILURE (-1 or -2)

 ===============================================================*/

int BookmarksManager::deleteTag(int bookmarkId, QString tagToDelete)