ANNOUNCE: Rose::DB::Object 0.50 released

RDBO has been bumped to the big 0.50. (Hey, that's half way to 1.0, right?
:) There have been many changes (bug fixes and significant new features)
since the last announcement to this list. The full change summary is below.
The most significant change is probably the addition of an extensive
tutorial:

perldoc Rose::DB::Object::Tutorial

It's not a replacement for the reference-style documentation, but it does
give a nice overview of the major features, and how best to use them.

-John

---

0.50 (11.17.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Added optional lazy-loading of column values.
* Long-overdue version number bump.

0.081 (11.15.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Tutorial added.

0.080 (11.14.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Added column triggers for get, set, load, save, inflate, and deflate.
* Added support for new argument types to relationship methods.
* Added a named, configurable map for convention manager classes.
* Added perl_manager_class() and make_manager_class() meta methods.
* Many bug fixes to datetime column methods, cross-database migration,
and the auto-init system.

0.079 (10.25.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Fixed bugs that caused auto-inited many-to-many relationships
to be inadequately fleshed-out under some circumstances.

0.078 (10.24.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Added page and per_page manager parameters for the truly lazy.
* Fixed a bug caused by a conflict between the convention manager
and the legacy foreign key name generator.

0.077 (10.20.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Added convention manager.
* Added "distinct" and "fetch_only" manager parameters.
* Added support for foreign key and relationship names as
column prefixes in manager query parameters and sort_by
arguments.
* Changed manager and query builder to default unprefixed
ambiguous columns to belong to the primary table ("t1").
* Fixed a bug that caused make_methods() to fail for "... to one"
relationships that have no corresponding foreign key.
* Fixed a bug in QueryBuilder that prevented the ability to check
for null columns.
* Added the ability to query columns that are not SELECTed.

0.076 (10.05.2005) - John Siracusa <siracusa@xxxxxxxxxxxxxx>

* Fixed a bug that caused incorrect counts in get_objects_count()
when using the require_object parameter with "... to many"
relationships.
* Added bulk update and delete methods to Manager.
* Added cascaded delete, plus a plea in the documentation for users
to do this in the database instead.
* Added "many to one" relationship and made it the new default
relationship type for foreign keys.
* Added *_now and *_on_save method types for foreign keys and
"... to one" relationships.
* Made get_set_on_save and delete_on_save the default auto method
types for foreign keys and "... to one" relationships.
* load() now returns the object itself on success, which allows
for the convenient $obj = MyObject->new(id => 123)->load;
* save() now returns the object itself on success, which allows
for the convenient $obj = MyObject->new(id => 123)->save;


.

Relevant Pages

  • Re: Need help with SQL query involving a recursive query
    ... >> their name, total salary (including bonus), mobile phone number, ... >> The Emp_Num of an employee's manager is in the manager number ... I have to do it in one query. ... > Manager_Num cannot contain a Null and have a foreign key to Emp_Num ...
    (microsoft.public.access.queries)
  • Re: DB design basic question
    ... You could make use the foreign key and then place a Constriant that the ... MattC ... A department HAS A manager. ...
    (microsoft.public.sqlserver.programming)
  • Re: Normalizing Tree Data
    ... Is the next level always Employee? ... references from Employee to Manager, from Manager to Division, and from ... I'm not sure what you mean by foreign key references. ...
    (comp.databases.theory)
  • Re: Passing parameter to query without using Enter Parameter window
    ... will do the filtering for you without having that parameter in the query. ... Dim strSQL As String, strTemp As String, strMgr As String ... ' Get list of manager IDs -- note: replace my generic table and field ...
    (microsoft.public.access.modulesdaovba)
  • Re: Export to excel in different tabs depending on criteria
    ... various data and export each filtered query to separate ... Dim strSQL As String, strTemp As String, strMgr As String ... ' *** code to set strSQL needs to be changed to conform to your ... ' Get list of manager IDs -- note: replace my generic table and field ...
    (microsoft.public.access.externaldata)