Rose-DB-Object

Changes for version 0.60

Added arbitrary-depth auto-joins to the Manager using a "dot-chained" syntax (e.g., vendor.regions.code)
Added make_modules() method to the loader.
Added pre_init_hook() method to metadata objects and the loader.
Added overflow attribute to control the behavior when a scalar, character, or varchar column value is too long. Possible values are "fatal" (the default), "truncate", and "warn".
Serial columns are now detected correctly even when DBI returns a column type of integer or bigint. (Reported by Cees Hek)
Added support for bigserial columns.
Enum columns now have their list of valid values printed correctly by the perl_hash_definition() method. (Reported by Juan Camacho)
Fixed a bug that caused the loader to trip over mixed-case unique keys in MySQL databases. (Reported by Juan Camacho)
Force MDY dates in Postgres in the test suite, just in case the user has European dates configured. (Reported by Cees Hek)
Fixed numerous Postgres 7.x bugs. (Reported by Cees Hek)
Modified the benchmark suite to further confine each module to its own private set of database rows in order to eliminate the influence of run order during the tests.
Worked around SQLite ORDER BY bugs in order to make the test suite function correctly.

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::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::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::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::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::Float

Floating-point column metadata.

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

Integer 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::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.60

Documentation

Modules

Provides

Other files

Module Install Instructions