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

Overview Repositories Revisions Requests Users Attributes Meta

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

#
# spec file for package perl-DBD-AnyData
#
# Copyright (c) 2019 SUSE LINUX 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 https://bugs.opensuse.org/
#

Name:           perl-DBD-AnyData
Version:        0.110
Release:        0
%define cpan_name DBD-AnyData
Summary:        DBI access to XML, CSV and other formats
License:        Artistic-1.0 OR GPL-1.0-or-later
Group:          Development/Libraries/Perl
Url:            https://metacpan.org/release/%{cpan_name}
Source0:        https://cpan.metacpan.org/authors/id/R/RE/REHSACK/%{cpan_name}-%{version}.tar.gz
BuildArch:      noarch
BuildRoot:      %{_tmppath}/%{name}-%{version}-build
BuildRequires:  perl
BuildRequires:  perl-macros
BuildRequires:  perl(AnyData) >= 0.07
BuildRequires:  perl(DBI) >= 1.611_93
BuildRequires:  perl(Module::Build) >= 0.360000
BuildRequires:  perl(Params::Util) >= 1.00
BuildRequires:  perl(SQL::Statement) >= 1.27_02
BuildRequires:  perl(Test::More) >= 0.9
Requires:       perl(AnyData) >= 0.07
Requires:       perl(DBI) >= 1.611_93
Requires:       perl(Params::Util) >= 1.00
Requires:       perl(SQL::Statement) >= 1.27_02
Recommends:     perl(AnyData) >= 0.10
Recommends:     perl(DBI) >= 1.612
Recommends:     perl(Params::Util) >= 1.01
Recommends:     perl(SQL::Statement) >= 1.28
%{perl_requires}

%description
The DBD::AnyData module provides a DBI/SQL interface to data in many
formats and from many sources.

Currently supported formats include general format flatfiles (CSV, Fixed
Length, Tab or Pipe "delimited", etc.), specific formats (passwd files, web
logs, etc.), a variety of other kinds of formats (XML, Mp3, HTML tables),
and, for some operations, any DBI accessible database. The number of
supported formats will continue to grow rapidly since there is an open API
making it easy for any author to create additional format parsers which can
be plugged in to AnyData.

Data in these various formats can come from local files, from remote files,
or from perl data structures such as strings and arrays.

Regardless of the format or source of the data, it may be accessed and/or
modified using all standard DBI methods and a subset of SQL syntax.

In addition to standard database access to files, the module also supports
in-memory tables which allow you to create temporary views; to combine data
from a number of sources; to quickly prototype database systems; and to
display or save the data in any of the supported formats (e.g. to display
data in a CSV file as an HTML table). These in-memory tables can be created
from any combination of DBI databases or files of any format. They may also
be created from perl data structures which means it's possible to quickly
prototype a database system without any file access or rdbms backend.

The module also supports converting files between any of the supported
formats (e.g. save selected data from MySQL or Oracle to an XML file).

Here a just a few examples of the capabilities:

# SELECT DATA FROM A PASSWD FILE
    #
    $dbh->func( 'users', 'Passwd', '/etc/passwd', 'ad_catalog');
    my $sth = $dbh->prepare("SELECT username,homedir,GID FROM users');

# INSERT A NEW ROW INTO A CSV FILE
    #
    $dbh->func( 'cars', 'CSV', 'cars.csv', 'ad_catalog');
    $dbh->do("INSERT INTO cars VALUES ('Honda','Odyssey')");

# READ A REMOTE XML FILE AND PRINT IT AS AN HTML TABLE
    #
    print $dbh->func( 'XML', $url, 'HTMLtable', 'ad_convert');

# CONVERT A MYSQL DATABASE INTO XML AND SAVE IT IN A NEW FILE
    #
    $dbh->func( 'DBI', $mysql_dbh, 'XML', 'data.xml', 'ad_convert');

# CREATE AND ACCESS A VIEW CONTAINING DATA FROM AN ORACLE DATABASE
    # AND A TAB DELIMITED FILE
    #
    $dbh->func( 'combo', 'DBI', $oracle_dbh, 'ad_import');
    $dbh->func( 'combo', 'Tab', 'data.tab', 'ad_import');
    my $sth = $dbh->prepare("SELECT * FROM combo");

%prep
%setup -q -n %{cpan_name}-%{version}
find . -type f ! -name \*.pl -print0 | xargs -0 chmod 644

%build
perl Build.PL installdirs=vendor
./Build build flags=%{?_smp_mflags}

%check
./Build test

%install
./Build install destdir=%{buildroot} create_packlist=0
%perl_gen_filelist

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

%changelog

Places

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

Places