forked from gooddata/gooddata-java
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathExample.java
More file actions
101 lines (71 loc) · 3.76 KB
/
Example.java
File metadata and controls
101 lines (71 loc) · 3.76 KB
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
/*
* Copyright (C) 2007-2014, GoodData(R) Corporation. All rights reserved.
*/
package com.gooddata;
import com.gooddata.account.Account;
import com.gooddata.account.AccountService;
import com.gooddata.dataset.DatasetManifest;
import com.gooddata.dataset.DatasetService;
import com.gooddata.gdc.DataStoreService;
import com.gooddata.md.Attribute;
import com.gooddata.md.Fact;
import com.gooddata.md.MetadataService;
import com.gooddata.md.Metric;
import com.gooddata.md.report.AttributeInGrid;
import com.gooddata.md.report.GridElement;
import com.gooddata.md.report.GridReportDefinitionContent;
import com.gooddata.md.report.Report;
import com.gooddata.md.report.ReportDefinition;
import com.gooddata.model.ModelDiff;
import com.gooddata.model.ModelService;
import com.gooddata.project.Project;
import com.gooddata.project.ProjectService;
import com.gooddata.report.ReportExportFormat;
import com.gooddata.report.ReportService;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.Collection;
import static com.gooddata.md.Restriction.identifier;
import static java.util.Arrays.asList;
public class Example {
public static void main(String... args) throws FileNotFoundException {
final AccountService accountService = gd.getAccountService();
final Account current = accountService.getCurrent();
System.out.println(current.getId());
final ProjectService projectService = gd.getProjectService();
final Collection<Project> projects = projectService.getProjects();
System.out.println(projects);
final Project project = projectService.createProject(new Project("sparkling3", "pgroup2")).get();
System.out.println(project.getUri());
final ModelService modelService = gd.getModelService();
final ModelDiff projectModelDiff = modelService.getProjectModelDiff(project,
new InputStreamReader(Example.class.getResourceAsStream("/person.json"))).get();
modelService.updateProjectModel(project, projectModelDiff).get();
final MetadataService md = gd.getMetadataService();
String fact = md.getObjUri(project, Fact.class, identifier("fact.person.shoesize"));
Metric m = md.createObj(project, new Metric("Avg shoe size", "SELECT AVG([" + fact + "])", "#,##0"));
Attribute attr = md.getObj(project, Attribute.class, identifier("attr.person.department"));
ReportDefinition definition = GridReportDefinitionContent.create(
"Department avg shoe size",
asList("metricGroup"),
asList(new AttributeInGrid(attr.getDefaultDisplayForm().getUri())),
asList(new GridElement(m.getUri(), "Avg shoe size"))
);
definition = md.createObj(project, definition);
Report report = md.createObj(project, new Report(definition.getTitle(), definition));
final DatasetService datasetService = gd.getDatasetService();
final DatasetManifest manifest = datasetService.getDatasetManifest(project, "dataset.person");
datasetService.loadDataset(project, manifest, Example.class.getResourceAsStream("/person.csv")).get();
final ReportService reportService = gd.getReportService();
reportService.exportReport(definition, ReportExportFormat.CSV, new FileOutputStream("report.csv"));
DataStoreService dataStoreService = gd.getDataStoreService();
dataStoreService.upload("/dir/file.txt", new FileInputStream("file.txt"));
InputStream stream = dataStoreService.download("/dir/file.txt");
dataStoreService.delete("/dir/file.txt");
gd.logout();
}
}