c = "delete volume=%s yes"%(r['volumename'],)
cmd.append(c)
+# find obsolete pools
+cursor.execute("""
+ SELECT name
+ FROM pool
+ WHERE
+ name != 'Scratch' AND
+ numvols = 0 AND
+ poolid NOT IN (SELECT recyclepoolid FROM media)
+""", {})
+
+for r in cursor.fetchall():
+ c = "delete pool=%s"%(r['name'],)
+ cmd.append(c)
+ cmd.append("yes")
+
if args.nodo:
print("\n".join(cmd))
sys.exit(0)