File perl-DBD-CSV.spec of Package perl-DBD-CSV

Overview Repositories Revisions Requests Users Attributes Meta

File perl-DBD-CSV.spec of Package perl-DBD-CSV (Revision f5f5efbc005d60734e6d4d450a12b933)

Currently displaying revision f5f5efbc005d60734e6d4d450a12b933 , Show latest

#
# spec file for package perl-DBD-CSV (Version 0.31)
#
# Copyright (c) 2010 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.

# Please submit bugfixes or comments via http://bugs.opensuse.org/
#

Name:           perl-DBD-CSV
Version:        0.31
Release:        1
License:        GPL+ or Artistic
%define cpan_name DBD-CSV
Summary:        DBI driver for CSV files
Url:            http://search.cpan.org/dist/DBD-CSV/
Group:          Development/Libraries/Perl
#Source:         http://www.cpan.org/authors/id/H/HM/HMBRAND/DBD-CSV-%{version}.tgz
Source:         %{cpan_name}-%{version}.tar.gz
BuildArch:      noarch
BuildRoot:      %{_tmppath}/%{name}-%{version}-build
BuildRequires:  perl
BuildRequires:  perl-macros
BuildRequires:  perl(Config)
BuildRequires:  perl(Cwd)
BuildRequires:  perl(DBD::File) >= 0.38
BuildRequires:  perl(DBI) >= 1.613
BuildRequires:  perl(SQL::Statement) >= 1.3
BuildRequires:  perl(Text::CSV_XS) >= 0.71
Requires:       perl(DBD::File) >= 0.40
Requires:       perl(DBI) >= 1.614
Requires:       perl(SQL::Statement) >= 1.31
Requires:       perl(Text::CSV_XS) >= 0.71
%{perl_requires}

%description
The DBD::CSV module is yet another driver for the DBI (Database independent
interface for Perl). This one is based on the SQL "engine" SQL::Statement
and the abstract DBI driver DBD::File and implements access to so-called
CSV files (Comma Separated Values). Such files are often used for exporting
MS Access and MS Excel data.

See the DBI manpage for details on DBI, the SQL::Statement manpage for
details on SQL::Statement and the DBD::File manpage for details on the base
class DBD::File.

Prerequisites
    The only system dependent feature that DBD::File uses, is the 'flock
    ()' function. Thus the module should run (in theory) on any system with
    a working 'flock ()', in particular on all Unix machines and on Windows
    NT. Under Windows 95 and MacOS the use of 'flock ()' is disabled, thus
    the module should still be usable.

Unlike other DBI drivers, you don't need an external SQL engine or a
    running server. All you need are the following Perl modules, available
    from any CPAN mirror, for example

http://search.cpan.org/

* DBI

The DBI (Database independent interface for Perl), version 1.00 or a
      later release

* DBD::File

This is the base class for DBD::CSV, and it is part of the DBI
      distribution. As DBD::CSV requires version 0.38 or newer for
      DBD::File it effectively requires DBI version 1.611 or newer.

* SQL::Statement

A simple SQL engine. This module defines all of the SQL syntax for
      DBD::CSV, new SQL support is added with each release so you should
      look for updates to SQL::Statement regularly.

It is possible to run 'DBD::CSV' without this module if you define
      the environment variable '$DBI_SQL_NANO' to 1. This will reduce the
      SQL support a lot though. See the DBI::SQL::Nano manpage for more
      details. Note that the test suite does not test in this mode!

* Text::CSV_XS

This module is used for writing rows to or reading rows from CSV
      files.

Installation
    Installing this module (and the prerequisites from above) is quite
    simple. The simplest way is to install the bundle:

$ cpan Bundle::CSV

Alternatively, you can name them all

$ cpan Text::CSV_XS DBI DBD::CSV

or even trust 'cpan' to resolve all dependencies for you:

$ cpan DBD::CSV

If you cannot, for whatever reason, use cpan, fetch all modules from
    CPAN, and build with a sequence like:

gzip -d < DBD-CSV-0.28.tgz | tar xf -

(this is for Unix users, Windows users would prefer WinZip or something
    similar) and then enter the following:

cd DBD-CSV-0.28
        perl Makefile.PL
        make test

If any tests fail, let us know. Otherwise go on with

make install UNINST=1

Note that you almost definitely need root or administrator permissions.
    If you don't have them, read the ExtUtils::MakeMaker man page for
    details on installing in your own directories. the ExtUtils::MakeMaker
    manpage.

Supported SQL Syntax
    All SQL processing for DBD::CSV is done by the the SQL::Statement
    manpage module. Features include joins, aliases, built-in and
    user-defined functions, and more. See the SQL::Statement::Syntax
    manpage for a description of the SQL syntax supported in DBD::CSV.

Table names are case insensitive unless quoted.

%prep
%setup -q -n %{cpan_name}-%{version}

%build
%{__perl} Makefile.PL INSTALLDIRS=vendor
%{__make} %{?_smp_mflags}

%check
%{__make} test

%install
%perl_make_install
%perl_process_packlist
%perl_gen_filelist

%clean
%{__rm} -rf %{buildroot}

%files -f %{name}.files
%defattr(644,root,root,755)
%doc ChangeLog README

%changelog

Places

File perl-DBD-CSV.spec of Package perl-DBD-CSV (Revision f5f5efbc005d60734e6d4d450a12b933)

Places