How can I log errors during SQL migrations in Go?

How can I log errors during SQL migrations in Go?

You can use the log package in Go to log errors. Wrap your migration code in a function and log any errors that occur.

Can you show me a code example?

Sure! Here's a simple example:

package main

import (
    "database/sql"
    "log"
)

func migrate(db *sql.DB) {
    _, err := db.Exec("CREATE TABLE IF NOT EXISTS users (id INT PRIMARY KEY, name TEXT)")
    if err != nil {
        log.Printf("Migration failed: %v", err)
    }
}

What if I want to log to a file instead of the console?

You can set up a log file by using os.OpenFile to create or open a log file and then set it as the output for the log package.

Thanks! Is there a way to include timestamps in the logs?

Yes! You can customize the log format using log.SetFlags(log.Ldate | log.Ltime) to include timestamps.