Cdbi plugins

From ClassDBI

Here we will describe the various other modules available on CPAN for working with Class::DBI, if we can keep up with the mad profusion.

Contents 1 Database-Specific Extensions 2 Relationships 3 Loaders 4 Utilities and Extended Functionality

Database-Specific Extensions

• Class::DBI::DB2
• Class::DBI::MSSQL
• Class::DBI::mysql
• Class::DBI::Oracle
• Class::DBI::Pg
• Class::DBI::SQLite
• Class::DBI::Sybase

Relationships

Class::DBI provides several relationships out of the box when installed. These include HasA, HasMany, and MightHave.

It is possible to write your own relationships by subclassing Class::DBI::Relationship. You can also download additional relationships from CPAN:

• IsA - Is-A 'inheritance' relationship - on CPAN
• HasVariant - columns with varying types on CPAN
• HasManyOrdered - One-to-many or many-to-many relationship with ordering on CPAN

Loaders

• Class::DBI::AutoLoader - generate subclasses dynamically - on CPAN
• Class::DBI::Factory - a factory-model framework for CDBI applications with multiple-database and mod_perl support on CPAN or on spanner.org
• Class::DBI::Loader - dynamic definition of subclasses - on CPAN
• Class::DBI::Loader::Relationship - Easier relationship specification in Class::DBI::Loader - on CPAN

Utilities and Extended Functionality

• Class::DBI::AbstractSearch - search with SQL::Abstract - on CPAN
• Class::DBI::AsForm - HTML form elements for columns - on CPAN
• Class::DBI::BaseDSN - DSN sensitive base class - on CPAN
• Class::DBI::ConceptSearch - high-level conceptual searches
• Class::DBI::DATASchema - execute SQL in DATA sections
• Class::DBI::DDL - create and dispose of tables
• Class::DBI::DeepAbstractSearch - complex searches using joins - on CPAN
• Class::DBI::Extension - Miyagawa's extensions used to be the essential first addition to Class::DBI, but they're not needed now - on CPAN
• Class::DBI::FromCGI - Update with CGI::Untaint - on CPAN
• Class::DBI::FromForm - Update Class::DBI data using Data::FormValidator - on CPAN
• Class::DBI::Join - Schwern's old prod in the direction of proper many-to-many support is now obsolete
• Class::DBI::Mysql::FullTextSearch - Full Text Indexing - on CPAN
• Class::DBI::Pager - Pager utility - on CPAN
• Class::DBI::Plugin::AbstractCount - get COUNT(*) results with SQL::Abstract - on CPAN
• Class::DBI::Plugin::FilterOnClick - Generate searchable and browseable HTML tables (formerly CDBI::Plugin::HTML) - on CPAN
• Class::DBI::Plugin::Pager - paged queries for CDBI - on CPAN
• Class::DBI::Plugin::RetrieveAll - more complex retrieve_all() - on CPAN
• Class::DBI::Plugin::Type - Determine type information for columns
• Class::DBI::Replication - for replicated databases
• Class::DBI::SAK - Swiss Army Knife
• Class::DBI::Schema2Code - Generate modules from database schema - on CPAN
• Class::DBI::ToSax - Turn objects into SAX events - on CPAN
• Class::DBI::Untaint - Implement constraints using CGI::Untaint - on CPAN
• Class::DBI::View - virtual views - on CPAN