NAME
   DBIx::DBO2::ReadMe - Getting Started with DBIx::DBO2

SYNOPSIS
     package MyRecord;
     use DBIx::DBO2::Record '-isasubclass';
     my $sql_engine = DBIx::SQLEngine->new( $dsn, $user, $pass );

     MyRecord->table(
       DBIx::DBO2::Table->new(name=>'myrecords', datasource=>$sql_engine)
     );

     package main;
     my $results = MyRecord->fetch_all;
     foreach my $record ( $results->records ) {
       if ( $record->{age} > 20 ) {
         $record->{status} = 'adult';
         $record->save_row;
       }
     }

DESCRIPTION
   DBIx::DBO2 is an object-relational mapping framework (or perhaps a
   relational-object mapping framework, if I understand the distinction
   correctly) that facilitates the development of Perl classes whose
   objects are stored in a SQL database table.

INSTALLING
   You should be able to install this module using the CPAN shell
   interface:

     perl -MCPAN -e 'install DBIx::DBO2'

   If this module has not yet been posted to your local CPAN mirror, you
   may also retrieve the current distribution from the below address and
   follow the normal "gunzip", "tar xf", "cd", "perl Makefile.PL && make
   test && sudo make install" procedure or your local equivalent:

     http://www.evoscript.org/DBIx-DBO2/

 Getting Started

   You may want to take a look at the test.pl and test-lib/ classes
   included with this distribution for a short example of how to use this
   framework to create your own classes.

 Prerequisites

   Requires DBIx::SQLEngine and Class::MakeMethods, both available on CPAN.

 Tested Platforms

   This release has been tested succesfully on the following platforms:

     5.6.1 on darwin
     5.005_03 on i386-freebsd

VERSION
   This is version 0.005 of DBIx::DBO2.

 Distribution Summary

   This module's summary in the CPAN DSLIP is intended to read:

     Name            DSLIP  Description
     --------------  -----  ---------------------------------------------
     DBIx::
     ::DBO2          bdpOp  Objects mapping to SQL relational structures

 Beta Release

   Although it based on earlier code that was extensively tested over
   several years of production use, this code has recently been majorly
   refactored, and has not yet been sufficiently tested in its new form.

 Discussion and Support

   There is not currently any offical discussion and support forum for this
   pacakage.

   Further information and support for this module is available at
   http://www.evoscript.org.

   If you have questions or feedback about this module, please feel free to
   contact the author at the below address.

   I would be particularly interested in any suggestions towards improving
   the documentation, correcting any Perl-version or platform dependencies,
   as well as general feedback and suggestions.

SEE ALSO
   See the DBIx::SQLEngine manpage for information about the underlying
   database interface.

   See the DBIx::DBO2::Record manpage, the DBIx::DBO2::Fields manpage, the
   DBIx::DBO2::Table manpage, and the DBIx::DBO2::TableSet manpage for key
   interfaces.

 Similar Modules

   Numerous modules on CPAN provide some type of system to map objects to
   and from SQL databases, including the Class::DBI manpage, the Alzabo
   manpage, and the Tangram manpage.

   See the Poop Group summary at http://poop.sourceforge.net/ for a review
   of several other CPAN modules which provide a similar RDBMS-to-OO
   mapping layer.

   For comparison purposes, here are some of the questions asked by the
   Poop Group summary and their answers for this module:

   Supported Databases
       Currently supports DBD::AnyData, DBD::CSV, DBD::MySQL, and DBD::Pg.

       Providing support for other drivers involves creating a DBD-specific
       subclass of DBIx::SQLEngine (which will be loaded via DBIx::AnyDBD
       when appropriate), and should only require a limited amount of
       coding.

   SQL Abstraction
       This module supports moderately complex selects, inserts, updates,
       and deletes, based on the DBIx::SQLEngine abstraction layer. It is
       possible to apply order by and group by clauses to operations, as
       well as limits.

       Inserts with sequences are supported, with DBIX::SQLEngine providing
       a workaround using its own sequence table logic for DBDs which don't
       have native sequence/auto_increment equivalents.

       Joins are not supported, although it is possible to pass in snippets
       of SQL to accomplish this, or to provide your own logic in a
       subclass.

   Invalid SQL
       The automated SQL generation should produce valid SQL, but if you
       pass in incorrect information, such as explicitly requesting a
       column name which does not exist in the database, or if you pass in
       a SQL snippet as part of a query, there is no way to validate this
       prior to actually executing the query and receiving an error from
       the DBMS.

   Deferred/Preloaded data retrieval
       There is not yet any way to defer the loading of given columns for a
       select. However, it always possible to easily specify only those
       columns which are needed at a given point in your code. (Deferred
       loading of additional columns is expected in an upcomming release.)

   Table Relationships
       DBIx::DBO2 supports both many-to-one (foreign key) and one-to-many
       (reverse foreign key) relationships. Support for one-to-many
       relationships includes your choice of cascading delete, nullify
       after delete, and restrict delete rules. You can establish
       relationships between classes regardless of whether their data is
       actually stored in the same underlying SQL database.

   Multiple rows and cursors
       DBIx::DBO2 currently returns multiple rows all at once. A RecordSet
       object similar to a cursor is used by it does not yet handle
       incremental retrieval. (Support for cursors and automatic iteration
       with closures is expected in an upcomming release.)

   Caching
       There is no built in caching support. (Support for LRU caching and
       ensuring that there is only a single instance of a given object in
       memory at any time are both expected in an upcomming release.)

   Transactions
       DBIx::DBO2 does not support transactions. (Basic transactions for
       DBDs which support them are expected in an upcomming release.)

   Auto-generated methods
       The included DBIx::DBO2::Fields package can generate a wide variety
       of methods, including customized accessors for each type of field or
       relationship. (These currently require explicit declarations, but
       support for automatic detection of database columns and subsequent
       method generation is expected in an upcomming release.)

   Other
       A callback mechanism allows you to specify method names or arbitrary
       subroutines to be called immediately before or after each record is
       retrieved, inserted, updated, or deleted. You can add these
       callbacks to all record classes, to a particular class, or even to a
       particular object instance.

   Documentation
       The documentation for this module is still fairly rough, although
       efforts are continuing to improve this.

   License
       GPL/Artistic disjunction. The same as Perl itself.

   Support
       Support for this module is available from the author
       ([email protected]). (The author is also available for support
       contracts or consulting engagements.)

   Status
       Recently released to CPAN after several years of in-house use.
       Actively developed and supported by the author.

CREDITS AND COPYRIGHT
 Developed By

     M. Simon Cavalletto, [email protected]
     Evolution Softworks, www.evoscript.org

 Contributors

     Piglet / EJ Evans, [email protected]
     Eric Schneider, [email protected]
     Chaos / Matthew Sheahan

 Copyright

   Copyright 2002 Matthew Simon Cavalletto.

   Portions copyright 1997, 1998, 1999, 2000, 2001 Evolution Online
   Systems, Inc.

 License

   You may use, modify, and distribute this software under the same terms
   as Perl.

You are viewing proxied material from ftp.icm.edu.pl. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.