Python scripts to access Follow Your Data (FYD) database
USAGE:
To run either use getFYD.py with:
python getFYD.py
Or use jupyter notebook and open the file:
saveJSON.ipynb
You need to install mysql-connector-python; e.g conda install mysql-connector-python
Change conn.py to appropriate values for host, username, password and database.
Both import getdbfields.py to open the dialog for selecting a value for each database field in the database (MYSQL) of your lab.
When done; click "save" to save a json file at a selected location, "done" updates a cash file in your working directory and you can use the output in your script. "cancel" to exit with no effect.
USAGE:
start qtdesigner in a command window (anaconda), simply with: designer
open a ui file; opens a graphical window, allows you to drag window controls into your app, to position and edit its attributes.
save this file and convert to python code with pyuic5.bat to a file with py extention. cmd > pyuic5.bat -x design.ui -o design.py
Now add callbacks and functionality to the window controls. I've done this in getdbfields.py where the Qt generated files are imported: design.py and NWdlg.py
In getdbfields three classes are defined; 1. a mysql connection class, 2. a New dialog class, and 3. the main dlgfields class.