/ Check-in [57d4c770]
Login

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

Overview
Comment:Combine the homerpm.sh file in with publish.sh. Update the website files to refer to the new RPMs that are now being built. Fix a small problem with the spec file. (CVS 505)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 57d4c7704794d0a28cbf67be3f90dbf81bf3b05d
User & Date: drh 2002-03-29 18:16:04
Context
2002-03-30
14:15
Describe the difference between the binary RPMs in the download.html file. (CVS 506) check-in: 8ce9a1fa user: drh tags: trunk
2002-03-29
18:16
Combine the homerpm.sh file in with publish.sh. Update the website files to refer to the new RPMs that are now being built. Fix a small problem with the spec file. (CVS 505) check-in: 57d4c770 user: drh tags: trunk
01:29
added a section to create a spec file and build the rpm files (CVS 504) check-in: e5291439 user: doughenry tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Deleted homerpm.sh.

     1         -#!/bin/sh
     2         -
     3         -echo "%HOME %{expand:%%(cd; pwd)}" > $HOME/.rpmmacros
     4         -echo "%_topdir %{HOME}/rpm" >> $HOME/.rpmmacros
     5         -
     6         -mkdir $HOME/rpm
     7         -mkdir $HOME/rpm/BUILD
     8         -mkdir $HOME/rpm/SOURCES
     9         -mkdir $HOME/rpm/RPMS
    10         -mkdir $HOME/rpm/SRPMS
    11         -mkdir $HOME/rpm/SPECS

Changes to publish.sh.

   141    141   rm -f sqlite-$vers.tar.gz
   142    142   ln sqlite.tar.gz sqlite-$vers.tar.gz
   143    143   
   144    144   #
   145    145   # Build RPMS (binary) and Source RPM
   146    146   #
   147    147   
   148         -# this script sets up the home directory so normal users can build rpms
   149         -# by default this would only be allowed by root.  This really only needs
   150         -# done once, but each time shouldn't hurt anything.
   151         -$srcdir/homerpm.sh
          148  +# Make sure we are properly setup to build RPMs
          149  +#
          150  +echo "%HOME %{expand:%%(cd; pwd)}" > $HOME/.rpmmacros
          151  +echo "%_topdir %{HOME}/rpm" >> $HOME/.rpmmacros
          152  +mkdir $HOME/rpm
          153  +mkdir $HOME/rpm/BUILD
          154  +mkdir $HOME/rpm/SOURCES
          155  +mkdir $HOME/rpm/RPMS
          156  +mkdir $HOME/rpm/SRPMS
          157  +mkdir $HOME/rpm/SPECS
   152    158   
   153    159   # create the spec file from the template
   154    160   sed s/SQLITE_VERSION/$vers/g $srcdir/spec.template > $HOME/rpm/SPECS/sqlite.spec
   155    161   
   156    162   # copy the source tarball to the rpm directory
   157    163   cp sqlite-$vers.tar.gz $HOME/rpm/SOURCES/.
   158    164   
   159    165   # build all the rpms
   160    166   rpm -ba $HOME/rpm/SPECS/sqlite.spec >& rpm-$vers.log
   161    167   
   162         -# this part I'm not sure about, looks like the rpms may need copied here or
   163         -# linked to?
          168  +# copy the RPMs into the build directory.
          169  +ln $HOME/rpm/RPMS/i386/sqlite*-$vers*.rpm .
          170  +ln $HOME/rpm/SRPMS/sqlite-$vers*.rpm .
   164    171   
   165    172   
   166    173   # Build the website
   167    174   #
   168    175   cp $srcdir/../historical/* .
   169    176   rm -rf doc
   170    177   make doc
   171    178   ln sqlite.bin.gz sqlite.zip sqlite*.tar.gz tclsqlite.so.gz tclsqlite.zip doc
   172    179   ln sqlitedll.zip sqlite.so.gz sqlite_source.zip doc
          180  +ln *.rpm doc

Changes to spec.template.

    31     31   
    32     32   %prep
    33     33   %setup -q -n %{name}
    34     34   
    35     35   %build
    36     36   CFLAGS="%optflags -DNDEBUG=1" CXXFLAGS="%optflags -DNDEBUG=1" ./configure --prefix=%{_prefix}
    37     37   
    38         -%make
    39     38   make
    40     39   make doc
    41     40   
    42     41   %install
    43     42   install -d $RPM_BUILD_ROOT/%{_prefix}
    44     43   install -d $RPM_BUILD_ROOT/%{_prefix}/bin
    45     44   install -d $RPM_BUILD_ROOT/%{_prefix}/include

Changes to www/changes.tcl.

     4      4   puts {<html>
     5      5   <head>
     6      6     <title>SQLite Change Log</title>
     7      7   </head>
     8      8   <body bgcolor="white">
     9      9   <h1 align="center">Recent Changes To SQLite</h1>
    10     10   
    11         -<center>><font color="red"><b>
    12         -*** This page has is no longer maintained. ***
    13         -</b></font></center>
    14         -<blockquote>
    15         -The change log is now generated automatically by the CVS server
    16         -for SQLite.  To see the latest changes, visit:
    17         -<blockquote>
           11  +<p>
           12  +This file provides a high-level summary of changes to SQLite.
           13  +For more detail, refer the the checkin logs generated by
           14  +CVS at
    18     15   <a href="http://cvs.hwaci.com:2080/sqlite/timeline">
    19         -http://cvs.hwaci.com:2080/sqlite/timeline
    20         -</a>
    21         -</blockquote>
    22         -</blockquote>
           16  +http://cvs.hwaci.com:2080/sqlite/timeline</a>.
           17  +</p>
    23     18   
    24     19   <DL>
    25     20   }
    26     21   
    27     22   
    28     23   proc chng {date desc} {
    29     24     puts "<DT><B>$date</B></DT>"
    30     25     puts "<DD><P><UL>$desc</UL></P></DD>"
    31     26   }
    32     27   
    33     28   chng {2002 Mar 24 (2.4.4)} {
    34     29   <li>Added support for CASE expressions (patch from Dan Kennedy)</li>
           30  +<li>Added RPMS to the delivery (patches from Doug Henry)</li>
           31  +<li>Fix typos in the documentation</li>
           32  +<li>Cut over configuration management to a new CVS repository with
           33  +    its own CVSTrac bug tracking system.</li>
    35     34   }
    36     35   
    37     36   chng {2002 Mar 22 (2.4.3)} {
    38     37   <li>Fix a bug in SELECT that occurs when a compound SELECT is used as a
    39     38       subquery in the FROM of a SELECT.</li>
    40     39   <li>The <b>sqlite_get_table()</b> function now returns an error if you
    41     40       give it two or more SELECTs that return different numbers of columns.</li>

Changes to www/download.tcl.

     1      1   #
     2      2   # Run this TCL script to generate HTML for the download.html file.
     3      3   #
     4         -set rcsid {$Id: download.tcl,v 1.3 2002/01/31 15:54:23 drh Exp $}
            4  +set rcsid {$Id: download.tcl,v 1.4 2002/03/29 18:16:04 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head><title>SQLite Download Page</title></head>
     8      8   <body bgcolor=white>
     9      9   <h1 align=center>SQLite Download Page</h1>}
    10     10   #<p align=center>}
    11     11   #puts "This page was last modified on [lrange $rcsid 3 4] UTC<br>"
................................................................................
    16     16   
    17     17   puts {<h2>Precompiled Binaries For Linux</h2>}
    18     18   
    19     19   proc Product {file desc} {
    20     20     if {![file exists $file]} return
    21     21     set size [file size $file]
    22     22     puts [subst {
    23         -<table cellpadding="20">
           23  +<table cellpadding="15">
    24     24   <tr>
    25         -<td width="150" align="right" valign="top">
           25  +<td width="200" align="right" valign="top">
    26     26   <a href="$file">$file</a><br>($size bytes)
    27     27   </td>
    28     28   <td valign="top">[string trim $desc]</td>
    29     29   </tr>
    30     30   </table>}]
    31     31   }
    32     32   
................................................................................
    41     41     See <a href="tclsqlite.html">the documentation</a> for details.
    42     42   }
    43     43   
    44     44   Product sqlite.so.gz {
    45     45     A precompiled shared-library for Linux.  This is the same as
    46     46     <b>tclsqlite.so.gz</b> but without the TCL bindings.
    47     47   }
           48  +
           49  +foreach name [lsort -dict [glob -nocomplain sqlite-*.i386.rpm]] {
           50  +  Product $name "An RPM for Linux"
           51  +}
    48     52   
    49     53   puts {<h2>Precompiled Binaries For Windows</h2>}
    50     54   
    51     55   Product sqlite.zip {
    52     56     A command-line program for accessing and modifing SQLite databases.
    53     57     See <a href="sqlite.html">the documentation</a> for additional information.
    54     58   }
................................................................................
    67     71   Product {sqlite_source.zip} {
    68     72     This ZIP archive contains pure C source code for the SQLite library.
    69     73     Unlike the tarballs below, all of the preprocessing has already been
    70     74     done on these C source code, so you can just hand the files directly to
    71     75     your favorite C compiler.  This file is provided as a service to
    72     76     MS-Windows users who lack the build support infrastructure of Unix.
    73     77   }
           78  +
           79  +foreach name [lsort -dict [glob -nocomplain sqlite-*.src.rpm]] {
           80  +  Product $name "Source RPM"
           81  +}
    74     82   
    75     83   foreach name [lsort -dict -decreasing [glob -nocomplain sqlite-*.tar.gz]] {
    76     84     regexp {sqlite-(.*)\.tar\.gz} $name match vers
    77     85     Product $name "
    78     86         Version $vers of the source tree including all documentation.
    79     87     "
    80     88   }

Changes to www/index.tcl.

     1      1   #
     2      2   # Run this TCL script to generate HTML for the index.html file.
     3      3   #
     4         -set rcsid {$Id: index.tcl,v 1.55 2002/03/27 12:52:48 drh Exp $}
            4  +set rcsid {$Id: index.tcl,v 1.56 2002/03/29 18:16:04 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head><title>SQLite: An SQL Database Engine In A C Library</title></head>
     8      8   <body bgcolor=white>
     9      9   <h1 align=center>SQLite: An SQL Database Engine In A C Library</h1>
    10     10   <p align=center>}
    11     11   puts "This page was last modified on [lrange $rcsid 3 4] UTC<br>"
................................................................................
    57     57   <li>Sources are uncopyrighted.  Use for any purpose.</li>
    58     58   </ul>
    59     59   </p>
    60     60   }
    61     61   
    62     62   puts {<h2>Current Status</h2>
    63     63   
    64         -<p>A <a href="http://cvs.hwaci.com:2080/sqlite/timeline">change history</a>
           64  +<p>A <a href="changes.html">Change Summary</a> is available on this
           65  +website.  You can also access a detailed
           66  +<a href="http://cvs.hwaci.com:2080/sqlite/timeline">change history</a>
    65     67   and a list of
    66         -<a href="http://cvs.hwaci.com:2080/sqlite/rptview?rn=2">open bugs</a> are
    67         -both available from the 
    68         -<a href="http://cvs.hwaci.com:2080/sqlite/">CVS server</a>.
    69         -Complete source code and precompiled binaries for the latest release are
           68  +<a href="http://cvs.hwaci.com:2080/sqlite/rptview?rn=2">open bugs</a> 
           69  +from the 
           70  +<a href="http://cvs.hwaci.com:2080/sqlite/">CVS server</a>.</p>
           71  +
           72  +<p>Complete source code and precompiled binaries for the latest release are
    70     73   <a href="download.html">available for download</a> on this site.  You
    71     74   can also obtain the latest changes by anonymous CVS access:
    72     75   <blockquote><pre>
    73     76   cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite login
    74     77   cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite checkout sqlite
    75     78   </pre></blockquote>
    76     79   When prompted for a password, enter "anonymous".