| 1 |
#!/usr/bin/perl |
| 2 |
|
| 3 |
use lib '../../../../Rose-DB/lib'; |
| 4 |
use lib '../../../lib'; |
| 5 |
use lib 'lib'; |
| 6 |
|
| 7 |
use My::Product; |
| 8 |
|
| 9 |
# use My::Price; |
| 10 |
# use My::Color; |
| 11 |
# use My::Vendor; |
| 12 |
# $p = My::Product->new(id => 1, name => 'A'); |
| 13 |
# $p->prices(My::Price->new(product_id => 1, region => 'IS', price => 1.23), |
| 14 |
# My::Price->new(product_id => 1, region => 'DE', price => 4.56)); |
| 15 |
# |
| 16 |
# $p->colors(My::Color->new(code => 'CC1', name => 'red'), |
| 17 |
# My::Color->new(code => 'CC2', name => 'green')); |
| 18 |
# |
| 19 |
# $p->vendor(My::Vendor->new(id => 1, name => 'V1')); |
| 20 |
# $p->save; |
| 21 |
|
| 22 |
$p = My::Product->new(id => 1)->load; |
| 23 |
print $p->vendor->name, "\n"; |
| 24 |
|
| 25 |
print join(', ', map { $_->region . ': ' . $_->price } $p->prices), "\n"; |
| 26 |
print join(', ', map { $_->name } $p->colors), "\n"; |
| 27 |
|
| 28 |
$c = My::Color->new(name => 'red')->load; |
| 29 |
|
| 30 |
print $c->name, ': ', $c->code, "\n"; |
| 31 |
|
| 32 |
#My::Product->meta->auto_load_related_classes(0); |
| 33 |
#print My::Product->meta->perl_class_definition(braces => 'bsd', indent => 2); |
| 34 |
|
| 35 |
__END__ |
| 36 |
|
| 37 |
DROP TABLE product_colors CASCADE; |
| 38 |
DROP TABLE prices CASCADE; |
| 39 |
DROP TABLE products CASCADE; |
| 40 |
DROP TABLE colors CASCADE; |
| 41 |
DROP TABLE vendors CASCADE; |
| 42 |
|
| 43 |
CREATE TABLE vendors |
| 44 |
( |
| 45 |
id SERIAL NOT NULL PRIMARY KEY, |
| 46 |
name VARCHAR(255) |
| 47 |
); |
| 48 |
|
| 49 |
CREATE TABLE colors |
| 50 |
( |
| 51 |
code CHAR(3) NOT NULL PRIMARY KEY, |
| 52 |
name VARCHAR(255) |
| 53 |
); |
| 54 |
|
| 55 |
CREATE TABLE products |
| 56 |
( |
| 57 |
id SERIAL NOT NULL PRIMARY KEY, |
| 58 |
name VARCHAR(255), |
| 59 |
vendor_id INT NOT NULL REFERENCES vendors (id) |
| 60 |
); |
| 61 |
|
| 62 |
CREATE TABLE prices |
| 63 |
( |
| 64 |
price_id SERIAL NOT NULL PRIMARY KEY, |
| 65 |
product_id INT NOT NULL REFERENCES products (id), |
| 66 |
region CHAR(2) NOT NULL DEFAULT 'US', |
| 67 |
price DECIMAL(10,2) NOT NULL |
| 68 |
); |
| 69 |
|
| 70 |
CREATE TABLE product_colors |
| 71 |
( |
| 72 |
id SERIAL NOT NULL PRIMARY KEY, |
| 73 |
product_id INT NOT NULL REFERENCES products (id), |
| 74 |
color_code CHAR(3) NOT NULL REFERENCES colors (code) |
| 75 |
); |
| 76 |
|
| 77 |
INSERT INTO vendors (id, name) VALUES (1, 'V1'); |
| 78 |
INSERT INTO vendors (id, name) VALUES (2, 'V2'); |
| 79 |
|
| 80 |
INSERT INTO products (id, name, vendor_id) VALUES (1, 'A', 1); |
| 81 |
INSERT INTO products (id, name, vendor_id) VALUES (2, 'B', 2); |
| 82 |
INSERT INTO products (id, name, vendor_id) VALUES (3, 'C', 1); |
| 83 |
|
| 84 |
INSERT INTO prices (product_id, region, price) VALUES (1, 'US', 1.23); |
| 85 |
INSERT INTO prices (product_id, region, price) VALUES (1, 'DE', 4.56); |
| 86 |
INSERT INTO prices (product_id, region, price) VALUES (2, 'US', 5.55); |
| 87 |
INSERT INTO prices (product_id, region, price) VALUES (3, 'US', 5.78); |
| 88 |
INSERT INTO prices (product_id, region, price) VALUES (3, 'US', 9.99); |
| 89 |
|
| 90 |
INSERT INTO colors (code, name) VALUES ('CC1', 'red'); |
| 91 |
INSERT INTO colors (code, name) VALUES ('CC2', 'green'); |
| 92 |
INSERT INTO colors (code, name) VALUES ('CC3', 'blue'); |
| 93 |
INSERT INTO colors (code, name) VALUES ('CC4', 'pink'); |
| 94 |
|
| 95 |
INSERT INTO product_colors (product_id, color_code) VALUES (1, 'CC1'); |
| 96 |
INSERT INTO product_colors (product_id, color_code) VALUES (1, 'CC2'); |
| 97 |
|
| 98 |
INSERT INTO product_colors (product_id, color_code) VALUES (2, 'CC4'); |
| 99 |
|
| 100 |
INSERT INTO product_colors (product_id, color_code) VALUES (3, 'CC2'); |
| 101 |
INSERT INTO product_colors (product_id, color_code) VALUES (3, 'CC3'); |