-
Notifications
You must be signed in to change notification settings - Fork 2
/
saveSamples.ts
91 lines (74 loc) · 2.57 KB
/
saveSamples.ts
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
import config from 'config'
import OrchestratorApi from '../../index'
import { excel2json } from 'excel-csv-read-write'
async function main() {
const api = new OrchestratorApi(config)
try {
// まずは認証
await api.authenticate()
let instances: any[] = []
let r: any
instances = await api.machine.findAll()
await api.machine.save2Excel(instances, 'machines.xlsx')
r = await excel2json('machines.xlsx')
console.table(r)
instances = await api.robot.findAll()
await api.robot.save2Excel(instances, 'robots.xlsx')
r = await excel2json('robots.xlsx')
console.table(r)
instances = await api.release.findAll()
await api.release.save2Excel(instances, 'releases.xlsx')
r = await excel2json('releases.xlsx')
console.table(r)
instances = await api.process.findAll()
await api.process.save2Excel(instances, 'processes.xlsx')
r = await excel2json('processes.xlsx')
console.table(r)
instances = await api.library.findAll()
await api.library.save2Excel(instances, 'libraries.xlsx')
r = await excel2json('libraries.xlsx')
console.table(r)
instances = await api.job.findAllEx()
await api.job.save2Excel(instances, 'jobs.xlsx')
r = await excel2json('jobs.xlsx')
console.table(r)
instances = await api.user.findAll()
await api.user.save2Excel(instances, 'users.xlsx')
r = await excel2json('users.xlsx')
console.table(r)
instances = await api.asset.findAllEx()
await api.asset.save2Excel(instances, 'assets.xlsx')
r = await excel2json('assets.xlsx')
console.table(r)
instances = await api.setting.findAll()
await api.setting.save2Excel(instances, 'settings.xlsx')
r = await excel2json('settings.xlsx')
console.table(r)
// instances = await api.schedule.findAll()
instances = await api.queueDefinition.findAll()
await api.queueDefinition.save2Excel(instances, 'queueDefinitions.xlsx')
r = await excel2json('queueDefinitions.xlsx')
console.table(r)
// instances = await api.queueItem.findAll()
instances = await api.log.findStartEndLogs({
from: new Date('2020/03/02 00:00'),
// to: new Date('2020/03/03 00:00'),
})
await api.log.save2Excel(instances, 'logs.xlsx')
instances = await api.auditLog.findByFilter(
{
from: new Date('2020/03/07 01:00'),
// to: new Date('2020/03/07 01:45'),
},
{ $top: 100 },
)
await api.auditLog.save2Excel(instances, 'auditLog.xlsx')
} catch (error) {
console.log(error)
}
}
if (!module.parent) {
(async () => {
await main()
})()
}