Rose::DB::Object::Loader 0.7662

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

SYNOPSIS

Sample 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)
);

Product's homepage

Requirements:

· Perl