sqlite/test/vt100-a.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 │
│ RED │ 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