Database

use app\Ngorei;
$Tds = new Ngorei();
$Tds->createDatabase('nama_database', [
    'charset' => 'utf8mb4',
    'collate' => 'utf8mb4_unicode_ci'
]);

DB_HOST=localhost
DB_NAME=exsampel
DB_USER=root
DB_PASS=12345678
DB_PORT=3306
DB_CHARSET=utf8mb4

// Membuat instance Ngorei
$Tds = new Ngorei();
try {
    $db =$Tds->Network->Brief('demo');
    $connectionInfo = $db->testConnection();
    print_r($connectionInfo);
} catch (\RuntimeException $e) {
    echo "Error: " . $e->getMessage();
}

// Definisi kolom
$columns = [
    [
        'name' => 'id',
        'type' => 'INT',
        'unsigned' => true,
        'auto_increment' => true,
        'primary' => true
    ]
    [
        'name' => 'email',
        'type' => 'VARCHAR',
        'length' => 255,
        'unique' => true
    ],
    [
        'name' => 'created_at',
        'type' => 'TIMESTAMP',
        'default' => 'CURRENT_TIMESTAMP'
    ]
];

// Opsi tabel
$options = [
    'engine' => 'InnoDB',
    'charset' => 'utf8mb4',
    'collate' => 'utf8mb4_unicode_ci',
    'comment' => 'Tabel untuk menyimpan data pengguna'
];

// Buat tabel
$Tds->createTable('users', $columns, $options);

// Menambah kolom baru
$Tds->tableOperation('users', 'ALTER', [
    'alterations' => [
        [
            'type' => 'ADD COLUMN',
            'definition' => 'phone VARCHAR(20) AFTER email'
        ],
        [
            'type' => 'MODIFY COLUMN',
            'definition' => 'name VARCHAR(150) NOT NULL'
        ]
    ]
]);

// Menambah index
$Tds->tableOperation('users', 'ALTER', [
    'alterations' => [
        [
            'type' => 'ADD INDEX',
            'definition' => 'idx_name (name)'
        ],
        [
            'type' => 'ADD UNIQUE INDEX',
            'definition' => 'unq_email (email)'
        ]
    ]
]);

// Menghapus index
$Tds->tableOperation('users', 'ALTER', [
    'alterations' => [
        [
            'type' => 'DROP INDEX',
            'definition' => 'idx_name'
        ]
    ]
]);

// Menampilkan struktur tabel
$structure = $Tds->getTableStructure('nama_tabel');

// Mengkloning tabel
$Tds->cloneTable('tabel_sumber', 'tabel_target');

// Mengosongkan tabel
$Tds->truncateTable('nama_tabel');

// Menghapus tabel
$Tds->dropTable('nama_tabel');

$Tds = new Ngorei();
$tables = $Tds->showTables();

$columns = [
    [
        'name' => 'id',
        'type' => 'INT',
        'unsigned' => true,
        'auto_increment' => true,
        'primary' => true
    ],
    [
        'name' => 'name',
        'type' => 'VARCHAR',
        'length' => 100,
        'nullable' => false
    ]
];

$options = [
    'engine' => 'InnoDB',
    'charset' => 'utf8mb4',
    'collate' => 'utf8mb4_unicode_ci'
];

$Tds->createTable('users', $columns, $options);

// Truncate table
$Tds->tableOperation('users', 'TRUNCATE');

// Rename table
$Tds->tableOperation('old_name', 'RENAME', ['new_name' => 'new_name']);

// Backup table
$Tds->tableOperation('users', 'BACKUP', ['backup_name' => 'users_backup']);

// Optimasi satu tabel
$Tds->optimizeTable('users');

// Optimasi semua tabel
$Tds->optimizeTable();

$analysis = $Tds->analyzeTableStructure('users');

$Tds->databaseMaintenance([
    'check_tables' => true,
    'optimize' => true,
    'analyze' => true,
    'clean_temp' => true
]);

// Backup database
$backup = $Tds->backupDatabase([
    'tables' => ['users', 'products'],
    'compress' => true
]);

// Restore database
$restore = $Tds->restoreDatabase('backup_file.sql', [
    'skip_errors' => false,
    'transaction' => true
]);

$metrics = $Tds->monitorPerformance();

$stats = $Tds->getTableStatistics('users');

$Tds->sqlView('CREATE', 'active_users', [
    'query' => "SELECT * FROM users WHERE status = 'active'",
    'algorithm' => 'MERGE',
    'security' => 'DEFINER'
]);

// Mengubah view
$Tds->sqlView('ALTER', 'active_users', [
    'query' => "SELECT id, name FROM users WHERE status = 'active'"
]);

// Menghapus view
$Tds->sqlView('DROP', 'active_users');

// Melihat definisi view
$Tds->sqlView('SHOW', 'active_users');

// Melihat daftar view
$Tds->sqlView('LIST', '');