Миграции

public static function init(string $basePath): void

DatabaseManager::init('/path/to/project');
// Создаёт:
//   /path/to/project/database/migrations/
//   /path/to/project/database/seeders/
//   /path/to/project/database/factories/

public static function migrate(): int

$count = DatabaseManager::migrate();
echo "Выполнено миграций: {$count}\n";

public static function rollback(int $steps = 1): int

// Откатить последнюю миграцию
DatabaseManager::rollback();

// Откатить последние 3 миграции
DatabaseManager::rollback(3);

public static function seed(?string $seederClass = null): int

// Один сидер
DatabaseManager::seed(UserSeeder::class);

// Все сидеры
DatabaseManager::seed();

public static function factory(string $factoryClass, int $count = 1): array

// Генерация 10 записей
$users = DatabaseManager::factory(UserFactory::class, 10);

// Генерация 1 записи
$user = DatabaseManager::factory(UserFactory::class);

abstract public function up(): void

public function up(): void
{
    $this->createTable('users', function (TableBuilder $table): void {
        $table->bigIncrements('pkid');
        $table->string('login', 50);
        $table->string('name', 100);
        $table->timestamps();
    });
}

abstract public function down(): void

public function down(): void
{
    $this->dropTable('users');
}

protected function createTable(string $name, callable $callback): void

$this->createTable('users', function (TableBuilder $table): void {
    $table->bigIncrements('pkid');
    $table->string('login', 50);
    $table->string('name', 100);
    $table->string('email', 100)->nullable();
    $table->string('password_hash', 255);
    $table->boolean('active')->default(true);
    $table->string('role', 20)->default('user');
    $table->timestamps();
});

protected function dropTable(string $name): void

$this->dropTable('users');

public function __construct(string $name)

public function bigIncrements(string $name): self

$table->bigIncrements('pkid');

public function increments(string $name): self

$table->increments('id');

public function integer(string $name): self

$table->integer('age');

public function bigInteger(string $name): self

$table->bigInteger('user_id');

public function string(string $name, int $length = 255): self

$table->string('login', 50);
$table->string('name');             // длина 255 по умолчанию
$table->string('email', 100)->nullable();

public function text(string $name): self

$table->text('description');

public function boolean(string $name): self

$table->boolean('active')->default(true);

public function decimal(string $name, int $precision = 8, int $scale = 2): self

$table->decimal('price', 10, 2);     // 99999999.99
$table->decimal('total', 8, 2);      // 999999.99
$table->decimal('weight');            // 999999.99 (по умолчанию)

public function date(string $name): self

$table->date('birthday');

public function dateTime(string $name): self

$table->dateTime('published_at');

public function timestamps(): self

$table->timestamps();
// Эквивалентно:
// $table->dateTime('created_at')->nullable();
// $table->dateTime('updated_at')->nullable();

public function json(string $name): self

$table->json('metadata');
$table->json('settings')->nullable();

public function default($value): self

$table->boolean('active')->default(true);
$table->string('role', 20)->default('user');
$table->integer('status')->default(0);
$table->text('description')->default('');

public function nullable(): self

$table->string('email', 100)->nullable();
$table->dateTime('deleted_at')->nullable();
$table->text('notes')->nullable();

public function create(): void

<?php
use IO\Database\Migration;

class CreateUsersTable extends Migration
{
    public function up(): void
    {
    $this->createTable('users', function (TableBuilder $table): void {
        $table->bigIncrements('pkid');
        $table->string('login', 50);
        $table->string('name', 100);
        $table->string('email', 100)->nullable();
        $table->string('password_hash', 255);
        $table->boolean('active')->default(true);
        $table->string('role', 20)->default('user');
        $table->timestamps();
    });
}

public function down(): void
{
    $this->dropTable('users');
}

<?php
use IO\Database\Migration;

class CreateOrdersTable extends Migration
{
    public function up(): void
    {
        $this->createTable('orders', function (TableBuilder $table): void {
            $table->bigIncrements('pkid');
            $table->bigInteger('user_id');
            $table->decimal('total', 10, 2);
            $table->string('status', 20)->default('pending');
            $table->json('items')->nullable();
            $table->timestamps();
        });

        // Добавить индексы
        \IO\Database\SqlConnection::connection()
            ->getSchemaBuilder()
            ->table('orders', function (\Illuminate\Database\Schema\Blueprint $table): void {
                $table->index('user_id');
                $table->index('status');
            });
    }

    public function down(): void
    {
        $this->dropTable('users');
    }
}

<?php
use IO\Database\Migration;

class CreateOrdersTable extends Migration
{
    public function up(): void
    {
        $this->createTable('orders', function (TableBuilder $table): void {
            $table->bigIncrements('pkid');
            $table->bigInteger('user_id');
            $table->decimal('total', 10, 2);
            $table->string('status', 20)->default('pending');
            $table->json('items')->nullable();
            $table->timestamps();
        });

        // Добавить индексы
        \IO\Database\SqlConnection::connection()
            ->getSchemaBuilder()
            ->table('orders', function (\Illuminate\Database\Schema\Blueprint $table): void {
                $table->index('user_id');
                $table->index('status');
            });
    }

    public function down(): void
    {
        $this->dropTable('orders');
    }
}

<?php
use IO\Database\Migration;
use IO\Database\SqlConnection;

class AddPhoneToUsersTable extends Migration
{
    public function up(): void
    {
        SqlConnection::connection()->getSchemaBuilder()
            ->table('users', function (\Illuminate\Database\Schema\Blueprint $table): void {
                $table->string('phone', 20)->nullable()->after('email');
            });
    }

    public function down(): void
    {
        SqlConnection::connection()->getSchemaBuilder()
            ->table('users', function (\Illuminate\Database\Schema\Blueprint $table): void {
                $table->dropColumn('phone');
            });
    }
}

<?php
use IO\Database\Migration;

class CreateArticlesTable extends Migration
{
    public function up(): void
    {
        $this->createTable('articles', function (TableBuilder $table): void {
            $table->bigIncrements('pkid');
            $table->bigInteger('author_id');
            $table->string('title', 255);
            $table->string('slug', 255);
            $table->text('body');
            $table->json('tags')->nullable();
            $table->string('status', 20)->default('draft');
            $table->dateTime('published_at')->nullable();
            $table->timestamps();
        });

        \IO\Database\SqlConnection::connection()
            ->getSchemaBuilder()
            ->table('articles', function (\Illuminate\Database\Schema\Blueprint $table): void {
                $table->index('author_id');
                $table->index('status');
                $table->unique('slug');
            });
    }

    public function down(): void
    {
        $this->dropTable('articles');
    }
}

use IO\Database\DatabaseManager;

// Инициализация
DatabaseManager::init('/path/to/project');

// Выполнить все миграции
$count = DatabaseManager::migrate();
echo "Выполнено: {$count}\n";

// Откатить последние 3
DatabaseManager::rollback(3);

// Выполнить сидер
DatabaseManager::seed(UserSeeder::class);

// Сгенерировать данные
$users = DatabaseManager::factory(UserFactory::class, 100);

$files = glob(DatabaseManager::getMigrationsPath() . '/*.php');
sort($files);
foreach ($files as $file) {
    echo basename($file) . "\n";
}

public function up(): void
{
    // PostgreSQL
    SqlConnection::connection()->getSchemaBuilder()
        ->table('users', function (\Illuminate\Database\Schema\Blueprint $table): void {
            $table->renameColumn('old_name', 'new_name');
        });
}

public function up(): void
{
    SqlConnection::connection()->getSchemaBuilder()
        ->table('users', function (\Illuminate\Database\Schema\Blueprint $table): void {
            $table->index('email');
            $table->unique('login');
        });
}

// Через named connection
SqlConnection::connection('mysql_replica')->getSchemaBuilder()
    ->table('users', function (\Illuminate\Database\Schema\Blueprint $table): void {
        $table->index('email');
    });

public static function create_app(): \IO\App
{
    $app = new \IO\App();
    $app->add_modules([
        \IO\Module::class,       // modules/io7/php/ → IO\
        \App\Module::class,      // app/ → App\
        \Crm\Module::class,      // modules/crm/ → Crm\
    ]);
    $app->init();
    return $app;
}

if (self::hasTable('migrations')) return;

$this->createTableIfNotExists('users', function ($table) {
    $table->bigIncrements('pkid');
    $table->string('name');
});

if (self::hasTable('migrations')) return;
if (!self::hasColumn('users', 'avatar')) { /* add column */ }
if (!self::hasIndex('users', 'idx_email')) { /* add index */ }

public function up(): void
{
    $this->updateTable('users', function ($table) {
        $table->string('avatar', 255)->nullable();
        $table->boolean('is_active')->default(true);
        $table->timestamps();
    });
}

// Удалить таблицу
$this->dropTable('old_users');

// Переименовать таблицу
$this->renameTable('users', 'accounts');

public function up(): void
{
    $this->updateTable('users', function ($table) {
        // Добавить столбец
        $table->string('avatar')->nullable();

        // Удалить столбец
        $table->dropColumn('legacy_field');

        // Удалить несколько столбцов
        $table->dropColumns(['old_col1', 'old_col2']);

        // Переименовать столбец
        $table->renameColumn('old_name', 'new_name');
    });
}

public function up(): void
{
    $this->renameTable('users', 'accounts');
}

public function down(): void
{
    $this->renameTable('accounts', 'users');
}