# HG changeset patch
# User hgs
# Date 1277786672 14400
# Node ID 9b96c4b50d96db8b532957eed9a740800e994d01
# Parent 016bf4557e2ffc82257a1042e6f00f9fc69f9166
201026
diff -r 016bf4557e2f -r 9b96c4b50d96 50_layers.sysdef.xml
--- a/50_layers.sysdef.xml Fri Jun 11 13:48:52 2010 +0300
+++ b/50_layers.sysdef.xml Tue Jun 29 00:44:32 2010 -0400
@@ -7,7 +7,7 @@
-
+
diff -r 016bf4557e2f -r 9b96c4b50d96 bookmarksengine/browsercontentdll/inc/browsercontentdll.h
--- a/bookmarksengine/browsercontentdll/inc/browsercontentdll.h Fri Jun 11 13:48:52 2010 +0300
+++ b/bookmarksengine/browsercontentdll/inc/browsercontentdll.h Tue Jun 29 00:44:32 2010 -0400
@@ -121,22 +121,22 @@
BrowserContent(QString aClientName);
~BrowserContent();
- int AddBookmark(BookmarkLeaf* BookmarkContent);
- int DeleteBookmark(QString title);
- QList FetchAllBookmarks();
+ int addBookmark(BookmarkLeaf* BookmarkContent);
+ int deleteBookmark(QString title);
+ QList fetchAllBookmarks();
QList suggestBookMarks(QString atitle);
int reorderBokmarks(QString title,int new_index);
int modifyBookmark(QString aOrgTitle, QString aNewTitle, QString aNewUrl);
QObjectList suggestContent(QString atitle);
- int AddHistory(HistoryLeaf* HistoryContent);
- QList FetchHistory();
+ int addHistory(HistoryLeaf* HistoryContent);
+ QList fetchHistory();
QList suggestHistory(QString atitle);
int clearHistory();
int clearBookmarks();
- QString FetchSerializedBookmarks();
- void FetchSerializedHistory(QVector &folderVector,QMap &mymap);
- void FetchAllBookmarkTitles(QVector &title);
+ QString fetchSerializedBookmarks();
+ void fetchSerializedHistory(QVector &folderVector,QMap &mymap);
+ void fetchAllBookmarkTitles(QVector &title);
private:
int createDatabase();
diff -r 016bf4557e2f -r 9b96c4b50d96 bookmarksengine/browsercontentdll/src/browsercontentdll.cpp
--- a/bookmarksengine/browsercontentdll/src/browsercontentdll.cpp Fri Jun 11 13:48:52 2010 +0300
+++ b/bookmarksengine/browsercontentdll/src/browsercontentdll.cpp Tue Jun 29 00:44:32 2010 -0400
@@ -75,11 +75,11 @@
if (tablelist.count() == 0) {
QSqlQuery query(sqlDB);
query.exec(
- "CREATE TABLE BookMarkTable (title VARCHAR(40) NOT NULL,url VARCHAR(100),adate VARCHAR(40),tags VARCHAR(40),rowindex INTEGER, domain VARCHAR(100),CONSTRAINT pk_BookMarkTable PRIMARY KEY(title))");
+ "CREATE TABLE BookMarkTable (title VARCHAR NOT NULL,url VARCHAR,adate VARCHAR,tags VARCHAR,rowindex INTEGER, domain VARCHAR,CONSTRAINT pk_BookMarkTable PRIMARY KEY(title))");
error=query.lastError();
if (error.type() == QSqlError::NoError) {
- query.exec("CREATE TABLE HistoryTable (rowindex INTEGER PRIMARY KEY, title VARCHAR(40) NOT NULL,url VARCHAR(100),adate VARCHAR(40),atime VARCHAR(40), domain VARCHAR(100))");
+ query.exec("CREATE TABLE HistoryTable (rowindex INTEGER PRIMARY KEY, pageTitle VARCHAR NOT NULL,url VARCHAR,domain VARCHAR, timestamp int)");
error=query.lastError();
}
}
@@ -102,7 +102,7 @@
/**==============================================================
* Description: adds the bookmark to the database
================================================================*/
-int BrowserContent::AddBookmark(
+int BrowserContent::addBookmark(
BookmarkLeaf* BookmarkContent)
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
@@ -145,7 +145,7 @@
/**==============================================================
* Description: deletes the requested bookmark
================================================================*/
-int BrowserContent::DeleteBookmark(QString atitle)
+int BrowserContent::deleteBookmark(QString atitle)
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlError error;
@@ -189,7 +189,7 @@
/**==============================================================
* Description: fetches Allbookmarks From database
================================================================*/
-QList BrowserContent::FetchAllBookmarks()
+QList BrowserContent::fetchAllBookmarks()
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
@@ -208,7 +208,7 @@
QString title = query.value(0).toString();
if(title.contains("'", Qt::CaseInsensitive))
title.replace(QString("'"), QString("'"));
- if(title.contains("\"", Qt::CaseInsensitive))
+ if(title.contains("\"", Qt::CaseInsensitive))
title.replace(QString("\""), QString("""));
QString url = query.value(1).toString();
if(url.contains("'", Qt::CaseInsensitive))
@@ -342,28 +342,28 @@
/**==============================================================
* Description: adds the bookmark to the database
================================================================*/
-int BrowserContent::AddHistory(
+int BrowserContent::addHistory(
HistoryLeaf* HistoryContent)
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlError error;
QString title =HistoryContent->getTitle();
QString url = HistoryContent->getUrl();
- QString adate =HistoryContent->getDate().toString("dd.MM.yyyy");
- QString atime = HistoryContent->getLastVisited().toString("h:mm ap");
+ QDateTime dt = QDateTime::currentDateTime();
+ int timestamp = dt.toTime_t();
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
if (db.isOpen()) {
QSqlQuery query(db);
- query.prepare("INSERT INTO HistoryTable (rowindex,title, url, adate, atime, domain) "
- "VALUES (NULL,:title, :url, :adate, :atime, :domain)");
+
+ query.prepare("INSERT INTO HistoryTable (rowindex,pageTitle, url, domain, timestamp) "
+ "VALUES (NULL,:title, :url, :domain, :timestamp)");
query.bindValue(":title", QVariant(title));
query.bindValue(":url", QVariant(url));
- query.bindValue(":adate", QVariant(adate));
- query.bindValue(":atime", QVariant(atime));
query.bindValue(":domain", QVariant(filterUrl(url)));
+ query.bindValue(":timestamp", QVariant(timestamp));
query.exec();
error = query.lastError();
}
@@ -379,7 +379,7 @@
/**==============================================================
* Description: fetches History From database
================================================================*/
-QList BrowserContent::FetchHistory()
+QList BrowserContent::fetchHistory()
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
@@ -391,7 +391,7 @@
if (dbopen) {
QSqlQuery query(db);
- query.prepare("SELECT title,url,adate,atime,rowindex FROM HistoryTable ORDER BY rowindex");
+ query.prepare("SELECT pagetitle,url,rowindex,timestamp FROM HistoryTable ORDER BY timestamp ASC");
query.exec();
QSqlError error = query.lastError();
@@ -400,17 +400,17 @@
if(title.contains("\"", Qt::CaseInsensitive))
title.replace(QString("\""), QString("""));
QString url = query.value(1).toString();
- QString date = query.value(2).toString();
- QString time = query.value(3).toString();
- int aIndex=query.value(4).toInt(&ok);
- HistoryLeaf* node = new HistoryLeaf();
- QDate adate = QDate::fromString(date, "dd.MM.yyyy");
- QTime atime = QTime::fromString(time, "h:mm ap");
+ int aIndex=query.value(2).toInt(&ok);
+ uint timest = query.value(3).toUInt();
+ QDateTime dtime=QDateTime::fromTime_t ( timest );
+ QDate adate=dtime.date();
+ QTime atime =dtime.time();
+
+ HistoryLeaf* node = new HistoryLeaf();
node->setTitle(title);
node->setUrl(url);
node->setDate(adate);
node->setLastVisited(atime);
-// node->setTag(tag);
node->setIndex(aIndex);
nodeslist.append(node);
}
@@ -571,7 +571,7 @@
/**==============================================================
* Description: Retrieves the bookmarks and sends it in serialized fashion
================================================================*/
-QString BrowserContent::FetchSerializedBookmarks()
+QString BrowserContent::fetchSerializedBookmarks()
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
@@ -592,7 +592,15 @@
{
QString title = query.value(0).toString();
+ if(title.contains("'", Qt::CaseInsensitive))
+ title.replace(QString("'"), QString("'"));
+ if(title.contains("\"", Qt::CaseInsensitive))
+ title.replace(QString("\""), QString("""));
QString url = query.value(1).toString();
+ if(url.contains("'", Qt::CaseInsensitive))
+ url.replace(QString("'"), QString("'"));
+ if(url.contains("\"", Qt::CaseInsensitive))
+ url.replace(QString("\""), QString("""));
QString date = query.value(2).toString();
QString tag = query.value(3).toString();
int aIndex=query.value(4).toInt(&ok);
@@ -613,12 +621,12 @@
}
+
/**==============================================================
* Description: Retrieves the History and sends it in serialized fashion
================================================================*/
-void BrowserContent::FetchSerializedHistory(QVector &folderVector,QMap &mymap)
- {
-
+void BrowserContent::fetchSerializedHistory(QVector &folders,QMap &historyData)
+{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
QList nodeslist;
@@ -627,81 +635,69 @@
bool ok;
QString history = "";
- if (dbopen)
- {
+ if (!dbopen) {
+ return;
+ }
QSqlQuery query(db);
- query.prepare("SELECT title,url,adate,atime,rowindex FROM HistoryTable ORDER BY rowindex");
+ query.prepare("SELECT pagetitle,url,rowindex,timestamp FROM HistoryTable ORDER BY timestamp ASC");
query.exec();
QSqlError error = query.lastError();
- QString prevtitle="";
int len=query.numRowsAffected();
- static int count=1;
- while (query.next())
- {
+
+ while (query.next()) {
+ QString title = query.value(0).toString();
+
+ if(title.contains("\"", Qt::CaseInsensitive))
+ title.replace(QString("\""), QString("""));
+
+ QString url = query.value(1).toString();
+ uint timest = query.value(3).toUInt();
+ QDateTime dtime=QDateTime::fromTime_t ( timest );
+ QDate adate=dtime.date();
+ QTime atime =dtime.time();
+ int aIndex=query.value(4).toInt(&ok);
+
+ QDate currentDate = QDateTime::currentDateTime().date();
+ int daysToCurrentDate = adate.daysTo(currentDate);
- QString title = query.value(0).toString();
- QString url = query.value(1).toString();
- QString date = query.value(2).toString();
- QString time = query.value(3).toString();
- int aIndex=query.value(4).toInt(&ok);
- HistoryLeaf* node = new HistoryLeaf();
- QDate adate = QDate::fromString(date, "dd.MM.yyyy");
- QTime atime = QTime::fromString(time, "h:mm ap");
-
- QString foldertitle=findFolderForDate(adate);
-
-
- if(folderVector.contains(foldertitle))
- {
- mymap[prevtitle].append("\"},");
+ if(daysToCurrentDate < 0) {
+ continue;
+ }
+
+ QString foldertitle = findFolderForDate(adate);
+
+ if(folders.contains(foldertitle)) {
+ historyData[foldertitle].append(",");
+ } else {
+ folders.append(foldertitle);
+ historyData[foldertitle].append("[");
}
- else
- {
- folderVector.append(foldertitle);
- if(count>1)
- {
- mymap[prevtitle].append("\"}");
- mymap[prevtitle].append ("]");
- mymap[foldertitle].append("[");
- }
- else
- {
- mymap[foldertitle].append("[");
- }
- count++;
-
-
- }
-
- prevtitle=foldertitle;
-
- mymap[foldertitle].append("{");
- mymap[foldertitle].append("\"titleVal\": \"");
- mymap[foldertitle].append(title);
- mymap[foldertitle].append("\", \"dateVal\": \"");
- mymap[foldertitle].append(adate.toString("dd.MM.yyyy"));
- mymap[foldertitle].append("\", \"urlVal\": \"");
- mymap[foldertitle].append(url);
- mymap[foldertitle].append("\", \"timeVal\": \"");
- mymap[foldertitle].append(atime.toString("h:mm ap"));
- }
- mymap[prevtitle].append("\"}");
- mymap[prevtitle].append ("]");
- }
-
+ historyData[foldertitle].append("{");
+ historyData[foldertitle].append("\"titleVal\": \"");
+ historyData[foldertitle].append(title);
+ historyData[foldertitle].append("\", \"dateVal\": \"");
+ historyData[foldertitle].append(adate.toString("dd.MM.yyyy"));
+ historyData[foldertitle].append("\", \"urlVal\": \"");
+ historyData[foldertitle].append(url);
+ historyData[foldertitle].append("\", \"timeVal\": \"");
+ historyData[foldertitle].append(atime.toString("h:mm ap"));
+ historyData[foldertitle].append("\"}");
}
+ for (int i = 0; i < folders.size(); ++i) {
+ historyData[folders[i]].append("]");
+ }
+}
/**==============================================================
* Description: Retrieves the bookmark titles and sends it in serialized fashion
================================================================*/
-void BrowserContent::FetchAllBookmarkTitles(QVector &title)
+void BrowserContent::fetchAllBookmarkTitles(QVector &title)
{
BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
bool dbopen = db.isOpen();
- bool ok;
int i=0;
if(dbopen)
@@ -746,13 +742,13 @@
//Check if date to belongs to current week folder
//Should disply the day for the current week
- if(daysToCurrentDate < 7 && currentDayOfWeek > nodeDayOfWeek ){
+ if(daysToCurrentDate > 1 && daysToCurrentDate < 7 && currentDayOfWeek > nodeDayOfWeek ){
QString folder = qtTrId("txt_browser_history_this_week");
return folder;
- }
+ }
- if(dateInThisMonth(nodeDate)){
+ if(daysToCurrentDate > 1 && dateInThisMonth(nodeDate)){
QString folder = qtTrId("txt_browser_history_this_month");
return folder;
}