entities

type DatabaseRepo interface {
	CreateMigrationTableIfNotExists() error
	GetLastAppliedMigrationFromDatabase() (*MigrationEntry, error)
	ApplyMigration(migration *SqlMigration) error
	GetMigrationEntries() (*[]MigrationEntry, error)
	DeleteMigrationTable() error
}

type DatabaseType int

type FileSystemRepo interface {
	RootFolder() string
	Extention() string

	MkAlldirIfnotExists(paths []string) error
	CreateFilesInDirectories(directoryList []string, fileNames []string) error
	GetFilesFromDirectory(directory string) ([]string, error)
	LoadMigrationsFromFiles(MigrationType, []string) (*[]SqlMigration, error)
	RemoveFilesFromDirectories(directoryList []string, fileNames []string) error

	FillMigrationFile(MigrationType, string, string) error
}

type MigrationEntry struct {
	Name    string
	MigType MigrationType
	Created time.Time
}

type MigrationType string

type MigratorConfig struct {
	Database  int
	Extention string
	Migrator  MigratorService
}

type MigratorService interface {
	// MigrateUp(0) will run all migrations
	// MigrateUp(2) will run next 2 migrations
	MigrateUp(int) error
	// MigrateDown(0) will run all down migrations
	// MigrateDown(2) will run next 2 migrations
	MigrateDown(int) error
	DeleteMigrationTable() error
	GetMigrationEntries() (*[]MigrationEntry, error)
}

type SqlMigration struct {
	Name  string
	Query string
	Type  MigrationType
}