DBIx::Class::Helper::ResultSet::WindowFunctions - Add support for window functions to DBIx::Class
version v0.1.0
In a resultset:
package MyApp::Schema::ResultSet::Wobbles; use base qw/DBIx::Class::ResultSet/; __PACKAGE__->load_components( qw/ Helper::ResultSet::WindowFunctions /);
Using the resultset:
my $rs = $schema->resultset('Wobbles')->search_rs( undef. '+select' => { avg => 'fingers', -over => { partition_by => 'hats', order_by => 'age', }, }, '+as' => 'avg', );
This helper adds rudimentary support for window functions to DBIx::Class resultsets.
This module is experimental.
Not all databases support window functions.
DBIx::Class
The development version is on github at https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions and may be cloned from git://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions.git
Please report any bugs or feature requests on the bugtracker website https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions/issues
When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.
Robert Rothenberg <rrwo@cpan.org>
Peter Rabbitson <ribasushi@leporine.io>
This software is Copyright (c) 2018 by Robert Rothenberg.
This is free software, licensed under:
The Artistic License 2.0 (GPL Compatible)
To install DBIx::Class::Helper::ResultSet::WindowFunctions, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class::Helper::ResultSet::WindowFunctions
CPAN shell
perl -MCPAN -e shell install DBIx::Class::Helper::ResultSet::WindowFunctions
For more information on module installation, please visit the detailed CPAN module installation guide.