From a5530656c152c1e7755d3d219f5b8b72f0f21479 Mon Sep 17 00:00:00 2001
From: Stan Ulbrych <89152624+StanFromIreland@users.noreply.github.com>
Date: Mon, 25 Aug 2025 13:58:00 +0100
Subject: [PATCH] gh-133390: Extend completion for .commands in `sqlite3`
 (GH-135432)

---
 Lib/sqlite3/__main__.py           | 1 +
 Lib/sqlite3/_completer.py         | 9 +++++++--
 Lib/test/test_sqlite3/test_cli.py | 5 +++++
 3 files changed, 13 insertions(+), 2 deletions(-)

diff --git a/Lib/sqlite3/__main__.py b/Lib/sqlite3/__main__.py
index 35344ecceff5..093b38c00013 100644
--- a/Lib/sqlite3/__main__.py
+++ b/Lib/sqlite3/__main__.py
@@ -60,6 +60,7 @@ class SqliteInteractiveConsole(InteractiveConsole):
 
         if not source or source.isspace():
             return False
+        # Remember to update CLI_COMMANDS in _completer.py
         if source[0] == ".":
             match source[1:].strip():
                 case "version":
diff --git a/Lib/sqlite3/_completer.py b/Lib/sqlite3/_completer.py
index f21ef69cad64..b3e8c0e5f362 100644
--- a/Lib/sqlite3/_completer.py
+++ b/Lib/sqlite3/_completer.py
@@ -5,6 +5,8 @@ try:
 except ImportError:
     SQLITE_KEYWORDS = ()
 
+CLI_COMMANDS = ('.quit', '.help', '.version')
+
 _completion_matches = []
 
 
@@ -12,8 +14,11 @@ def _complete(text, state):
     global _completion_matches
 
     if state == 0:
-        text_upper = text.upper()
-        _completion_matches = [c for c in SQLITE_KEYWORDS if c.startswith(text_upper)]
+        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)]
     try:
         return _completion_matches[state] + " "
     except IndexError:
diff --git a/Lib/test/test_sqlite3/test_cli.py b/Lib/test/test_sqlite3/test_cli.py
index 720fa3c4c1ea..5926cec0569d 100644
--- a/Lib/test/test_sqlite3/test_cli.py
+++ b/Lib/test/test_sqlite3/test_cli.py
@@ -249,6 +249,11 @@ class Completion(unittest.TestCase):
         self.assertIn(b"SELECT", output)
         self.assertIn(b"(1,)", output)
 
+        # .commands are completed without changing case
+        input_ = b".ver\t\n.quit\n"
+        output = self.write_input(input_)
+        self.assertIn(b".version", output)
+
     @unittest.skipIf(sys.platform.startswith("freebsd"),
                     "Two actual tabs are inserted when there are no matching"
                     " completions in the pseudo-terminal opened by run_pty()"
-- 
2.47.3