summaryrefslogtreecommitdiff
path: root/packages/backend/src/server/api/endpoints/admin/vacuum.ts
blob: 0546acfacbd1f7472a238eab9b2c18bc4da47e15 (plain)
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
import define from '../../define.js';
import { insertModerationLog } from '@/services/insert-moderation-log.js';
import { db } from '@/db/postgre.js';

export const meta = {
	tags: ['admin'],

	requireCredential: true,
	requireModerator: true,
} as const;

export const paramDef = {
	type: 'object',
	properties: {
		full: { type: 'boolean' },
		analyze: { type: 'boolean' },
	},
	required: ['full', 'analyze'],
} as const;

// eslint-disable-next-line import/no-default-export
export default define(meta, paramDef, async (ps, me) => {
	const params: string[] = [];

	if (ps.full) {
		params.push('FULL');
	}

	if (ps.analyze) {
		params.push('ANALYZE');
	}

	db.query('VACUUM ' + params.join(' '));

	insertModerationLog(me, 'vacuum', ps);
});