directus

1
import { useEnv } from '@directus/env';
2
import { SchemaHelper } from '../types.js';
3

4
const env = useEnv();
5

6
export class SchemaHelperPostgres extends SchemaHelper {
7
	override async getDatabaseSize(): Promise<number | null> {
8
		try {
9
			const result = await this.knex.select(this.knex.raw(`pg_database_size(?) as size;`, [env['DB_DATABASE']]));
10

11
			return result[0]?.['size'] ? Number(result[0]?.['size']) : null;
12
		} catch {
13
			return null;
14
		}
15
	}
16
}
17