man-group / okcli Goto Github PK

Not sure if still active.
It might make more sense to update from ipython-sql to Jupysql.
Adding more context on depracation.

This transition should help you avoid compatibility issues and get access to newer features.
Just switching the name and version as backward compatibility is on.

I tried to put format=simpleon ~/.okclirc but it did not work. Also tried to use the color parameter there but it did not work either. How can I use them?

The oracle databases I currently work with unfortunately have a ton of namespaces and tables.
This results in "Refreshing completions" for around a minute every time I start okcli.

I've talked a bit with @icepuma about this issue and we had the idea to add optional completion caching to okcli.
It could work like this:

• entirely opt-in and set by command line flag (eG --enable-completions-cache or similar)
• if enabled, the completions are serialized into the XDG_CACHE_DIR
• if enabled and there is a completions dump at start, deserialize from file instead of asking the DB
• if disabled, nothing changes

The cache would be per-connection, for example after hashing the connection string.
I don't have any particular preference regarding cache invalidation, maybe simply removing the file manually would be good enough for a first start, or a --force-invalidate-cache option (slightly better especially if the file name is a hash).

A slightly easier variation to avoid dealing with XDG would be to simply support --completion-cache <path> so the user can decide if and when to delete the file. But it also introduces the potential mistake of using a completion cache for a different connection which would be confusing.

What are your thoughts on this and would you accept a pull request implementing this?

$ sudo pip install okcli
$ okcli
Traceback (most recent call last):
File "/usr/local/bin/okcli", line 5, in
from okcli.main import cli
File "/usr/local/lib/python3.10/dist-packages/okcli/main.py", line 20, in
from cli_helpers.tabular_output import TabularOutputFormatter
File "/usr/local/lib/python3.10/dist-packages/cli_helpers/tabular_output/init.py", line 11, in
from .output_formatter import format_output, TabularOutputFormatter
File "/usr/local/lib/python3.10/dist-packages/cli_helpers/tabular_output/output_formatter.py", line 10, in
from . import (delimited_output_adapter, vertical_table_adapter,
File "/usr/local/lib/python3.10/dist-packages/cli_helpers/tabular_output/tabulate_adapter.py", line 4, in
from cli_helpers.packages import tabulate
File "/usr/local/lib/python3.10/dist-packages/cli_helpers/packages/tabulate.py", line 6, in
from collections import namedtuple, Iterable
ImportError: cannot import name 'Iterable' from 'collections' (/usr/lib/python3.10/collections/init.py)