Cant get demo to run

[arminposchmann]

Hi all,
i stumbled about this project when looking for a way to sort PysimpleGui Tables and have a headings marker for the sorting. Then i tried the version 2.3.0 of this project and could only get the Restaurant demo to run. All the Fruit examples fail with
Traceback (most recent call last):
File "/home/ap/pydev/testpy/testfiles/fruit4.py", line 20, in
ss.record(table, 'name', label='Fruit Name'), # pysimplesql.record() convenience function for easy record creation!
File "/home/ap/.local/lib/python3.10/site-packages/pysimplesql/pysimplesql.py", line 2392, in record
label_text = query_info.split('.')[1].replace('fk', '').replace('_', ' ').capitalize() + ':'
IndexError: list index out of range

Is there a way to get a demo that works with a sg.Table and is able to sort ?
I tried with PySimpleGUI 4.6.1 and with PySimpleGUI 5.0.3

[ssweber]

Could you download the latest master version? here's a link to download the zip

I’m not actively working on this project, but left the master version in a good working state. All the SQLite examples should work.

[arminposchmann]

Yes, after downloading and installing from git, most of what i am interested in is working.
I managed to reskin everything with little extensions to psg_reskinner and most easy demos are running.
What i'm interested in is transforming the data: set_transform(ss.simple_transform)
There is a demo journal_with data_manipulation.py that shows exactly the transform i would like to use,
but the demo fails on the requery call.
See the output below:
2024-04-03 17:48:34.561 | INFO | pysimplesql.pysimplesql:execute:10059 - Executing query: SELECT "Journal".* FROM "Journal" LEFT JOIN "Mood" ON "Journal"."mood_id"="Mood"."id" ORDER BY entry_date DESC None
2024-04-03 17:48:34.562 | DEBUG | pysimplesql.pysimplesql:get_value:824 - Getting current record for Journal.id
2024-04-03 17:48:34.563 | DEBUG | pysimplesql.pysimplesql:sort:3313 - Sort column is None. Resetting sort.
2024-04-03 17:48:34.563 | DEBUG | pysimplesql.pysimplesql:set_by_pk:1997 - Setting table Journal record by primary key 1
2024-04-03 17:48:34.563 | DEBUG | pysimplesql.pysimplesql:update_selectors:4675 - update_elements: SELECTOR FOUND
2024-04-03 17:48:34.563 | DEBUG | pysimplesql.pysimplesql:update_selectors:4681 - <class 'pysimplesql.pysimplesql.LazyTable'>
2024-04-03 17:48:34.563 | DEBUG | pysimplesql.pysimplesql:update_selectors:4725 - update_elements: Table selector found...
2024-04-03 17:48:34.569 | DEBUG | pysimplesql.pysimplesql:get_value:824 - Getting current record for Journal.id
2024-04-03 17:48:34.570 | DEBUG | pysimplesql.pysimplesql:update_selectors:4762 - Selector:: index:[0] found:True
2024-04-03 17:48:34.572 | DEBUG | pysimplesql.pysimplesql:simple_transform:4995 - Transforming entry_date from 1712159314 to 04/03/24
2024-04-03 17:48:34.575 | DEBUG | pysimplesql.pysimplesql:first:1639 - Moving to the first record of table Journal
2024-04-03 17:48:34.575 | DEBUG | pysimplesql.pysimplesql:update_elements:4366 - update_elements(): Updating PySimpleGUI elements
2024-04-03 17:48:34.575 | DEBUG | pysimplesql.pysimplesql:update_element_states:4893 - Updating element Journal.entry_date to disabled: False, visible: None
2024-04-03 17:48:34.576 | DEBUG | pysimplesql.pysimplesql:update_element_states:4893 - Updating element Journal.mood_id to disabled: False, visible: None
2024-04-03 17:48:34.576 | DEBUG | pysimplesql.pysimplesql:update_element_states:4893 - Updating element Journal.title to disabled: False, visible: None
2024-04-03 17:48:34.576 | DEBUG | pysimplesql.pysimplesql:update_element_states:4893 - Updating element Journal.entry to disabled: False, visible: None
Traceback (most recent call last):
File "/home/ap/pydev/testpy/testfiles/sql/.journal_with_data_manipulation.py", line 74, in
frm['Journal'].requery()
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 1584, in requery
self.first(
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 1650, in first
self.frm.update_elements(self.key)
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 4378, in update_elements
self.update_actions(target_data_key)
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 4420, in update_actions
or self[data_key].pk_is_virtual()
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 2727, in pk_is_virtual
return bool(pk in self.virtual_pks)
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 2710, in virtual_pks
return self.rows.attrs["virtual"]
KeyError: 'virtual'

Thank you for your answer. This project is very interesting!

Regards Armin

[ssweber]

That shouldn’t be too difficult to fix. Looks like we assume “virtual” key is there when it isn’t. I’ll push a fix for that when I have a second

[ssweber]

See if master now works for you!

[arminposchmann]

The stacktrace changed a little bit, but it does not work.

INFO:pysimplesql.pysimplesql:Executing query: SELECT "Journal".* FROM "Journal" LEFT JOIN "Mood" ON "Journal"."mood_id"="Mood"."id" ORDER BY entry_date DESC None
Traceback (most recent call last):
File "/home/ap/pydev/testpy/testfiles/sql/pysimplesql/examples/SQLite_examples/journal_with_data_manipulation.py", line 74, in
frm['Journal'].requery()
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 1583, in requery
self.first(
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 1649, in first
self.frm.update_elements(self.key)
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 4386, in update_elements
self.update_selectors(target_data_key, omit_elements)
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 4741, in update_selectors
values = dataset.table_values(
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 2788, in table_values
if self.current.has_backup and not self.current.get().equals(
File "/home/ap/pydev/pysimplesql/src/pysimplesql/pysimplesql.py", line 748, in has_backup
isinstance(rows.attrs["row_backup"], pd.Series)
KeyError: 'row_backup'

[ssweber]

Ah ok. Let me dig a little deeper and figure out where we arnt populating the attrs dictionary with (at least) empty values