drh
49 lines
2.2 KiB
SQL
49 lines
2.2 KiB
SQL
/*
|
|
** Run this script using the "sqlite3" command-line shell
|
|
** test test formatting of output text that contains
|
|
** vt100 escape sequences.
|
|
*/
|
|
.mode box -escape off
|
|
CREATE TEMP TABLE t1(a,b,c);
|
|
INSERT INTO t1 VALUES
|
|
('one','twotwotwo','thirty-three'),
|
|
(unistr('\u001b[91mRED\u001b[0m'),'fourfour','fifty-five'),
|
|
('six','seven','eighty-eight');
|
|
.testcase 100
|
|
SELECT * FROM t1;
|
|
.check <<END
|
|
╭─────┬───────────┬──────────────╮
|
|
│ a │ b │ c │
|
|
╞═════╪═══════════╪══════════════╡
|
|
│ one │ twotwotwo │ thirty-three │
|
|
│ [91mRED[0m │ fourfour │ fifty-five │
|
|
│ six │ seven │ eighty-eight │
|
|
╰─────┴───────────┴──────────────╯
|
|
END
|
|
|
|
.mode box -escape ascii
|
|
.testcase 200
|
|
SELECT * FROM t1;
|
|
.check <<END
|
|
╭────────────────┬───────────┬──────────────╮
|
|
│ a │ b │ c │
|
|
╞════════════════╪═══════════╪══════════════╡
|
|
│ one │ twotwotwo │ thirty-three │
|
|
│ ^[[91mRED^[[0m │ fourfour │ fifty-five │
|
|
│ six │ seven │ eighty-eight │
|
|
╰────────────────┴───────────┴──────────────╯
|
|
END
|
|
|
|
.testcase 300
|
|
.mode box -escape symbol
|
|
SELECT * FROM t1;
|
|
.check <<END
|
|
╭──────────────┬───────────┬──────────────╮
|
|
│ a │ b │ c │
|
|
╞══════════════╪═══════════╪══════════════╡
|
|
│ one │ twotwotwo │ thirty-three │
|
|
│ ␛[91mRED␛[0m │ fourfour │ fifty-five │
|
|
│ six │ seven │ eighty-eight │
|
|
╰──────────────┴───────────┴──────────────╯
|
|
END
|