Debian Codegraph @

test/qrf03.test

raw
1 # 2025-11-15
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 #
12 # Test cases for the Query Result Formatter (QRF)
13 #
14 # Format narrowing due to nScreenWidth
15 #
16
17 set testdir [file dirname $argv0]
18 source $testdir/tester.tcl
19 set testprefix qrf03
20
21 do_execsql_test 1.0 {
22 CREATE TABLE mlink(
23 mid INTEGER,
24 fid INTEGER,
25 pmid INTEGER,
26 pid INTEGER,
27 fnid INTEGER REFERENCES filename,
28 pfnid INTEGER,
29 mperm INTEGER,
30 isaux BOOLEAN DEFAULT 0
31 );
32 INSERT INTO mlink VALUES(28775,28774,28773,28706,1,0,0,0);
33 INSERT INTO mlink VALUES(28773,28706,28770,28685,1,0,0,0);
34 INSERT INTO mlink VALUES(28770,28736,28769,28695,2,0,0,0);
35 INSERT INTO mlink VALUES(28770,28697,28769,28698,3,0,0,0);
36 INSERT INTO mlink VALUES(28767,28768,28759,28746,4,0,0,0);
37 CREATE TABLE event(
38 type TEXT,
39 mtime DATETIME,
40 objid INTEGER PRIMARY KEY,
41 tagid INTEGER,
42 uid INTEGER REFERENCES user,
43 bgcolor TEXT,
44 euser TEXT,
45 user TEXT,
46 ecomment TEXT,
47 comment TEXT,
48 brief TEXT,
49 omtime DATETIME
50 );
51 INSERT INTO event VALUES('ci',2460994.978048461023,126223,NULL,NULL,NULL,NULL,'drh',NULL,unistr('Data structure improvements on columnar layout. Prep work for getting\u000acolumnar layouts to respond to nScreenWidth.'),NULL,2460994.978048461023);
52 INSERT INTO event VALUES('ci',2460994.836955601816,126218,NULL,NULL,NULL,NULL,'stephan',NULL,'API doc typo fix.',NULL,2460994.836955601816);
53 INSERT INTO event VALUES('ci',2460994.88823369192,126212,NULL,NULL,NULL,NULL,'stephan',NULL,'Move sqlite3-api-cleanup.js into post-js-footer.js to remove the final direct Emscripten dependency from the intermediary build product sqlite3-api.js (the whole library, waiting to be bootstrapped). This is partly in response to [forum:4b7d45433731d2e0|forum post 4b7d45433731d2e0], which demonstrates a potential use case for a standalone sqlite3-api.js. This is a build/doc change, not a functional one.',NULL,2460994.88823369192);
54 INSERT INTO event VALUES('ci',2460994.516081551089,126211,NULL,NULL,NULL,NULL,'drh',NULL,unistr('Improve columnar layout in QRF so that it correctly deals with control\u000acharacters, and especially tabs.'),NULL,2460994.516081551089);
55 INSERT INTO event VALUES('ci',2460994.409343171865,126208,NULL,NULL,NULL,NULL,'drh',NULL,'Make use of the new sqlite3_str_free() interface in the CLI.',NULL,2460994.409343171865);
56 }
57
58 do_test 1.10 {
59 set x "\n[db format -style box -screenwidth 68 \
60 {SELECT * FROM mlink ORDER BY rowid}]"
61
62 } {
63 ╭───────┬───────┬───────┬───────┬──────┬───────┬───────┬───────╮
64 │ mid │ fid │ pmid │ pid │ fnid │ pfnid │ mperm │ isaux │
65 ╞═══════╪═══════╪═══════╪═══════╪══════╪═══════╪═══════╪═══════╡
66 │ 28775 │ 28774 │ 28773 │ 28706 │ 1 │ 0 │ 0 │ 0 │
67 │ 28773 │ 28706 │ 28770 │ 28685 │ 1 │ 0 │ 0 │ 0 │
68 │ 28770 │ 28736 │ 28769 │ 28695 │ 2 │ 0 │ 0 │ 0 │
69 │ 28770 │ 28697 │ 28769 │ 28698 │ 3 │ 0 │ 0 │ 0 │
70 │ 28767 │ 28768 │ 28759 │ 28746 │ 4 │ 0 │ 0 │ 0 │
71 ╰───────┴───────┴───────┴───────┴──────┴───────┴───────┴───────╯
72 }
73 do_test 1.11 {
74 set x "\n[db format -style box -screenwidth 52 \
75 {SELECT * FROM mlink ORDER BY rowid}]"
76
77 } {
78 ╭─────┬─────┬─────┬─────┬────┬─────┬─────┬─────╮
79 │ mid │ fid │pmid │ pid │fnid│pfnid│mperm│isaux│
80 ╞═════╪═════╪═════╪═════╪════╪═════╪═════╪═════╡
81 │28775│28774│28773│28706│ 1│ 0│ 0│ 0│
82 │28773│28706│28770│28685│ 1│ 0│ 0│ 0│
83 │28770│28736│28769│28695│ 2│ 0│ 0│ 0│
84 │28770│28697│28769│28698│ 3│ 0│ 0│ 0│
85 │28767│28768│28759│28746│ 4│ 0│ 0│ 0│
86 ╰─────┴─────┴─────┴─────┴────┴─────┴─────┴─────╯
87 }
88
89 do_test 1.20 {
90 set x "\n[db format -style table -screenwidth 68 \
91 {SELECT * FROM mlink ORDER BY rowid}]"
92
93 } {
94 +-------+-------+-------+-------+------+-------+-------+-------+
95 | mid | fid | pmid | pid | fnid | pfnid | mperm | isaux |
96 +-------+-------+-------+-------+------+-------+-------+-------+
97 | 28775 | 28774 | 28773 | 28706 | 1 | 0 | 0 | 0 |
98 | 28773 | 28706 | 28770 | 28685 | 1 | 0 | 0 | 0 |
99 | 28770 | 28736 | 28769 | 28695 | 2 | 0 | 0 | 0 |
100 | 28770 | 28697 | 28769 | 28698 | 3 | 0 | 0 | 0 |
101 | 28767 | 28768 | 28759 | 28746 | 4 | 0 | 0 | 0 |
102 +-------+-------+-------+-------+------+-------+-------+-------+
103 }
104 do_test 1.21 {
105 set x "\n[db format -style table -screenwidth 52 \
106 {SELECT * FROM mlink ORDER BY rowid}]"
107
108 } {
109 +-----+-----+-----+-----+----+-----+-----+-----+
110 | mid | fid |pmid | pid |fnid|pfnid|mperm|isaux|
111 +-----+-----+-----+-----+----+-----+-----+-----+
112 |28775|28774|28773|28706| 1| 0| 0| 0|
113 |28773|28706|28770|28685| 1| 0| 0| 0|
114 |28770|28736|28769|28695| 2| 0| 0| 0|
115 |28770|28697|28769|28698| 3| 0| 0| 0|
116 |28767|28768|28759|28746| 4| 0| 0| 0|
117 +-----+-----+-----+-----+----+-----+-----+-----+
118 }
119
120 do_test 1.30 {
121 set x "\n[db format -style markdown -screenwidth 68 \
122 {SELECT * FROM mlink ORDER BY rowid}]"
123
124 } {
125 | mid | fid | pmid | pid | fnid | pfnid | mperm | isaux |
126 |-------|-------|-------|-------|------|-------|-------|-------|
127 | 28775 | 28774 | 28773 | 28706 | 1 | 0 | 0 | 0 |
128 | 28773 | 28706 | 28770 | 28685 | 1 | 0 | 0 | 0 |
129 | 28770 | 28736 | 28769 | 28695 | 2 | 0 | 0 | 0 |
130 | 28770 | 28697 | 28769 | 28698 | 3 | 0 | 0 | 0 |
131 | 28767 | 28768 | 28759 | 28746 | 4 | 0 | 0 | 0 |
132 }
133 do_test 1.31 {
134 set x "\n[db format -style markdown -screenwidth 52 \
135 {SELECT * FROM mlink ORDER BY rowid}]"
136
137 } {
138 | mid | fid |pmid | pid |fnid|pfnid|mperm|isaux|
139 |-----|-----|-----|-----|----|-----|-----|-----|
140 |28775|28774|28773|28706| 1| 0| 0| 0|
141 |28773|28706|28770|28685| 1| 0| 0| 0|
142 |28770|28736|28769|28695| 2| 0| 0| 0|
143 |28770|28697|28769|28698| 3| 0| 0| 0|
144 |28767|28768|28759|28746| 4| 0| 0| 0|
145 }
146
147 do_test 1.40 {
148 set x "\n[db format -style column -screenwidth 68 \
149 {SELECT * FROM mlink ORDER BY rowid}]"
150
151 } {
152 mid fid pmid pid fnid pfnid mperm isaux
153 ----- ----- ----- ----- ---- ----- ----- -----
154 28775 28774 28773 28706 1 0 0 0
155 28773 28706 28770 28685 1 0 0 0
156 28770 28736 28769 28695 2 0 0 0
157 28770 28697 28769 28698 3 0 0 0
158 28767 28768 28759 28746 4 0 0 0
159 }
160 do_test 1.41 {
161 set x "\n[db format -style column -screenwidth 52 \
162 {SELECT * FROM mlink ORDER BY rowid}]"
163
164 } {
165 mid fid pmid pid fnid pfnid mperm isaux
166 ----- ----- ----- ----- ---- ----- ----- -----
167 28775 28774 28773 28706 1 0 0 0
168 28773 28706 28770 28685 1 0 0 0
169 28770 28736 28769 28695 2 0 0 0
170 28770 28697 28769 28698 3 0 0 0
171 28767 28768 28759 28746 4 0 0 0
172 }
173
174
175
176 finish_test