Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 956 Categories, Downloaded 49.593.767 Times

DBIx::SQLCrosstab 1.17

  Date Added: June 14, 2010  |  Visits: 810

DBIx::SQLCrosstab

Report Broken Link
Printer Friendly Version


Product Homepage
Download (100 downloads)



DBIx::SQLCrosstab Perl module creates a server-side cross tabulation from a database. SYNOPSIS use DBIx::SQLCrosstab; my $dbh=DBI->connect("dbi:driver:database" "user","password", {RaiseError=>1}) or die "error in connection $DBI::errstrn"; my $params = { dbh => $dbh, op => [ [SUM, salary] ], from => person INNER JOIN departments USING (dept_id), rows => [ { col => country}, ], cols => [ { id => dept, value =>department, from =>departments }, { id => gender, from => person } ] }; my $xtab = DBIx::SQLCrosstab->new($params) or die "error in creation ($DBIx::SQLCrosstab::errstr)n"; my $query = $xtab->get_query("#") or die "error in query building $DBIx::SQLCrosstab::errstrn"; # use the query or let the module do the dirty job for you my $recs = $xtab->get_recs or die "error in execution $DBIx::SQLCrosstab::errstrn"; # do something with records, or use the child class # DBIx::SQLCrosstab::Format to produce well # formatted HTML or XML output # my $xtab = DBIx::SQLCrosstab::Format->new($params) or die "error in creation ($DBIx::SQLCrosstab::errstr)n"; if ($xtab->get_query and $xtab->get_recs) { print $xtab->as_html; my $xml_data = $xtab->as_xml; } DBIx::SQLCrosstab produces a SQL query to interrogate a database and generate a cross-tabulation report. The amount of parameters needed to achieve the result is kept to a minimum. You need to indicate which columns and rows to cross and from which table(s) they should be taken. Acting on your info, DBIx::SQLCrosstab creates an appropriate query to get the desired result. Compared to spreadsheet based cross-tabulations, DBIx::SQLCrosstab has two distinct advantages, i.e. it keeps the query in the database work space, fully exploiting the engine capabilities, and does not limit the data extraction to one table..

Requirements: No special requirements
Platforms: Linux
Keyword: Creates Cross Cross Tabulation Dbix Dbixsqlcrosstab Error Libraries Module Perl Module Programming Query Sqlcrosstab Sqlcrosstab Perl Tabulation
Users rating: 0/10

License: Freeware Size: 72.7 KB
USER REVIEWS
More Reviews or Write Review


DBIX::SQLCROSSTAB RELATED
Libraries  -  DBIx::SQL::Abstract 0.07
DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) =...
4.1 KB  
Libraries  -  DBIx::Recordset::Playground 1.12
DBIx::Recordset::Playground is a Perl module with working sample usages of DBIx::Recordset. This document serves several purposes. One, it makes it easy to get started with DBIx::Recordset. Two, it serves as a place for those experienced with...
1.12 MB  
Libraries  -  DBIx::HTML::ClientDB 1.05
DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit...
11.26 KB  
Libraries  -  DBIx::Class::LibXMLdoc 0.03
DBIx::Class::LibXMLdoc is a Perl module to create an adjunct "Doc" accessor of a columns data which is automatically parsed into a LibXML documentElement (alpha-software). SYNOPSIS package My::DB::thingy; __PACKAGE__->load_components(qw/...
5.12 KB  
Libraries  -  DBIx::DBStag::Cookbook 0.08
DBIx::DBStag::Cookbook is a Perl module for building and querying databases from XML. SYNOPSIS stag-autoddl.pl stag-storenode.pl selectall_xml.pl This will give an outline of how to build a normalised relational database from XML source...
133.12 KB  
Libraries  -  Net::DBus::Error 0.33.4
Net::DBus::Error is a Perl module with error details for remote method invocation. SYNOPSIS package Music::Player::UnknownFormat; use base qw(Net::DBus::Error); # Define an error type for unknown track encoding type # for a music player...
94.21 KB  
Libraries  -  DBIx::Wrapper 0.24
DBIx::Wrapper library is a Perl module that serves as a wrapper around DBI, providing additional functionality and convenience methods. Whats New in This Release: - This release adds convenience methods for generating CSV, XML, and bencoded...
27.65 KB  
Libraries  -  DBIx::Migration::Directories 0.05
DBIx::Migration::Directories is a Perl module to install/remove/upgrade/downgrade SQL schemas. SYNOPSIS use DBIx::Migration::Directories; use DBI; my $dbh = DBI->connect(db:something:some=where, user, pass); my $m =...
28.67 KB  
Science  -  FreeNorm 2.1
FreeNorm is a cross-tabulation web application adapted from SurveyComplete's real-time reporting system. Currently it can run tabs on extremely large datasets, export to Excel, read ASCII data, and understand table definitions in the UNCLE tab...
47.54 KB  
Database Tools  -  Agata Report 7.2
Agata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as...
3.7 MB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Libraries  -  wolfSSL 4.0.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
3.88 MB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB