Skip to content

gh-133390: Support table, index, trigger, view, column, function, and schema completion in the sqlite3 CLI #136101

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
encukou merged 14 commits into from
Oct 24, 2025
Merged

gh-133390: Support table, index, trigger, view, column, function, and schema completion in the sqlite3 CLI #136101

Changes from 1 commit
Commits
Show all changes
14 commits
Select commit Hold shift + click to select a range
7164755
Support table, index, trigger, view, column, function, and schema com…
tanloong Jun 24, 2025
a641e59
blurb add
tanloong Jun 29, 2025
0bfc0fd
Merge branch 'main' into sqlite3-cli-completion-table-index-triger-vi…
tanloong Jul 1, 2025
47d7fb4
Add what's new
tanloong Jul 1, 2025
393e24c
Merge branch 'main' into sqlite3-cli-completion-table-index-triger-vi…
tanloong Aug 9, 2025
dfd3721
Merge branch 'main' into sqlite3-cli-completion-table-index-triger-vi…
tanloong Oct 4, 2025
62b9dc5
Merge branch 'main' into sqlite3-cli-completion-table-index-triger-vi…
tanloong Oct 8, 2025
164a9e1
use SQLite for more of manipulating and filtering
tanloong Oct 8, 2025
2c99f21
formatting
tanloong Oct 9, 2025
088e741
add comment
tanloong Oct 9, 2025
445e279
test case-insensitive completion
tanloong Oct 12, 2025
10f09e0
Merge branch 'main' into sqlite3-cli-completion-table-index-triger-vi…
tanloong Oct 12, 2025
658d41c
skip PRAGMA-dependent completion tests on older SQLite versions (3.16…
tanloong Oct 12, 2025
48c60bf
add another assertion
tanloong Oct 21, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
formatting
  • Loading branch information
@tanloong
tanloong committed Oct 9, 2025
commit 2c99f21baf804747d40267097b0af332ccd79481
26 changes: 14 additions & 12 deletions Lib/sqlite3/_completer.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -15,14 +15,15 @@ def _complete(con, text, state):
global _completion_matches

if state == 0:
text_upper = text.upper()
text_lower = text.lower()

if text.startswith('.'):
_completion_matches = [c + ' ' for c in CLI_COMMANDS if c.startswith(text)]
if text.startswith("."):
_completion_matches = [
c + " " for c in CLI_COMMANDS if c.startswith(text)
]
else:
text_upper = text.upper()
_completion_matches = [c + ' ' for c in SQLITE_KEYWORDS if c.startswith(text_upper)]
_completion_matches = [
c + " " for c in SQLITE_KEYWORDS if c.startswith(text_upper)
]

cursor = con.cursor()
schemata = tuple(row[1] for row
Expand Down Expand Up @@ -57,24 +58,25 @@ def _complete(con, text, state):
)
)
except OperationalError:
# skip on SQLite<3.16.0 where pragma table-valued function is not
# supported yet
# skip on SQLite<3.16.0 where pragma table-valued function is
# not supported yet
pass
# functions
try:
_completion_matches.extend(
row[0]
for row in cursor.execute("""\
SELECT DISTINCT UPPER(name) || '(' FROM pragma_function_list()
row[0] for row in cursor.execute("""\
SELECT DISTINCT UPPER(name) || '('
FROM pragma_function_list()
WHERE name NOT IN ('->', '->>') AND
name LIKE REPLACE(:text, '_', '^_') || '%' ESCAPE '^'""",
{"text": text},
{"text": text},
)
)
except OperationalError:
# skip on SQLite<3.30.0 where function_list is not supported yet
pass
# schemata
text_lower = text.lower()
_completion_matches.extend(c for c in schemata
if c.lower().startswith(text_lower))
_completion_matches = sorted(set(_completion_matches))
Expand Down
Loading