bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31,632 Commits 1,672 Branches 385 Tags
cli-prompt
Commit Graph

31632 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
d08caad3a5 Fix harmless compiler warnings. 
FossilOrigin-Name: 3b4cc8d3beab8c910dd954bf8093f7ab499e4690b9cf882f981c4415dd7a7540
 2026-04-11 17:47:31 +00:00
drh
28456958ca Initial test cases for the CLI prompt enhancements. 
FossilOrigin-Name: b7ecc84735d41e9cdb498020b86d8219efa18ca5b40aef1031a14809f1ac2d38
 2026-04-11 16:12:12 +00:00
drh
3b27ffa534 Add --reset, --show, and -- options to the ".prompt" command of the CLI. 
FossilOrigin-Name: 8075576ba2324a458440bae398baecc7872b6528574b7fe6681a3a30b62d58ef
 2026-04-11 15:45:45 +00:00
drh
fc2c730c87 Enhancements to shell_prompt_test() for better testing. Enhance the 
".open" command so that it does ~/ expansion on filenames.

FossilOrigin-Name: ec6830fe60b73bc606d3c2a5d407a39db53f6dadee760829410abfa1df46389e
 2026-04-11 14:11:56 +00:00
drh
cd28797117 Remove arbitrary limits on the length of CLI prompts. Use environment 
variables SQLITE_PS1 and SQLITE_PS2 (if they exist) as the default
CLI prompts.

FossilOrigin-Name: a46ceaeab968d8f376c5a225c23c0be8619fed4511b7e567baf3a8d7736c19d1
 2026-04-11 12:35:53 +00:00
drh
c8b130f255 Fix the \B escape for prompts so that it uses wcwidth() instead of 
strlen() to compute spacing.

FossilOrigin-Name: c6ff4f701d9cf963cf2472ed72ad4e201227560dde2ba8d48602af2e49170e89
 2026-04-11 11:24:09 +00:00
stephan
504cfd5ec7 Ensure that sqlite3-opfs-async-proxy.js is copied into the fiddle target dirs. 
FossilOrigin-Name: 7c9998de1b839cfbe12c4328ac5176f5fae981e139c5f8888b100752f5e4756b
 2026-04-10 23:25:57 +00:00
stephan
9d950aa13b A protype of .prompt support in fiddle but its utility there is in doubt because .open does not work there, so there's very little dynamic info worth showing in a prompt. Also, ANSI colorization can't work there, nor can we colorize the prompts using HTML because of limitations in jquery.terminal. 
FossilOrigin-Name: 3b17500dc6338df23d1ed0572cd71593da5a9b048731f73242e27b9a76553a27
 2026-04-10 23:05:41 +00:00
drh
01e1be854b Fix minor issues on Windows. 
FossilOrigin-Name: 48e40d3f6a193d6c4d1b8deda36415a690602dbe33d49984a9d92c6d40d8da5c
 2026-04-10 20:44:38 +00:00
drh
70868a5ae3 Fix prompt for in-memory databases. Fix the continuation mechanism so that 
it looks at all accumulated lines, not just the most recent line.

FossilOrigin-Name: 166894725569cafa96c434aa14db0428db6791a8296fcc2990bec4ec819fd876
 2026-04-10 20:29:35 +00:00
drh
d0065c8118 Replace the former dynamic-continuation prompt logic with backslash-escape 
prompt expansion, include some expansions that serve the same role as the
old dynamic-continuation prompts.  This allows greater user
configurability.

FossilOrigin-Name: 052631202e4dd930d93434b7003e73b23557934421ace5d2f382f041638d5518
 2026-04-10 20:14:16 +00:00
drh
bd574dbaee Add the \B escape for CLI prompts. Change the default prompts to 
use \f, \H, and \B.

FossilOrigin-Name: 354325b6f396bda38bbb82e7d38aa50d3d6441e1ebb9b578aed8e0bcf62f9911
 2026-04-10 20:06:34 +00:00
drh
7632922625 The \H escape on a prompt string fills in with the characters needed 
to make the input "complete".  Add the shell_expand_prompt() SQL function
for testing purposes.

FossilOrigin-Name: 6aafb76c74b73aafef74250dae9c8cbe73226c0efb606e8f80ea761b3293cf9d
 2026-04-10 19:33:15 +00:00
drh
49998a6d25 Merge trunk fixes and enhancements into the cli-prompt-redo branch 
FossilOrigin-Name: f3354ebf51e684ef680986bef9b606f63786c254f1c8774bcaf7a7f3d0d37056
 2026-04-10 18:53:13 +00:00
drh
92c435cda7 Improve defenses in QRF against trying to run the same prepared statement 
twice, concurrently.

FossilOrigin-Name: 6ab6f622be3e1ad93166d139b5fccf9628c86d1c14c6dfb4464cb8cf52c94785
 2026-04-10 18:14:33 +00:00
stephan
35f8abcfd0 API doc correction for sqlite3_js_retry_busy(). No code changes. 
FossilOrigin-Name: 749c537812b907164b7e7ad1fddc1aee8106c59875d2686fe83d602cd0e07611
 2026-04-10 17:55:31 +00:00
drh
1a315c0d51 Use sqlite3_malloc() for memory allocation inside of sqlite3_str_vappendf(), 
since it invokes sqlite3_initialize(), whereas sqlite3DbMallocRaw() does
not.

FossilOrigin-Name: a2f84c56316ea746c134aa6e5a2b46021f67c6642161beae8122f73daeddda92
 2026-04-10 17:11:16 +00:00
drh
3a8d38ffc0 Fix the printf() optimization added at [ccb6b6c4ac21742d] so that 
sqlite3_snprintf() does not incorrectly truncate floating-point
conversions that are close to filling the buffer, as reported in
[forum:/forumpost/2026-04-10T13:48:12z|forum post 2026-04-10T13:48:12z].

FossilOrigin-Name: a50521a16068e555aa08ee25726b081bb4cd33e3ea388b82dcbaa691c2576284
 2026-04-10 15:55:08 +00:00
drh
693b15ac83 Prototype sqlite3_incomplete() - a variant of sqlite3_complete() that returns 
additional information about what is needed to complete the statement.

FossilOrigin-Name: a698fbfb8bb256ee0d9802c01562c11492ca2800a45360b268ac6cf397a7fad7
 2026-04-10 13:43:48 +00:00
drh
8cdc2abf07 Attempt to work around a bug in legacy Microsoft compilers. 
[forum:/forumpost/2026-04-10T06:33:11z|Forum post 2026-04-10T06:33:11z].

FossilOrigin-Name: 661e1413625f55c37e2cd4d785074576d355e125231bbc1dd0a511a2b02c8e3b
 2026-04-10 10:48:04 +00:00
drh
931fa90d74 Change a variable name to try to quash a compiler warning reported 
by [forum:/forumpost/2026-04-10T09:33:27z|forum post 2026-04-10T09:33:27z].
This is just a guess, as we have no way of reproducing the warning,
and hence no way of knowing if it fixes the problem.

FossilOrigin-Name: e065c019d29d4e82a21a89984b86c1811c2b1bdd4663c792857cf89ea2cd91c3
 2026-04-10 10:27:04 +00:00
stephan
eb9a6a95ca Correct shell result code propagation regression introduced in [ff084ae341eab5c4] and reported in [forum:6fa3247e9724844c|forum post 6fa3247e9724844c]. 
FossilOrigin-Name: a76682a3b1d6c5e8ca16caf8afbe545c9ae39849fe21ba68d4cddae683a409b5
 2026-04-10 08:36:55 +00:00
drh
b37bf0b8b4 Improvements to the way \x works so that it can be used to change 
the prompt color.  This really messes with linenoise, though.

FossilOrigin-Name: bbee56f970ade40734c8a278f46d8a268b305fe349c3739c977fa9141d2c3b6a
 2026-04-10 00:55:40 +00:00
drh
850104bbad A prototype of code that shows how to expand backslash escapes in the 
CLI prompt.

FossilOrigin-Name: 9cf28959671920b4909521bb1db6f0cbbc85448fbf3594c43b4000505b4e055b
 2026-04-09 23:37:48 +00:00
drh
6a6ebb0d06 Store the prompts as part of the ShellState object, not as global variables. 
FossilOrigin-Name: 39f6c5a8a7d91e03f89b13496e333b9500977a2cbcc0c27ba14dfb87dc81e678
 2026-04-09 22:14:58 +00:00
drh
30b824e432 Strip out the legacy dynamic prompt generation. It will go back in as I 
add the user-defined prompt escapes.

FossilOrigin-Name: ab08b7a8ef518f96a549a41fe8ff11776abe5e83153c5f8d5d58694ecc476389
 2026-04-09 20:21:25 +00:00
drh
3944e70677 Clean-ups in prompt generation in the CLI. 
FossilOrigin-Name: e2c9d4c6b731ea9afbb9cb22f86a3db3670ca67968f15891dc46ae1fc9ba34dc
 2026-04-09 18:51:09 +00:00
drh
df0e915ad2 Use O_TMPFILE (on systems that support it) to security create a temporary 
file that is inaccessible to any other process.

FossilOrigin-Name: 4609ba34b8b4a6df4cd28e39d19f96e59580db0e838f1aa605cc00ea003c2a85
 2026-04-09 16:16:39 +00:00
drh
b0d9039c8c Updates to testrunner.tcl: Shorten the prefix on created subdirectories from 
"testrunner_bld_" to just "testrun_".  Do not append ".exe" to the names of
created subdirectories.  Add the "clean" command to recursively remove all
subdirectories and files created by a test run.

FossilOrigin-Name: 450c7edf1247024db4b66f38bf9561c5c6b0c4175c4df8de17019aea6cbde5cf
 2026-04-09 16:08:29 +00:00
drh
f1cc3c4be5 Version number to 3.54.0 to begin the next development cycle. 
FossilOrigin-Name: 4c2a5c9bb40c63bb9d0f633f78d132bdd69b9d755d4e6d5e3cb534e63b383a4e
 2026-04-09 16:03:56 +00:00
drh
3aed7dc446 Make use of O_TMPFILE for more secure temporary file creation, when that 
option is available.

FossilOrigin-Name: 094fc6da0768ea0ec4b4d3dc020cd6025aab341550d6cea6be7487ac570f9171
 2026-04-09 14:12:09 +00:00
drh
9a8732e44b Merge the 3.53.0 release changes into the cli-prompt branch 
FossilOrigin-Name: 8fd48b9fe47d47b3eca31d187f1d98174c257daea220ae7be18e4c82764d9d5c
 2026-04-09 13:21:09 +00:00
drh
4ebc7fdcf4 Version 3.53.0 
FossilOrigin-Name: 4525003a53a7fc63ca75c59b22c79608659ca12f0131f52c18637f829977f20b
major-release release version-3.53.0 		2026-04-09 11:41:38 +00:00
dan
a5495355c4 Fix some buffer overreads that might occur in the session module when handling corrupt changesets. 
FossilOrigin-Name: cda5dd9bcbef2135bb9855139a11d0e22a092f9498d82eb18e7d4401264b6eb8
 2026-04-09 10:39:32 +00:00
dan
df3e207501 When generating make.sh for testrunner, correctly quote the value of any options passed via environment variable OPTS. 
FossilOrigin-Name: 0837933b49f5fc5590f2052808bc305aceccafbf5db65aae250c594ce48d4d32
 2026-04-09 06:38:31 +00:00
dan
535b1f2875 Fix some buffer overreads that might occur in the session module when handling corrupt changesets. 
FossilOrigin-Name: 8fcf92e15d87487703afc1129f3a89a8d4d72cb30d30a1a9151a5596473069bd
 2026-04-09 05:33:19 +00:00
drh
a7200804eb Fix a buffer overflow bug in a recent check-in, reported by unsolicted 
email from OpenAI/Codex.

FossilOrigin-Name: be891a137af15897691250324e4d3d9c96f0c5fb414bca27d0c3bfdd3012a8a2
 2026-04-08 17:00:33 +00:00
stephan
0d979c217f Fix a few doc typos and inconsistencies. No code changes. 
FossilOrigin-Name: 025abd4cf409fb9938e116289f23dc5bcd6d14feb46066221e691b146ee9b354
 2026-04-07 15:54:35 +00:00
drh
e9af8caac0 Fix incorrect datatype on the auto_ext_leak_tester() function in the CLI. 
FossilOrigin-Name: 4a36454904e1c5e7d25406713ab0125f11df66eabe0d378edcb837ef8dedc981
 2026-04-07 12:51:52 +00:00
drh
606c64a543 Fix redundant typedef in qrf.c when that file is amalgamated into 
tclsqlite3.c.

FossilOrigin-Name: b8f0c71b48953cb6d5a8b3d33d004a31b63c59d59d455f285bf8fa91c3b07129
 2026-04-07 11:31:41 +00:00
stephan
eefe3aa9ad Replace a doc reference to a renamed file, as reported by [forum:5d9d70c618|forum post 5d9d70c618]. No code changes. 
FossilOrigin-Name: c8121593fa455cd43b3878f8b65ebac47c07dab4b8ce081aa34b14fc9440afbc
 2026-04-07 09:15:21 +00:00
stephan
fcef193a82 Add a dummy auto-extension to the shell in SQLITE_DEBUG builds to validate that [9d56df17b4ab49] does the right thing. 
FossilOrigin-Name: 164af3703b8fb5d88612edcceeaae0ae5a230c34c7a0f2ac9b650f5a742b2787
 2026-04-06 22:00:20 +00:00
stephan
8e7ffc09f5 Add a call to sqlite3_reset_auto_extension() near the end of shell.c.in:main() to squelch a leak message when SQLITE_EXTRA_INIT adds auto-extensions, as reported in [forum:310cb231b07c80d1|forum post 310cb231b07c80d1]. 
FossilOrigin-Name: c4dd7e8b36deced3ee9cc6b5f87d8b3cc9a752cad8d62c9b711c7b58db11834b
 2026-04-06 20:24:02 +00:00
drh
9ad63c0f4e Appease static analyzers by masking the index to the 
WalHashLoc.aPgno array to make it easy to prove that there
is never OOB read or write.

FossilOrigin-Name: 9d56df17b4ab4940f7bc24488a9df118f6172fcfbf3e5cb95bdcbd2db2a07911
 2026-04-04 14:43:37 +00:00
stephan
d4b74b9fac Add some comments to the OPFS async proxy about potential future experimentation. No code changes. 
FossilOrigin-Name: 9c14ee74305a5db3be95dbd9ae8d1db0abf39b323001be4e2f02b7226e6ca0d3
 2026-04-04 08:07:25 +00:00
drh
7ff8b558e8 Enhance testrunner.tcl so that a PATTERN argument that begins with "~" is 
an "anti-pattern".  Only run tests that match one or more patterns if there
are any patterns *and* do not match any anti-pattern.

FossilOrigin-Name: c313d91bb67b56be2db46194c3baa5a72b469595de3b2abe249612838dc175e4
 2026-04-03 19:48:01 +00:00
stephan
bb6d2a5f07 configure script: replace two 'file normalize' calls with file-normalize (a tcl/jimsh compatibility issue) to fix --with-linenoise. Problem reported in [forum:ce688d13793bd78f|forum post ce688d13793bd78f]. 
FossilOrigin-Name: 2be1c5a3e47f1276b9f0a4771f2d5fb0bc1ccb907c855caa04d757b4145533f5
 2026-04-03 13:54:48 +00:00
drh
217c590688 Fix Tcl9 compatibility issues in test_session.c. 
FossilOrigin-Name: 1387b5819085146cafb0e8740410faaa48bfb5aefc78ff763aaa8e85744d48b3
 2026-04-03 11:48:00 +00:00
drh
fc19b2ca8a Minor patch to test/json/json-speed-check.sh. That script is not maintained, 
but this fix at least gets it working for now.

FossilOrigin-Name: 9d92e371ca375776d251fe446f17a437823cc96e48a5c45f42cb0768d0a47f65
 2026-04-02 16:21:47 +00:00
drh
939930db1e Improvements to the syntax hints in the continuation prompt of the CLI 
FossilOrigin-Name: 5c544f169680804c9652b8f9fc843a4bac052706be6bac205baf13a8c83fc840
 2026-04-02 11:43:04 +00:00