Rose::DB::Object::LoaderRose::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
- 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