perl-DBIx-PivotQuery-0.01-alt1.noarch.rpm


Advertisement

Description

perl-DBIx-PivotQuery - create pivot tables from queries

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package name perl-DBIx-PivotQuery
Package version 0.01
Package release alt1
Package architecture noarch
Package type rpm
Installed size 20.09 KB
Download size 20.09 KB
Official Mirror ftp.altlinux.org
use DBIx::PivotQuery 'pivot_by';
my $rows = pivot_by(
dbh       => $dbh,
columns   => ['month'],
rows      => ['region'],
aggregate => ['sum(amount) as amount'],
sql => <<'SQL');
select
month(date) as report_month
, region
, amount
from mytable
SQL
The above code returns a data structure roughly like

Alternatives

Package Version Architecture Repository
perl-DBIx-PivotQuery - - -

Requires

Name Value
/usr/share/perl5 -
perl(Filter/signatures.pm) -
perl(feature.pm) -
rpmlib(PayloadIsLzma) -

Provides

Name Value
perl(DBIx/PivotQuery.pm) = 0.010
perl-DBIx-PivotQuery = 0.01-alt1

Download

Type URL
Binary Package perl-DBIx-PivotQuery-0.01-alt1.noarch.rpm
Source Package perl-DBIx-PivotQuery-0.01-alt1.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-DBIx-PivotQuery rpm package:
    # sudo apt-get install perl-DBIx-PivotQuery

Files

Path
/usr/share/doc/perl-DBIx-PivotQuery-0.01/Changes
/usr/share/doc/perl-DBIx-PivotQuery-0.01/README
/usr/share/doc/perl-DBIx-PivotQuery-0.01/README.mkdn
/usr/share/perl5/DBIx/PivotQuery.pm

See Also

Package Description
perl-DBIx-Placeholder-Named-0.08-alt1.noarch.rpm perl module DBIx-Placeholder-Named
perl-DBIx-Poggy-0.08-alt1.noarch.rpm async Pg with AnyEvent and Promises
perl-DBIx-PreQL-0.01.00-alt1.noarch.rpm Less terrible dynamic SQL
perl-DBIx-Printf-0.08-alt1.noarch.rpm A printf-style prepared statement
perl-DBIx-Printf-Named-0.01-alt1.noarch.rpm A named-printf-style prepared statement
perl-DBIx-ProcedureCall-0.11-alt1.noarch.rpm perl module DBIx-ProcedureCall
perl-DBIx-Profile-1.0-alt1.noarch.rpm perl module DBIx-Profile
perl-DBIx-ProfileManager-0.03-alt1.noarch.rpm Helps to fine control your DBI profiling without hassles
perl-DBIx-Query-1.06-alt1.noarch.rpm perl module DBIx-Query
perl-DBIx-QueryByName-0.18-alt1.noarch.rpm Execute SQL queries by name
perl-DBIx-QueryLog-0.41-alt1.noarch.rpm Logging queries for DBI
perl-DBIx-QuickDB-0.000007-alt1.noarch.rpm Quickly start a db server
perl-DBIx-Raw-0.12-alt1.noarch.rpm Maintain control of SQL queries while still having a layer of abstraction above DBI
perl-DBIx-Recordset-0.26-alt2_5.noarch.rpm Perl extension for DBI recordsets
perl-DBIx-Recordset-Playground-1.9-alt1.noarch.rpm working sample usages of DBIx::Recordset
Advertisement
Advertisement