From 9cc1ecf5c888eabb23e74bc3cf1615c50673ef1d Mon Sep 17 00:00:00 2001 From: dakkar Date: Fri, 31 Dec 2021 16:22:58 +0000 Subject: flush batched adds --- lib/App/MediaControl/DB.rakumod | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/App/MediaControl/DB.rakumod') diff --git a/lib/App/MediaControl/DB.rakumod b/lib/App/MediaControl/DB.rakumod index 6e7a272..03c8bdd 100644 --- a/lib/App/MediaControl/DB.rakumod +++ b/lib/App/MediaControl/DB.rakumod @@ -78,7 +78,7 @@ class App::MediaControl::DB { $values ) INSERT INTO files(parent_id,path,name,is_dir,seen) - SELECT id, newrow.path, name, is_dir, true + SELECT parent.id, newrow.path, newrow.name, newrow.is_dir, true FROM newrow LEFT JOIN parent ON parent.path=newrow.path WHERE true -- cgit v1.2.3