Sqlite3 PRAGMA integrity_check;

1

Hi, I want to use

sqlite3 my_tropy_project.tpy “PRAGMA integrity_check;”

to automatically check the integrity of a tropy file and so far it seems to work.

  1. is this the same tool tropy uses internally?
  2. is it guaranteed that sqlite3 my_tropy_project.tpy “PRAGMA integrity_check;” always yields the same result as the check Tropy does when starting?
2

When opening a project file Tropy will run PRAGMA integrity_check and also PRAGMA foreign_key_check on the project. This should be identical to running the command form the command line, though there can be differences because the version of SQLite used by Tropy could be different from the one you’re using. We usually update SQLite to the latest version when new release comes out.