migration

type Config struct {
	MigrationsDir string
	DBType        string
	Verbose       bool
	DryRun        bool
}

type DatabaseDriver interface {
	MigrationTracker
	// ExecuteMigration executes a migration file
	ExecuteMigration(migrationFile string, isUp bool) error
	// GetDBType returns the database type (postgres, mongo)
	GetDBType() string
}

type Manager struct {
	Driver DatabaseDriver
	Config *Config
}

type Migration struct {
	Version   int64
	Name      string
	UpFile    string
	DownFile  string
	Applied   bool
	AppliedAt *time.Time
}

type MigrationTracker interface {
	// Initialize creates the tracking table/collection if it doesn't exist
	Initialize() error
	// GetAppliedMigrations returns all applied migration versions
	GetAppliedMigrations() ([]int64, error)
	// MarkMigrationApplied marks a migration as applied
	MarkMigrationApplied(version int64) error
	// MarkMigrationReverted removes a migration from applied list
	MarkMigrationReverted(version int64) error
	// GetCurrentVersion returns the latest applied migration version
	GetCurrentVersion() (int64, error)
	// Close closes the database connection
	Close() error
}

type MongoDriver struct {
	// contains filtered or unexported fields
}

type PostgresDriver struct {
	// contains filtered or unexported fields
}

type SchemaMigration struct {
	Version   int64     `bson:"version"`
	AppliedAt time.Time `bson:"applied_at"`
}