Dbi

Test::Differences Perl module contains test strings and data structures and show differences if not ok. SYNOPSIS use Test; ## Or use Test::More use Test::Differences; eq_or_diff $got, "anbncn", "testing strings"; eq_or_diff @got, [qw( a b c )], "testing arrays"; ## Passing options:...

Cache::Static is a Perl module used for caching without freshness concerns. SYNOPSIS HTML::Mason instructions In handler.pl: use Cache::Static; In any component you where you have a well defined set of dependencies which change the output: < %init > my $_cs_deps = [ #file dependencies...

Bundle::DBWIZ is a Perl CPAN Bundle for DBWIZ. SYNOPSIS C< perl -MCPAN -e install Bundle::DBWIZ > CONTENTS Class::DBI Class::DBI::mysql Module::Build Exception::Class Exception::Class::DBI SQL::Abstract MIME::Tools SOAP::Lite Parallel::ForkManager Data::Serializer Time::HiRes...


Platforms: *nix

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


Platforms: *nix

Database Independent Abstraction Layer for C (libdbi) implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using...


Platforms: *nix

DBD::ODBC Perl module contains a ODBC Driver for DBI. SYNOPSIS use DBI; $dbh = DBI->connect(dbi:ODBC:DSN, user, password); Private DBD::ODBC Attributes odbc_more_results (applies to statement handle only!) Use this attribute to determine if there are more result sets available. SQL...


Platforms: *nix

PHP Database Interface is an easy to use PHP database interface meant to give applications universal support across many databases, including several flat file formats. Installation These are just a few notes installation notes regarding DBi and using it with your project txtSQL support...


Platforms: *nix

HTTPD::GroupAdmin is a Perl module for the management of HTTP server group databases. SYNOPSIS use HTTPD::GroupAdmin (); This software is meant to provide a generic interface that hides the inconsistencies across HTTP server implementations of user and group databases. METHODS new ()...


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

Apache2::AuthCookieDBI is an AuthCookie module backed by a DBI database. SYNOPSIS # In httpd.conf or .htaccess PerlModule Apache2::AuthCookieDBI PerlSetVar WhatEverPath / PerlSetVar WhatEverLoginScript /login.pl # Optional, to share tickets between servers. PerlSetVar WhatEverDomain...


Platforms: *nix

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


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

Test::MockDBI is Perl module mock DBI interface for testing. SYNOPSIS use Test::MockDBI; OR use Test::MockDBI qw( :all ); Test::MockDBI::set_dbi_test_type(42); if (Test::MockDBI::get_dbi_test_type() == 42) { ... $mock_dbi = get_instance Test::MockDBI; $mock_dbi->bad_method(...


Platforms: *nix

AxKit::XSP::ESQL is an Extended SQL taglib for AxKit eXtensible Server Pages. SYNOPSIS Add the esql: namespace to your XSP < xsp:page > tag: < xsp:page language="Perl" xmlns:xsp="http://apache.org/xsp/core/v1" xmlns:esql="http://apache.org/xsp/SQL/v2" > And add this taglib to AxKit...


Platforms: *nix

DBIx::XML_RDB is a Perl extension for creating XML from existing DBI datasources. SYNOPSIS use DBIx::XML_RDB; my $xmlout = DBIx::XML_RDB->new($datasource, "ODBC", $userid, $password, $dbname) || die "Failed to make new xmlout"; $xmlout->DoSql("select * from MyTable"); print...


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

Oraperl is a Perl access to Oracle databases for old oraperl scripts. SYNOPSIS eval use Oraperl; 1; || die $@ if $] >= 5; # ADD THIS LINE TO OLD SCRIPTS $lda = ⊦a_login($system_id, $name, $password) $csr = ⊦a_open($lda, $stmt [, $cache]) ⊦a_bind($csr, $var, ...) ⊦a_fetch($csr [,...


Platforms: *nix

DBIx::Timeout is a Perl module that provides a safe method of timing out DBI requests. The method described in the DBI documentation uses unsafe signals, which may cause memory corruption. DBIx::Timeout instead uses a separate timeout process. The problem with using POSIX sigaction() is that...


Platforms: *nix

SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...


Platforms: *nix

DBIx::DWIW is a Perl module for robust and simple DBI wrapper to Do What I Want (DWIW). SYNOPSIS When used directly: use DBIx::DWIW; my $db = DBIx::DWIW->Connect(DB => $database, User => $user, Pass => $password, Host => $host); my @records = $db->Array("select * from foo"); When...


Platforms: *nix