feature request: execute a set of commands during startup

[aborruso]

Hi,
it would be great to the option to execute a set of commands during startup.

In example I often load pcre module and I would like to have it as default behavior.

Thank you

[elig0n]

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

[aborruso]

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

[zzl0]

@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.

[rmcgibbo]

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!

[fdietze]

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

[amjith]

@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.

[fdietze]

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!

[bjornasm]

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

[bjornasm]

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