Rose-DB-Object

Changes for version 0.73

The new setup() method is now the officially recommended way to set up class metadata.
Updated the documentation and the generated Perl code to use the new setup() method.
Related classes are now loaded automatically by default. Added the auto_load_related_classes metadata attribute to control this behavior.
Added the pk_columns() alias for the primary_key_columns() method.
Added insert_or_update() and insert_or_update_on_duplicate_key() helper methods. (Suggested by Guillermo Roditi)
The Loader now automatically skips tables without primary keys.
Moved some database introspection code to a new version of Rose::DB, which this version of Rose::DB::Object now requires.
Non-null character columns are now detected correctly in Informix.
Fixed many bugs related to explicit and auto-detected column defaults.
Corrected the return value of Rose::DB::Object::Cached's load() method to match that of the standard load(). (Reported by Randal Schwartz)
Fixed a bug that caused chkpass columns to be erased after some save()s. (Reported by Cees Hek)
Added an option to use InnoDB with MySQL in the benchmark suite.

Documentation

Rose::DB::Object::Tutorial

A guided tour of the basics of Rose::DB::Object

Modules

Rose::DB::Object

Extensible, high performance RDBMS-OO mapper.

Rose::DB::Object::Cached

Memory cached object representation of a single row in a database table.

Rose::DB::Object::ConventionManager

Provide missing metadata by convention.

Rose::DB::Object::ConventionManager::Null

A singleton convention manager that does nothing.

Rose::DB::Object::Helpers

A mix-in class containing convenience methods for Rose::DB::Object.

Rose::DB::Object::Iterator

Iterate over a series of Rose::DB::Objects.

Rose::DB::Object::Loader

Automatically create Rose::DB::Object subclasses for all the tables in a database.

Rose::DB::Object::MakeMethods::BigNum

Create object methods for arbitrary-precision numeric attributes for Rose::DB::Object-derived objects.

Rose::DB::Object::MakeMethods::Date

Create date-related methods for Rose::DB::Object-derived objects.

Rose::DB::Object::MakeMethods::Generic

Create generic object methods for Rose::DB::Object-derived objects.

Rose::DB::Object::MakeMethods::Pg

Create PostgreSQL-specific object methods for Rose::DB::Object-derived objects.

Rose::DB::Object::MakeMethods::Std

Create object methods related to Rose::DB::Object::Std-derived objects.

Rose::DB::Object::MakeMethods::Time

Create time-related methods for Rose::DB::Object-derived objects.

Rose::DB::Object::Manager

Fetch multiple Rose::DB::Object-derived objects from the database using complex queries.

Rose::DB::Object::Metadata

Database object metadata.

Rose::DB::Object::Metadata::Column

Base class for database column metadata objects.

Rose::DB::Object::Metadata::Column::Array

Array column metadata.

Rose::DB::Object::Metadata::Column::BigInt

Big integer column metadata.

Rose::DB::Object::Metadata::Column::BigSerial

Big serial column metadata.

Rose::DB::Object::Metadata::Column::Bitfield

Bitfield column metadata.

Rose::DB::Object::Metadata::Column::Blob

Binary large object column metadata.

Rose::DB::Object::Metadata::Column::Boolean

Boolean column metadata.

Rose::DB::Object::Metadata::Column::Character

Character column metadata.

Rose::DB::Object::Metadata::Column::Date

Date column metadata.

Rose::DB::Object::Metadata::Column::Datetime

Datetime column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction

Datetime year to fraction column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction1

Datetime year to fraction(1) column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction2

Datetime year to fraction(2) column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction3

Datetime year to fraction(3) column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction4

Datetime year to fraction(4) column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToFraction5

Datetime year to fraction(5) column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToMinute

Datetime year to minute column metadata.

Rose::DB::Object::Metadata::Column::DatetimeYearToSecond

Datetime year to second column metadata.

Rose::DB::Object::Metadata::Column::Decimal

Decimal column metadata.

Rose::DB::Object::Metadata::Column::Enum

Enumerated column metadata.

Rose::DB::Object::Metadata::Column::Epoch

Seconds since the epoch column metadata.

Rose::DB::Object::Metadata::Column::Epoch::HiRes

Fractional seconds since the epoch column metadata.

Rose::DB::Object::Metadata::Column::Float

Floating-point column metadata.

Rose::DB::Object::Metadata::Column::Integer

Integer column metadata.

Rose::DB::Object::Metadata::Column::Interval

Date column metadata.

Rose::DB::Object::Metadata::Column::Numeric

Numeric column metadata.

Rose::DB::Object::Metadata::Column::Pg::Chkpass

PostgreSQL CHKPASS column metadata.

Rose::DB::Object::Metadata::Column::Scalar

Scalar column metadata.

Rose::DB::Object::Metadata::Column::Serial

Serial column metadata.

Rose::DB::Object::Metadata::Column::Set

Set column metadata.

Rose::DB::Object::Metadata::Column::Text

Text column metadata.

Rose::DB::Object::Metadata::Column::Timestamp

Timestamp column metadata.

Rose::DB::Object::Metadata::Column::Varchar

Variable-length character column metadata.

Rose::DB::Object::Metadata::ForeignKey

Foreign key metadata.

Rose::DB::Object::Metadata::PrimaryKey

Primary key metadata.

Rose::DB::Object::Metadata::Relationship

Base class for table relationship metadata objects.

Rose::DB::Object::Metadata::Relationship::ManyToMany

One to many table relationship metadata object.

Rose::DB::Object::Metadata::Relationship::ManyToOne

Many to one table relationship metadata object.

Rose::DB::Object::Metadata::Relationship::OneToMany

One to many table relationship metadata object.

Rose::DB::Object::Metadata::Relationship::OneToOne

One to one table relationship metadata object.

Rose::DB::Object::Metadata::UniqueKey

Unique key metadata.

Rose::DB::Object::MixIn

A base class for mix-ins.

Rose::DB::Object::QueryBuilder

Build SQL queries on behalf of Rose::DB::Object::Manager.

Rose::DB::Object::Std

Standardized object representation of a single row in a database table.

Rose::DB::Object::Std::Cached

Memory cached standardized object representation of a single row in a database table.

Rose::DB::Object::Std::Metadata

Standardized database object metadata.

Rose::DB::Object::Util

Utility functions for use in Rose::DB::Object subclasses and method makers.

Provides

Rose::DB::Object::Constants

in lib/Rose/DB/Object/Constants.pm

Rose::DB::Object::Metadata::Auto

in lib/Rose/DB/Object/Metadata/Auto.pm

Rose::DB::Object::Metadata::Auto::Generic

in lib/Rose/DB/Object/Metadata/Auto/Generic.pm

Rose::DB::Object::Metadata::Auto::Informix

in lib/Rose/DB/Object/Metadata/Auto/Informix.pm

Rose::DB::Object::Metadata::Auto::MySQL

in lib/Rose/DB/Object/Metadata/Auto/MySQL.pm

Rose::DB::Object::Metadata::Auto::Pg

in lib/Rose/DB/Object/Metadata/Auto/Pg.pm

Rose::DB::Object::Metadata::Auto::SQLite

in lib/Rose/DB/Object/Metadata/Auto/SQLite.pm

Rose::DB::Object::Metadata::ColumnList

in lib/Rose/DB/Object/Metadata/ColumnList.pm

Rose::DB::Object::Metadata::MethodMaker

in lib/Rose/DB/Object/Metadata/MethodMaker.pm

Rose::DB::Object::Metadata::Object

in lib/Rose/DB/Object/Metadata/Object.pm

Rose::DB::Object::Metadata::Util

in lib/Rose/DB/Object/Metadata/Util.pm

Other files

To install Rose::DB::Object, copy and paste the appropriate command in to your terminal.

cpanm

cpanm Rose::DB::Object

CPAN shell

perl -MCPAN -e shell
install Rose::DB::Object

For more information on module installation, please visit the detailed CPAN module installation guide.

	Global
`s`	Focus search bar
`?`	Bring up this help dialog

	GitHub
`g` `p`	Go to pull requests
`g` `i`	go to github issues (only if github is preferred repository)

	POD
`g` `a`	Go to author
`g` `c`	Go to changes
`g` `i`	Go to issues
`g` `d`	Go to dist
`g` `r`	Go to repository/SCM
`g` `s`	Go to source
`g` `b`	Go to file browse

	Search terms
module: (e.g. module:Plugin)
distribution: (e.g. distribution:Dancer auth)
author: (e.g. author:SONGMU Redis)
version: (e.g. version:1.00)

Changes for version 0.73

Documentation

Modules

Provides

Other files

Module Install Instructions