go install github.com/gopackx/go-migration/cmd/migrator@latest

go-migration --help

go-migration migrate --config=./config/migration.json

go-migration init [--module=MODULE] [--force]

$ go-migration init

Creating project structure...

  Created directories:
    ✓ database/migrations/
    ✓ database/seeders/
    ✓ database/factories/
    ✓ cmd/migrator/

  Created files:
    ✓ cmd/migrator/main.go
    ✓ migration.json

Project initialized successfully!
Run 'go-migration make:migration create_users_table' to create your first migration.

# Initialize a new project (auto-detects module path from go.mod)
go-migration init

# Initialize with a custom module path
go-migration init --module=github.com/myuser/myproject

# Re-initialize and overwrite existing files
go-migration init --force

go-migration migrate [--seed]

# Run all pending migrations
go-migration migrate

# Run migrations then seed the database
go-migration migrate --seed

# Run with a specific config file
go-migration migrate --config=./config/production.yaml

go-migration migrate:rollback [--step=N]

# Roll back the last batch
go-migration migrate:rollback

# Roll back the last 3 migrations
go-migration migrate:rollback --step=3

go-migration migrate:reset [--force]

# Roll back all migrations (will prompt for confirmation)
go-migration migrate:reset

# Roll back all migrations without confirmation
go-migration migrate:reset --force

# Roll back all migrations with a specific config
go-migration migrate:reset --config=./config/staging.yaml

go-migration migrate:refresh [--seed]

# Refresh all migrations
go-migration migrate:refresh

# Refresh and seed
go-migration migrate:refresh --seed

# Refresh with a specific config
go-migration migrate:refresh --config=./config/development.yaml

go-migration migrate:fresh [--force] [--seed]

# Drop all tables and re-migrate (will prompt for confirmation)
go-migration migrate:fresh

# Drop all tables without confirmation
go-migration migrate:fresh --force

# Fresh migration then seed
go-migration migrate:fresh --seed

# Fresh migration with a specific config
go-migration migrate:fresh --config=./config/test.yaml

go-migration migrate:status

+------+----------------------------------------+-------+
| Ran? | Migration                              | Batch |
+------+----------------------------------------+-------+
| Yes  | 20240101_000001_create_users_table      | 1     |
| Yes  | 20240115_000001_create_posts_table      | 1     |
| Yes  | 20240201_000001_add_phone_to_users      | 2     |
| No   | 20240301_000001_create_comments_table   |       |
+------+----------------------------------------+-------+

# Show migration status
go-migration migrate:status

# Show status using a specific config
go-migration migrate:status --config=./config/production.yaml

go-migration migrate:install

# Create the migrations table
go-migration migrate:install

# Create with a specific config
go-migration migrate:install --config=./config/migration.json

go-migration make:migration <name> [--create=TABLE] [--table=TABLE]

# Generate a blank migration
go-migration make:migration create_users_table

# Generate a migration to create a new "users" table
go-migration make:migration create_users_table --create=users

# Generate a migration to modify the "users" table
go-migration make:migration add_email_to_users --table=users

package migrations

import (
    "github.com/gopackx/go-migration/schema"
)

type CreateUsersTable struct{}

func (m *CreateUsersTable) Up(s *schema.Builder) {
    s.Create("users", func(bp *schema.Blueprint) {
        bp.ID()
        // Add columns here
        bp.Timestamps()
    })
}

func (m *CreateUsersTable) Down(s *schema.Builder) {
    s.DropIfExists("users")
}

package migrations

import (
    "github.com/gopackx/go-migration/schema"
)

type AddEmailToUsers struct{}

func (m *AddEmailToUsers) Up(s *schema.Builder) {
    s.Alter("users", func(bp *schema.Blueprint) {
        // Add or modify columns here
    })
}

func (m *AddEmailToUsers) Down(s *schema.Builder) {
    s.Alter("users", func(bp *schema.Blueprint) {
        // Reverse the changes here
    })
}

go-migration make:seeder <name> [--class=CLASS]

# Generate a seeder file
go-migration make:seeder users

# Generate with a custom struct name
go-migration make:seeder users --class=UserSeeder

package seeders

import (
    "database/sql"
)

type UserSeeder struct{}

func (s *UserSeeder) Run(db *sql.DB) error {
    // Seed logic here
    return nil
}

go-migration make:factory <name>

# Generate a factory file
go-migration make:factory users

# Generate a factory for a specific model
go-migration make:factory user_profile

package factories

import (
    "github.com/gopackx/go-migration/seeder/factory"
)

// Users model.
type Users struct {
    // TODO: define model fields
}

// NewUsersFactory creates a factory for Users.
func NewUsersFactory() *factory.Factory[Users] {
    return factory.NewFactory(func(f factory.Faker) Users {
        return Users{
            // TODO: set fields using faker
        }
    })
}

go-migration db:seed [--class=CLASS] [--tag=TAG]

# Run all seeders
go-migration db:seed

# Run a specific seeder
go-migration db:seed --class=UserSeeder

# Run seeders tagged as "development"
go-migration db:seed --tag=development

# Run with a specific config
go-migration db:seed --config=./config/development.yaml

go-migration db:seed:rollback --class=CLASS

# Roll back a specific seeder
go-migration db:seed:rollback --class=UserSeeder

# Roll back with a specific config
go-migration db:seed:rollback --class=UserSeeder --config=./config/development.yaml

go-migration db:seed:truncate --table=TABLE

# Truncate the users table
go-migration db:seed:truncate --table=users

# Truncate with a specific config
go-migration db:seed:truncate --table=posts --config=./config/development.yaml