Debian Codegraph @

t/sandbox/code-gen/generated-perl-test.pl

raw
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');