mysqlite/migrator_test.go
Sebastiaan de Schaetzen 0a177e0b46
All checks were successful
Build / build (push) Successful in 1m7s
Allow multi-statement migration scripts
2025-03-12 08:24:27 +01:00

25 lines
584 B
Go

package mysqlite
import (
"embed"
"github.com/stretchr/testify/require"
"testing"
)
//go:embed testMigrations/*.sql
var migrations embed.FS
func TestDb_MigrateDb(t *testing.T) {
db := openEmptyTestDb(t)
err := db.MigrateDb(migrations, "testMigrations")
require.NoError(t, err)
var count int
db.Query("select count(*) from mydata").MustScanSingle(&count)
require.Equal(t, 1, count, "incorrect number of rows in database")
count = 0
db.Query("select count(*) from multiTable").MustScanSingle(&count)
require.Equal(t, 1, count, "incorrect number of rows in database")
}