From 3402f3d6e906afb500b95448d7d0b136b6b5ee86 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Wed, 15 Jun 2022 17:14:28 +1000 Subject: Adjust 'node_imgs' table to use node name, not id --- backend/data/trimTree.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'backend/data/trimTree.py') diff --git a/backend/data/trimTree.py b/backend/data/trimTree.py index 1291c14..3c98ae8 100755 --- a/backend/data/trimTree.py +++ b/backend/data/trimTree.py @@ -24,7 +24,7 @@ print("\tFinding nodes with descs") for (name,) in dbCur.execute("SELECT name FROM descs"): nodesToKeep.add(name) print("\tFinding nodes with images") -for (name,) in dbCur.execute("SELECT name FROM nodes INNER JOIN node_imgs ON nodes.id = node_imgs.id"): +for (name,) in dbCur.execute("SELECT name FROM node_imgs"): nodesToKeep.add(name) print("\tFinding nodes in reduced-tree") for (name,) in dbCur.execute("SELECT name from r_nodes"): -- cgit v1.2.3