(cherry picked from commit 885dc3d8)
Signed-off-by: Hugo Beauzée-Luyssen <hugo@beauzee.fr>

(cherry picked from commit 48017dd3)
Signed-off-by: Hugo Beauzée-Luyssen <hugo@beauzee.fr>

The Task UNIQUE constraint doesn't consider 2 (mrl, NULL) entries as
duplicated.
By detecting it early, we prevent the metadata extraction to be run
twice for nothing.

(cherry picked from commit 35c61e2c)
Signed-off-by: Hugo Beauzée-Luyssen <hugo@beauzee.fr>

(cherry picked from commit b5a23750)
Signed-off-by: Hugo Beauzée-Luyssen <hugo@beauzee.fr>

Which was created as is_track_presentAFTER, which apparently defaults to
a BEFORE trigger, causing the wrong is_present value to be used

This seems to happen on some devices, with folders ending with a
trailing dot
Fix https://trac.videolan.org/vlc/ticket/19909

We were leaving potentially scheduled parser tasks behind

is_present doesn't exist, and we want to reset the count for all tasks
anyway. It will start or not depending on the file presence, but we
don't need to care when reseting

This version will ensure all the File have an associated Task, to avoid
some content not appearing because it wasn't analyzed

This eases up recreating a task from a file, in case we failed to do so
during the original migration

Which is more appropriate for what this function does

That makes it 2 forgotten tables...

If any, they are signaled through an sqlite exception

It will now check for the folder existence & validity during the
Directory constructor. As such, we need to check for potential
exceptions being thrown, and don't need to check for the return value.

To recover from different encoding without removing all files