How can I test database migrations in Go?

How can I test database migrations in Go?

You can test database migrations in Go by using a testing framework like testing along with a library like gorm or sqlx. Start by creating a test database and applying your migrations there.

What tools do I need for this?

You'll need Go installed, a database like PostgreSQL or MySQL, and a migration library such as golang-migrate or gorm.

Can you show me a code example?

Sure! Here's a simple example using golang-migrate:

package main

import (
    "database/sql"
    "log"
    "github.com/golang-migrate/migrate/v4"
    "github.com/golang-migrate/migrate/v4/database/postgres"
    "github.com/golang-migrate/migrate/v4/source/file"
)

func main() {
    db, err := sql.Open("postgres", "user=youruser dbname=yourdb sslmode=disable")
    if err != nil {
        log.Fatal(err)
    }
    m, err := migrate.New(
        "file://path/to/migrations",
        "postgres://youruser:yourpass@localhost:5432/yourdb?sslmode=disable",
    )
    if err != nil {
        log.Fatal(err)
    }
    if err := m.Up(); err != nil {
        log.Fatal(err)
    }
}

What if I encounter errors during migration?

If you encounter errors, check the migration files for syntax issues, ensure your database connection is correct, and review the logs for specific error messages.