summaryrefslogtreecommitdiffstats
path: root/mycli/packages/special/dbcommands.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2022-09-07 09:38:54 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2022-09-07 09:38:54 +0000
commit69a60002fd1bb149ca60d888e5b290ba527ae400 (patch)
tree70b027a809ee8f8fea766316f8d52f56b1dc6f32 /mycli/packages/special/dbcommands.py
parentAdding upstream version 1.25.0. (diff)
downloadmycli-69a60002fd1bb149ca60d888e5b290ba527ae400.tar.xz
mycli-69a60002fd1bb149ca60d888e5b290ba527ae400.zip
Adding upstream version 1.26.1.upstream/1.26.1
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mycli/packages/special/dbcommands.py')
-rw-r--r--mycli/packages/special/dbcommands.py5
1 files changed, 4 insertions, 1 deletions
diff --git a/mycli/packages/special/dbcommands.py b/mycli/packages/special/dbcommands.py
index 45d7069..5c29c55 100644
--- a/mycli/packages/special/dbcommands.py
+++ b/mycli/packages/special/dbcommands.py
@@ -34,6 +34,7 @@ def list_tables(cur, arg=None, arg_type=PARSED_QUERY, verbose=False):
return [(None, tables, headers, status)]
+
@special_command('\\l', '\\l', 'List databases.', arg_type=RAW_QUERY, case_sensitive=True)
def list_databases(cur, **_):
query = 'SHOW DATABASES'
@@ -45,6 +46,7 @@ def list_databases(cur, **_):
else:
return [(None, None, None, '')]
+
@special_command('status', '\\s', 'Get status information from the server.',
arg_type=RAW_QUERY, aliases=('\\s', ), case_sensitive=True)
def status(cur, **_):
@@ -146,7 +148,8 @@ def status(cur, **_):
stats.append('Queries: {0}'.format(status['Queries']))
stats.append('Slow queries: {0}'.format(status['Slow_queries']))
stats.append('Opens: {0}'.format(status['Opened_tables']))
- stats.append('Flush tables: {0}'.format(status['Flush_commands']))
+ if 'Flush_commands' in status:
+ stats.append('Flush tables: {0}'.format(status['Flush_commands']))
stats.append('Open tables: {0}'.format(status['Open_tables']))
if 'Queries' in status:
queries_per_second = int(status['Queries']) / int(status['Uptime'])