Function UpdateNoteBook

pkg/cli/database/queries.go:208–219

UpdateNoteBook moves the note to a different book and marks the note as dirty

(db *DB, c clock.Clock, rowID int, bookUUID string)

// UpdateNoteBook moves the note to a different book and marks the note as dirty
func UpdateNoteBook(db *DB, c clock.Clock, rowID int, bookUUID string) error {
	ts := c.Now().UnixNano()

	_, err := db.Exec(`UPDATE notes
			SET book_uuid = ?, edited_on = ?, dirty = ?
			WHERE rowid = ?`, bookUUID, ts, true, rowID)
	if err != nil {
		return errors.Wrap(err, "updating the note")
	}

	return nil
}