Search videos by subtitles/captions/transcripts [AND video title AND video description AND video author AND video publisher?]

[deldesir]

This feature is being implemented in #152. The pain point is finding the video titles without parsing the xklb search command output. Currently it is broken due changes made to the way xklb display results. Another approach worth trying is to fetch results directly from xklb-metadata.db and merge them with those fetch from metadata.db.

[holta]

@deldesir: is this ticket title somewhat accurate?

(Or do we need to further revise the precise objective here?)

[deldesir]

Revision looks better.

[deldesir]

Two implementations for this feature were made and are functional:

• Support searching videos [subtitles, captions, transcripts?] #152 using a subprocess call, running lb search <db> <term> --to-json in the background, which return videos titles for a given term.
• Query captions/subtitles [e.g. video transcripts] from xklb-metadata.db #244 querying xklb-metadata.db's table captions for a given term, looking for video titles.

In both case the results are combined with the calibre-web search results. Duplicates are removed so the user can be presented with unique results.