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
Gabriel Gavrilov
394bf8cb70
Allow number types for payload metadata when updating books. ( #4118 )
...
* Allow number types for payload metadata
* cast numbers to string
2025-03-16 08:42:18 -05:00
Vito0912
953f21ed53
fix updating progress not updating finishedAt
2025-03-10 13:58:52 +01:00
advplyr
6075f2686f
Merge pull request #3546 from justcallmelarry/master
...
API PATCH /me/progress/:id - allow providing createdAt and respect provided finishedAt when syncing progress
2025-02-28 17:25:46 -06:00
mikiher
659164003f
Clear LibraryItemsPodcastFilters count cache after podcast[Episode] is created or destroryed
2025-02-16 13:27:47 +02:00
mikiher
da8fd2d9d5
Set podcastId when mediaProgress is created
2025-02-16 08:57:10 +02:00
mikiher
f1de307bf9
Update cached user whenever mediaProgress is removed
2025-02-16 08:52:33 +02:00
mikiher
7282afcfde
Add podcastId to mediaProgress model
2025-02-16 08:42:09 +02:00
mikiher
e2f1aeed75
Add numEpisodes to podcast model
2025-02-16 08:38:03 +02:00
advplyr
d9b206fe1c
Fix server crash when quick match all updates existing series sequence #3961
2025-02-14 16:56:37 -06:00
advplyr
9a261195b7
Update server/models/Book.js
2025-02-08 10:19:13 -06:00
mikiher
3d08a35aa0
Add index on (libraryId, mediaType, createdAt)
2025-02-08 14:53:01 +02:00
mikiher
a13143245b
Improve page load queries on title, titleIgnorePrefix, and addedAt sort order
2025-02-08 12:29:23 +02:00
advplyr
24d6e390f0
Fix Book/Podcast updateFromRequest to support null values in string fields #3938
2025-02-05 15:31:57 -06:00
advplyr
aebb3ff413
Fix API including basepath in tracks contentUrl
2025-02-01 16:47:36 -06:00
advplyr
b3b2bd7772
Fix feeds for collection/series pub date increment #3442
2025-01-28 17:11:57 -06:00
mikiher
9b4732c207
Add bookSeries id attribute to findAllExpandedWhere
2025-01-26 12:21:54 +02:00
advplyr
922a5039ce
Update descriptionPlain to only be available in json expanded
2025-01-25 13:30:30 -06:00
mikiher
286185329d
Support rich text book descriptions
2025-01-22 08:53:23 +02:00
advplyr
b816c0e7c4
Fix opening feed for series and collections
2025-01-20 14:18:22 -06:00
advplyr
a8b92819d1
Update feed episode description to use CDATA
2025-01-20 14:04:18 -06:00
advplyr
54a4b09592
Update RSS feed to exclude empty tags, format duration, use CDATA
2025-01-20 13:57:56 -06:00
advplyr
4701b3ed0c
Update audiobook rss feeds to increment pub dates in 1 minute intervals #3442
2025-01-17 17:21:35 -06:00
advplyr
ed5960825b
Fix podcast episode continue and listen again home page shelves
2025-01-07 08:37:05 -06:00
advplyr
977bdbf0bb
Fix podcast episode AudioTrack object
2025-01-06 13:30:31 -06:00
advplyr
108eaba022
Migrate tools and collapse series. fix continue shelves. remove old objects
2025-01-05 14:09:03 -06:00
advplyr
d5ce7b4939
Migrate to new library item in scanner
2025-01-05 12:05:01 -06:00
advplyr
1e9470b840
Update AuthorController library item usage and remove unused
2025-01-04 15:59:40 -06:00
advplyr
6d52f88a96
Update controllers to use toOldJSON functions
2025-01-04 15:20:41 -06:00
advplyr
d8823c8b1c
Update podcasts to new library item model
2025-01-04 12:41:09 -06:00
advplyr
69d1744496
Update podcasts to new library item model
2025-01-03 16:48:24 -06:00
advplyr
63466ec48b
Fix deleting episode library file removes episode from playlist #3784
2025-01-03 12:06:20 -06:00
advplyr
c251f1899d
Update PlaybackSession to use new library item model
2025-01-03 11:16:03 -06:00
advplyr
12c6f2e9a5
Update updateMedia endpoint to use new model
2025-01-02 17:21:07 -06:00
advplyr
4787e7fdb5
Updates to LibraryItemController to use new model
2025-01-02 15:42:52 -06:00
advplyr
dd0ebdf2d8
Implementing toOld functions for LibraryItem/Book/Podcast
2025-01-02 12:49:58 -06:00
advplyr
e7f7d1a573
Fix refresh feed when book is deleted and belonged to a series/collection
2025-01-01 12:06:01 -06:00
advplyr
5201625d38
Fix FeedEpisodes using a new ID when updating #3757
2025-01-01 11:32:39 -06:00
mikiher
0444829a9f
Add index on duration
2025-01-01 08:37:57 +02:00
mikiher
754c121168
Add libraryItem size index
2025-01-01 07:34:29 +02:00
advplyr
777c59458d
Fix find all playlist endpoint
2024-12-31 17:11:31 -06:00
advplyr
9785bc02ea
Update Playlist model & controller to remove usage of old Playlist object, remove old Playlist
2024-12-31 17:01:42 -06:00
advplyr
476933a144
Refactor Collection model/controller to not use old Collection object, remove
2024-12-30 16:54:48 -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
e0c674d9a9
Fix:Opening audiobook RSS feeds use audiofile name #3752
2024-12-28 16:36:53 -06:00
advplyr
b39268ccb0
Remove old Feed/FeedEpisode/FeedMeta objects
2024-12-15 17:54:36 -06:00
advplyr
de8a9304d2
Remove unused old feed methods
2024-12-15 17:05:57 -06:00
advplyr
f8fbd3ac8c
Migrate Feed updating and build xml to new model
2024-12-15 16:56:59 -06:00
advplyr
369c05936b
Fix feed create entityUpdatedAt value
2024-12-15 14:07:46 -06:00
advplyr
4c68ad46f4
Refactor RssFeedManager to use new model when closing feeds, fix close series feed when series is removed, update RssFeedManager to singleton
2024-12-15 12:37:01 -06:00
