| 113 | self.execute("DELETE FROM content WHERE ?", {"site_id": self.site_ids.get(site.address, 0), "inner_path": inner_path}) |
| 114 | |
| 115 | def loadDbDict(self, site): |
| 116 | res = self.execute( |
| 117 | "SELECT GROUP_CONCAT(inner_path, '|') AS inner_paths FROM content WHERE ?", |
| 118 | {"site_id": self.site_ids.get(site.address, 0)} |
| 119 | ) |
| 120 | row = res.fetchone() |
| 121 | if row and row["inner_paths"]: |
| 122 | inner_paths = row["inner_paths"].split("|") |
| 123 | return dict.fromkeys(inner_paths, False) |
| 124 | else: |
| 125 | return {} |
| 126 | |
| 127 | def getTotalSize(self, site, ignore=None): |
| 128 | params = {"site_id": self.site_ids.get(site.address, 0)} |