Pretty table config is deprecated and it causes an error of `KeyError: "DEFAULT"`

[talbarda]

https://github.com/catherinedevlin/ipython-sql/blob/eb274844b4a619463149e0d57df705e1bba47635/src/sql/run.py#L116C63-L116C74

description
in https://github.com/catherinedevlin/ipython-sql/blob/eb274844b4a619463149e0d57df705e1bba47635/src/sql/run.py#L116C63-L116C74 it'd relying on old values which were deprecated in prettytable/prettytable@c280f5d#diff-a23434b1b73f48b3a86c77a98ace18042f475a7463f98eea9d2ccf7523e6046dL13 (see https://github.com/prettytable/prettytable/releases)

few possible solutions:

1. change to self.pretty = PrettyTable(self.field_names, style=prettytable.__dict__[f"_DEPRECATED_{config.style.upper()}])
2. freeze prettytable to 3.11 in

   ipython-sql/requirements.txt

   Line 1 in eb27484

   prettytable

[pavlozt]

The proposed change works.
And it is a very frustrating bug that breaks the basic functionality

[talbarda]

Can you merge this then ?

[makingglitches]

I'm seeing this too.
It's breaking where its accessing the style selected as a dictionary key, in the toplevel object.
The KeyError changes based on style you select as well.
I could fix it again....

[makingglitches]

Appears to be line 116 of run.py at HEAD.
It appears constants related to style have moved to a class called TableStyle as static members.

self.pretty = PrettyTable(self.field_names, style=prettytable.TableStyle.dict[config.style.upper()])

Should probably fix it.

[Sygyzmundovych]

I switched to the new and maintained fork jupysql (see: https://jupysql.readthedocs.io/en/latest/quick-start.html)