No - with (pure) Perl, you will have to calculate such stuff yourself.
What you can do is map your Array of Hashes to a DBD::SQLite table, backed by your Perl data structure and then just use SQL to query your Perl data structures:
use DBI;
use DBD::SQLite;
# ...
sub import_data( $self, $book ) {
my $dbh = DBI->connect('dbi:SQLite:dbname=:memory:',undef,undef,{A
+utoCommit => 1, RaiseError => 1,PrintError => 0});
$dbh->sqlite_create_module(perl => "DBD::SQLite::VirtualTable::Per
+lData");
my $sql_name = "mytable";
my $colnames = join ", ", qw(PvcCount LCir RCir);
local $table_000 = \@data;
my $tablevar = __PACKAGE__ . '::table_000';
my $sql = qq(CREATE VIRTUAL TABLE temp."$sql_name" USING perl($col
+names, arrayrefs="$tablevar"););
$dbh->do($sql);
my $sum = $dbh->selectall_arrayref(<<'SQL');
select
sum( PvcCount )
, sum(LCir)
, sum(RCir)
, EquipName
from mytable
group by EquipName
SQL
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|