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

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

Serving Software Downloads in 976 Categories, Downloaded 31.570.242 Times

Relations::Family 0.94

  Date Added: May 09, 2010  |  Visits: 860


Report Broken Link
Printer Friendly Version

Product Homepage
Download (72 downloads)

Relations::Family is a DBI/DBD::mysql Relational Query Engine module. SYNOPSIS # DBI, Relations::Family Script that creates some queries. #!/usr/bin/perl use DBI; use Relations::Family; $dsn = "DBI:mysql:finder"; $username = "root"; $password = ; $dbh = DBI->connect($dsn,$username,$password,{PrintError => 1, RaiseError => 0}); $abstract = new Relations::Abstract($dbh); $family = new Relations::Family($abstract); $family->add_member(-name => account, -label => Cust. Account, -database => finder, -table => account, -id_field => acc_id, -query => {-select => {id => acc_id, label => "concat(cust_name, - ,balance)"}, -from => [account,customer], -where => "customer.cust_id=account.cust_id", -order_by => "cust_name"}); $family->add_member(-name => customer, -label => Customer, -database => finder, -table => customer, -id_field => cust_id, -query => {-select => {id => cust_id, label => cust_name}, -from => customer, -order_by => "cust_name"}); $family->add_member(-name => purchase, -label => Purchase, -database => finder, -table => purchase, -id_field => pur_id, -query => {-select => {id => pur_id, label => "concat( cust_name, - , date_format(date, %M %D, %Y) )"}, -from => [purchase, customer], -where => customer.cust_id=purchase.cust_id, -order_by => [date desc, cust_name]}); $family->add_lineage(-parent_name => customer, -parent_field => cust_id, -child_name => purchase, -child_field => cust_id); $family->add_rivalry(-brother_name => customer, -brother_field => cust_id, -sister_name => account, -sister_field => cust_id); $family->set_chosen(-label => Customer, -ids => 2,4); $available = $family->get_available(-label => Purchase); print "Found $available->{count} Purchases:n"; foreach $id (@{$available->{ids_array}}) { print "Id: $id Label: $available->{labels_hash}->{$id}n"; } $family->add_value(-name => Cust. Account, -sql => "concat(cust_name, - ,balance)", -member_names => customer,account); $family->add_value(-name => Paid, -sql => "if(balance > 0,NO,YES)", -member_names => account); $family->add_value(-name => Customer, -sql => cust_name, -member_names => customer); $family->add_value(-name => Purchase, -sql => "concat( cust_name, - , date_format(date, %M %D, %Y) )", -member_names => purchase,customer); $reunion = $family->get_reunion(-data => Paid,Purchase, -use_labels => Customer, -order_by => Customer,Purchase); $matrix = $abstract->select_matrix(-query => $reunion); print "Found " . scalar @$matrix . " Values:n"; foreach $row (@$matrix) { print "Customer: $row->{Customer}n"; print "Purchase: $row->{Purchase}n"; print "Paid: $row->{Paid}nn"; } $dbh->disconnect();.

Requirements: No special requirements
Platforms: Linux
Keyword: Cust Date Dbd Dbi Field Id Libraries Name Print Programming Relational Query Relational Query Engine Relationsfamily
Users rating: 0/10

License: Freeware Size: 50.18 KB
Libraries  -  DBD::mysql 4.004
DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI). SYNOPSIS use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port"; $dbh = DBI->connect($dsn, $user, $password); $drh =...
112.64 KB  
Libraries  -  DBD::mSQL 1.2219
DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI). SYNOPSIS use DBI; $driver = "mSQL"; # or "mSQL1"; $dsn = "DBI:$driver:database=$database;host=$hostname"; $dbh =...
194.56 KB  
Libraries  -  DBD::SQLite 1.12
DBD::SQLite is a Self Contained RDBMS in a DBI Driver. SYNOPSIS use DBI; my $dbh = DBI->connect("dbi:SQLite:dbname=dbfile","",""); SQLite is a public domain RDBMS database engine that you can find at
542.72 KB  
Modules  -  Validateage 5.x-1.x-dev 1.0
The minimum age and the name of the custom date of birth field are configurable on the admin page.InstallationUnpack in your modules folder (usually /sites/all/modules/) and enable under Administer > Site Building > Modules. Requirements: -...
Libraries  -  Relations::Query 0.93
Relations::Query is a Perl Object for building queries with DBI/DBD::mysql. SYNOPSIS # Relations::Query Script that creates some queries. use Relations::Query; $query = new Relations::Query(-select => {fife => barney}, -from =>...
10.24 KB  
Libraries  -  Date::Roman 1.06
Date::Roman is a Perl OO extension for handling roman style dates. SYNOPSIS use Date::Roman; $caesar_death = Date::Roman->new(roman => id 3 702); print $caesar_death->ical(),"n"; #prints -520315 This module defines a class for handling...
38.91 KB  
Utilities  -  AttributeMagic Free! 2.4
AttributeMagic Free! - freeware utility to view and modify file-folder date/time and attributes: creation date, last access date, modify date and attributes. Utility can change name and extension of files and folders. Unicode file names supported....
755.79 KB  
Utilities  -  BIOSAgent 3.66
The BIOS Agent will automatically identify your computers BIOS information. You'll quickly identify the BIOS Date, BIOS Type, BIOS ID String, Motherboard OEM data, Motherboard Chipset and Super I/O data. This information is very helpful in the...
336.76 KB  
Finance  -  Central Willamette Mobile 200.1.1029
Features: - Accounts: Quickly view balances and the most recent 100 transactions for any account or loan. - Pending Debits: New! See pending Debit card transactions. View the date and dollar amount held (business name coming...
5.4 MB  
Document Management Tools  -  Super Task Log 1.1
Super Task Log allows you to manage all of your tasks, define parent projects and save out XML data.Includes search and sort by different parameters such as start date, due date, open/closed, project ID, client name, or project name.
146 KB  
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by, it is used to describe information about an application such as the name and...
327.68 KB  
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  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  wolfSSL 3.13.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