Function TestLocalMigration14

pkg/cli/migrate/migrate_test.go:1099–1144

(t *testing.T)

}

func TestLocalMigration14(t *testing.T) {
	// set up
	db := database.InitTestMemoryDBRaw(t, "./fixtures/local-14-pre-schema.sql")
	ctx := context.InitTestCtxWithDB(t, db)

	b1UUID := testutils.MustGenerateUUID(t)
	database.MustExec(t, "inserting book", db, "INSERT INTO books (uuid, label) VALUES (?, ?)", b1UUID, "b1")

	n1UUID := testutils.MustGenerateUUID(t)
	database.MustExec(t, "inserting note", db, `INSERT INTO notes
		(uuid, book_uuid, body, added_on, edited_on, public, dirty, usn, deleted) VALUES
		(?, ?, ?, ?, ?, ?, ?, ?, ?)`, n1UUID, b1UUID, "test note", 1, 2, true, false, 0, false)

	// Execute
	tx, err := db.Begin()
	if err != nil {
		t.Fatal(errors.Wrap(err, "beginning a transaction"))
	}

	err = lm14.run(ctx, tx)
	if err != nil {
		tx.Rollback()
		t.Fatal(errors.Wrap(err, "failed to run"))
	}

	tx.Commit()

	// Test - verify public column was dropped by checking column names
	rows, err := db.Query("SELECT name FROM pragma_table_info('notes')")
	if err != nil {
		t.Fatal(errors.Wrap(err, "getting table info"))
	}
	defer rows.Close()

	for rows.Next() {
		var name string
		err := rows.Scan(&name)
		if err != nil {
			t.Fatal(errors.Wrap(err, "scanning column name"))
		}

		if name == "public" {
			t.Fatal("public column still exists after migration")
		}
	}
}

func TestRemoteMigration1(t *testing.T) {
	// set up