Function TestNoteUpdateUUID

pkg/cli/database/models_test.go:318–383

(t *testing.T)

}

func TestNoteUpdateUUID(t *testing.T) {
	testCases := []struct {
		newUUID string
	}{
		{
			newUUID: "n1-new-uuid",
		},
		{
			newUUID: "n2-new-uuid",
		},
	}

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

			n1 := Note{
				UUID:     "n1-uuid",
				BookUUID: "b1-uuid",
				AddedOn:  1542058874,
				Body:     "n1-body",
				USN:      1,
				Deleted:  true,
				Dirty:    false,
			}
			n2 := Note{
				UUID:     "n2-uuid",
				BookUUID: "b1-uuid",
				AddedOn:  1542058874,
				Body:     "n2-body",
				USN:      1,
				Deleted:  true,
				Dirty:    false,
			}

			MustExec(t, "inserting n1", db, "INSERT INTO notes (uuid, book_uuid, body, added_on, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", n1.UUID, n1.BookUUID, n1.Body, n1.AddedOn, n1.USN, n1.Deleted, n1.Dirty)
			MustExec(t, "inserting n2", db, "INSERT INTO notes (uuid, book_uuid, body, added_on, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", n2.UUID, n2.BookUUID, n2.Body, n2.AddedOn, n2.USN, n2.Deleted, n2.Dirty)

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

			tx.Commit()

			// test
			var n1Record, n2Record Note
			MustScan(t, "getting n1",
				db.QueryRow("SELECT uuid, body, usn, deleted, dirty FROM notes WHERE body = ?", "n1-body"),
				&n1Record.UUID, &n1Record.Body, &n1Record.USN, &n1Record.Deleted, &n1Record.Dirty)
			MustScan(t, "getting n2",
				db.QueryRow("SELECT uuid, body, usn, deleted, dirty FROM notes WHERE body = ?", "n2-body"),