feature request: execute a set of commands during startup about litecli HOT 9 OPEN

I was about to file an identical issue before I found this one. This would be a useful feature for me as well. Adding my +1!

from litecli.

@fdietze The default behavior of litecli seems to match most of the things in your sqliterc file.

The default table format already has headers on.
The null value is already represented as <null>.
The number of affected row are always printed (.changes on)
The timing information is also on by default (.timer on)

The goal with litecli is to ship with sane defaults so people aren't spending a lot of time trying to mess with configuration files to get reasonable behavior.

That said I can see that people might still want this feature. I'm happy to help someone get started if they're interested in contributing this feature.

from litecli.

I have started implemented this now. If people don't mind that it might be a bit below the standard of the rest of the codebase I will submit a pull request (I will ofc do my best). If nothing else it can serve as a starting point. Thinking that it can take in startup commands specified in the config file. Will first focus on implementing the core functionality, then add some basic error handling (which I am sure can be expanded). Already have a minimal running example. @fdietze @amjith @aborruso

from litecli.

I think you can store your commands in a file and then pass them as command line argument to litecli.

from litecli.

Hi @elig0n and how to run at start in example .load /usr/lib/sqlite3/pcre.so?

It would be nice if litecli read .sqliterc standard file.

Thank you

from litecli.

@aborruso that's a good idea. For now, I think you can use the favorite query to store a set of commands, and run it with a short name.

from litecli.

Just found this issue, this is the first thing I was looking for in the configuration. 👍

I have a nice .sqliterc with features i'd like to keep using:

.mode column
.headers on
.nullvalue <null>

-- always explain query plan
.eqp on
pragma foreign_keys = ON;

.print "Databases:"
.databases
.print "\nTables:"
.tables
.print "\n"

.changes on
.timer on

from litecli.

The goal with litecli is to ship with sane defaults so people aren't spending a lot of time trying to mess with configuration files to get reasonable behavior.

That's what I like about it! Thank you for your work!

from litecli.

Came here to open this issue. It would be great to auto set foreign keys as well as display the tables of the db.

from litecli.