97434c1789
Fix GetNowPlaying endpoint showing only the last play
2021-06-20 10:39:19 -04:00
66b74c81f1
Encrypt passwords in DB ( #1187 )
...
* Encode/Encrypt passwords in DB
* Only decrypts passwords if it is necessary
* Add tests for encryption functions
2021-06-18 18:38:38 -04:00
110e17b004
Make MockRepo names more consistent
2021-06-08 16:30:19 -04:00
bebfe296a5
Allow updating only specific columns
2021-06-02 18:40:29 -04:00
327c259a3d
Create share table and repository. ( #930 )
...
* Add share table and repository
* Add datastore mock
* Try fixing indent
* Try fixing indent - 2
* Try fixing indent - 3
* Implement rest.Repository and rest.Persistance
* Renew date
* Better error handling
* Improve field name
* Fix json name conventionally
2021-05-30 11:50:35 -04:00
1940267a18
Handle functions with params in sort order.
...
Related to #1023
2021-05-28 17:35:32 -04:00
e60f2bfa3d
User management improvements ( #1101 )
...
* Show more descriptive success messages for User actions
* Check username uniqueness when creating/updating User
* Adjust translations
* Add tests for `validateUsernameUnique()`
Co-authored-by: Deluan <deluan@navidrome.org>
2021-05-16 13:25:38 -04:00
874b17b8f6
Require user to provide current password to be able to change it
...
Admins can change other users' password without providing the current one, but not when changing their own
2021-05-03 15:03:34 -04:00
7feda4bea4
Add `EnableUserEditing`, to control whether a regular user can change their own details (default `true`)
2021-05-02 17:11:12 -04:00
e3fe8399c8
Fix DevAutoCreateAdminPassword
2021-05-01 18:40:02 -04:00
a35de2bfd1
Allow regular users to change their info, including password.
...
Should fix #199
2021-04-28 22:35:25 -04:00
b671d0ff7b
Better handling of album comments ( #1013 )
...
* Change album comment behaviour
* Don't check first item
* Fix previously imported album comments.
* Remove song comments if album comment is present
2021-04-24 21:40:55 -04:00
5178f44094
Add `has_rating` filter to albums
2021-04-07 11:04:36 -04:00
720e2357b7
Add option to sort Recently Added by file's mtime instead of time of import.
2021-03-12 18:18:35 -05:00
6ee45a9ccc
Move project to Navidrome GitHub organization
2021-02-06 21:46:35 -05:00
22145e070f
Replace custom chunking logic with a `utils.BreakUpStringSlice` call
2021-02-03 17:26:03 -05:00
861b406575
Use new simplified `uuid.NewString()` syntax
2021-02-01 01:22:31 -05:00
7cc9fbaaf9
Revert: Use modified time as updated_at and created_at when refreshing/creating albums
2021-02-01 00:30:45 -05:00
9807b0b6c0
Use modified time as updated_at and created_at when refreshing/creating albums. Closes #717
2021-01-31 22:17:40 -05:00
10e52bdd3f
Use order_* fields for sorting by album and artist
2020-12-25 12:37:16 -05:00
9e84ce42b5
Use same album songs order for UI and Subsonic API
2020-12-25 12:37:16 -05:00
15b289201a
Fall back to media file path when sorting
...
If files cannot be sorted by disc and track id, try by artist then
title.
One use case is a loose compilation of files with same album, album
artist, and no track numbers. File order was then undetermined, in
practice depended on insertion order in the database.
2020-12-25 12:37:16 -05:00
db5b9246dd
Handle more sort/order cases
2020-12-23 11:37:38 -05:00
4f90fa9924
Add denormalized list of artist_ids to album, to speed-up artist's albums queries
...
This will be removed once we have a proper many-to-many relationship between album and artist
2020-12-13 14:05:48 -05:00
8bfaa0ad9d
Better detection of ID fields, to use `=` instead of `LIKE`
2020-11-15 18:24:13 -05:00
98af68ac99
Import comments and lyrics
2020-11-11 10:43:17 -05:00
9bcd606fe8
Fix Artist full_text refresh
2020-11-02 10:27:01 -05:00
7819e834c8
Fix Artist filtering
2020-11-02 09:58:51 -05:00
cfad35544b
Add artistImageUrl available in getArtists endpoint
...
Also cache artist info in the DB for 1 hour
2020-11-01 14:37:29 -05:00
d0bf37a8a9
Move mock datastore to tests package
2020-10-27 15:23:49 -04:00
313a088f86
Make mocks strongly typed
2020-10-27 15:23:49 -04:00
1cfa7b2272
Change MediaFolder.ID type to int32
2020-10-25 23:22:52 -04:00
173dd52fe1
Use MBID with most occurrences
2020-10-20 17:16:24 -04:00
6663c079e0
Add MBIDs to media_file, album and artist
2020-10-20 16:27:22 -04:00
40fd5bab34
Search for artists case-insensitive
2020-10-20 16:07:31 -04:00
07535e1518
Add ExternalInformation core service (not a great name, I know)
2020-10-20 16:07:31 -04:00
2f8dc794de
Add and show Playlists sizes
2020-10-12 22:31:01 -04:00
68a9be5e86
Add Artist (discography) size, and show sizes in Download caption
2020-10-12 22:31:01 -04:00
fd6edf967f
Add size to album details ( #561 )
...
* add size to album details
for #534
* addressing review comments:
* create index album(size)
* remove unneeded Size field from refresh struct
* add whitespace to album details
* add size to album list view
* prettier
2020-10-12 11:10:07 -04:00
21f7c1906d
Fix ByPath queries should not match partial filenames
2020-10-06 08:13:25 -04:00
abd51b2156
Use Subsonic API to star/unstar
...
This removes the need to update the annotations on Put(model), removing complexity and making it less buggy
2020-10-03 20:08:51 -04:00
f859772723
Remove dangling tracks after changing MusicFolder. Fix #445
2020-10-02 16:18:45 -04:00
841c1129ff
Break-up album/artist refresh in chunks
2020-09-09 08:57:59 -04:00
e50a720818
Sort by album name, then artist name
2020-09-07 16:21:29 -04:00
596a4897a3
Do not force username to always be lowercase in the DB
2020-09-01 18:00:19 -04:00
76e522710a
New option: SearchFullString, to match query strings anywhere in searchable fields, not only in word boundaries
...
Based on feedback from @orlea, in https://github.com/deluan/navidrome/issues/255#issuecomment-683427754
2020-08-30 13:08:10 -04:00
a2e0acd6a2
Fix starring albums. Seems I may have lost a commit?
2020-08-15 15:03:03 -04:00
c2e03c8162
Add stars to Albums
2020-08-14 13:35:28 -04:00
f2ebbd26fa
Add stars to Artist
2020-08-14 13:19:32 -04:00
ed726c2126
Better implementation of Bookmarks, using its own table
2020-08-01 12:17:15 -04:00
23d69d26e0
Add Bookmarks to Subsonic API
2020-07-31 17:45:49 -04:00
3d0e70e907
Add MediaFile to Bookmark
2020-07-31 17:45:49 -04:00
34e843a4b3
Add updatedAt to Bookmarks
2020-07-31 17:45:49 -04:00
2d3ed85311
Add bookmark in persistence layer
2020-07-31 17:45:49 -04:00
3d4f4b4e2b
Fix lint errors
2020-07-31 17:45:49 -04:00
3000238a3c
Implements the get/save play queue Subsonic endpoints and bumps API version to 1.12.0
2020-07-31 17:45:49 -04:00
721a959735
Create playqueue table and repository
2020-07-31 17:45:49 -04:00
eae46d15bf
Fix pagination
2020-07-29 15:34:48 -04:00
db8a48bba6
Implement album lists
2020-07-29 15:34:48 -04:00
1b7f628759
Add tests for paths with UTF8 chars
2020-07-22 11:48:09 -04:00
5a891fda9e
Handle utf8 chars in paths
2020-07-22 09:36:22 -04:00
b9b6ce066b
Auto-Import playlists found in the Music Folder
2020-07-17 22:55:51 -04:00
d14a6031f0
Add test for case-sensitive DeleteByPath
2020-07-14 15:35:42 -04:00
8b20c26e04
Make "ByPath" queries case-sensitive
2020-07-14 15:27:27 -04:00
33d5459c20
Escape paths in "ByPath" queries
2020-07-14 07:20:27 -04:00
dc8368c89c
Return counter from DeleteByPath
2020-07-12 11:53:07 -04:00
f0ee52a98e
Fix album refresh query. Fixes #373
2020-06-29 14:17:28 -04:00
c01d81802d
Fix album's songCount. Fixes #373
2020-06-29 11:35:51 -04:00
890ca64f51
Fix `cover.jpg` discovery
2020-06-29 10:50:38 -04:00
bcaf330233
Make sure to select cover art from media_file that has it. Fix #360
2020-06-27 22:16:07 -04:00
5f40801a78
Add more logs to GC call
2020-06-26 10:23:05 -04:00
eb109ebeb4
Remove duplicated helper functions, move them to `utils` package
2020-06-24 20:48:42 -04:00
bb9a7fadc0
Add tests for external album cover processing
...
This implements basic tests for functionality related to loading and
processing external album covers, both on the scanning size, and on the
display side.
2020-06-24 20:48:42 -04:00
ac5d99c079
Check MIME type for cover on refresh, display
...
Files that match the `CoverArtPriority` setting will now be considered
eligible only if their extensions are of an 'image/*' MIME type (e.g.
'.png' for 'image/png', '.jpg' for 'image/jpeg'). This prevents matching
files that will likely not be valid during display.
In addition to the above, code for returning the cover image file from
scanned data will also check against the MIME type for the path stored,
instead of attempting to re-trace `CoverArtPriority` matches. This
simplifies the code and bypasses a number of edge-cases related to
inconsistent matching.
2020-06-24 20:48:42 -04:00
08cd28af2d
Load cover art from file directory
...
This commit adds support for loading cover art from media file
directories, according to configured filename priorities (of which an
additional, special choice of `embedded` is given).
Cover art paths are resolved during scanning and stored in the database
as part of the `album.cover_art_path` column; if embedded cover art is
matched, this will default to the path of the media file itself, and if
no cover art is matched at all.
Similarly, the `album.cover_art_id` column will default to a reference
to `media_file.id` if embedded cover art is wanted, but if an external
cover art file is matched, this will instead be set to a reference to
the `album.id` value itself, prefixed with the `al-` constant.
Stored cover art paths are once again resolved and matched against
configuration when covers are requested; that is, any change in
configuration between scanning and requesting cover art may not return
correct data until a re-scan is complete.
Tests will be added in future commits.
2020-06-24 20:48:42 -04:00
2d1d992e17
Support Windows paths
2020-06-14 03:11:16 -04:00
e73b71aaf7
Remove tracks from DB that were deleted while Navidrome was not running. Fixes #151
2020-06-14 03:11:16 -04:00
3190611ec8
Call `ffmpeg` in batches
2020-06-14 03:11:16 -04:00
6a3dabbb06
Optimize queries by path
2020-06-14 03:11:16 -04:00
0033966c25
No need to delete the playlist tracks explicitly
2020-06-10 18:07:10 -04:00
94d88395e7
Add referential integrity to player and playlist tables
2020-06-10 18:07:10 -04:00
c9bcb333ae
Add more options to Players list
2020-06-10 18:07:10 -04:00
29c7513879
Update `updated_at` field when modifying the playlist
2020-06-09 07:55:35 -04:00
b4e06c416d
Allow toggling a playlist public from the Playlist list view. Closes #344
2020-06-08 18:39:31 -04:00
c6f23139bc
Handle playlist's permissions on server
2020-06-05 11:55:29 -04:00
331fa1d952
Add ability to reorder playlist items
2020-06-04 19:05:41 -04:00
d8699b03bd
Fix album sort fields
2020-05-28 20:48:58 -04:00
201a22e613
Change index in playlist to start from `1`
2020-05-26 13:50:15 -04:00
aaa4f1531e
Ignore brackets in search
2020-05-25 11:05:30 -04:00
e811816021
Fix pagination in Songs when filtered by starred
2020-05-23 00:43:45 -04:00
9331be67a3
Fix pagination in Songs
2020-05-23 00:17:35 -04:00
ec0002e77a
Add a sortable Starred column and a Starred filter to Song List
2020-05-22 23:10:58 -04:00
8a68cecdb9
Add ToggleStar to SongContextMenu (WIP)
2020-05-22 15:23:42 -04:00
17df63b550
Fix `child.size` and `directory.playCount` compatibility with Subsonic API. Fixes #304
2020-05-19 23:51:23 -04:00
c2d1e9df9f
Remove orphan tracks from playlists after they are removed from library
2020-05-18 20:32:01 -04:00
d1a0ffaaee
Check permissions in playlists
2020-05-16 23:14:28 -04:00
12cf2f1104
Remove tracks from playlist
2020-05-16 18:35:34 -04:00
e81a9dd1b5
Add tracks to playlist
2020-05-16 18:35:34 -04:00
8a709c489a
Add playlist views
2020-05-16 18:35:34 -04:00
5682d0e721
Remove tracks from Playlist's GetAll
2020-05-16 18:35:34 -04:00
8f9601090c
Add helper functions tests
2020-05-16 18:35:34 -04:00
aebee651ac
Add nested resource `playlist/{id}/tracks`
2020-05-16 18:35:34 -04:00
a56e588c8e
Create relation table for playlist tracks
2020-05-16 18:35:34 -04:00
27de18f8c9
Fix typo
2020-05-16 18:35:34 -04:00
4e613be960
Add playlists REST endpoint
2020-05-16 18:35:34 -04:00
f8362a4acb
Fix staticcheck's SA1029
2020-05-13 16:49:55 -04:00
5ce3135f00
Fix gosec's G601
2020-05-13 15:32:42 -04:00
0d9361734f
Import and display disc subtitles
2020-05-12 12:57:53 -04:00
0d1e2a92f6
Make MediaFolder ID int32
2020-05-09 22:29:02 -04:00
70047fe20e
Add `songCount` column to Artist table
2020-05-08 10:05:48 -04:00
c585ca7131
Add `random` as a valid sort option for `song` resource
2020-05-05 16:17:09 -04:00
dbde5330bd
Mark helper function as unexported
2020-05-01 09:17:21 -04:00
5cd453afeb
Fix all `errcheck` warnings
2020-04-26 15:07:36 -04:00
03c3c192ed
Fixing static checks about passing nil context
2020-04-26 15:07:36 -04:00
8dcca76ec9
Fix various small sort issues
2020-04-24 17:37:28 -04:00
e6f798811d
Generate Artist Index using the OrderArtistName
2020-04-24 15:02:20 -04:00
69c19e946c
Add sort tags and use them in search
2020-04-24 15:02:20 -04:00
80c8d85cb9
Fine tune search functionality
2020-04-19 23:29:07 -04:00
69dc4d97b3
Always fill album's min_year if max_year is filled
2020-04-17 21:44:34 -04:00
4b1c76e307
Keep the order of the playlist when adding new songs. Also allow adding a song more than once
2020-04-11 21:24:15 -04:00
9fb4f5ef52
Removed Playlist.GetWithTracks, not needed anymore
2020-04-11 19:05:51 -04:00
e232c5c561
Add `created` and `changed` fields to playlists responses
2020-04-11 18:58:43 -04:00
5265d0234f
Fix tests for Cover service
2020-04-09 12:13:54 -04:00
43ce81af67
Add all individual artists from album in searchable full text field. Should fix #94
2020-04-08 23:54:54 -04:00
b8d1185f7f
Remove duplicated words and extra spaces from full text searchable fields
2020-04-08 23:29:28 -04:00
46f4f63212
feat: initial implementation of album lists
2020-03-29 00:01:08 -04:00
777231ea79
feat: expose album, song and artist annotations in the RESTful API
2020-03-28 19:22:55 -04:00
0e36ed35a3
fix: typo
2020-03-28 18:50:18 -04:00
0ca849a61a
feat: show year range in album view and match ranges in year filter. #118
2020-03-27 21:11:06 -04:00
53e8a92fed
feat: rename year to max_year and add min_year to album. #118
2020-03-27 21:11:06 -04:00
b03519b09c
fix: configured transcodings not appearing in players view
2020-03-27 19:12:11 -04:00
dcb3b3b5d1
fix: various album_artists <-> artists mismatches
2020-03-26 09:08:53 -04:00
5331732236
fix: remove sql injection
2020-03-25 20:40:18 -04:00
dc973ae670
refactor: remove unused code
2020-03-25 20:40:18 -04:00
100db2bcfd
feat: add artist filter to album view
2020-03-25 20:40:18 -04:00
b4c7cac964
refactor: moved magic strings to consts
2020-03-24 11:59:10 -04:00
20075ae68d
refactor: extracted restful helpers into their own composable struct
2020-03-21 20:00:46 -04:00
f6e448c1ba
refactor: removed unused code, unnecessary typecasts and fixed small warnings
2020-03-20 00:07:36 -04:00
8401d85f78
feat: search in WebUI now is more flexible, searching in all relevant fields in the current view
2020-03-19 22:26:18 -04:00
32fbf2e9eb
refactor: drop search table, integrated full_text into main tables
2020-03-19 21:44:48 -04:00
8cdd4e317d
feat: allow restful filter customization per field
2020-03-19 21:09:57 -04:00
97d95ea794
fix: group compilations together in the restful API. fix #93
2020-03-19 15:02:11 -04:00
811703ab60
fix: create default transcodings on existing installations
2020-03-17 16:49:37 -04:00
68a49befc8
feat: allow regular users to change their players' configuration
2020-03-17 15:20:35 -04:00
c8b0d2bfae
feat: select correct transcoding for streaming
2020-03-17 15:20:35 -04:00
39993810b3
feat: add `transcodedSuffix` to Subsonic API responses
2020-03-17 15:20:35 -04:00
8ec78900c5
feat: transcoding and player datastores and configuration
2020-03-17 15:20:35 -04:00
9235ab6414
fix: index albumArtist as part of the album searchable fields
2020-03-07 13:10:20 -05:00
6f5a322927
fix: login must be case-insensitive
2020-03-01 15:45:41 -05:00
a7f8e4ee2b
fix: only set created_at when adding data to DB
2020-02-28 18:43:22 -05:00
0850872b0f
fix: ormer.Driver() is not available when creating orms with NewOrmWithDB()
2020-02-28 16:09:27 -05:00
faa2a978c0
refactor: use only one DB instance for the whole application
2020-02-28 15:06:31 -05:00
65a792be3a
fix: handle nil pointer dereference
2020-02-28 11:02:38 -05:00
33ede13eef
fix: check if album is starred before adding the starred date in the response. also return "starred" in search responses
2020-02-24 22:06:12 -05:00
d2eea64528
fix: typo
2020-02-23 21:41:10 -05:00
fc14e346b9
feat: store duration as float, to cater for milliseconds
2020-02-20 17:02:06 -05:00
8a31e80b7a
fix: find songs and albums when sending an artist name search query
2020-02-09 19:52:06 -05:00
5a95feeedc
fix: allow searches with 2 chars. closes #65
2020-02-09 12:20:34 -05:00
029290f304
fix: set default play_count to 0
...
IncPlayCount was not incrementing when the annotation already existed with play_count = null
2020-02-08 22:55:05 -05:00
7aab82c246
feat: enable overriding sql sorting
2020-02-06 18:41:34 -05:00
6978790e96
feat: allow regular users to login to the UI
2020-02-05 22:22:44 -05:00
e0308acef3
feat: add lapsed time to SQL logger, to help detect SQL bottlenecks
2020-02-05 08:47:32 -05:00
464880dd31
refactor: use stdlib `filepath.FromSlash`
2020-02-03 17:53:59 -05:00
ff8c18e0f4
fix: don't log empty sql responses as errors
2020-02-02 21:29:27 -05:00
d4365b9f64
refactor: read musicFolderId from request (but still don't use it)
2020-02-01 17:23:03 -05:00
b62b78edfe
refactor: better SQL logging
2020-02-01 17:23:03 -05:00
7c4511e33a
refactor: consolidate query executions into two functions `queryOne` and `queryAll`
2020-02-01 17:23:03 -05:00
7e65bb8f20
refactor: better integration between `db` and `persistence` packages
...
Will address support for different DBs in the future (+1 squashed commit)
Squashed commits:
[a014757] refactor: better integration between `db` and `persistence` packages
2020-02-01 17:23:03 -05:00
a6b8f40ac3
refactor: remove prefix New from SQLStore
2020-02-01 17:23:03 -05:00
0d0787e656
refactor:clean annotations in GC
2020-02-01 17:23:03 -05:00
88e01d05f6
refactor: annotations
2020-02-01 17:23:03 -05:00
de1fea64bc
refactor: introduce GC, to delete old data
2020-02-01 17:23:03 -05:00
5d1df19291
fix: manually set timestamps, as we don't rely on the ORM anymore
2020-02-01 17:23:03 -05:00
0b91d8a30e
refactor: more SQL logs
2020-02-01 17:23:03 -05:00
cdbbb2f596
fix: Find/DeleteByPath
2020-02-01 17:23:03 -05:00
44671c59c0
refactor: fix rest filter
2020-02-01 17:23:03 -05:00
d9f61a278c
refactor: some clean-up
2020-02-01 17:23:03 -05:00
a260e65307
refactor: add GetStarred to artists
2020-02-01 17:23:03 -05:00
5a4c763510
refactor: add search back to albums and artists
2020-02-01 17:23:03 -05:00
d755609d13
refactor: add search back to mediafiles
2020-02-01 17:23:03 -05:00
4f4af34595
fix: DB pagination
2020-02-01 17:23:03 -05:00
f5071d1614
refactor: adding back artist and album tables
2020-02-01 17:23:03 -05:00
d389d40db1
feat: improve logs, remove config for disable authentication
2020-02-01 17:23:03 -05:00
72d9ddf532
refactor: remove annotation handling from engine
2020-02-01 17:23:03 -05:00
67ed830a68
refactor: add filters
2020-02-01 17:23:03 -05:00
71c1844bca
refactor: new persistence, more SQL, less ORM
2020-02-01 17:23:03 -05:00
0d2911daf9
refactor: add Context to the persistence layer
2020-01-27 09:41:33 -05:00
0ff741b394
fix: persistence tests were not being properly initialized
2020-01-26 17:10:13 -05:00
f9db80c409
feat: add conf for data folder, default current folder (not ./data anymore)
2020-01-26 16:42:56 -05:00
58a7879ba8
feat: first time admin user creation through the ui
2020-01-25 17:10:16 -05:00
bff6f3a4bd
Rename env vars prefix to ND_
2020-01-24 01:29:31 -05:00
bee55c04c8
Rename project to Navidrome
2020-01-23 19:44:08 -05:00
ed31b6fa31
Remove unused code
2020-01-22 15:42:29 -05:00
1f58bf47d6
Fix GetStarred for all item types
2020-01-22 15:19:37 -05:00
7dc3f49c1c
Initial support for artist browsing from UI. Also add linking between resources
2020-01-22 13:02:19 -05:00
ea30b4c2d9
Initial support for album browsing from UI
2020-01-22 12:32:31 -05:00
9557f7ceed
Initial support for song browsing from UI
2020-01-22 10:47:43 -05:00
c73f549c83
Don't try to get albums if ids is empty
2020-01-22 01:03:49 -05:00
c8a74881d8
Fix album lists, to use annotations
2020-01-22 01:00:00 -05:00
d7116eebd4
Implement annotations per user
2020-01-21 23:03:37 -05:00
Deluan