Debian Codegraph @

t/sandbox/code-gen/make-modules.pl

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