App\Console\Commands\UpdateNNTmuxDB

Complexity

Total Complexity

50

Size/Duplication

Total Lines	323
Duplicated Lines	0 %

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	handleRollback()	0	23	4
A	createPostgresBackup()	0	18	4
A	optimizePostgres()	0	7	2
A	optimizeDatabase()	0	12	4
B	handle()	0	48	7
A	checkDatabaseConnection()	0	28	4
B	createMysqlCompatibleBackup()	0	30	10
A	optimizeMysqlCompatible()	0	18	3
A	runMigrations()	0	15	3
A	checkMigrationStatus()	0	4	1
A	createDatabaseBackup()	0	25	5
A	runSeeders()	0	15	3

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

class UpdateNNTmuxDB extends Command
{
    /**
     * The name and signature of the console command.
     */
    protected $signature = 'nntmux:db
                            {--seed : Run database seeders after migration}
                            {--rollback= : Rollback the last N migrations}
                            {--check : Check migration status without running}';

    /**
     * The console command description.
     */
    protected $description = 'Update NNTmux database with enhanced safety and performance';

    /**
     * Execute the console command.
     */
    public function handle(): int
    {
        try {
            $this->info('🗄️ Starting database update process...');

            // Check database connection and detect database type
            $dbType = $this->checkDatabaseConnection();
            if (!$dbType) {
                $this->error('Database connection failed');
                return Command::FAILURE;
            }

            // Handle rollback if requested
            if ($this->option('rollback')) {
                return $this->handleRollback();
            }

            // Check migration status if requested
            if ($this->option('check')) {
                return $this->checkMigrationStatus();
            }

            // Backup database before migration (in production)
            if (app()->environment('production')) {

The method environment() does not exist on Illuminate\Container\Container. Are you sure you never get this type here, but always one of the subclasses?

                $this->info('📋 Creating database backup...');
                $this->createDatabaseBackup($dbType);
            }

            // Run migrations
            $this->info('🔄 Running database migrations...');
            $this->runMigrations();

            // Run seeders if requested
            if ($this->option('seed')) {
                $this->info('🌱 Running database seeders...');
                $this->runSeeders();
            }

            // Optimize database
            $this->info('⚡ Optimizing database...');
            $this->optimizeDatabase($dbType);

            $this->info('✅ Database update completed successfully');
            return Command::SUCCESS;

        } catch (\Exception $e) {
            $this->error('❌ Database update failed: ' . $e->getMessage());
            return Command::FAILURE;
        }
    }

    /**
     * Check database connection and return database type
     */
    private function checkDatabaseConnection(): ?string
    {
        try {
            DB::connection()->getPdo();

            $dbConfig = config('database.connections.' . config('database.default'));
            $driver = $dbConfig['driver'] ?? null;

            // Detect actual database type for MySQL-compatible drivers
            if (in_array($driver, ['mysql', 'mariadb'])) {
                $version = DB::select('SELECT VERSION() as version')[0]->version;

                if (str_contains(strtolower($version), 'mariadb')) {
                    $actualType = 'mariadb';
                } else {
                    $actualType = 'mysql';
                }

                $this->line("  ✓ Database connection established ($actualType $version)");
                return $actualType;
            }

            $this->line("  ✓ Database connection established ($driver)");
            return $driver;

        } catch (\Exception $e) {
            $this->error('  ✗ Database connection failed: ' . $e->getMessage());
            return null;
        }
    }

    /**
     * Handle migration rollback
     */
    private function handleRollback(): int
    {
        $steps = (int) $this->option('rollback');

        if ($steps <= 0) {
            $this->error('Invalid rollback steps. Must be a positive integer.');
            return Command::FAILURE;
        }

        $this->warn("⚠️ Rolling back $steps migrations...");

        if (!$this->confirm('Are you sure you want to rollback migrations? This may cause data loss.')) {
            $this->info('Rollback cancelled');
            return Command::SUCCESS;
        }

        $exitCode = $this->call('migrate:rollback', ['--step' => $steps]);

        if ($exitCode === 0) {
            $this->info("✅ Successfully rolled back $steps migrations");
        }

        return $exitCode;
    }

    /**
     * Check migration status
     */
    private function checkMigrationStatus(): int
    {
        $this->info('📊 Migration Status:');
        return $this->call('migrate:status');
    }

    /**
     * Create database backup with proper driver detection
     */
    private function createDatabaseBackup(string $dbType): void
    {
        try {
            $backupPath = storage_path('backups');

            if (!is_dir($backupPath)) {
                mkdir($backupPath, 0755, true);
            }

            $timestamp = now()->format('Y-m-d_H-i-s');
            $filename = "nntmux_backup_{$timestamp}.sql";
            $fullPath = $backupPath . '/' . $filename;

            $dbConfig = config('database.connections.' . config('database.default'));

            if (in_array($dbType, ['mysql', 'mariadb'])) {
                $this->createMysqlCompatibleBackup($dbConfig, $fullPath, $dbType);
            } elseif ($dbType === 'pgsql') {
                $this->createPostgresBackup($dbConfig, $fullPath);
            } else {
                $this->warn("  ⚠ Backup not supported for database type: $dbType");
            }

        } catch (\Exception $e) {
            $this->warn('  ⚠ Backup creation failed: ' . $e->getMessage());
        }
    }

    /**
     * Create backup for MySQL/MariaDB
     */
    private function createMysqlCompatibleBackup(array $dbConfig, string $fullPath, string $dbType): void
    {
        $command = sprintf(
            '%s -h%s -P%s -u%s %s %s > %s 2>/dev/null',
            $dbType === 'mariadb' ? 'mariadb-dump' : 'mysqldump',
            escapeshellarg($dbConfig['host']),
            escapeshellarg($dbConfig['port']),
            escapeshellarg($dbConfig['username']),
            !empty($dbConfig['password']) ? '-p' . escapeshellarg($dbConfig['password']) : '',
            escapeshellarg($dbConfig['database']),
            escapeshellarg($fullPath)
        );

        exec($command, $output, $returnVar);

        if ($returnVar === 0 && file_exists($fullPath) && filesize($fullPath) > 0) {
            $this->line("  ✓ $dbType backup created: " . basename($fullPath));
        } else {
            // Fallback to mysqldump if mariadb-dump failed
            if ($dbType === 'mariadb') {
                $fallbackCommand = str_replace('mariadb-dump', 'mysqldump', $command);
                exec($fallbackCommand, $output, $returnVar);

                if ($returnVar === 0 && file_exists($fullPath) && filesize($fullPath) > 0) {
                    $this->line("  ✓ MySQL backup created (fallback): " . basename($fullPath));
                } else {
                    $this->warn('  ⚠ Backup creation failed');
                }
            } else {
                $this->warn('  ⚠ Backup creation failed');
            }
        }
    }

    /**
     * Create backup for PostgreSQL
     */
    private function createPostgresBackup(array $dbConfig, string $fullPath): void
    {
        $command = sprintf(
            'PGPASSWORD=%s pg_dump -h %s -p %s -U %s %s > %s 2>/dev/null',
            escapeshellarg($dbConfig['password']),
            escapeshellarg($dbConfig['host']),
            escapeshellarg($dbConfig['port']),
            escapeshellarg($dbConfig['username']),
            escapeshellarg($dbConfig['database']),
            escapeshellarg($fullPath)
        );

        exec($command, $output, $returnVar);

        if ($returnVar === 0 && file_exists($fullPath) && filesize($fullPath) > 0) {
            $this->line("  ✓ PostgreSQL backup created: " . basename($fullPath));
        } else {
            $this->warn('  ⚠ PostgreSQL backup creation failed');
        }
    }

    /**
     * Run database migrations
     */
    private function runMigrations(): void
    {
        $migrateOptions = [];

        if (app()->environment('production')) {
            $migrateOptions['--force'] = true;
        }

        $exitCode = $this->call('migrate', $migrateOptions);

        if ($exitCode !== 0) {
            throw new \Exception('Migration failed');
        }

        $this->line('  ✓ Migrations completed successfully');
    }

    /**
     * Run database seeders
     */
    private function runSeeders(): void
    {
        $seedOptions = [];

        if (app()->environment('production')) {
            $seedOptions['--force'] = true;
        }

        $exitCode = $this->call('db:seed', $seedOptions);

        if ($exitCode !== 0) {
            throw new \Exception('Seeding failed');
        }

        $this->line('  ✓ Seeders completed successfully');
    }

    /**
     * Optimize database tables with proper driver detection
     */
    private function optimizeDatabase(string $dbType): void
    {
        try {
            if (in_array($dbType, ['mysql', 'mariadb'])) {
                $this->optimizeMysqlCompatible($dbType);
            } elseif ($dbType === 'pgsql') {
                $this->optimizePostgres();
            } else {
                $this->line("  ℹ Database optimization skipped (unsupported type: $dbType)");
            }
        } catch (\Exception $e) {
            $this->warn('  ⚠ Database optimization failed: ' . $e->getMessage());
        }
    }

    /**
     * Optimize MySQL/MariaDB tables
     */
    private function optimizeMysqlCompatible(string $dbType): void
    {
        $dbConfig = config('database.connections.' . config('database.default'));
        $tables = DB::select('SHOW TABLES');
        $tableKey = 'Tables_in_' . $dbConfig['database'];

        $optimizedCount = 0;
        foreach ($tables as $table) {
            $tableName = $table->$tableKey;
            try {
                DB::statement("OPTIMIZE TABLE `$tableName`");
                $optimizedCount++;
            } catch (\Exception $e) {
                $this->warn("    ⚠ Failed to optimize table: $tableName");
            }
        }

        $this->line("  ✓ $dbType tables optimized ($optimizedCount/" . count($tables) . ")");
    }

    /**
     * Optimize PostgreSQL database
     */
    private function optimizePostgres(): void
    {
        try {
            DB::statement('VACUUM ANALYZE');
            $this->line('  ✓ PostgreSQL database optimized (VACUUM ANALYZE)');
        } catch (\Exception $e) {
            $this->warn('  ⚠ PostgreSQL optimization failed: ' . $e->getMessage());
        }
    }
}