void TestSqlTrack::testRemoveLabelFromTrack() { Meta::TrackPtr track = m_collection->registry()->getTrack( "/IDoNotExist.mp3" ); Meta::LabelPtr label = m_collection->registry()->getLabel( "A" ); track->addLabel( label ); QCOMPARE( track->labels().count(), 1 ); track->removeLabel( label ); QCOMPARE( track->labels().count(), 0 ); QStringList urlsLabelsCount = m_storage->query( "SELECT COUNT(*) FROM urls_labels;" ); QCOMPARE( urlsLabelsCount.first().toInt(), 0 ); }
void TestSqlTrack::testRemoveLabelFromTrackWhenNotInCache() { m_storage->query( "INSERT INTO labels(id,label) VALUES (1,'A');" ); m_storage->query( "INSERT INTO urls_labels(url,label) VALUES (1,1);" ); Meta::TrackPtr track = m_collection->registry()->getTrack( "/IDoNotExist.mp3" ); Meta::LabelPtr label = m_collection->registry()->getLabel( "A" ); track->removeLabel( label ); QCOMPARE( track->labels().count(), 0 ); QStringList urlsLabelsCount = m_storage->query( "SELECT COUNT(*) FROM urls_labels;" ); QCOMPARE( urlsLabelsCount.first().toInt(), 0 ); }