Differential D20531 Diff 56715 autotests/databaseinterfacetest.cpp

Changeset View

Standalone View

View Options

autotests/databaseinterfacetest.cpp

Show First 20 Lines • Show All 146 Lines • ▼ Show 20 Line(s)86 {
147 147​
148 auto track = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"), 148​ auto track = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"),
149 QStringLiteral("album3"), 6, 1)); 149​ QStringLiteral("album3"), 6, 1));
150 150​
151 QCOMPARE(track.isValid(), true); 151​ QCOMPARE(track.isValid(), true);
152 QCOMPARE(track.title(), QStringLiteral("track6")); 152​ QCOMPARE(track.title(), QStringLiteral("track6"));
153 QCOMPARE(track.artist(), QStringLiteral("artist2")); 153​ QCOMPARE(track.artist(), QStringLiteral("artist2"));
154 QCOMPARE(track.album(), QStringLiteral("album3")); 154​ QCOMPARE(track.album(), QStringLiteral("album3"));
155 QVERIFY(track.albumArtist().isEmpty()); 155​ QVERIFY(!track.albumArtist().isEmpty());
156 QCOMPARE(track.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 156​ QCOMPARE(track.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
157 QCOMPARE(track.trackNumber(), 6); 157​ QCOMPARE(track.trackNumber(), 6);
158 QCOMPARE(track.discNumber(), 1); 158​ QCOMPARE(track.discNumber(), 1);
159 QCOMPARE(track.duration(), QTime::fromMSecsSinceStartOfDay(23)); 159​ QCOMPARE(track.duration(), QTime::fromMSecsSinceStartOfDay(23));
160 QCOMPARE(track.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$23"))); 160​ QCOMPARE(track.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$23")));
161 QCOMPARE(track.rating(), 5); 161​ QCOMPARE(track.rating(), 5);
162 QCOMPARE(track.genre(), QStringLiteral("genre1")); 162​ QCOMPARE(track.genre(), QStringLiteral("genre1"));
163 QCOMPARE(track.composer(), QStringLiteral("composer1")); 163​ QCOMPARE(track.composer(), QStringLiteral("composer1"));
164 QCOMPARE(track.lyricist(), QStringLiteral("lyricist1")); 164​ QCOMPARE(track.lyricist(), QStringLiteral("lyricist1"));
165 165​
166 auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2")); 166​ auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2"));
167 QVERIFY(albumId != 0); 167​ QVERIFY(albumId != 0);
168 auto album = musicDb.albumDataFromDatabaseId(albumId); 168​ auto album = musicDb.albumDataFromDatabaseId(albumId);
169 auto albumData = musicDb.albumData(albumId); 169​ auto albumData = musicDb.albumData(albumId);
170 170​
171 QCOMPARE(album.isValid(), true); 171​ QCOMPARE(album.isValid(), true);
172 QCOMPARE(albumData.count(), 1); 172​ QCOMPARE(albumData.count(), 1);
173 QCOMPARE(album.title(), QStringLiteral("album3")); 173​ QCOMPARE(album.title(), QStringLiteral("album3"));
174 QCOMPARE(album.artist(), {}); 174​ QCOMPARE(album.artist(), QStringLiteral("artist2"));
175 QCOMPARE(album.isValidArtist(), false); 175​ QVERIFY(album.isValidArtist());
176 QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3"))); 176​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
177 QCOMPARE(album.isSingleDiscAlbum(), true); 177​ QCOMPARE(album.isSingleDiscAlbum(), true);
178 } 178​ }
179 179​
180 void addAndRemoveOneTrackWithoutAlbum() 180​ void addAndRemoveOneTrackWithoutAlbum()
181 { 181​ {
182 QTemporaryFile databaseFile; 182​ QTemporaryFile databaseFile;
183 databaseFile.open(); 183​ databaseFile.open();
▲ Show 20 Lines • Show All 427 Lines • ▼ Show 20 Line(s)563 {
611 auto newCovers = mNewCovers; 611​ auto newCovers = mNewCovers;
612 newCovers[QStringLiteral("file:///$23")] = QUrl::fromLocalFile(QStringLiteral("album3")); 612​ newCovers[QStringLiteral("file:///$23")] = QUrl::fromLocalFile(QStringLiteral("album3"));
613 newCovers[QStringLiteral("file:///$20")] = QUrl::fromLocalFile(QStringLiteral("album3")); 613​ newCovers[QStringLiteral("file:///$20")] = QUrl::fromLocalFile(QStringLiteral("album3"));
614 614​
615 musicDb.insertTracksList(newTracks, newCovers); 615​ musicDb.insertTracksList(newTracks, newCovers);
616 616​
617 musicDbTrackAddedSpy.wait(300); 617​ musicDbTrackAddedSpy.wait(300);
618 618​
619 QCOMPARE(musicDb.allAlbumsData().count(), 1); 619​ QCOMPARE(musicDb.allAlbumsData().count(), 2);
620 QCOMPARE(musicDb.allArtistsData().count(), 2); 620​ QCOMPARE(musicDb.allArtistsData().count(), 2);
621 QCOMPARE(musicDb.allTracksData().count(), 2); 621​ QCOMPARE(musicDb.allTracksData().count(), 2);
622 QCOMPARE(musicDbArtistAddedSpy.count(), 1); 622​ QCOMPARE(musicDbArtistAddedSpy.count(), 1);
623 QCOMPARE(musicDbAlbumAddedSpy.count(), 1); 623​ QCOMPARE(musicDbAlbumAddedSpy.count(), 1);
624 QCOMPARE(musicDbTrackAddedSpy.count(), 1); 624​ QCOMPARE(musicDbTrackAddedSpy.count(), 1);
625 QCOMPARE(musicDbArtistRemovedSpy.count(), 0); 625​ QCOMPARE(musicDbArtistRemovedSpy.count(), 0);
626 QCOMPARE(musicDbAlbumRemovedSpy.count(), 0); 626​ QCOMPARE(musicDbAlbumRemovedSpy.count(), 0);
627 QCOMPARE(musicDbTrackRemovedSpy.count(), 0); 627​ QCOMPARE(musicDbTrackRemovedSpy.count(), 0);
628 QCOMPARE(musicDbAlbumModifiedSpy.count(), 0); 628​ QCOMPARE(musicDbAlbumModifiedSpy.count(), 0);
629 QCOMPARE(musicDbTrackModifiedSpy.count(), 0); 629​ QCOMPARE(musicDbTrackModifiedSpy.count(), 0);
630 QCOMPARE(musicDbDatabaseErrorSpy.count(), 0); 630​ QCOMPARE(musicDbDatabaseErrorSpy.count(), 0);
631 631​
632 auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"), 632​ auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"),
633 QStringLiteral("album3"), 6, 1)); 633​ QStringLiteral("album3"), 6, 1));
634 634​
635 QCOMPARE(firstTrack.isValid(), true); 635​ QCOMPARE(firstTrack.isValid(), true);
636 QCOMPARE(firstTrack.title(), QStringLiteral("track6")); 636​ QCOMPARE(firstTrack.title(), QStringLiteral("track6"));
637 QCOMPARE(firstTrack.artist(), QStringLiteral("artist2")); 637​ QCOMPARE(firstTrack.artist(), QStringLiteral("artist2"));
638 QCOMPARE(firstTrack.album(), QStringLiteral("album3")); 638​ QCOMPARE(firstTrack.album(), QStringLiteral("album3"));
639 QVERIFY(firstTrack.albumArtist().isEmpty()); 639​ QVERIFY(!firstTrack.albumArtist().isEmpty());
640 QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 640​ QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
641 QCOMPARE(firstTrack.trackNumber(), 6); 641​ QCOMPARE(firstTrack.trackNumber(), 6);
642 QCOMPARE(firstTrack.discNumber(), 1); 642​ QCOMPARE(firstTrack.discNumber(), 1);
643 QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19)); 643​ QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19));
644 QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19"))); 644​ QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19")));
645 QCOMPARE(firstTrack.rating(), 5); 645​ QCOMPARE(firstTrack.rating(), 5);
646 QCOMPARE(firstTrack.genre(), QStringLiteral("genre1")); 646​ QCOMPARE(firstTrack.genre(), QStringLiteral("genre1"));
647 QCOMPARE(firstTrack.composer(), QStringLiteral("composer1")); 647​ QCOMPARE(firstTrack.composer(), QStringLiteral("composer1"));
648 QCOMPARE(firstTrack.lyricist(), QStringLiteral("lyricist1")); 648​ QCOMPARE(firstTrack.lyricist(), QStringLiteral("lyricist1"));
649 QCOMPARE(firstTrack.hasEmbeddedCover(), true); 649​ QCOMPARE(firstTrack.hasEmbeddedCover(), true);
650 650​
651 auto secondTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track7"), QStringLiteral("artist3"), 651​ auto secondTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track7"), QStringLiteral("artist3"),
652 QStringLiteral("album3"), 7, 1)); 652​ QStringLiteral("album3"), 7, 1));
653 653​
654 QCOMPARE(secondTrack.isValid(), true); 654​ QCOMPARE(secondTrack.isValid(), true);
655 QCOMPARE(secondTrack.title(), QStringLiteral("track7")); 655​ QCOMPARE(secondTrack.title(), QStringLiteral("track7"));
656 QCOMPARE(secondTrack.artist(), QStringLiteral("artist3")); 656​ QCOMPARE(secondTrack.artist(), QStringLiteral("artist3"));
657 QCOMPARE(secondTrack.album(), QStringLiteral("album3")); 657​ QCOMPARE(secondTrack.album(), QStringLiteral("album3"));
658 QVERIFY(secondTrack.albumArtist().isEmpty()); 658​ QVERIFY(!secondTrack.albumArtist().isEmpty());
659 QCOMPARE(secondTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 659​ QCOMPARE(secondTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
660 QCOMPARE(secondTrack.trackNumber(), 7); 660​ QCOMPARE(secondTrack.trackNumber(), 7);
661 QCOMPARE(secondTrack.discNumber(), 1); 661​ QCOMPARE(secondTrack.discNumber(), 1);
662 QCOMPARE(secondTrack.duration(), QTime::fromMSecsSinceStartOfDay(20)); 662​ QCOMPARE(secondTrack.duration(), QTime::fromMSecsSinceStartOfDay(20));
663 QCOMPARE(secondTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$20"))); 663​ QCOMPARE(secondTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$20")));
664 QCOMPARE(secondTrack.rating(), 5); 664​ QCOMPARE(secondTrack.rating(), 5);
665 QCOMPARE(secondTrack.genre(), QStringLiteral("genre1")); 665​ QCOMPARE(secondTrack.genre(), QStringLiteral("genre1"));
666 QCOMPARE(secondTrack.composer(), QStringLiteral("composer1")); 666​ QCOMPARE(secondTrack.composer(), QStringLiteral("composer1"));
667 QCOMPARE(secondTrack.lyricist(), QStringLiteral("lyricist1")); 667​ QCOMPARE(secondTrack.lyricist(), QStringLiteral("lyricist1"));
668 QCOMPARE(secondTrack.hasEmbeddedCover(), false); 668​ QCOMPARE(secondTrack.hasEmbeddedCover(), false);
669 669​
670 auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2")); 670​ auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2"));
671 auto album = musicDb.albumDataFromDatabaseId(albumId); 671​ auto album = musicDb.albumDataFromDatabaseId(albumId);
672 auto albumData = musicDb.albumData(albumId); 672​ auto albumData = musicDb.albumData(albumId);
673 673​
674 QCOMPARE(album.isValid(), true); 674​ QCOMPARE(album.isValid(), true);
675 QCOMPARE(albumData.count(), 2); 675​ QCOMPARE(albumData.count(), 1);
676 QCOMPARE(album.title(), QStringLiteral("album3")); 676​ QCOMPARE(album.title(), QStringLiteral("album3"));
677 QCOMPARE(album.isValidArtist(), false); 677​ QVERIFY(album.isValidArtist());
678​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
679​ QCOMPARE(album.isSingleDiscAlbum(), true);
680​
681​ albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist3"));
682​ album = musicDb.albumDataFromDatabaseId(albumId);
683​ albumData = musicDb.albumData(albumId);
684​
685​ QCOMPARE(album.isValid(), true);
686​ QCOMPARE(albumData.count(), 1);
687​ QCOMPARE(album.title(), QStringLiteral("album3"));
688​ QVERIFY(album.isValidArtist());
678 QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3"))); 689​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
679 QCOMPARE(album.isSingleDiscAlbum(), true); 690​ QCOMPARE(album.isSingleDiscAlbum(), true);
680 } 691​ }
681 692​
682 void addThreeTracksWithoutAlbumArtistButSameArtist() 693​ void addThreeTracksWithoutAlbumArtistButSameArtist()
683 { 694​ {
684 DatabaseInterface musicDb; 695​ DatabaseInterface musicDb;
685 696​
▲ Show 20 Lines • Show All 67 Lines • ▼ Show 20 Line(s)
753 764​
754 auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"), 765​ auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"),
755 QStringLiteral("album3"), 6, 1)); 766​ QStringLiteral("album3"), 6, 1));
756 767​
757 QCOMPARE(firstTrack.isValid(), true); 768​ QCOMPARE(firstTrack.isValid(), true);
758 QCOMPARE(firstTrack.title(), QStringLiteral("track6")); 769​ QCOMPARE(firstTrack.title(), QStringLiteral("track6"));
759 QCOMPARE(firstTrack.artist(), QStringLiteral("artist2")); 770​ QCOMPARE(firstTrack.artist(), QStringLiteral("artist2"));
760 QCOMPARE(firstTrack.album(), QStringLiteral("album3")); 771​ QCOMPARE(firstTrack.album(), QStringLiteral("album3"));
761 QVERIFY(firstTrack.albumArtist().isEmpty()); 772​ QVERIFY(!firstTrack.albumArtist().isEmpty());
762 QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 773​ QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
763 QCOMPARE(firstTrack.trackNumber(), 6); 774​ QCOMPARE(firstTrack.trackNumber(), 6);
764 QCOMPARE(firstTrack.discNumber(), 1); 775​ QCOMPARE(firstTrack.discNumber(), 1);
765 QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19)); 776​ QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19));
766 QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19"))); 777​ QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19")));
767 QCOMPARE(firstTrack.rating(), 5); 778​ QCOMPARE(firstTrack.rating(), 5);
768 QCOMPARE(firstTrack.genre(), QStringLiteral("genre1")); 779​ QCOMPARE(firstTrack.genre(), QStringLiteral("genre1"));
769 QCOMPARE(firstTrack.composer(), QStringLiteral("composer1")); 780​ QCOMPARE(firstTrack.composer(), QStringLiteral("composer1"));
770 QCOMPARE(firstTrack.lyricist(), QStringLiteral("lyricist1")); 781​ QCOMPARE(firstTrack.lyricist(), QStringLiteral("lyricist1"));
771 QCOMPARE(firstTrack.isSingleDiscAlbum(), true); 782​ QCOMPARE(firstTrack.isSingleDiscAlbum(), true);
772 783​
773 auto secondTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track7"), QStringLiteral("artist2"), 784​ auto secondTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track7"), QStringLiteral("artist2"),
774 QStringLiteral("album3"), 7, 1)); 785​ QStringLiteral("album3"), 7, 1));
775 786​
776 QCOMPARE(secondTrack.isValid(), true); 787​ QCOMPARE(secondTrack.isValid(), true);
777 QCOMPARE(secondTrack.title(), QStringLiteral("track7")); 788​ QCOMPARE(secondTrack.title(), QStringLiteral("track7"));
778 QCOMPARE(secondTrack.artist(), QStringLiteral("artist2")); 789​ QCOMPARE(secondTrack.artist(), QStringLiteral("artist2"));
779 QCOMPARE(secondTrack.album(), QStringLiteral("album3")); 790​ QCOMPARE(secondTrack.album(), QStringLiteral("album3"));
780 QVERIFY(secondTrack.albumArtist().isEmpty()); 791​ QVERIFY(!secondTrack.albumArtist().isEmpty());
781 QCOMPARE(secondTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 792​ QCOMPARE(secondTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
782 QCOMPARE(secondTrack.trackNumber(), 7); 793​ QCOMPARE(secondTrack.trackNumber(), 7);
783 QCOMPARE(secondTrack.discNumber(), 1); 794​ QCOMPARE(secondTrack.discNumber(), 1);
784 QCOMPARE(secondTrack.duration(), QTime::fromMSecsSinceStartOfDay(20)); 795​ QCOMPARE(secondTrack.duration(), QTime::fromMSecsSinceStartOfDay(20));
785 QCOMPARE(secondTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$20"))); 796​ QCOMPARE(secondTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$20")));
786 QCOMPARE(secondTrack.rating(), 4); 797​ QCOMPARE(secondTrack.rating(), 4);
787 QCOMPARE(secondTrack.genre(), QStringLiteral("genre1")); 798​ QCOMPARE(secondTrack.genre(), QStringLiteral("genre1"));
788 QCOMPARE(secondTrack.composer(), QStringLiteral("composer1")); 799​ QCOMPARE(secondTrack.composer(), QStringLiteral("composer1"));
789 QCOMPARE(secondTrack.lyricist(), QStringLiteral("lyricist1")); 800​ QCOMPARE(secondTrack.lyricist(), QStringLiteral("lyricist1"));
790 QCOMPARE(secondTrack.isSingleDiscAlbum(), true); 801​ QCOMPARE(secondTrack.isSingleDiscAlbum(), true);
791 QCOMPARE(secondTrack.hasEmbeddedCover(), false); 802​ QCOMPARE(secondTrack.hasEmbeddedCover(), false);
792 803​
793 auto thirdTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track8"), QStringLiteral("artist2"), 804​ auto thirdTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track8"), QStringLiteral("artist2"),
794 QStringLiteral("album3"), 8, 1)); 805​ QStringLiteral("album3"), 8, 1));
795 806​
796 QCOMPARE(thirdTrack.isValid(), true); 807​ QCOMPARE(thirdTrack.isValid(), true);
797 QCOMPARE(thirdTrack.title(), QStringLiteral("track8")); 808​ QCOMPARE(thirdTrack.title(), QStringLiteral("track8"));
798 QCOMPARE(thirdTrack.artist(), QStringLiteral("artist2")); 809​ QCOMPARE(thirdTrack.artist(), QStringLiteral("artist2"));
799 QCOMPARE(thirdTrack.album(), QStringLiteral("album3")); 810​ QCOMPARE(thirdTrack.album(), QStringLiteral("album3"));
800 QVERIFY(thirdTrack.albumArtist().isEmpty()); 811​ QVERIFY(!thirdTrack.albumArtist().isEmpty());
801 QCOMPARE(thirdTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 812​ QCOMPARE(thirdTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
802 QCOMPARE(thirdTrack.trackNumber(), 8); 813​ QCOMPARE(thirdTrack.trackNumber(), 8);
803 QCOMPARE(thirdTrack.discNumber(), 1); 814​ QCOMPARE(thirdTrack.discNumber(), 1);
804 QCOMPARE(thirdTrack.duration(), QTime::fromMSecsSinceStartOfDay(21)); 815​ QCOMPARE(thirdTrack.duration(), QTime::fromMSecsSinceStartOfDay(21));
805 QCOMPARE(thirdTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$21"))); 816​ QCOMPARE(thirdTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$21")));
806 QCOMPARE(thirdTrack.rating(), 3); 817​ QCOMPARE(thirdTrack.rating(), 3);
807 QCOMPARE(thirdTrack.genre(), QStringLiteral("genre1")); 818​ QCOMPARE(thirdTrack.genre(), QStringLiteral("genre1"));
808 QCOMPARE(thirdTrack.composer(), QStringLiteral("composer1")); 819​ QCOMPARE(thirdTrack.composer(), QStringLiteral("composer1"));
809 QCOMPARE(thirdTrack.lyricist(), QStringLiteral("lyricist1")); 820​ QCOMPARE(thirdTrack.lyricist(), QStringLiteral("lyricist1"));
810 QCOMPARE(thirdTrack.isSingleDiscAlbum(), true); 821​ QCOMPARE(thirdTrack.isSingleDiscAlbum(), true);
811 822​
812 auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2")); 823​ auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2"));
813 auto album = musicDb.albumDataFromDatabaseId(albumId); 824​ auto album = musicDb.albumDataFromDatabaseId(albumId);
814 auto albumData = musicDb.albumData(albumId); 825​ auto albumData = musicDb.albumData(albumId);
815 826​
816 QCOMPARE(album.isValid(), true); 827​ QCOMPARE(album.isValid(), true);
817 QCOMPARE(albumData.count(), 3); 828​ QCOMPARE(albumData.count(), 3);
818 QCOMPARE(album.title(), QStringLiteral("album3")); 829​ QCOMPARE(album.title(), QStringLiteral("album3"));
819 QCOMPARE(album.isValidArtist(), false); 830​ QVERIFY(album.isValidArtist());
820 QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3"))); 831​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
821 QCOMPARE(album.isSingleDiscAlbum(), true); 832​ QCOMPARE(album.isSingleDiscAlbum(), true);
822 } 833​ }
823 834​
824 void addTwoTracksWithPartialAlbumArtist() 835​ void addTwoTracksWithPartialAlbumArtist()
825 { 836​ {
826 QTemporaryFile databaseFile; 837​ QTemporaryFile databaseFile;
827 databaseFile.open(); 838​ databaseFile.open();
▲ Show 20 Lines • Show All 45 Lines • ▼ Show 20 Line(s)
873 auto newCovers = mNewCovers; 884​ auto newCovers = mNewCovers;
874 newCovers[QStringLiteral("file:///$19")] = QUrl::fromLocalFile(QStringLiteral("album3")); 885​ newCovers[QStringLiteral("file:///$19")] = QUrl::fromLocalFile(QStringLiteral("album3"));
875 newCovers[QStringLiteral("file:///$20")] = QUrl::fromLocalFile(QStringLiteral("album3")); 886​ newCovers[QStringLiteral("file:///$20")] = QUrl::fromLocalFile(QStringLiteral("album3"));
876 887​
877 musicDb.insertTracksList(newTracks, newCovers); 888​ musicDb.insertTracksList(newTracks, newCovers);
878 889​
879 musicDbTrackAddedSpy.wait(300); 890​ musicDbTrackAddedSpy.wait(300);
880 891​
881 QCOMPARE(musicDb.allAlbumsData().count(), 1); 892​ QCOMPARE(musicDb.allAlbumsData().count(), 2);
882 QCOMPARE(musicDb.allArtistsData().count(), 3); 893​ QCOMPARE(musicDb.allArtistsData().count(), 3);
883 QCOMPARE(musicDb.allTracksData().count(), 2); 894​ QCOMPARE(musicDb.allTracksData().count(), 2);
884 QCOMPARE(musicDbArtistAddedSpy.count(), 1); 895​ QCOMPARE(musicDbArtistAddedSpy.count(), 1);
885 QCOMPARE(musicDbAlbumAddedSpy.count(), 1); 896​ QCOMPARE(musicDbAlbumAddedSpy.count(), 1);
886 QCOMPARE(musicDbTrackAddedSpy.count(), 1); 897​ QCOMPARE(musicDbTrackAddedSpy.count(), 1);
887 QCOMPARE(musicDbArtistRemovedSpy.count(), 0); 898​ QCOMPARE(musicDbArtistRemovedSpy.count(), 0);
888 QCOMPARE(musicDbAlbumRemovedSpy.count(), 0); 899​ QCOMPARE(musicDbAlbumRemovedSpy.count(), 0);
889 QCOMPARE(musicDbTrackRemovedSpy.count(), 0); 900​ QCOMPARE(musicDbTrackRemovedSpy.count(), 0);
890 QCOMPARE(musicDbAlbumModifiedSpy.count(), 0); 901​ QCOMPARE(musicDbAlbumModifiedSpy.count(), 0);
891 QCOMPARE(musicDbTrackModifiedSpy.count(), 0); 902​ QCOMPARE(musicDbTrackModifiedSpy.count(), 0);
892 QCOMPARE(musicDbDatabaseErrorSpy.count(), 0); 903​ QCOMPARE(musicDbDatabaseErrorSpy.count(), 0);
893 904​
894 auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"), 905​ auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"),
895 QStringLiteral("album3"), 6, 1)); 906​ QStringLiteral("album3"), 6, 1));
896 907​
897 QCOMPARE(firstTrack.isValid(), true); 908​ QCOMPARE(firstTrack.isValid(), true);
898 QCOMPARE(firstTrack.title(), QStringLiteral("track6")); 909​ QCOMPARE(firstTrack.title(), QStringLiteral("track6"));
899 QCOMPARE(firstTrack.artist(), QStringLiteral("artist2")); 910​ QCOMPARE(firstTrack.artist(), QStringLiteral("artist2"));
900 QCOMPARE(firstTrack.album(), QStringLiteral("album3")); 911​ QCOMPARE(firstTrack.album(), QStringLiteral("album3"));
901 QCOMPARE(firstTrack.albumArtist(), QStringLiteral("artist4")); 912​ QCOMPARE(firstTrack.albumArtist(), QStringLiteral("artist2"));
902 QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 913​ QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
903 QCOMPARE(firstTrack.trackNumber(), 6); 914​ QCOMPARE(firstTrack.trackNumber(), 6);
904 QCOMPARE(firstTrack.discNumber(), 1); 915​ QCOMPARE(firstTrack.discNumber(), 1);
905 QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19)); 916​ QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(19));
906 QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19"))); 917​ QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$19")));
907 QCOMPARE(firstTrack.rating(), 5); 918​ QCOMPARE(firstTrack.rating(), 5);
908 QCOMPARE(firstTrack.genre(), QStringLiteral("genre1")); 919​ QCOMPARE(firstTrack.genre(), QStringLiteral("genre1"));
909 QCOMPARE(firstTrack.composer(), QStringLiteral("composer1")); 920​ QCOMPARE(firstTrack.composer(), QStringLiteral("composer1"));
Show All 21 Lines
931 QCOMPARE(secondTrack.isSingleDiscAlbum(), true); 942​ QCOMPARE(secondTrack.isSingleDiscAlbum(), true);
932 QCOMPARE(secondTrack.hasEmbeddedCover(), false); 943​ QCOMPARE(secondTrack.hasEmbeddedCover(), false);
933 944​
934 auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist4")); 945​ auto albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist4"));
935 auto album = musicDb.albumDataFromDatabaseId(albumId); 946​ auto album = musicDb.albumDataFromDatabaseId(albumId);
936 auto albumData = musicDb.albumData(albumId); 947​ auto albumData = musicDb.albumData(albumId);
937 948​
938 QCOMPARE(album.isValid(), true); 949​ QCOMPARE(album.isValid(), true);
939 QCOMPARE(albumData.count(), 2); 950​ QCOMPARE(albumData.count(), 1);
940 QCOMPARE(album.title(), QStringLiteral("album3")); 951​ QCOMPARE(album.title(), QStringLiteral("album3"));
941 QCOMPARE(album.artist(), QStringLiteral("artist4")); 952​ QCOMPARE(album.artist(), QStringLiteral("artist4"));
942 QCOMPARE(album.isValidArtist(), true); 953​ QCOMPARE(album.isValidArtist(), true);
943 QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3"))); 954​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
944 QCOMPARE(album.isSingleDiscAlbum(), true); 955​ QCOMPARE(album.isSingleDiscAlbum(), true);
956​
957​ albumId = musicDb.albumIdFromTitleAndArtist(QStringLiteral("album3"), QStringLiteral("artist2"));
958​ album = musicDb.albumDataFromDatabaseId(albumId);
959​ albumData = musicDb.albumData(albumId);
960​
961​ QCOMPARE(album.isValid(), true);
962​ QCOMPARE(albumData.count(), 1);
963​ QCOMPARE(album.title(), QStringLiteral("album3"));
964​ QCOMPARE(album.artist(), QStringLiteral("artist2"));
965​ QCOMPARE(album.isValidArtist(), true);
966​ QCOMPARE(album.albumArtURI(), QUrl::fromLocalFile(QStringLiteral("album3")));
967​ QCOMPARE(album.isSingleDiscAlbum(), true);
945 } 968​ }
946 969​
947 void addMultipleTimeSameTracks() 970​ void addMultipleTimeSameTracks()
948 { 971​ {
949 QTemporaryFile databaseFile; 972​ QTemporaryFile databaseFile;
950 databaseFile.open(); 973​ databaseFile.open();
951 974​
952 qDebug() << "addMultipleTimeSameTracks" << databaseFile.fileName(); 975​ qDebug() << "addMultipleTimeSameTracks" << databaseFile.fileName();
▲ Show 20 Lines • Show All 2766 Lines • ▼ Show 20 Line(s)3681 {
3719 3742​
3720 auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"), 3743​ auto firstTrack = musicDb.trackDataFromDatabaseId(musicDb.trackIdFromTitleAlbumTrackDiscNumber(QStringLiteral("track6"), QStringLiteral("artist2"),
3721 QStringLiteral("album3"), 6, 1)); 3744​ QStringLiteral("album3"), 6, 1));
3722 3745​
3723 QCOMPARE(firstTrack.isValid(), true); 3746​ QCOMPARE(firstTrack.isValid(), true);
3724 QCOMPARE(firstTrack.title(), QStringLiteral("track6")); 3747​ QCOMPARE(firstTrack.title(), QStringLiteral("track6"));
3725 QCOMPARE(firstTrack.artist(), QStringLiteral("artist2")); 3748​ QCOMPARE(firstTrack.artist(), QStringLiteral("artist2"));
3726 QCOMPARE(firstTrack.album(), QStringLiteral("album3")); 3749​ QCOMPARE(firstTrack.album(), QStringLiteral("album3"));
3727 QVERIFY(firstTrack.albumArtist().isEmpty()); 3750​ QVERIFY(!firstTrack.albumArtist().isEmpty());
3728 QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3"))); 3751​ QCOMPARE(firstTrack.albumCover(), QUrl::fromLocalFile(QStringLiteral("album3")));
3729 QCOMPARE(firstTrack.trackNumber(), 6); 3752​ QCOMPARE(firstTrack.trackNumber(), 6);
3730 QCOMPARE(firstTrack.discNumber(), 1); 3753​ QCOMPARE(firstTrack.discNumber(), 1);
3731 QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(23)); 3754​ QCOMPARE(firstTrack.duration(), QTime::fromMSecsSinceStartOfDay(23));
3732 QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$23"))); 3755​ QCOMPARE(firstTrack.resourceURI(), QUrl::fromLocalFile(QStringLiteral("/$23")));
3733 QCOMPARE(firstTrack.rating(), 5); 3756​ QCOMPARE(firstTrack.rating(), 5);
3734 QCOMPARE(firstTrack.genre(), QStringLiteral("genre1")); 3757​ QCOMPARE(firstTrack.genre(), QStringLiteral("genre1"));
3735 QCOMPARE(firstTrack.composer(), QStringLiteral("composer1")); 3758​ QCOMPARE(firstTrack.composer(), QStringLiteral("composer1"));
▲ Show 20 Lines • Show All 237 Lines • ▼ Show 20 Line(s)3934 {
3973 newCovers[QStringLiteral("file:///album7/$21")] = QUrl::fromLocalFile(QStringLiteral("album7")); 3996​ newCovers[QStringLiteral("file:///album7/$21")] = QUrl::fromLocalFile(QStringLiteral("album7"));
3974 newCovers[QStringLiteral("file:///album8/$22")] = QUrl::fromLocalFile(QStringLiteral("album8")); 3997​ newCovers[QStringLiteral("file:///album8/$22")] = QUrl::fromLocalFile(QStringLiteral("album8"));
3975 newCovers[QStringLiteral("file:///album8/$23")] = QUrl::fromLocalFile(QStringLiteral("album8")); 3998​ newCovers[QStringLiteral("file:///album8/$23")] = QUrl::fromLocalFile(QStringLiteral("album8"));
3976 3999​
3977 musicDb.insertTracksList(newTracks, newCovers); 4000​ musicDb.insertTracksList(newTracks, newCovers);
3978 4001​
3979 musicDbTrackAddedSpy.wait(300); 4002​ musicDbTrackAddedSpy.wait(300);
3980 4003​
3981 QCOMPARE(musicDb.allAlbumsData().count(), 2); 4004​ QCOMPARE(musicDb.allAlbumsData().count(), 4);
3982 QCOMPARE(musicDb.allArtistsData().count(), 4); 4005​ QCOMPARE(musicDb.allArtistsData().count(), 4);
3983 QCOMPARE(musicDb.allTracksData().count(), 4); 4006​ QCOMPARE(musicDb.allTracksData().count(), 4);
3984 QCOMPARE(musicDbArtistAddedSpy.count(), 1); 4007​ QCOMPARE(musicDbArtistAddedSpy.count(), 1);
3985 QCOMPARE(musicDbAlbumAddedSpy.count(), 1); 4008​ QCOMPARE(musicDbAlbumAddedSpy.count(), 1);
3986 QCOMPARE(musicDbTrackAddedSpy.count(), 1); 4009​ QCOMPARE(musicDbTrackAddedSpy.count(), 1);
3987 QCOMPARE(musicDbArtistRemovedSpy.count(), 0); 4010​ QCOMPARE(musicDbArtistRemovedSpy.count(), 0);
3988 QCOMPARE(musicDbAlbumRemovedSpy.count(), 0); 4011​ QCOMPARE(musicDbAlbumRemovedSpy.count(), 0);
3989 QCOMPARE(musicDbTrackRemovedSpy.count(), 0); 4012​ QCOMPARE(musicDbTrackRemovedSpy.count(), 0);
3990 QCOMPARE(musicDbAlbumModifiedSpy.count(), 0); 4013​ QCOMPARE(musicDbAlbumModifiedSpy.count(), 0);
3991 QCOMPARE(musicDbTrackModifiedSpy.count(), 0); 4014​ QCOMPARE(musicDbTrackModifiedSpy.count(), 0);
3992 QCOMPARE(musicDbDatabaseErrorSpy.count(), 0); 4015​ QCOMPARE(musicDbDatabaseErrorSpy.count(), 0);
3993 4016​
3994 QCOMPARE(musicDb.allAlbumsData().size(), 2); 4017​ QCOMPARE(musicDb.allAlbumsData().size(), 4);
3995 QCOMPARE(musicDb.allArtistsData().size(), 4); 4018​ QCOMPARE(musicDb.allArtistsData().size(), 4);
3996 QCOMPARE(musicDb.allTracksData().size(), 4); 4019​ QCOMPARE(musicDb.allTracksData().size(), 4);
3997 4020​
3998 auto allAlbums = musicDb.allAlbumsData(); 4021​ auto allAlbums = musicDb.allAlbumsData();
3999 auto firstAlbum = allAlbums[0]; 4022​ auto firstAlbum = allAlbums[0];
4000 auto firstAlbumData = musicDb.albumData(firstAlbum.databaseId()); 4023​ auto firstAlbumData = musicDb.albumData(firstAlbum.databaseId());
4001 QCOMPARE(firstAlbumData.count(), 2); 4024​ QCOMPARE(firstAlbumData.count(), 1);
4002 auto secondAlbum = allAlbums[1]; 4025​ auto secondAlbum = allAlbums[1];
4003 auto secondAlbumData = musicDb.albumData(secondAlbum.databaseId()); 4026​ auto secondAlbumData = musicDb.albumData(secondAlbum.databaseId());
4004 QCOMPARE(secondAlbumData.count(), 2); 4027​ QCOMPARE(secondAlbumData.count(), 1);
4005 } 4028​ }
4006 4029​
4007 void addTowAlbumsWithDifferentPathsAndSameTracks() 4030​ void addTwoAlbumsWithDifferentPathsAndSameTracks()
4008 { 4031​ {
4009 QTemporaryFile databaseFile; 4032​ QTemporaryFile databaseFile;
4010 databaseFile.open(); 4033​ databaseFile.open();
4011 4034​
4012 qDebug() << "addTowAlbumsWithDifferentPathsAndSameName" << databaseFile.fileName(); 4035​ qDebug() << "addTowAlbumsWithDifferentPathsAndSameName" << databaseFile.fileName();
4013 4036​
4014 DatabaseInterface musicDb; 4037​ DatabaseInterface musicDb;
4015 4038​
▲ Show 20 Lines • Show All 68 Lines • ▼ Show 20 Line(s)
4084 newCovers[QStringLiteral("file:///album8/$20")] = QUrl::fromLocalFile(QStringLiteral("album8")); 4107​ newCovers[QStringLiteral("file:///album8/$20")] = QUrl::fromLocalFile(QStringLiteral("album8"));
4085 newCovers[QStringLiteral("file:///album8/$21")] = QUrl::fromLocalFile(QStringLiteral("album8")); 4108​ newCovers[QStringLiteral("file:///album8/$21")] = QUrl::fromLocalFile(QStringLiteral("album8"));
4086 newCovers[QStringLiteral("file:///album8/$22")] = QUrl::fromLocalFile(QStringLiteral("album8")); 4109​ newCovers[QStringLiteral("file:///album8/$22")] = QUrl::fromLocalFile(QStringLiteral("album8"));
4087 4110​
4088 musicDb.insertTracksList(newTracks, newCovers); 4111​ musicDb.insertTracksList(newTracks, newCovers);
4089 4112​
4090 musicDbTrackAddedSpy.wait(300); 4113​ musicDbTrackAddedSpy.wait(300);
4091 4114​
4092 QCOMPARE(musicDb.allAlbumsData().count(), 2); 4115​ QCOMPARE(musicDb.allAlbumsData().count(), 6);
4093 QCOMPARE(musicDb.allArtistsData().count(), 3); 4116​ QCOMPARE(musicDb.allArtistsData().count(), 3);
4094 QCOMPARE(musicDb.allTracksData().count(), 6); 4117​ QCOMPARE(musicDb.allTracksData().count(), 6);
4095 QCOMPARE(musicDbArtistAddedSpy.count(), 1); 4118​ QCOMPARE(musicDbArtistAddedSpy.count(), 1);
4096 QCOMPARE(musicDbAlbumAddedSpy.count(), 1); 4119​ QCOMPARE(musicDbAlbumAddedSpy.count(), 1);
4097 QCOMPARE(musicDbTrackAddedSpy.count(), 1); 4120​ QCOMPARE(musicDbTrackAddedSpy.count(), 1);
4098 QCOMPARE(musicDbArtistRemovedSpy.count(), 0); 4121​ QCOMPARE(musicDbArtistRemovedSpy.count(), 0);
4099 QCOMPARE(musicDbAlbumRemovedSpy.count(), 0); 4122​ QCOMPARE(musicDbAlbumRemovedSpy.count(), 0);
4100 QCOMPARE(musicDbTrackRemovedSpy.count(), 0); 4123​ QCOMPARE(musicDbTrackRemovedSpy.count(), 0);
4101 QCOMPARE(musicDbAlbumModifiedSpy.count(), 0); 4124​ QCOMPARE(musicDbAlbumModifiedSpy.count(), 0);
4102 QCOMPARE(musicDbTrackModifiedSpy.count(), 0); 4125​ QCOMPARE(musicDbTrackModifiedSpy.count(), 0);
4103 QCOMPARE(musicDbDatabaseErrorSpy.count(), 0); 4126​ QCOMPARE(musicDbDatabaseErrorSpy.count(), 0);
4104 4127​
4105 auto allAlbums = musicDb.allAlbumsData(); 4128​ auto allAlbums = musicDb.allAlbumsData();
4106 auto firstAlbum = allAlbums[0]; 4129​ auto firstAlbum = allAlbums[0];
4107 auto firstAlbumData = musicDb.albumData(firstAlbum.databaseId()); 4130​ auto firstAlbumData = musicDb.albumData(firstAlbum.databaseId());
4108 QCOMPARE(firstAlbumData.count(), 3); 4131​ QCOMPARE(firstAlbumData.count(), 1);
4109 auto secondAlbum = allAlbums[1]; 4132​ auto secondAlbum = allAlbums[1];
4110 auto secondAlbumData = musicDb.albumData(secondAlbum.databaseId()); 4133​ auto secondAlbumData = musicDb.albumData(secondAlbum.databaseId());
4111 QCOMPARE(secondAlbumData.count(), 3); 4134​ QCOMPARE(secondAlbumData.count(), 1);
4112 } 4135​ }
4113 4136​
4114 void addTwoTracksFromSameAlbumButDifferentDiscs() 4137​ void addTwoTracksFromSameAlbumButDifferentDiscs()
4115 { 4138​ {
4116 QTemporaryFile databaseFile; 4139​ QTemporaryFile databaseFile;
4117 databaseFile.open(); 4140​ databaseFile.open();
4118 4141​
4119 qDebug() << "addTwoTracksFromSameAlbumButDifferentDiscs" << databaseFile.fileName(); 4142​ qDebug() << "addTwoTracksFromSameAlbumButDifferentDiscs" << databaseFile.fileName();
▲ Show 20 Lines • Show All 709 Lines • Show Last 20 Lines