locationdataharvester/locationdatalookupdb/locationdatalookupdb.cpp
changeset 35 59575560d1e6
parent 31 8db05346071b
child 41 b3dd5ec3089d
--- a/locationdataharvester/locationdatalookupdb/locationdatalookupdb.cpp	Tue Jul 06 14:10:28 2010 +0300
+++ b/locationdataharvester/locationdatalookupdb/locationdatalookupdb.cpp	Wed Aug 18 09:43:18 2010 +0300
@@ -339,6 +339,28 @@
     }
 }
 
+
+// ---------------------------------------------------------
+// LocationDataLookupDb::updateEntryNameById()
+// ---------------------------------------------------------
+void LocationDataLookupDb::updateEntryNameByIdAndType(quint32 aSourceId, quint32 aSourceType , QString aName)
+{
+	if( mDbOpen )
+		{
+			QSqlQuery query(*mDb);
+			query.prepare("UPDATE lplookup SET "							
+							"name = ? "							
+						    "WHERE sourceid = ? AND sourcetype = ?");
+		
+			query.addBindValue( aName );
+			
+			query.addBindValue( aSourceId );
+			query.addBindValue( aSourceType );				
+			
+			query.exec();
+		}
+}
+
 // ---------------------------------------------------------
 // LocationDataLookupDb::deleteEntryBySourceIdAndType()
 // ---------------------------------------------------------
@@ -518,19 +540,19 @@
 // ---------------------------------------------------------
 // LocationDataLookupDb::getAddressDetails()
 // ---------------------------------------------------------
-QString LocationDataLookupDb::getAddressDetails( quint32 mId , quint32 mSourceType )
+QString LocationDataLookupDb::getAddressDetails( quint32 aId , quint32 aSourceType )
 {
     QString addressDetails;
     if (mDbOpen)
     {
         QSqlQuery query(*mDb);
-        if (mSourceType == ESourceContactsPref || mSourceType
-                == ESourceContactsWork || mSourceType == ESourceContactsHome)
+        if ( aSourceType == ESourceContactsPref || aSourceType
+                == ESourceContactsWork || aSourceType == ESourceContactsHome)
         {
             query.prepare("SELECT * FROM lplookup "
                 "WHERE sourceid = ? AND sourcetype = ?");
-            query.addBindValue(mId);
-            query.addBindValue(mSourceType);
+            query.addBindValue( aId );
+            query.addBindValue( aSourceType );
             query.exec();
             if (query.first()) {
                 QSqlRecord rec = query.record();
@@ -579,11 +601,11 @@
             }
 
         }
-        else if (mSourceType == ESourceCalendar)
+        else if (aSourceType == ESourceCalendar)
         {
             query.prepare("SELECT * FROM lplookupaddress "
                 "WHERE sourceid = ? ");
-            query.addBindValue(mId);
+            query.addBindValue( aId );
             query.exec();
             if ( query.first() )
             {
@@ -626,8 +648,9 @@
          {
              QSqlQuery query(*mDb);
              query.prepare( "SELECT * FROM lplookup " 
-                     "WHERE sourcetype = ?" );
+                     "WHERE sourcetype = ? AND duplicate = ?" );
              query.addBindValue( ESourceCalendar );
+             query.addBindValue( 0 );
              query.exec();
              
              qDebug("size %d",query.size());             
@@ -656,7 +679,9 @@
     //     else // all contents
          {
              QSqlQuery query(*mDb);
-             query.prepare( "SELECT * FROM lplookup" );
+             query.prepare( "SELECT * FROM lplookup"
+                     "WHERE duplicate = ?" );
+             query.addBindValue( 0 );
              query.exec();
              int count=0;
              while( query.next() )  count++;