Differential D23280 Diff 65698 src/databaseinterface.cpp

Changeset View

Standalone View

View Options

src/databaseinterface.cpp

  • This file is larger than 256 KB, so syntax highlighting is disabled by default.
Show First 20 Lines • Show All 6379 Lines • ▼ Show 20 Line(s)6328{
6380 if (!trackRecord.value(26).isNull()) { 6380​ if (!trackRecord.value(26).isNull()) {
6381 result[TrackDataType::key_type::FirstPlayDate] = trackRecord.value(26); 6381​ result[TrackDataType::key_type::FirstPlayDate] = trackRecord.value(26);
6382 } 6382​ }
6383 if (!trackRecord.value(27).isNull()) { 6383​ if (!trackRecord.value(27).isNull()) {
6384 result[TrackDataType::key_type::LastPlayDate] = trackRecord.value(27); 6384​ result[TrackDataType::key_type::LastPlayDate] = trackRecord.value(27);
6385 } 6385​ }
6386 result[TrackDataType::key_type::PlayCounter] = trackRecord.value(28); 6386​ result[TrackDataType::key_type::PlayCounter] = trackRecord.value(28);
6387 result[TrackDataType::key_type::PlayFrequency] = trackRecord.value(29); 6387​ result[TrackDataType::key_type::PlayFrequency] = trackRecord.value(29);
6388 result[DataType::key_type::ElementTypeRole] = ElisaUtils::Track; 6388​ result[TrackDataType::key_type::ElementTypeRole] = ElisaUtils::Track;
6389 6389​
6390 return result; 6390​ return result;
6391} 6391​}
6392 6392​
6393DatabaseInterface::TrackDataType DatabaseInterface::buildRadioDataFromDatabaseRecord(const QSqlRecord &trackRecord) const 6393​DatabaseInterface::TrackDataType DatabaseInterface::buildRadioDataFromDatabaseRecord(const QSqlRecord &trackRecord) const
6394{ 6394​{
6395 TrackDataType result; 6395​ TrackDataType result;
6396 6396​
6397 result[TrackDataType::key_type::DatabaseIdRole] = trackRecord.value(0); 6397​ result[TrackDataType::key_type::DatabaseIdRole] = trackRecord.value(0);
6398 result[TrackDataType::key_type::TitleRole] = trackRecord.value(1); 6398​ result[TrackDataType::key_type::TitleRole] = trackRecord.value(1);
6399 6399​
6400 result[TrackDataType::key_type::AlbumRole] = QStringLiteral("Radios"); 6400​ result[TrackDataType::key_type::AlbumRole] = QStringLiteral("Radios");
6401 result[TrackDataType::key_type::ArtistRole] = trackRecord.value(1); 6401​ result[TrackDataType::key_type::ArtistRole] = trackRecord.value(1);
6402 6402​
6403 result[TrackDataType::key_type::ResourceRole] = trackRecord.value(2); 6403​ result[TrackDataType::key_type::ResourceRole] = trackRecord.value(2);
6404 result[TrackDataType::key_type::RatingRole] = trackRecord.value(3); 6404​ result[TrackDataType::key_type::RatingRole] = trackRecord.value(3);
6405 if (!trackRecord.value(4).isNull()) { 6405​ if (!trackRecord.value(4).isNull()) {
6406 result[TrackDataType::key_type::GenreRole] = trackRecord.value(4); 6406​ result[TrackDataType::key_type::GenreRole] = trackRecord.value(4);
6407 } 6407​ }
6408 result[TrackDataType::key_type::CommentRole] = trackRecord.value(5); 6408​ result[TrackDataType::key_type::CommentRole] = trackRecord.value(5);
6409 result[DataType::key_type::ElementTypeRole] = ElisaUtils::Radio; 6409​ result[TrackDataType::key_type::ElementTypeRole] = ElisaUtils::Radio;
6410 6410​
6411 return result; 6411​ return result;
6412} 6412​}
6413 6413​
6414void DatabaseInterface::internalRemoveTracksList(const QList<QUrl> &removedTracks) 6414​void DatabaseInterface::internalRemoveTracksList(const QList<QUrl> &removedTracks)
6415{ 6415​{
6416 QSet<qulonglong> modifiedAlbums; 6416​ QSet<qulonglong> modifiedAlbums;
6417 6417​
▲ Show 20 Lines • Show All 397 Lines • ▼ Show 20 Line(s)6802{
6815 auto result = execQuery(query); 6815​ auto result = execQuery(query);
6816 6816​
6817 if (!result || !query.isActive()) { 6817​ if (!result || !query.isActive()) {
6818 Q_EMIT databaseError(); 6818​ Q_EMIT databaseError();
6819 6819​
6820 qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.lastQuery(); 6820​ qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.lastQuery();
6821 qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.boundValues(); 6821​ qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.boundValues();
6822 qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.lastError(); 6822​ qCDebug(orgKdeElisaDatabase) << "DatabaseInterface::updateTrackInDatabase" << query.lastError();
6823 }else{ 6823​ } else {
6824 TrackDataType radio(oneTrack); 6824​ if (oneTrack[TrackDataType::key_type::DatabaseIdRole] == -1) {
6825 radio[TrackDataType::key_type::ArtistRole] = radio[TrackDataType::key_type::TitleRole]; 6825​ auto radio = internalOneRadioPartialData(internalRadioIdFromHttpAddress(oneTrack.resourceURI().toString()));
6826 if (radio[TrackDataType::key_type::DatabaseIdRole] == -1) { ​
6827 radio[TrackDataType::key_type::DatabaseIdRole] = internalRadioIdFromHttpAddress(oneTrack.resourceURI().toString()); ​
6828 radio[TrackDataType::key_type::AlbumRole] = QStringLiteral("Radios"); ​
6829 radio[TrackDataType::key_type::ArtistRole] = radio[TrackDataType::key_type::TitleRole]; ​
6830 radio[DataType::key_type::ElementTypeRole] = ElisaUtils::Radio; ​
6831 // Genre and rating missing for now, see buildRadioDataFromDatabaseRecord. Should be added if used for radios. ​
6832 6826​
6833 Q_EMIT radioAdded(radio); 6827​ Q_EMIT radioAdded(radio);
6834 } else { 6828​ } else {
6829​ auto radio = internalOneRadioPartialData(oneTrack.databaseId());
6830​
6835 Q_EMIT radioModified(radio); 6831​ Q_EMIT radioModified(radio);
6836 } 6832​ }
6837 } 6833​ }
6838 6834​
6839 query.finish(); 6835​ query.finish();
6840} 6836​}
6841 6837​
6842void DatabaseInterface::removeRadio(qulonglong radioId) 6838​void DatabaseInterface::removeRadio(qulonglong radioId)
▲ Show 20 Lines • Show All 895 Lines • Show Last 20 Lines