Changeset View
Changeset View
Standalone View
Standalone View
src/databaseinterface.cpp
- This file is larger than 256 KB, so syntax highlighting is disabled by default.
Show First 20 Lines • Show All 3283 Lines • ▼ Show 20 Line(s) | 3235 | auto selectAllAlbumsText = QStringLiteral("SELECT " | |||
---|---|---|---|---|---|
3284 | "tracks.`AlbumPath` = album.`AlbumPath` AND " | 3284 | "tracks.`AlbumPath` = album.`AlbumPath` AND " | ||
3285 | "EXISTS (" | 3285 | "EXISTS (" | ||
3286 | " SELECT tracks2.`Genre` " | 3286 | " SELECT tracks2.`Genre` " | ||
3287 | " FROM " | 3287 | " FROM " | ||
3288 | " `Tracks` tracks2, " | 3288 | " `Tracks` tracks2, " | ||
3289 | " `Genre` genre2 " | 3289 | " `Genre` genre2 " | ||
3290 | " WHERE " | 3290 | " WHERE " | ||
3291 | " tracks2.`AlbumTitle` = album.`Title` AND " | 3291 | " tracks2.`AlbumTitle` = album.`Title` AND " | ||
3292 | " tracks2.`AlbumArtistName` = album.`ArtistName` AND " | 3292 | " (tracks2.`AlbumArtistName` = album.`ArtistName` OR " | ||
3293 | " (tracks2.`AlbumArtistName` IS NULL AND " | ||||
3294 | " album.`ArtistName` IS NULL" | ||||
3295 | " )" | ||||
3296 | " ) AND " | ||||
3293 | " tracks2.`Genre` = genre2.`Name` AND " | 3297 | " tracks2.`Genre` = genre2.`Name` AND " | ||
3294 | " genre2.`Name` = :genreFilter AND " | 3298 | " genre2.`Name` = :genreFilter AND " | ||
3295 | " (tracks2.`ArtistName` = :artistFilter OR tracks2.`AlbumArtistName` = :artistFilter) " | 3299 | " (tracks2.`ArtistName` = :artistFilter OR tracks2.`AlbumArtistName` = :artistFilter) " | ||
3296 | ") " | 3300 | ") " | ||
3297 | "GROUP BY album.`ID`, album.`Title`, album.`AlbumPath` " | 3301 | "GROUP BY album.`ID`, album.`Title`, album.`AlbumPath` " | ||
3298 | "ORDER BY album.`Title` COLLATE NOCASE"); | 3302 | "ORDER BY album.`Title` COLLATE NOCASE"); | ||
3299 | 3303 | | |||
3300 | auto result = prepareQuery(d->mSelectAllAlbumsShortWithGenreArtistFilterQuery, selectAllAlbumsText); | 3304 | auto result = prepareQuery(d->mSelectAllAlbumsShortWithGenreArtistFilterQuery, selectAllAlbumsText); | ||
▲ Show 20 Lines • Show All 4435 Lines • Show Last 20 Lines |