337 query.exec(); |
337 query.exec(); |
338 } |
338 } |
339 } |
339 } |
340 } |
340 } |
341 |
341 |
|
342 |
|
343 // --------------------------------------------------------- |
|
344 // LocationDataLookupDb::updateEntryNameById() |
|
345 // --------------------------------------------------------- |
|
346 void LocationDataLookupDb::updateEntryNameByIdAndType(quint32 aSourceId, quint32 aSourceType , QString aName) |
|
347 { |
|
348 if( mDbOpen ) |
|
349 { |
|
350 QSqlQuery query(*mDb); |
|
351 query.prepare("UPDATE lplookup SET " |
|
352 "name = ? " |
|
353 "WHERE sourceid = ? AND sourcetype = ?"); |
|
354 |
|
355 query.addBindValue( aName ); |
|
356 |
|
357 query.addBindValue( aSourceId ); |
|
358 query.addBindValue( aSourceType ); |
|
359 |
|
360 query.exec(); |
|
361 } |
|
362 } |
|
363 |
342 // --------------------------------------------------------- |
364 // --------------------------------------------------------- |
343 // LocationDataLookupDb::deleteEntryBySourceIdAndType() |
365 // LocationDataLookupDb::deleteEntryBySourceIdAndType() |
344 // --------------------------------------------------------- |
366 // --------------------------------------------------------- |
345 void LocationDataLookupDb::deleteEntryBySourceIdAndType( const QLookupItem& aLookupItem ) |
367 void LocationDataLookupDb::deleteEntryBySourceIdAndType( const QLookupItem& aLookupItem ) |
346 { |
368 { |
516 } |
538 } |
517 |
539 |
518 // --------------------------------------------------------- |
540 // --------------------------------------------------------- |
519 // LocationDataLookupDb::getAddressDetails() |
541 // LocationDataLookupDb::getAddressDetails() |
520 // --------------------------------------------------------- |
542 // --------------------------------------------------------- |
521 QString LocationDataLookupDb::getAddressDetails( quint32 mId , quint32 mSourceType ) |
543 QString LocationDataLookupDb::getAddressDetails( quint32 aId , quint32 aSourceType ) |
522 { |
544 { |
523 QString addressDetails; |
545 QString addressDetails; |
524 if (mDbOpen) |
546 if (mDbOpen) |
525 { |
547 { |
526 QSqlQuery query(*mDb); |
548 QSqlQuery query(*mDb); |
527 if (mSourceType == ESourceContactsPref || mSourceType |
549 if ( aSourceType == ESourceContactsPref || aSourceType |
528 == ESourceContactsWork || mSourceType == ESourceContactsHome) |
550 == ESourceContactsWork || aSourceType == ESourceContactsHome) |
529 { |
551 { |
530 query.prepare("SELECT * FROM lplookup " |
552 query.prepare("SELECT * FROM lplookup " |
531 "WHERE sourceid = ? AND sourcetype = ?"); |
553 "WHERE sourceid = ? AND sourcetype = ?"); |
532 query.addBindValue(mId); |
554 query.addBindValue( aId ); |
533 query.addBindValue(mSourceType); |
555 query.addBindValue( aSourceType ); |
534 query.exec(); |
556 query.exec(); |
535 if (query.first()) { |
557 if (query.first()) { |
536 QSqlRecord rec = query.record(); |
558 QSqlRecord rec = query.record(); |
537 QString temp; |
559 QString temp; |
538 temp.clear(); |
560 temp.clear(); |
577 } |
599 } |
578 |
600 |
579 } |
601 } |
580 |
602 |
581 } |
603 } |
582 else if (mSourceType == ESourceCalendar) |
604 else if (aSourceType == ESourceCalendar) |
583 { |
605 { |
584 query.prepare("SELECT * FROM lplookupaddress " |
606 query.prepare("SELECT * FROM lplookupaddress " |
585 "WHERE sourceid = ? "); |
607 "WHERE sourceid = ? "); |
586 query.addBindValue(mId); |
608 query.addBindValue( aId ); |
587 query.exec(); |
609 query.exec(); |
588 if ( query.first() ) |
610 if ( query.first() ) |
589 { |
611 { |
590 QSqlRecord rec = query.record(); |
612 QSqlRecord rec = query.record(); |
591 addressDetails.append( |
613 addressDetails.append( |
624 |
646 |
625 // ESourceLandmarksCalendarCat |
647 // ESourceLandmarksCalendarCat |
626 { |
648 { |
627 QSqlQuery query(*mDb); |
649 QSqlQuery query(*mDb); |
628 query.prepare( "SELECT * FROM lplookup " |
650 query.prepare( "SELECT * FROM lplookup " |
629 "WHERE sourcetype = ?" ); |
651 "WHERE sourcetype = ? AND duplicate = ?" ); |
630 query.addBindValue( ESourceCalendar ); |
652 query.addBindValue( ESourceCalendar ); |
|
653 query.addBindValue( 0 ); |
631 query.exec(); |
654 query.exec(); |
632 |
655 |
633 qDebug("size %d",query.size()); |
656 qDebug("size %d",query.size()); |
634 int count=0; |
657 int count=0; |
635 while( query.next() ) count++; |
658 while( query.next() ) count++; |
654 |
677 |
655 |
678 |
656 // else // all contents |
679 // else // all contents |
657 { |
680 { |
658 QSqlQuery query(*mDb); |
681 QSqlQuery query(*mDb); |
659 query.prepare( "SELECT * FROM lplookup" ); |
682 query.prepare( "SELECT * FROM lplookup" |
|
683 "WHERE duplicate = ?" ); |
|
684 query.addBindValue( 0 ); |
660 query.exec(); |
685 query.exec(); |
661 int count=0; |
686 int count=0; |
662 while( query.next() ) count++; |
687 while( query.next() ) count++; |
663 aCount.append(count); |
688 aCount.append(count); |
664 } |
689 } |