Incomplete, multi-line CREATE TABLE with .schema about litecli HOT 7 CLOSED

I'm not able to reproduce this locally. Do you have the exact create statement that you used?

Perhaps you can paste the output of .schema from the sqlite3 cli.

from litecli.

@amjith Please try with this: https://pastebin.com/raw/Uyrs2hfA

from litecli.

I'm able to reproduce it. Thank you for your example. Trying to figure out the fix now.

from litecli.

@tsroten I found an interesting issue with cli_helpers that I'm not sure how to solve.

One of the preprocessors applied by tabulate_adapter is truncate_string.

But in this specific issue where the CREATE TABLE statement is mutli-line there result can often be longer than the 500 characters but it is broken up into multiple lines using \n characters.

Ideally, I would want to override the default preprocessors for the tabulate adapter when I know that there is a reason to do so. But with the way the code is structured, I can specify additional preprocessors but I can't override the existing ones.

So I'm wondering what would be the best way to proceed?

from litecli.

@amjith I can definitely see a use case for disabling preprocessors in general. There is a way to disable the truncate_string preprocessor, which is to pass max_field_width=None as a keyword argument when you call format_output(). Would that work?

from litecli.

from litecli.

This is now fixed in cli_helpers and released. Please upgrade cli_helpers by running:

pip install -U cli_helpers

from litecli.