- main.py: _pending_record_id locks resolved DB key at Add/Update time;
show original barcode in update frame; auto-focus mass field on open;
clear all fields and return focus to ID input after confirm/reset
- database_manager.py: buffered=True cursors on all SELECTs; no
fetchall() after DML; replace ON DUPLICATE KEY UPDATE VALUES() with
explicit UPDATE then INSERT fallback; add app_actions.log with
structured per-action entries; purge_old_action_logs(30) on startup
- dist/DatabaseApp.exe: rebuilt single-file Windows binary (30.9 MB)
- remove unused files: README, WINDOWS_README, run_app.sh,
setup_database.sh, setup_user.sql, test_database.py, sept.csv"
- All widget heights, fonts, padding and spacing derived from
Window.height so layout fits any screen (800p, 1080p, etc.)
- Content block wrapped in AnchorLayout (anchor_y=center) so it
sits centered in the space above the numpad instead of bottom-aligned
- Rebuilt DatabaseApp.exe (30.9 MB)
- Exit button relocated from bottom-right overlay to right side of title row
- Spacing between action buttons and update frame reduced 40px -> 10px
- Rebuilt DatabaseApp.exe (30.9 MB)
mysql-connector-python 9.x restructured its package hierarchy. PyInstaller
fails to auto-discover submodules (aio, plugins, locales, etc.).
Updated DatabaseApp.spec to use collect_all('mysql.connector') which
walks the full package tree and bundles all required files.
Rebuilt DatabaseApp.exe (30.9 MB).
