Rose::DB::Object::Loader

Rose::DB::Object::Loader allows you to automatically create Rose::DB::Object subclasses based on database table definitions.
Download

Rose::DB::Object::Loader Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Perl Artistic License
  • Price:
  • FREE
  • Publisher Name:
  • John C. Siracusa
  • Publisher web site:
  • http://search.cpan.org/~jsiracusa/

Rose::DB::Object::Loader Tags


Rose::DB::Object::Loader Description

Rose::DB::Object::Loader allows you to automatically create Rose::DB::Object subclasses based on database table definitions. Rose::DB::Object::Loader allows you to automatically create Rose::DB::Object subclasses based on database table definitions.SYNOPSISSample database schema: CREATE TABLE vendors ( id SERIAL NOT NULL PRIMARY KEY, name VARCHAR(255) NOT NULL, UNIQUE(name) ); CREATE TABLE products ( id SERIAL NOT NULL PRIMARY KEY, name VARCHAR(255) NOT NULL, price DECIMAL(10,2) NOT NULL DEFAULT 0.00, vendor_id INT REFERENCES vendors (id), status VARCHAR(128) NOT NULL DEFAULT 'inactive' CHECK(status IN ('inactive', 'active', 'defunct')), date_created TIMESTAMP NOT NULL DEFAULT NOW(), release_date TIMESTAMP, UNIQUE(name) ); CREATE TABLE prices ( id SERIAL NOT NULL PRIMARY KEY, product_id INT NOT NULL REFERENCES products (id), region CHAR(2) NOT NULL DEFAULT 'US', price DECIMAL(10,2) NOT NULL DEFAULT 0.00, UNIQUE(product_id, region) ); CREATE TABLE colors ( id SERIAL NOT NULL PRIMARY KEY, name VARCHAR(255) NOT NULL, UNIQUE(name) ); CREATE TABLE product_color_map ( product_id INT NOT NULL REFERENCES products (id), color_id INT NOT NULL REFERENCES colors (id), PRIMARY KEY(product_id, color_id) ); Requirements: · Perl


Rose::DB::Object::Loader Related Software