System.Data.SQLite
Check-in [872bd8c9ee]
Not logged in

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

Overview
Comment:Further improvements to the download page update script.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 872bd8c9ee232f72e67f403411eab1fcb1105b26
User & Date: mistachkin 2015-07-30 18:13:28
Context
2015-07-30
18:30
Update release procedures wiki page. check-in: fc9062d656 user: mistachkin tags: trunk
18:13
Further improvements to the download page update script. check-in: 872bd8c9ee user: mistachkin tags: trunk
17:59
Improve robustness of the download page update script. check-in: a2473ecc36 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Setup/updateFileInfo.tcl.

    97     97   
    98     98   set pattern2 {<a\
    99     99       href=".*?/package/.*?/\d+\.\d+\.\d+\.\d+">(.*?)</a>.*?\((\d+?\.\d+?)\
   100    100       MiB\).*?sha1: ([0-9A-F]{40})}
   101    101   
   102    102   set pattern3 {href="/downloads/(.*?)"}
   103    103   set pattern4 {\(sha1: ([0-9A-F]{40})\)}
          104  +set pattern5 {\((\d+?\.\d+?) MiB\)}
   104    105   
   105    106   #
   106    107   # NOTE: Grab all the data from the file to be updated.
   107    108   #
   108    109   set data [readFile $updateFileName]
   109    110   
   110    111   #
................................................................................
   184    185   }
   185    186   
   186    187   #
   187    188   # NOTE: Attempt to verify that each file name now has the correct SHA1 hash
   188    189   #       associated with it on the page.
   189    190   #
   190    191   foreach {dummy3 fileName} [regexp -all -inline -nocase -- $pattern3 $data] \
   191         -        {dummy4 fileHash} [regexp -all -inline -nocase -- $pattern4 $data] {
          192  +        {dummy4 fileHash} [regexp -all -inline -nocase -- $pattern4 $data] \
          193  +        {dummy5 fileSize} [regexp -all -inline -nocase -- $pattern5 $data] {
   192    194     #
   193    195     # NOTE: Get the fully qualified file name based on the configured
   194    196     #       directory.
   195    197     #
   196    198     set fullFileName [file join $outputDirectory [file tail $fileName]]
   197    199   
   198    200     #
................................................................................
   202    204     set fullFileHash [getFileHash $fullFileName]
   203    205   
   204    206     if {$fileHash ne $fullFileHash} then {
   205    207       puts stdout "ERROR: SHA1 hash mismatch for\
   206    208           file \"$fullFileName\", have \"$fileHash\" (from data),\
   207    209           need \"$fullFileHash\" (calculated)."
   208    210     }
          211  +
          212  +  set fullFileSize [getFileSize $fullFileName]
          213  +
          214  +  if {$fileSize ne $fullFileSize} then {
          215  +    puts stdout "ERROR: Byte size mismatch for\
          216  +        file \"$fullFileName\", have \"$fileSize\" (from data),\
          217  +        need \"$fullFileSize\" (calculated)."
          218  +  }
   209    219   }
   210    220   
   211    221   #
   212    222   # NOTE: Write the [modified] data to the file to be updated.
   213    223   #
   214    224   if {$count > 0} then {
   215    225     writeFile $updateFileName $data
   216    226   } else {
   217    227     puts stdout "WARNING: No changes, update of \"$updateFileName\" skipped."
   218    228   }

Changes to www/downloads.wiki.

  2118   2118         </td>
  2119   2119       </tr>
  2120   2120   
  2121   2121       <tr>
  2122   2122         <td width="10">&nbsp;</td>
  2123   2123         <td width="30%" valign="top" align="right">
  2124   2124           <a href="http://www.sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/1.0.66.0/SQLite-1.0.66.0-setup.exe/download">SQLite-1.0.66.0-setup.exe</a>
  2125         -        <br />
  2126         -        (3.2 MiB)
  2127   2125         </td>
  2128   2126         <td width="5"></td>
  2129   2127         <td valign="top">
  2130   2128           Legacy versions, as well as the original support forums, may still be
  2131   2129           found at
  2132   2130           <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a>,
  2133   2131           though there have been no updates to this version since April of 2010.