Differential D18679 Diff 53961 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 4311 Lines • ▼ Show 20 Line(s)4309 if (isModifiedTrack) {
4312 auto oldTrack = internalTrackFromDatabaseId(existingTrackId); 4312​ auto oldTrack = internalTrackFromDatabaseId(existingTrackId);
4313 oldAlbumId = oldTrack.albumId(); 4313​ oldAlbumId = oldTrack.albumId();
4314 4314​
4315 auto isSameTrack = true; 4315​ auto isSameTrack = true;
4316 isSameTrack = isSameTrack && (oldTrack.title() == oneTrack.title()); 4316​ isSameTrack = isSameTrack && (oldTrack.title() == oneTrack.title());
4317 isSameTrack = isSameTrack && (oldTrack.albumName() == oneTrack.albumName()); 4317​ isSameTrack = isSameTrack && (oldTrack.albumName() == oneTrack.albumName());
4318 isSameTrack = isSameTrack && (oldTrack.artist() == oneTrack.artist()); 4318​ isSameTrack = isSameTrack && (oldTrack.artist() == oneTrack.artist());
4319 isSameTrack = isSameTrack && (oldTrack.albumArtist() == oneTrack.albumArtist()); 4319​ isSameTrack = isSameTrack && (oldTrack.albumArtist() == oneTrack.albumArtist());
4320​ isSameTrack = isSameTrack && (oldTrack.trackNumberIsValid() == oneTrack.trackNumberIsValid());
4321​ if (isSameTrack && oldTrack.trackNumberIsValid()) {
4320 isSameTrack = isSameTrack && (oldTrack.trackNumber() == oneTrack.trackNumber()); 4322​ isSameTrack = isSameTrack && (oldTrack.trackNumber() == oneTrack.trackNumber());
4323​ }
4324​ isSameTrack = isSameTrack && (oldTrack.discNumberIsValid() == oneTrack.discNumberIsValid());
4325​ if (isSameTrack && oldTrack.discNumberIsValid()) {
4321 isSameTrack = isSameTrack && (oldTrack.discNumber() == oneTrack.discNumber()); 4326​ isSameTrack = isSameTrack && (oldTrack.discNumber() == oneTrack.discNumber());
4327​ }
4322 isSameTrack = isSameTrack && (oldTrack.duration() == oneTrack.duration()); 4328​ isSameTrack = isSameTrack && (oldTrack.duration() == oneTrack.duration());
4323 isSameTrack = isSameTrack && (oldTrack.rating() == oneTrack.rating()); 4329​ isSameTrack = isSameTrack && (oldTrack.rating() == oneTrack.rating());
4324 isSameTrack = isSameTrack && (oldTrack.resourceURI() == oneTrack.resourceURI()); 4330​ isSameTrack = isSameTrack && (oldTrack.resourceURI() == oneTrack.resourceURI());
4325 isSameTrack = isSameTrack && (oldTrack.genre() == oneTrack.genre()); 4331​ isSameTrack = isSameTrack && (oldTrack.genre() == oneTrack.genre());
4326 isSameTrack = isSameTrack && (oldTrack.composer() == oneTrack.composer()); 4332​ isSameTrack = isSameTrack && (oldTrack.composer() == oneTrack.composer());
4327 isSameTrack = isSameTrack && (oldTrack.lyricist() == oneTrack.lyricist()); 4333​ isSameTrack = isSameTrack && (oldTrack.lyricist() == oneTrack.lyricist());
4328 isSameTrack = isSameTrack && (oldTrack.comment() == oneTrack.comment()); 4334​ isSameTrack = isSameTrack && (oldTrack.comment() == oneTrack.comment());
4329 isSameTrack = isSameTrack && (oldTrack.year() == oneTrack.year()); 4335​ isSameTrack = isSameTrack && (oldTrack.year() == oneTrack.year());
4336​ isSameTrack = isSameTrack && (oldTrack.channelsIsValid() == oneTrack.channelsIsValid());
4337​ if (isSameTrack && oldTrack.channelsIsValid()) {
4330 isSameTrack = isSameTrack && (oldTrack.channels() == oneTrack.channels()); 4338​ isSameTrack = isSameTrack && (oldTrack.channels() == oneTrack.channels());
4339​ }
4340​ isSameTrack = isSameTrack && (oldTrack.bitRateIsValid() == oneTrack.bitRateIsValid());
4341​ if (isSameTrack && oldTrack.bitRateIsValid()) {
4331 isSameTrack = isSameTrack && (oldTrack.bitRate() == oneTrack.bitRate()); 4342​ isSameTrack = isSameTrack && (oldTrack.bitRate() == oneTrack.bitRate());
4343​ }
4344​ isSameTrack = isSameTrack && (oldTrack.sampleRateIsValid() == oneTrack.sampleRateIsValid());
4345​ if (isSameTrack && oldTrack.sampleRateIsValid()) {
4332 isSameTrack = isSameTrack && (oldTrack.sampleRate() == oneTrack.sampleRate()); 4346​ isSameTrack = isSameTrack && (oldTrack.sampleRate() == oneTrack.sampleRate());
4347​ }
4333 4348​
4334 if (isSameTrack) { 4349​ if (isSameTrack) {
4335 return resultId; 4350​ return resultId;
4336 } 4351​ }
4337 4352​
4338 auto newTrack = oneTrack; 4353​ auto newTrack = oneTrack;
4339 newTrack.setDatabaseId(resultId); 4354​ newTrack.setDatabaseId(resultId);
4340 updateTrackInDatabase(newTrack, trackPath); 4355​ updateTrackInDatabase(newTrack, trackPath);
▲ Show 20 Lines • Show All 139 Lines • ▼ Show 20 Line(s)4483{
4480 result.setArtist(trackRecord.value(3).toString()); 4495​ result.setArtist(trackRecord.value(3).toString());
4481 4496​
4482 if (trackRecord.value(4).isValid()) { 4497​ if (trackRecord.value(4).isValid()) {
4483 result.setAlbumArtist(trackRecord.value(4).toString()); 4498​ result.setAlbumArtist(trackRecord.value(4).toString());
4484 } 4499​ }
4485 4500​
4486 result.setResourceURI(trackRecord.value(5).toUrl()); 4501​ result.setResourceURI(trackRecord.value(5).toUrl());
4487 result.setFileModificationTime(trackRecord.value(6).toDateTime()); 4502​ result.setFileModificationTime(trackRecord.value(6).toDateTime());
4503​ if (trackRecord.value(7).isValid()) {
4488 result.setTrackNumber(trackRecord.value(7).toInt()); 4504​ result.setTrackNumber(trackRecord.value(7).toInt());
4505​ }
4506​ if (trackRecord.value(8).isValid()) {
4489 result.setDiscNumber(trackRecord.value(8).toInt()); 4507​ result.setDiscNumber(trackRecord.value(8).toInt());
4508​ }
4490 result.setDuration(QTime::fromMSecsSinceStartOfDay(trackRecord.value(9).toInt())); 4509​ result.setDuration(QTime::fromMSecsSinceStartOfDay(trackRecord.value(9).toInt()));
4491 result.setAlbumName(trackRecord.value(10).toString()); 4510​ result.setAlbumName(trackRecord.value(10).toString());
4492 result.setRating(trackRecord.value(11).toInt()); 4511​ result.setRating(trackRecord.value(11).toInt());
4493 result.setAlbumCover(trackRecord.value(12).toUrl()); 4512​ result.setAlbumCover(trackRecord.value(12).toUrl());
4494 result.setIsSingleDiscAlbum(trackRecord.value(13).toBool()); 4513​ result.setIsSingleDiscAlbum(trackRecord.value(13).toBool());
4495 result.setGenre(trackRecord.value(14).toString()); 4514​ result.setGenre(trackRecord.value(14).toString());
4496 result.setComposer(trackRecord.value(15).toString()); 4515​ result.setComposer(trackRecord.value(15).toString());
4497 result.setLyricist(trackRecord.value(16).toString()); 4516​ result.setLyricist(trackRecord.value(16).toString());
4498 result.setComment(trackRecord.value(17).toString()); 4517​ result.setComment(trackRecord.value(17).toString());
4499 result.setYear(trackRecord.value(18).toInt()); 4518​ result.setYear(trackRecord.value(18).toInt());
4500 result.setChannels(trackRecord.value(19).toInt()); 4519​ if (trackRecord.value(19).isValid()) {
4501 result.setBitRate(trackRecord.value(20).toInt()); 4520​ bool isValid;
4502 result.setSampleRate(trackRecord.value(21).toInt()); 4521​ auto value = trackRecord.value(19).toInt(&isValid);
4522​ if (isValid) {
4523​ result.setChannels(value);
4524​ }
4525​ }
4526​ if (trackRecord.value(20).isValid()) {
4527​ bool isValid;
4528​ auto value = trackRecord.value(20).toInt(&isValid);
4529​ if (isValid) {
4530​ result.setBitRate(value);
4531​ }
4532​ }
4533​ if (trackRecord.value(21).isValid()) {
4534​ bool isValid;
4535​ auto value = trackRecord.value(21).toInt(&isValid);
4536​ if (isValid) {
4537​ result.setSampleRate(value);
4538​ }
4539​ }
4503 result.setAlbumId(trackRecord.value(2).toULongLong()); 4540​ result.setAlbumId(trackRecord.value(2).toULongLong());
4504 result.setHasEmbeddedCover(trackRecord.value(22).toBool()); 4541​ result.setHasEmbeddedCover(trackRecord.value(22).toBool());
4505 4542​
4506 result.setValid(true); 4543​ result.setValid(true);
4507 4544​
4508 return result; 4545​ return result;
4509} 4546​}
4510 4547​
4511DatabaseInterface::TrackDataType DatabaseInterface::buildTrackDataFromDatabaseRecord(const QSqlRecord &trackRecord) const 4548​DatabaseInterface::TrackDataType DatabaseInterface::buildTrackDataFromDatabaseRecord(const QSqlRecord &trackRecord) const
4512{ 4549​{
4513 TrackDataType result; 4550​ TrackDataType result;
4514 4551​
4515 result[TrackDataType::key_type::DatabaseIdRole] = trackRecord.value(0); 4552​ result[TrackDataType::key_type::DatabaseIdRole] = trackRecord.value(0);
4516 result[TrackDataType::key_type::TitleRole] = trackRecord.value(1); 4553​ result[TrackDataType::key_type::TitleRole] = trackRecord.value(1);
4554​ if (!trackRecord.value(10).isNull()) {
4517 result[TrackDataType::key_type::AlbumRole] = trackRecord.value(10); 4555​ result[TrackDataType::key_type::AlbumRole] = trackRecord.value(10);
4518 result[TrackDataType::key_type::AlbumIdRole] = trackRecord.value(2); 4556​ result[TrackDataType::key_type::AlbumIdRole] = trackRecord.value(2);
4557​ }
4558​ if (!trackRecord.value(3).isNull()) {
4519 result[TrackDataType::key_type::ArtistRole] = trackRecord.value(3); 4559​ result[TrackDataType::key_type::ArtistRole] = trackRecord.value(3);
4560​ }
4561​ if (!trackRecord.value(4).isNull()) {
4520 result[TrackDataType::key_type::AlbumArtistRole] = trackRecord.value(4); 4562​ result[TrackDataType::key_type::AlbumArtistRole] = trackRecord.value(4);
4563​ }
4521 result[TrackDataType::key_type::ResourceRole] = trackRecord.value(5); 4564​ result[TrackDataType::key_type::ResourceRole] = trackRecord.value(5);
4565​ if (!trackRecord.value(7).isNull()) {
4522 result[TrackDataType::key_type::TrackNumberRole] = trackRecord.value(7); 4566​ result[TrackDataType::key_type::TrackNumberRole] = trackRecord.value(7);
4567​ }
4568​ if (!trackRecord.value(8).isNull()) {
4523 result[TrackDataType::key_type::DiscNumberRole] = trackRecord.value(8); 4569​ result[TrackDataType::key_type::DiscNumberRole] = trackRecord.value(8);
4570​ }
4524 result[TrackDataType::key_type::DurationRole] = QTime::fromMSecsSinceStartOfDay(trackRecord.value(9).toInt()); 4571​ result[TrackDataType::key_type::DurationRole] = QTime::fromMSecsSinceStartOfDay(trackRecord.value(9).toInt());
4525 result[TrackDataType::key_type::MilliSecondsDurationRole] = trackRecord.value(9).toInt(); 4572​ result[TrackDataType::key_type::MilliSecondsDurationRole] = trackRecord.value(9).toInt();
4526 result[TrackDataType::key_type::RatingRole] = trackRecord.value(11); 4573​ result[TrackDataType::key_type::RatingRole] = trackRecord.value(11);
4574​ if (!trackRecord.value(12).isNull()) {
4527 result[TrackDataType::key_type::ImageUrlRole] = QUrl(trackRecord.value(12).toString()); 4575​ result[TrackDataType::key_type::ImageUrlRole] = QUrl(trackRecord.value(12).toString());
4576​ }
4528 result[TrackDataType::key_type::IsSingleDiscAlbumRole] = trackRecord.value(13); 4577​ result[TrackDataType::key_type::IsSingleDiscAlbumRole] = trackRecord.value(13);
4578​ if (!trackRecord.value(14).isNull()) {
4529 result[TrackDataType::key_type::GenreRole] = trackRecord.value(14); 4579​ result[TrackDataType::key_type::GenreRole] = trackRecord.value(14);
4580​ }
4581​ if (!trackRecord.value(15).isNull()) {
4530 result[TrackDataType::key_type::ComposerRole] = trackRecord.value(15); 4582​ result[TrackDataType::key_type::ComposerRole] = trackRecord.value(15);
4583​ }
4584​ if (!trackRecord.value(16).isNull()) {
4531 result[TrackDataType::key_type::LyricistRole] = trackRecord.value(16); 4585​ result[TrackDataType::key_type::LyricistRole] = trackRecord.value(16);
4586​ }
4532 result[TrackDataType::key_type::HasEmbeddedCover] = trackRecord.value(22); 4587​ result[TrackDataType::key_type::HasEmbeddedCover] = trackRecord.value(22);
4533 result[TrackDataType::key_type::FileModificationTime] = trackRecord.value(6); 4588​ result[TrackDataType::key_type::FileModificationTime] = trackRecord.value(6);
4589​ if (!trackRecord.value(24).isNull()) {
4534 result[TrackDataType::key_type::FirstPlayDate] = trackRecord.value(24); 4590​ result[TrackDataType::key_type::FirstPlayDate] = trackRecord.value(24);
4591​ }
4592​ if (!trackRecord.value(25).isNull()) {
4535 result[TrackDataType::key_type::LastPlayDate] = trackRecord.value(25); 4593​ result[TrackDataType::key_type::LastPlayDate] = trackRecord.value(25);
4594​ }
4536 result[TrackDataType::key_type::PlayCounter] = trackRecord.value(26); 4595​ result[TrackDataType::key_type::PlayCounter] = trackRecord.value(26);
4537 result[TrackDataType::key_type::PlayFrequency] = trackRecord.value(27); 4596​ result[TrackDataType::key_type::PlayFrequency] = trackRecord.value(27);
4538 result[DataType::key_type::ElementTypeRole] = ElisaUtils::Track; 4597​ result[DataType::key_type::ElementTypeRole] = ElisaUtils::Track;
4539 4598​
4540 return result; 4599​ return result;
4541} 4600​}
4542 4601​
4543void DatabaseInterface::internalRemoveTracksList(const QList<QUrl> &removedTracks) 4602​void DatabaseInterface::internalRemoveTracksList(const QList<QUrl> &removedTracks)
▲ Show 20 Lines • Show All 353 Lines • ▼ Show 20 Line(s)4951{
4897 d->mUpdateTrackQuery.bindValue(QStringLiteral(":artistName"), oneTrack.artist()); 4956​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":artistName"), oneTrack.artist());
4898 d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumTitle"), oneTrack.albumName()); 4957​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumTitle"), oneTrack.albumName());
4899 if (oneTrack.isValidAlbumArtist()) { 4958​ if (oneTrack.isValidAlbumArtist()) {
4900 d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumArtistName"), oneTrack.albumArtist()); 4959​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumArtistName"), oneTrack.albumArtist());
4901 } else { 4960​ } else {
4902 d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumArtistName"), {}); 4961​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumArtistName"), {});
4903 } 4962​ }
4904 d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumPath"), albumPath); 4963​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":albumPath"), albumPath);
4964​ if (oneTrack.trackNumberIsValid()) {
4905 d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackNumber"), oneTrack.trackNumber()); 4965​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackNumber"), oneTrack.trackNumber());
4966​ } else {
4967​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackNumber"), {});
4968​ }
4969​ if (oneTrack.discNumberIsValid()) {
4906 d->mUpdateTrackQuery.bindValue(QStringLiteral(":discNumber"), oneTrack.discNumber()); 4970​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":discNumber"), oneTrack.discNumber());
4971​ } else {
4972​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":discNumber"), {});
4973​ }
4907 d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackDuration"), QVariant::fromValue<qlonglong>(oneTrack.duration().msecsSinceStartOfDay())); 4974​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackDuration"), QVariant::fromValue<qlonglong>(oneTrack.duration().msecsSinceStartOfDay()));
4908 d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackRating"), oneTrack.rating()); 4975​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":trackRating"), oneTrack.rating());
4909 if (insertGenre(oneTrack.genre()) != 0) { 4976​ if (insertGenre(oneTrack.genre()) != 0) {
4910 d->mUpdateTrackQuery.bindValue(QStringLiteral(":genre"), oneTrack.genre()); 4977​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":genre"), oneTrack.genre());
4911 } else { 4978​ } else {
4912 d->mUpdateTrackQuery.bindValue(QStringLiteral(":genre"), {}); 4979​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":genre"), {});
4913 } 4980​ }
4914 if (insertComposer(oneTrack.composer()) != 0) { 4981​ if (insertComposer(oneTrack.composer()) != 0) {
4915 d->mUpdateTrackQuery.bindValue(QStringLiteral(":composer"), oneTrack.composer()); 4982​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":composer"), oneTrack.composer());
4916 } else { 4983​ } else {
4917 d->mUpdateTrackQuery.bindValue(QStringLiteral(":composer"), {}); 4984​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":composer"), {});
4918 } 4985​ }
4919 if (insertLyricist(oneTrack.lyricist()) != 0) { 4986​ if (insertLyricist(oneTrack.lyricist()) != 0) {
4920 d->mUpdateTrackQuery.bindValue(QStringLiteral(":lyricist"), oneTrack.lyricist()); 4987​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":lyricist"), oneTrack.lyricist());
4921 } else { 4988​ } else {
4922 d->mUpdateTrackQuery.bindValue(QStringLiteral(":lyricist"), {}); 4989​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":lyricist"), {});
4923 } 4990​ }
4924 d->mUpdateTrackQuery.bindValue(QStringLiteral(":comment"), oneTrack.comment()); 4991​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":comment"), oneTrack.comment());
4925 d->mUpdateTrackQuery.bindValue(QStringLiteral(":year"), oneTrack.year()); 4992​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":year"), oneTrack.year());
4993​ if (oneTrack.channelsIsValid()) {
4926 d->mUpdateTrackQuery.bindValue(QStringLiteral(":channels"), oneTrack.channels()); 4994​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":channels"), oneTrack.channels());
4995​ } else {
4996​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":channels"), {});
4997​ }
4998​ if (oneTrack.bitRateIsValid()) {
4927 d->mUpdateTrackQuery.bindValue(QStringLiteral(":bitRate"), oneTrack.bitRate()); 4999​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":bitRate"), oneTrack.bitRate());
5000​ } else {
5001​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":bitRate"), {});
5002​ }
5003​ if (oneTrack.sampleRateIsValid()) {
4928 d->mUpdateTrackQuery.bindValue(QStringLiteral(":sampleRate"), oneTrack.sampleRate()); 5004​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":sampleRate"), oneTrack.sampleRate());
5005​ } else {
5006​ d->mUpdateTrackQuery.bindValue(QStringLiteral(":sampleRate"), {});
5007​ }
4929 5008​
4930 auto result = d->mUpdateTrackQuery.exec(); 5009​ auto result = d->mUpdateTrackQuery.exec();
4931 5010​
4932 if (!result || !d->mUpdateTrackQuery.isActive()) { 5011​ if (!result || !d->mUpdateTrackQuery.isActive()) {
4933 Q_EMIT databaseError(); 5012​ Q_EMIT databaseError();
4934 5013​
4935 qDebug() << "DatabaseInterface::updateTrackInDatabase" << d->mUpdateTrackQuery.lastQuery(); 5014​ qDebug() << "DatabaseInterface::updateTrackInDatabase" << d->mUpdateTrackQuery.lastQuery();
4936 qDebug() << "DatabaseInterface::updateTrackInDatabase" << d->mUpdateTrackQuery.boundValues(); 5015​ qDebug() << "DatabaseInterface::updateTrackInDatabase" << d->mUpdateTrackQuery.boundValues();
▲ Show 20 Lines • Show All 904 Lines • Show Last 20 Lines