support for pipes with .once

[danp]

Hey, thanks for this project!

When I use the official sqlite3 CLI I use .once's pipe support quite a bit:

https://sqlite.org/cli.html#writing_results_to_a_file

This means I can do something like:

.mode markdown
.once | pbcopy
select foo from bar;

Then end up with the output in markdown in my clipboard (on macOS), ready to paste somewhere (like GitHub).

I discovered litecli's .once doesn't support this, so I ended up with a file named | pbcopy.

Supporting pipes like this in litecli would be a nice addition.

[amjith]

I ended up with a file named | pbcopy

I'm so sorry. 😂

Reminds me of the time I tricked my friend into deleting his home folder by doing touch ? and touch ?? and touch ??? and he decided to delete the files by calling rm -f ?*. We were are a bunch of clowns.

Back to your request. This is possible (and probably easy). We have this in mycli. If you are feeling generous you can take a crack at a PR for litecli.

[danp]

😬

All good! I don't do a lot of python but gave it a try at #193.