database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-21 19:26:38 +03:00
Code
29,842 Commits 1,540 Branches 176 Tags
Commit Graph

107 Commits

Author SHA1 Message Date
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
drh
b7c46aa8c9 Change the -init option to the command-line shell to honor the -bail option. 
Also change it to report an error if the filename mentioned cannot be
opened.

FossilOrigin-Name: a29f54bd2c032374d7235bb1f9d4c04c094611bbc7d274b7b92722b5b802050c
 2020-11-25 13:59:47 +00:00
drh
bbb29ecfb4 Add the --nosys option to the .schema command in the CLI. 
FossilOrigin-Name: b72ee694532c0c5d2285dd580154546eb592fd6892cad9ad7a49e98737adb974
 2020-10-12 14:56:47 +00:00
drh
4dfdb86c8d New test cases for the use of the ieee754 and decimal extensions in the CLI. 
FossilOrigin-Name: bc1590f32fc4e2696b4126bd0302cb6405031dd4f55b86f3f1611f7f39299f85
 2020-08-11 18:17:04 +00:00
drh
c060508445 Always use ?...? to indicate optional arguments in the output of ".help" 
in the CLI.  Change ".mode column" so that it automatically activates
".headers on" if headers have not been previously turned on or off.

FossilOrigin-Name: 2827c0a186596299e43eb3e7378eea462d2b060b2c3388ce5cb2bc8e0b43999e
 2020-06-05 00:54:27 +00:00
drh
0908e38536 Add support for "box" mode in the CLI: Like "table" except that it uses 
unicode box-drawing characters instead of ascii-art.

FossilOrigin-Name: 6da784c9e174744d6deeb76c553b515b96c1fcb80c55a281e476959ec680fb72
 2020-06-04 18:05:39 +00:00
drh
30c54a01db Progress toward adding new output modes to the CLI: json, table, and 
markdown.

FossilOrigin-Name: 14f55fafec11491e87e6526c72cf85c689d74ba18418a1ae9646586ec206767a
 2020-05-28 23:49:50 +00:00
drh
541ef2c36c Enhance the ".filectrl" command in the CLI to support the --schema option. 
FossilOrigin-Name: 698d40db58b76f4094687d46b5c6292702a62168054f9e6a70ee86650a6635f7
 2020-04-20 16:21:30 +00:00
drh
8e9297fb79 Enhance the ".dump" command in the CLI so that it accepts multiple LIKE 
pattern arguments and shows the union of all matching tables.

FossilOrigin-Name: 45fba3d7055f90f67005ca740687f060a2311db40c8f6a161bfea0424e6ebf6d
 2020-03-25 12:50:13 +00:00
drh
ccb3781673 Enhancements to the ".import" command of the CLI. 
FossilOrigin-Name: cab1834cfc71f71bfed3c5170a0ba40a39385c3b2c50b7c6b6f09cc830dd1b1e
 2020-03-09 15:39:39 +00:00
drh
158931ab64 Test case changes so that they work with both Tcl8.6 and Tcl8.7. 
FossilOrigin-Name: 7b771405a9adc3ec191156be4ebe7122f4c698d88d69ae2134c75acb8d8feebb
 2019-04-12 16:25:42 +00:00
drh
4d342827d6 Fix the shell1.test test for the new format of the .backup command. 
FossilOrigin-Name: 9748d7995bc1dd632d66d2d326048d50e29c6f5e6993d5a6294d14421d2cb72f
 2018-12-10 00:41:28 +00:00
drh
98aa2abc45 Begin revamping the ".help" command in the command-line shell so that it 
can accept an argument and will do a search for commands that match that
argument.

FossilOrigin-Name: 209afb8d06466536863b89a8acb9a1a18477a06331d8cce95fc6380e1666b6f5
 2018-09-26 16:53:51 +00:00
drh
3c49eaf4be Avoid using a prepared statement for ".stats on" after it has been closed 
by the ".eqp full" logic.  Fix for ticket [7be932dfa60a8a6b3b26bcf76].

FossilOrigin-Name: bb87c054b1b76959e46258ac66b24027f468b390a4148ac67f208a1fbeda4060
 2018-06-07 15:23:43 +00:00
drh
69ed38a822 Add the --append option to the ".backup" command in the CLI. 
FossilOrigin-Name: 0dfdbdee527b0c429703bc2696bf8d8e44a852aafe0aca742b9d7152eb1f932e
 2018-05-14 00:23:08 +00:00
dan
07f119e470 Fix a test script problem causing shell1.test to fail with 
-DSQLITE_OMIT_VIRTUAL_TABLE builds.

FossilOrigin-Name: 2e06906e0959e1256fc2feb9dc2c3a9d1e9c19c4ba59585fe52df9af174ab443
 2018-03-24 15:08:48 +00:00
mistachkin
9d107262e4 Enhance .schema in shell to enable matching patterns with literal underscores. 
FossilOrigin-Name: 98e3f5247a6012f58642a2fcdc9be062f7afe8f2e154d06007f4935a0fd87aac
 2018-03-23 14:24:34 +00:00
drh
6c9dcc427d Update test cases for the new "usage" for .output. 
FossilOrigin-Name: fbf5e43c07e7c012cb39b33a74b3fab9e46ba946c48497fbd990110692125f57
 2018-01-10 23:27:30 +00:00
drh
1d315cf7b8 Improved name quoting and escaping in the auxiliary column info section 
of the ".schema" output for views and virtual tables.

FossilOrigin-Name: d64b14e37d9624bf5d86059ddd091170d8e6d341a8043f84548b9b3dbb96a908
 2018-01-01 21:49:43 +00:00
drh
ceba792a2f In the output of ".schema", show the column names of virtual tables and 
views in a separate comment.

FossilOrigin-Name: 2234a87fa905312b23f46d52e06cff7cacbf23b187e16c4398a42e6bdae0ee9f
 2018-01-01 21:28:25 +00:00