mikiher
40504da4d7
Improve book library page query performance for author sort order ( #4080 )
...
* Add migration to create authorNames* columns, in libraryItems including update triggers and indices
* Add authorNames columns and indices to LibraryItem model
* Add database triggers for updating author names in libraryItems (for new databases)
* Populate authorNames during book scanning
* Update book sorting to use new authorNames columns
* Add an index on podcastEpisodes.publishedAt
* Fix group_concat order by and update to sqlite 3.44.2
---------
Co-authored-by: advplyr <advplyr@protonmail.com>
2025-03-17 17:09:49 -05:00
advplyr
804dafdfcb
Add test for parseOpfMetadata OPF v3 author
2025-03-14 17:32:32 -05:00
Nicholas Wallace
0a00ebcde1
Fix: flaky 2.15.0 migration test
2025-02-26 21:40:56 -07:00
advplyr
20f812403f
Add fileUtils recurseFiles and shouldIgnoreFile tests
2025-02-23 16:53:11 -06:00
mikiher
568bf0254d
Change migration version to v2.19.4
2025-02-18 07:57:46 +02:00
mikiher
23a750214f
Add migration in preparation for podcast query optimization
2025-02-16 08:35:51 +02:00
mikiher
8ee5646d79
fix stringifySequelizeQuery and add tests
2025-02-15 23:57:27 +02:00
advplyr
9e54b4f7ca
Merge pull request #3952 from mikiher/query-performance
...
Improve book library page query performance on title, titleIgnorePrefix, and addedAt sort orders.
2025-02-11 15:41:59 -06:00
advplyr
0ccb88904a
fix v2.15.0 migration test
2025-02-09 17:40:29 -06:00
mikiher
a13143245b
Improve page load queries on title, titleIgnorePrefix, and addedAt sort order
2025-02-08 12:29:23 +02:00
advplyr
5e5a604d03
Fix name parser to not use "last, first" format when not using comma separators. Adds unit tests #3940
2025-02-05 17:25:31 -06:00
advplyr
ac159bea72
Update unit test stub function
2025-01-05 12:12:20 -06:00
advplyr
5cd14108f9
Remove req.oldLibraryItem usage
2025-01-02 15:54:10 -06:00
advplyr
eb853d9f09
Fix LibraryItemController unit test
2025-01-02 15:51:21 -06:00
Greg Lorenzen
4cdc2a8c28
Feat/download via share link ( #3666 )
...
* Adds share download endpoint
* Adds Downloadable toggle to share modal
---------
Co-authored-by: advplyr <advplyr@protonmail.com>
2024-12-29 16:52:57 -06:00
advplyr
302b651e7b
Fix library item unit test
2024-12-15 12:38:50 -06:00
mikiher
9b8e059efe
Remove serverAddress from Feeds and FeedEpisodes URLs
2024-12-07 19:27:37 +02:00
advplyr
5fa0897ad7
Merge pull request #3665 from mikiher/subdirectory-fixes-3
...
Subdirectory support for OIDC and SocketIO
2024-12-03 17:29:57 -06:00
advplyr
0f1b64b883
Add test for grouping book library items
2024-12-03 17:21:57 -06:00
advplyr
33aa4f1952
Merge master
2024-12-01 13:27:20 -06:00
advplyr
2b5484243b
Add LibraryItemController test for delete/batchDelete/updateMedia endpoint functions to correctly remove authors & series with no books
2024-12-01 12:44:21 -06:00
advplyr
4b52f31d58
Update v2.17.3 migration file to first check if constraints need to be updated, add unit test
2024-11-30 15:48:20 -06:00
mikiher
9917f2d358
Change migration to v2.17.4
2024-11-29 09:01:03 +02:00
mikiher
6d8720b404
Subfolder support for OIDC auth
2024-11-29 04:28:50 +02:00
mikiher
50797879d5
Add a REINDEX NOCASE v2.15.1 migration and update v2.15.0 migration ( #3533 )
...
* Add REINDEX NOCASE migration and update v2.15.0 migration
* Update v2.15.0 migration test
* Fix typo
2024-10-18 16:10:29 -05:00
advplyr
e58d7db03b
Merge pull request #3417 from nichwall/series_cleanup_2
...
Add: series migration to be unique
2024-10-12 15:48:04 -05:00
Nicholas Wallace
e6e494a92c
Rename for next minor release
2024-10-07 18:52:14 -07:00
mikiher
501dc938e6
Add Nunicode sqlite extension integration
2024-09-29 09:22:39 +03:00
advplyr
5154e31c1c
Update migration to v2.14.0
2024-09-24 17:06:00 -05:00
advplyr
c67b5e950e
Update MigrationManager.test.js - moved migrations ensureDir to init()
2024-09-24 16:54:13 -05:00
Nicholas Wallace
8b95dd65d9
Fix: test cases checking the wrong bookSeriesId
2024-09-14 15:43:10 -07:00
Nicholas Wallace
691ed88096
Add more logging, clean up typo
2024-09-14 15:34:38 -07:00
Nicholas Wallace
999ada03d1
Fix: missing variables
2024-09-14 14:36:47 -07:00
Nicholas Wallace
fa451f362b
Add: tests for one book in duplicate series
2024-09-14 12:11:31 -07:00
Nicholas Wallace
868659a2f1
Add: unique constraint on bookseries table
2024-09-14 11:44:19 -07:00
advplyr
8ae62da138
Update migration unit test name
2024-09-14 10:40:01 -05:00
advplyr
bedba39af9
Merge branch 'master' into series_cleanup_2
2024-09-14 10:11:16 -05:00
mikiher
55164803b0
Fix migrationMeta database version initial value, and move isDatabaseNew logic inside MigrationManager
2024-09-14 08:01:32 +03:00
Nicholas Wallace
2711b989e1
Add: series migration to be unique
2024-09-13 16:55:48 -07:00
advplyr
703477b157
Merge pull request #3405 from mikiher/logger-fixes
...
Log non-strings into log file like console.log does
2024-09-11 14:31:05 -05:00
mikiher
220f7ef7cd
Resolve some weird unrelated flakiness in BookFinder test
2024-09-11 21:40:31 +03:00
mikiher
682a99dd43
Log non-strings into log file like console.log does
2024-09-11 19:58:30 +03:00
advplyr
7cbf9de8ca
Update migrations jsdocs
2024-09-10 15:57:07 -05:00
mikiher
6fb1202c1c
Put umzug in server/libs and remove unneeded dependencies from it
2024-09-08 21:33:32 +03:00
mikiher
8a28029809
Make migration management more robust
2024-09-07 22:24:19 +03:00
mikiher
3f93b93d9e
Add db migration management infratructure
2024-09-04 12:48:10 +03:00
advplyr
2472b86284
Update:Express middleware sets req.user to new data model, openid permissions functions moved to new data model
2024-08-11 16:07:29 -05:00
advplyr
29a15858f4
Update ApiCacheManager unit test for userNew
2024-08-11 15:19:28 -05:00
advplyr
2c8ebd43cc
Update ApiCacheManager unit test
2024-08-06 17:26:36 -05:00
mikiher
294490f814
Fix permission issues in embed/merge
2024-07-29 20:19:58 +03:00
