Dbix

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) = $dbh->select($table, @fields, %where, @order); my($query,...

DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources. The package maintains simple XML templates that describe object structure. The package is capable of generating SQL statements based on these templates and executing them against DBI data sources. After...

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/ PK::Auto LibXMLdoc Core /);...


Platforms: *nix

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 definition my $edef = $ec->enum_definition; # $edef is...


Platforms: *nix

DBIx::Class::Schema::Loader::RelBuilder is a Perl module that builds relationships for DBIx::Class::Schema::Loader. This class builds relationships for DBIx::Class::Schema::Loader. This is module is not (yet) for external use. METHODS new Arguments: schema_class (scalar), fk_info...


Platforms: *nix

DBIx::FetchLoop is a Perl module that can fetch with change detection and aggregates. SYNOPSIS use DBIx::FetchLoop; $lph = DBIx::FetchLoop->new($sth, $dbi_method); $hash_ref = $lph->fetch_current_data; $rowset = $hash_ref->{previous}; $rowset = $hash_ref->{current}; $rowset =...


Platforms: *nix

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


Platforms: *nix

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 data, set up SQL templates, issue relational queries...


Platforms: *nix

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 => localhost, Port => undef, Login => , Password => ,...


Platforms: *nix

DBIx::Class::FormTools is a utility module for building forms with multiple related DBIx::Class objects. SYNOPSIS In the examples I use 3 objects, a Film, an Actor and a Role. Role is a many to many relation between Film and Actor. package MySchema; use base DBIx::Class::Schema;...


Platforms: *nix

DBIx::SQLCrosstab::Format is a Perl module with formats results created by DBIx::SQLCrosstab. SYNOPSIS use DBIx::SQLCrosstab::Format; my $dbh=DBI->connect("dbi:driver:database" "user","password", {RaiseError=>1}) or die "error in connection $DBI::errstrn"; my $params = { dbh => $dbh,...


Platforms: *nix

DBIx::XML::DataLoader contains a set of modules that are meant to work together. DBIx::XML::DataLoader.pm the core for this package DB.pm which contains the sql specific stuff MapIt.pm handles parsing the xml mapping file IsDefined.pm a simple module for making sure empty data sets are defined...


Platforms: *nix

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 strings from query results. - The...


Platforms: *nix

DBIx::Wrapper::Config Perl module allows the use of a configuration file in XML specifying information required to connect to databases using DBIx::Wrapper. This way, your database connection specifications can be kept in one place. Each "db" element specifies a key/name for the database...


Platforms: *nix

DBIx::XHTML_Table is Perl module for SQL query result set to XML-based HTML table. SYNOPSIS use DBIx::XHTML_Table; # database credentials - fill in the blanks my ($data_source,$usr,$pass) = (); my $table = DBIx::XHTML_Table->new($data_source,$usr,$pass); $table->exec_query(" select...


Platforms: *nix

DBIx::Recordset is a Perl extension for DBI recordsets. SYNOPSIS use DBIx::Recordset; # Setup a new object and select some recods... *set = DBIx::Recordset -> Search ({!DataSource => dbi:Oracle:...., !Table => users, $where => name = ? and age > ?, $values => [richter, 25] }) ; # Get...


Platforms: *nix

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,...


Platforms: *nix

DBIx::Version is a Perl extension for getting database software name and version. SYNOPSIS use DBIx::Version; my $dbh = DBI->connect( ... ); my ($dbname, $dbver, $dbverfull) = DBIx::Version::Version($dbh); DBIx::Version lets you query which database software and version you are connected...


Platforms: *nix

DBIx::PDlib is a Perl with DBI SQL abstraction and convenience methods. SYNOPSIS use DBIx::PDlib; my $db = DBIx::PDlib->connect({ driver => mydriver, host => myhost.com, dbname => mydb, user => myuser, password => mypassword, }); my ($name) = $db->select(name,table1,"id = 10"); my...


Platforms: *nix

DBIx::Log4perl is a Perl extension for DBI to selectively log SQL, parameters, result-sets, transactions etc to a Log::Log4perl handle. SYNOPSIS use Log::Log4perl; use DBIx::Log4perl; Log::Log4perl->init("/etc/mylog.conf"); my $dbh = DBIx::Log4perl->connect(DBI:odbc:mydsn, $user, $pass);...


Platforms: *nix