Initial prototype

[simonw]

Running this command will open the shell:

sqlite-utils shell data.db

Or omit the database for an in-memory shell.

It will behave in a similar way to the sqlite3 shell - but you'll have access to the extra SQL functions provided by plugins.

[simonw]

Demo so far:

% sqlite-utils shell hi.db
Enter your SQL commands to execute in sqlite3.
Type 'exit' to exit.
sqlite-utils> select 5;
  5
---
  5
sqlite-utils> select 5 + 6;
  5 + 6
-------
     11
sqlite-utils> select * from news;
An error occurred: no such table: news
sqlite-utils> create table foo3 (id integer primary key);
sqlite-utils> insert into foo3 (id) values (1);
1 row affected
sqlite-utils> insert into foo3 (id) values (5);
1 row affected
sqlite-utils> insert into foo3 (id) values (6);
1 row affected
sqlite-utils> select * from foo3;
  id
----
   1
   5
   6
sqlite-utils> delete from foo3;
3 rows affected
sqlite-utils> 

[simonw]

Called without a filename it should use memory instead.

[simonw]

It doesn't have any tests yet but I'm going to ship 0.1 anyway.