Allow users to inspect the sqlite queries used

exponential-decay / demystify

Engine for analysis of Siegfried export files and DROID CSV. The tool has three purposes, break the export into its components and store them within a SQLite database; create additional columns to augment the output where useful; and query the SQLite database, outputting results in a readable form useful for analysis by researchers and archivists within digital preservation departments in memory institutions. The tool will find duplicates, unidentified files, blacklisted objects, character encoding issues, and more.

http://www.openplanetsfoundation.org/blogs/2014-06-03-analysis-engine-droid-csv-export

zlib License

23 stars 5 forks source link

Allow users to inspect the sqlite queries used #75

Open ross-spencer opened 2 years ago

ross-spencer commented 2 years ago

There's are a number of sqlite queries on `sqlitefid. They may be of interest to users and it is possible they might want to use them for themselves to build similar tooling.

Add an audit mechanism that allows users to see those calls for their own format identification reports.

ross-spencer commented 2 years ago

From the attached PR, output might look as follows: https://gist.github.com/ross-spencer/1f6cf16c9f966b980db277f7a932d81b