Dbi

Class::DBI::Plugin::FilterOnClick is a Perl module to generate browsable and searchable HTML Tables using FilterOnClick in conjunction with Class::DBI. SYNOPSIS # Inside of your sub-class of Class::DBI add these lines: use Class::DBI::Plugin::FilterOnClick; use Class::DBI::Pager; use...

Tao::DBI::st is a Perl module for DBI statements with portable support for named placeholders. SYNOPSIS use Tao::DBI qw(dbi_connect dbi_prepare); $dbh = dbi_connect($args); $sql = q{UPDATE T set a = :a, b = :b where k = :k}; $stmt = $dbh->prepare($sql); $rc = $stmt->execute({ k => $k, a...

Class::DBI::ConceptSearch is a Perl module to retrieve Class::DBI aggregates from high-level conceptual searches. SYNOPSIS my $cs = Class::DBI::ConceptSearch->new(xml => $config); #see CONFIGURATION $cs->use_wildcards(1); $cs->use_implicit_wildcards(1); $cs->use_search_ilike(1);...


Platforms: *nix

DBI::FAQ is a Perl module for the Frequently Asked Questions of the Perl5 Database Interface. What is DBI, DBperl, Oraperl and *perl? To quote Tim Bunce, the architect and author of DBI: ``DBI is a database access Application Programming Interface (API) for the Perl Language. The DBI API...


Platforms: *nix

OpenInteract2::Datasource::DBI is a Perl module that can create DBI database handles. SYNOPSIS # Define the parameters for a database handle main using PostgreSQL [datasource main] type = DBI dbi_type = Pg dsn = dbname=urkelweb username = webuser password = urkelnut # Define a handle...


Platforms: *nix

Class::DBI::DataMigration::Mapping is an abstract parent class for objects that map a single column in a single row from the source database to the target database. Synopsis use Class::DBI::DataMigration::Mapping; # ... Later, when building $mappings hashref for use by a #...


Platforms: *nix

Class::DBI::FormBuilder is a Perl module with Class::DBI/CGI::FormBuilder integration. SYNOPSIS package Film; use strict; use warnings; use base Class::DBI; use Class::DBI::FormBuilder; # for indented output: # use Class::DBI::FormBuilder PrettyPrint => ALL; # POST all forms to...


Platforms: *nix

Jifty::DBI::SchemaGenerator is a Perl module to generate table schemas from Jifty::DBI records. This module turns a Jifty::Record object into an SQL schema for your chosen database. At the moment, your choices are MySQL, SQLite, or PostgreSQL. Oracle might also work right, though its untested....


Platforms: *nix

Class::DBI::FormTools is a Perl module to build forms with multiple interconnected objects. SYNOPSIS package MyApp::Film; use base Class::DBI::FormTools; Mason example < %init > my $o = Film->retrieve(42); < /%init > < form > < input name="< % $o- >form_fieldname(title) % >"...


Platforms: *nix

Persistent::DBI is an Abstract Persistent Class implemented using a DBI Data Source. SYNOPSIS ### we are a subclass of ... ### use Persistent::DBI; @ISA = qw(Persistent::DBI); ABSTRACT This is an abstract class used by the Persistent framework of classes to implement persistence using...


Platforms: *nix

DBI::Changes Perl module contains a list of significant changes to the DBI..


Platforms: *nix

OpenPlugin::Datasource::DBI is a DBI driver, used to create DBI database handles for the OpenPlugin::Datasource plugin. SYNOPSIS # Define the parameters for a database handle main in the config file type = DBI db_owner = username = webuser password = urkelnut dsn =...


Platforms: *nix

Class::DBI::AutoIncrement is a Perl module to emulate auto-incrementing columns on Class::DBI subclasses. SYNOPSIS Lets assume you have a project making use of Class::DBI. You have implemented a subclass of Class::DBI called MyProject::DBI that opens a connection towards your projects...


Platforms: *nix

Class::DBI::Template::Stash is a Perl module with Template::Stash subclass for Class::DBI::Template. SYNOPSIS package Music::DBI; use base Class::DBI; use Class::DBI::Template; There is nothing you need to do for this module, it is setup for you when you use Class::DBI::Template. It...


Platforms: *nix

Thesaurus::DBI is a Perl module that can store and query synonyms (Thesaurus) in an SQL database. SYNOPSIS use Thesaurus::DBI; # create new database connection my $th = new Thesaurus::DBI(dbhost=> localhost, dbname=>thesaurus,dbuser=>user,dbpassword=>pass); # use existing database...


Platforms: *nix

DBI::DBD is a Perl DBI Database Driver Writers Guide. SYNOPSIS perldoc DBI::DBD Version and volatility This document is still a minimal draft which is in need of further work. The changes will occur both because the DBI specification is changing and hence the requirements on DBD drivers...


Platforms: *nix

Bundle::DBI is a bundle to install DBI and required modules. SYNOPSIS perl -MCPAN -e install Bundle::DBI CONTENTS DBI - for to get to know thyself DBI::Shell 11.91 - the DBI command line shell Storable 2.06 - for DBD::Proxy and DBI::ProxyServer Net::Daemon 0.37 - for DBD::Proxy and...


Platforms: *nix

Class::DBI::Query is a Perl module with deprecated SQL manager for Class::DBI. SYNOPSIS my $sth = Class::DBI::Query ->new({ owner => $class, sqlname => $type, essential => @columns, where_columns => @where_cols, }) ->run($val); This abstracts away many of the details of the...


Platforms: *nix

DBI is a database independent interface for Perl. SYNOPSIS use DBI; @driver_names = DBI->available_drivers; %drivers = DBI->installed_drivers; @data_sources = DBI->data_sources($driver_name, %attr); $dbh = DBI->connect($data_source, $username, $auth, %attr); $rv =...


Platforms: *nix

Oryx::DBI is a DBI Storage interface for Oryx. SYNOPSIS my $storage = Oryx::DBI->new; $storage->connect([ dbi:Pg:dbname=mydb, $usname, $passwd]); $storage->connect([ dbi:Pg:dbname=mydb, $usname, $passwd], $schema); $storage->dbh; $storage->db_name; $storage->ping; $storage->schema;...


Platforms: *nix