summaryrefslogtreecommitdiffstats
path: root/litecli/packages/special/dbcommands.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2023-12-10 10:18:43 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2023-12-10 10:18:43 +0000
commit44ba8147bbb1b651867b4b04e1711273d4a7281c (patch)
treed8c169e12006bfa46e436a180fd531aaac08aad5 /litecli/packages/special/dbcommands.py
parentAdding upstream version 1.9.0. (diff)
downloadlitecli-44ba8147bbb1b651867b4b04e1711273d4a7281c.tar.xz
litecli-44ba8147bbb1b651867b4b04e1711273d4a7281c.zip
Adding upstream version 1.10.0.upstream/1.10.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'litecli/packages/special/dbcommands.py')
-rw-r--r--litecli/packages/special/dbcommands.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/litecli/packages/special/dbcommands.py b/litecli/packages/special/dbcommands.py
index 203e1a8..dec3507 100644
--- a/litecli/packages/special/dbcommands.py
+++ b/litecli/packages/special/dbcommands.py
@@ -69,13 +69,14 @@ def show_schema(cur, arg=None, **_):
args = (arg,)
query = """
SELECT sql FROM sqlite_master
- WHERE name==?
+ WHERE name==? AND sql IS NOT NULL
ORDER BY tbl_name, type DESC, name
"""
else:
args = tuple()
query = """
SELECT sql FROM sqlite_master
+ WHERE sql IS NOT NULL
ORDER BY tbl_name, type DESC, name
"""
@@ -212,7 +213,7 @@ def load_extension(cur, arg, **_):
"Description of a table",
arg_type=PARSED_QUERY,
case_sensitive=True,
- aliases=("\\d", "describe", "desc"),
+ aliases=("\\d", "desc"),
)
def describe(cur, arg, **_):
if arg: