Differential D12889 Diff 34835 src/databaseinterface.cpp

Changeset View

Standalone View

View Options

src/databaseinterface.cpp

Show First 20 Lines • Show All 1602 Lines • ▼ Show 20 Line(s)1576 auto selectTrackQueryText = QStringLiteral("SELECT "
1603 "LEFT JOIN `Artists` artistAlbum ON artistAlbum.`ID` = artistAlbumMapping.`ArtistID` " 1603​ "LEFT JOIN `Artists` artistAlbum ON artistAlbum.`ID` = artistAlbumMapping.`ArtistID` "
1604 "LEFT JOIN `Composer` trackComposer ON trackComposer.`ID` = tracks.`ComposerID` " 1604​ "LEFT JOIN `Composer` trackComposer ON trackComposer.`ID` = tracks.`ComposerID` "
1605 "LEFT JOIN `Lyricist` trackLyricist ON trackLyricist.`ID` = tracks.`LyricistID` " 1605​ "LEFT JOIN `Lyricist` trackLyricist ON trackLyricist.`ID` = tracks.`LyricistID` "
1606 "LEFT JOIN `Genre` trackGenre ON trackGenre.`ID` = tracks.`GenreID` " 1606​ "LEFT JOIN `Genre` trackGenre ON trackGenre.`ID` = tracks.`GenreID` "
1607 "WHERE " 1607​ "WHERE "
1608 "tracks.`ID` = trackArtist.`TrackID` AND " 1608​ "tracks.`ID` = trackArtist.`TrackID` AND "
1609 "artist.`ID` = trackArtist.`ArtistID` AND " 1609​ "artist.`ID` = trackArtist.`ArtistID` AND "
1610 "tracksMapping.`TrackID` = tracks.`ID` AND " 1610​ "tracksMapping.`TrackID` = tracks.`ID` AND "
1611 "tracks.`AlbumID` = :albumId AND " 1611​ "tracks.`AlbumID` = album.`ID` AND "
1612 "album.`ID` = :albumId AND " 1612​ "album.`ID` = :albumId AND "
1613 "tracksMapping.`Priority` = (SELECT MIN(`Priority`) FROM `TracksMapping` WHERE `TrackID` = tracks.`ID`) " 1613​ "tracksMapping.`Priority` = (SELECT MIN(`Priority`) FROM `TracksMapping` WHERE `TrackID` = tracks.`ID`) "
1614 "ORDER BY tracks.`DiscNumber` ASC, " 1614​ "ORDER BY tracks.`DiscNumber` ASC, "
1615 "tracks.`TrackNumber` ASC"); 1615​ "tracks.`TrackNumber` ASC");
1616 1616​
1617 auto result = d->mSelectTrackQuery.prepare(selectTrackQueryText); 1617​ auto result = d->mSelectTrackQuery.prepare(selectTrackQueryText);
1618 1618​
1619 if (!result) { 1619​ if (!result) {
▲ Show 20 Lines • Show All 533 Lines • ▼ Show 20 Line(s)2152 if (!result) {
2153 qDebug() << "DatabaseInterface::initRequest" << d->mSelectAlbumTrackCountQuery.lastQuery(); 2153​ qDebug() << "DatabaseInterface::initRequest" << d->mSelectAlbumTrackCountQuery.lastQuery();
2154 qDebug() << "DatabaseInterface::initRequest" << d->mSelectAlbumTrackCountQuery.lastError(); 2154​ qDebug() << "DatabaseInterface::initRequest" << d->mSelectAlbumTrackCountQuery.lastError();
2155 2155​
2156 Q_EMIT databaseError(); 2156​ Q_EMIT databaseError();
2157 } 2157​ }
2158 } 2158​ }
2159 { 2159​ {
2160 auto updateAlbumQueryText = QStringLiteral("UPDATE `Albums` " 2160​ auto updateAlbumQueryText = QStringLiteral("UPDATE `Albums` "
2161 "SET `TracksCount` = (SELECT COUNT(*) FROM `Tracks` WHERE `AlbumID` = :albumId) " 2161​ "SET `TracksCount` = (SELECT COUNT(*) FROM `Tracks` WHERE `AlbumID` = `Albums`.`ID`) "
2162 "WHERE " 2162​ "WHERE "
2163 "`ID` = :albumId"); 2163​ "`ID` = :albumId");
2164 2164​
2165 auto result = d->mUpdateAlbumQuery.prepare(updateAlbumQueryText); 2165​ auto result = d->mUpdateAlbumQuery.prepare(updateAlbumQueryText);
2166 2166​
2167 if (!result) { 2167​ if (!result) {
2168 qDebug() << "DatabaseInterface::initRequest" << d->mUpdateAlbumQuery.lastQuery(); 2168​ qDebug() << "DatabaseInterface::initRequest" << d->mUpdateAlbumQuery.lastQuery();
2169 qDebug() << "DatabaseInterface::initRequest" << d->mUpdateAlbumQuery.lastError(); 2169​ qDebug() << "DatabaseInterface::initRequest" << d->mUpdateAlbumQuery.lastError();
▲ Show 20 Lines • Show All 2077 Lines • Show Last 20 Lines