如何使用python从bugzilla访问bug数据

pip install requests beautifulsoup4 pandas

import requests
from bs4 import BeautifulSoup
import pandas as pd

url = "https://bugzilla.example.com/buglist.cgi?product=example"
response = requests.get(url)

soup = BeautifulSoup(response.text, "html.parser")
bugs_table = soup.find("table", id="buglist")

data = []
rows = bugs_table.find_all("tr")
for row in rows:
    cells = row.find_all("td")
    if len(cells) > 0:
        bug_id = cells[0].text.strip()
        summary = cells[1].text.strip()
        status = cells[2].text.strip()
        data.append([bug_id, summary, status])

df = pd.DataFrame(data, columns=["Bug ID", "Summary", "Status"])

# 示例：打印Bug数量和状态统计
print("Total Bugs:", len(df))
print("Bug Status:")
print(df["Status"].value_counts())

# 保存为CSV文件
df.to_csv("bugs.csv", index=False)

# 保存到数据库（示例使用SQLite）
import sqlite3
conn = sqlite3.connect("bugs.db")
df.to_sql("bugs", conn, if_exists="replace", index=False)
conn.close()