Implement Migration CLI Commands (migrate:generate, migrate:up, migrate:down, migrate:status)

[0xvasanth]

Issue: Implement Migration CLI Commands

Summary

The toasty CLI defines migration commands but they are not implemented. All commands print "TODO: implementation" messages instead of performing the actual migration operations.

Commands Affected

All migration commands are affected:

• toasty migrate:generate
• toasty migrate:up
• toasty migrate:down
• toasty migrate:status

Steps to Reproduce

1. Clone the repository
2. Build the CLI: cargo build --bin toasty
3. Try to generate a migration:

cargo run --bin toasty -- migrate:generate --message "test" --dir ./migrations

Expected Behavior

The command should:

1. Create the migrations directory if it doesn't exist
2. Generate a migration file with up/down SQL
3. Save a schema snapshot

Actual Behavior

The command outputs:

Generating migration: test
Migration directory: ./migrations
✅ Migration generated (TODO: implementation)

But no files are created and no directory is made.

Source Code

In crates/toasty-cli/src/main.rs, all migration commands have TODO placeholders:

Commands::MigrateGenerate { message, dir } => {
    println!("Generating migration: {}", message);
    println!("Migration directory: {}", dir);

    // TODO: Implement migration generation
    // 1. Load current schema snapshot
    // 2. Build schema from current models
    // 3. Detect changes
    // 4. Generate migration file
    // 5. Save new snapshot

    println!("✅ Migration generated (TODO: implementation)");
    Ok(())
}

Context

I'm testing toasty with a user management system (users, roles, permissions) and would like to use the migration system for schema management instead of db.reset_db() which destroys all data.

The toasty-migrate crate appears to have the infrastructure in place:

• SchemaSnapshot
• SchemaDiff
• MigrationGenerator
• MigrationRunner
• MigrationTracker

It just needs to be wired up to the CLI commands.