diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2022-06-19 06:58:13 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2022-06-19 06:58:13 +0000 |
| commit | a4a8868c9aef11c418df378332c597b390e1bc7e (patch) | |
| tree | c68cce344dc53b62c7f7ac5fa92c7dcfb6742c71 /litecli/sqlexecute.py | |
| parent | Adding upstream version 1.8.0. (diff) | |
| download | litecli-a4a8868c9aef11c418df378332c597b390e1bc7e.tar.xz litecli-a4a8868c9aef11c418df378332c597b390e1bc7e.zip | |
Adding upstream version 1.9.0.upstream/1.9.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'litecli/sqlexecute.py')
| -rw-r--r-- | litecli/sqlexecute.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/litecli/sqlexecute.py b/litecli/sqlexecute.py index 2b8fce3..3f78d49 100644 --- a/litecli/sqlexecute.py +++ b/litecli/sqlexecute.py @@ -38,6 +38,13 @@ class SQLExecute(object): ORDER BY tableName, columnName """ + indexes_query = """ + SELECT name + FROM sqlite_master + WHERE type = 'index' AND name NOT LIKE 'sqlite_%' + ORDER BY 1 + """ + functions_query = '''SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE="FUNCTION" AND ROUTINE_SCHEMA = "%s"''' |