Method deleteDescendants

packages/shell/src/filesystem.ts:1514–1540

(dirPath: string)

  }

  private async deleteDescendants(dirPath: string): Promise<void> {
    const pattern = escapeLike(dirPath) + "/%";
    const T = this.tableName;

    const r2Rows = await this.sql.query<{ r2_key: string }>(
      `SELECT r2_key FROM ${T}
      WHERE path LIKE ? ESCAPE ?
        AND storage_backend = 'r2'
        AND r2_key IS NOT NULL`,
      pattern,
      LIKE_ESCAPE
    );

    if (r2Rows.length > 0) {
      const r2 = this.getR2();
      if (r2) {
        const keys = r2Rows.map((r) => r.r2_key);
        await r2.delete(keys);
      }
    }

    await this.sql.run(
      `DELETE FROM ${T} WHERE path LIKE ? ESCAPE ?`,
      pattern,
      LIKE_ESCAPE
    );
  }
}

// ── Base64 helpers ───────────────────────────────────────────────────