Current WIP #312

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