Testing scenarios for multimedia downloads using iiab/calibre-web [TDD, Gherkin Stories]

[deldesir]

This is a placeholder for testing scenarios pertaining to the media download feature:

1. Valid Download with Progress Observation:

   • Provide a valid media URL.
   • Observe the progress during the download of each video when a playlist URL is submitted.
   • Ensure the download completes successfully.
   • Verify that the progress reaches 100% and the success message is displayed.

2. Invalid URL:

   • Provide an invalid media URL (e.g., a URL that doesn't exist or is unreachable or a known YouTube or Vimeo one that will fail).
   • Confirm that the error handling correctly detects the failure.
   • Check that the progress is set to 0, and an appropriate error message is displayed in Tasks.

3. No Requested Files in the Database:

   • Ensure the SQLite database contains no requested files by providing a YouTube live video URL.
   • Run the download task and verify that it logs "No requested files found in the database."
   • Check that the progress is set to 0 and an error is displayed in Tasks.

4. Shelf Title Retrieval:

   • Intentionally provide a short playlist URL.
   • Confirm that the bookshelf is named after the playlist title, and appropriate messages are displayed in Tasks.
   • Check that the progress is set accordingly (100% if successful).

5. Download Cancellation:

   • Provide a valid media URL.
   • During the download process, attempt to cancel the task.
   • Confirm that the cancellation is handled correctly, and the progress is set to 0.

[EMG70]

iiab - diagnostics http://sprunge.us/W6auGx?en
1.Valid Download
https://www.youtube.com/watch?v=QXQrvT23rPw The sahara

2.Invalid URL
https://www.youtube.com/watch?v=1RQVkzbU2jo&list=PLg2tfDG3Ww4uBdOZ-j-znfOarR7TKGs-w TLSMaths E7 Module

3.No Requested Files in the Database:
https://www.youtube.com/watch?v=BJ3Yv572V1A Nat Geographic live video

4.Shelf Title Retrieval:
https://www.youtube.com/playlist?list=PL7yh-TELLS1FuqLSjl5bgiQIEH25VEmIc Python Advanced Tutorials playlist
Hung up and all videos in waiting mode thereafter.I had to restart calibre under Admin

5.Download Cancellation:
cancellation of video once started does not stop it from proceeding
https://www.youtube.com/watch?v=CWG17Nj6iT0

AFTER RESET CALIBRE
https://www.youtube.com/playlist?list=PLg2tfDG3Ww4uaKb8khJ4vApIAezsBLx8N all 8 videos downloaded ok, but top line status says failed!

https://www.youtube.com/playlist?list=PLg2tfDG3Ww4uV66ly6CSWK0AwX_IBRGRT download ok but shows failed in tasks!
https://www.youtube.com/watch?v=flFRBKml_8g download ok single video

[EMG70]

[EMG70]

The option to reset calibre was only done after a video playlist hung up at 99% ( almost done status) ,all further downloads thereafter were in waiting mode for ages.
https://www.youtube.com/playlist?list=PL7yh-TELLS1FuqLSjl5bgiQIEH25VEmIc

[deldesir]

Thank you @EMG70 for your comprehensive testing. It provide valuable insights into the functionality of the download task.

iiab - diagnostics http://sprunge.us/W6auGx?en 1.Valid Download https://www.youtube.com/watch?v=QXQrvT23rPw The sahara

No issues reported. The task correctly completed the download.

2.Invalid URL https://www.youtube.com/watch?v=1RQVkzbU2jo&list=PLg2tfDG3Ww4uBdOZ-j-znfOarR7TKGs-w TLSMaths E7 Module

The task handled the invalid URL correctly, showing an appropriate error message, but reported an incorrect 100% progress.

3.No Requested Files in the Database: https://www.youtube.com/watch?v=BJ3Yv572V1A Nat Geographic live video

The task correctly identified that there were no requested files in the database and logged the message "Failed to download: 500 INTERNAL SERVER ERROR". I was expecting something like "No requested files found".

4.Shelf Title Retrieval: https://www.youtube.com/playlist?list=PL7yh-TELLS1FuqLSjl5bgiQIEH25VEmIc Python Advanced Tutorials playlist Hung up and all videos in waiting mode thereafter.I had to restart calibre under Admin

[ASIDE] Do you mean restart? (this clears the task table)
You should see a bookshelf named after the playlist. When videos stay in waiting mode, that could mean a silent failure, but in most cases it's just background ffmpeg processing happening, especially when they're stuck at 99%. It could also mean network errors or storage issues.

5.Download Cancellation: cancellation of video once started does not stop it from proceeding https://www.youtube.com/watch?v=CWG17Nj6iT0

The cancellation issue needs further investigation. We'll work on fixing this to ensure proper cancellation functionality.

AFTER RESET CALIBRE https://www.youtube.com/playlist?list=PLg2tfDG3Ww4uaKb8khJ4vApIAezsBLx8N all 8 videos downloaded ok, but top line status says failed!

Weird they recovered. Does resetting/restarting prevent us from seeing something informative? I also don't see subsequent upload tasks.

https://www.youtube.com/playlist?list=PLg2tfDG3Ww4uV66ly6CSWK0AwX_IBRGRT download ok but shows failed in tasks! https://www.youtube.com/watch?v=flFRBKml_8g download ok single video

I'll investigate and address the discrepancies in status messages to ensure accurate reporting. If you have additional feedback or encounter more scenarios, please feel free to share. Your contributions play a crucial role in improving those fixes.

[deldesir]

By the way @EMG70, did you use #96 in your tests. If so, we should be covered by xklb's own errors handling for YouTube-related and database failures.

[EMG70]

By the way @EMG70, did you use #96 in your tests. If so, we should be covered by xklb's own errors handling for YouTube-related and database failures.

Yes I created a new VM after your early morning merges which I assume would include latest updates.

[EMG70]

[ASIDE] Do you mean restart? (this clears the task table)
You should see a bookshelf named after the playlist. When videos stay in waiting mode, that could mean a silent failure, but in most cases it's just background ffmpeg processing happening, especially when they're stuck at 99%. It could also mean network errors or storage issues.

Restart clears all lists of downloads from Tasks.The successful videos are populating titles correctly and shelf appears with correct playlist name.

[EMG70]

root@box:~# df -h
Filesystem Size Used Avail Use% Mounted on
tmpfs 196M 1.2M 195M 1% /run
efivarfs 256K 24K 228K 10% /sys/firmware/efi/efivars
/dev/sda1 19G 4.1G 15G 22% /
tmpfs 977M 0 977M 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
/dev/sda16 881M 60M 760M 8% /boot
/dev/sda15 105M 6.1M 99M 6% /boot/efi
tmpfs 50M 14M 37M 27% /run/lxd_agent
tmpfs 196M 4.0K 196M 1% /run/user/1000

[deldesir]

Good. Thanks for the additional info. Identified issues will be addressed ASAP.

[holta]

I'll put quick instructions at https://github.com/iiab/calibre-web/wiki making clear to everyone... how to test the actual code of any individual PR:

As there's nothing more important than TDD (Test-Driven Dev) in the end, informed by actual users/teachers/parents/etc! 🏗️

[deldesir]

Currently playlist downloads will report a 500 INTERNAL SERVER ERROR. I am working on it