From 61bff3188e386eee5a0f07678bdb930a298a7a50 Mon Sep 17 00:00:00 2001 From: dakkar Date: Fri, 31 Dec 2021 16:23:27 +0000 Subject: actually pass pairs --- lib/App/MediaControl/DB.rakumod | 8 ++++---- 1 file 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 -- cgit v1.2.3