Rose-DB-Object

Changes for version 0.764

Added a "find" method type to many-to-many relationships.
Added a "count" method type to ...-to-many relationships.
Added support for nested joins.
The setup() method now supports a "helpers" shortcut for importing methods from Rose::DB::Object::Helpers.
Added the dubious require_primary_key parameter and object attribute to the Loader. (Requested by Teodor Zlatanov)
Added two syntaxes for literal SQL to QueryBuilder.
Added the with_column_triggers attribute to foreign keys and singular relationships in order to keep columns and related objects in sync.
Fixed a bug that caused some optional related objects to be improperly transformed into required objects. (Reported by Ethan Rowe)
Improved detection of errors when auto-loading related classes.
Duplicate auto-created map record method names are now detected and reported as a fatal error.
Added and documented a return value for add_columns().
Added module_preamble and module_postamble features to the Loader's make_modules() method. (Patch by David Christensen)
Made changes_only, cascade, and prepare_cached arguments to save() also apply to *_on_save collections.
Added test and prerequisite version for a Rose::DB bug that prevented certain reserved words from being detected as primary key columns in Postgres. (Reported by Fred Cox)
Baseline Oracle support added to the Loader. (Patch by Teodor Zlatanov)
The clone() and clone_and_reset() methods now handle missing or differently named accessor/mutator methods.
QueryBuilder now supports eq/ne undef for is/is not null comparisons.
Foreign key columns that are also primary key columns are no longer set to undef when a foreign object is set to undef. (Reported by Ovid)
Fixed a bug that caused values not to be checked against the list of valid values in SET columns. (Reported by Adrian Howard)
Fixed a bug that caused column (get/)set methods not to return the correct value when an on_set trigger was applied to the column. (Reported by Cory Bennett)
Fixed a bug that caused enum columns to be incorrectly marked as modified in some circumstances. (Reported by Cory Bennett)
Fixed a bug that caused inflate/deflate triggers to fail under some circumstances. (Patch by Cory Bennett)

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 based on database table definitions.

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

Datetime year to month 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::DoublePrecision

Double-precision 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

Interval column metadata.

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

Numeric column metadata.

Rose::DB::Object::Metadata::Column::Pg::Bytea

PostgreSQL BYTEA 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::Time

Time 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

Many 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::Exception

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

Rose::DB::Object::Exception::ClassNotReady

in lib/Rose/DB/Object/Exception.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::Oracle

in lib/Rose/DB/Object/Metadata/Auto/Oracle.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.764

Documentation

Modules

Provides

Other files

Module Install Instructions