head	1.5;
access;
symbols
	OPENPKG_E1_MP:1.2
	OPENPKG_E1_MP_HEAD:1.2;
locks; strict;
comment	@-- @;


1.5
date	2009.06.30.20.21.29;	author rse;	state Exp;
branches;
next	1.4;
commitid	mW7f5wxeUG4f4VTt;

1.4
date	2009.04.18.13.16.01;	author rse;	state Exp;
branches;
next	1.3;
commitid	4pHXU27WTIGCZuKt;

1.3
date	2008.01.01.15.05.12;	author rse;	state Exp;
branches;
next	1.2;
commitid	B8esaHJHoduuKILs;

1.2
date	2007.01.01.17.42.00;	author rse;	state Exp;
branches;
next	1.1;
commitid	BicZD6VUl7GuqP0s;

1.1
date	2006.11.15.13.58.14;	author rse;	state Exp;
branches;
next	;
commitid	EO2dQbVgWMgbLLUr;


desc
@@


1.5
log
@switch to the new SourceForge.net website functionality where we can find all files (again)
@
text
@##
##  sqlitedbms.spec -- OpenPKG RPM Package Specification
##  Copyright (c) 2000-2009 OpenPKG Foundation e.V. <http://openpkg.net/>
##
##  Permission to use, copy, modify, and distribute this software for
##  any purpose with or without fee is hereby granted, provided that
##  the above copyright notice and this permission notice appear in all
##  copies.
##
##  THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
##  WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
##  MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
##  IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR
##  CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
##  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
##  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
##  USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
##  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
##  OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
##  OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
##  SUCH DAMAGE.
##

#   FIXME: rse: rc.sqlitedbms still missing
#   FIXME: rse: the sqlitedbmsd is still a little bit buggy under run-time!?

#   package information
Name:         sqlitedbms
Summary:      SQLite Database Management System
URL:          http://sqlitedbms.sourceforge.net/
Vendor:       Kibae Shin
Packager:     OpenPKG Foundation e.V.
Distribution: OpenPKG Community
Class:        EVAL
Group:        Database
License:      MIT-style
Version:      0.5.1
Release:      20080101

#   list of sources
Source0:      http://switch.dl.sourceforge.net/sqlitedbms/sqlitedbms-%{version}.tar.gz
Source1:      sqlitedbms.conf
Patch0:       sqlitedbms.patch

#   build information
Prefix:       %{l_prefix}
BuildRoot:    %{l_buildroot}
BuildPreReq:  OpenPKG, openpkg >= 20040130, gcc
PreReq:       OpenPKG, openpkg >= 20040130
BuildPreReq:  sqlite >= 3.3, pcre, openssl
PreReq:       sqlite >= 3.3, pcre, openssl
AutoReq:      no
AutoReqProv:  no

%description
    SQLiteDBMS is a client/server Relational Database Management System
    (RDBMS) based on the SQLite SQL and storage engine.

%track
    prog sqlitedbms = {
        version   = %{version}
        url       = http://sourceforge.net/projects/sqlitedbms/files/
        regex     = sqlitedbms-(__VER__)\.tar\.gz
    }

%prep
    %setup -q
    %patch -p0

%build
    #   configure program
    %{l_shtool} subst \
        -e 's;conf/sqlitedbms.conf;%{l_prefix}/etc/sqlitedbms/sqlitedbms.conf;' \
        src/backend/include/define.h
    CC="%{l_cc}" \
    CFLAGS="%{l_cflags -O}" \
    CPPFLAGS="%{l_cppflags}" \
    LDFLAGS="%{l_ldflags}" \
    LIBS="-lpcreposix -lpcre" \
    ./configure \
        --prefix=%{l_prefix} \
        --with-sqlite3=%{l_prefix} \
        --with-openssl=%{l_prefix} \
        --disable-shared

    #   build program
    %{l_make} %{l_mflags -O}

%install
    #   install program
    rm -rf $RPM_BUILD_ROOT
    %{l_make} %{l_mflags} install \
        prefix=$RPM_BUILD_ROOT%{l_prefix} \
        exec_prefix=$RPM_BUILD_ROOT%{l_prefix}

    #   adjust installation
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/share
    mv  $RPM_BUILD_ROOT%{l_prefix}/htdocs \
        $RPM_BUILD_ROOT%{l_prefix}/share/sqlitedbms

    #   strip down installation
    strip $RPM_BUILD_ROOT%{l_prefix}/bin/* >/dev/null 2>&1 || true
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/conf
    rm -rf $RPM_BUILD_ROOT%{l_prefix}/data

    #   install default configuration
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/etc/sqlitedbms
    %{l_shtool} install -c -m 644 %{l_value -s -a} \
        %{SOURCE sqlitedbms.conf} \
        $RPM_BUILD_ROOT%{l_prefix}/etc/sqlitedbms/

    #   create run-time directories
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/var/sqlitedbms/db \
        $RPM_BUILD_ROOT%{l_prefix}/var/sqlitedbms/rep \
        $RPM_BUILD_ROOT%{l_prefix}/var/sqlitedbms/log

    #   determine installation files
    %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
        %{l_files_std} \
        '%config %{l_prefix}/etc/sqlitedbms/*' \
        '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/sqlitedbms/*'

%files -f files

%clean
    rm -rf $RPM_BUILD_ROOT

%post
    if [ $1 -eq 1 ]; then
        #   create initial database in batch
        if [ ! -f $RPM_INSTALL_PREFIX/var/sqlitedbms/db/catalog.user.superdb ]; then
            ( echo "CREATE TABLE USER (id text PRIMARY KEY, pass text, super int);"
              echo "CREATE TABLE GRANT_DB (id text, db text, grant text, PRIMARY KEY(id, db));"
              echo "CREATE TABLE GRANT_OBJECT (id text, db text, object text, grant text, PRIMARY KEY(id, db, object));"
              echo "INSERT INTO USER VALUES('admin', 'admin', 1);"
            ) | su - %{l_rusr} -c \
                $RPM_INSTALL_PREFIX/bin/sqlite3 \
                $RPM_INSTALL_PREFIX/var/sqlitedbms/db/catalog.user.superdb
        fi
    fi
    if [ $1 -eq 2 ]; then
        #   after upgrade, restart service
        eval `%{l_rc} sqlitedbms status 2>/dev/null`
        [ ".$sqlitedbms_active" = .yes ] && %{l_rc} sqlitedbms restart
    fi
    exit 0

%preun
    if [ $1 -eq 0 ]; then
        #   before erase, stop service and remove log files
        %{l_rc} sqlitedbms stop 2>/dev/null
        rm -f $RPM_INSTALL_PREFIX/var/sqlitedbms/rep/* >/dev/null 2>&1 || true
        rm -f $RPM_INSTALL_PREFIX/var/sqlitedbms/log/* >/dev/null 2>&1 || true
    fi
    exit 0

@


1.4
log
@bump years in copyright messages
@
text
@d62 1
a62 1
        url       = http://prdownloads.sourceforge.net/sqlitedbms/
@


1.3
log
@Update package specifications according to OpenPKG year 2008 world order:
http://www.mail-archive.com/openpkg-announce@@openpkg.org/msg00221.html
@
text
@d3 1
a3 1
##  Copyright (c) 2000-2008 OpenPKG Foundation e.V. <http://openpkg.net/>
@


1.2
log
@Welcome Year 2007!
@
text
@d3 1
a3 2
##  Copyright (c) 2000-2007 OpenPKG Foundation e.V. <http://openpkg.net/>
##  Copyright (c) 2000-2007 Ralf S. Engelschall <http://engelschall.com/>
d38 1
a38 1
Release:      20061115
@


1.1
log
@new package: sqlitedbms 0.5.1 (SQLite Database Management System)
@
text
@d3 2
a4 2
##  Copyright (c) 2000-2006 OpenPKG Foundation e.V. <http://openpkg.net/>
##  Copyright (c) 2000-2006 Ralf S. Engelschall <http://engelschall.com/>
@