1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
| #!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Grafana仪表板批量导出工具
export-dashboards.py
"""
import os
import json
import requests
import argparse
from datetime import datetime
from pathlib import Path
import re
class GrafanaExporter:
def __init__(self, url, api_key, output_dir="./grafana-exports"):
self.url = url.rstrip('/')
self.api_key = api_key
self.output_dir = Path(output_dir)
self.session = requests.Session()
self.session.headers.update({
'Authorization': f'Bearer {api_key}',
'Content-Type': 'application/json'
})
# 创建带时间戳的导出目录
timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")
self.export_dir = self.output_dir / f"export_{timestamp}"
self.export_dir.mkdir(parents=True, exist_ok=True)
def api_request(self, endpoint):
"""发送API请求"""
try:
response = self.session.get(f"{self.url}{endpoint}")
response.raise_for_status()
return response.json()
except requests.exceptions.RequestException as e:
print(f"API请求失败: {e}")
return None
def safe_filename(self, name):
"""生成安全的文件名"""
return re.sub(r'[^a-zA-Z0-9._-]', '_', name)
def get_folders(self):
"""获取所有文件夹"""
print("获取文件夹列表...")
folders = self.api_request("/api/folders")
if folders:
# 保存文件夹信息
with open(self.export_dir / "folders.json", 'w', encoding='utf-8') as f:
json.dump(folders, f, indent=2, ensure_ascii=False)
print(f"找到 {len(folders)} 个文件夹")
return folders or []
def get_dashboards(self):
"""获取所有仪表板"""
print("获取仪表板列表...")
dashboards = self.api_request("/api/search?type=dash-db")
if dashboards:
print(f"找到 {len(dashboards)} 个仪表板")
return dashboards or []
def export_dashboard(self, dashboard_info):
"""导出单个仪表板"""
uid = dashboard_info['uid']
title = dashboard_info['title']
folder_title = dashboard_info.get('folderTitle', 'root')
print(f"导出仪表板: {title} (UID: {uid})")
# 创建文件夹目录
folder_dir = self.export_dir / self.safe_filename(folder_title)
folder_dir.mkdir(exist_ok=True)
# 获取仪表板详细信息
dashboard_data = self.api_request(f"/api/dashboards/uid/{uid}")
if dashboard_data and 'dashboard' in dashboard_data:
# 生成文件名
safe_title = self.safe_filename(title)
filename = folder_dir / f"{safe_title}_{uid}.json"
# 保存仪表板
with open(filename, 'w', encoding='utf-8') as f:
json.dump(dashboard_data['dashboard'], f, indent=2, ensure_ascii=False)
print(f" ✓ 导出成功: {filename}")
return True
else:
print(f" ✗ 导出失败: {title}")
return False
def generate_report(self, exported_count, total_count):
"""生成导出报告"""
report_file = self.export_dir / "export_report.txt"
# 统计信息
folders_count = len([d for d in self.export_dir.iterdir() if d.is_dir()])
json_files = list(self.export_dir.rglob("*.json"))
dashboard_files = [f for f in json_files if f.name != "folders.json"]
with open(report_file, 'w', encoding='utf-8') as f:
f.write(f"Grafana仪表板导出报告\n")
f.write(f"{'='*50}\n")
f.write(f"导出时间: {datetime.now().strftime('%Y-%m-%d %H:%M:%S')}\n")
f.write(f"Grafana URL: {self.url}\n")
f.write(f"导出目录: {self.export_dir}\n\n")
f.write(f"统计信息:\n")
f.write(f" 文件夹数量: {folders_count}\n")
f.write(f" 仪表板总数: {total_count}\n")
f.write(f" 成功导出: {exported_count}\n")
f.write(f" 失败数量: {total_count - exported_count}\n\n")
f.write(f"导出文件列表:\n")
for file in sorted(dashboard_files):
relative_path = file.relative_to(self.export_dir)
f.write(f" {relative_path}\n")
print(f"导出报告已生成: {report_file}")
def export_all(self):
"""导出所有仪表板"""
print(f"开始导出Grafana仪表板...")
print(f"Grafana URL: {self.url}")
print(f"导出目录: {self.export_dir}")
# 获取文件夹信息
self.get_folders()
# 获取所有仪表板
dashboards = self.get_dashboards()
if not dashboards:
print("未找到任何仪表板")
return
# 导出每个仪表板
exported_count = 0
for dashboard in dashboards:
if self.export_dashboard(dashboard):
exported_count += 1
# 生成报告
self.generate_report(exported_count, len(dashboards))
print(f"\n导出完成!")
print(f"成功导出: {exported_count}/{len(dashboards)} 个仪表板")
print(f"导出目录: {self.export_dir}")
def main():
parser = argparse.ArgumentParser(description='Grafana仪表板批量导出工具')
parser.add_argument('--url', default='http://localhost:3000',
help='Grafana URL (默认: http://localhost:3000)')
parser.add_argument('--api-key', required=True,
help='Grafana API密钥')
parser.add_argument('--output', default='./grafana-exports',
help='导出目录 (默认: ./grafana-exports)')
args = parser.parse_args()
# 创建导出器并执行导出
exporter = GrafanaExporter(args.url, args.api_key, args.output)
exporter.export_all()
if __name__ == '__main__':
main()
|
