search

dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.06k stars 67 forks source link

`--indent` with `.schema` doesnt work #179

Open the-shank opened 1 month ago

the-shank commented 1 month ago

Is there a way to get --indent option to work when printing the schema for a table?

In sqlite3 prompt:

sqlite> .schema runstats --indent
CREATE TABLE IF NOT EXISTS "runstats"(
  "id" INTEGER NOT NULL PRIMARY KEY,
  "run_id" INTEGER NOT NULL,
  "crate_id" INTEGER NOT NULL,
  "functions" INTEGER,
  "functions_converted" INTEGER CHECK(functions >= functions_converted),
  "instances" INTEGER,
  "instances_converted" INTEGER CHECK(instances >= instances_converted),
  "instance_types" INTEGER,
  "instance_types_converted" INTEGER CHECK(instance_types >= instance_types_converted),
  FOREIGN KEY("run_id") REFERENCES "run"("id"),
  FOREIGN KEY("crate_id") REFERENCES "crate"("id")
);
CREATE INDEX "runstats_run_id" ON "runstats"("run_id");
CREATE INDEX "runstats_crate_id" ON "runstats"("crate_id");

In litecli:

❯ litecli aunor.db
LiteCli: 1.11.0 (SQLite: 3.45.3)
GitHub: https://github.com/dbcli/litecli
aunor.db> .schema runstats --indent
Time: 0.000s