New command: `osxphotos check`

[RhetTbull]

For debugging issues, would be helpful to have an osxphotos command that does an integrity check on a database. Verifies the files are there. That they are valid. If so, dumps the version data. Maybe add a --schema that dumps the schema. Also a --repair that would run a sqlite repair (dump and rebuild) on the databases.

OK, I've tried, but same result.

That is very strange. Try running the following commands and let me know what the output is:

file ~/Pictures/Bibliothèque\ Photos.photoslibrary/database/photos.db
file  ~/Pictures/Bibliothèque\ Photos.photoslibrary/database/Photos.sqlite
sqlite3  ~/Pictures/Bibliothèque\ Photos.photoslibrary/database/photos.db "PRAGMA integrity_check;"
sqlite3  ~/Pictures/Bibliothèque\ Photos.photoslibrary/database/Photos.sqlite "PRAGMA integrity_check;"

I may be able to work around the problem in OSXPhotos but it would be helpful to understand why the problem actually is occurring.

Originally posted by @RhetTbull in #1805