Author: Jeremy Holden
Email: jeremy.holden@ontario.ca
version: 0.0.1.9004
version date: October 19, 2022
updated on: Aug 28, 2023 (J. Holden)
Create a lightweight sqlite data base with a tkinter GUI that is used to record required data changes to FN2 files. Changes are recorded in the data base and then in R a rows_update() applies the changes to the data along with additional cleaning and standardization routines. Changes are recorded in the database and will later be merged using R along with additional cleaning and standardization routines as the data are migrated to a long term storage system. In this manner, raw data can remain unchanged while creating a documented, reproducible pipeline of data changes.
The script (executable if created) can be deployed from any directory. On load, you can create a new database or load an existing database from options in the File menu. You can move between entry boxes using "TAB". New records are added to the database via the "Submit" button (on click or with "ENTER" when highlighted). Currently, errors can only be deleted and not edited (at least not from this GUI - see DBBrowser software to interact with update_data.db if required). To delete a record, highlight the record in the spreadsheet window that is intended to be deleted and then click "Delete".
python DataChangeGUI.py
An executable can be created using auto-py-to-exe.
auto-py-to-exe
- Current template only for FN125 - consider implementation for other tables
- Add additional checks for field constraints (eg.
entryin "flen", "tlen", ...)) - FN123 GUI required
- Adds a FN121 GUI that will add a FN121Changes table to an existing database that may have only previously had FN125 changes.
- Modifies code in FN125 to create a new table if required when connecting to an existing database (i.e. one created from FN121 GUI)