1 files changed, 79 insertions, 0 deletions
diff --git a/SQLiteStudio3/sqlitestudiocli/commands/clicommandtables.cpp b/SQLiteStudio3/sqlitestudiocli/commands/clicommandtables.cpp
new file mode 100644
index 0000000..9a6b325
--- /dev/null
+++ b/SQLiteStudio3/sqlitestudiocli/commands/clicommandtables.cpp
@@ -0,0 +1,79 @@
+#include "clicommandtables.h"
+#include "cli.h"
+#include "schemaresolver.h"
+#include "services/dbmanager.h"
+#include "common/utils.h"
+
+void CliCommandTables::execute()
+{
+    Db* db = nullptr;
+    if (syntax.isArgumentSet(DB_NAME))
+    {
+        db = DBLIST->getByName(syntax.getArgument(DB_NAME));
+        if (!db)
+        {
+            println(tr("No such database: %1. Use .dblist to see list of known databases.").arg(syntax.getArgument(DB_NAME)));
+            return;
+        }
+    }
+    else if (cli->getCurrentDb())
+    {
+        db = cli->getCurrentDb();
+    }
+    else
+    {
+        println(tr("Cannot call %1 when no database is set to be current. Specify current database with %2 command or pass database name to %3.")
+                .arg(cmdName("tables")).arg(cmdName("use")).arg(cmdName("tables")));
+        return;
+    }
+
+    if (!db->isOpen())
+    {
+        println(tr("Database %1 is closed.").arg(db->getName()));
+        return;
+    }
+
+    println();
+
+    SchemaResolver resolver(db);
+    resolver.setIgnoreSystemObjects(!syntax.isOptionSet(SHOW_SYSTEM_TABLES));
+    QSet<QString> dbList;
+    dbList << "main" << "temp";
+    dbList += resolver.getDatabases();
+
+    int width = longest(dbList.toList()).length();
+    width = qMax(width, tr("Database").length());
+
+    println(pad(tr("Database"), width, ' ') + " " + tr("Table"));
+    println(pad("", width, '-') + "-------------------");
+
+    foreach (const QString& dbName, dbList)
+    {
+        foreach (const QString& table, resolver.getTables(dbName))
+            println(pad(dbName, width, ' ') + " " + table);
+    }
+
+    println();
+}
+
+QString CliCommandTables::shortHelp() const
+{
+    return tr("prints list of tables in the database");
+}
+
+QString CliCommandTables::fullHelp() const
+{
+    return tr(
+                "Prints list of tables in given <database> or in the current working database. "
+                "Note, that the <database> should be the name of the registered database (see %1). "
+                "The output list includes all tables from any other databases attached to the queried database.\n"
+                "When the -s option is given, then system tables are also listed."
+                ).arg(cmdName("use"));
+}
+
+void CliCommandTables::defineSyntax()
+{
+    syntax.setName("tables");
+    syntax.addArgument(DB_NAME, tr("database", "CLI command syntax"), false);
+    syntax.addOptionShort(SHOW_SYSTEM_TABLES, "s");
+}