Dbix

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

CGI::Explorer is a class to manage displaying a hash tree of data, for use in CGI scripts. Synopsis Install /assets/css/explorer/xtree.css, /assets/js/explorer/xtree.js, and /assets/images/explorer/*, as per the installation instructions, below. Then run the demos...

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

Email::Handle is a Objective Email Handler. SYNOPSIS use Email::Handle; my $email = Email::Handle->new(root@example.com); print $email->is_valid ? yes : no; print $email->obfuscate; print $email->anonymize; print $email; $email->send(From => foo@example.com); This module is also...


Platforms: *nix

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


Platforms: *nix

HTML::Widget::DBIC is a subclass of HTML::Widgets for dealing with DBIx::Class. SYNOPSIS # create a widget coupled with a db record my $widget = HTML::Widget::DBIC->create_from_config( $config, $resultset, $item ); # process a query my $result = $widget->process ( $query ); # and save...


Platforms: *nix

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::XMLServer is a Perl module to serve data as XML in response to HTTP requests. SYNOPSIS use XML::LibXML; use DBIx::XMLServer; my $xml_server = new DBIx::XMLServer($dbh, "template.xml"); my $doc = $xml_server->process($QUERY_STRING); die "Error: $doc" unless ref $doc; print...


Platforms: *nix

DBIx::Class::Manual::Cookbook is a Perl module that contains miscellaneous recipes. Paged results When you expect a large number of results, you can ask DBIx::Class for a paged resultset, which will fetch only a small number of records at a time: my $rs = $schema->resultset(Artist)->search(...


Platforms: *nix

Catalyst::Example::InstantCRUD is a CRUD scaffolding for Catalyst. SYNOPSIS instantcrud.pl -name=My::App -dsn=dbi:Pg:dbname=CE -user=zby -password=pass The instantcrud.pl executable creates a skeleton CRUD application in current directory. The parameters are: name of the application and...


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

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

DBIx::HTMLinterface is a class for creating a CGI interface to a database. SYNOPSIS use CGI; use DBI; use DBIx::HTMLinterface; $cgi = new CGI; $dbh = DBI->connect("DBI:mysql:[DATABASE]:[HOSTNAME]","[USERNAME]","[PASSWORD]") ); $DBinterface = new DBIx::HTMLinterface ($cgi, $dbh,...


Platforms: *nix

[COPRIGHT=1] EXAMPLES General #!/usr/bin/perl -w use strict; use DBIx::Simple; # Instant database with DBD::SQLite my $db = DBIx::Simple->connect(dbi:SQLite:dbname=file.dat) or die DBIx::Simple->error; # Connecting to a MySQL database my $db = DBIx::Simple->connect(...


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