FCL/sf/app/location: comparison locationdataharvester/locationdatalookupdb/locationdatalookupdb.cpp

equal deleted inserted replaced

-:793f76d9ab0c
+:b3dd5ec3089d
 #include <QSqlDatabase>
 #include <QSqlError>
 #include <QSqlQuery>
 #include <QSqlRecord>
 #include <QVariant>
-#include<locationservicedefines.h>
+#include <locationservicedefines.h>
+#include <mylocationsdefines.h>
-// database name
-#ifdef LOCPICKER_UNIT_TEST
-const QString KLocationDataLookupDbName = "c:\\locationdatalookuptestdb.db";
-#else
-const QString KLocationDataLookupDbName = "c:\\locationdatalookupdb.db";
-#endif
 // ================= MEMBER FUNCTIONS =======================
 //
 // ---------------------------------------------------------
 "icontype int,"
 "iconpath varchar(255),"
 "maptile varchar(255))");
-query.exec("create table if not exists lplookupaddress ("
+query.exec("create table if not exists calendarlocation ("
 "sourceid int,"
 "address varchar(255))");
 mDb->close();
 }
 query.bindValue(":maptile", aLookupItem.mMapTilePath);
 query.exec();
 QVariant var = query.lastInsertId();
 aLookupItem.mId = var.toInt();
-if(aLookupItem.mSourceType==ESourceCalendar)
-{
-query.prepare("INSERT INTO lplookupaddress ("
-"sourceid ,"
-"address )"
-"VALUES ("
-":sourceid, "
-":address) " );
-query.bindValue(":sourceid", aLookupItem.mSourceUid);
-query.bindValue(":address", aLookupItem.mSingleLineAddress);
-query.exec();
-}
 }
 }
 // ---------------------------------------------------------
 // LocationDataLookupDb::updateEntryBySourceIdAndType()
 query.addBindValue( aLookupItem.mSourceUid );
 query.addBindValue( aLookupItem.mSourceType );
 query.exec();
-if(aLookupItem.mSourceType==ESourceCalendar)
-{
-query.prepare("UPDATE lplookupaddress SET "
-"address = ? "
-"WHERE sourceid = ? ");
-query.addBindValue( aLookupItem.mSingleLineAddress);
-query.addBindValue( aLookupItem.mSourceUid);
-query.exec();
-}
 }
 }
 // ---------------------------------------------------------
 query.addBindValue( aLookupItem.mMapTilePath );
 query.addBindValue( aLookupItem.mId );
 query.exec();
-if(aLookupItem.mSourceType==ESourceCalendar)
-{
-query.prepare("UPDATE lplookupaddress SET "
-"address = ? "
-"WHERE sourceid = ?");
-query.addBindValue( aLookupItem.mSingleLineAddress);
-query.addBindValue( aLookupItem.mSourceUid );
-query.exec();
-}
 }
 }
 // ---------------------------------------------------------
 query.addBindValue( aLookupItem.mSourceUid );
 query.addBindValue( aLookupItem.mSourceType );
 query.exec();
-if(aLookupItem.mSourceType==ESourceCalendar)
-{
-query.prepare( "DELETE FROM lplookupaddress "
-"WHERE sourceid = ? " );
-query.addBindValue( aLookupItem.mSourceUid );
-query.exec();
-}
 }
 }
 // ---------------------------------------------------------
 // LocationDataLookupDb::findEntryBySourceIdAndType()
 }
 }
 else if (aSourceType == ESourceCalendar)
 {
-query.prepare("SELECT * FROM lplookupaddress "
+query.prepare("SELECT * FROM calendarlocation "
 "WHERE sourceid = ? ");
 query.addBindValue( aId );
 query.exec();
 if ( query.first() )
 {
 }
 }
+// ---------------------------------------------------------
+// LocationDataLookupDb::updateCalendarLocationById()
+// ---------------------------------------------------------
+void LocationDataLookupDb::updateCalendarLocationById(quint32 id , QString location)
+{
+QSqlQuery query(*mDb);
+query.prepare("SELECT * FROM calendarlocation "
+"WHERE sourceid = ? ");
+query.addBindValue(id);
+query.exec();
+if (query.first()) {
+query.prepare("UPDATE calendarlocation SET "
+"address = ? "
+"WHERE sourceid = ?");
+query.addBindValue( location );
+query.addBindValue( id);
+}
+else {
+query.prepare("INSERT INTO calendarlocation ("
+"sourceid ,"
+"address )"
+"VALUES ("
+":sourceid, "
+":address) ");
+query.bindValue(":sourceid", id);
+query.bindValue(":address", location);
+}
+query.exec();
+}
+// ---------------------------------------------------------
+// LocationDataLookupDb::deleteCalendarEntry()
+// ---------------------------------------------------------
+void LocationDataLookupDb::deleteCalendarEntry(quint32 id)
+{
+QSqlQuery query(*mDb);
+query.prepare( "DELETE FROM calendarlocation "
+"WHERE sourceid = ? " );
+query.addBindValue( id );
+query.exec();
+}
+// ---------------------------------------------------------
+// LocationDataLookupDb::getAllCalendarEntry()
+// ---------------------------------------------------------
+void LocationDataLookupDb::getAllCalendarEntry(QList<QCalendarLocationDetails>& lookupItemArray)
+{
+QSqlQuery query(*mDb);
+query.prepare( "SELECT * FROM calendarlocation ");
+query.exec();
+while( query.next() ) {
+QCalendarLocationDetails calendarEntry;
+QSqlRecord rec = query.record();
+calendarEntry.mSourceUid = query.value( rec.indexOf("sourceid") ).toUInt();
+calendarEntry.mOnelineLocation = query.value( rec.indexOf("address") ).toString();
+lookupItemArray.append(calendarEntry);
+}
+}
 // End of file

changeset 41	b3dd5ec3089d
parent 35	59575560d1e6