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 32.283.892 Times

Relations::Family 0.94

  Date Added: May 09, 2010  |  Visits: 882

Relations::Family

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
RELATIONS::FAMILY RELATED
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 http://www.hwaci.com/sw/sqlite/....
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  
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 3.15.3
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