Function TestCleanLocalNotes

pkg/cli/cmd/sync/sync_test.go:3085–3154

(t *testing.T)

}

func TestCleanLocalNotes(t *testing.T) {
	// set up
	db := database.InitTestMemoryDB(t)

	list := syncList{
		Notes: map[string]client.SyncFragNote{
			"n1-uuid": {
				UUID: "n1-uuid",
			},
			"n2-uuid": {
				UUID: "n2-uuid",
			},
		},
		Books: map[string]client.SyncFragBook{
			"b1-uuid": {
				UUID: "b1-uuid",
			},
			"b2-uuid": {
				UUID: "b2-uuid",
			},
		},
		ExpungedNotes: map[string]bool{
			"n3-uuid": true,
			"n4-uuid": true,
		},
		ExpungedBooks: map[string]bool{
			"b3-uuid": true,
			"b4-uuid": true,
		},
		MaxUSN:         1,
		MaxCurrentTime: 2,
	}

	b1UUID := "b1-uuid"
	database.MustExec(t, "inserting b1", db, "INSERT INTO books (uuid, label, usn, deleted, dirty) VALUES (?, ?, ?, ?, ?)", b1UUID, "b1-label", 1, false, false)

	// exists in the list
	database.MustExec(t, "inserting n1", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n1-uuid", b1UUID, 10, "n1 body", 1541108743, false, false)
	database.MustExec(t, "inserting n2", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n2-uuid", b1UUID, 0, "n2 body", 1541108743, false, true)
	// non-existent in the list but in valid state
	// (created in the cli and hasn't been uploaded)
	database.MustExec(t, "inserting n6", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n6-uuid", b1UUID, 0, "n6 body", 1541108743, false, true)
	// non-existent in the list and in an invalid state
	database.MustExec(t, "inserting n5", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n5-uuid", b1UUID, 7, "n5 body", 1541108743, true, true)
	database.MustExec(t, "inserting n9", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n9-uuid", b1UUID, 17, "n9 body", 1541108743, true, false)
	database.MustExec(t, "inserting n10", db, "INSERT INTO notes (uuid, book_uuid, usn, body, added_on, deleted, dirty) VALUES (?, ?, ?, ?, ?, ?, ?)", "n10-uuid", b1UUID, 0, "n10 body", 1541108743, false, false)

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

	if err := cleanLocalNotes(tx, &list); err != nil {
		tx.Rollback()
		t.Fatal(errors.Wrap(err, "executing").Error())
	}