bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
30,835 Commits 1,672 Branches 385 Tags
qrf
Commit Graph

126 Commits

Author SHA1 Message Date
drh
53794ab541 The -textjsonb option is on by default in the standard non-batch mode of 
the CLI.  New fast screening test for JSONB.

FossilOrigin-Name: fd09f934d64ec07fd56f1b80ab05dafb28b605d5802ff5758eea17d8ad24e3cc
 2025-11-17 18:51:55 +00:00
drh
234d2e51ac CLI comes up in legacy "list" mode if neither stdin or stdout are a tty, or 
if "--compat 20251114" or earlier is specified, or if "--batch" is used.
New modes "batch" and "tty" select either legacy "list" mode or the newer
"qbox" mode with limits.
Make CVS output compatible with legacy.  Break out ".import" into a separate
subroutine in anticipation of forthcoming improvements.  General code
cleanup.

FossilOrigin-Name: f6bfcea9a01493af182e9aa0d35df6f81bf9e36220df79139afa287fa43d9aa3
 2025-11-17 16:44:13 +00:00
drh
4d91527aa5 Fix a bug in ".show". Adjust test cases for the new default mode. 
FossilOrigin-Name: 2aebd7bfecaaf1f75b52b05a0d3009fc0dc61289ae666d24cb4e3ddfaf251645
 2025-11-16 23:06:45 +00:00
drh
f4870a2b51 Improved --safe mode defenses. Fix a test case error. 
FossilOrigin-Name: eacc9db80de8baa878ebdc3a054538c8998db9a2e46720c0d8b109d62a0cac29
 2025-11-16 01:34:01 +00:00
drh
d5ee8aa625 Fix various bugs and compiler warnings. All tests now passing on linux, mac, 
and windows.  More testing needed, though.

FossilOrigin-Name: 2220cb70c2f1ee30dcdf917a20feacdfcb3789433d0645fea626fd4c5cf0d099
 2025-11-14 13:07:45 +00:00
drh
c37fcdd5d1 Improvements to --titles handling in the .mode command. Fix shell1 test 
cases having to do with quoting of NULL values in "tcl" mode.

FossilOrigin-Name: 0fef770bd654b8ba8011b0bb610128058e75e8444f86c51e7ea59a6f2625a3fc
 2025-11-14 02:22:39 +00:00
drh
a9136b45fa Continuing code cleanup. Various minor bug fixes. All legacy tests now 
pass.  All planned features for ".mode" are implemented, at least at the
interface level, though some features are still no-ops.

FossilOrigin-Name: e5a81711d0076b447e5bd3206bc04d755a6229b9f4926f42260fcd01ecf3e5a2
 2025-11-12 18:54:09 +00:00
drh
7f947dbd6c Move the ".output" command into a separate subroutine. Enhance .output so 
that it is able to capture output in a sqlite3_str object, then compare that
captured output we patterns to accomplish tests.

FossilOrigin-Name: ddd167044753f5215624fc9ee0e3657836c528f23a6a3e262401fd1b64cdbb21
 2025-11-11 14:08:50 +00:00
drh
09f16c5ab6 Add the bTextNull field to sqlite3_qrf_spec. Use QRF to implement "tcl" 
mode in the CLI.

FossilOrigin-Name: 2ba92320db3c16c3c91e29ea935ae92da546261f25846d242bd2dd27e0b7e032
 2025-11-10 12:32:04 +00:00
drh
e2201e40ce Fixes to autoExplain 
FossilOrigin-Name: 38e4171697057437fc9f70f8734c7f557b91da47804ff10b3d2481802377222f
 2025-11-10 00:18:36 +00:00
drh
3e98ff6b1d Remove about a thousand lines of dead code from shell.c.in. 
FossilOrigin-Name: efbcc7decd5347e3460cc3ed62720c8c3932225dfdf92293a990c51895450906
 2025-11-08 23:35:57 +00:00
drh
ec27a2e7e5 Fix some problems. But there is a need to do major surgery on the 
table layout algorithm, so it seems good to snapshot before proceeding.

FossilOrigin-Name: 9052991a897ad12ac54476d9a370d1ad18937abc3c3fc11efcb678f21cb5ef69
 2025-11-07 19:20:49 +00:00
drh
d2424338b0 Incremental check-in. QRF is working, but there are many test failures 
in the shell test modules.

FossilOrigin-Name: de7fc9afc43d4bd5f5995832cd698633e0e7213c190fa044856c9f82512161f9
 2025-11-07 17:48:14 +00:00
drh
1c19c06246 Fix the output of ".dump" in the CLI so that the sqlite_sequence table 
is created using correct syntax.

FossilOrigin-Name: 4b9f2e1d4485ad3baf9285aa09b468469be929b18cb308f19af471d7aac66076
 2025-10-31 11:23:44 +00:00
drh
139ec38ac8 Further improvements the ".dump" command to handle corner cases. 
FossilOrigin-Name: cd0c77934ff32050380c2143bba7d4e6c07d5f08187cb5d5e8e7602854d1cda8
 2025-10-30 18:52:48 +00:00
drh
c5ff2aa7cf Fix the CLI ".dump" command so that it does not make duplicate 
sqlite_sequence table entries as described in
[forum:/forumpost/b1674b56ad|forum thread b1674b56ad].

FossilOrigin-Name: c833f26a6780f919551e50c67d308e96293cec8481899354411d805617481f24
 2025-10-30 11:39:49 +00:00
dan
9b6bc61dbd Fix some integer overflow warnings in the base64 and base85 extensions. 
FossilOrigin-Name: 06b4bd2aba22c57f5a5fed606c3bee225dee6fdc13bb16cc58194040ef0d7d85
 2025-10-07 15:14:03 +00:00
drh
dc868ef879 Convert the ShellText object in the CLI to use sqlite3_malloc64() rather than 
plain malloc().  Avoid unnecessary quoting of table names in .dump output
and similar.  Improved detection of OOM in set_table_name().

FossilOrigin-Name: 6ce4f6dc15a575c318669051fe6590ad114b52ff3f3e260cdf7accccdd922d63
 2025-09-25 10:55:54 +00:00
drh
2c88a2ffb5 Rework the set_table_name() function in the CLI to use modern APIs. 
[forum:/forumpost/2baa4acd64|Forum post 2baa4acd64].

FossilOrigin-Name: 821cc0e421bc14a68ebaee507e38a900e0c84ff6ba7ee95bf796cad387755232
 2025-09-24 19:10:58 +00:00
stephan
2d49219b1c Correct two tests in shell1.test which were broken by the addition of new output in [0f11087b8475]. 
FossilOrigin-Name: 909dd0a02a967baef46c3efdca42a0ab4e15003e34ce7e9af82fce5f17213d7b
 2025-03-28 16:31:54 +00:00
jan.nijtmans
d07045119d shell1.test: == => eq 
FossilOrigin-Name: 99fdd19193056259d84768f46519328c300976b102f1b1e0b815720df01b28d0
 2025-03-27 17:25:38 +00:00
drh
72b5c6db35 Avoid running test cases involving ANSI control characters or Unicode 
on Windows in a slave interpreter, as that combination does not work.

FossilOrigin-Name: f6745a7355c62ee64c08e23b795f437dd74add903b55e1255c1d03f9a811170d
 2025-03-11 15:46:23 +00:00
drh
b8ec04ee02 Fix a test case that was broken when the default --escape type was changed 
by the previous check-in.

FossilOrigin-Name: 5f2531e068b4856db2270518c370b65cbd0c0ab5443d76f1fb1116fe9ad80296
 2025-02-25 20:36:46 +00:00
drh
87ad172c50 Enhancements to help avoid problems in the CLI when trying display content 
that contains ANSI escape codes:  (1) Add the --escape MODE option to the CLI
where MODE is one of "symbol", "ascii", "off" where the default is "symbol".
(2) Add the unistr() SQL function.  (3) Add the unistr_quote() SQL function.
(4) Add the %#Q and %#q conversions in the built-in printf.

FossilOrigin-Name: e3e509ae145ee2623ac68ededa59991a97fcd28313e03f67a3890b560c5381b0
 2025-02-25 15:57:49 +00:00
drh
96a65cc474 Three different --escape modes: symbol, ascii, off. 
FossilOrigin-Name: b5adb52fc0dc1838cb9c66cff422f2b8ec147e546cf909dd3c48731fa1edfe50
 2025-02-24 00:18:12 +00:00
drh
8d15d7ed68 Work toward VT100-safe output from the CLI by default. 
FossilOrigin-Name: 44c44620e8648a4265053f194e32b3a5c65d25b4f1fff61ef9b944e7cb0ed624
 2025-02-23 20:20:56 +00:00
dan
c978e390e6 Fix release test errors on winrt. 
FossilOrigin-Name: 39bebd50b80ceee321b1da837c72a20cdb26f06e4b726f23e3ddac877d9400a7
 2024-12-16 19:31:30 +00:00
drh
17408fbbd8 An improved method for statically linking sqlite3_analyzer.exe using Tcl9. 
Enable wildcard expansion of arguments to testfiture on Windows.

FossilOrigin-Name: 9b87ea219bce5689a69efac31063b9b11928e59124c0d36194715ff7faa5129d
 2024-10-11 17:02:37 +00:00
drh
b7ceffdadf Fix shell test cases to account for recent additions to the ".help" output. 
FossilOrigin-Name: 54c22bc6165affbea0d1166a0912d19939300ccc4ae33a6b2ed8c510ab61c574
 2024-09-26 01:29:22 +00:00
drh
4400b0ac45 Fix a problem with strictly conforming UTF8 in shell1.test. 
FossilOrigin-Name: 8ee187f98d310e1e7cf6c3fdf000c19e98a9f11e01436c3c407df04da79aa7c0
 2024-07-31 02:01:19 +00:00
dan
2dbf276e93 Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it. 
FossilOrigin-Name: 6eae4547d4d50c798d1f05eaa1da02f4682d261dbd64e94748179923839024e6
 2024-03-11 19:33:55 +00:00
larrybr
5d175eb020 Fix output redirect bug reported in [forum:/forumposts/cbf4933cfeee74bb|the forum]. 
FossilOrigin-Name: ce542fee6f0150bbd13505dcd26b21a9d1d23eb2dc8e78e63f9da6b4298ec028
 2023-11-23 07:08:49 +00:00
larrybr
033127af75 Cherrypick shell1.test fix. 
FossilOrigin-Name: 91c888eddbcb1b461f7d562c2f0eee57f1a2be7f9959b9d69e80fc7c1da20e9e
 2023-11-20 00:21:24 +00:00
drh
aa040d891f Fix the shell1.test test so to align with the new behavior imposed by 
[bce807cd48763273] - that backslash escapes only work without quoted arguments
in dot-commands of the CLI.

FossilOrigin-Name: 0db82b4281a0e0d5e365553df11e0347f60c00c861c0fb96227059edff3a0ef6
 2023-10-23 02:01:14 +00:00
larrybr
d8200de04d Give CLI quoted args hex escapes (as documented.) 
FossilOrigin-Name: 90e434a6ae370a35109802fc336b98298d345f3d23125ef2cc68c31d8e69bb50
 2023-05-02 19:33:27 +00:00
larrybr
a9fffc179f Give CLI a no-more-options option. (--) 
FossilOrigin-Name: 0822788752621f6bf6af44b420b594ddd352634b3b0ed0eb835abea34b45817a
 2023-03-10 20:54:44 +00:00
larrybr
0953c5354a Add base64() and base85() text/blob conversions to the CLI. 
FossilOrigin-Name: 4bc98a2d9520efa9b80142163cbfab72a5f2fe9854cd6ba8291dcefdb872e657
 2022-12-23 19:04:59 +00:00
larrybr
2f5f674066 Simplify .import leak plug and arrange for CLI to be run under valgrind. 
FossilOrigin-Name: 0d3e2380197aa3e725591266acaeb0d43a7e794ca9153e6c56253cdcf60720b1
 2022-05-09 12:29:47 +00:00
larrybr
6403e77d3b For CLI, fix how columnar mode fills in empty portions of wrapped row outputs. 
FossilOrigin-Name: 77aed89192bdbad819ac17bf5d08728278a9b8cbbbef1d805df230caff79b417
 2022-04-20 22:41:10 +00:00
larrybr
4c5c6214b1 CLI auto-column rename revamped after forum discussion. 
FossilOrigin-Name: 2da1f8e45eb0cb1ead6049df6a31a903bfad5a7abd27e92cd3dac25fe355aec3
 2022-02-11 01:21:09 +00:00
drh
633c798283 Do not show the error code number of CLI error messages unless the error 
is something other than 1 (SQLITE_ERROR).

FossilOrigin-Name: b471601892df98c5103bb55132bbdecf3e4dfc428aaecc47bfec1e1d51e583c7
 2022-02-08 12:13:16 +00:00
drh
ca1776b5f3 CLI: Add the --ww option as an alias for --wordwrap. Improve the wordwrap 
algorithm so that it breaks at punctuation if it cannot find space.  Always
wordwrap with --ww even if there is a .width setting for the column.

FossilOrigin-Name: 1b528e31f8c62797e0814568b520c0680ff23a2ee877ca6aa70a167d40ebdf80
 2022-02-01 12:28:17 +00:00
larrybr
cc4d55c9cb Add "--wordwrap on/off" option for CLI columnar modes, qwbox shortcut 
FossilOrigin-Name: 10dbc278708cd2cce7fef90738082dbe31750d93e44b5fa5413a9a32dae7703a
 2022-02-01 02:50:45 +00:00
drh
e40f28618c CLI: Enhancements to columnar output modes. (See 
[forum/forumpost/5b53cd851f66441f9|forum post 5b53cd851] for discussion.)
New output mode "qbox".  New output options "--quote" and "--wrap N".

FossilOrigin-Name: 539cef5214446a7181614793e9cf323e95ba00ba0f888585b14b598dd2ff0808
 2022-01-31 14:14:29 +00:00
larrybr
d0a9a46215 Test .mode quote blob output 
FossilOrigin-Name: ef4dcd1080241a62a50eff28ef12c49da0116032f10843aaf048ae7ad3cdfd0e
 2022-01-03 19:33:44 +00:00
drh
092ba22cca Minor changes to shell1.test test results to account for the new feature 
of the shell that points to the specific part of the input line where the
error occurs.

FossilOrigin-Name: d4870c08893ea9984b1fa1c3a7d04893ad5ed4a2130e9287d169a306cc8ef0a4
 2021-12-29 13:32:36 +00:00
larrybr
f9a49b0cad Add phase and error number to CLI error messages. 
FossilOrigin-Name: 7f87a298688c37bbad8fd2e1cf0e8fbcc36f0c211dcfa3685298525648dbe21b
 2021-10-26 16:57:09 +00:00
larrybr
d797d6b626 In CLI, ensure correct line-accumulation state whenever line(s) are dumped or processed. And test this. 
FossilOrigin-Name: be211a9c59234ef202e772fcaae18be43c44e1e00674f137cad2d903e00bfcab
 2021-10-03 22:03:59 +00:00
drh
a6e6cf2c8f New CLI command: ".stats vmstep" enables the display of the virtual-machine 
step count only, after each command.  Useful for optimization problems.

FossilOrigin-Name: 49dfce469e6a17111b349e53578479daf783064200bf0eec5bf8a91d3553b19f
 2021-01-09 19:10:04 +00:00
drh
f82d78e9c2 Fix the shell1.test test script so that it works on windows. 
FossilOrigin-Name: 9bd15b07e58b1811c2a368ec76059ac683a2c35b163ef4bba01ccb8b7ca7288d
 2020-11-25 14:50:42 +00:00