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.403.002 Times

DBIx::DBStag 0.08

  Date Added: June 18, 2010  |  Visits: 678

DBIx::DBStag

Report Broken Link
Printer Friendly Version


Product Homepage
Download (77 downloads)



DBIx::DBStag is a Perl module for Relational Database to Hierarchical (Stag/XML) Mapping. SYNOPSIS use DBIx::DBStag; my $dbh = DBIx::DBStag->connect("dbi:Pg:dbname=moviedb"); my $sql = q[ SELECT studio.*, movie.*, star.* FROM studio NATURAL JOIN movie NATURAL JOIN movie_to_star NATURAL JOIN star WHERE movie.genre = sci-fi AND star.lastname = Fisher USE NESTING (set(studio(movie(star)))) ]; my $dataset = $dbh->selectall_stag($sql); my @studios = $dataset->get_studio; # returns nested data that looks like this - # # (studio # (name "20th C Fox") # (movie # (name "star wars") (genre "sci-fi") # (star # (firstname "Carrie")(lastname "Fisher"))))) # iterate through result tree - foreach my $studio (@studios) { printf "STUDIO: %sn", $studio->get_name; my @movies = $studio->get_movie; foreach my $movie (@movies) { printf " MOVIE: %s (genre:%s)n", $movie->get_name, $movie->get_genre; my @stars = $movie->get_star; foreach my $star (@stars) { printf " STARRING: %s:%sn", $star->get_firstname, $star->get_lastname; } } } # manipulate data then store it back in the database my @allstars = $dataset->get("movie/studio/star"); $_->set_fullname($_->get_firstname. .$_->get_lastname) foreach(@allstars); $dbh->storenode($dataset); exit 0; Or from the command line: unix> selectall_xml.pl -d dbi:Pg:dbname=moviebase SELECT * FROM studio NATURAL JOIN movie NATURAL JOIN movie_to_star NATURAL JOIN star USE NESTING (set(studio(movie(star)))) Or using a predefined template: unix> selectall_xml.pl -d moviebase /mdb-movie genre=sci-fi.

Requirements: No special requirements
Platforms: Linux
Keyword: Database Database To Dbix Dbixdbstag Dbstag Join Movie Natural Natural Join Perl Module Relational Database Star Studio Xml
Users rating: 0/10

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


DBIX::DBSTAG RELATED
Libraries  -  Email::Store::DBI 0.254
Email::Store::DBI is a Perl module for database backend to Email::Store. SYNOPSIS use Email::Store dbi:...; This class is a subclass of Class::DBI and contains means for Email::Store-based programs to register what DSN they wish to use. It...
28.67 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  
Database Tools  -  Firebird Relational Database 2.0 / 2.1 Beta 1
Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and...
1.4 MB  
Libraries  -  DBIx::TableHash 1.05
DBIx::TableHash is a Perl module that can tie a hash to a mysql table + SQL utils. SYNOPSIS use DBIx::TableHash; my $DBHash = DBIx::TableHash->create_or_die (my $Params = { DBIDriver => mysql, Database => mydatabase, HostName =>...
17.41 KB  
Libraries  -  DBIx::EnumConstraints 0.01
DBIx::EnumConstraints is a Perl module that generates enum-like SQL constraints. SYNOPSIS use DBIx::EnumConstraints; my $ec = DBIx::EnumConstraints->new({ name => kind, fields => [ [ k1, a, b ] , [ k2, b ] ] }); # get enum field...
10.24 KB  
Libraries  -  DBD::Oracle 1.19
DBD::Oracle is a Perl module with Oracle database driver for the DBI module. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd); $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd); # See the...
368.64 KB  
Libraries  -  DBD::MaxDB 7.6.00.27
DBD::MaxDB is a Perl module for MySQL MaxDB database driver for the DBI module version 7.6.0 BUILD 027-121-124-939. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:MaxDB:$hostname/$dbname", "$user", "$password") or die "Cant connect $DBI::err...
87.04 KB  
Libraries  -  DBIx::CGITables 0.001
DBIx::CGITables is a Perl module for easy DB access from a CGI. SYNOPSIS use DBIx::CGITables; my %parameters=(); my $query=DBIx::CGITables->new(%parameters)); $query->search_execute_and_do_everything_even_parse_the_template(); This module...
20.48 KB  
Libraries  -  DBD::Informix 2005.02
DBD::Informix is a Perl module witj IBM Informix Database Driver for Perl DBI. SYNOPSIS use DBI; You should also read the documentation for DBI perldoc DBI as this document qualifies what is stated there. Note that this document was last...
276.48 KB  
Libraries  -  Wais 2.311
Wais is a Perl module with access to freeWAIS-sf libraries. USAGE The main high-level interface are the functions Wais::Search and Wais::Retrieve. Both return a reference to an object of the class Wais::Result. Wais::Search Arguments of...
54.27 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