Btw, I am still working on this. I haven't published a new gist because as usual, I am changing everything 😭 (Also have had many visitors)
As I wanted to have more static data associated with each PRAGMA, my approach to the data representation fell apart.
And it's more than likely I am going down the wrong path again or fingers crossed, possibly not.
I have decided on a list of namedtuples to define the PRAMA's with thier static data.
Will look something like this ;
pragma_recs = [
_prec(cmd='application_id', query=True, call=True, ui_type='number', msg=None, unused=None),
_prec(cmd='auto_vacuum', query=True, call=True, ui_type='number', msg=None, unused=None),
Will be a list item for each PRAGMA. Maybe I am wrong.
I could do this as a normal list or just a normal set of tuples but there are 63 records. To go back and edit these records or review them later would be frustrating and error prone , this seems to be the best solution I can find.
From list of the namedtuple records, I will have to decide how to deal with them, as namedtuple's, dicts etc...
Anyway, still working on it