Documentation Source Text

Check-in [b69af062e6]
Login

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

Overview
Comment:Add hyperlinks to source documetns on the requirements.html page. Add mention of the psow query parameter to the uri.html page.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b69af062e6b2dc1615de47ee569c1c8e5666bbcb
User & Date: drh 2011-12-31 00:20:25
Context
2012-01-02
15:48
Document the change to PRAGMA cache_size in which a negative argument can be used to set the cache size in kibibytes. check-in: 47c781b488 user: drh tags: trunk
2011-12-31
00:20
Add hyperlinks to source documetns on the requirements.html page. Add mention of the psow query parameter to the uri.html page. check-in: b69af062e6 user: drh tags: trunk
2011-12-30
20:41
Update the change log for 3.7.10. Added information on test modules associated with each requirement. check-in: d62d2f8ee3 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/requirements.in.

116
117
118
119
120
121
122



123

124
125
126
127

128
129

130
131
132
133
134
135
136

<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"



  hd_puts "<dd><p>$reqtext\n"

  set ck [
    db eval {SELECT DISTINCT srccat || '/' || srcfile FROM evidence
             WHERE reqno=$reqno ORDER BY 1}
  ]

  if {[llength $ck]==0} {
    hd_puts "<i>(source: $srcfile)</i>"

  } else {
    hd_puts "<i>(source: $srcfile, checked-by: [join $ck {, }])</i>"
  }
  hd_puts "</p></dd>\n\n"
}
</tcl>
</dl>







>
>
>
|
>




>

<
>

|





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>

Changes to pages/uri.in.

163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190







191
192
193
194
195
196
197
198
199
Some query parameters are interpreted by the SQLite core and used to 
modify the characteristics of the new connection.  ^All query parameters
are always passed through into the xOpen method of the [VFS] even if
they are previously read and interpreted by the SQLite core.
</p>

<p>
The following query parameters are recognized by SQLite as of version 3.7.7.
Other query parameters might be added to this set in future releases.
</p>

<dl>
<dt><b>vfs=</b><i>NAME</i></dt>
<dd><p>^This query parameter causes the database connection to be opened
using the [VFS] called <i>NAME</i>.
^The open attempt fails if <i>NAME</i> is not the name of a [VFS] that
is built into SQLite or that has been previously registered using
[sqlite3_vfs_register()].</dd>

<dt><b>mode=ro<br>mode=rw<br>mode=rwc</b></dt>
<dd><p>^These query parameters determine if the new database is opened
read-only, read-write, or read-write and created if it does not exist,
respectively.
</dd>

<dt><b>cache=shared<br>cache=private</b></dt>
<dd><p>^These query parameters determine if the new database is opened
using [shared cache mode] or with a private cache, respectively.







</dd>
</dl>

<h1>4.0 See Also</h1>

<ul>
<li> [URI filenames in sqlite3_open()]
<li> [URI filename examples]
</ul>







|





|






|
|
<



|
|
>
>
>
>
>
>
>









163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
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
Some query parameters are interpreted by the SQLite core and used to 
modify the characteristics of the new connection.  ^All query parameters
are always passed through into the xOpen method of the [VFS] even if
they are previously read and interpreted by the SQLite core.
</p>

<p>
The following query parameters are recognized by SQLite as of version 3.7.10.
Other query parameters might be added to this set in future releases.
</p>

<dl>
<dt><b>vfs=</b><i>NAME</i></dt>
<dd><p>^The vfs query parameter causes the database connection to be opened
using the [VFS] called <i>NAME</i>.
^The open attempt fails if <i>NAME</i> is not the name of a [VFS] that
is built into SQLite or that has been previously registered using
[sqlite3_vfs_register()].</dd>

<dt><b>mode=ro<br>mode=rw<br>mode=rwc</b></dt>
<dd><p>^The mode query parameter determines if the new database is opened
read-only, read-write, or read-write and created if it does not exist.

</dd>

<dt><b>cache=shared<br>cache=private</b></dt>
<dd><p>^The cache query parameter determines if the new database is opened
using [shared cache mode] or with a private cache.
</dd>

<dt><b>psow=0<br>psow=1</b></dt>
<dd><p>^The psow query parameter overrides the [powersafe overwrite]
property of the database file being opened.  ^The psow query parameter
works with the default windows and unix [VFSes] but might be a no-op for
other proprietary or non-standard VFSes.
</dd>
</dl>

<h1>4.0 See Also</h1>

<ul>
<li> [URI filenames in sqlite3_open()]
<li> [URI filename examples]
</ul>