Closed deldesir closed 3 months ago
Thanks @deldesir for catching this!
(As this'll be very important among students/teachers searching their offline video collections...)
It would be interesting to know how the xklb-metadata.db was created so that I can fix other? bugs, if any. The problem with making all the schema/queries column-optional is that silent data bugs will exponentiate...
interesting to know how the xklb-metadata.db was created
@deldesir can you link to precise code, showing were xklb-metadata.db is created?
Thanks if you can please.
xklb-metadata.db is created by https://github.com/iiab/calibre-web/blob/916963a17cf5074e402e9c49ec608abf43809f32/scripts/lb-wrapper#L56
okay it should be working in 2.8.050
It looks like this could also benefit from having one or two simple tests in tests/mediadb/test_search.py
to prevent future regressions like these. You can look for examples of capsys
in tests/mediadb/test_playlists.py
.
It doesn't have to be very detailed to be useful--but you will need a database that has captions. You might need to move parts of tests/mediadb/test_download.py
to tests/utils/__init__.py
and then reference it in test_search.py
similar to how tests/utils/__init__.py:v_db
is referenced in other test files
okay it should be working in 2.8.050
Priceless:
@deldesir and I have decided to focus on getting search (across all local books/videos/etc) working as rigorously/reliably as possible in coming days and weeks[*]. So hopefully he can respond to your (@chapmanjacobd) TDD-oriented suggestions very soon, as this all points precisely to what grassroots communities need (meaningful local learning, not info-bloat!) 💯
[*] CAVEAT: Bogus captions and extremely poor-quality transcriptions are something we all have to live with for now, all too often, and so be it. (Let us hope that extremely low-quality transcriptions / captions / sub-titles finally start becoming increasingly more sane in 2025 ;-)
Thank you for the quick fix @chapmanjacobd
It looks like this could also benefit from having one or two simple tests
I appreciate the suggestion. I'll do my best to learn and get this done.
Describe the bug Searching captions/subtitles no longer works Error:
sqlite3.OperationalError: no such column: m.time_deleted
Expected behavior Xklb should return the captions found and the titles of the video(s) related to them
To Reproduce