Changeset View
Changeset View
Standalone View
Standalone View
src/databaseinterface.h
Show First 20 Lines • Show All 362 Lines • ▼ Show 20 Line(s) | 343 | Q_SIGNALS: | |||
---|---|---|---|---|---|
363 | void albumModified(const DatabaseInterface::AlbumDataType &modifiedAlbum, qulonglong modifiedAlbumId); | 363 | void albumModified(const DatabaseInterface::AlbumDataType &modifiedAlbum, qulonglong modifiedAlbumId); | ||
364 | 364 | | |||
365 | void trackModified(const DatabaseInterface::TrackDataType &modifiedTrack); | 365 | void trackModified(const DatabaseInterface::TrackDataType &modifiedTrack); | ||
366 | 366 | | |||
367 | void requestsInitDone(); | 367 | void requestsInitDone(); | ||
368 | 368 | | |||
369 | void databaseError(); | 369 | void databaseError(); | ||
370 | 370 | | |||
371 | void restoredTracks(const QString &musicSource, QHash<QUrl, QDateTime> allFiles); | 371 | void restoredTracks(QHash<QUrl, QDateTime> allFiles); | ||
372 | 372 | | |||
373 | void cleanedDatabase(); | 373 | void cleanedDatabase(); | ||
374 | 374 | | |||
375 | void finishInsertingTracksList(); | ||||
376 | | ||||
377 | void finishRemovingTracksList(); | ||||
378 | | ||||
375 | public Q_SLOTS: | 379 | public Q_SLOTS: | ||
376 | 380 | | |||
377 | void insertTracksList(const QList<MusicAudioTrack> &tracks, const QHash<QString, QUrl> &covers, const QString &musicSource); | 381 | void insertTracksList(const QList<MusicAudioTrack> &tracks, const QHash<QString, QUrl> &covers); | ||
378 | 382 | | |||
379 | void removeTracksList(const QList<QUrl> &removedTracks); | 383 | void removeTracksList(const QList<QUrl> &removedTracks); | ||
380 | 384 | | |||
381 | void removeAllTracksFromSource(const QString &sourceName); | 385 | void askRestoredTracks(); | ||
382 | | ||||
383 | void askRestoredTracks(const QString &musicSource); | | |||
384 | 386 | | |||
385 | void trackHasStartedPlaying(const QUrl &fileName, const QDateTime &time); | 387 | void trackHasStartedPlaying(const QUrl &fileName, const QDateTime &time); | ||
386 | 388 | | |||
387 | void clearData(); | 389 | void clearData(); | ||
388 | 390 | | |||
389 | private: | 391 | private: | ||
390 | 392 | | |||
391 | enum class TrackFileInsertType { | 393 | enum class TrackFileInsertType { | ||
▲ Show 20 Lines • Show All 56 Lines • ▼ Show 20 Line(s) | |||||
448 | void removeArtistInDatabase(qulonglong artistId); | 450 | void removeArtistInDatabase(qulonglong artistId); | ||
449 | 451 | | |||
450 | void reloadExistingDatabase(); | 452 | void reloadExistingDatabase(); | ||
451 | 453 | | |||
452 | qulonglong initialId(DataUtils::DataType aType); | 454 | qulonglong initialId(DataUtils::DataType aType); | ||
453 | 455 | | |||
454 | qulonglong genericInitialId(QSqlQuery &request); | 456 | qulonglong genericInitialId(QSqlQuery &request); | ||
455 | 457 | | |||
456 | qulonglong insertMusicSource(const QString &name); | 458 | void insertTrackOrigin(const QUrl &fileNameURI, const QDateTime &fileModifiedTime, const QDateTime &importDate); | ||
457 | | ||||
458 | void insertTrackOrigin(const QUrl &fileNameURI, const QDateTime &fileModifiedTime, const QDateTime &importDate, qulonglong discoverId); | | |||
459 | 459 | | |||
460 | void updateTrackOrigin(const QUrl &fileName, const QDateTime &fileModifiedTime); | 460 | void updateTrackOrigin(const QUrl &fileName, const QDateTime &fileModifiedTime); | ||
461 | 461 | | |||
462 | int computeTrackPriority(const QString &title, const QString &trackArtist, const QString &album, const QString &albumArtist, const QString &trackPath); | 462 | int computeTrackPriority(const QString &title, const QString &trackArtist, const QString &album, const QString &albumArtist, const QString &trackPath); | ||
463 | 463 | | |||
464 | qulonglong internalInsertTrack(qulonglong discoverId, const MusicAudioTrack &oneModifiedTrack, | 464 | qulonglong internalInsertTrack(const MusicAudioTrack &oneModifiedTrack, | ||
465 | const QHash<QString, QUrl> &covers, bool &isInserted); | 465 | const QHash<QString, QUrl> &covers, bool &isInserted); | ||
466 | 466 | | |||
467 | MusicAudioTrack buildTrackFromDatabaseRecord(const QSqlRecord &trackRecord) const; | 467 | MusicAudioTrack buildTrackFromDatabaseRecord(const QSqlRecord &trackRecord) const; | ||
468 | 468 | | |||
469 | TrackDataType buildTrackDataFromDatabaseRecord(const QSqlRecord &trackRecord) const; | 469 | TrackDataType buildTrackDataFromDatabaseRecord(const QSqlRecord &trackRecord) const; | ||
470 | 470 | | |||
471 | void internalRemoveTracksList(const QList<QUrl> &removedTracks); | 471 | void internalRemoveTracksList(const QList<QUrl> &removedTracks); | ||
472 | 472 | | |||
473 | void internalRemoveTracksList(const QHash<QUrl, QDateTime> &removedTracks, qulonglong sourceId); | 473 | void internalRemoveTracksList(const QHash<QUrl, QDateTime> &removedTracks, qulonglong sourceId); | ||
474 | 474 | | |||
475 | QUrl internalAlbumArtUriFromAlbumId(qulonglong albumId); | 475 | QUrl internalAlbumArtUriFromAlbumId(qulonglong albumId); | ||
476 | 476 | | |||
477 | bool isValidArtist(qulonglong albumId); | 477 | bool isValidArtist(qulonglong albumId); | ||
478 | 478 | | |||
479 | qulonglong insertComposer(const QString &name); | 479 | qulonglong insertComposer(const QString &name); | ||
480 | 480 | | |||
481 | qulonglong insertLyricist(const QString &name); | 481 | qulonglong insertLyricist(const QString &name); | ||
482 | 482 | | |||
483 | qulonglong internalSourceIdFromName(const QString &sourceName); | 483 | QHash<QUrl, QDateTime> internalAllFileName(); | ||
484 | | ||||
485 | QHash<QUrl, QDateTime> internalAllFileNameFromSource(const QString &sourceName); | | |||
486 | 484 | | |||
487 | bool internalGenericPartialData(QSqlQuery &query); | 485 | bool internalGenericPartialData(QSqlQuery &query); | ||
488 | 486 | | |||
489 | ListArtistDataType internalAllArtistsPartialData(QSqlQuery &artistsQuery); | 487 | ListArtistDataType internalAllArtistsPartialData(QSqlQuery &artistsQuery); | ||
490 | 488 | | |||
491 | ArtistDataType internalOneArtistPartialData(qulonglong databaseId); | 489 | ArtistDataType internalOneArtistPartialData(qulonglong databaseId); | ||
492 | 490 | | |||
493 | ListAlbumDataType internalAllAlbumsPartialData(QSqlQuery &query); | 491 | ListAlbumDataType internalAllAlbumsPartialData(QSqlQuery &query); | ||
Show All 26 Lines | 517 | void updateAlbumArtist(qulonglong albumId, const QString &title, const QString &albumPath, | |||
520 | const QString &artistName); | 518 | const QString &artistName); | ||
521 | 519 | | |||
522 | void updateTrackStatistics(const QUrl &fileName, const QDateTime &time); | 520 | void updateTrackStatistics(const QUrl &fileName, const QDateTime &time); | ||
523 | 521 | | |||
524 | void createDatabaseV9(); | 522 | void createDatabaseV9(); | ||
525 | 523 | | |||
526 | void upgradeDatabaseV11(); | 524 | void upgradeDatabaseV11(); | ||
527 | 525 | | |||
526 | void upgradeDatabaseV12(); | ||||
527 | | ||||
528 | std::unique_ptr<DatabaseInterfacePrivate> d; | 528 | std::unique_ptr<DatabaseInterfacePrivate> d; | ||
529 | 529 | | |||
530 | }; | 530 | }; | ||
531 | 531 | | |||
532 | Q_DECLARE_METATYPE(DatabaseInterface::TrackDataType) | 532 | Q_DECLARE_METATYPE(DatabaseInterface::TrackDataType) | ||
533 | Q_DECLARE_METATYPE(DatabaseInterface::AlbumDataType) | 533 | Q_DECLARE_METATYPE(DatabaseInterface::AlbumDataType) | ||
534 | Q_DECLARE_METATYPE(DatabaseInterface::ArtistDataType) | 534 | Q_DECLARE_METATYPE(DatabaseInterface::ArtistDataType) | ||
535 | Q_DECLARE_METATYPE(DatabaseInterface::GenreDataType) | 535 | Q_DECLARE_METATYPE(DatabaseInterface::GenreDataType) | ||
536 | 536 | | |||
537 | Q_DECLARE_METATYPE(DatabaseInterface::ListTrackDataType) | 537 | Q_DECLARE_METATYPE(DatabaseInterface::ListTrackDataType) | ||
538 | Q_DECLARE_METATYPE(DatabaseInterface::ListAlbumDataType) | 538 | Q_DECLARE_METATYPE(DatabaseInterface::ListAlbumDataType) | ||
539 | Q_DECLARE_METATYPE(DatabaseInterface::ListArtistDataType) | 539 | Q_DECLARE_METATYPE(DatabaseInterface::ListArtistDataType) | ||
540 | Q_DECLARE_METATYPE(DatabaseInterface::ListGenreDataType) | 540 | Q_DECLARE_METATYPE(DatabaseInterface::ListGenreDataType) | ||
541 | 541 | | |||
542 | #endif // DATABASEINTERFACE_H | 542 | #endif // DATABASEINTERFACE_H |