1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
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 %2 to see list of known databases.").arg(syntax.getArgument(DB_NAME), cmdName("dblist")));
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");
}
|
