diff options
author | dakkar <dakkar@thenautilus.net> | 2021-12-31 16:41:45 +0000 |
---|---|---|
committer | dakkar <dakkar@thenautilus.net> | 2021-12-31 16:41:45 +0000 |
commit | aa2727248bd80cf8cf4c320db47248a632d3d4fd (patch) | |
tree | e1bc5ab616c096749561d0be4b5a8eab47e391dd | |
parent | fix `recent` payload (diff) | |
download | media-control-aa2727248bd80cf8cf4c320db47248a632d3d4fd.tar.gz media-control-aa2727248bd80cf8cf4c320db47248a632d3d4fd.tar.bz2 media-control-aa2727248bd80cf8cf4c320db47248a632d3d4fd.zip |
fix `recent` limit
-rw-r--r-- | lib/App/MediaControl/DB.rakumod | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/App/MediaControl/DB.rakumod b/lib/App/MediaControl/DB.rakumod index 3d90de8..f49cfab 100644 --- a/lib/App/MediaControl/DB.rakumod +++ b/lib/App/MediaControl/DB.rakumod @@ -143,7 +143,7 @@ class App::MediaControl::DB { method get-recently-watched-folders(Int:D() $limit=20) { self!db: { - .query(qq:to/END/, :$limit).hashes; + .query(qq:to/END/, $limit).hashes; WITH recent(id,watched_time) AS ( SELECT parent_id AS id, MAX(watched_time) AS watched_time FROM files @@ -152,7 +152,7 @@ class App::MediaControl::DB { AND parent_id IS NOT NULL GROUP BY parent_id ORDER BY watched_time DESC - LIMIT $limit + LIMIT ? ) SELECT files.id, files.name, files.is_dir, recent.watched_time FROM files |