Shell history not being persisted correctly

[afiore]

👋 Hi there,

While using the shell subcommand, I have noticed that the query history doesn't seem to be persisted correctly.

Expected behaviour

• Like other interactive shells, I would expect the lenses-cli shell to append to the history file both valid and invalid queries.
• Most important, I would expect the shell to reload the history on startup and allow me to cycle through all my recent queries using the arrow keys.

Steps to reproduce

I observed the behaviour below on a local build of: dcbcf0b:

• Start shell with Lenses API running on http://localhost:3030/
• Run first query:

lenses-sql> show tables;
// output omitted

• Run second query:

lenses-sql>select * from cc_data limit 1;
... output omitted

• Hit Crtl+D and exit the shell
• Inspect the history file:

cat ~/.lenses/history
select * from cc_data limit 1; select * from cc_data limit 1;% 

Note that:

• the first query has not been persisted, and will not be available when re-running the command
• the last query is repeated twice