Current WIP - Githubissues

ssweber commented 1 year ago

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

PySimpleSQL commented 1 year ago

Very cool - I look forward to seeing it. Unfortunately I'm on a 100+ hour work week this week so I've been pretty pinned down

ssweber commented 1 year ago

Figured you we swamped! Just wanted to give an update :)

ssweber commented 1 year ago

Preview: Almost finished. Excited about this datepicker:

https://github.com/PySimpleSQL/pysimplesql/assets/57631333/0a2b1a85-4c14-404d-89e5-e757af0c5e6a

PySimpleSQL commented 1 year ago

Wow, sweet!

Sorry, I've been pinned down. Looks like I have a ton to catch up on. Sorry for the delay with things, time has been very slim this month!

On Tue, May 16, 2023 at 5:08 PM ssweber @.***> wrote:

Closed #312 https://github.com/PySimpleSQL/pysimplesql/issues/312 as completed.

— Reply to this email directly, view it on GitHub https://github.com/PySimpleSQL/pysimplesql/issues/312#event-9262540216, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX2REUOHCCURMGQM5GGW2TXGPUD7ANCNFSM6AAAAAAX6ZTW4M . You are receiving this because you commented.Message ID: @.***>

PySimpleSQL / pysimplesql

Current WIP #312