Ross Spencer

Allow users to inspect the sqlite queries used

1

There's are a number of sqlite queries on [`sqlitefid](https://github.com/exponential-decay/sqlitefid). They may be of interest to users and it is possible they might want to use them for themselves to build...

These variables need translating to other languages! We've started with French and Czech, but need to keep going :D https://docs.google.com/spreadsheets/d/1dVsRsXgD9V2GarNHHpf6Tzhrfx99_MXt3LjSSDrNLOY/edit#gid=0

Some queries optimize the need for string concatenation too early, for example: * `"SELECT 'ns:' || NSDATA.NS_NAME || ' ' || IDDATA.ID, count(IDDATA.ID) as TOTAL\n"` (`ns + Namespace + Name...

Using the following pattern starts to get us into the realm of a decent JSON output. ```python import json print(json.dumps(analysis_results.__dict__, sort_keys=True, indent=2)) ``` The output below is roughly all the...

Normalizing to sqlite is useful, is getting that normalized information out of the database helpful? Early script for this here: * https://github.com/exponential-decay/demystify/blob/114b1d08ea0d4dcb2bcf25a37f6e22d60f07a271/libs/ExportDBClass.py

Create a .editorconfig

1

This looks like a good idea for all projects but need to start somewhere so why note demystify? * https://editorconfig.org/

The Python 3 work is close to being finished. String handling in output is not ideal but it works - a refactor and rethinking of how the output is achieved...

Currently for each character issue discovered we do something a bit verbose: ``` def reportIssue(self, s, msg, value=''): self.report = self.report + "File: " + s + " " +...

Take: ```csv "62","60","file:/home/ross-spencer/git/exponential-decay/demystify/tests/fixtures/dirs_with_various_encodings/cp437/caf%C3%A9/","/home/ross-spencer/git/exponential-decay/demystify/tests/fixtures/dirs_with_various_encodings/cp437/café/","café","","Done","","Folder","","2020-06-22T19:38:22","false","","","","","","" ``` I expect `café` to show up as a directory and in the name analysis, but it doesn't. We may need to go through `sqlitefid` to make...

With more scaffolding around this tooling now/soon, with the imminent release of the Python3 work we can start to get rid of excess in the scripts that don't make sense....