| 1 |
#!/usr/bin/perl |
| 2 |
|
| 3 |
use lib '../../../../Rose-DB/lib'; |
| 4 |
use lib '../../../lib'; |
| 5 |
|
| 6 |
require '../../test-lib.pl'; |
| 7 |
|
| 8 |
use Rose::DB::Object::Loader; |
| 9 |
|
| 10 |
#Rose::DB->default_type('pg'); |
| 11 |
#my $db = Rose::DB->new('pg'); |
| 12 |
|
| 13 |
my $loader = |
| 14 |
Rose::DB::Object::Loader->new( |
| 15 |
#db => $db, |
| 16 |
#db_class => 'Rose::DB', |
| 17 |
db_dsn => 'dbi:Pg:dbname=test;host=localhost', |
| 18 |
db_username => 'postgres', |
| 19 |
class_prefix => 'My::'); |
| 20 |
|
| 21 |
$loader->make_modules(module_dir => 'lib', |
| 22 |
braces => 'bsd', |
| 23 |
indent => 2); |
| 24 |
|
| 25 |
# auto_load_related_classes => 0 |
| 26 |
|
| 27 |
__END__ |
| 28 |
|
| 29 |
DROP TABLE product_colors CASCADE; |
| 30 |
DROP TABLE prices CASCADE; |
| 31 |
DROP TABLE products CASCADE; |
| 32 |
DROP TABLE colors CASCADE; |
| 33 |
DROP TABLE vendors CASCADE; |
| 34 |
|
| 35 |
CREATE TABLE vendors |
| 36 |
( |
| 37 |
id SERIAL NOT NULL PRIMARY KEY, |
| 38 |
name VARCHAR(255) |
| 39 |
); |
| 40 |
|
| 41 |
CREATE TABLE colors |
| 42 |
( |
| 43 |
code CHAR(3) NOT NULL PRIMARY KEY, |
| 44 |
name VARCHAR(255), |
| 45 |
UNIQUE(name) |
| 46 |
); |
| 47 |
|
| 48 |
CREATE TABLE products |
| 49 |
( |
| 50 |
id SERIAL NOT NULL PRIMARY KEY, |
| 51 |
name VARCHAR(255), |
| 52 |
vendor_id INT NOT NULL REFERENCES vendors (id), |
| 53 |
|
| 54 |
UNIQUE(name, vendor_id), |
| 55 |
UNIQUE(name) |
| 56 |
); |
| 57 |
|
| 58 |
CREATE TABLE prices |
| 59 |
( |
| 60 |
price_id SERIAL NOT NULL PRIMARY KEY, |
| 61 |
product_id INT NOT NULL REFERENCES products (id), |
| 62 |
region CHAR(2) NOT NULL DEFAULT 'US', |
| 63 |
price DECIMAL(10,2) NOT NULL |
| 64 |
); |
| 65 |
|
| 66 |
CREATE TABLE product_colors |
| 67 |
( |
| 68 |
id SERIAL NOT NULL PRIMARY KEY, |
| 69 |
product_id INT NOT NULL REFERENCES products (id), |
| 70 |
color_code CHAR(3) NOT NULL REFERENCES colors (code) |
| 71 |
); |
| 72 |
|
| 73 |
INSERT INTO vendors (id, name) VALUES (1, 'V1'); |
| 74 |
INSERT INTO vendors (id, name) VALUES (2, 'V2'); |
| 75 |
|
| 76 |
INSERT INTO products (id, name, vendor_id) VALUES (1, 'A', 1); |
| 77 |
INSERT INTO products (id, name, vendor_id) VALUES (2, 'B', 2); |
| 78 |
INSERT INTO products (id, name, vendor_id) VALUES (3, 'C', 1); |
| 79 |
|
| 80 |
INSERT INTO prices (product_id, region, price) VALUES (1, 'US', 1.23); |
| 81 |
INSERT INTO prices (product_id, region, price) VALUES (1, 'DE', 4.56); |
| 82 |
INSERT INTO prices (product_id, region, price) VALUES (2, 'US', 5.55); |
| 83 |
INSERT INTO prices (product_id, region, price) VALUES (3, 'US', 5.78); |
| 84 |
INSERT INTO prices (product_id, region, price) VALUES (3, 'US', 9.99); |
| 85 |
|
| 86 |
INSERT INTO colors (code, name) VALUES ('CC1', 'red'); |
| 87 |
INSERT INTO colors (code, name) VALUES ('CC2', 'green'); |
| 88 |
INSERT INTO colors (code, name) VALUES ('CC3', 'blue'); |
| 89 |
INSERT INTO colors (code, name) VALUES ('CC4', 'pink'); |
| 90 |
|
| 91 |
INSERT INTO product_colors (product_id, color_code) VALUES (1, 'CC1'); |
| 92 |
INSERT INTO product_colors (product_id, color_code) VALUES (1, 'CC2'); |
| 93 |
|
| 94 |
INSERT INTO product_colors (product_id, color_code) VALUES (2, 'CC4'); |
| 95 |
|
| 96 |
INSERT INTO product_colors (product_id, color_code) VALUES (3, 'CC2'); |
| 97 |
INSERT INTO product_colors (product_id, color_code) VALUES (3, 'CC3'); |