Spaces:
Sleeping
Sleeping
File size: 2,506 Bytes
f5957a1 | 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 | import {
Controller,
Get,
Post,
UseGuards,
} from '@nestjs/common';
import {
ApiTags,
ApiBearerAuth,
ApiOperation,
ApiResponse,
} from '@nestjs/swagger';
import { JwtAuthGuard } from '../../auth/guards/jwt-auth.guard';
import { RolesGuard } from '../../auth/guards/roles.guard';
import { Roles } from '../../../common/decorators/roles.decorator';
import { RoleName } from '../../auth/entities/role.entity';
import { DatabaseService } from '../services/database.service';
@ApiTags('🗄️ Database')
@ApiBearerAuth('JWT-auth')
@Controller('api/database')
@UseGuards(JwtAuthGuard, RolesGuard)
export class DatabaseController {
constructor(private readonly databaseService: DatabaseService) {}
@Get('status')
@Roles(RoleName.ADMIN, RoleName.IT_ADMIN)
@ApiOperation({
summary: 'Get database status',
description:
'Returns MySQL server uptime, connected threads, and version. ' +
'Access roles: ADMIN, IT_ADMIN. Uses: MySQL SHOW GLOBAL STATUS queries.',
})
@ApiResponse({ status: 200, description: 'Database status returned' })
@ApiResponse({ status: 401, description: 'Unauthorized' })
@ApiResponse({ status: 403, description: 'Forbidden – insufficient role' })
async getStatus() {
return this.databaseService.getStatus();
}
@Get('tables')
@Roles(RoleName.ADMIN, RoleName.IT_ADMIN)
@ApiOperation({
summary: 'Get database table sizes',
description:
'Returns information about all tables including row count, data size, index size. ' +
'Access roles: ADMIN, IT_ADMIN. Uses: `information_schema.TABLES`.',
})
@ApiResponse({ status: 200, description: 'Table size information returned' })
@ApiResponse({ status: 401, description: 'Unauthorized' })
@ApiResponse({ status: 403, description: 'Forbidden – insufficient role' })
async getTables() {
return this.databaseService.getTables();
}
@Post('optimize')
@Roles(RoleName.IT_ADMIN)
@ApiOperation({
summary: 'Optimize all database tables',
description:
'Runs OPTIMIZE TABLE on every table in the database to reclaim space and defragment. ' +
'Access roles: IT_ADMIN. Uses: MySQL OPTIMIZE TABLE command on all tables.',
})
@ApiResponse({ status: 200, description: 'Optimization results returned' })
@ApiResponse({ status: 401, description: 'Unauthorized' })
@ApiResponse({ status: 403, description: 'Forbidden – insufficient role' })
async optimizeDatabase() {
return this.databaseService.optimizeDatabase();
}
}
|