Rose-DB-Object

This is an extensible, high performance object-relational mapper (ORM) for RoseDB.

Features:

• Create a row in the database by saving a newly constructed object.
• Initialize an object by loading a row from the database.
• Update a row by saving a modified object back to the database.
• Delete a row from the database.
• Fetch an object referred to by a foreign key in the current object. (i.e., "one to one" and "many to one" relationships.)
• Fetch multiple objects that refer to the current object, either directly through foreign keys or indirectly through a mapping table. (i.e., "one to many" and "many to many" relationships.)
• Load an object along with "foreign objects" that are related through any of the supported relationship types.

What is new in this release:

• Handle null default values for foreign key columns in PostgreSQL.

What is new in version 0.788:

• Fixed a bug that prevented function calls like now() from being properly inlined, even when allow_inline_column_values was set to a true value.
• The Loader/auto-init system will now automatically set the allow_inline_column_values attribute to a true value when a column has a default value that looks like a function call.
• Fixed a non-numeric warning with development releases of Math::BigInt.

Limitations:

• Rose::DB::Object objects can represent rows in almost any database table, subject to the following constraints:
• The database server must be supported by Rose::DB.
• The database table must have a primary key.
• The primary key must not allow null values in any of its columns.