Sign Up
Log In
Log In
or
Sign Up
Places
All Projects
Status Monitor
Collapse sidebar
devel:languages:perl:CPAN-D
perl-DBD-AnyData
perl-DBD-AnyData.spec
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
Locations
Projects
Search
Status Monitor
Help
OpenBuildService.org
Documentation
API Documentation
Code of Conduct
Contact
Support
@OBShq
Terms
openSUSE Build Service is sponsored by
The Open Build Service is an
openSUSE project
.
Sign Up
Log In
Places
Places
All Projects
Status Monitor