import os
import requests
import pandas as pd
from datetime import datetime, timedelta
import logging
# 配置
BASE_URL = "http://172.17.0.100:8080/api/v4"
PRIVATE_TOKEN = "h_8duuSiAJsP4Kd-uEyn"
USERNAME = "kanghongyan" # 替换为实际的用户名
START_DATE = "2024-01-01"
END_DATE = "2025-01-01"
OUTPUT_FILE_CSV = "merge_requests_report.csv"
OUTPUT_FILE_EXCEL = "merge_requests_report.xlsx"
# 初始化日志
logging.basicConfig(level=logging.INFO, format="%(asctime)s - %(levelname)s - %(message)s")
# 请求头
HEADERS = {"PRIVATE-TOKEN": PRIVATE_TOKEN}
# 获取用户 ID
def fetch_author_id(username):
url = f"{BASE_URL}/users"
params = {"username": username}
try:
response = requests.get(url, headers=HEADERS, params=params)
response.raise_for_status()
users = response.json()
if users:
return users[0]["id"]
else:
logging.error(f"未找到用户名 {username} 对应的用户。")
return None
except requests.exceptions.RequestException as e:
logging.error(f"获取用户 ID 失败: {e}")
return None
# 获取用户的 MR 列表
def fetch_merge_requests(author_id, start_date, end_date):
url = f"{BASE_URL}/merge_requests"
params = {
"author_id": author_id,
"created_after": start_date,
"created_before": end_date,
"state": "merged",
"per_page": 100,
"page": 1,
}
results = []
try:
while True:
response = requests.get(url, headers=HEADERS, params=params)
response.raise_for_status()
data = response.json()
if not data:
break
results.extend(data)
params["page"] += 1
return results
except requests.exceptions.RequestException as e:
logging.error(f"获取 MR 列表失败: {e}")
return []
# 获取 MR 的代码变更详情
def fetch_merge_request_changes(project_id, mr_id):
url = f"{BASE_URL}/projects/{project_id}/merge_requests/{mr_id}/changes"
try:
response = requests.get(url, headers=HEADERS)
response.raise_for_status()
return response.json()
except requests.exceptions.RequestException as e:
logging.error(f"获取变更详情失败: {e}")
return {}
# 统计增删行数
def calculate_code_changes(changes):
additions = deletions = 0
for change in changes.get("changes", []):
diff = change.get("diff", "")
additions += diff.count("\n+")
deletions += diff.count("\n-")
return additions, deletions
# 主函数
def main():
# 动态获取 author_id
author_id = fetch_author_id(USERNAME)
if not author_id:
logging.error("无法继续执行,因为未能成功获取 author_id。")
return
# 检查并移除旧文件
if os.path.exists(OUTPUT_FILE_CSV):
os.remove(OUTPUT_FILE_CSV)
if os.path.exists(OUTPUT_FILE_EXCEL):
os.remove(OUTPUT_FILE_EXCEL)
# 初始化结果存储
results = []
# 日期范围
start_date = datetime.strptime(START_DATE, "%Y-%m-%d")
end_date = datetime.strptime(END_DATE, "%Y-%m-%d")
current_date = start_date
while current_date <= end_date:
month_start_date = current_date.replace(day=1)
next_month = (month_start_date + timedelta(days=31)).replace(day=1)
month_end_date = next_month - timedelta(days=1)
# 日期格式化
start_date_str = month_start_date.strftime("%Y-%m-%d")
end_date_str = min(month_end_date, end_date).strftime("%Y-%m-%d")
logging.info(f"处理日期范围: {start_date_str} 到 {end_date_str}")
# 获取 MR 数据
merge_requests = fetch_merge_requests(author_id, start_date_str, end_date_str)
if not merge_requests:
logging.info(f"日期范围 {start_date_str} 到 {end_date_str} 没有找到 MR 数据。")
current_date = next_month
continue
for mr in merge_requests:
project_id = mr.get("project_id")
mr_id = mr.get("iid")
title = mr.get("title", "无标题")
created_date = mr.get("created_at", "")[:10]
target_branch = mr.get("target_branch", "未知分支")
# 获取变更详情
changes_data = fetch_merge_request_changes(project_id, mr_id)
additions, deletions = calculate_code_changes(changes_data)
results.append({
"日期": created_date,
"标题": title,
"目标分支": target_branch,
"新增行数": additions,
"删除行数": deletions,
})
# 跳转到下个月
current_date = next_month
# 保存结果到 CSV 和 Excel
if results:
df = pd.DataFrame(results)
# 保存为 CSV 文件,使用 utf-8-sig 编码
df.to_csv(OUTPUT_FILE_CSV, index=False, encoding="utf-8-sig")
logging.info(f"统计结果已保存到 CSV 文件: {OUTPUT_FILE_CSV}")
# 保存为 Excel 文件
df.to_excel(OUTPUT_FILE_EXCEL, index=False, engine="openpyxl")
logging.info(f"统计结果已保存到 Excel 文件: {OUTPUT_FILE_EXCEL}")
else:
logging.info("未查询到符合条件的 Merge Request。")
if __name__ == "__main__":
main()