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
|
import define from '../define';
import { NoteReactions, Notes, Users } from '../../../models';
import { federationChart, driveChart } from '../../../services/chart';
export const meta = {
requireCredential: false as const,
tags: ['meta'],
params: {
},
res: {
type: 'object' as const,
optional: false as const, nullable: false as const,
properties: {
notesCount: {
type: 'number' as const,
optional: false as const, nullable: false as const,
description: 'The count of all (local/remote) notes of this instance.',
},
originalNotesCount: {
type: 'number' as const,
optional: false as const, nullable: false as const,
description: 'The count of all local notes of this instance.',
},
usersCount: {
type: 'number' as const,
optional: false as const, nullable: false as const,
description: 'The count of all (local/remote) accounts of this instance.',
},
originalUsersCount: {
type: 'number' as const,
optional: false as const, nullable: false as const,
description: 'The count of all local accounts of this instance.',
},
instances: {
type: 'number' as const,
optional: false as const, nullable: false as const,
description: 'The count of federated instances.',
},
driveUsageLocal: {
type: 'number' as const,
optional: false as const, nullable: false as const
},
driveUsageRemote: {
type: 'number' as const,
optional: false as const, nullable: false as const
}
}
}
};
export default define(meta, async () => {
const [
notesCount,
originalNotesCount,
usersCount,
originalUsersCount,
reactionsCount,
//originalReactionsCount,
instances,
driveUsageLocal,
driveUsageRemote
] = await Promise.all([
Notes.count({ cache: 3600000 }), // 1 hour
Notes.count({ where: { userHost: null }, cache: 3600000 }),
Users.count({ cache: 3600000 }),
Users.count({ where: { host: null }, cache: 3600000 }),
NoteReactions.count({ cache: 3600000 }), // 1 hour
//NoteReactions.count({ where: { userHost: null }, cache: 3600000 }),
federationChart.getChart('hour', 1, null).then(chart => chart.instance.total[0]),
driveChart.getChart('hour', 1, null).then(chart => chart.local.totalSize[0]),
driveChart.getChart('hour', 1, null).then(chart => chart.remote.totalSize[0]),
]);
return {
notesCount,
originalNotesCount,
usersCount,
originalUsersCount,
reactionsCount,
//originalReactionsCount,
instances,
driveUsageLocal,
driveUsageRemote
};
});
|