System.Data.SQLite
Check-in [23a3ba47a0]
Not logged in

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

Overview
Comment:Add tooling to sync up the SQLite core library docs from upstream.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 23a3ba47a0a55172e2ec8ecf9043c2e5cc49e9c1
User & Date: mistachkin 2016-09-12 19:44:51
Context
2016-09-12
21:01
More doc tooling updates. check-in: d8c22e8ff7 user: mistachkin tags: trunk
19:44
Add tooling to sync up the SQLite core library docs from upstream. check-in: 23a3ba47a0 user: mistachkin tags: trunk
18:57
Update SQLite core library to the 3.14.2 release. check-in: 33e23b483e user: mistachkin tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Added Doc/sync.eagle.









































































































































































































































































































































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
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
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
206
207
208
209
210
211
212
###############################################################################
#
# sync.eagle --
#
# Written by Joe Mistachkin.
# Released to the public domain, use at your own risk!
#
###############################################################################

set fileNames [list \
    [file join lang.html] \
    [file join lang_aggfunc.html] \
    [file join lang_altertable.html] \
    [file join lang_analyze.html] \
    [file join lang_attach.html] \
    [file join lang_comment.html] \
    [file join lang_conflict.html] \
    [file join lang_corefunc.html] \
    [file join lang_createindex.html] \
    [file join lang_createtable.html] \
    [file join lang_createtrigger.html] \
    [file join lang_createview.html] \
    [file join lang_createvtab.html] \
    [file join lang_datefunc.html] \
    [file join lang_delete.html] \
    [file join lang_detach.html] \
    [file join lang_dropindex.html] \
    [file join lang_droptable.html] \
    [file join lang_droptrigger.html] \
    [file join lang_dropview.html] \
    [file join lang_explain.html] \
    [file join lang_expr.html] \
    [file join lang_indexedby.html] \
    [file join lang_insert.html] \
    [file join lang_keywords.html] \
    [file join lang_naming.html] \
    [file join lang_reindex.html] \
    [file join lang_replace.html] \
    [file join lang_savepoint.html] \
    [file join lang_select.html] \
    [file join lang_transaction.html] \
    [file join lang_update.html] \
    [file join lang_vacuum.html] \
    [file join lang_with.html] \
    [file join pragma.html] \
    [file join syntax.html] \
    [file join syntaxdiagrams.html] \
    [file join vtab.html] \
    [file join images sqlite370_banner.gif] \
    [file join images syntax alter-table-stmt.gif] \
    [file join images syntax analyze-stmt.gif] \
    [file join images syntax attach-stmt.gif] \
    [file join images syntax begin-stmt.gif] \
    [file join images syntax column-constraint.gif] \
    [file join images syntax column-def.gif] \
    [file join images syntax comment-syntax.gif] \
    [file join images syntax commit-stmt.gif] \
    [file join images syntax common-table-expression.gif] \
    [file join images syntax compound-operator.gif] \
    [file join images syntax compound-select-stmt.gif] \
    [file join images syntax conflict-clause.gif] \
    [file join images syntax create-index-stmt.gif] \
    [file join images syntax create-table-stmt.gif] \
    [file join images syntax create-trigger-stmt.gif] \
    [file join images syntax create-view-stmt.gif] \
    [file join images syntax create-virtual-table-stmt.gif] \
    [file join images syntax cte-table-name.gif] \
    [file join images syntax delete-stmt-limited.gif] \
    [file join images syntax delete-stmt.gif] \
    [file join images syntax detach-stmt.gif] \
    [file join images syntax drop-index-stmt.gif] \
    [file join images syntax drop-table-stmt.gif] \
    [file join images syntax drop-trigger-stmt.gif] \
    [file join images syntax drop-view-stmt.gif] \
    [file join images syntax expr.gif] \
    [file join images syntax factored-select-stmt.gif] \
    [file join images syntax foreign-key-clause.gif] \
    [file join images syntax indexed-column.gif] \
    [file join images syntax insert-stmt.gif] \
    [file join images syntax join-clause.gif] \
    [file join images syntax join-constraint.gif] \
    [file join images syntax join-operator.gif] \
    [file join images syntax literal-value.gif] \
    [file join images syntax numeric-literal.gif] \
    [file join images syntax ordering-term.gif] \
    [file join images syntax pragma-stmt.gif] \
    [file join images syntax pragma-value.gif] \
    [file join images syntax qualified-table-name.gif] \
    [file join images syntax raise-function.gif] \
    [file join images syntax recursive-cte.gif] \
    [file join images syntax reindex-stmt.gif] \
    [file join images syntax release-stmt.gif] \
    [file join images syntax result-column.gif] \
    [file join images syntax rollback-stmt.gif] \
    [file join images syntax savepoint-stmt.gif] \
    [file join images syntax select-core.gif] \
    [file join images syntax select-stmt.gif] \
    [file join images syntax signed-number.gif] \
    [file join images syntax simple-select-stmt.gif] \
    [file join images syntax sql-stmt-list.gif] \
    [file join images syntax sql-stmt.gif] \
    [file join images syntax table-constraint.gif] \
    [file join images syntax table-or-subquery.gif] \
    [file join images syntax type-name.gif] \
    [file join images syntax update-stmt-limited.gif] \
    [file join images syntax update-stmt.gif] \
    [file join images syntax vacuum-stmt.gif] \
    [file join images syntax with-clause.gif] \
    [file join syntax alter-table-stmt.html] \
    [file join syntax analyze-stmt.html] \
    [file join syntax attach-stmt.html] \
    [file join syntax begin-stmt.html] \
    [file join syntax column-constraint.html] \
    [file join syntax column-def.html] \
    [file join syntax comment-syntax.html] \
    [file join syntax commit-stmt.html] \
    [file join syntax common-table-expression.html] \
    [file join syntax compound-operator.html] \
    [file join syntax compound-select-stmt.html] \
    [file join syntax conflict-clause.html] \
    [file join syntax create-index-stmt.html] \
    [file join syntax create-table-stmt.html] \
    [file join syntax create-trigger-stmt.html] \
    [file join syntax create-view-stmt.html] \
    [file join syntax create-virtual-table-stmt.html] \
    [file join syntax cte-table-name.html] \
    [file join syntax delete-stmt-limited.html] \
    [file join syntax delete-stmt.html] \
    [file join syntax detach-stmt.html] \
    [file join syntax drop-index-stmt.html] \
    [file join syntax drop-table-stmt.html] \
    [file join syntax drop-trigger-stmt.html] \
    [file join syntax drop-view-stmt.html] \
    [file join syntax expr.html] \
    [file join syntax factored-select-stmt.html] \
    [file join syntax foreign-key-clause.html] \
    [file join syntax indexed-column.html] \
    [file join syntax insert-stmt.html] \
    [file join syntax join-clause.html] \
    [file join syntax join-constraint.html] \
    [file join syntax join-operator.html] \
    [file join syntax literal-value.html] \
    [file join syntax numeric-literal.html] \
    [file join syntax ordering-term.html] \
    [file join syntax pragma-stmt.html] \
    [file join syntax pragma-value.html] \
    [file join syntax qualified-table-name.html] \
    [file join syntax raise-function.html] \
    [file join syntax recursive-cte.html] \
    [file join syntax reindex-stmt.html] \
    [file join syntax release-stmt.html] \
    [file join syntax result-column.html] \
    [file join syntax rollback-stmt.html] \
    [file join syntax savepoint-stmt.html] \
    [file join syntax select-core.html] \
    [file join syntax select-stmt.html] \
    [file join syntax signed-number.html] \
    [file join syntax simple-select-stmt.html] \
    [file join syntax sql-stmt-list.html] \
    [file join syntax sql-stmt.html] \
    [file join syntax table-constraint.html] \
    [file join syntax table-or-subquery.html] \
    [file join syntax type-name.html] \
    [file join syntax update-stmt-limited.html] \
    [file join syntax update-stmt.html] \
    [file join syntax vacuum-stmt.html] \
    [file join syntax with-clause.html]]

###############################################################################

set specialFileNames [list \
    [file join vtab.html]]

###############################################################################

set path [file dirname [info script]]
set rootUri https://www.sqlite.org
set rootDirectory [file join $path]

if {[info exists argv] && \
    [lsearch -exact -- $argv --verbose] != -1} then {
  set verbose true
} else {
  set verbose false
}

foreach fileName $fileNames {
  set uri [file join $rootUri $fileName]

  if {[lsearch -exact -- $specialFileNames $fileName] != -1} then {
    set directory [file join \
        $rootDirectory Special Core [file dirname $fileName]]
  } else {
    set directory [file join \
        $rootDirectory Extra Core [file dirname $fileName]]
  }

  set fileName [file normalize \
      [file join $directory [file tail $fileName]]]

  if {$verbose} then {
    puts -nonewline stdout [appendArgs \
        "Downloading \"" $uri "\" to \"" $fileName "\"... "]
  }

  file delete $fileName
  uri download $uri $fileName

  if {$verbose} then {
    puts stdout OK
  }
}

Changes to Setup/data/verify.lst.

198
199
200
201
202
203
204

205
206
207
208
209
210
211
  Doc/Special/
  Doc/Special/Core/
  Doc/Special/Core/vtab.html
  Doc/SQLite.NET.chm
  Doc/SQLite.NET.hhc
  Doc/SQLite.NET.hhp
  Doc/SQLite.NET.ndoc

  Doc/vtab.tcl
  Externals/
  Externals/Eagle/
  Externals/Eagle/bin/
  Externals/Eagle/bin/EagleShell.exe.config
  Externals/Eagle/bin/EagleShell.exe.mda.config
  Externals/Eagle/lib/







>







198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
  Doc/Special/
  Doc/Special/Core/
  Doc/Special/Core/vtab.html
  Doc/SQLite.NET.chm
  Doc/SQLite.NET.hhc
  Doc/SQLite.NET.hhp
  Doc/SQLite.NET.ndoc
  Doc/sync.tcl
  Doc/vtab.tcl
  Externals/
  Externals/Eagle/
  Externals/Eagle/bin/
  Externals/Eagle/bin/EagleShell.exe.config
  Externals/Eagle/bin/EagleShell.exe.mda.config
  Externals/Eagle/lib/

Changes to www/release.wiki.

245
246
247
248
249
250
251



























252
253
254
255
256
257
258

  <li>
    Copy those changes to the
    &quot;&lt;root&gt;\Doc\Extra\Provider\version.html&quot; and
    &quot;&lt;root&gt;\www\news.wiki&quot; files, reformatting as necessary
    to fit with the existing document conventions.
  </li>



























</ol>

<a name="buildDocumentation"></a>
<h2>Build Documentation</h2>

<ol>
  <li>Open a normal command prompt window with &quot;cmd.exe&quot;.</li>







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285

  <li>
    Copy those changes to the
    &quot;&lt;root&gt;\Doc\Extra\Provider\version.html&quot; and
    &quot;&lt;root&gt;\www\news.wiki&quot; files, reformatting as necessary
    to fit with the existing document conventions.
  </li>

  <li>Change the current directory to &quot;&lt;root&gt;\Doc&quot;.</li>

  <li>
    Enter the following command to update all documentation that is
    included from upstream (e.g. from the SQLite core library, etc):
    <br />
    <br />
    <b>..\Externals\Eagle\bin\EagleShell.exe -file sync.eagle --verbose</b>
  </li>

  <li>
    Enter the following command to update the embedded SQLite core library
    virtual table documentation:
    <br />
    <br />
    <b>tclsh.exe&nbsp;vtab.tcl</b>
    <br />
    <br />
    <i>This assumes that [https://www.activestate.com/activetcl | ActiveTcl]
    version 8.4 or later has been installed using the default settings.</i>
  </li>

  <li>
    Make sure everything downloads with no errors; the console output may be
    checked if any errors should occur.
  </li>
</ol>

<a name="buildDocumentation"></a>
<h2>Build Documentation</h2>

<ol>
  <li>Open a normal command prompt window with &quot;cmd.exe&quot;.</li>