.schema: line breaks and missing index information

[balta2ar]

sqlite:

→ sqlite3 imdb-cmudb2022.db
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> .schema people
CREATE TABLE people (
  person_id VARCHAR PRIMARY KEY,
  name VARCHAR,
  born INTEGER,
  died INTEGER
);
CREATE INDEX ix_people_name ON people (name);
sqlite>

litecli:

→ litecli imdb-cmudb2022.db
Version: 1.9.0
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
imdb-cmudb2022.db> .schema people
+--------------------------------------------------------------------------------------------------------------+
| sql                                                                                                          |
+--------------------------------------------------------------------------------------------------------------+
| CREATE TABLE people (\n  person_id VARCHAR PRIMARY KEY,\n  name VARCHAR,\n  born INTEGER,\n  died INTEGER\n) |
+--------------------------------------------------------------------------------------------------------------+
Time: 0.012s
imdb-cmudb2022.db>

[kracekumar]

I guess, in the latest version, \nis properly parsed and not sure if it's related to any OS/shell combo.

Definitely index is missing.

LiteCli: 1.14.4 (SQLite: 3.47.1)
test.db> CREATE TABLE people (
           person_id VARCHAR PRIMARY KEY,
           name VARCHAR,
           born INTEGER,
           died INTEGER
         );
Query OK
Time: 0.003s
test.db> CREATE INDEX ix_people_name ON people (name);
Query OK
Time: 0.002s
test.db> .schema people
+----------------------------------+
| sql                              |
+----------------------------------+
| CREATE TABLE people (            |
|   person_id VARCHAR PRIMARY KEY, |
|   name VARCHAR,                  |
|   born INTEGER,                  |
|   died INTEGER                   |
| )                                |
+----------------------------------+
Time: 0.006s
test.db>

[kracekumar]

I can see sqlite supports both .schema and .indexcommand.

sqlite> .schema people1
CREATE TABLE people1(
  person_id VARCHAR PRIMARY KEY,
  name VARCHAR,
  born INTEGER,
  died INTEGER
);
CREATE INDEX ix_people_name_2 ON people1 (name);
sqlite> .index people1
ix_people_name_2            sqlite_autoindex_people1_1
sqlite>

[amjith]

@balta2ar Can you upgrade to the latest version of litecli and let me know if the line breaks are still broken?