Documentation Source Text

Check-in [3fd4c6332b]
Login

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

Overview
Comment:Links to syntax diagrams now go to a page that contains just that one diagram, rather than the page of all diagrams. This is the first step toward adding descriptive text about each diagram.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3fd4c6332b6dc476378f35a0d72394b11ff60a14
User & Date: drh 2014-09-25 21:14:49.419
Context
2014-09-30
12:57
Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. (check-in: a893d831f4 user: drh tags: trunk)
2014-09-25
21:14
Links to syntax diagrams now go to a page that contains just that one diagram, rather than the page of all diagrams. This is the first step toward adding descriptive text about each diagram. (check-in: 3fd4c6332b user: drh tags: trunk)
2014-09-24
13:25
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. (check-in: d59078695f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Added pages/syntax.in.
































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
57
58
59
60
61
62
63
64
<title>List of SQLite Syntax Diagrams</title>

<h1 align="center">List of SQLite Syntax Diagrams</h1>

<table border=0 cellspacing=25 width="100%"><tr>
<tcl>
  set n [llength $syntax_order]
  set lx [lsort $syntax_order]
  set ncol 3
  set percol [expr {($n+$ncol-1)/$ncol}]
  for {set ii 0} {$ii<$ncol} {incr ii} {
    hd_putsnl {<td valign='top' width='33%'>}
    hd_putsnl {<ul>}
    set max [expr {($ii+1)*$percol}]
    if {$max>$n} {set max $n}
    for {set jj [expr {$ii*$percol}]} {$jj<$max} {incr jj} {
      set name [lindex $lx $jj]
      hd_putsnl "<li><a href='syntax/$name.html'>$name</a></li>"
    }
    hd_putsnl {</ul></td>}
  }
</tcl>
</tr></table>
<tcl>
foreach name $syntax_order {
  file mkdir $::DEST/syntax
  hd_open_aux syntax/$name.html
  hd_enable_main 0
  hd_header "SQLite Syntax: $name"
  hd_keywords $name "$name syntax diagram"
  hd_putsnl "<h1 align='center'>$name</h1>"
  hd_putsnl "<blockquote>"
  hd_putsnl "<img src='../images/syntax/$name.gif'></img><br>"
  foreach {cx px} $syntax_linkage($name) break
  if {[llength $px]>0} {
    hd_puts "\nUsed by:"
    foreach c $px {
      hd_puts "&nbsp;&nbsp; <a href='./$c.html'>$c</a>"
    }
  }
  if {[llength $cx]>0} {
    hd_puts "<br></br>\nReferences:"
    foreach c $cx {
      hd_puts "&nbsp;&nbsp; <a href='./$c.html'>$c</a>"
    }
  }
  if {[info exists ::backlink($name)]} {
    unset -nocomplain bk
    foreach c $::backlink($name) {
      regsub {#.*} $c {} c
      set bk($c) 1
    }
    set bklist [lsort [array names bk]]
    if {[llength $bklist]>0} {
      hd_puts "<br></br>\nSee also:"
      foreach c $bklist {
        hd_puts "&nbsp;&nbsp; <a href='../$c'>$c</a>"
      }
    }
  }
  hd_puts "\n</blockquote>\n\n"
  hd_close_aux
}
</tcl>
Changes to pages/syntaxdiagrams.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<title>Syntax Diagrams For SQLite</title>
<tcl>hd_keywords {syntax diagrams}</tcl>

<h1 align=center>Syntax Diagrams For SQLite</h1>

<tcl>

foreach name $syntax_order {
  hd_fragment $name *$name "$name syntax diagram"
  hd_puts "<h4>$name:</h4>"
  hd_puts "<blockquote>\n"
  hd_puts "<img src=\"images/syntax/$name.gif\"></img><br></br>"
  foreach {cx px} $syntax_linkage($name) break
  if {[llength $px]>0} {
    hd_puts "\nUsed by:"
    foreach c $px {








|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<title>Syntax Diagrams For SQLite</title>
<tcl>hd_keywords {syntax diagrams}</tcl>

<h1 align=center>Syntax Diagrams For SQLite</h1>

<tcl>

foreach name $syntax_order {
  # hd_fragment $name *$name "$name syntax diagram"
  hd_puts "<h4>$name:</h4>"
  hd_puts "<blockquote>\n"
  hd_puts "<img src=\"images/syntax/$name.gif\"></img><br></br>"
  foreach {cx px} $syntax_linkage($name) break
  if {[llength $px]>0} {
    hd_puts "\nUsed by:"
    foreach c $px {