Commit | Line | Data |
88f2d2fd |
1 | package SQL::Translator::Producer::Turnkey; |
c00bb9f8 |
2 | |
dd6fb3de |
3 | # ------------------------------------------------------------------- |
147d59b4 |
4 | # $Id: Turnkey.pm,v 1.60 2004-10-13 22:31:59 allenday Exp $ |
dd6fb3de |
5 | # ------------------------------------------------------------------- |
977651a5 |
6 | # Copyright (C) 2002-4 SQLFairy Authors |
dd6fb3de |
7 | # |
8 | # This program is free software; you can redistribute it and/or |
9 | # modify it under the terms of the GNU General Public License as |
10 | # published by the Free Software Foundation; version 2. |
11 | # |
12 | # This program is distributed in the hope that it will be useful, but |
13 | # WITHOUT ANY WARRANTY; without even the implied warranty of |
14 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
15 | # General Public License for more details. |
16 | # |
17 | # You should have received a copy of the GNU General Public License |
18 | # along with this program; if not, write to the Free Software |
19 | # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA |
20 | # 02111-1307 USA |
21 | # ------------------------------------------------------------------- |
22 | |
c00bb9f8 |
23 | use strict; |
24 | use vars qw[ $VERSION $DEBUG ]; |
147d59b4 |
25 | $VERSION = sprintf "%d.%02d", q$Revision: 1.60 $ =~ /(\d+)\.(\d+)/; |
c00bb9f8 |
26 | $DEBUG = 1 unless defined $DEBUG; |
27 | |
28 | use SQL::Translator::Schema::Constants; |
d8dc07e7 |
29 | use SQL::Translator::Schema::Graph; |
30 | use SQL::Translator::Schema::Graph::HyperEdge; |
65157eda |
31 | use Log::Log4perl; Log::Log4perl::init('/etc/log4perl.conf'); |
c00bb9f8 |
32 | use Data::Dumper; |
58bf08d5 |
33 | $Data::Dumper::Maxdepth = 3; |
c00bb9f8 |
34 | use Template; |
35 | |
d8dc07e7 |
36 | my %producer2dsn = ( |
c00bb9f8 |
37 | MySQL => 'mysql', |
38 | PostgreSQL => 'Pg', |
39 | Oracle => 'Oracle', |
40 | ); |
41 | |
42 | # ------------------------------------------------------------------- |
43 | sub produce { |
1da10402 |
44 | my $log = Log::Log4perl->get_logger('SQL.Translator.Producer.Turnkey'); |
65157eda |
45 | |
c00bb9f8 |
46 | my $t = shift; |
47 | my $create = undef; |
c00bb9f8 |
48 | my $args = $t->producer_args; |
d8dc07e7 |
49 | my $no_comments = $t->no_comments; |
50 | my $baseclass = $args->{'main_pkg_name'} || $t->format_package_name('DBI'); |
65157eda |
51 | my $graph = SQL::Translator::Schema::Graph->new(translator => $t, |
52 | baseclass => $baseclass |
53 | ); |
c00bb9f8 |
54 | |
88f2d2fd |
55 | my $parser_type = (split /::/, $t->parser_type)[-1]; |
56 | |
57 | local $DEBUG = $t->debug; |
58 | |
59 | my %meta = ( |
919a1670 |
60 | concat => $args->{'concat'} || '', |
88f2d2fd |
61 | format_fk => $t->format_fk_name, |
bed83b64 |
62 | format_package => $t->format_package_name, |
43167a31 |
63 | format_table => $t->format_table_name, |
88f2d2fd |
64 | template => $args->{'template'} || '', |
d8dc07e7 |
65 | baseclass => $baseclass, |
35276d8c |
66 | db_dsn => $args->{'db_dsn'} || '', |
88f2d2fd |
67 | db_user => $args->{'db_user'} || '', |
68 | db_pass => $args->{'db_pass'} || '', |
cf927f90 |
69 | db_str => $args->{'db_str'} || '', |
88f2d2fd |
70 | parser => $t->parser_type, |
71 | producer => __PACKAGE__, |
d8dc07e7 |
72 | dsn => $args->{'dsn'} || sprintf( 'dbi:%s:_', $producer2dsn{ $parser_type } |
73 | ? $producer2dsn{ $parser_type } |
88f2d2fd |
74 | : $parser_type |
75 | ) |
76 | ); |
77 | |
69c7a62f |
78 | # |
c8515c9f |
79 | # create methods |
69c7a62f |
80 | # |
58bf08d5 |
81 | # this code needs to move to Graph.pm |
d8dc07e7 |
82 | foreach my $node_from ($graph->node_values){ |
65157eda |
83 | |
84 | next unless $node_from->table->is_data or !$node_from->table->is_trivial_link; |
85 | |
88f2d2fd |
86 | foreach my $cedge ( $node_from->compoundedges ){ |
69c7a62f |
87 | |
d8dc07e7 |
88 | my $hyperedge = SQL::Translator::Schema::Graph::HyperEdge->new(); |
c8515c9f |
89 | |
d8dc07e7 |
90 | my $node_to; |
88f2d2fd |
91 | foreach my $edge ($cedge->edges){ |
92 | if($edge->thisnode->name eq $node_from->name){ |
93 | $hyperedge->vianode($edge->thatnode); |
c8515c9f |
94 | |
88f2d2fd |
95 | if($edge->thatnode->name ne $cedge->via->name){ |
d8dc07e7 |
96 | $node_to ||= $graph->node($edge->thatnode->table->name); |
88f2d2fd |
97 | } |
c8515c9f |
98 | |
d8dc07e7 |
99 | $hyperedge->push_thisnode($edge->thisnode); |
100 | $hyperedge->push_thisfield($edge->thisfield); |
101 | $hyperedge->push_thisviafield($edge->thatfield); |
c8515c9f |
102 | |
88f2d2fd |
103 | } else { |
88f2d2fd |
104 | if($edge->thisnode->name ne $cedge->via->name){ |
d8dc07e7 |
105 | $node_to ||= $graph->node($edge->thisnode->table->name); |
88f2d2fd |
106 | } |
d8dc07e7 |
107 | $hyperedge->push_thatnode($edge->thisnode); |
108 | $hyperedge->push_thatfield($edge->thisfield); |
109 | $hyperedge->push_thatviafield($edge->thatfield); |
88f2d2fd |
110 | } |
65157eda |
111 | $log->debug($edge->thisfield->name); |
112 | $log->debug($edge->thatfield->name); |
88f2d2fd |
113 | } |
65157eda |
114 | |
88f2d2fd |
115 | if($hyperedge->count_thisnode == 1 and $hyperedge->count_thatnode == 1){ $hyperedge->type('one2one') } |
116 | elsif($hyperedge->count_thisnode > 1 and $hyperedge->count_thatnode == 1){ $hyperedge->type('many2one') } |
117 | elsif($hyperedge->count_thisnode == 1 and $hyperedge->count_thatnode > 1){ $hyperedge->type('one2many') } |
118 | elsif($hyperedge->count_thisnode > 1 and $hyperedge->count_thatnode > 1){ $hyperedge->type('many2many') } |
119 | |
1da10402 |
120 | $log->debug($_) foreach sort keys %::SQL::Translator::Schema::Graph::HyperEdge::; |
65157eda |
121 | |
122 | #node_to won't always be defined b/c of multiple edges to a single other node |
123 | if(defined($node_to)){ |
124 | $log->debug($node_from->name); |
125 | $log->debug($node_to->name); |
126 | |
127 | if(scalar($hyperedge->thisnode) > 1){ |
128 | $log->debug($hyperedge->type ." via ". $hyperedge->vianode->name); |
129 | my $i = 0; |
130 | foreach my $thisnode ( $hyperedge->thisnode ){ |
131 | $log->debug($thisnode->name .' '. |
132 | $hyperedge->thisfield_index(0)->name .' -> '. |
133 | $hyperedge->thisviafield_index($i)->name .' '. |
134 | $hyperedge->vianode->name .' '. |
135 | $hyperedge->thatviafield_index(0)->name .' <- '. |
136 | $hyperedge->thatfield_index(0)->name .' '. |
137 | $hyperedge->thatnode_index(0)->name ."\n" |
138 | ); |
139 | $i++; |
140 | } |
d8dc07e7 |
141 | } |
816ce4b6 |
142 | #warn Dumper($hyperedge) if $hyperedge->type eq 'many2many'; |
65157eda |
143 | $node_from->push_hyperedges($hyperedge); |
d8dc07e7 |
144 | } |
88f2d2fd |
145 | } |
c8515c9f |
146 | } |
d8dc07e7 |
147 | $meta{"nodes"} = $graph->node; |
88f2d2fd |
148 | return(translateForm($t, \%meta)); |
c00bb9f8 |
149 | } |
150 | |
d8dc07e7 |
151 | sub translateForm { |
152 | my $t = shift; |
153 | my $meta = shift; |
a0249514 |
154 | |
d8dc07e7 |
155 | my $args = $t->producer_args; |
156 | my $type = $meta->{'template'}; |
bc0cf6eb |
157 | |
d8dc07e7 |
158 | my $template = Template->new({ |
bc0cf6eb |
159 | PRE_CHOMP => 1, |
160 | POST_CHOMP => 0, |
161 | EVAL_PERL => 1 |
162 | }); |
d8dc07e7 |
163 | |
bc0cf6eb |
164 | my $tt2; |
165 | $tt2 = template($type); |
d8dc07e7 |
166 | my $result; |
bc0cf6eb |
167 | |
168 | if($type eq 'atomtemplate'){ |
169 | my %result; |
170 | foreach my $node (values %{ $meta->{'nodes'} }){ |
171 | $result = ''; |
172 | my $param = { node => $node }; |
173 | $template->process(\$tt2, $param, \$result) || die $template->error(); |
174 | $result =~ s/^\s*(.+)\s*$/$1/s; |
175 | next unless $result; |
bc0cf6eb |
176 | $result{$node->table->name} = $result; |
bc0cf6eb |
177 | } |
56d46c5c |
178 | return \%result; |
bc0cf6eb |
179 | } else { |
180 | $template->process(\$tt2, $meta, \$result) || die $template->error(); |
181 | } |
182 | |
919a1670 |
183 | #warn $result if $type eq 'dbi'; |
184 | |
d8dc07e7 |
185 | return($result); |
186 | } |
187 | |
188 | 1; |
189 | |
190 | # ------------------------------------------------------------------- |
191 | |
192 | =pod |
193 | |
194 | =head1 NAME |
195 | |
196 | SQL::Translator::Producer::Turnkey - create Turnkey classes from schema |
197 | |
198 | =head1 SYNOPSIS |
199 | |
200 | Creates output for use with the Turnkey project. |
201 | |
202 | =head1 SEE ALSO |
203 | |
204 | L<http://turnkey.sourceforge.net>. |
205 | |
206 | =head1 AUTHORS |
207 | |
208 | Allen Day E<lt>allenday@ucla.eduE<gt> |
82cedef0 |
209 | Brian O\'Connor E<lt>boconnor@ucla.comE<gt>. |
d8dc07e7 |
210 | |
211 | =cut |
212 | |
213 | sub template { |
214 | my $type = shift; |
215 | |
c00bb9f8 |
216 | ########################################### |
217 | # Here documents for the tt2 templates # |
218 | ########################################### |
219 | |
a0249514 |
220 | if($type eq 'dbi'){ |
8a412596 |
221 | return <<'EOF'; |
88f2d2fd |
222 | [% MACRO printPackage(node) BLOCK %] |
efcd92a3 |
223 | |
919a1670 |
224 | ########[% node.table.name | ucfirst #node.name | replace("Turnkey${concat}::Model::", '') %]######## |
88f2d2fd |
225 | |
226 | package [% node.name %]; |
227 | use base '[% node.base %]'; |
228 | use Class::DBI::Pager; |
8dff25a5 |
229 | no warnings qw(redefine); |
88f2d2fd |
230 | |
231 | [% node.name %]->set_up_table('[% node.table.name %]'); |
232 | [% printPKAccessors(node.primary_key, node.table.name) %] |
233 | [% printHasA(node.edges, node) %] |
234 | [% printHasMany(node.edges, node) %] |
235 | [% printHasCompound(node.compoundedges, node.hyperedges, node.name) %] |
65157eda |
236 | [% #printHasFriendly(node) %] |
88f2d2fd |
237 | [% END %] |
88f2d2fd |
238 | [% MACRO printPKAccessors(array, name) BLOCK %] |
239 | # |
240 | # Primary key accessors |
241 | # |
a006efcb |
242 | |
88f2d2fd |
243 | [% FOREACH item = array %] |
a006efcb |
244 | [% IF item != "id" %]sub id { shift->[% item %] }[% END %] |
245 | [% IF item != name %]sub [% name %] { shift->[% item %] }[% END %] |
88f2d2fd |
246 | [% END %] |
65157eda |
247 | |
88f2d2fd |
248 | [% END %] |
88f2d2fd |
249 | [% MACRO printHasA(edges, name) BLOCK %] |
7611bcd7 |
250 | [% FOREACH edge = edges %] |
251 | [% IF loop.first() %] |
88f2d2fd |
252 | # |
253 | # Has A |
254 | # |
65157eda |
255 | |
7611bcd7 |
256 | [% END %] |
65157eda |
257 | [% IF edge.type == 'import' %] |
88f2d2fd |
258 | [% node.name %]->has_a([% edge.thisfield.name %] => '[% edge.thatnode.name %]'); |
65157eda |
259 | [% IF node.has(edge.thatnode.name) < 2 %] |
88f2d2fd |
260 | sub [% edge.thatnode.table.name %] { return shift->[% edge.thisfield.name %] } |
65157eda |
261 | [% ELSE %] |
88f2d2fd |
262 | sub [% format_fk(edge.thisnode.table.name,edge.thisfield.name) %] { return shift->[% edge.thisfield.name %] } |
65157eda |
263 | [% END %] |
65157eda |
264 | [% END %] |
88f2d2fd |
265 | [% END %] |
65157eda |
266 | |
88f2d2fd |
267 | [% END %] |
268 | |
269 | [% MACRO printHasMany(edges, node) BLOCK %] |
7611bcd7 |
270 | [% FOREACH edge = edges %] |
271 | [% IF loop.first() %] |
88f2d2fd |
272 | # |
273 | # Has Many |
274 | # |
65157eda |
275 | |
7611bcd7 |
276 | [% END %] |
65157eda |
277 | [% IF edge.type == 'export' %] |
a0249514 |
278 | [% node.name %]->has_many('[% edge.thatnode.table.name %]_[% edge.thatfield.name %]', '[% edge.thatnode.name %]' => '[% edge.thatfield.name %]'); |
65157eda |
279 | [% IF node.via(edge.thatnode.name) >= 1 %] |
88f2d2fd |
280 | sub [% edge.thatnode.table.name %]_[% format_fk(edge.thatnode.table.name,edge.thatfield.name) %]s { return shift->[% edge.thatnode.table.name %]_[% edge.thatfield.name %] } |
65157eda |
281 | [% ELSIF edge.thatnode.table.is_data %] |
282 | [% IF node.edgecount(edge.thatnode.name) > 1 %] |
283 | sub [% edge.thatnode.table.name %]_[% format_fk(edge.thatnode.name,edge.thatfield.name) %]s { return shift->[% edge.thatnode.table.name %]_[% edge.thatfield.name %] } |
284 | [% ELSE %] |
88f2d2fd |
285 | sub [% edge.thatnode.table.name %]s { return shift->[% edge.thatnode.table.name %]_[% edge.thatfield.name %] } |
65157eda |
286 | [% END %] |
287 | [% END %] |
0be4a1f8 |
288 | |
65157eda |
289 | [% END %] |
88f2d2fd |
290 | [% END %] |
65157eda |
291 | |
88f2d2fd |
292 | [% END %] |
88f2d2fd |
293 | [% MACRO printHasCompound(cedges,hedges,name) BLOCK %] |
7611bcd7 |
294 | [% FOREACH cedge = cedges %] |
295 | [% IF loop.first() %] |
88f2d2fd |
296 | # |
297 | # Has Compound Many |
298 | # |
7611bcd7 |
299 | [% END %] |
88f2d2fd |
300 | [% FOREACH edge = cedge.edges %] |
65157eda |
301 | [% NEXT IF edge.thisnode.name != name %] |
88f2d2fd |
302 | sub [% cedge.via.table.name %]_[% format_fk(edge.thatnode.table.name,edge.thatfield.name) %]s { return shift->[% cedge.via.table.name %]_[% edge.thatfield.name %] } |
303 | [% END %] |
304 | [% END %] |
65157eda |
305 | |
7611bcd7 |
306 | [% seen = 0 %] |
88f2d2fd |
307 | [% FOREACH h = hedges %] |
7611bcd7 |
308 | [% NEXT UNLESS h.type == 'one2one' %] |
efcd92a3 |
309 | [% IF seen == 0 ; seen = 1 %]# one2one #[% END %] |
d2fd0190 |
310 | sub [% h.thatnode.table.name %]s { my $self = shift; return map $_->[% h.thatviafield.name %], $self->[% h.vianode.table.name %]_[% h.thisviafield.name %] } |
7611bcd7 |
311 | [% END %] |
65157eda |
312 | |
7611bcd7 |
313 | [% seen = 0 %] |
314 | [% FOREACH h = hedges %] |
315 | [% NEXT UNLESS h.type == 'one2many' %] |
efcd92a3 |
316 | [% IF seen == 0 ; seen = 1 %]# one2many #[% END %] |
7611bcd7 |
317 | [% thisnode = h.thisnode_index(0) %] |
318 | [% i = 0 %] |
319 | [% FOREACH thatnode = h.thatnode %] |
320 | [% NEXT UNLESS h.thisviafield_index(i).name %] |
65157eda |
321 | #[% thisnode.name %]::[% h.thisfield_index(0).name %] -> [% h.vianode.name %]::[% h.thisviafield_index(i).name %] ... [% h.vianode.name %]::[% h.thatviafield_index(0).name %] <- [% h.thatnode_index(0).name %]::[% h.thatfield_index(0).name %] |
d2fd0190 |
322 | sub [% h.vianode.table.name %]_[% format_fk(h.vianode,h.thatviafield_index(0).name) %]s { my $self = shift; return map $_->[% h.thatviafield_index(0).name %], $self->[% h.vianode.table.name %]_[% h.thisviafield_index(i).name %] } |
7611bcd7 |
323 | [% i = i + 1 %] |
324 | [% END %] |
325 | [% END %] |
65157eda |
326 | |
7611bcd7 |
327 | [% seen = 0 %] |
328 | [% FOREACH h = hedges %] |
329 | [% NEXT UNLESS h.type == 'many2one' %] |
efcd92a3 |
330 | [% IF seen == 0 ; seen = 1 %]# many2one #[% END %] |
7611bcd7 |
331 | [% i = 0 %] |
332 | [% FOREACH thisnode = h.thisnode %] |
65157eda |
333 | #[% thisnode.name %]::[% h.thisfield_index(0).name %] -> [% h.vianode.name %]::[% h.thisviafield_index(i).name %] ... [% h.vianode.name %]::[% h.thatviafield_index(0).name %] <- [% h.thatnode_index(0).name %]::[% h.thatfield_index(0).name %] |
d2fd0190 |
334 | sub [% h.vianode.table.name %]_[% format_fk(h.vianode,h.thisviafield_index(i).name) %]_[% format_fk(h.vianode,h.thatviafield_index(0).name) %]s { my $self = shift; return map $_->[% h.thatviafield_index(0).name %], $self->[% h.vianode.table.name %]_[% h.thisviafield_index(i).name %] } |
7611bcd7 |
335 | [% i = i + 1 %] |
336 | [% END %] |
337 | [% END %] |
65157eda |
338 | |
7611bcd7 |
339 | [% seen = 0 %] |
340 | [% FOREACH h = hedges %] |
341 | [% NEXT UNLESS h.type == 'many2many' %] |
efcd92a3 |
342 | [% IF seen == 0 ; seen = 1 %]# many2many #[% END %] |
7611bcd7 |
343 | [% i = 0 %] |
344 | [% FOREACH thisnode = h.thisnode %] |
345 | [% j = 0 %] |
346 | [% FOREACH thatnode = h.thatnode %] |
65157eda |
347 | #[% thisnode.name %]::[% h.thisfield_index(i).name %] -> [% h.vianode.name %]::[% h.thisviafield_index(i).name %] ... [% h.vianode.name %]::[% h.thatviafield_index(j).name %] <- [% h.thatnode_index(j).name %]::[% h.thatfield_index(j).name %] |
d2fd0190 |
348 | sub [% h.vianode.table.name %]_[% format_fk(h.vianode,h.thisviafield_index(i).name) %]_[% format_fk(h.vianode,h.thatviafield_index(j).name) %]s { my $self = shift; return map $_->[% h.vianode.table.name %]_[% format_fk(h.vianode,h.thatviafield_index(j).name) %]s, $self->[% h.vianode.table.name %]_[% format_fk(h.vianode,h.thisviafield_index(i).name) %]s } |
7611bcd7 |
349 | [% j = j + 1 %] |
65157eda |
350 | [% END %] |
7611bcd7 |
351 | [% i = i + 1 %] |
65157eda |
352 | [% END %] |
88f2d2fd |
353 | [% END %] |
7a9287a9 |
354 | 1; |
88f2d2fd |
355 | [% END %] |
d8dc07e7 |
356 | [% MACRO printHasFriendly(node) BLOCK %] |
357 | # |
358 | # Has Friendly |
359 | # |
7611bcd7 |
360 | #FIXME, why aren't these being generated? |
a0249514 |
361 | |
d8dc07e7 |
362 | [% END %] |
88f2d2fd |
363 | [% MACRO printList(array) BLOCK %][% FOREACH item = array %][% item %] [% END %][% END %] |
efcd92a3 |
364 | |
ebee7d95 |
365 | ########AutoDBI######## |
919a1670 |
366 | use Turnkey[% concat %]::Model::DBI; |
efcd92a3 |
367 | [% FOREACH node = nodes %] |
368 | use [% node.value.name %]; |
369 | [% END %] |
370 | 1; |
371 | |
919a1670 |
372 | ########DBI######## |
88f2d2fd |
373 | package [% baseclass %]; |
374 | |
375 | # Created by SQL::Translator::Producer::Turnkey |
376 | # Template used: classdbi |
377 | |
378 | use strict; |
f552aa62 |
379 | use Data::Dumper; |
f890ae86 |
380 | no warnings 'redefine'; |
88f2d2fd |
381 | use base qw(Class::DBI::Pg); |
382 | |
c051e2bb |
383 | [% baseclass %]->set_db('Main', '[% db_dsn %]', '[% db_user %]', '[% db_pass %]'); |
edee0655 |
384 | sub search_ilike { shift->_do_search(ILIKE => [% "\@\_" %] ) } |
79989cde |
385 | sub search_lower { |
386 | my $c = shift; |
387 | my %q = @_; |
388 | my %t; |
389 | foreach my $k (keys %q){ |
390 | $t{"lower($k)"} = lc($q{$k}); |
391 | } |
392 | $c->_do_search(LIKE => %t); |
393 | } |
394 | |
edee0655 |
395 | |
28ae4732 |
396 | # debug method |
397 | sub dump { |
398 | my $self = shift; |
79989cde |
399 | my %arg = %{shift @_}; |
400 | $arg{'indent'} ||= 1; |
401 | $arg{'depth'} ||= 3; |
402 | $Data::Dumper::Maxdepth = $arg{'depth'} if defined $arg{'depth'}; |
403 | $Data::Dumper::Indent = $arg{'indent'} if defined $arg{'indent'}; |
404 | return(Dumper($arg{'object'})); |
28ae4732 |
405 | } |
88f2d2fd |
406 | |
7a9287a9 |
407 | 1; |
efcd92a3 |
408 | |
efcd92a3 |
409 | [% FOREACH node = nodes %][% printPackage(node.value) %][% END %] |
88f2d2fd |
410 | EOF |
a0249514 |
411 | } |
412 | |
bf46ec51 |
413 | elsif($type eq 'soap'){ |
414 | return <<'EOF'; |
415 | [% FOREACH node = nodes %][% node.value.name %], [%- END -%] |
416 | EOF |
417 | } |
a0249514 |
418 | |
419 | elsif($type eq 'atom'){ |
88f2d2fd |
420 | |
d8dc07e7 |
421 | return <<'EOF'; |
efcd92a3 |
422 | [% # DOCUMENT START # %] |
c00bb9f8 |
423 | |
ebee7d95 |
424 | ########AutoAtom######## |
7a9287a9 |
425 | [% FOREACH node = nodes %] |
426 | use [% node.value.name %]; |
427 | [% END %] |
428 | 1; |
429 | |
a0249514 |
430 | [% FOREACH node = nodes %] |
63c988ed |
431 | [% IF !node.value.is_trivial_link %] |
c00bb9f8 |
432 | |
919a1670 |
433 | ########[% node.value.name | replace('.+::', '') %]######## |
c00bb9f8 |
434 | |
919a1670 |
435 | package Turnkey[% concat %]::Atom::[% node.value.name FILTER replace '.+::', '' %]; |
c00bb9f8 |
436 | |
919a1670 |
437 | [% pname = node.value.name FILTER replace '.+::', '' %] |
63c988ed |
438 | |
919a1670 |
439 | use base qw(Turnkey[% concat %]::Atom); |
c00bb9f8 |
440 | use Data::Dumper; |
441 | |
442 | sub can_render { |
443 | return 1; |
444 | } |
445 | |
446 | sub render { |
447 | my $self = shift; |
448 | my $dbobject = shift; |
c01582e9 |
449 | |
450 | # Assumption here that if it's not rendering on it's own dbobject |
451 | # then it's a list. This will be updated when AtomLists are implemented -boconnor |
919a1670 |
452 | if(ref($dbobject) eq 'Turnkey[% concat %]::Model::[% pname %]') { |
c01582e9 |
453 | $self->focus('yes'); |
c00bb9f8 |
454 | return(_render_record($dbobject)); |
455 | } |
456 | else { return(_render_list($dbobject)); } |
457 | } |
458 | |
459 | sub _render_record { |
460 | my $dbobject = shift; |
461 | my @output = (); |
462 | my $row = {}; |
463 | my $field_hash = {}; |
8bba52b2 |
464 | |
465 | #data |
a0249514 |
466 | [% FOREACH value = node.value.data_fields %] |
816ce4b6 |
467 | [% IF value != 1 %] |
468 | $field_hash->{[% value.key %]} = $dbobject->[% value.key %](); |
8bba52b2 |
469 | [% END %] |
470 | [% END %] |
471 | |
472 | #keys |
473 | [% FOREACH value = node.value.edges %] |
474 | [% NEXT IF value.type != 'import' %] |
475 | $field_hash->{[% value.thisfield.name %]} = $dbobject->[% value.thisfield.name %](); |
476 | [% END %] |
477 | |
c00bb9f8 |
478 | $row->{data} = $field_hash; |
479 | $row->{id} = $dbobject->id(); |
480 | push @output, $row; |
481 | return(\@output); |
482 | } |
483 | |
484 | sub _render_list { |
485 | my $dbobject = shift; |
486 | my @output = (); |
88f2d2fd |
487 | my @objects = $dbobject->[% node.key %]s; |
c01582e9 |
488 | foreach my $object (@objects){ |
c00bb9f8 |
489 | my $row = {}; |
c01582e9 |
490 | my $field_hash = {}; |
8bba52b2 |
491 | |
c01582e9 |
492 | #data |
8bba52b2 |
493 | [% FOREACH value = node.value.data_fields %] |
494 | [% IF value != 1 %] |
816ce4b6 |
495 | $field_hash->{[% value.key %]} = $object->[% value.key %](); |
8bba52b2 |
496 | [% END %] |
497 | [% END %] |
498 | |
c01582e9 |
499 | #keys |
500 | [% FOREACH value = node.value.edges %] |
501 | [% NEXT IF value.type != 'import' %] |
502 | $field_hash->{[% value.thisfield.name %]} = $object->[% value.thisfield.name %](); |
503 | [% END %] |
8bba52b2 |
504 | |
c00bb9f8 |
505 | $row->{data} = $field_hash; |
c01582e9 |
506 | $row->{id} = $object->id(); |
507 | push @output, $row; |
508 | } |
c00bb9f8 |
509 | return(\@output); |
510 | } |
511 | |
512 | sub head { |
513 | return 1; |
514 | } |
515 | |
516 | 1; |
a0249514 |
517 | [% END %] |
c00bb9f8 |
518 | [% END %] |
519 | EOF |
520 | |
d8dc07e7 |
521 | } elsif($type eq 'xml'){ |
8a412596 |
522 | return <<'EOF'; |
c00bb9f8 |
523 | <?xml version="1.0" encoding="UTF-8"?> |
63c988ed |
524 | <!DOCTYPE Turnkey SYSTEM "Turnkey.dtd"> |
525 | <Turnkey> |
c00bb9f8 |
526 | |
527 | <!-- The basic layout is fixed --> |
4097689d |
528 | <container orientation="vertical" type="Container" label="RootContainer"> |
529 | <container orientation="horizontal" type="Container" label="MiddleContainer"> |
530 | <container align="center" class="leftbar" orientation="vertical" type="minor" label="MidLeftContainer"/> |
531 | <container orientation="vertical" type="major" label="MainContainer"/> |
c00bb9f8 |
532 | </container> |
533 | </container> |
534 | |
535 | <!-- Atom Classes --> |
63c988ed |
536 | [% FOREACH node = nodes %] |
537 | [% IF !node.value.is_trivial_link %] |
4097689d |
538 | <atom class="[% format_table(node.key) %]" name="[% format_table(node.key) %]" label="[% format_table(node.key) %]Atom"/> |
69c7a62f |
539 | [%- END -%] |
63c988ed |
540 | [% END %] |
79989cde |
541 | <!-- custom --> |
542 | <atom class="Frontpage" name="Frontpage" label="FrontpageAtom"/> |
543 | <atom class="Search" name="Search" label="SearchAtom"/> |
544 | <atom class="Userinfo" name="UserInfo" label="UserinfoAtom"/> |
545 | <!-- custom --> |
546 | |
c00bb9f8 |
547 | |
548 | <!-- Atom Bindings --> |
549 | <atomatombindings> |
63c988ed |
550 | [% FOREACH focus_atom = nodes %] |
551 | [% IF !focus_atom.value.is_trivial_link %] |
552 | [% FOREACH link_atom = focus_atom.value.hyperedges %] |
4097689d |
553 | <atomatombinding from="#[% format_table(focus_atom.key) %]Atom" to="#[% format_table(link_atom.thatnode.table.name) %]Atom" label="[% format_table(focus_atom.key) %]Atom2[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
69c7a62f |
554 | [%- END -%] |
63c988ed |
555 | [% previous = "" %] |
556 | [% FOREACH link_atom = focus_atom.value.edges %] |
557 | [% IF link_atom.type == 'export' && previous != link_atom.thatnode.table.name && link_atom.thatnode.table.name != "" %] |
4097689d |
558 | <atomatombinding from="#[% format_table(focus_atom.key) %]Atom" to="#[% format_table(link_atom.thatnode.table.name) %]Atom" label="[% format_table(focus_atom.key) %]Atom2[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
559 | [% previous = link_atom.thatnode.table.name %] |
560 | [% END %] |
561 | [%- END %] |
69c7a62f |
562 | [%- END -%] |
63c988ed |
563 | [% END %] |
c00bb9f8 |
564 | </atomatombindings> |
565 | |
83a42239 |
566 | <layouts> |
63c988ed |
567 | [% FOREACH focus_atom = nodes %] |
568 | [% IF !focus_atom.value.is_trivial_link %] |
4097689d |
569 | <layout label="[% format_table(focus_atom.key) %]"> |
63c988ed |
570 | [% FOREACH link_atom = focus_atom.value.hyperedges %] |
4097689d |
571 | <placement from="#MidLeftContainer" label="MidLeftContainer2[% format_table(link_atom.thatnode.table.name) %]Atom" to="#[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
572 | [%- END%] |
573 | [% previous = "" %] |
574 | [% FOREACH link_atom = focus_atom.value.edges %] |
575 | [% IF link_atom.type == 'export' && previous != link_atom.thatnode.table.name %] |
4097689d |
576 | <placement from="#MidLeftContainer" label="MidLeftContainer2[% format_table(link_atom.thatnode.table.name) %]Atom" to="#[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
577 | [% previous = link_atom.thatnode.table.name %] |
578 | [% END %] |
579 | [%- END %] |
4097689d |
580 | <placement from="#MainContainer" label="MainContainer2[% format_table(focus_atom.key) %]Atom" to="#[% format_table(focus_atom.key) %]Atom"/> |
6124b910 |
581 | </layout> |
63c988ed |
582 | [%- END %] |
583 | [% END %] |
919a1670 |
584 | <!-- custom FIXME remove --> |
585 | <layout label="Turnkey[% concat%]::Util::Frontpage"> |
79989cde |
586 | <placement from="#MainContainer" label="MainContainer2AnalysisAtom" to="#FrontpageAtom"/> |
587 | </layout> |
919a1670 |
588 | <layout label="Turnkey[% concat %]::Util::Search"> |
79989cde |
589 | <placement from="#MainContainer" label="MainContainer2AnalysisAtom" to="#SearchAtom"/> |
590 | </layout> |
919a1670 |
591 | <layout label="Turnkey[% concat %]::Util::Userinfo"> |
79989cde |
592 | <placement from="#MainContainer" label="MainContainer2UserinfoAtom" to="#UserinfoAtom"/> |
593 | </layout> |
594 | <!-- custom --> |
83a42239 |
595 | </layouts> |
69c7a62f |
596 | |
597 | <uribindings> |
919a1670 |
598 | <uribinding uri="/db" class="Turnkey[% concat%]::Util::Frontpage"/> |
599 | <uribinding uri="/db/search" class="Turnkey[% concat %]::Util::Search"/> |
600 | <uribinding uri="/db/userinfo" class="Turnkey[% concat %]::Util::Userinfo"/> |
69c7a62f |
601 | </uribindings> |
602 | |
603 | <classbindings> |
63c988ed |
604 | [% FOREACH focus_atom = nodes %] |
605 | [% IF !focus_atom.value.is_trivial_link %] |
83a42239 |
606 | <classbinding class="[% format_table(focus_atom.key) %]" plugin="#[% format_table(focus_atom.key) %]Atom" rank="0"/> |
69c7a62f |
607 | [%- END -%] |
63c988ed |
608 | [% END %] |
79989cde |
609 | <!-- custom --> |
919a1670 |
610 | <classbinding class="Turnkey[% concat %]::Util::Frontpage" plugin="#FrontpageAtom" rank="0"/> |
611 | <classbinding class="Turnkey[% concat %]::Util::Search" plugin="#SearchAtom" rank="0"/> |
612 | <classbinding class="Turnkey[% concat %]::Util::Userinfo" plugin="#UserinfoAtom" rank="0"/> |
79989cde |
613 | <!-- custom --> |
69c7a62f |
614 | </classbindings> |
c00bb9f8 |
615 | |
63c988ed |
616 | </Turnkey> |
c00bb9f8 |
617 | EOF |
618 | |
d8dc07e7 |
619 | } elsif($type eq 'template'){ |
620 | return <<'EOF'; |
c00bb9f8 |
621 | [% TAGS [- -] %] |
82cedef0 |
622 | [% MACRO renderpanel(panel,name,dbobject) BLOCK %] |
c00bb9f8 |
623 | <!-- begin panel: [% panel.label %] --> |
c00bb9f8 |
624 | [% FOREACH p = panel.containers %] |
625 | [% IF p.can_render(panel) %] |
c00bb9f8 |
626 | [% IF p.type == 'Container' %] |
82cedef0 |
627 | [% renderpanel(p,name,dbobject) %] |
c00bb9f8 |
628 | [% ELSE %] |
82cedef0 |
629 | [% IF p.type == 'major' %] |
e204c7c7 |
630 | <div class="middle"><div class="column-in"> |
82cedef0 |
631 | [% IF name %] |
632 | <div class="middle-header">[% name %]</div> |
e204c7c7 |
633 | [% END %] |
c00bb9f8 |
634 | <!-- begin atom: [% p.label %] --> |
dbbe24ef |
635 | <!-- table cellpadding="0" cellspacing="0" width="100%" --><!-- [% ref(atom) %] [% ref(dbobject) %] --> |
82cedef0 |
636 | [% renderatom(name,dbobject,p.containers[0]) %] |
dbbe24ef |
637 | <!-- /table --> |
e204c7c7 |
638 | </div></div> |
639 | <div class="cleaner"></div> |
82cedef0 |
640 | [% ELSIF p.type == 'minor' %] |
e204c7c7 |
641 | <div class="left"><div class="column-in"> |
c7a9e95b |
642 | [% FOREACH atom = p.containers %] |
e204c7c7 |
643 | <div class="left-item"> |
82cedef0 |
644 | [% IF name %] |
645 | [% linkname = ref(p.containers[0]) %] |
919a1670 |
646 | <div class="box-header">[% atom.name | replace("Turnkey${concat}::Atom::", '') %]</div> |
e204c7c7 |
647 | [% END %] |
648 | <!-- begin atom: [% p.label %] --> |
dbbe24ef |
649 | <!-- table cellpadding="0" cellspacing="0" width="100%" --><!-- [% ref(atom) %] [% ref(dbobject) %] --> |
c7a9e95b |
650 | [% renderatom(name,dbobject,atom) %] |
dbbe24ef |
651 | <!-- /table --> |
c7a9e95b |
652 | </div> |
653 | [% END %] |
654 | </div></div> |
e204c7c7 |
655 | [% END %] |
c00bb9f8 |
656 | [% END %] |
c00bb9f8 |
657 | [% IF panel.orientation == 'vertical' %] |
c00bb9f8 |
658 | [% END %] |
659 | [% END %] |
660 | [% END %] |
e204c7c7 |
661 | |
c00bb9f8 |
662 | <!-- end panel: [% panel.label %] --> |
e204c7c7 |
663 | |
c00bb9f8 |
664 | [% END %] |
8bba52b2 |
665 | [% BLOCK make_linked_dbobject %] |
666 | [% PERL %] |
667 | $stash->set(linked_dbobject => [% class %]->retrieve([% id %])); |
668 | [% END %] |
669 | [% END %] |
670 | [% MACRO obj2link(obj) SWITCH ref(obj) %] |
671 | [% CASE '' %] |
672 | [% obj %] |
673 | [% CASE DEFAULT %] |
674 | [% IF obj.name %] |
675 | <a href="[% obj2url(obj) %]">[% obj.name %]</a> |
676 | [% ELSE %] |
677 | <a href="[% obj2url(obj) %]">[% obj %]</a> |
678 | [% END %] |
679 | [% END %] |
680 | [% MACRO obj2url(obj) SWITCH obj %] |
681 | [% CASE DEFAULT %] |
e6c65ff9 |
682 | /db/[% ref(obj) | replace('.+::','') %]/[% obj %] |
8bba52b2 |
683 | [% END %] |
79989cde |
684 | <!-- the above method should be updated when additional namespaces are used --> |
8bba52b2 |
685 | [% MACRO obj2desc(obj) SWITCH ref(obj) %] |
686 | [% CASE '' %] |
687 | [% obj %] |
688 | [% CASE DEFAULT %] |
689 | [% IF obj.value %] |
690 | [% obj.value %] |
691 | [% ELSE %] |
692 | [% obj %] |
693 | [% END %] |
694 | [% END %] |
82cedef0 |
695 | [% MACRO renderatom(name, dbobject, atom) SWITCH name %] |
7fbe3b98 |
696 | [- FOREACH node = nodes -] |
697 | [- IF !node.value.is_trivial_link -] |
43167a31 |
698 | [% CASE '[- format_table(node.key) -]' %] |
147d59b4 |
699 | [% INCLUDE [- format_table(node.key) | lower -].tt2 %] |
c00bb9f8 |
700 | [- END -] |
7fbe3b98 |
701 | [- END -] |
c00bb9f8 |
702 | [% CASE DEFAULT %] |
703 | [% renderlist(atom.render(dbobject)) %] |
704 | [% END %] |
bc0cf6eb |
705 | [% MACRO renderlist(lstArr) BLOCK %] |
dbbe24ef |
706 | <div class="left-item"> |
707 | <ul> |
bc0cf6eb |
708 | [% FOREACH item = lstArr %] |
c01582e9 |
709 | [% class = ref(atom) | replace('::Atom::', '::Model::') %] |
bc0cf6eb |
710 | [% id = item.id %] |
c01582e9 |
711 | [% PROCESS make_linked_dbobject %] |
712 | <li class="minorfocus">[% obj2link(linked_dbobject) %]</li> |
713 | [% END %] |
dbbe24ef |
714 | </ul> |
715 | </div> |
c00bb9f8 |
716 | [% END %] |
bc0cf6eb |
717 | EOF |
718 | |
719 | } elsif($type eq 'atomtemplate') { |
720 | return <<'EOF'; |
721 | [%- TAGS [- -] -%] |
722 | [-- IF !node.is_trivial_link --] |
82cedef0 |
723 | [% records = atom.render(dbobject) %] |
bc0cf6eb |
724 | [% rowcount = 0 %] |
725 | [% IF atom.focus == "yes" %] |
82cedef0 |
726 | [% FOREACH record = records %] |
727 | [% fields = record.data %] |
e204c7c7 |
728 | <table> |
bc0cf6eb |
729 | [- FOREACH field = node.data_fields -] |
730 | [- IF field != "1" -] |
e66764e5 |
731 | <tr><td class="dbfieldname">[- field.key -]</td><td class="dbfieldvalue">[% obj2link(fields.[- field.key -]) %]</td></tr> |
bc0cf6eb |
732 | [- END -] |
733 | [- END -] |
734 | [- FOREACH field = node.edges -] |
735 | [- NEXT IF field.type != 'import' -] |
736 | <tr><td class="dbfieldname">[- field.thisfield.name -]</td><td class="dbfieldvalue">[% obj2link(fields.[- field.thisfield.name -]) %]</td></tr> |
737 | [- END -] |
bc0cf6eb |
738 | [% IF (rowcount > 1) %] <tr><td colspan="2"><hr></td></tr> [% END %] |
739 | [% rowcount = rowcount + 1 %] |
e204c7c7 |
740 | </table> |
82cedef0 |
741 | [% END %] |
bc0cf6eb |
742 | [% ELSE %] |
e204c7c7 |
743 | <ul> |
8c54bff0 |
744 | [% FOREACH record = atom.render(dbobject) %] |
8bba52b2 |
745 | [% class = ref(atom) | replace('::Atom::', '::Model::') %] |
8c54bff0 |
746 | [% id = record.id #needed by make_linked_dbobject macro %] |
8bba52b2 |
747 | [% PROCESS make_linked_dbobject %] |
c01582e9 |
748 | <li class="minorfocus">[% obj2link(linked_dbobject) %]</li> |
c00bb9f8 |
749 | [% END %] |
dbbe24ef |
750 | </ul> |
c00bb9f8 |
751 | [% END %] |
bc0cf6eb |
752 | [- END -] |
c00bb9f8 |
753 | EOF |
754 | |
d8dc07e7 |
755 | } |
756 | } |
bc0cf6eb |
757 | |
758 | 1; |