Documentation Source Text

Check-in [3f00f6192a]
Login

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

Overview
Comment:Update syntax diagrams for expr and vacuum.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3f00f6192aae804992234f6e0f42ae54ed2d98c2
User & Date: drh 2016-09-14 17:28:35
Context
2016-09-14
17:45
Update documentation on VACUUM to describe how attached databases can be vacuumed. check-in: 6f01723464 user: drh tags: trunk
17:28
Update syntax diagrams for expr and vacuum. check-in: 3f00f6192a user: drh tags: trunk
16:27
Continuing work on the row value documentation. check-in: ee61092516 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to art/syntax/bubble-generator-data.tcl.

254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
...
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
    or
     {line literal-value}
     {line bind-parameter}
     {line {optx {optx /schema-name .} /table-name .} /column-name}
     {line /unary-operator expr}
     {line expr /binary-operator expr}
     {line /function-name ( {or {line {optx DISTINCT} {toploop expr ,}} {} *} )}
     {line ( expr )}
     {line CAST ( expr AS type-name )}
     {line expr COLLATE /collation-name}
     {line expr {optx NOT} {or LIKE GLOB REGEXP MATCH} expr
           {opt ESCAPE expr}}
     {line expr {or ISNULL NOTNULL {line NOT NULL}}}
     {line expr IS {optx NOT} expr}
     {line expr {optx NOT} BETWEEN expr AND expr}
................................................................................
        }
  }
  qualified-table-name {
     line {optx /schema-name .} /table-name
          {or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
  }
  vacuum-stmt {
      line VACUUM
  }
  comment-syntax {
    or
      {line -- {loop nil /anything-except-newline} 
           {or /newline /end-of-input}}
      {line /* {loop nil /anything-except-*/}
           {or */ /end-of-input}}
  }
}







|







 







|









254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
...
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
    or
     {line literal-value}
     {line bind-parameter}
     {line {optx {optx /schema-name .} /table-name .} /column-name}
     {line /unary-operator expr}
     {line expr /binary-operator expr}
     {line /function-name ( {or {line {optx DISTINCT} {toploop expr ,}} {} *} )}
     {line ( {toploop expr ,} )}
     {line CAST ( expr AS type-name )}
     {line expr COLLATE /collation-name}
     {line expr {optx NOT} {or LIKE GLOB REGEXP MATCH} expr
           {opt ESCAPE expr}}
     {line expr {or ISNULL NOTNULL {line NOT NULL}}}
     {line expr IS {optx NOT} expr}
     {line expr {optx NOT} BETWEEN expr AND expr}
................................................................................
        }
  }
  qualified-table-name {
     line {optx /schema-name .} /table-name
          {or nil {line INDEXED BY /index-name} {line NOT INDEXED}}
  }
  vacuum-stmt {
      line VACUUM {opt /schema-name}
  }
  comment-syntax {
    or
      {line -- {loop nil /anything-except-newline} 
           {or /newline /end-of-input}}
      {line /* {loop nil /anything-except-*/}
           {or */ /end-of-input}}
  }
}

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
20


21
22
23
24
25
26
27
28
29
30
31
32







33
34
35


36
37
38
39
40
41
42
#!/bin/wish
#
# Run this wish script to generate syntax bubble diagrams from
# text descriptions.
#

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


# Top-level displays
#
toplevel .bb
canvas .c -bg white
pack .c -side top -fill both -expand 1
wm withdraw .

# Draw the button bar
#

set bn 0



frame .bb.f1
frame .bb.f2


pack .bb.f1 -side left -fill both -expand 1
pack .bb.f2 -side left -fill both -expand 1
set side .bb.f1
foreach {name graph} $all_graphs {
  incr bn
  set b $side.b$bn
  button $b -text $name -command [list draw_graph $name $graph] -pady 0
  pack $b -side top -fill x -expand 1 -pady 0
  if {$side==".bb.f1"} {set side .bb.f2} {set side .bb.f1}
}
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 RADIUS 9                      ;# default turn radius
set HSEP 17                       ;# horizontal separation
set VSEP 9                        ;# vertical separation
set DPI 80                       ;# dots per inch





<
|
>










>
|
>
>
>
|
|
>
>
|
|
|
|
|
|
|
|
|
|
|
<
>
>
>
>
>
>
>
|
|
|
>
>







1
2
3
4
5

6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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
#!/bin/wish
#
# Run this wish script to generate syntax bubble diagrams from
# text descriptions.
#

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

# Top-level displays
#
toplevel .bb
canvas .c -bg white
pack .c -side top -fill both -expand 1
wm withdraw .

# Draw the button bar
#
proc create_buttons {} {
  set bn 0
  catch { destroy .bb.f1 }
  catch { destroy .bb.f2 }
  catch { destroy .bb.x }
  frame .bb.f1
  frame .bb.f2
  frame .bb.x
  pack .bb.x -side top -fill x -expand 1
  pack .bb.f1 -side left -fill both -expand 1
  pack .bb.f2 -side left -fill both -expand 1
  set side .bb.f1
  foreach {name graph} $::all_graphs {
    incr bn
    set b $side.b$bn
    button $b -text $name -command [list draw_graph $name $graph] -pady 0
    pack $b -side top -fill x -expand 1 -pady 0
    if {$side==".bb.f1"} {set side .bb.f2} {set side .bb.f1}
  }
  incr bn

  button .bb.x.r -text Redraw -command {
    source $datafile
    create_buttons
  }
  pack .bb.x.r -side top -fill x -expand 1
  button .bb.x.q -text Quit -command {exit}
  pack .bb.x.q -side top -fill x -expand 1
  button .bb.x.e -text Everything -command {draw_all_graphs}
  pack .bb.x.e -side top -fill x -expand 1
}
create_buttons
  
set tagcnt 0                      ;# tag counter
set font1 {Helvetica 16 bold}     ;# default token font
set font2 {GillSans 14 bold}      ;# default variable font
set RADIUS 9                      ;# default turn radius
set HSEP 17                       ;# horizontal separation
set VSEP 9                        ;# vertical separation
set DPI 80                       ;# dots per inch

Changes to art/syntax/expr.gif.

cannot compute difference between binary files

Changes to art/syntax/vacuum-stmt.gif.

cannot compute difference between binary files