Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/glacials/mainframe. my mainframe.
Something went wrong. Try again.
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061// Package db is a utility library to assist in interacting with SQLite. It is// not an abstraction layer.package db
import ( "database/sql" "fmt" "log"
"github.com/golang-migrate/migrate/v4" "github.com/golang-migrate/migrate/v4/database/sqlite" _ "github.com/golang-migrate/migrate/v4/source/file" _ "github.com/golang-migrate/migrate/v4/source/pkger" _ "modernc.org/sqlite")
// New creates a database connection to the SQLite database at the given path,// migrates the database if necessary, and returns the connection.//// It is the caller's responsibility to call db.Close().func New(logger *log.Logger, name string) (*sql.DB, error) { path := fmt.Sprintf("%s.db", name)
db, err := sql.Open("sqlite", path) if err != nil { return nil, fmt.Errorf("can't open database: %v", err) }
driver, err := sqlite.WithInstance(db, &sqlite.Config{DatabaseName: name}) if err != nil { return nil, fmt.Errorf( "can't create migration driver for %s: %v", path, err, ) }
m, err := migrate.NewWithDatabaseInstance( "pkger:///db/migrations", name, driver, ) if err != nil { return nil, fmt.Errorf("can't set up migrations: %w", err) }
err = m.Up() if err == migrate.ErrNoChange { return db, nil } else if err != nil { return nil, fmt.Errorf("can't migrate database: %v", err) }
version, dirty, err := m.Version() if err != nil { return nil, fmt.Errorf("can't get migration version: %w", err) } logger.Printf("Database migrated to %d (dirty=%t)", version, dirty) return db, nil}