Documentation Source Text

Check-in [a6da4c726a]
Login

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

Overview
Comment:Update the requirements.html document to provide links into the matrix for each requirement.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a6da4c726af1d1550617edd507e26c11d4e5c409
User & Date: drh 2015-09-11 20:19:09.479
Context
2015-09-11
22:51
Add links from the requirements.html page into the matrix. Clarifications to the CREATE INDEX and REINDEX documentation. (check-in: c1c7b5e3d1 user: drh tags: trunk)
20:19
Update the requirements.html document to provide links into the matrix for each requirement. (check-in: a6da4c726a user: drh tags: trunk)
17:17
Improvements and fixes to the eponymous virtual table documentation. (check-in: a8cbed7cc9 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
︙︙
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
3175
3176

See the section titled [ON CONFLICT] for additional information.
For compatibility with MySQL, ^the parser allows the use of the
single keyword <a href="lang_replace.html">REPLACE</a> as an 
alias for "INSERT OR REPLACE".

<p>^(The optional "<i>schema-name</i><b>.</b>" prefix on the 
<yyterm>table-name</yyterm>
is support for top-level INSERT statements only.)^  ^The table name must be
unqualified for INSERT statements that occur within [CREATE TRIGGER] statements.
^Similarly, the "DEFAULT VALUES" form of the INSERT statement is supported for
top-level INSERT statements only and not for INSERT statements within
triggers.
<p>

<tcl>








|








3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
3175
3176

See the section titled [ON CONFLICT] for additional information.
For compatibility with MySQL, ^the parser allows the use of the
single keyword <a href="lang_replace.html">REPLACE</a> as an 
alias for "INSERT OR REPLACE".

<p>^(The optional "<i>schema-name</i><b>.</b>" prefix on the 
<yyterm>table-name</yyterm>
is supported for top-level INSERT statements only.)^  ^The table name must be
unqualified for INSERT statements that occur within [CREATE TRIGGER] statements.
^Similarly, the "DEFAULT VALUES" form of the INSERT statement is supported for
top-level INSERT statements only and not for INSERT statements within
triggers.
<p>

<tcl>
︙︙
Changes to pages/requirements.in.
︙︙
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



<h2>2.0 List Of Requirements</h2>

<dl>
<tcl>
db eval {SELECT * FROM requirement ORDER BY reqno} {



  hd_puts "<dt><b>$reqno</b></dt>\n"
  if {$reqimage} {
    hd_puts "<dd><p>$origtext<br>\n"
  } else {
    hd_puts "<dd><p>$reqtext\n"
  }
  set ck [
    db eval {SELECT DISTINCT srccat || '/' || srcfile FROM evidence
             WHERE reqno=$reqno ORDER BY 1}
  ]
  hd_puts "<i>(source <a href=\"$srcfile\">$srcfile</a>"
  if {[llength $ck]==0} {
    hd_puts ")</i>"
  } else {
    hd_puts ", checked-by: [join $ck {, }])</i>"
  }


  hd_puts "</p></dd>\n\n"
}
</tcl>
</dl>








>
>
>











|
<
<
|

>
>





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



<h2>2.0 List Of Requirements</h2>

<dl>
<tcl>
db eval {SELECT * FROM requirement ORDER BY reqno} {
  regsub -all {[^a-zA-Z0-9]} [file tail [file root $srcfile]] _ docid
  set durl "matrix/matrix_d$docid.html#$reqno"
  set surl "matrix/$srcfile#$reqno"
  hd_puts "<dt><b>$reqno</b></dt>\n"
  if {$reqimage} {
    hd_puts "<dd><p>$origtext<br>\n"
  } else {
    hd_puts "<dd><p>$reqtext\n"
  }
  set ck [
    db eval {SELECT DISTINCT srccat || '/' || srcfile FROM evidence
             WHERE reqno=$reqno ORDER BY 1}
  ]
  hd_puts "<i>(source <a href=\"$srcfile\">$srcfile</a>"
  if {[llength $ck]>0} {


    hd_puts ", checked-by: [join $ck {, }]"
  }
  hd_puts ", matrix: <a href='$surl'>context</a>"
  hd_puts ", <a href='$durl'>detail</a>)</i>"
  hd_puts "</p></dd>\n\n"
}
</tcl>
</dl>