Documentation Source Text

Check-in [ede6ba1df3]
Login

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

Overview
Comment:Adjustments to the document indexes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: ede6ba1df33dcf40bca51be4dd63c7c3fe50465042d366de46ebea70b5912dca
User & Date: drh 2019-09-26 15:24:57.440
Context
2019-09-26
19:02
Fix introspection pragma documentation to show that they are now on by default. Add documentation for the TCL Interface config method. (check-in: a94ea31acb user: drh tags: trunk)
15:24
Adjustments to the document indexes. (check-in: ede6ba1df3 user: drh tags: trunk)
2019-09-16
14:49
Add SQLITE_DIRECTONLY to the change log and documentation. Fix a typo in changes to the index_info pragma. (check-in: 518f7b3bdd user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/doclist.in.
23
24
25
26
27
28
29
30


31
32
33
34
35
36
37
     ('https://sqlite.org/sqlar/','SQLite Archiver (sqlar.exe)'),
     ('https://www.fossil-scm.org/','The Fossil Version Control System')
  ;
}
db eval {
  SELECT filename, pagetitle
    FROM page
   WHERE pagetitle IS NOT NULL AND pagetitle!='No Title'


  UNION ALL
  SELECT url, pagetitle FROM expage
   ORDER BY pagetitle COLLATE nocase
} {
  hd_puts "<li><a href=\"$filename\">$pagetitle</a></li>\n"
}
</tcl>







|
>
>







23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
     ('https://sqlite.org/sqlar/','SQLite Archiver (sqlar.exe)'),
     ('https://www.fossil-scm.org/','The Fossil Version Control System')
  ;
}
db eval {
  SELECT filename, pagetitle
    FROM page
   WHERE pagetitle IS NOT NULL
     AND pagetitle!='No Title'
     AND pagetitle NOT LIKE 'code of %'
  UNION ALL
  SELECT url, pagetitle FROM expage
   ORDER BY pagetitle COLLATE nocase
} {
  hd_puts "<li><a href=\"$filename\">$pagetitle</a></li>\n"
}
</tcl>
Changes to pages/sitemap.in.
17
18
19
20
21
22
23
24


25
26
27
28
29
30
31
<ul class='lessindent'>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}
db eval {
  SELECT pagetitle, filename FROM page WHERE pagetitle!='No Title'


  UNION ALL
  SELECT alttitle, filename FROM alttitle, page
   WHERE alttitle.pageid=page.pageid
  UNION ALL
  SELECT pagetitle, url FROM expage
} {
  regsub -all -- {-} $pagetitle { } pagetitle







|
>
>







17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<ul class='lessindent'>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}
db eval {
  SELECT pagetitle, filename FROM page 
   WHERE pagetitle!='No Title'
     AND pagetitle NOT LIKE 'code of %'
  UNION ALL
  SELECT alttitle, filename FROM alttitle, page
   WHERE alttitle.pageid=page.pageid
  UNION ALL
  SELECT pagetitle, url FROM expage
} {
  regsub -all -- {-} $pagetitle { } pagetitle