Relations::Display

Description

Relations::Display is a DBI/DBD::mysql Query Graphing Perl module. SYNOPSIS # DBI, Relations::Display Script that creates a # matrix, table, and graph from a query. use DBI; use Relations; use Relations::Query; use Relations::Abstract; use Relations::Display; $dsn = "DBI:mysql:watcher"; $username = "root"; $password = ; $dbh = DBI->connect($dsn,$username,$password,{PrintError => 1, RaiseError => 0}); $abstract = new Relations::Abstract($dbh); $display = new Relations::Display(-abstract => $abstract, -query => {-select => {total => "count(*)", first => "Bird", second => "Count", third => "if(gender=Male,Boy,Girl)", tao => "if(gender=Male,Yang,Yin)", sex => "gender", kind => "sp_name", id => "species.sp_id", fourth => "(species.sp_id+50)", vert => "2", horiz => "1.5"}, -from => [bird,species], -where => [species.sp_id=bird.sp_id, species.sp_id < 4], -group_by => [sp_name,gender,first,second], -order_by => [gender,sp_name]}, -x_axis => first,kind,id,fourth, -legend => second,third,tao,sex,vert,horiz, -y_axis => total, -hide => fourth,third,vert,horiz, -vertical => vert, -horizontal => horiz); $matrix = $display->get_matrix(); $table = $display->get_table(); $display->set(-chart => bars, -width => 400, -height => 400, -settings => {y_min_value => 0, y_max_value => 3, y_tick_number => 3, transparent => 0} ); $gph = $display->get_graph(); $gd = $gph->gd(); open(IMG, >test.png) or die $!; binmode IMG; print IMG $gd->png; $dbh->disconnect();.

Dbi - Query Graphing Perl - Dbd - Img - Relationsdisplay - Query - Perl - Id - Graphing - Libraries - Programming

Published By:GAF-3 Industries, Inc.

License Type:Freeware

Date Added:25 October, 2010

Version:0.92

Price:Free

Downloads:15

Size:24.6 KB

Platform: Linux

What people say
- required fields
     
Related Downloads

DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure.

DateAug 9, 2010

AuthorAndrei Nossov

Size25.6 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

dbitotcl is a Tcl extension for using Perl DBI (Database independent interface) from tcl. This project allow to use nearly all functions of Perl DBI from Tcl as new Tcl commands. The use of Perl is hidden from the Tcl-User.

DateAug 11, 2010

AuthorArtur Trzewik

Size8.2 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

Test::Differences Perl module contains test strings and data structures and show differences if not ok.

DateOct 12, 2010

AuthorBarrie Slaymaker

Size8.2 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

Cache::Static is a Perl module used for caching without freshness concerns. SYNOPSIS HTML::Mason instructions In handler.

DateAug 16, 2010

AuthorBrian Szymanski

Size60.4 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

Bundle::DBWIZ is a Perl CPAN Bundle for DBWIZ.

DateOct 15, 2010

AuthorCalvin Mah

Size2.0 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming