Commit | Line | Data |
88f2d2fd |
1 | package SQL::Translator::Producer::Turnkey; |
c00bb9f8 |
2 | |
dd6fb3de |
3 | # ------------------------------------------------------------------- |
977651a5 |
4 | # $Id: Turnkey.pm,v 1.22 2004-02-09 23:02:17 kycl4rk 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 ]; |
977651a5 |
25 | $VERSION = sprintf "%d.%02d", q$Revision: 1.22 $ =~ /(\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; |
33 | use Template; |
34 | |
d8dc07e7 |
35 | my %producer2dsn = ( |
c00bb9f8 |
36 | MySQL => 'mysql', |
37 | PostgreSQL => 'Pg', |
38 | Oracle => 'Oracle', |
39 | ); |
40 | |
41 | # ------------------------------------------------------------------- |
42 | sub produce { |
1da10402 |
43 | my $log = Log::Log4perl->get_logger('SQL.Translator.Producer.Turnkey'); |
65157eda |
44 | |
c00bb9f8 |
45 | my $t = shift; |
46 | my $create = undef; |
c00bb9f8 |
47 | my $args = $t->producer_args; |
d8dc07e7 |
48 | my $no_comments = $t->no_comments; |
49 | my $baseclass = $args->{'main_pkg_name'} || $t->format_package_name('DBI'); |
65157eda |
50 | my $graph = SQL::Translator::Schema::Graph->new(translator => $t, |
51 | baseclass => $baseclass |
52 | ); |
c00bb9f8 |
53 | |
88f2d2fd |
54 | my $parser_type = (split /::/, $t->parser_type)[-1]; |
55 | |
56 | local $DEBUG = $t->debug; |
57 | |
58 | my %meta = ( |
59 | format_fk => $t->format_fk_name, |
bed83b64 |
60 | format_package => $t->format_package_name, |
43167a31 |
61 | format_table => $t->format_table_name, |
88f2d2fd |
62 | template => $args->{'template'} || '', |
d8dc07e7 |
63 | baseclass => $baseclass, |
35276d8c |
64 | db_dsn => $args->{'db_dsn'} || '', |
88f2d2fd |
65 | db_user => $args->{'db_user'} || '', |
66 | db_pass => $args->{'db_pass'} || '', |
cf927f90 |
67 | db_str => $args->{'db_str'} || '', |
88f2d2fd |
68 | parser => $t->parser_type, |
69 | producer => __PACKAGE__, |
d8dc07e7 |
70 | dsn => $args->{'dsn'} || sprintf( 'dbi:%s:_', $producer2dsn{ $parser_type } |
71 | ? $producer2dsn{ $parser_type } |
88f2d2fd |
72 | : $parser_type |
73 | ) |
74 | ); |
75 | |
69c7a62f |
76 | # |
c8515c9f |
77 | # create methods |
69c7a62f |
78 | # |
d8dc07e7 |
79 | foreach my $node_from ($graph->node_values){ |
65157eda |
80 | |
81 | next unless $node_from->table->is_data or !$node_from->table->is_trivial_link; |
82 | |
88f2d2fd |
83 | foreach my $cedge ( $node_from->compoundedges ){ |
69c7a62f |
84 | |
d8dc07e7 |
85 | my $hyperedge = SQL::Translator::Schema::Graph::HyperEdge->new(); |
c8515c9f |
86 | |
d8dc07e7 |
87 | my $node_to; |
88f2d2fd |
88 | foreach my $edge ($cedge->edges){ |
89 | if($edge->thisnode->name eq $node_from->name){ |
90 | $hyperedge->vianode($edge->thatnode); |
c8515c9f |
91 | |
88f2d2fd |
92 | if($edge->thatnode->name ne $cedge->via->name){ |
d8dc07e7 |
93 | $node_to ||= $graph->node($edge->thatnode->table->name); |
88f2d2fd |
94 | } |
c8515c9f |
95 | |
d8dc07e7 |
96 | $hyperedge->push_thisnode($edge->thisnode); |
97 | $hyperedge->push_thisfield($edge->thisfield); |
98 | $hyperedge->push_thisviafield($edge->thatfield); |
c8515c9f |
99 | |
88f2d2fd |
100 | } else { |
88f2d2fd |
101 | if($edge->thisnode->name ne $cedge->via->name){ |
d8dc07e7 |
102 | $node_to ||= $graph->node($edge->thisnode->table->name); |
88f2d2fd |
103 | } |
d8dc07e7 |
104 | $hyperedge->push_thatnode($edge->thisnode); |
105 | $hyperedge->push_thatfield($edge->thisfield); |
106 | $hyperedge->push_thatviafield($edge->thatfield); |
88f2d2fd |
107 | } |
65157eda |
108 | $log->debug($edge->thisfield->name); |
109 | $log->debug($edge->thatfield->name); |
88f2d2fd |
110 | } |
65157eda |
111 | |
88f2d2fd |
112 | if($hyperedge->count_thisnode == 1 and $hyperedge->count_thatnode == 1){ $hyperedge->type('one2one') } |
113 | elsif($hyperedge->count_thisnode > 1 and $hyperedge->count_thatnode == 1){ $hyperedge->type('many2one') } |
114 | elsif($hyperedge->count_thisnode == 1 and $hyperedge->count_thatnode > 1){ $hyperedge->type('one2many') } |
115 | elsif($hyperedge->count_thisnode > 1 and $hyperedge->count_thatnode > 1){ $hyperedge->type('many2many') } |
116 | |
1da10402 |
117 | $log->debug($_) foreach sort keys %::SQL::Translator::Schema::Graph::HyperEdge::; |
65157eda |
118 | |
119 | #node_to won't always be defined b/c of multiple edges to a single other node |
120 | if(defined($node_to)){ |
121 | $log->debug($node_from->name); |
122 | $log->debug($node_to->name); |
123 | |
124 | if(scalar($hyperedge->thisnode) > 1){ |
125 | $log->debug($hyperedge->type ." via ". $hyperedge->vianode->name); |
126 | my $i = 0; |
127 | foreach my $thisnode ( $hyperedge->thisnode ){ |
128 | $log->debug($thisnode->name .' '. |
129 | $hyperedge->thisfield_index(0)->name .' -> '. |
130 | $hyperedge->thisviafield_index($i)->name .' '. |
131 | $hyperedge->vianode->name .' '. |
132 | $hyperedge->thatviafield_index(0)->name .' <- '. |
133 | $hyperedge->thatfield_index(0)->name .' '. |
134 | $hyperedge->thatnode_index(0)->name ."\n" |
135 | ); |
136 | $i++; |
137 | } |
d8dc07e7 |
138 | } |
65157eda |
139 | $node_from->push_hyperedges($hyperedge); |
d8dc07e7 |
140 | } |
88f2d2fd |
141 | } |
c8515c9f |
142 | } |
d8dc07e7 |
143 | $meta{"nodes"} = $graph->node; |
88f2d2fd |
144 | return(translateForm($t, \%meta)); |
c00bb9f8 |
145 | } |
146 | |
d8dc07e7 |
147 | sub translateForm { |
148 | my $t = shift; |
149 | my $meta = shift; |
a0249514 |
150 | |
151 | |
1da10402 |
152 | #"Node Data:\n"; |
153 | #warn Dumper $meta->{nodes}; |
a0249514 |
154 | #exit; |
155 | |
d8dc07e7 |
156 | my $args = $t->producer_args; |
157 | my $type = $meta->{'template'}; |
158 | my $tt2; |
159 | $tt2 = template($type); |
160 | my $template = Template->new({ |
65157eda |
161 | PRE_CHOMP => 1, |
162 | POST_CHOMP => 0, |
d8dc07e7 |
163 | EVAL_PERL => 1 |
164 | }); |
165 | |
166 | my $result; |
d8dc07e7 |
167 | $template->process(\$tt2, $meta, \$result) || die $template->error(); |
168 | return($result); |
169 | } |
170 | |
171 | 1; |
172 | |
173 | # ------------------------------------------------------------------- |
174 | |
175 | =pod |
176 | |
177 | =head1 NAME |
178 | |
179 | SQL::Translator::Producer::Turnkey - create Turnkey classes from schema |
180 | |
181 | =head1 SYNOPSIS |
182 | |
183 | Creates output for use with the Turnkey project. |
184 | |
185 | =head1 SEE ALSO |
186 | |
187 | L<http://turnkey.sourceforge.net>. |
188 | |
189 | =head1 AUTHORS |
190 | |
191 | Allen Day E<lt>allenday@ucla.eduE<gt> |
d8dc07e7 |
192 | Brian O\'Connor E<lt>brian.oconnor@excite.comE<gt>. |
193 | |
194 | =cut |
195 | |
196 | sub template { |
197 | my $type = shift; |
198 | |
c00bb9f8 |
199 | ########################################### |
200 | # Here documents for the tt2 templates # |
201 | ########################################### |
202 | |
a0249514 |
203 | if($type eq 'dbi'){ |
d8dc07e7 |
204 | return <<EOF; |
88f2d2fd |
205 | [% MACRO printPackage(node) BLOCK %] |
206 | # -------------------------------------------- |
207 | |
208 | package [% node.name %]; |
209 | use base '[% node.base %]'; |
210 | use Class::DBI::Pager; |
211 | |
212 | [% node.name %]->set_up_table('[% node.table.name %]'); |
213 | [% printPKAccessors(node.primary_key, node.table.name) %] |
214 | [% printHasA(node.edges, node) %] |
215 | [% printHasMany(node.edges, node) %] |
216 | [% printHasCompound(node.compoundedges, node.hyperedges, node.name) %] |
65157eda |
217 | [% #printHasFriendly(node) %] |
88f2d2fd |
218 | [% END %] |
219 | |
a0249514 |
220 | # MACRO |
221 | |
88f2d2fd |
222 | [% MACRO printPKAccessors(array, name) BLOCK %] |
223 | # |
224 | # Primary key accessors |
225 | # |
226 | [% FOREACH item = array %] |
227 | sub id { shift->[% item %] } |
228 | sub [% name %] { shift->[% item %] } |
229 | [% END %] |
65157eda |
230 | |
88f2d2fd |
231 | [% END %] |
232 | |
233 | [% MACRO printHasA(edges, name) BLOCK %] |
234 | # |
235 | # Has A |
236 | # |
65157eda |
237 | |
88f2d2fd |
238 | [% FOREACH edge = edges %] |
65157eda |
239 | [% IF edge.type == 'import' %] |
88f2d2fd |
240 | [% node.name %]->has_a([% edge.thisfield.name %] => '[% edge.thatnode.name %]'); |
65157eda |
241 | [% IF node.has(edge.thatnode.name) < 2 %] |
88f2d2fd |
242 | sub [% edge.thatnode.table.name %] { return shift->[% edge.thisfield.name %] } |
65157eda |
243 | [% ELSE %] |
88f2d2fd |
244 | sub [% format_fk(edge.thisnode.table.name,edge.thisfield.name) %] { return shift->[% edge.thisfield.name %] } |
65157eda |
245 | [% END %] |
246 | |
247 | [% END %] |
88f2d2fd |
248 | [% END %] |
65157eda |
249 | |
88f2d2fd |
250 | [% END %] |
251 | |
252 | [% MACRO printHasMany(edges, node) BLOCK %] |
253 | # |
254 | # Has Many |
255 | # |
65157eda |
256 | |
88f2d2fd |
257 | [% FOREACH edge = edges %] |
65157eda |
258 | [% IF edge.type == 'export' %] |
a0249514 |
259 | [% node.name %]->has_many('[% edge.thatnode.table.name %]_[% edge.thatfield.name %]', '[% edge.thatnode.name %]' => '[% edge.thatfield.name %]'); |
65157eda |
260 | [% IF node.via(edge.thatnode.name) >= 1 %] |
88f2d2fd |
261 | 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 |
262 | [% ELSIF edge.thatnode.table.is_data %] |
263 | [% IF node.edgecount(edge.thatnode.name) > 1 %] |
264 | sub [% edge.thatnode.table.name %]_[% format_fk(edge.thatnode.name,edge.thatfield.name) %]s { return shift->[% edge.thatnode.table.name %]_[% edge.thatfield.name %] } |
265 | [% ELSE %] |
88f2d2fd |
266 | sub [% edge.thatnode.table.name %]s { return shift->[% edge.thatnode.table.name %]_[% edge.thatfield.name %] } |
65157eda |
267 | [% END %] |
268 | [% END %] |
269 | |
270 | [% END %] |
88f2d2fd |
271 | [% END %] |
65157eda |
272 | |
88f2d2fd |
273 | [% END %] |
274 | |
275 | [% MACRO printHasCompound(cedges,hedges,name) BLOCK %] |
276 | # |
277 | # Has Compound Many |
278 | # |
279 | [% FOREACH cedge = cedges %] |
280 | [% FOREACH edge = cedge.edges %] |
65157eda |
281 | [% NEXT IF edge.thisnode.name != name %] |
88f2d2fd |
282 | sub [% cedge.via.table.name %]_[% format_fk(edge.thatnode.table.name,edge.thatfield.name) %]s { return shift->[% cedge.via.table.name %]_[% edge.thatfield.name %] } |
283 | [% END %] |
284 | [% END %] |
65157eda |
285 | |
88f2d2fd |
286 | [% FOREACH h = hedges %] |
65157eda |
287 | ########## [% h.type %] ########## |
288 | [% IF h.type == 'one2one' %] |
289 | sub [% h.thatnode.table.name %]s { my \$self = shift; return map \$_->[% h.thatviafield.name %], \$self->[% h.vianode.table.name %]_[% h.thisviafield.name %] } |
290 | |
291 | [% ELSIF h.type == 'one2many' %] |
292 | [% thisnode = h.thisnode_index(0) %] |
293 | [% i = 0 %] |
294 | [% FOREACH thatnode = h.thatnode %] |
295 | #[% 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 %] |
296 | 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 %] } |
297 | [% i = i + 1 %] |
298 | [% END %] |
299 | |
300 | [% ELSIF h.type == 'many2one' %] |
301 | [% i = 0 %] |
d8dc07e7 |
302 | [% FOREACH thisnode = h.thisnode %] |
65157eda |
303 | #[% 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 %] |
304 | 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 %] } |
305 | [% i = i + 1 %] |
306 | |
d8dc07e7 |
307 | [% END %] |
65157eda |
308 | |
309 | [% ELSIF h.type == 'many2many' %] |
310 | [% i = 0 %] |
311 | [% FOREACH thisnode = h.thisnode %] |
312 | [% j = 0 %] |
313 | [% FOREACH thatnode = h.thatnode %] |
314 | #[% 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 %] |
315 | 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 \$_->[% %], \$self->[% %] } |
316 | [% j = j + 1 %] |
317 | |
318 | [% END %] |
319 | [% i = i + 1 %] |
320 | [% END %] |
321 | [% END %] |
88f2d2fd |
322 | [% END %] |
65157eda |
323 | |
88f2d2fd |
324 | [% END %] |
325 | |
d8dc07e7 |
326 | [% MACRO printHasFriendly(node) BLOCK %] |
327 | # |
328 | # Has Friendly |
329 | # |
a0249514 |
330 | |
d8dc07e7 |
331 | [% END %] |
332 | |
88f2d2fd |
333 | [% MACRO printList(array) BLOCK %][% FOREACH item = array %][% item %] [% END %][% END %] |
334 | package [% baseclass %]; |
335 | |
336 | # Created by SQL::Translator::Producer::Turnkey |
337 | # Template used: classdbi |
338 | |
339 | use strict; |
340 | use base qw(Class::DBI::Pg); |
341 | |
35276d8c |
342 | [% baseclass %]->set_db('Main', '[% db_dsn %]', '[% db_user %]', '[% db_pass %]', {AutoCommit=>1}); |
edee0655 |
343 | sub search_ilike { shift->_do_search(ILIKE => [% "\@\_" %] ) } |
344 | |
88f2d2fd |
345 | |
346 | [% FOREACH node = nodes %] |
347 | [% printPackage(node.value) %] |
348 | [% END %] |
349 | EOF |
a0249514 |
350 | } |
351 | |
352 | |
353 | elsif($type eq 'atom'){ |
88f2d2fd |
354 | |
d8dc07e7 |
355 | return <<'EOF'; |
c00bb9f8 |
356 | [% ###### DOCUMENT START ###### %] |
357 | |
a0249514 |
358 | [% FOREACH node = nodes %] |
63c988ed |
359 | [% IF !node.value.is_trivial_link %] |
c00bb9f8 |
360 | |
361 | ############################################## |
362 | |
a0249514 |
363 | package Turnkey::Atom::[% node.value.name FILTER replace "Turnkey::Model::", "" %]; |
c00bb9f8 |
364 | |
a0249514 |
365 | [% pname = node.value.name FILTER replace "Turnkey::Model::", "" %] |
63c988ed |
366 | |
a0249514 |
367 | use base qw(Turnkey::Atom); |
c00bb9f8 |
368 | use Data::Dumper; |
369 | |
370 | sub can_render { |
371 | return 1; |
372 | } |
373 | |
374 | sub render { |
375 | my $self = shift; |
376 | my $dbobject = shift; |
c01582e9 |
377 | |
378 | # Assumption here that if it's not rendering on it's own dbobject |
379 | # then it's a list. This will be updated when AtomLists are implemented -boconnor |
a0249514 |
380 | if(ref($dbobject) eq 'Turnkey::Model::[% pname %]') { |
c01582e9 |
381 | $self->focus('yes'); |
c00bb9f8 |
382 | return(_render_record($dbobject)); |
383 | } |
384 | else { return(_render_list($dbobject)); } |
385 | } |
386 | |
387 | sub _render_record { |
388 | my $dbobject = shift; |
389 | my @output = (); |
390 | my $row = {}; |
391 | my $field_hash = {}; |
8bba52b2 |
392 | |
393 | #data |
a0249514 |
394 | [% FOREACH value = node.value.data_fields %] |
8bba52b2 |
395 | [% IF value != 1 %] |
396 | $field_hash->{[% value %]} = $dbobject->[% value %](); |
397 | [% END %] |
398 | [% END %] |
399 | |
400 | #keys |
401 | [% FOREACH value = node.value.edges %] |
402 | [% NEXT IF value.type != 'import' %] |
403 | $field_hash->{[% value.thisfield.name %]} = $dbobject->[% value.thisfield.name %](); |
404 | [% END %] |
405 | |
c00bb9f8 |
406 | $row->{data} = $field_hash; |
407 | $row->{id} = $dbobject->id(); |
408 | push @output, $row; |
409 | return(\@output); |
410 | } |
411 | |
412 | sub _render_list { |
413 | my $dbobject = shift; |
414 | my @output = (); |
88f2d2fd |
415 | my @objects = $dbobject->[% node.key %]s; |
c01582e9 |
416 | foreach my $object (@objects){ |
c00bb9f8 |
417 | my $row = {}; |
c01582e9 |
418 | my $field_hash = {}; |
8bba52b2 |
419 | |
c01582e9 |
420 | #data |
8bba52b2 |
421 | [% FOREACH value = node.value.data_fields %] |
422 | [% IF value != 1 %] |
c01582e9 |
423 | $field_hash->{[% value %]} = $object->[% value %](); |
8bba52b2 |
424 | [% END %] |
425 | [% END %] |
426 | |
c01582e9 |
427 | #keys |
428 | [% FOREACH value = node.value.edges %] |
429 | [% NEXT IF value.type != 'import' %] |
430 | $field_hash->{[% value.thisfield.name %]} = $object->[% value.thisfield.name %](); |
431 | [% END %] |
8bba52b2 |
432 | |
c00bb9f8 |
433 | $row->{data} = $field_hash; |
c01582e9 |
434 | $row->{id} = $object->id(); |
435 | push @output, $row; |
436 | } |
c00bb9f8 |
437 | return(\@output); |
438 | } |
439 | |
440 | sub head { |
441 | return 1; |
442 | } |
443 | |
444 | 1; |
a0249514 |
445 | [% END %] |
c00bb9f8 |
446 | [% END %] |
447 | EOF |
448 | |
d8dc07e7 |
449 | } elsif($type eq 'xml'){ |
450 | return <<EOF; |
c00bb9f8 |
451 | <?xml version="1.0" encoding="UTF-8"?> |
63c988ed |
452 | <!DOCTYPE Turnkey SYSTEM "Turnkey.dtd"> |
453 | <Turnkey> |
c00bb9f8 |
454 | |
455 | <!-- The basic layout is fixed --> |
456 | <container bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" height="90%" orientation="vertical" type="root" width="100%" xlink:label="RootContainer"> |
457 | <container cellpadding="3" cellspacing="0" orientation="horizontal" type="container" height="100%" width="100%" xlink:label="MiddleContainer"> |
458 | <container align="center" cellpadding="2" cellspacing="0" class="leftbar" orientation="vertical" type="minor" width="0%" xlink:label="MidLeftContainer"/> |
459 | <container cellpadding="0" cellspacing="0" orientation="vertical" width="100%" type="major" xlink:label="MainContainer"/> |
460 | </container> |
461 | </container> |
462 | |
463 | <!-- Atom Classes --> |
63c988ed |
464 | [% FOREACH node = nodes %] |
465 | [% IF !node.value.is_trivial_link %] |
43167a31 |
466 | <atom class="Turnkey::Atom::[% format_table(node.key) %]" name="[% format_table(node.key) %]" xlink:label="[% format_table(node.key) %]Atom"/> |
69c7a62f |
467 | [%- END -%] |
63c988ed |
468 | [% END %] |
c00bb9f8 |
469 | |
470 | <!-- Atom Bindings --> |
471 | <atomatombindings> |
63c988ed |
472 | [% FOREACH focus_atom = nodes %] |
473 | [% IF !focus_atom.value.is_trivial_link %] |
474 | [% FOREACH link_atom = focus_atom.value.hyperedges %] |
43167a31 |
475 | <atomatombinding xlink:from="#[% format_table(focus_atom.key) %]Atom" xlink:to="#[% format_table(link_atom.thatnode.table.name) %]Atom" xlink:label="[% format_table(focus_atom.key) %]Atom2[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
69c7a62f |
476 | [%- END -%] |
63c988ed |
477 | [% previous = "" %] |
478 | [% FOREACH link_atom = focus_atom.value.edges %] |
479 | [% IF link_atom.type == 'export' && previous != link_atom.thatnode.table.name && link_atom.thatnode.table.name != "" %] |
43167a31 |
480 | <atomatombinding xlink:from="#[% format_table(focus_atom.key) %]Atom" xlink:to="#[% format_table(link_atom.thatnode.table.name) %]Atom" xlink:label="[% format_table(focus_atom.key) %]Atom2[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
481 | [% previous = link_atom.thatnode.table.name %] |
482 | [% END %] |
483 | [%- END %] |
69c7a62f |
484 | [%- END -%] |
63c988ed |
485 | [% END %] |
c00bb9f8 |
486 | </atomatombindings> |
487 | |
488 | <atomcontainerbindings> |
63c988ed |
489 | [% FOREACH focus_atom = nodes %] |
490 | [% IF !focus_atom.value.is_trivial_link %] |
43167a31 |
491 | <atomcontainerbindingslayout xlink:label="Turnkey::Model::[% format_table(focus_atom.key) %]"> |
63c988ed |
492 | [% FOREACH link_atom = focus_atom.value.hyperedges %] |
43167a31 |
493 | <atomcontainerbinding xlink:from="#MidLeftContainer" xlink:label="MidLeftContainer2[% format_table(link_atom.thatnode.table.name) %]Atom" xlink:to="#[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
494 | [%- END%] |
495 | [% previous = "" %] |
496 | [% FOREACH link_atom = focus_atom.value.edges %] |
497 | [% IF link_atom.type == 'export' && previous != link_atom.thatnode.table.name %] |
43167a31 |
498 | <atomcontainerbinding xlink:from="#MidLeftContainer" xlink:label="MidLeftContainer2[% format_table(link_atom.thatnode.table.name) %]Atom" xlink:to="#[% format_table(link_atom.thatnode.table.name) %]Atom"/> |
63c988ed |
499 | [% previous = link_atom.thatnode.table.name %] |
500 | [% END %] |
501 | [%- END %] |
43167a31 |
502 | <atomcontainerbinding xlink:from="#MainContainer" xlink:label="MainContainer2[% format_table(focus_atom.key) %]Atom" xlink:to="#[% format_table(focus_atom.key) %]Atom"/> |
69c7a62f |
503 | </atomcontainerbindingslayout> |
63c988ed |
504 | [%- END %] |
505 | [% END %] |
69c7a62f |
506 | </atomcontainerbindings> |
507 | |
508 | <uribindings> |
63c988ed |
509 | <uribinding uri="/" class="Turnkey::Util::Frontpage"/> |
69c7a62f |
510 | </uribindings> |
511 | |
512 | <classbindings> |
63c988ed |
513 | [% FOREACH focus_atom = nodes %] |
514 | [% IF !focus_atom.value.is_trivial_link %] |
43167a31 |
515 | <classbinding class="Turnkey::Model::[% format_table(focus_atom.key) %]" plugin="#[% format_table(focus_atom.key) %]Atom" rank="0"/> |
69c7a62f |
516 | [%- END -%] |
63c988ed |
517 | [% END %] |
69c7a62f |
518 | </classbindings> |
c00bb9f8 |
519 | |
63c988ed |
520 | </Turnkey> |
c00bb9f8 |
521 | EOF |
522 | |
d8dc07e7 |
523 | } elsif($type eq 'template'){ |
524 | return <<'EOF'; |
c00bb9f8 |
525 | [% TAGS [- -] %] |
526 | [% MACRO renderpanel(panel,dbobject) BLOCK %] |
527 | <!-- begin panel: [% panel.label %] --> |
528 | <table border="0" width="[% panel.width %]" height="[% panel.height %]" bgcolor="[% panel.bgcolor %]" valign="top" cellpadding="[% panel.cellpadding %]" cellspacing="[% panel.cellspacing %]" align="[% panel.align %]" valign="[% panel.valign %]"> |
529 | <tr> |
530 | [% FOREACH p = panel.containers %] |
531 | [% IF p.can_render(panel) %] |
532 | <td valign="top" class="[% p.class %]" align="[% panel.align %]" height="[% p.height || 1 %]" width="[% p.width %]"> |
533 | [% IF p.type == 'Container' %] |
534 | [% renderpanel(p,dbobject) %] |
535 | [% ELSE %] |
536 | <table cellpadding="0" cellspacing="0" align="left" height="100%" width="100%"> |
537 | [% IF p.name %] |
304d682b |
538 | <tr class="dbtabletitle" height="1"> |
539 | <td class="dbtabletitle">[% p.name %][% IF panel.type == 'major' %]: [% dbobject.name %][% END %]</td> |
540 | <td align="right" width="0"></td> |
c00bb9f8 |
541 | </tr> |
542 | [% END %] |
304d682b |
543 | <tr><td colspan="2" class="dbtablerow"> |
c00bb9f8 |
544 | <!-- begin atom: [% p.label %] --> |
545 | <table cellpadding="0" cellspacing="0" align="left" height="100%" width="100%"><!-- [% ref(atom) %] [% ref(dbobject) %] --> |
546 | [% renderatom(p,dbobject) %] <!-- used to be renderplugin(p,panel) --> |
547 | </table> |
548 | </table> |
549 | [% END %] |
550 | </td> |
551 | [% IF panel.orientation == 'vertical' %] |
552 | </tr><tr> |
553 | [% END %] |
554 | [% END %] |
555 | [% END %] |
556 | </tr> |
557 | </table> |
558 | <!-- end panel: [% panel.label %] --> |
559 | [% END %] |
8bba52b2 |
560 | [% BLOCK make_linked_dbobject %] |
561 | [% PERL %] |
562 | $stash->set(linked_dbobject => [% class %]->retrieve([% id %])); |
563 | [% END %] |
564 | [% END %] |
565 | [% MACRO obj2link(obj) SWITCH ref(obj) %] |
566 | [% CASE '' %] |
567 | [% obj %] |
568 | [% CASE DEFAULT %] |
569 | [% IF obj.name %] |
570 | <a href="[% obj2url(obj) %]">[% obj.name %]</a> |
571 | [% ELSE %] |
572 | <a href="[% obj2url(obj) %]">[% obj %]</a> |
573 | [% END %] |
574 | [% END %] |
575 | [% MACRO obj2url(obj) SWITCH obj %] |
576 | [% CASE DEFAULT %] |
577 | /?id=[% obj %];class=[% ref(obj) %] |
578 | [% END %] |
579 | [% MACRO obj2desc(obj) SWITCH ref(obj) %] |
580 | [% CASE '' %] |
581 | [% obj %] |
582 | [% CASE DEFAULT %] |
583 | [% IF obj.value %] |
584 | [% obj.value %] |
585 | [% ELSE %] |
586 | [% obj %] |
587 | [% END %] |
588 | [% END %] |
c00bb9f8 |
589 | [% MACRO renderatom(atom, dbobject) SWITCH atom.name %] |
7fbe3b98 |
590 | [- FOREACH node = nodes -] |
591 | [- IF !node.value.is_trivial_link -] |
43167a31 |
592 | [% CASE '[- format_table(node.key) -]' %] |
593 | [% render[- format_table(node.key) -]Atom(atom,dbobject) %] |
c00bb9f8 |
594 | [- END -] |
7fbe3b98 |
595 | [- END -] |
c00bb9f8 |
596 | [% CASE DEFAULT %] |
597 | [% renderlist(atom.render(dbobject)) %] |
598 | [% END %] |
63c988ed |
599 | [- FOREACH node = nodes -] |
600 | [- IF !node.value.is_trivial_link -] |
43167a31 |
601 | [% MACRO render[- format_table(node.key) -]Atom(atom, dbobject) BLOCK %] |
c01582e9 |
602 | [% lstArr = atom.render(dbobject) %] |
603 | [% rowcount = 0 %] |
604 | [% IF atom.focus == "yes" %] |
c00bb9f8 |
605 | [% FOREACH record = lstArr %] |
606 | [% fields = record.data %] |
43167a31 |
607 | [- pname = format_table(node.key) -] |
63c988ed |
608 | [- pkey = "Turnkey::Model::${pname}" -] |
609 | [- FOREACH field = node.value.data_fields -] |
610 | [- IF field != "1" -] |
8bba52b2 |
611 | <tr><td class="dbfieldname">[- field -]</td><td class="dbfieldvalue">[% obj2link(fields.[- field -]) %]</td></tr> |
612 | [- END -] |
c00bb9f8 |
613 | [- END -] |
8bba52b2 |
614 | [- FOREACH field = node.value.edges -] |
615 | [- NEXT IF field.type != 'import' -] |
616 | <tr><td class="dbfieldname">[- field.thisfield.name -]</td><td class="dbfieldvalue">[% obj2link(fields.[- field.thisfield.name -]) %]</td></tr> |
63c988ed |
617 | [- END -] |
c00bb9f8 |
618 | [% id = record.id %] |
c01582e9 |
619 | [% IF (rowcount > 1) %] <tr><td colspan="2"><hr></td></tr> [% END %] |
620 | [% rowcount = rowcount + 1 %] |
621 | [% END %] |
622 | [% ELSE %] |
623 | <tr><td><ul> |
624 | [% FOREACH record = lstArr %] |
625 | [% class = ref(atom) | replace('::Atom::', '::Model::') %] |
626 | [% id = record.id %] |
627 | [% PROCESS make_linked_dbobject %] |
628 | <li class="minorfocus">[% obj2link(linked_dbobject) %]</li> |
629 | [% END %] |
630 | </ul></td></tr> |
c00bb9f8 |
631 | [% END %] |
632 | [% END %] |
633 | [- END -] |
63c988ed |
634 | [- END -] |
c00bb9f8 |
635 | [% MACRO renderlist(lstArr) BLOCK %] |
8bba52b2 |
636 | <tr><td><ul> |
637 | [% FOREACH item = lstArr %] |
638 | [% class = ref(atom) | replace('::Atom::', '::Model::') %] |
639 | [% id = item.id %] |
640 | [% PROCESS make_linked_dbobject %] |
c01582e9 |
641 | <li class="minorfocus">[% obj2link(linked_dbobject) %]</li> |
c00bb9f8 |
642 | [% END %] |
8bba52b2 |
643 | </ul></td></tr> |
c00bb9f8 |
644 | [% END %] |
645 | EOF |
646 | |
c00bb9f8 |
647 | 1; |
648 | |
d8dc07e7 |
649 | } |
650 | } |