1 package SQL::Translator::Producer::TTSchema;
3 # -------------------------------------------------------------------
4 # $Id: TTSchema.pm,v 1.2 2003-08-20 21:26:02 kycl4rk Exp $
5 # -------------------------------------------------------------------
6 # Copyright (C) 2003 Mark Addison <grommit@users.sourceforge.net>,
7 # Ken Y. Clark <kclark@cpan.org>.
9 # This program is free software; you can redistribute it and/or
10 # modify it under the terms of the GNU General Public License as
11 # published by the Free Software Foundation; version 2.
13 # This program is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16 # General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with this program; if not, write to the Free Software
20 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
22 # -------------------------------------------------------------------
28 SQL::Translator::Producer::TTSchema -
29 Produces output using the Template Toolkit from a SQL schema
34 my $translator = SQL::Translator->new(
36 filename => 'foo_schema.sql',
39 ttfile => 'foo_template.tt',
42 print $translator->translate;
46 Produces schema output using a given Template Tookit template.
48 It needs one additional producer_arg of C<ttfile> that is the file
49 name of the template to use. This template has one var added to it
50 called C<schema>, which is the SQL::Translator::Producer::Schema
51 object so you can then template via its methods.
53 database: [% schema.database %]
55 [% FOREACH table = schema.get_tables %]
58 [% FOREACH field = table.get_fields %]
59 [% field.name %] [% field.data_type %]([% field.size %])
63 See F<t/data/template/basic.tt> for a more complete example.
65 You can also set any of the options used to initiallize the Template object by
66 adding them to your producer_args. See Template Toolkit docs for details of
69 $translator = SQL::Translator->new(
72 ttfile => 'foo_template.tt',
73 INCLUDE_PATH => '/foo/templates/tt',
80 # -------------------------------------------------------------------
84 use vars qw[ $DEBUG $VERSION @EXPORT_OK ];
85 $VERSION = sprintf "%d.%02d", q$Revision: 1.2 $ =~ /(\d+)\.(\d+)/;
86 $DEBUG = 0 unless defined $DEBUG;
91 use base qw(Exporter);
92 @EXPORT_OK = qw(produce);
94 use base qw/SQL::Translator::Producer/; # Doesn't do anything at the mo!
97 warn @_,"\n" if $DEBUG;
101 my $translator = shift;
102 local $DEBUG = $translator->debug;
103 my $scma = $translator->schema;
104 my $args = $translator->producer_args;
105 my $file = delete $args->{'ttfile'} or die "No template file!";
107 debug "Processing template $file\n";
109 my $tt = Template->new(
111 ABSOLUTE => 1, # Set so we can use from the command line sensible.
112 RELATIVE => 1, # Maybe the cmd line code should set it! Security!
113 %$args, # Allow any TT opts to be passed in the producer_args
114 ) || die "Failed to initialize Template object: ".Template->error;
116 $tt->process( $file, { schema => $scma }, \$out )
117 or die "Error processing template '$file': ".$tt->error;
124 # -------------------------------------------------------------------
130 Mark Addison E<lt>grommit@users.sourceforge.netE<gt>.
134 B<More template vars?> e.g. [% tables %] as a shortcut for
135 [% schema.get_tables %].