On keyboard interrupt during a long-running query, an error message is printed:
Encountered error while cancelling query: near "kill": syntax error
That's because litecli tries to treat sqlite like a remote database and sends a kill <connectionid> command, which sqlite doesn't support.
Instead, litecli should call the connection.interrupt() method. No new connection is needed. In main.py:LiteCli.one_iteration(), replace the last KeyboardInterrupt exception handler with:
On keyboard interrupt during a long-running query, an error message is printed:
That's because litecli tries to treat sqlite like a remote database and sends a
kill <connectionid>
command, which sqlite doesn't support.Instead, litecli should call the
connection.interrupt()
method. No new connection is needed. Inmain.py:LiteCli.one_iteration()
, replace the lastKeyboardInterrupt
exception handler with: