aboutsummaryrefslogtreecommitdiff
path: root/lib/App/MediaControl/DB.rakumod
diff options
context:
space:
mode:
Diffstat (limited to 'lib/App/MediaControl/DB.rakumod')
-rw-r--r--lib/App/MediaControl/DB.rakumod8
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/App/MediaControl/DB.rakumod b/lib/App/MediaControl/DB.rakumod
index 03c8bdd..34716c5 100644
--- a/lib/App/MediaControl/DB.rakumod
+++ b/lib/App/MediaControl/DB.rakumod
@@ -102,12 +102,12 @@ class App::MediaControl::DB {
}
multi method get-children-of(Any:U $) { 'IS NULL' }
- multi method get-children-of(Int:D() $id) { '=$id', $id }
+ multi method get-children-of(Int:D() $id) { '=$id', :$id }
proto method get-children-of($) {
my ($clause, @binds) = {*};
self!db: {
.query(qq:to/END/,|@binds).hashes;
- SELECT id, name, is_dir
+ SELECT id, name, is_dir, watched_time
FROM files
WHERE parent_id $clause
ORDER BY name ASC
@@ -117,7 +117,7 @@ class App::MediaControl::DB {
method get-parents-of(Int:D() $id) {
self!db: {
- .query(q:to/END/,$id).hashes.reverse;
+ .query(q:to/END/,:$id).hashes.reverse;
WITH f(id, parent_id, name) AS (
SELECT id, parent_id, name
FROM files
@@ -134,7 +134,7 @@ class App::MediaControl::DB {
method get-entry(Int:D() $id) {
self!db: {
- .query(q:to/END/,$id).hash;
+ .query(q:to/END/,:$id).hash;
SELECT id, path, name, is_dir
FROM files
WHERE id=$id