go/mirko: add SQL migrations machinery
This uses github.com/golang-migrate/migrate and adds a Source that
allows using go_embed data files.
We also provide a test/example.
Change-Id: Icd2b6c7f7d0f728073b3fdf39b432b33ce61a3cd
diff --git a/go/mirko/tests/sql/sql_test.go b/go/mirko/tests/sql/sql_test.go
new file mode 100644
index 0000000..c76c3c1
--- /dev/null
+++ b/go/mirko/tests/sql/sql_test.go
@@ -0,0 +1,38 @@
+package sql
+
+import (
+ "testing"
+
+ _ "github.com/golang-migrate/migrate/v4/database/sqlite3"
+
+ "code.hackerspace.pl/hscloud/go/mirko/tests/sql/migrations"
+)
+
+// TestOkay goes up and down fully through migrations.
+func TestOkay(t *testing.T) {
+ m, err := migrations.New("sqlite3://:memory:")
+ if err != nil {
+ t.Fatalf("migrations.New: %v", err)
+ }
+
+ err = m.Up()
+ if err != nil {
+ t.Fatalf("m.Up() failed: %v", err)
+ }
+
+ vers, dirty, err := m.Version()
+ if err != nil {
+ t.Fatalf("m.Version() failed: %v", err)
+ }
+ if dirty {
+ t.Errorf("database migration shouldn't be dirty")
+ }
+ if want, got := uint(1564669988), vers; want != got {
+ t.Errorf("got database version %d, want %d", want, got)
+ }
+
+ err = m.Down()
+ if err != nil {
+ t.Fatalf("m.Down() failed: %v", err)
+ }
+}