diff options
| author | dakkar <dakkar@thenautilus.net> | 2021-12-31 16:23:27 +0000 |
|---|---|---|
| committer | dakkar <dakkar@thenautilus.net> | 2021-12-31 16:23:27 +0000 |
| commit | 61bff3188e386eee5a0f07678bdb930a298a7a50 (patch) | |
| tree | 7844e83c1d9c8c5cc0924d37002376ea287acde9 | |
| parent | flush batched adds (diff) | |
| download | media-control-61bff3188e386eee5a0f07678bdb930a298a7a50.tar.gz media-control-61bff3188e386eee5a0f07678bdb930a298a7a50.tar.bz2 media-control-61bff3188e386eee5a0f07678bdb930a298a7a50.zip | |
actually pass pairs
| -rw-r--r-- | lib/App/MediaControl/DB.rakumod | 8 |
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 |