Documentation Source Text

Changes On Branch bubble-generator-tkpath
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Changes In Branch bubble-generator-tkpath Excluding Merge-Ins

This is equivalent to a diff from 4f106d99e8 to 5619b986d5

2016-01-02
04:16
Cherrypick changes off of the bubble-generator-tkpath branch that were intended for trunk. Also merge in changes to the 3.9.x branch. (check-in: e2ad1111f4 user: drh tags: trunk)
04:14
Further tweaks to the website. (Leaf check-in: 5619b986d5 user: drh tags: bubble-generator-tkpath)
2015-12-31
14:06
Update the change log with the latest enhancements. (check-in: 5077172640 user: drh tags: bubble-generator-tkpath)
2015-12-30
15:10
Fix a problem in an SQL example in fts3.html. (check-in: 4648330f75 user: dan tags: trunk)
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. (check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath)
2015-12-11
15:50
Improved javascript for randomizing the order of sponsor icons. Remove the document.write() calls. (check-in: 4f106d99e8 user: drh tags: trunk)
2015-12-09
14:13
Updates to the famous users list. (check-in: bf79c7d26b user: drh tags: trunk)

Changes to art/syntax/bubble-generator.tcl.
1
2
3
4
5




6
7
8
9
10
11

12

13
14
15
16
17
18
19
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

17
18
19
20
21
22
23
24





+
+
+
+






+
-
+







#!/bin/wish
#
# Run this wish script to generate syntax bubble diagrams from
# text descriptions.
#

option add *busyCursor watch

package require tkpath

source [file join [file dirname [info script]] bubble-generator-data.tcl]

# Top-level displays
#
toplevel .bb
wm protocol .bb WM_DELETE_WINDOW {destroy .}
canvas .c -bg white
tkp::canvas .c -bg white
pack .c -side top -fill both -expand 1
wm withdraw .

# Draw the button bar
#
set bn 0
frame .bb.f1
30
31
32
33
34
35
36
37
38


39
40
41


42
43
44
45
46
47
48
49
50
51
52
53
54
55


56
57
58
59



60
61

62
63
64
65



66
67
68
69
70


71
72
73
74
75
76
77
78
79
80
81
82
83
84


85

86
87
88
89



90
91
92



93
94
95

96

97

98
99
100

101
102
103
104
105


106
107
108
109

110
111
112
113
114
115
116


117
118
119


120


121
122
123
124
125
126
127
128
129
130
131
132

133


134
135
136
137
138

139
140
141
142


143
144
145
146
147
148
149
150
151
152

153
154
155
156








157
158
159


160
161


162
163
164
165
166
167
168
35
36
37
38
39
40
41


42
43
44


45
46


47
48
49
50
51
52
53
54


55
56
57
58
59
60


61
62
63
64

65
66



67
68
69
70




71
72
73
74
75
76
77
78
79
80
81
82


83
84
85
86

87
88
89


90
91
92
93


94
95
96
97
98

99
100
101

102



103
104




105
106
107
108
109

110
111
112
113
114
115


116
117
118


119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136

137
138
139
140
141
142

143
144
145


146
147




148
149
150



151




152
153
154
155
156
157
158
159
160
161

162
163
164
165
166
167
168
169
170
171
172
173
174







-
-
+
+

-
-
+
+
-
-








-
-


+
+


-
-
+
+
+

-
+

-
-
-
+
+
+

-
-
-
-
+
+










-
-


+
+
-
+


-
-
+
+
+

-
-
+
+
+


-
+

+
-
+
-
-
-
+

-
-
-
-
+
+



-
+





-
-
+
+

-
-
+
+

+
+












+
-
+
+




-
+


-
-
+
+
-
-
-
-



-
-
-
+
-
-
-
-
+
+
+
+
+
+
+
+


-
+
+


+
+







}
incr bn
set b $side.b$bn
button $b -text Everything -command {draw_all_graphs}
pack $b -side top -fill x -expand 1

set tagcnt 0                      ;# tag counter
set font1 {Helvetica 16 bold}     ;# default token font
set font2 {GillSans 14 bold}      ;# default variable font
set font1 {Helvetica 13 bold}     ;# default token font
set font2 {Helvetica 11 bold}     ;# default variable font
set RADIUS 9                      ;# default turn radius
set HSEP 17                       ;# horizontal separation
set VSEP 9                        ;# vertical separation
set HSEP 15                       ;# horizontal separation
set VSEP 7                        ;# vertical separation
set DPI 80                       ;# dots per inch


# Draw a right-hand turn around.  Approximately a ")"
#
proc draw_right_turnback {tag x y0 y1} {
  global RADIUS
  if {$y0 + 2*$RADIUS < $y1} {
    set xr0 [expr {$x-$RADIUS}]
    set xr1 [expr {$x+$RADIUS}]
    .c create arc $xr0 $y0 $xr1 [expr {$y0+2*$RADIUS}] \
          -width 2 -start 90 -extent -90 -tags $tag -style arc
    set yr0 [expr {$y0+$RADIUS}]
    set yr1 [expr {$y1-$RADIUS}]
    .c create path "M $x $y0 A $RADIUS $RADIUS 0 0 1 $xr1 $yr0" \
       -strokewidth 2 -tags $tag
    if {abs($yr1-$yr0)>$RADIUS*2} {
      set half_y [expr {($yr1+$yr0)/2}]
      .c create line $xr1 $yr0 $xr1 $half_y -width 2 -tags $tag -arrow last
      .c create line $xr1 $half_y $xr1 $yr1 -width 2 -tags $tag
      .c create pline $xr1 $yr0 $xr1 $half_y -strokewidth 2 -tags $tag \
        -endarrow on
      .c create pline $xr1 $half_y $xr1 $yr1 -strokewidth 2 -tags $tag
    } else {
      .c create line $xr1 $yr0 $xr1 $yr1 -width 2 -tags $tag
      .c create pline $xr1 $yr0 $xr1 $yr1 -strokewidth 2 -tags $tag
    }
    .c create arc $xr0 [expr {$y1-2*$RADIUS}] $xr1 $y1 \
          -width 2 -start 0 -extent -90 -tags $tag -style arc
  } else { 
    .c create path "M $xr1 $yr1 A $RADIUS $RADIUS 0 0 1 $x $y1" \
      -strokewidth 2 -tags $tag
  } else {
    set r [expr {($y1-$y0)/2.0}]
    set x0 [expr {$x-$r}]
    set x1 [expr {$x+$r}]
    .c create arc $x0 $y0 $x1 $y1 \
          -width 2 -start 90 -extent -180 -tags $tag -style arc
    .c create path "M $x $y0 A $r $r 0 0 0 $x $y1" \
      -strokewidth 2 -tags $tag
  }
}

# Draw a left-hand turn around.  Approximately a "("
#
proc draw_left_turnback {tag x y0 y1 dir} {
  global RADIUS
  if {$y0 + 2*$RADIUS < $y1} {
    set xr0 [expr {$x-$RADIUS}]
    set xr1 [expr {$x+$RADIUS}]
    .c create arc $xr0 $y0 $xr1 [expr {$y0+2*$RADIUS}] \
          -width 2 -start 90 -extent 90 -tags $tag -style arc
    set yr0 [expr {$y0+$RADIUS}]
    set yr1 [expr {$y1-$RADIUS}]
    .c create path "M $x $y0 A $RADIUS $RADIUS 0 0 0 $xr0 $yr0" \
      -strokewidth 2 -tags $tag
    if {abs($yr1-$yr0)>$RADIUS*3} {
    if {abs($yr1-$yr0)>$RADIUS*2} {
      set half_y [expr {($yr1+$yr0)/2}]
      if {$dir=="down"} {
        .c create line $xr0 $yr0 $xr0 $half_y -width 2 -tags $tag -arrow last
        .c create line $xr0 $half_y $xr0 $yr1 -width 2 -tags $tag
        .c create pline $xr0 $yr0 $xr0 $half_y -strokewidth 2 -tags $tag \
          -endarrow on
        .c create pline $xr0 $half_y $xr0 $yr1 -strokewidth 2 -tags $tag
      } else {
        .c create line $xr0 $yr1 $xr0 $half_y -width 2 -tags $tag -arrow last
        .c create line $xr0 $half_y $xr0 $yr0 -width 2 -tags $tag
        .c create pline $xr0 $yr1 $xr0 $half_y -strokewidth 2 -tags $tag \
          -endarrow on
        .c create pline $xr0 $half_y $xr0 $yr0 -strokewidth 2 -tags $tag
      }
    } else {
      .c create line $xr0 $yr0 $xr0 $yr1 -width 2 -tags $tag
      .c create pline $xr0 $yr0 $xr0 $yr1 -strokewidth 2 -tags $tag
    }
    .c create path "M $xr0 $yr1 A $RADIUS $RADIUS 0 0 0 $x $y1" \
    # .c create line $xr0 $yr0 $xr0 $yr1 -width 2 -tags $tag
      -strokewidth 2 -tags $tag
    .c create arc $xr0 [expr {$y1-2*$RADIUS}] $xr1 $y1 \
          -width 2 -start 180 -extent 90 -tags $tag -style arc
  } else { 
  } else {
    set r [expr {($y1-$y0)/2.0}]
    set x0 [expr {$x-$r}]
    set x1 [expr {$x+$r}]
    .c create arc $x0 $y0 $x1 $y1 \
          -width 2 -start 90 -extent 180 -tags $tag -style arc
    .c create path "M $x $y0 A $r $r 0 0 1 $x $y1" \
      -strokewidth 2 -tags $tag
  }
}

# Draw a bubble containing $txt. 
# Draw a bubble containing $txt.
#
proc draw_bubble {txt} {
  global tagcnt
  incr tagcnt
  set tag x$tagcnt
  if {$txt=="nil"} {
    .c create line 0 0 1 0 -width 2 -tags $tag
  if {$txt eq "nil"} {
    .c create pline 0 0 1 0 -strokewidth 2 -tags $tag
    return [list $tag 1 0]
  } elseif {$txt=="bullet"} {
    .c create oval 0 -3 6 3 -width 2 -tags $tag
  } elseif {$txt eq "bullet"} {
    .c create circle 2 0 -r 3 -strokewidth 2 -tags $tag
    return [list $tag 6 0]
  } elseif {$txt eq "--"} {
    set txt "- -"
  }
  if {[regexp {^/[a-z]} $txt]} {
    set txt [string range $txt 1 end]
    set font $::font2
    set istoken 1
  } elseif {[regexp {^[a-z]} $txt]} {
    set font $::font2
    set istoken 0
  } else {
    set font $::font1
    set istoken 1
  }
  foreach {ffam fsize fweight} $font break
  set id1 [.c create text 0 0 -anchor c -text $txt -font $font -tags $tag]
  set id1 [.c create ptext 0 0 -text $txt -fontfamily $ffam \
    -fontsize $fsize -fontweight $fweight -textanchor c -tags $tag]
  foreach {x0 y0 x1 y1} [.c bbox $id1] break
  set h [expr {$y1-$y0+2}]
  set rad [expr {($h+1)/2}]
  set top [expr {$y0-2}]
  set btm [expr {$y1}]
  set btm [expr {$y1+2}]
  set fudge [expr {int(3*$istoken + [string length $txt]*1.4)}]
#puts "fudge($txt)=$fudge"
  set left [expr {$x0+$fudge}]
  set right [expr {$x1-$fudge}]
  set left [expr {$x0-$fudge}]
  set right [expr {$x1+$fudge}]
  if {$left>$right} {
    set left [expr {($x0+$x1)/2}]
    set right $left
  }
  set tag2 x$tagcnt-box
  set tags [list $tag $tag2]
  if {$istoken} {
    .c create arc [expr {$left-$rad}] $top [expr {$left+$rad}] $btm \
         -width 2 -start 90 -extent 180 -style arc -tags $tags
    .c create arc [expr {$right-$rad}] $top [expr {$right+$rad}] $btm \
    set w [expr {$right-$left}]
         -width 2 -start -90 -extent 180 -style arc -tags $tags
    if {$left<$right} {
      .c create line $left $top $right $top -width 2 -tags $tags
      .c create line $left $btm $right $btm -width 2 -tags $tags
    if {$w>1.3*$h} {
      .c create prect $left $top $right $btm -rx $rad -strokewidth 2 \
        -tags $tags -fill gray80 -fillopacity 0.1
    } else {
      set xx [expr {($x0+$x1)/2}]
      set yy [expr {($y0+$y1)/2}]
      .c create circle $xx $yy -r [expr {2+$h/2}] -strokewidth 2 \
        -tags $tags -fill gray80 -fillopacity 0.1
    }
  } else {
    .c create rect $left $top $right $btm -width 2 -tags $tags
    .c create prect $left $top $right $btm -strokewidth 2 \
      -tags $tags -fill gray80 -fillopacity 0.1
  }
  foreach {x0 y0 x1 y1} [.c bbox $tag2] break
  set x0 [expr {$x0+3}]
  set x1 [expr {$x1-3}]
  set width [expr {$x1-$x0}]
  .c move $tag [expr {-$x0}] 0

  # Entry is always 0 0
  # Return:  TAG EXIT_X EXIT_Y
  #
  return [list $tag $width 0]
181
182
183
184
185
186
187
188
189


190
191
192
193
194
195
196
197
198

199
200
201


202
203
204
205
206
207
208
187
188
189
190
191
192
193


194
195
196
197
198
199
200
201
202
203

204
205


206
207
208
209
210
211
212
213
214







-
-
+
+








-
+

-
-
+
+







  set exy 0
  foreach term $lx {
    set m [draw_diagram $term]
    foreach {t texx texy} $m break
    if {$exx>0} {
      set xn [expr {$exx+$sep}]
      .c move $t $xn $exy
      .c create line [expr {$exx-1}] $exy $xn $exy \
         -tags $tag -width 2 -arrow last
      .c create pline [expr {$exx-1}] $exy $xn $exy \
        -tags $tag -strokewidth 2 -endarrow on
      set exx [expr {$xn+$texx}]
    } else {
      set exx $texx
    }
    set exy $texy
    .c addtag $tag withtag $t
    .c dtag $t $t
  }
  if {$exx==0} {	
  if {$exx==0} {
    set exx [expr {$sep*2}]
    .c create line 0 0 $sep 0 -width 2 -tags $tag -arrow last
    .c create line $sep 0 $exx 0 -width 2 -tags $tag
    .c create pline 0 0 $sep 0 -strokewidth 2 -tags $tag -endarrow on
    .c create pline $sep 0 $exx 0 -strokewidth 2 -tags $tag
    set exx $sep
  }
  return [list $tag $exx $exy]
}

# Draw a sequence of terms from right to left.
#
223
224
225
226
227
228
229
230


231
232
233
234
235
236
237
238
239
240

241
242
243
244
245
246
247
229
230
231
232
233
234
235

236
237
238
239
240
241
242
243
244
245
246

247
248
249
250
251
252
253
254







-
+
+









-
+







    set m [draw_diagram $term]
    foreach {t texx texy} $m break
    foreach {tx0 ty0 tx1 ty1} [.c bbox $t] break
    set w [expr {$tx1-$tx0}]
    if {$exx>0} {
      set xn [expr {$exx+$sep}]
      .c move $t $xn 0
      .c create line $exx $exy $xn $exy -tags $tag -width 2 -arrow first
      .c create pline $exx $exy $xn $exy -tags $tag -strokewidth 2 \
        -startarrow on
      set exx [expr {$xn+$texx}]
    } else {
      set exx $texx
    }
    set exy $texy
    .c addtag $tag withtag $t
    .c dtag $t $t
  }
  if {$exx==0} {
    .c create line 0 0 $sep 0 -width 2 -tags $tag
    .c create pline 0 0 $sep 0 -strokewidth 2 -tags $tag
    set exx $sep
  }
  return [list $tag $exx $exy]
}

# Draw a sequence of terms from top to bottom.
#
283
284
285
286
287
288
289
290
291
292
293




294
295
296
297
298


299
300
301
302
303
304
305



306
307
308
309
310


311
312
313
314
315
316
317
318
319

320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
















337
338
339
340
341
342
343
344







345
346
347
348
349
350
351
290
291
292
293
294
295
296




297
298
299
300
301
302
303


304
305
306
307
308
309



310
311
312

313
314


315
316
317
318
319
320
321
322
323
324
325
326
327
















328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344







345
346
347
348
349
350
351
352
353
354
355
356
357
358







-
-
-
-
+
+
+
+



-
-
+
+




-
-
-
+
+
+
-


-
-
+
+









+

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+

-
-
-
-
-
-
-
+
+
+
+
+
+
+







        if {$ex2>$enter_x} {set enter_x $ex2}
      } else {
        set enter_x [expr {$sep*2 + $indent}]
      }
      set back_y [expr {$btm + $sep + 1}]
      if {$bypass_y>0} {
         set mid_y [expr {($bypass_y+$RADIUS+$back_y)/2}]
         .c create line $bypass_x $bypass_y $bypass_x $mid_y \
            -width 2 -tags $tag -arrow last
         .c create line $bypass_x $mid_y $bypass_x [expr {$back_y+$RADIUS}] \
             -tags $tag -width 2
         .c create pline $bypass_x $bypass_y $bypass_x $mid_y \
           -strokewidth 2 -tags $tag -endarrow on
         .c create pline $bypass_x $mid_y $bypass_x [expr {$back_y+$RADIUS}] \
           -tags $tag -strokewidth 2
      }
      .c move $t $enter_x $enter_y
      set e2 [expr {$exit_x + $sep}]
      .c create line $exit_x $exit_y $e2 $exit_y \
            -width 2 -tags $tag
      .c create pline $exit_x $exit_y $e2 $exit_y \
        -strokewidth 2 -tags $tag
      draw_right_turnback $tag $e2 $exit_y $back_y
      set e3 [expr {$enter_x-$sep}]
      set bypass_x [expr {$e3-$RADIUS}]
      set emid [expr {($e2+$e3)/2}]
      .c create line $e2 $back_y $emid $back_y \
                 -width 2 -tags $tag -arrow last
      .c create line $emid $back_y $e3 $back_y \
      .c create pline $e2 $back_y $emid $back_y -strokewidth 2 -tags $tag \
        -endarrow on
      .c create pline $emid $back_y $e3 $back_y -strokewidth 2 -tags $tag
                 -width 2 -tags $tag
      set r2 [expr {($enter_y - $back_y)/2.0}]
      draw_left_turnback $tag $e3 $back_y $enter_y down
      .c create line $e3 $enter_y $enter_x $enter_y \
                 -arrow last -width 2 -tags $tag
      .c create pline $e3 $enter_y $enter_x $enter_y -endarrow on \
        -strokewidth 2 -tags $tag
      set exit_x [expr {$enter_x + $exx}]
      set exit_y [expr {$enter_y + $exy}]
    }
    .c addtag $tag withtag $t
    .c dtag $t $t
    set btm [lindex [.c bbox $tag] 3]
    incr i
  }
  if {$bypass} {
    set r $RADIUS
    set fwd_y [expr {$btm + $sep + 1}]
    set mid_y [expr {($next_bypass_y+$RADIUS+$fwd_y)/2}]
    set descender_x [expr {$exit_x+$RADIUS}]
    .c create line $bypass_x $next_bypass_y $bypass_x $mid_y \
        -width 2 -tags $tag -arrow last
    .c create line $bypass_x $mid_y $bypass_x [expr {$fwd_y-$RADIUS}] \
        -tags $tag -width 2
    .c create arc $bypass_x [expr {$fwd_y-2*$RADIUS}] \
                  [expr {$bypass_x+2*$RADIUS}] $fwd_y \
        -width 2 -start 180 -extent 90 -tags $tag -style arc
    .c create arc [expr {$exit_x-$RADIUS}] $exit_y \
                  $descender_x [expr {$exit_y+2*$RADIUS}] \
        -width 2 -start 90 -extent -90 -tags $tag -style arc
    .c create arc $descender_x [expr {$fwd_y-2*$RADIUS}] \
                  [expr {$descender_x+2*$RADIUS}] $fwd_y \
        -width 2 -start 180 -extent 90 -tags $tag -style arc
    set exit_x [expr {$exit_x+2*$RADIUS}]
    set mid_y [expr {($next_bypass_y+$r+$fwd_y)/2}]
    set descender_x [expr {$exit_x+$r}]
    .c create pline $bypass_x $next_bypass_y $bypass_x $mid_y \
      -strokewidth 2 -tags $tag -endarrow on
    .c create pline $bypass_x $mid_y $bypass_x [expr {$fwd_y-$r}] \
      -tags $tag -strokewidth 2
    set path "M $bypass_x [expr {$fwd_y-$r}]"
    append path " A $r $r 0 0 0 [expr {$bypass_x+$r}] $fwd_y"
    .c create path $path -strokewidth 2 -tags $tag
    set path "M $exit_x $exit_y"
    append path " A $r $r 0 0 1 $descender_x [expr {$exit_y+$r}]"
    .c create path $path -strokewidth 2 -tags $tag
    set path "M $descender_x [expr {$fwd_y-$r}]"
    append path " A $r $r 0 0 0 [expr {$descender_x+$r}] $fwd_y"
    .c create path $path -strokewidth 2 -tags $tag
    set exit_x [expr {$exit_x+2*$r}]
    set half_x [expr {($exit_x+$indent)/2}]
    .c create line [expr {$bypass_x+$RADIUS}] $fwd_y $half_x $fwd_y \
        -width 2 -tags $tag -arrow last
    .c create line $half_x $fwd_y $exit_x $fwd_y \
        -width 2 -tags $tag
    .c create line $descender_x [expr {$exit_y+$RADIUS}] \
                   $descender_x [expr {$fwd_y-$RADIUS}] \
        -width 2 -tags $tag -arrow last
    .c create pline [expr {$bypass_x+$r}] $fwd_y $half_x $fwd_y \
      -strokewidth 2 -tags $tag -endarrow on
    .c create pline $half_x $fwd_y $exit_x $fwd_y \
      -strokewidth 2 -tags $tag
    .c create pline $descender_x [expr {$exit_y+$r}] \
                   $descender_x [expr {$fwd_y-$r}] \
      -strokewidth 2 -tags $tag -endarrow on
    set exit_y $fwd_y
  }
  set width [lindex [.c bbox $tag] 2]
  return [list $tag $exit_x $exit_y]
}

proc draw_loop {forward back} {
374
375
376
377
378
379
380
381
382



383
384
385
386
387
388
389



390
391
392
393
394
395
396
397


398
399
400
401
402
403
404
405
406

407
408
409
410
411

412
413
414
415
416
417
418
381
382
383
384
385
386
387


388
389
390
391
392
393
394
395


396
397
398
399
400
401
402
403
404


405
406
407
408
409
410
411
412
413
414

415
416
417
418
419

420
421
422
423
424
425
426
427







-
-
+
+
+





-
-
+
+
+






-
-
+
+








-
+




-
+







  set by1 [expr {$dy+$by1}]

  if {$fw>$bw} {
    if {$fexx<$fw && $fexx>=$bw} {
      set dx [expr {($fexx-$bw)/2}]
      .c move $bt $dx 0
      set bexx [expr {$dx+$bexx}]
      .c create line 0 $biny $dx $biny -width 2 -tags $bt
      .c create line $bexx $bexy $fexx $bexy -width 2 -tags $bt -arrow first
      .c create pline 0 $biny $dx $biny -strokewidth 2 -tags $bt
      .c create pline $bexx $bexy $fexx $bexy -strokewidth 2 -tags $bt \
        -startarrow on
      set mxx $fexx
    } else {
      set dx [expr {($fw-$bw)/2}]
      .c move $bt $dx 0
      set bexx [expr {$dx+$bexx}]
      .c create line 0 $biny $dx $biny -width 2 -tags $bt
      .c create line $bexx $bexy $fx1 $bexy -width 2 -tags $bt -arrow first
      .c create pline 0 $biny $dx $biny -strokewidth 2 -tags $bt
      .c create pline $bexx $bexy $fx1 $bexy -strokewidth 2 -tags $bt \
        -startarrow on
      set mxx $fexx
    }
  } elseif {$bw>$fw} {
    set dx [expr {($bw-$fw)/2}]
    .c move $ft $dx 0
    set fexx [expr {$dx+$fexx}]
    .c create line 0 0 $dx $fexy -width 2 -tags $ft -arrow last
    .c create line $fexx $fexy $bx1 $fexy -width 2 -tags $ft
    .c create pline 0 0 $dx $fexy -strokewidth 2 -tags $ft -endarrow on
    .c create pline $fexx $fexy $bx1 $fexy -strokewidth 2 -tags $ft
    set mxx $bexx
  }
  .c addtag $tag withtag $bt
  .c addtag $tag withtag $ft
  .c dtag $bt $bt
  .c dtag $ft $ft
  .c move $tag $sep 0
  set mxx [expr {$mxx+$sep}]
  .c create line 0 0 $sep 0 -width 2 -tags $tag
  .c create pline 0 0 $sep 0 -strokewidth 2 -tags $tag
  draw_left_turnback $tag $sep 0 $biny up
  draw_right_turnback $tag $mxx $fexy $bexy
  foreach {x0 y0 x1 y1} [.c bbox $tag] break
  set exit_x [expr {$mxx+$::RADIUS}]
  .c create line $mxx $fexy $exit_x $fexy -width 2 -tags $tag
  .c create pline $mxx $fexy $exit_x $fexy -strokewidth 2 -tags $tag
  return [list $tag $exit_x $fexy]
}

proc draw_toploop {forward back} {
  global tagcnt
  incr tagcnt
  set tag x$tagcnt
432
433
434
435
436
437
438
439
440



441
442
443
444
445
446
447


448
449
450
451
452
453
454
455
456

457
458
459
460

461
462
463
464
465
466
467
441
442
443
444
445
446
447


448
449
450
451
452
453
454
455


456
457
458
459
460
461
462
463
464
465

466
467
468
469

470
471
472
473
474
475
476
477







-
-
+
+
+





-
-
+
+








-
+



-
+







  set by0 [expr {$dy+$by0}]
  set by1 [expr {$dy+$by1}]

  if {$fw>$bw} {
    set dx [expr {($fw-$bw)/2}]
    .c move $bt $dx 0
    set bexx [expr {$dx+$bexx}]
    .c create line 0 $biny $dx $biny -width 2 -tags $bt
    .c create line $bexx $bexy $fx1 $bexy -width 2 -tags $bt -arrow first
    .c create pline 0 $biny $dx $biny -strokewidth 2 -tags $bt
    .c create pline $bexx $bexy $fx1 $bexy -strokewidth 2 -tags $bt \
      -startarrow on
    set mxx $fexx
  } elseif {$bw>$fw} {
    set dx [expr {($bw-$fw)/2}]
    .c move $ft $dx 0
    set fexx [expr {$dx+$fexx}]
    .c create line 0 0 $dx $fexy -width 2 -tags $ft
    .c create line $fexx $fexy $bx1 $fexy -width 2 -tags $ft
    .c create pline 0 0 $dx $fexy -strokewidth 2 -tags $ft
    .c create pline $fexx $fexy $bx1 $fexy -strokewidth 2 -tags $ft
    set mxx $bexx
  }
  .c addtag $tag withtag $bt
  .c addtag $tag withtag $ft
  .c dtag $bt $bt
  .c dtag $ft $ft
  .c move $tag $sep 0
  set mxx [expr {$mxx+$sep}]
  .c create line 0 0 $sep 0 -width 2 -tags $tag
  .c create pline 0 0 $sep 0 -strokewidth 2 -tags $tag
  draw_left_turnback $tag $sep 0 $biny down
  draw_right_turnback $tag $mxx $fexy $bexy
  foreach {x0 y0 x1 y1} [.c bbox $tag] break
  .c create line $mxx $fexy $x1 $fexy -width 2 -tags $tag
  .c create pline $mxx $fexy $x1 $fexy -strokewidth 2 -tags $tag
  return [list $tag $x1 $fexy]
}

proc draw_or {lx} {
  global tagcnt
  incr tagcnt
  set tag x$tagcnt
477
478
479
480
481
482
483
484

485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504




505
506
507


508
509
510
511
512
513
514
515
516
517



518
519
520
521



522
523
524



525
526
527
528
529
530






531
532
533
534
535
536
537

538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554

555
556
557
558
559
560
561
562
563
564
565
566



567
568
569
570
571
572
573

574
575
576
577



578
579


580
581
582
583
584
585
586
487
488
489
490
491
492
493

494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511



512
513
514
515
516


517
518
519
520
521
522
523
524
525



526
527
528
529
530


531
532
533
534


535
536
537
538





539
540
541
542
543
544
545
546
547
548
549
550

551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567

568
569
570
571
572
573
574
575
576
577



578
579
580
581
582
583
584
585
586

587
588
589


590
591
592
593

594
595
596
597
598
599
600
601
602







-
+

















-
-
-
+
+
+
+

-
-
+
+







-
-
-
+
+
+


-
-
+
+
+

-
-
+
+
+

-
-
-
-
-
+
+
+
+
+
+






-
+
















-
+









-
-
-
+
+
+






-
+


-
-
+
+
+

-
+
+







    set w [expr {$x1-$x0}]
    if {$i>0} {set w [expr {$w+20}]}  ;# extra space for arrowheads
    if {$w>$mxw} {set mxw $w}
    incr i
  }

  set x0 0                        ;# entry x
  set x1 $sep                     ;# decender 
  set x1 $sep                     ;# decender
  set x2 [expr {$sep*2}]          ;# start of choice
  set xc [expr {$mxw/2}]          ;# center point
  set x3 [expr {$mxw+$x2}]        ;# end of choice
  set x4 [expr {$x3+$sep}]        ;# accender
  set x5 [expr {$x4+$sep}]        ;# exit x

  for {set i 0} {$i<$n} {incr i} {
    foreach {t texx texy} $m($i) break
    foreach {tx0 ty0 tx1 ty1} [.c bbox $t] break
    set w [expr {$tx1-$tx0}]
    set dx [expr {($mxw-$w)/2 + $x2}]
    if {$w>10 && $dx>$x2+10} {set dx [expr {$x2+10}]}
    .c move $t $dx 0
    set texx [expr {$texx+$dx}]
    set m($i) [list $t $texx $texy]
    foreach {tx0 ty0 tx1 ty1} [.c bbox $t] break
    if {$i==0} {
      if {$dx>$x2} {set ax last} {set ax none}
      .c create line 0 0 $dx 0 -width 2 -tags $tag -arrow $ax
      .c create line $texx $texy [expr {$x5+1}] $texy -width 2 -tags $tag
      if {$dx>$x2} {set ax {-endarrow on}} {set ax {}}
      .c create pline 0 0 $dx 0 -strokewidth 2 -tags $tag {*}$ax
      .c create pline $texx $texy [expr {$x5+1}] $texy -strokewidth 2 \
        -tags $tag
      set exy $texy
      .c create arc -$sep 0 $sep [expr {$sep*2}] \
         -width 2 -start 90 -extent -90 -tags $tag -style arc
      .c create path "M 0 0 A $sep $sep 0 0 1 $sep $sep" \
        -strokewidth 2 -tags $tag
      set btm $ty1
    } else {
      set dy [expr {$btm - $ty0 + $vsep}]
      if {$dy<2*$sep} {set dy [expr {2*$sep}]}
      .c move $t 0 $dy
      set texy [expr {$texy+$dy}]
      if {$dx>$x2} {
        .c create line $x2 $dy $dx $dy -width 2 -tags $tag -arrow last
        if {$dx<$xc-2} {set ax last} {set ax none}
        .c create line $texx $texy $x3 $texy -width 2 -tags $tag -arrow $ax
        .c create pline $x2 $dy $dx $dy -strokewidth 2 -tags $tag -endarrow on
        if {$dx<$xc-2} {set ax {-endarrow on}} {set ax {}}
        .c create pline $texx $texy $x3 $texy -strokewidth 2 -tags $tag {*}$ax
      }
      set y1 [expr {$dy-2*$sep}]
      .c create arc $x1 $y1 [expr {$x1+2*$sep}] $dy \
          -width 2 -start 180 -extent 90 -style arc -tags $tag
      .c create path \
        "M $x1 [expr {$y1+$sep}] A $sep $sep 0 0 0 [expr {$x1+$sep}] $dy" \
        -strokewidth 2 -tags $tag
      set y2 [expr {$texy-2*$sep}]
      .c create arc [expr {$x3-$sep}] $y2 $x4 $texy \
          -width 2 -start 270 -extent 90 -style arc -tags $tag
      .c create path \
        "M $x3 [expr {$y2+2*$sep}] A $sep $sep 0 0 0 $x4 [expr {$y2+$sep}]" \
        -strokewidth 2 -tags $tag
      if {$i==$n-1} {
        .c create arc $x4 $exy [expr {$x4+2*$sep}] [expr {$exy+2*$sep}] \
           -width 2 -start 180 -extent -90 -tags $tag -style arc
        .c create line $x1 [expr {$dy-$sep}] $x1 $sep -width 2 -tags $tag
        .c create line $x4 [expr {$texy-$sep}] $x4 [expr {$exy+$sep}] \
               -width 2 -tags $tag
        .c create path \
          "M $x4 [expr {$exy+$sep}] A $sep $sep 0 0 1 [expr {$x4+$sep}] $exy" \
          -strokewidth 2 -tags $tag
        .c create pline $x1 [expr {$dy-$sep}] $x1 $sep -strokewidth 2 -tags $tag
        .c create pline $x4 [expr {$texy-$sep}] $x4 [expr {$exy+$sep}] \
          -strokewidth 2 -tags $tag
      }
      set btm [expr {$ty1+$dy}]
    }
    .c addtag $tag withtag $t
    .c dtag $t $t
  }
  return [list $tag $x5 $exy]   
  return [list $tag $x5 $exy]
}

proc draw_tail_branch {lx} {
  global tagcnt
  incr tagcnt
  set tag x$tagcnt
  set sep $::VSEP
  set vsep [expr {$sep/2}]
  set n [llength $lx]
  set i 0
  foreach term $lx {
    set m($i) [set mx [draw_diagram $term]]
    incr i
  }

  set x0 0                        ;# entry x
  set x1 $sep                     ;# decender 
  set x1 $sep                     ;# decender
  set x2 [expr {$sep*2}]          ;# start of choice

  for {set i 0} {$i<$n} {incr i} {
    foreach {t texx texy} $m($i) break
    foreach {tx0 ty0 tx1 ty1} [.c bbox $t] break
    set dx [expr {$x2+10}]
    .c move $t $dx 0
    foreach {tx0 ty0 tx1 ty1} [.c bbox $t] break
    if {$i==0} {
      .c create line 0 0 $dx 0 -width 2 -tags $tag -arrow last
      .c create arc -$sep 0 $sep [expr {$sep*2}] \
         -width 2 -start 90 -extent -90 -tags $tag -style arc
      .c create pline 0 0 $dx 0 -strokewidth 2 -tags $tag -endarrow on
      .c create path "M 0 0 A $sep $sep 0 0 1 $sep $sep" \
        -strokewidth 2 -tags $tag
      set btm $ty1
    } else {
      set dy [expr {$btm - $ty0 + $vsep}]
      if {$dy<2*$sep} {set dy [expr {2*$sep}]}
      .c move $t 0 $dy
      if {$dx>$x2} {
        .c create line $x2 $dy $dx $dy -width 2 -tags $tag -arrow last
        .c create pline $x2 $dy $dx $dy -strokewidth 2 -tags $tag -endarrow on
      }
      set y1 [expr {$dy-2*$sep}]
      .c create arc $x1 $y1 [expr {$x1+2*$sep}] $dy \
          -width 2 -start 180 -extent 90 -style arc -tags $tag
      set path "M $x1 [expr {$y1+$sep}]"
      append path " A $sep $sep 0 0 0 [expr {$x1+$sep}] $dy"
      .c create path $path -strokewidth 2 -tags $tag
      if {$i==$n-1} {
        .c create line $x1 [expr {$dy-$sep}] $x1 $sep -width 2 -tags $tag
        .c create pline $x1 [expr {$dy-$sep}] $x1 $sep -strokewidth 2 \
          -tags $tag
      }
      set btm [expr {$ty1+$dy}]
    }
    .c addtag $tag withtag $t
    .c dtag $t $t
  }
  return [list $tag 0 0]
640
641
642
643
644
645
646
















































647

648
649
650
651
652
653
654
655
656


657
658


659
660
661
662

663
664
665
666












667

668
669
670
671
672

673
674
675
676
677
678

679
680
681
682
683
684
685
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710

711
712
713
714
715
716
717
718


719
720
721
722
723
724
725



726




727
728
729
730
731
732
733
734
735
736
737
738

739
740
741
742
743
744
745
746
747
748
749
750

751
752
753
754
755
756
757
758







+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+







-
-
+
+


+
+

-
-
-
+
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
-
+





+





-
+







  if {$cmd=="tailbranch"} {
    # return [draw_tail_branch [lrange $spec 1 end]]
    return [draw_or [lrange $spec 1 end]]
  }
  error "unknown operator: $cmd"
}

proc copy_to_surface {surf} {
  foreach id [.c find withtag all] {
    switch -- [.c type $id] {
      pline {
	# tricky: arrow heads adjust coords, but we want the original ones!
        set sa [.c itemcget $id -startarrow]
        set ea [.c itemcget $id -endarrow]
        .c itemconfig $id -startarrow off -endarrow off
	$surf create pline [.c coords $id] \
	  -strokewidth [.c itemcget $id -strokewidth] \
          -stroke [.c itemcget $id -stroke] \
	  -startarrow $sa -endarrow $ea
        .c itemconfig $id -startarrow $sa -endarrow $ea
      }
      path {
	$surf create path [.c coords $id] \
	  -strokewidth [.c itemcget $id -strokewidth] \
	  -stroke [.c itemcget $id -stroke]
      }
      circle {
	$surf create circle [.c coords $id] \
	  -r [.c itemcget $id -r] \
	  -strokewidth [.c itemcget $id -strokewidth] \
	  -stroke [.c itemcget $id -stroke]
      }
      prect {
	$surf create prect [.c coords $id] \
	  -rx [.c itemcget $id -rx] \
	  -ry [.c itemcget $id -ry] \
	  -strokewidth [.c itemcget $id -strokewidth] \
	  -stroke [.c itemcget $id -stroke] \
	  -fillopacity [.c itemcget $id -fillopacity] \
	  -fill [.c itemcget $id -fill]
      }
      ptext {
	$surf create ptext [.c coords $id] \
	  -strokewidth [.c itemcget $id -strokewidth] \
	  -stroke [.c itemcget $id -stroke] \
	  -fontfamily [.c itemcget $id -fontfamily] \
	  -fontsize [.c itemcget $id -fontsize] \
	  -text [.c itemcget $id -text] \
	  -textanchor [.c itemcget $id -textanchor] \
	  -fontweight [.c itemcget $id -fontweight]
      }
    }
  }
}

proc draw_graph {name spec {do_xv 1}} {
proc draw_graph {name spec {do_surf 0}} {
  .c delete all
  wm deiconify .
  wm title . $name
  draw_diagram "line bullet [list $spec] bullet"
  foreach {x0 y0 x1 y1} [.c bbox all] break
  .c move all [expr {2-$x0}] [expr {2-$y0}]
  foreach {x0 y0 x1 y1} [.c bbox all] break
  .c create rect -100 -100 [expr {$x1+100}] [expr {$y1+100}] \
     -fill white -outline white -tags bgrect
  .c create prect -100 -100 [expr {$x1+100}] [expr {$y1+100}] \
     -fill white -stroke white -tags bgrect
  .c lower bgrect
  .c config -width $x1 -height $y1
  .c delete bgrect
  catch {tk busy hold .}
  update
  .c postscript -file $name.ps -width [expr {$x1+2}] -height [expr {$y1+2}]
  global DPI
  .c delete bgrect
  catch {tk busy forget .}
  exec convert -density ${DPI}x$DPI -antialias $name.ps $name.gif
  if {$do_xv} {
    if {[catch {exec xv $name.gif &}]} {
      exec display $name.gif &
  if {$do_surf} {
    set ws [expr {$x1+2}]
    set hs [expr {$y1+2}]
    set surf [tkp::surface new $ws $hs]
    $surf erase 0 0 $ws $hs
    $surf create prect 0 0 $ws $hs -fill white
    copy_to_surface $surf
    set img [image create photo]
    $surf copy $img
    $surf destroy
    # $img write $name.png -format png
    $img write $name.gif -format gif
    }
    image delete $img
  }
}

proc draw_all_graphs {} {
  global all_graphs
  catch {tk busy hold .bb}
  set f [open all.html w]
  foreach {name graph} $all_graphs {
    if {[regexp {^X-} $name]} continue
    puts $f "<h3>$name:</h3>"
    puts $f "<img src=\"$name.gif\">"
    draw_graph $name $graph 0
    draw_graph $name $graph 1
    set img($name) 1
    set children($name) {}
    set parents($name) {}
  }
  close $f
  set order {}
  foreach {name graph} $all_graphs {
697
698
699
700
701
702
703

704
705
706
707
708
709
710
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784







+







  foreach name [lsort [array names img]] {
    set cx [lsort $children($name)]
    set px [lsort $parents($name)]
    puts $f [list set syntax_linkage($name) [list $cx $px]]
  }
  puts $f [list set syntax_order $order]
  close $f
  catch {tk busy forget .bb}
  wm withdraw .
}

proc walk_graph_extract_names {graph varname} {
  upvar 1 $varname v
  foreach x $graph {
    set n [llength $x]
Changes to pages/changes.in.
28
29
30
31
32
33
34










35
36
37





38
39
40
41



42
43
44
45
46
47
48
49
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53



54
55
56

57
58
59
60
61
62
63







+
+
+
+
+
+
+
+
+
+



+
+
+
+
+

-
-
-
+
+
+
-







<li>Enhance the [PRAGMA cache_spill] statement to accept a 32-bit integer
    parameter which is the threshold below which cache spilling is prohibited.
<li>On unix, if a symlink to a database file is opened, then the corresponding
    journal files are based on the actual filename, not the symlink name.
<li>Added the "--transaction" option to [sqldiff].
<li>Added the [sqlite3_db_cacheflush()] interface.
<li>Added the [sqlite3_strlike()] interface.
<li>When using [memory-mapped I/O] map the database file read-only so that stray pointers
    and/or array overruns in the application cannot accidently modify the database file.
<li>Added the <em>experimental</em> [sqlite3_snapshot_get()], [sqlite3_snapshot_open()],
    and [sqlite3_snapshot_free()] interfaces.  These are subject to change or removal in
    a subsequent release.
<li>Enhance the ['utc' modifier] in the [date and time functions] so that it is a no-op if
    the date/time is known to already be in UTC.  (This is not a compatibility break since
    the behavior has long been documented as "undefined" in that case.)
<li>Added the [json_group_array()] and [json_group_object()] SQL functions in the
    [json] extension.
<li>Many small performance optimizations.
<p><b>Portability enhancements:</b>
<li>Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX.
    [https://www.sqlite.org/src/fdiff?sbs=1&v1=869c95b0fc73026d&v2=232c242a0ccb3d67|(details)]
<p><b>Enhancements to the [command-line shell]:</b>
<li>Added the ".changes ON|OFF" and ".vfsinfo" [dot-commands].
<li>Translate between MBCS and UTF8 when
    running in [https://en.wikipedia.org/wiki/Cmd.exe|cmd.exe] on Windows.
<p><b>Enhancements to makefiles:</b>
<li>Added the --enable-editline option to the various autoconf-generated configure
    scripts.
<li>Omit all use of "awk" in the makefiles,
<li>Added the --enable-editline and --enable-static-shell options
    to the various autoconf-generated configure scripts.
<li>Omit all use of "awk" in the makefiles, to make building easier for MSVC users.
    to make building easier for MSVC users.
<p><b>Important fixes:</b>
<li>Fix inconsistent integer to floating-point comparison operations that
    could result in a corrupt index if the index is created on a table
    column that contains both large integers and floating point values
    of similar magnitude.  Ticket 
    [https://www.sqlite.org/src/tktview?name=38a97a87a6|38a97a87a6].
<li>Fix an infinite-loop in the query planner that could occur on
Changes to pages/cli.in.
116
117
118
119
120
121
122

123

124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143

144
145
146
147
148
149
150
116
117
118
119
120
121
122
123

124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152







+
-
+




















+







}</tcl>

<p>Be careful when using the ".save" command as it will overwrite any
preexisting database files having the same name without prompting for
confirmation.  As with the ".open" command, you might want to use a
full pathname with forward-slash directory separators to avoid ambiguity.

<tcl>hd_fragment dotcmd {dot-commands}</tcl>
<h3>Special commands to sqlite3</h3>
<h3>Special commands to sqlite3 (dot-commands)</h3>

<p>
Most of the time, sqlite3 just reads lines of input and passes them
on to the SQLite library for execution.
But if an input line begins with a dot ("."), then
that line is intercepted and interpreted by the sqlite3 program itself.
These "dot commands" are typically used to change the output format
of queries, or to execute certain prepackaged query statements.
</p>

<p>
For a listing of the available dot commands, you can enter ".help"
at any time.  For example:
</p>

<tcl>DisplayCode {
sqlite> (((.help)))
.backup ?DB? FILE      Backup DB (default "main") to FILE
.bail on|off           Stop after hitting an error.  Default OFF
.binary on|off         Turn binary output on or off.  Default OFF
.changes on|off        Show number of rows changed by SQL
.clone NEWDB           Clone data into NEWDB from the existing database
.databases             List names and files of attached databases
.dbinfo ?DB?           Show status information about the database
.dump ?TABLE? ...      Dump the database in an SQL text format
                         If TABLE specified, only dump tables matching
                         LIKE pattern TABLE.
.echo on|off           Turn command echo on or off
194
195
196
197
198
199
200

201
202
203
204
205
206
207
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210







+







.system CMD ARGS...    Run CMD ARGS... in a system shell
.tables ?TABLE?        List names of tables
                         If TABLE specified, only list tables matching
                         LIKE pattern TABLE.
.timeout MS            Try opening locked tables for MS milliseconds
.timer on|off          Turn SQL timer on or off
.trace FILE|off        Output each SQL statement as it is run
.vfsinfo ?AUX?         Information about the top-level VFS
.vfsname ?AUX?         Print the name of the VFS stack
.width NUM1 NUM2 ...   Set column widths for "column" mode
                         Negative values right-justify
sqlite> 
}</tcl>

<h3>Rules for "dot-commands"</h3>
Changes to pages/json1.in.
1
2
3
4
5
6
7

8
9
10

11
12
13
14
15
16
17
1
2
3
4
5
6

7
8
9

10
11
12
13
14
15
16
17






-
+


-
+







<title>The JSON1 Extension</title>
<tcl>hd_keywords json1 {the json1 extension} {JSON SQL functions}</tcl>
<h2>The JSON1 Extension</h2>

<p>
The <b>json1</b> extension is a [loadable extension] that
implements eleven [application-defined SQL functions] and
implements thirteen [application-defined SQL functions] and
two [table-valued functions] that are useful for
managing [http://json.org/ | JSON] content stored in an SQLite database.
These are the SQL functions implemented by json1:
These are the scalar SQL functions implemented by json1:

<blockquote>
<center><table border=0 cellpadding=5>
<tcl>
set tabcnt 0
proc tabentry {fx desc lnk} {
  global tabcnt
89
90
91
92
93
94
95
















96
97
98
99
100
101
102
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118







+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+







tabentry {json_type(json)<br>json_type(json,path)} {
  Return the type of a JSON string or subcomponent.
} jtype

tabentry {json_valid(json)} {
  Return true (1) if the input text is a valid JSON string
} jvalid
</tcl>
</table></center></blockquote>

<p>There are two aggregate SQL functions:

<blockquote><center><table border=0 cellpadding=5>
<tcl>
tabentry {json_group_array(value)} {
  Return a JSON array composed of all <i>value</i> elements 
  in the aggregation.
} jgrouparray

tabentry {json_group_object(name,value)} {
  Return a JSON object composed of all <i>name</i> and <i>value</i> pairs
  in the aggregation.
} jgroupobject
</tcl>
</table></center></blockquote>

<p>The [table-valued functions] implemented by this routine are:

<blockquote><center><table border=0 cellpadding=5>
<tcl>
508
509
510
511
512
513
514















515
516
517
518

519
520
521
522
523
524
525
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548

549
550
551
552
553
554
555
556







+
+
+
+
+
+
+
+
+
+
+
+
+
+
+



-
+








<tcl>
jexample \
  {json_valid('{"x":35}')} 1 \
  "json_valid('\173\"x\":35')" 0
</tcl>

<tcl>
hd_fragment jgrouparray {json_group_array SQL function} \
   {json_group_array}
hd_fragment jgroupobject {json_group_object SQL function} \
   {json_group_object}
</tcl>
<h3>3.10 The json_group_array() and json_group_object()
aggregate SQL functions</h3>

<p>The json_group_array(X) function is an 
[Aggregate Functions|aggregate SQL function] that returns a JSON array
comprised of all X values in the aggregation.
Similarly, the json_group_object(NAME,VALUE) function returns a JSON object
comprised of all NAME/VALUE pairs in the aggregation.


<tcl>hd_fragment jeach {json_each table-valued function} {json_each}</tcl>
<tcl>hd_fragment jtree {json_tree table-valued function} {json_tree}</tcl>
<h3>3.9 The json_each() and json_tree() table-valued functions</h3>
<h3>3.11 The json_each() and json_tree() table-valued functions</h3>

<p>The json_each(X) and json_tree(X) [table-valued functions] walk the
JSON value provided as their first argument and return one row for each
element.  The json_each(X) function only walks the immediate children
of the top-level array or object or 
or just the top-level element itself if the top-level
element is a primitive value.
586
587
588
589
590
591
592
593

594
595
596
597
598
599
600
617
618
619
620
621
622
623

624
625
626
627
628
629
630
631







-
+








<p>
The "path" column is the path to the array or object container the holds 
the current row, or the path to the current row in the case where the 
iteration starts on a primitive type and thus only provides a single
row of output.

<h4>3.10.1 Examples using json_each() and json_tree()</h4>
<h4>3.11.1 Examples using json_each() and json_tree()</h4>

<p>Suppose the table "CREATE TABLE user(name,phone)" stores zero or
more phone numbers as a JSON array object in the user.phone field.
To find all users who have any phone number with a 704 area code:

<blockquote><pre>
SELECT DISTINCT user.name
Changes to pages/lang.in.
1948
1949
1950
1951
1952
1953
1954
1955

1956
1957
1958
1959
1960
1961
1962
1948
1949
1950
1951
1952
1953
1954

1955
1956
1957
1958
1959
1960
1961
1962







-
+







<p>^The maximum parameter number is set at compile-time by
the [SQLITE_MAX_VARIABLE_NUMBER] macro.  ^(An individual [database connection]
D can reduce its maximum parameter number below the compile-time maximum
using the [sqlite3_limit](D, [SQLITE_LIMIT_VARIABLE_NUMBER],...) interface.)^
</p>

<tcl>hd_fragment like LIKE ESCAPE</tcl>
<h3>The LIKE, GLOB, and REGEXP operators</h3>
<h3>The LIKE, GLOB, REGEXP, and MATCH operators</h3>
<p>^The LIKE operator does a pattern matching comparison. ^The operand
to the right of the LIKE operator contains the pattern and the left hand
operand contains the string to match against the pattern.

<tcl>hd_puts "^A percent symbol (\"%\") in the LIKE pattern matches any
sequence of zero or more characters in the string.  ^An underscore
(\"_\") in the LIKE pattern matches any single character in the
2917
2918
2919
2920
2921
2922
2923
2924

2925
2926
2927
2928

2929

2930
2931
2932
2933
2934
2935
2936
2917
2918
2919
2920
2921
2922
2923

2924
2925
2926
2927
2928
2929

2930
2931
2932
2933
2934
2935
2936
2937







-
+




+
-
+







separate the "unixepoch" modifier from prior DDDDDDDDDD then the
behavior is undefined.
Due to precision limitations imposed by the implementations use
of 64-bit integers, the "unixepoch" modifier only works for
dates between 0000-01-01 00:00:00 and 5352-11-01 10:52:47 (unix times
of -62167219200 through 10675199167).</p>

<tcl>hd_fragment localtime {localtime modifier}</tcl>
<tcl>hd_fragment localtime {localtime modifier} {'utc' modifier}</tcl>
<p>^The "localtime" modifier (12) assumes the time string to its left is in
Universal Coordinated Time (UTC) and adjusts the time
string so that it displays localtime.  If "localtime"
follows a time that is not UTC, then the behavior is undefined.
^(The "utc" modifier is the opposite of "localtime".  
^(The "utc" is the opposite of "localtime".  "utc" assumes that the string
"utc" assumes that the string
to its left is in the local timezone and adjusts that string to be in UTC.)^
If the prior string is not in localtime, then the result of "utc" is
undefined.</p>

<h3>Examples</h3>

^(<p>Compute the current date.<p>