package repositories_test import ( "fmt" "os" "path/filepath" "testing" "git.eugenetriguba.com/bolt/cli/internal/configloader" "git.eugenetriguba.com/bolt/cli/internal/models" "git.eugenetriguba.com/bolt/cli/internal/repositories" "git.eugenetriguba.com/checkmate/assert" ) func assertFileExists(t *testing.T, path string) { _, err := os.Stat(path) assert.Nil(t, err) } func TestNewMigrationFsRepo_CreatesDirIfNotExists(t *testing.T) { tempDir := t.TempDir() migrationsDir := filepath.Join(tempDir, "migrations") migrationsConfig := configloader.MigrationsConfig{DirectoryPath: migrationsDir} _, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) assertFileExists(t, migrationsDir) } func TestNewMigrationFsRepo_MigrationDirIsFile(t *testing.T) { tempDir := t.TempDir() migrationsDir := filepath.Join(tempDir, "migrations") migrationsConfig := configloader.MigrationsConfig{DirectoryPath: migrationsDir} _, err := os.Create(migrationsDir) assert.Nil(t, err) _, err = repositories.NewMigrationFsRepo(&migrationsConfig) assert.ErrorContains(t, err, "is not a directory") } func TestNewMigrationFsRepo_UnknownStatErr(t *testing.T) { migrationsConfig := configloader.MigrationsConfig{DirectoryPath: "\000x"} _, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.ErrorContains(t, err, "unable to check if migration directory") } func TestCreate_SuccessfullyCreated(t *testing.T) { tempDir := t.TempDir() migrationsConfig := configloader.MigrationsConfig{DirectoryPath: tempDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") err = repo.Create(migration) assert.Nil(t, err) assertFileExists(t, filepath.Join(tempDir, fmt.Sprintf("%s.sql", migration.Name()))) } func TestCreate_FailsToCreateMigration(t *testing.T) { tempDir := t.TempDir() repo, err := repositories.NewMigrationFsRepo( &configloader.MigrationsConfig{DirectoryPath: tempDir}, ) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") _, err = os.OpenFile( filepath.Join(tempDir, fmt.Sprintf("%s.sql", migration.Name())), os.O_CREATE, 0000, ) assert.Nil(t, err) err = repo.Create(migration) assert.NotNil(t, err) assert.ErrorContains(t, err, "unable to create file") } func TestReadUpgradeScript_SuccessfullyRead(t *testing.T) { tempDir := t.TempDir() migrationsConfig := configloader.MigrationsConfig{DirectoryPath: tempDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") err = repo.Create(migration) assert.Nil(t, err) migrationName := fmt.Sprintf("%s.sql", migration.Name()) expectedUpgradeScriptContents := "CREATE TABLE users(id int PRIMARY KEY);\n" os.WriteFile( filepath.Join(tempDir, migrationName), []byte("-- migrate:up\n"+expectedUpgradeScriptContents), 0755, ) upgradeScript, err := repo.ReadUpgradeScript(migration) assert.Nil(t, err) assert.Equal(t, upgradeScript.Contents, string(expectedUpgradeScriptContents)) } func TestReadUpgradeScript_FileDoesNotExist(t *testing.T) { migrationsConfig := configloader.MigrationsConfig{DirectoryPath: t.TempDir()} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") _, err = repo.ReadUpgradeScript(migration) assert.NotNil(t, err) assert.ErrorContains(t, err, "no such file or directory") } func TestReadDowngradeScript_SuccessfullyRead(t *testing.T) { tempDir := t.TempDir() migrationsConfig := configloader.MigrationsConfig{DirectoryPath: tempDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") err = repo.Create(migration) assert.Nil(t, err) migrationName := fmt.Sprintf("%s.sql", migration.Name()) expectedDowngradeScriptContents := "DROP TABLE users;\n" os.WriteFile( filepath.Join(tempDir, migrationName), []byte("-- migrate:down\n"+expectedDowngradeScriptContents), 0755, ) downgradeScript, err := repo.ReadDowngradeScript(migration) assert.Nil(t, err) assert.Equal(t, downgradeScript.Contents, string(expectedDowngradeScriptContents)) } func TestReadDowngradeScript_FileDoesNotExist(t *testing.T) { migrationsConfig := configloader.MigrationsConfig{DirectoryPath: t.TempDir()} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration := models.NewMigration(1, "add users table") _, err = repo.ReadDowngradeScript(migration) assert.NotNil(t, err) assert.ErrorContains(t, err, "no such file or directory") } func TestList_Success(t *testing.T) { tempDir := t.TempDir() migrationsConfig := configloader.MigrationsConfig{DirectoryPath: tempDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration1 := models.NewMigration(1, "migration_1") migration2 := models.NewMigration(2, "migration_2") err = repo.Create(migration1) assert.Nil(t, err) repo.Create(migration2) assert.Nil(t, err) migrations, err := repo.List() assert.Nil(t, err) assert.Equal(t, len(migrations), 2) assert.DeepEqual(t, migrations[migration1.Version], migration1) assert.DeepEqual(t, migrations[migration2.Version], migration2) } func TestList_DirDoesNotExist(t *testing.T) { migrationsDir := filepath.Join(t.TempDir(), "migrations") migrationsConfig := configloader.MigrationsConfig{DirectoryPath: migrationsDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) err = os.RemoveAll(migrationsDir) assert.Nil(t, err) _, err = repo.List() assert.NotNil(t, err) assert.ErrorContains(t, err, "no such file or directory") } func TestList_InvalidMigrationName(t *testing.T) { migrationsDir := filepath.Join(t.TempDir(), "migrations") migrationsConfig := configloader.MigrationsConfig{DirectoryPath: migrationsDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) err = os.Mkdir(filepath.Join(migrationsDir, "invalid"), 0755) assert.Nil(t, err) _, err = repo.List() assert.NotNil(t, err) assert.ErrorContains( t, err, "expected a migration directory of the format _", ) } func TestList_DuplicateMigrationVersion(t *testing.T) { migrationsDir := filepath.Join(t.TempDir(), "migrations") migrationsConfig := configloader.MigrationsConfig{DirectoryPath: migrationsDir} repo, err := repositories.NewMigrationFsRepo(&migrationsConfig) assert.Nil(t, err) migration1 := models.NewMigration(1, "migration_1") migration2 := models.NewMigration(1, "migration_2") err = repo.Create(migration1) assert.Nil(t, err) repo.Create(migration2) assert.Nil(t, err) _, err = repo.List() assert.ErrorIs(t, err, repositories.ErrMigrationVersionConflict) assert.ErrorContains( t, err, "0001_migration_1 and 0001_migration_2 both have version 0001; renumber one of them", ) }