json output format

[mooreniemi]

This output list is exhaustive, and json is not supported today, right?

When I try --table-format "json", I get unrecognized format_name "json". It seems weird to me that html is supported but not just json.

[j-bennet]

The list in the docs in not exhaustive, but the comment in the CLI config file should be:

athenacli/athenacli/athenaclirc

Lines 45 to 49 in c9e4774

	# Table format. Possible values: ascii, double, github,
	# psql, plain, simple, grid, fancy_grid, pipe, orgtbl, rst, mediawiki, html,
	# latex, latex_booktabs, textile, moinmoin, jira, vertical, tsv, csv.
	# Recommended: ascii
	table_format = ascii

athenacli uses cli_helpers to do output formatting, which in return uses tabulate. https://pypi.org/project/tabulate/.
json is not supported by tabulate, I would guess because it's not really a tabular format.

[zzl0]

@mooreniemi thanks for the feedback. Unfortunately, we don't support json format now. I think that's the great idea to support it.

[mooreniemi]

Ok, I am not sure I will have time but if you point me to where a potential refactoring point is to add it, I may be able to help.

[j-bennet]

@mooreniemi You would add a new adapter here:

https://github.com/dbcli/cli_helpers/tree/main/cli_helpers/tabular_output

For an example, take a look at this PR, which was adding a tsv adapter:

dbcli/cli_helpers#47