line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package SQL::Translator::Producer::TT::Base; |
2
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
=pod |
4
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
=head1 NAME |
6
|
|
|
|
|
|
|
|
7
|
|
|
|
|
|
|
SQL::Translator::Producer::TT::Base - TT (Template Toolkit) based Producer base |
8
|
|
|
|
|
|
|
class. |
9
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
=cut |
11
|
|
|
|
|
|
|
|
12
|
1
|
|
|
1
|
|
548
|
use strict; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
31
|
|
13
|
1
|
|
|
1
|
|
6
|
use warnings; |
|
1
|
|
|
|
|
5
|
|
|
1
|
|
|
|
|
51
|
|
14
|
|
|
|
|
|
|
|
15
|
|
|
|
|
|
|
our @EXPORT_OK; |
16
|
|
|
|
|
|
|
our $VERSION = '1.62'; |
17
|
|
|
|
|
|
|
|
18
|
1
|
|
|
1
|
|
10
|
use Template; |
|
1
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
28
|
|
19
|
1
|
|
|
1
|
|
10
|
use Data::Dumper; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
78
|
|
20
|
1
|
|
|
1
|
|
7
|
use IO::Handle; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
41
|
|
21
|
1
|
|
|
1
|
|
6
|
use Exporter; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
41
|
|
22
|
1
|
|
|
1
|
|
8
|
use base qw(Exporter); |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
126
|
|
23
|
|
|
|
|
|
|
@EXPORT_OK = qw(produce); |
24
|
|
|
|
|
|
|
|
25
|
1
|
|
|
1
|
|
9
|
use SQL::Translator::Utils 'debug'; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
645
|
|
26
|
|
|
|
|
|
|
|
27
|
|
|
|
|
|
|
# Hack to convert the produce call into an object. ALL sub-classes need todo |
28
|
|
|
|
|
|
|
# this so that the correct class gets created. |
29
|
|
|
|
|
|
|
sub produce { |
30
|
0
|
|
|
0
|
0
|
0
|
return __PACKAGE__->new( translator => shift )->run; |
31
|
|
|
|
|
|
|
}; |
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
sub new { |
34
|
1
|
|
|
1
|
1
|
22
|
my $proto = shift; |
35
|
1
|
|
33
|
|
|
5
|
my $class = ref $proto || $proto; |
36
|
1
|
|
|
|
|
5
|
my %args = @_; |
37
|
|
|
|
|
|
|
|
38
|
1
|
|
|
|
|
3
|
my $me = bless {}, $class; |
39
|
1
|
|
50
|
|
|
10
|
$me->{translator} = delete $args{translator} || die "Need a translator."; |
40
|
|
|
|
|
|
|
|
41
|
1
|
|
|
|
|
7
|
return $me; |
42
|
|
|
|
|
|
|
} |
43
|
|
|
|
|
|
|
|
44
|
2
|
|
|
2
|
1
|
40
|
sub translator { shift->{translator}; } |
45
|
1
|
|
|
1
|
1
|
47
|
sub schema { shift->{translator}->schema(@_); } |
46
|
|
|
|
|
|
|
|
47
|
|
|
|
|
|
|
# Util args access method. |
48
|
|
|
|
|
|
|
# No args - Return hashref (the actual hash in Translator) or hash of args. |
49
|
|
|
|
|
|
|
# 1 arg - Return that named args value. |
50
|
|
|
|
|
|
|
# Args - List of names. Return values of the given arg names in list context |
51
|
|
|
|
|
|
|
# or return as hashref in scalar context. Any names given that don't |
52
|
|
|
|
|
|
|
# exist in the args are returned as undef. |
53
|
|
|
|
|
|
|
sub args { |
54
|
2
|
|
|
2
|
1
|
3
|
my $me = shift; |
55
|
|
|
|
|
|
|
|
56
|
|
|
|
|
|
|
# No args |
57
|
2
|
100
|
|
|
|
7
|
unless (@_) { |
58
|
|
|
|
|
|
|
return wantarray |
59
|
0
|
|
|
|
|
0
|
? %{ $me->{translator}->producer_args } |
60
|
|
|
|
|
|
|
: $me->{translator}->producer_args |
61
|
1
|
50
|
|
|
|
27
|
; |
62
|
|
|
|
|
|
|
} |
63
|
|
|
|
|
|
|
|
64
|
|
|
|
|
|
|
# 1 arg. Return the value whatever the context. |
65
|
1
|
50
|
|
|
|
24
|
return $me->{translator}->producer_args->{$_[0]} if @_ == 1; |
66
|
|
|
|
|
|
|
|
67
|
|
|
|
|
|
|
# More args so return values list or hash ref |
68
|
0
|
|
|
|
|
0
|
my %args = %{ $me->{translator}->producer_args }; |
|
0
|
|
|
|
|
0
|
|
69
|
0
|
0
|
|
|
|
0
|
return wantarray ? @args{@_} : { map { ($_=>$args{$_}) } @_ }; |
|
0
|
|
|
|
|
0
|
|
70
|
|
|
|
|
|
|
} |
71
|
|
|
|
|
|
|
|
72
|
|
|
|
|
|
|
# Run the produce and return the result. |
73
|
|
|
|
|
|
|
sub run { |
74
|
1
|
|
|
1
|
1
|
4
|
my $me = shift; |
75
|
1
|
|
|
|
|
9
|
my $scma = $me->schema; |
76
|
1
|
|
|
|
|
12
|
my %args = %{$me->args}; |
|
1
|
|
|
|
|
7
|
|
77
|
1
|
50
|
|
|
|
9
|
my $tmpl = $me->tt_schema or die "No template!"; |
78
|
|
|
|
|
|
|
|
79
|
1
|
|
|
|
|
10
|
debug "Processing template $tmpl\n"; |
80
|
1
|
|
|
|
|
2
|
my $out; |
81
|
1
|
|
50
|
|
|
7
|
my $tt = Template->new( |
82
|
|
|
|
|
|
|
#DEBUG => $me->translator->debug, |
83
|
|
|
|
|
|
|
ABSOLUTE => 1, # Set so we can use from the command line sensibly |
84
|
|
|
|
|
|
|
RELATIVE => 1, # Maybe the cmd line code should set it! Security! |
85
|
|
|
|
|
|
|
$me->tt_config, # Hook for sub-classes to add config |
86
|
|
|
|
|
|
|
%args, # Allow any TT opts to be passed in the producer_args |
87
|
|
|
|
|
|
|
) || die "Failed to initialize Template object: ".Template->error; |
88
|
|
|
|
|
|
|
|
89
|
1
|
50
|
|
|
|
25328
|
$tt->process( $tmpl, { |
90
|
|
|
|
|
|
|
$me->tt_default_vars, |
91
|
|
|
|
|
|
|
$me->tt_vars, # Sub-class hook for adding vars |
92
|
|
|
|
|
|
|
}, \$out ) |
93
|
|
|
|
|
|
|
or die "Error processing template '$tmpl': ".$tt->error; |
94
|
|
|
|
|
|
|
|
95
|
1
|
|
|
|
|
251
|
return $out; |
96
|
|
|
|
|
|
|
} |
97
|
|
|
|
|
|
|
|
98
|
|
|
|
|
|
|
|
99
|
|
|
|
|
|
|
# Sub class hooks |
100
|
|
|
|
|
|
|
#----------------------------------------------------------------------------- |
101
|
|
|
|
|
|
|
|
102
|
0
|
|
|
0
|
1
|
0
|
sub tt_config { () }; |
103
|
|
|
|
|
|
|
|
104
|
|
|
|
|
|
|
sub tt_schema { |
105
|
1
|
|
|
1
|
1
|
2
|
my $me = shift; |
106
|
1
|
|
|
|
|
3
|
my $class = ref $me; |
107
|
|
|
|
|
|
|
|
108
|
1
|
|
|
|
|
3
|
my $file = $me->args("ttfile"); |
109
|
1
|
50
|
|
|
|
4
|
return $file if $file; |
110
|
|
|
|
|
|
|
|
111
|
1
|
|
|
1
|
|
8
|
no strict 'refs'; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
223
|
|
112
|
1
|
|
|
|
|
3
|
my $ref = *{"$class\:\:DATA"}{IO}; |
|
1
|
|
|
|
|
8
|
|
113
|
1
|
50
|
|
|
|
16
|
if ( $ref->opened ) { |
114
|
1
|
|
|
|
|
26
|
local $/ = undef; # Slurp mode |
115
|
1
|
|
|
|
|
61
|
return \<$ref>; |
116
|
|
|
|
|
|
|
} |
117
|
|
|
|
|
|
|
|
118
|
0
|
|
|
|
|
0
|
undef; |
119
|
|
|
|
|
|
|
}; |
120
|
|
|
|
|
|
|
|
121
|
|
|
|
|
|
|
sub tt_default_vars { |
122
|
1
|
|
|
1
|
1
|
3
|
my $me = shift; |
123
|
|
|
|
|
|
|
return ( |
124
|
1
|
|
|
|
|
9
|
translator => $me->translator, |
125
|
|
|
|
|
|
|
schema => $me->pre_process_schema($me->translator->schema), |
126
|
|
|
|
|
|
|
); |
127
|
|
|
|
|
|
|
} |
128
|
|
|
|
|
|
|
|
129
|
1
|
|
|
1
|
1
|
19
|
sub pre_process_schema { $_[1] } |
130
|
|
|
|
|
|
|
|
131
|
0
|
|
|
0
|
1
|
|
sub tt_vars { () }; |
132
|
|
|
|
|
|
|
|
133
|
|
|
|
|
|
|
1; |
134
|
|
|
|
|
|
|
|
135
|
|
|
|
|
|
|
=pod |
136
|
|
|
|
|
|
|
|
137
|
|
|
|
|
|
|
=head1 SYNOPSIS |
138
|
|
|
|
|
|
|
|
139
|
|
|
|
|
|
|
# Create a producer using a template in the __DATA__ section. |
140
|
|
|
|
|
|
|
package SQL::Translator::Producer::Foo; |
141
|
|
|
|
|
|
|
|
142
|
|
|
|
|
|
|
use base qw/SQL::Translator::Producer::TT::Base/; |
143
|
|
|
|
|
|
|
|
144
|
|
|
|
|
|
|
# Convert produce call into a method call on our new class |
145
|
|
|
|
|
|
|
sub produce { return __PACKAGE__->new( translator => shift )->run; }; |
146
|
|
|
|
|
|
|
|
147
|
|
|
|
|
|
|
# Configure the Template object. |
148
|
|
|
|
|
|
|
sub tt_config { ( INTERPOLATE => 1 ); } |
149
|
|
|
|
|
|
|
|
150
|
|
|
|
|
|
|
# Extra vars to add to the template |
151
|
|
|
|
|
|
|
sub tt_vars { ( foo => "bar" ); } |
152
|
|
|
|
|
|
|
|
153
|
|
|
|
|
|
|
# Put template in DATA section (or use file with ttfile producer arg) |
154
|
|
|
|
|
|
|
__DATA__ |
155
|
|
|
|
|
|
|
Schema |
156
|
|
|
|
|
|
|
|
157
|
|
|
|
|
|
|
Database: [% schema.database %] |
158
|
|
|
|
|
|
|
Foo: $foo |
159
|
|
|
|
|
|
|
... |
160
|
|
|
|
|
|
|
|
161
|
|
|
|
|
|
|
=head1 DESCRIPTION |
162
|
|
|
|
|
|
|
|
163
|
|
|
|
|
|
|
A base class producer designed to be sub-classed to create new TT based |
164
|
|
|
|
|
|
|
producers cheaply - by simply giving the template to use and sprinkling in some |
165
|
|
|
|
|
|
|
extra template variables and config. |
166
|
|
|
|
|
|
|
|
167
|
|
|
|
|
|
|
You can find an introduction to this module in L. |
168
|
|
|
|
|
|
|
|
169
|
|
|
|
|
|
|
The 1st thing the module does is convert the produce sub routine call we get |
170
|
|
|
|
|
|
|
from SQL::Translator into a method call on an object, which we can then |
171
|
|
|
|
|
|
|
sub-class. This is done with the following code which needs to appear in B |
172
|
|
|
|
|
|
|
sub classes. |
173
|
|
|
|
|
|
|
|
174
|
|
|
|
|
|
|
# Convert produce call into an object method call |
175
|
|
|
|
|
|
|
sub produce { return __PACKAGE__->new( translator => shift )->run; }; |
176
|
|
|
|
|
|
|
|
177
|
|
|
|
|
|
|
See L below for details. |
178
|
|
|
|
|
|
|
|
179
|
|
|
|
|
|
|
The upshot of this is we can make new template producers by sub classing this |
180
|
|
|
|
|
|
|
base class, adding the above snippet and a template. |
181
|
|
|
|
|
|
|
The module also provides a number of hooks into the templating process, |
182
|
|
|
|
|
|
|
see L for details. |
183
|
|
|
|
|
|
|
|
184
|
|
|
|
|
|
|
See the L above for an example of creating a simple producer using |
185
|
|
|
|
|
|
|
a single template stored in the producers DATA section. |
186
|
|
|
|
|
|
|
|
187
|
|
|
|
|
|
|
=head1 SUB CLASS HOOKS |
188
|
|
|
|
|
|
|
|
189
|
|
|
|
|
|
|
Sub-classes can override these methods to control the templating by giving |
190
|
|
|
|
|
|
|
the template source, adding variables and giving config to the Tempate object. |
191
|
|
|
|
|
|
|
|
192
|
|
|
|
|
|
|
=head2 tt_config |
193
|
|
|
|
|
|
|
|
194
|
|
|
|
|
|
|
sub tt_config { ( INTERPOLATE => 1 ); } |
195
|
|
|
|
|
|
|
|
196
|
|
|
|
|
|
|
Return hash of Template config to add to that given to the L C |
197
|
|
|
|
|
|
|
method. |
198
|
|
|
|
|
|
|
|
199
|
|
|
|
|
|
|
=head2 tt_schema |
200
|
|
|
|
|
|
|
|
201
|
|
|
|
|
|
|
sub tt_schema { "foo.tt"; } |
202
|
|
|
|
|
|
|
sub tt_schema { local $/ = undef; \; } |
203
|
|
|
|
|
|
|
|
204
|
|
|
|
|
|
|
The template to use, return a file name or a scalar ref of TT |
205
|
|
|
|
|
|
|
source, or an L. See L for details, as the return from |
206
|
|
|
|
|
|
|
this is passed on to it's C method. |
207
|
|
|
|
|
|
|
|
208
|
|
|
|
|
|
|
The default implementation uses the producer arg C as a filename to read |
209
|
|
|
|
|
|
|
the template from. If the arg isn't there it will look for a C<__DATA__> section |
210
|
|
|
|
|
|
|
in the class, reading it as template source if found. Returns undef if both |
211
|
|
|
|
|
|
|
these fail, causing the produce call to fail with a 'no template!' error. |
212
|
|
|
|
|
|
|
|
213
|
|
|
|
|
|
|
=head2 tt_vars |
214
|
|
|
|
|
|
|
|
215
|
|
|
|
|
|
|
sub tt_vars { ( foo => "bar" ); } |
216
|
|
|
|
|
|
|
|
217
|
|
|
|
|
|
|
Return hash of template vars to use in the template. Nothing added here |
218
|
|
|
|
|
|
|
by default, but see L for the variables you get for free. |
219
|
|
|
|
|
|
|
|
220
|
|
|
|
|
|
|
=head2 tt_default_vars |
221
|
|
|
|
|
|
|
|
222
|
|
|
|
|
|
|
Return a hash-ref of the default vars given to the template. |
223
|
|
|
|
|
|
|
You wouldn't normally over-ride this, just inherit the default implementation, |
224
|
|
|
|
|
|
|
to get the C & C variables, then over-ride L to add |
225
|
|
|
|
|
|
|
your own. |
226
|
|
|
|
|
|
|
|
227
|
|
|
|
|
|
|
The current default variables are: |
228
|
|
|
|
|
|
|
|
229
|
|
|
|
|
|
|
=over 4 |
230
|
|
|
|
|
|
|
|
231
|
|
|
|
|
|
|
=item schema |
232
|
|
|
|
|
|
|
|
233
|
|
|
|
|
|
|
The schema to template. |
234
|
|
|
|
|
|
|
|
235
|
|
|
|
|
|
|
=item translator |
236
|
|
|
|
|
|
|
|
237
|
|
|
|
|
|
|
The L object. |
238
|
|
|
|
|
|
|
|
239
|
|
|
|
|
|
|
=back |
240
|
|
|
|
|
|
|
|
241
|
|
|
|
|
|
|
=head2 pre_process_schema |
242
|
|
|
|
|
|
|
|
243
|
|
|
|
|
|
|
WARNING: This method is Experimental so may change! |
244
|
|
|
|
|
|
|
|
245
|
|
|
|
|
|
|
Called with the L object and should return one (it |
246
|
|
|
|
|
|
|
doesn't have to be the same one) that will become the C variable used |
247
|
|
|
|
|
|
|
in the template. |
248
|
|
|
|
|
|
|
|
249
|
|
|
|
|
|
|
Gets called from tt_default_vars. |
250
|
|
|
|
|
|
|
|
251
|
|
|
|
|
|
|
=head1 PRODUCER OBJECT |
252
|
|
|
|
|
|
|
|
253
|
|
|
|
|
|
|
The rest of the methods in the class set up a sub-classable producer object. |
254
|
|
|
|
|
|
|
You normally just inherit them. |
255
|
|
|
|
|
|
|
|
256
|
|
|
|
|
|
|
=head2 new |
257
|
|
|
|
|
|
|
|
258
|
|
|
|
|
|
|
my $tt_producer = TT::Base->new( translator => $translator ); |
259
|
|
|
|
|
|
|
|
260
|
|
|
|
|
|
|
Construct a new TT Producer object. Takes a single, named arg of the |
261
|
|
|
|
|
|
|
L object running the translation. Dies if this is not given. |
262
|
|
|
|
|
|
|
|
263
|
|
|
|
|
|
|
=head2 translator |
264
|
|
|
|
|
|
|
|
265
|
|
|
|
|
|
|
Return the L object. |
266
|
|
|
|
|
|
|
|
267
|
|
|
|
|
|
|
=head2 schema |
268
|
|
|
|
|
|
|
|
269
|
|
|
|
|
|
|
Return the L we are translating. This is equivalent |
270
|
|
|
|
|
|
|
to C<< $tt_producer->translator->schema >>. |
271
|
|
|
|
|
|
|
|
272
|
|
|
|
|
|
|
=head2 run |
273
|
|
|
|
|
|
|
|
274
|
|
|
|
|
|
|
Called to actually produce the output, calling the sub class hooks. Returns the |
275
|
|
|
|
|
|
|
produced text. |
276
|
|
|
|
|
|
|
|
277
|
|
|
|
|
|
|
=head2 args |
278
|
|
|
|
|
|
|
|
279
|
|
|
|
|
|
|
Util wrapper method around C<< TT::Base->translator->producer_args >> for |
280
|
|
|
|
|
|
|
(mostly) readonly access to the producer args. How it works depends on the |
281
|
|
|
|
|
|
|
number of arguments you give it and the context. |
282
|
|
|
|
|
|
|
|
283
|
|
|
|
|
|
|
No args - Return hashref (the actual hash in Translator) or hash of args. |
284
|
|
|
|
|
|
|
1 arg - Return value of the arg with the passed name. |
285
|
|
|
|
|
|
|
2+ args - List of names. In list context returns values of the given arg |
286
|
|
|
|
|
|
|
names, returns as a hashref in scalar context. Any names given |
287
|
|
|
|
|
|
|
that don't exist in the args are returned as undef. |
288
|
|
|
|
|
|
|
|
289
|
|
|
|
|
|
|
This is still a bit messy but is a handy way to access the producer args when |
290
|
|
|
|
|
|
|
you use your own to drive the templating. |
291
|
|
|
|
|
|
|
|
292
|
|
|
|
|
|
|
=head1 SEE ALSO |
293
|
|
|
|
|
|
|
|
294
|
|
|
|
|
|
|
L, |
295
|
|
|
|
|
|
|
L, |
296
|
|
|
|
|
|
|
L. |
297
|
|
|
|
|
|
|
|
298
|
|
|
|
|
|
|
=head1 TODO |
299
|
|
|
|
|
|
|
|
300
|
|
|
|
|
|
|
- Add support for a sqlf template repository, set as an INCLUDE_PATH, |
301
|
|
|
|
|
|
|
so that sub-classes can easily include file based templates using relative |
302
|
|
|
|
|
|
|
paths. |
303
|
|
|
|
|
|
|
|
304
|
|
|
|
|
|
|
- Pass in template vars from the producer args and command line. |
305
|
|
|
|
|
|
|
|
306
|
|
|
|
|
|
|
- Merge in L. |
307
|
|
|
|
|
|
|
|
308
|
|
|
|
|
|
|
- Hooks to pre-process the schema and post-process the output. |
309
|
|
|
|
|
|
|
|
310
|
|
|
|
|
|
|
=head1 AUTHOR |
311
|
|
|
|
|
|
|
|
312
|
|
|
|
|
|
|
Mark Addison Egrommit@users.sourceforge.netE. |
313
|
|
|
|
|
|
|
|
314
|
|
|
|
|
|
|
=cut |