File perl-DBIx-Query.spec of Package perl-DBIx-Query

Overview Repositories Revisions Requests Users Attributes Meta

File perl-DBIx-Query.spec of Package perl-DBIx-Query (Revision 98b5cb0e8d3220439ac0d4bf1355db16)

Currently displaying revision 98b5cb0e8d3220439ac0d4bf1355db16 , Show latest

#
# spec file for package perl-DBIx-Query
#
# Copyright (c) 2015 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-DBIx-Query
Version:        1.04
Release:        0
%define cpan_name DBIx-Query
Summary:        Simplified abstracted chained DBI subclass
License:        GPL-1.0+ or Artistic-1.0
Group:          Development/Libraries/Perl
Url:            http://search.cpan.org/dist/DBIx-Query/
#Source:        http://www.cpan.org/authors/id/G/GR/GRYPHON/%{cpan_name}-1.06.tar.gz
Source:         DBIx-Query-1.04.tar.gz
BuildArch:      noarch
BuildRoot:      %{_tmppath}/%{name}-%{version}-build
BuildRequires:  perl
BuildRequires:  perl-macros
BuildRequires:  perl(Clone)
BuildRequires:  perl(DBD::SQLite)
BuildRequires:  perl(DBI)
BuildRequires:  perl(SQL::Abstract::Complete) >= 1.03
BuildRequires:  perl(SQL::Parser)
BuildRequires:  perl(Test::Most)
#BuildRequires: perl(parent)
Requires:       perl(Clone)
Requires:       perl(DBD::SQLite)
Requires:       perl(DBI)
Requires:       perl(SQL::Abstract::Complete) >= 1.03
Requires:       perl(SQL::Parser)
Requires:       perl(Test::Most)
%{perl_requires}

%description
This module provides a simplified abstracted chained DBI subclass. It's
sort of like jQuery for the DBI manpage, or sort of like DBIx::Class only
without objects, or sort of like cookies without a glass of milk. With
DBIx::Query, you can construct queries either with SQL or abstract Perl
data structures described by the SQL::Abstract::Complete manpage.

my $stuff  = $dq->sql('SELECT stuff FROM things WHERE value = ?')->run(42)->all();
    my $things = $dq->get( 'things', ['stuff'], { 'value' = 42 } )->run()->all();

The overall point being that you can chain various parts of the query
prepare, execute, and data retrieval process to dramatically reduce
repeated code in most programs.

my $c_value    = $dq->sql('SELECT a FROM b WHERE c = ?')->run($c)->value();
    my $everything = $dq->get('things')->run()->all({});

DBIx::Query is a pure subclass of DBI, so it can be used exactly like DBI.
At any point, you can drop out of DBIx::Query-specific methods and use DBI
methods.

my $sth = $dq->get('things');
    $sth->execute();
    my $stuff = $sth->fetchall_arrayref();

Like the DBI manpage, there are multiple sub-classes each with a set of
methods related to its level. In the DBI manpage, there is: DBI (the parent
class), db (the object created from a connect call), and st (the statement
handle). DBIx::Query adds the following additional: rowset, row, and cell.

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

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

%check
%{__make} test

%install
%perl_make_install
%perl_process_packlist
%perl_gen_filelist

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

%changelog

Places

File perl-DBIx-Query.spec of Package perl-DBIx-Query (Revision 98b5cb0e8d3220439ac0d4bf1355db16)

Places