Grafana報表系統

• 備份報表資訊

1. 備份 folder

public static void backupAllFolders() throws Exception {

 List<Map<String, Object>> folders = getAllFoldersFromGrafanaA();
 ObjectMapper objectMapper = new ObjectMapper();
 String json = objectMapper.writeValueAsString(folders);
 writeToFile(BACKUP_FOLDER + "//folders.json", json);

}

public static List getAllFoldersFromGrafanaA() throws Exception {

	String url = GRAFANA_A_URL + "/api/folders";
	HttpHeaders headers = new HttpHeaders();
	headers.set("Authorization", API_KEY_A);
	headers.setContentType(MediaType.APPLICATION_JSON);
	HttpEntity<String> entity = new HttpEntity<>(headers);

	ResponseEntity<List> response = restTemplate.exchange(url, HttpMethod.GET, entity, List.class);
	if (response.getStatusCode() == HttpStatus.OK) {
		return (response.getBody());
		// writeToFile(BACKUP_FOLDER + "//folders.json", new
		// JSONArray(response.getBody()).toString());
	}
	return Collections.emptyList();
}

2. 備份 dashboard 及 library

public static void backupAllDashboardAndLibs() {
	try {

		RestTemplate restTemplate = new RestTemplate();
		HttpHeaders headers = new HttpHeaders();
		headers.set("Authorization", API_KEY_A);
		headers.setContentType(MediaType.APPLICATION_JSON);

		String searchUrl = GRAFANA_A_URL + "/api/search?type=dash-db";
		HttpEntity<String> request = new HttpEntity<>(headers);
		ResponseEntity<String> searchResponse = restTemplate.exchange(searchUrl, HttpMethod.GET, request,
				String.class);

		ObjectMapper objectMapper = new ObjectMapper();
		JsonNode searchResult = objectMapper.readTree(searchResponse.getBody());

		for (JsonNode dashboard : searchResult) {

			String dashboardUid = dashboard.get("uid").asText();

			String dashboardTitle = dashboard.get("title").asText();

			String dashboardUrl = GRAFANA_A_URL + "/api/dashboards/uid/" + dashboardUid;
			ResponseEntity<String> dashboardResponse = restTemplate.exchange(dashboardUrl, HttpMethod.GET, request,
					String.class);
			JsonNode dashboardJson = objectMapper.readTree(dashboardResponse.getBody());

			writeToFile(BACKUP_FOLDER + "dashboard\\" + dashboardTitle + ".json", dashboardJson);

			JsonNode panels = dashboardJson.path("dashboard").path("panels");
			for (JsonNode panel : panels) {

				if (panel.has("libraryPanel")) {

					String libraryPanelUid = panel.get("libraryPanel").get("uid").asText();
					System.out.println("Found library panel with UID: " + libraryPanelUid);

					String libraryElementsUrl = GRAFANA_A_URL + "/api/library-elements/" + libraryPanelUid;

					HttpEntity<String> libraryRequest = new HttpEntity<>(headers);
					ResponseEntity<String> libraryResponse = restTemplate.exchange(libraryElementsUrl,
							HttpMethod.GET, libraryRequest, String.class);

					String resBody = libraryResponse.getBody();

					JsonNode libraryElementsJson = objectMapper.readTree(resBody);

					writeToFile(BACKUP_FOLDER + "library\\"
							+ libraryElementsJson.path("result").get("name").asText() + ".json",
							libraryElementsJson);

				}
			}

		}

	} catch (Exception e) {
		e.printStackTrace();
	}
}

3. 備份 Datasource

private static void backupDataSource() throws Exception {

	String urlA = GRAFANA_A_URL + "/api/datasources";
	HttpHeaders headers = new HttpHeaders();
	headers.set("Authorization", API_KEY_A);
	headers.setContentType(MediaType.APPLICATION_JSON);
	HttpEntity<String> entity = new HttpEntity<>(headers);

	ResponseEntity<String> response = restTemplate.exchange(urlA, HttpMethod.GET, entity, String.class);
	if (response.getStatusCode() == HttpStatus.OK) {
		System.out.println(response.getBody());
		writeToFile(BACKUP_FOLDER + "//datasource.json", new JSONArray(response.getBody()).toString());
	}

}