Current WIP #312
Description
Little update… made huge progress yesterday and today getting functionality just right for a new “Orders” example that I’m going to record the opening readme with.
It highlights most everything that makes pysimplesql so special… the automatic binding, relationship handling, prompt-saving, table sorting, with all the new live-updating functionality.
I’ll try to finish and create a pull for the following tomorrow:
- add the Orders example
- Add datepicker for celledit if domain is “date” - almost done, but want to include a version that doesn’t rely on GPL tkcalendar library
- Rewritten search function, that fills in descriptions if rel.fk
- Add write_event to set_current - so in Main Loop you can have custom code that acts on cell/liveupdates
- add SQLite generated column handling (don’t try to update generated columns!)
- Fix: Add try/except to set_by_pk,
- Fix: In save_record use .to_dict() instead of dict() for pd.Series… dict() keeps ints as numpy types
- Display description column for sg.Text if a fk. skip sg.text in save_records
- Add readonly to add_column()
- Example to show different checkbox behavior: Boolean is the only one fully supported in celledit, while we do 'best-effort' for int/text
- display Booleans as checkboxes in sg.Tables