Function TestBookUpdateUUID

pkg/cli/database/models_test.go:651–713

(t *testing.T)

}

func TestBookUpdateUUID(t *testing.T) {
	testCases := []struct {
		newUUID string
	}{
		{
			newUUID: "b1-new-uuid",
		},
		{
			newUUID: "b2-new-uuid",
		},
	}

	for idx, tc := range testCases {
		t.Run(fmt.Sprintf("testCase%d", idx), func(t *testing.T) {

			// Setup
			db := InitTestMemoryDB(t)

			b1 := Book{
				UUID:    "b1-uuid",
				Label:   "b1-label",
				USN:     1,
				Deleted: true,
				Dirty:   false,
			}
			b2 := Book{
				UUID:    "b2-uuid",
				Label:   "b2-label",
				USN:     1,
				Deleted: true,
				Dirty:   false,
			}

			MustExec(t, "inserting b1", db, "INSERT INTO books (uuid, label, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?)", b1.UUID, b1.Label, b1.USN, b1.Deleted, b1.Dirty)
			MustExec(t, "inserting b2", db, "INSERT INTO books (uuid, label, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?)", b2.UUID, b2.Label, b2.USN, b2.Deleted, b2.Dirty)

			// execute
			tx, err := db.Begin()
			if err != nil {
				t.Fatal(errors.Wrap(err, "beginning a transaction").Error())
			}
			if err := b1.UpdateUUID(tx, tc.newUUID); err != nil {
				tx.Rollback()
				t.Fatal(errors.Wrap(err, "executing").Error())
			}

			tx.Commit()

			// test
			var b1Record, b2Record Book
			MustScan(t, "getting b1",
				db.QueryRow("SELECT uuid, label, usn, deleted, dirty FROM books WHERE label = ?", "b1-label"),
				&b1Record.UUID, &b1Record.Label, &b1Record.USN, &b1Record.Deleted, &b1Record.Dirty)
			MustScan(t, "getting b2",
				db.QueryRow("SELECT uuid, label, usn, deleted, dirty FROM books WHERE label = ?", "b2-label"),
				&b2Record.UUID, &b2Record.Label, &b2Record.USN, &b2Record.Deleted, &b2Record.Dirty)

			assert.Equal(t, b1.UUID, tc.newUUID, "b1 original reference uuid mismatch")