72 Commits

Author SHA1 Message Date
theguymadmax 5597d8e1a7 Checkpoint wal 2026-02-18 15:11:57 -05:00
theguymadmax 0166362258 Use BackupDatabase() instead of File.Move in library.db migration 2026-02-17 22:56:45 -05:00
David Federman 290463fe7b Fix migration UNIQUE constraint on BaseItemProviders
Deduplicate ProviderIds by ProviderId during MigrateLibraryDb migration
to prevent UNIQUE constraint violations when legacy data contains
duplicate provider entries for the same item.

Fixes #16134
2026-02-12 20:37:26 -08:00
theguymadmax 177b6464ca Don't clear baseitemids (#15446) 2025-11-09 09:22:09 -07:00
JPVenson 8ea9bece03 Add explicit reference check to migration 2025-09-28 08:46:31 +00:00
JPVenson e282b05b8f fixes #14859 Add Check for ItemValues (#14860) 2025-09-25 08:02:20 -06:00
JPVenson 740b9924a0 Include ListOrder on Import (#14854) 2025-09-24 15:22:05 -06:00
JPVenson 5a6d9180fe Add People Dedup and multiple progress fixes (#14848) 2025-09-24 15:20:30 -06:00
JPVenson 0949212993 Make migration handle parent cleanup (#14817)
* Make migration handle parent cleanup

* Remove speed improvement

* Update MigrateLibraryDb.cs
2025-09-19 13:17:31 -06:00
JPVenson eaf33f01e1 #14751 Only migrate providerids that match assumption (#14810) 2025-09-17 18:33:23 -06:00
Bond-009 8776a447d1 Various cleanups (#14785) 2025-09-12 13:58:23 -06:00
JPVenson a1eb04dc0b Add full migration for IsFolder flag 2025-07-30 19:58:56 +00:00
JPVenson 711e649e35 Also migrate IsFolder 2025-07-30 19:41:34 +00:00
JPVenson ba0eb87371 Add migration to migrate disconnected UserData too (#14339) 2025-06-23 08:36:49 -06:00
Shadowghost af0bcbc652 Fixup 2025-06-19 12:33:46 +02:00
Shadowghost ccb917b8df Cleanup logging and user data import skip on missing user 2025-06-18 21:33:32 +02:00
JPVenson 1e9e4ffda9 Rework startup topic handling and reenable output to logging framework (#14243) 2025-06-08 19:52:39 -06:00
JPVenson 88332e89c4 Feature/version check in library migration (#14105) 2025-06-05 08:59:11 -06:00
JPVenson d5672ce407 Add declarative backups for migrations (#14135) 2025-06-03 16:49:41 -06:00
JPVenson a7bb3ea214 Only consider migrations that have key set for migration.xml migration (#14061) 2025-05-05 17:23:23 -06:00
JPVenson e66c76fc34 Unified migration handling (#13950) 2025-04-27 18:18:08 -06:00
JPVenson 77ad7f6139 Fix the migration as the new constraint now uses Value as unique key (#13867) 2025-04-07 14:42:01 -06:00
Tim Eisele 596b635511 Cleanup extracted files (#13760)
* Cleanup extracted files

* Pagination and fixes

* Add migration for attachments to MigrateLibraryDb

* Unify attachment handling

* Don't extract again if files were already extracted

* Fix MKS attachment extraction

* Always run full extraction on mks

* Don't try to extract mjpeg streams as attachments

* Fallback to check if attachments were extracted to cache folder

* Fixup
2025-04-03 09:17:14 -06:00
JPVenson 90a6cca92b Library.db migration impovements (#13809)
* Fixes cleanup of wrong table in migration

* use dedicated context for each step

* Use prepared Context

* Fix measurement of UserData migration time

* Update logging and combine cleanup to its own stage

* fix people map not logging
migrate only readonly database

* Add id blacklisting in migration to avoid duplicated log entires
2025-03-30 21:36:27 -06:00
JPVenson d75216cf3a Fixes cleanup of wrong table in migration (#13796) 2025-03-29 10:00:19 -06:00
theguymadmax ae4b35da46 Include UnratedType in LibraryDb migration query (#13783) 2025-03-27 10:43:39 -06:00
JPVenson 9e4abb7319 Add override for migration if old library still exists (#13779) 2025-03-27 05:34:59 -06:00
JPVenson 296b17bf44 Feature/backup on migration (#13754)
* Added generalised backup for migrations

* Added backup strategy to MigrateLibraryDb

* Added missing namespace

* Fix merge issues

* Fixed style issue

* change fast backup key to timestamp

* Update src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/SqliteDatabaseProvider.cs

* Update Fields

* applied review comments
2025-03-26 20:23:36 -06:00
Cody Robibero d848faeb75 Merge pull request #13589 from JPVenson/feature/DatabaseRefactor
[Feature] Database code refactor
2025-03-25 21:34:26 -06:00
JPVenson 42bdb22bfb Fixed namespaces 2025-03-25 16:45:00 +01:00
JPVenson 160020c551 WIP fixed namespaces 2025-03-25 15:30:22 +00:00
JPVenson 850f1c79f1 Merge branch 'master' into feature/DatabaseRefactor 2025-03-25 15:12:48 +00:00
Niels van Velzen 8680170706 Merge pull request #13616 from Lampan-git/fix_people_role
Include PeopleBaseItemMap in GetPeople to inlcude Role and SortOrder
2025-03-24 15:29:28 +01:00
Fernando Fernández c77a0719c2 Clear dictionaries when not needed, use set for finding existing base items (#13749) 2025-03-22 18:30:32 -06:00
Lampan-git cf1f251f2a Preserve null sortOrder during migration 2025-03-14 21:07:34 +01:00
theguymadmax f1dd065eca Include CleanName in LibraryDb migration query 2025-03-10 11:50:28 -04:00
Roman Dordzheev 70b8fa73f0 Include SortName in LibraryDb migration query 2025-03-08 13:55:21 +03:00
JPVenson d8030147ff Merge remote-tracking branch 'jellyfinorigin/master' into feature/DatabaseRefactor 2025-02-19 18:25:00 +00:00
Cody Robibero debc499711 Change BaseItemEntity ChannelId to nullable Guid 2025-02-13 20:17:25 -07:00
JPVenson aa811eb1e3 Prepared Seperation of Database components for future multi provider support 2025-01-26 20:45:28 +00:00
luzpaz c877ffa5ad Fix various typos
Found via `codespell -q 3 -S "./Emby.Server.Implementations/Localization" -L inh,som`
2025-01-25 21:04:37 -05:00
JPVenson b33810534b Applied review comments 2025-01-15 20:12:41 +00:00
JPVenson 80cace4321 Updated usage of internal user Id 2024-11-23 22:39:39 +00:00
JPVenson 77bae62acc Added migration filtering 2024-11-15 16:24:38 +00:00
JPVenson 19e55f4309 Fixed migration referencing non-existing Items 2024-11-15 09:08:27 +00:00
JPVenson ffc18a2044 Updated comments/TODOs 2024-11-14 05:58:32 +00:00
JPVenson 7b81a39ee1 Fix Deduplication and Save of Items 2024-11-13 14:25:26 +00:00
JPVenson d073e2c664 Fixed invalid columns on MediaStreams 2024-11-12 23:53:05 +00:00
JPVenson 22515ad647 Fixed app paths not being expanded 2024-11-12 17:23:41 +00:00
JPVenson 85b8b2573b Fixed AncestorIds
Fixed Sorting, NextUp and Continue Watching
2024-11-12 15:37:01 +00:00