litecli

litecli copied to clipboard

STRICT tables seem to not be supported

1

Hi, As of version 3.37.0 (2021-11-27), SQLite supports [STRICT tables](https://www.sqlite.org/stricttables.html). However, the LiteCLI client seems to choke on tables defined this way. Steps to reproduce: - have sqlite3 version >=...

nguiard

LiteCLI is built in Python, and the Python bindings for SQLite make it possible to bind custom functions you can then call from SQL, see the [`Connection.create_function()` documentation](https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function). I'd love...

mjpieters

When long wide characters are stored in the database, it will not output some rows if enabled auto_vertical_output

1

``` create table qwq(a text); insert into qwq values('啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊'); -- now select it select * from qwq; ``` 

one-pyy

`create table t(t text);` Then type `insert into t values(` (not copy) ``` Unhandled exception in event loop: File "D:\Miniconda3\lib\site-packages\prompt_toolkit\buffer.py", line 1939, in new_coroutine await coroutine(*a, **kw) File "D:\Miniconda3\lib\site-packages\prompt_toolkit\buffer.py", line...

one-pyy

With srqlparse 0.4.3 `tests/test_smart_completion_public_schema_only.py::test_auto_escaped_col_names` test fails Pytest output ``` ============================= test session starts ============================== platform linux -- Python 3.10.9, pytest-7.2.1, pluggy-1.0.0 -- /tmp/tmp.Tb95zRlr01/litecli/.venv/bin/python cachedir: .pytest_cache rootdir: /tmp/tmp.Tb95zRlr01/litecli, configfile: setup.cfg plugins:...

vlaci

Currently, the keyword argument **python_requires** of **setup()** is not set, and thus it is assumed that this distribution is compatible with all Python versions. However, I found it is not...

PyVCEchecker

## Description Adds a basic Debian package as requested in the install page. From my quick tests this should cover everything but I'm not 100% sure if every dependency is...

joshuaboniface

the prompt seems to behave strangely when the filename doesn't fit on a single line. it looks like maybe what i type is appearing off (above) screen?

davidszotten

I have just installed litecli 1.11.0 via Homebrew, and when I launch it I get the following warning: ``` /opt/homebrew/Cellar/litecli/1.11.0/libexec/lib/python3.12/site-packages/litecli/main.py:332: SyntaxWarning: invalid escape sequence '\e' """Editor command is any query...

dserodio

Is there a way to get `--indent` option to work when printing the schema for a table? In sqlite3 prompt: ``` sqlite> .schema runstats --indent CREATE TABLE IF NOT EXISTS...

the-shank