Rose-DB-Object

Changes for version 0.75

Added a cascade option to save().
Added auto-detection one one-to-one relationships to the Loader.
The object_class parameter to Manager methods now defaults to the return value of the object_class() class method.
The soft() and referential_integrity() methods of the ManyToOne and OneToOne relationship classes have been renamed to optional() and required(), respectively. The old method names still work, but may be removed at some later date. Also, the default values are now determined by a new set of rules, rather than a constant.
Passing invalid query parameters to Manager methods will now cause a fatal error.
Scalar references now work correctly when used in IN(...) queries built by QueryBuilder. (Patch by Perrin Harkins)
Fixed a bug that caused get_set_on_save methods to fail for certain kinds of ...-to-one relationships.
Ignore empty "and" and "or" query parameters in QueryBuilder. (Suggested by Jonathan Vanasco)
Fixed a bug that caused update() to fail for tables where all columns are part of the primary key. (Reported by Danial Pearce)
Minor tweaks to the subselect-based limit/offset code.

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

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

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.75

Documentation

Modules

Provides

Other files

Module Install Instructions