package SQL::Translator::Producer::TTSchema;
+# -------------------------------------------------------------------
+# Copyright (C) 2002-2009 SQLFairy Authors
+#
+# This program is free software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License as
+# published by the Free Software Foundation; version 2.
+#
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+# General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
+# 02111-1307 USA
+# -------------------------------------------------------------------
+
=pod
=head1 NAME
-SQL::Translator::Producer::TTSchema - Produces output using the template toolkit
-from a SQL schema.
+SQL::Translator::Producer::TTSchema -
+ Produces output using the Template Toolkit from a SQL schema
+
+=head1 SYNOPSIS
+
+ use SQL::Translator;
+ my $translator = SQL::Translator->new(
+ from => 'MySQL',
+ filename => 'foo_schema.sql',
+ to => 'TTSchema',
+ producer_args => {
+ ttfile => 'foo_template.tt', # Template file to use
+
+ # Extra template variables
+ ttargs => {
+ author => "Mr Foo",
+ },
+
+ # Template config options
+ ttargs => {
+ INCLUDE_PATH => '/foo/templates',
+ },
+ },
+ );
+ print $translator->translate;
+
+=head1 DESCRIPTION
+
+Produces schema output using a given Template Tookit template.
+
+It needs one additional producer_arg of C<ttfile> which is the file
+name of the template to use. This template will be passed a variable
+called C<schema>, which is the C<SQL::Translator::Producer::Schema> object
+created by the parser. You can then use it to walk the schema via the
+methods documented in that module.
+
+Here's a brief example of what the template could look like:
+
+ database: [% schema.database %]
+ tables:
+ [% FOREACH table = schema.get_tables %]
+ [% table.name %]
+ ================
+ [% FOREACH field = table.get_fields %]
+ [% field.name %] [% field.data_type %]([% field.size %])
+ [% END -%]
+ [% END %]
+
+See F<t/data/template/basic.tt> for a more complete example.
+
+The template will also get the set of extra variables given as a hashref via the
+C<tt_vars> producer arg.
+
+You can set any of the options used to initiallize the Template object by
+adding a tt_conf producer_arg. See Template Toolkit docs for details of
+the options.
+(Note that the old style of passing this config directly in the producer args
+has been deprecated).
+
+
+ $translator = SQL::Translator->new(
+ to => 'TT',
+ producer_args => {
+ ttfile => 'foo_template.tt',
+ ttargs => {},
+ tt_conf = {
+ INCLUDE_PATH => '/foo/templates/tt',
+ INTERPOLATE => 1,
+ }
+ },
+ );
+
+You can use this producer to create any type of text output you like,
+even using it to create your own versions of what the other producers
+make. For example, you could create a template that translates the
+schema into MySQL's syntax, your own HTML documentation, your own
+Class::DBI classes (or some other code) -- the opportunities are
+limitless!
+
+=head2 Producer Args
+
+=over 4
+
+=item ttfile
+
+The template file to generate the output with.
+
+=item tt_vars
+
+A hash ref of extra variables you want to add to the template.
+
+=item tt_conf
+
+A hash ref of configuration options to pass to the L<Template> object's
+constructor.
+
+=back
=cut
+# -------------------------------------------------------------------
use strict;
-use warnings;
use vars qw[ $DEBUG $VERSION @EXPORT_OK ];
-#$VERSION = sprintf "%d.%02d", q$Revision: 1.1 $ =~ /(\d+)\.(\d+)/;
-$VERSION = 0.1;
+$VERSION = '1.59';
$DEBUG = 0 unless defined $DEBUG;
+use Template;
use Data::Dumper;
use Exporter;
use base qw(Exporter);
@EXPORT_OK = qw(produce);
-use base qw/SQL::Translator::Producer/; # Doesn't do anything at the mo!
-use Template;
-
-sub debug {
- warn @_,"\n" if $DEBUG;
-}
+use SQL::Translator::Utils 'debug';
sub produce {
my $translator = shift;
- local $DEBUG = $translator->debug;
- my $scma = $translator->schema;
- my $args = $translator->producer_args;
- my $file = delete $args->{ttfile} or die "No template file!";
-
+ local $DEBUG = $translator->debug;
+ my $scma = $translator->schema;
+ my $args = $translator->producer_args;
+ my $file = delete $args->{'ttfile'} or die "No template file!";
+
+ my $tt_vars = delete $args->{'tt_vars'} || {};
+ if ( exists $args->{ttargs} ) {
+ warn "Use of 'ttargs' producer arg is deprecated."
+ ." Please use 'tt_vars' instead.\n";
+ %$tt_vars = { %{$args->{ttargs}}, %$tt_vars };
+ }
+
+ my %tt_conf = exists $args->{tt_conf} ? %{$args->{tt_conf}} : ();
+ # sqlt passes the producer args for _all_ producers in, so we use this
+ # grep hack to test for the old usage.
+ debug(Dumper(\%tt_conf));
+ if ( grep /^[A-Z_]+$/, keys %$args ) {
+ warn "Template config directly in the producer args is deprecated."
+ ." Please use 'tt_conf' instead.\n";
+ %tt_conf = ( %tt_conf, %$args );
+ }
+
debug "Processing template $file\n";
my $out;
- my $tt = Template->new(
- DEBUG => $DEBUG,
- ABSOLUTE => 1, # Set so we can use from the command line sensible.
- RELATIVE => 1, # Maybe the cmd line code should set it! Security!
- %$args, # Allow any TT opts to be passed in the producer_args
-
- ) || die "Failed to initialize Template object: ".Template->error;
- $tt->process($file,{ schema => $scma },\$out)
- or die "Error processing template '$file': ".$tt->error;
+ my $tt = Template->new(
+ DEBUG => $DEBUG,
+ ABSOLUTE => 1, # Set so we can use from the command line sensibly
+ RELATIVE => 1, # Maybe the cmd line code should set it! Security!
+ %tt_conf,
+ );
+ debug("Template ERROR: " . Template->error. "\n") if(!$tt);
+ $tt || die "Failed to initialize Template object: ".Template->error;
+
+ my $ttproc = $tt->process(
+ $file,
+ { schema => $scma , %$tt_vars },
+ \$out
+ );
+ debug("ERROR: ". $tt->error. "\n") if(!$ttproc);
+ $ttproc or die "Error processing template '$file': ".$tt->error;
return $out;
};
1;
-__END__
+# -------------------------------------------------------------------
=pod
-=head1 SYNOPSIS
-
- use SQL::Translator;
- $translator = SQL::Translator->new(
- from => "MySQL",
- filename => "foo_schema.sql",
- to => "TT",
- producer_args => {
- ttfile => "foo_template.tt",
- },
- );
- print $translator->translate;
-
-=head1 DESCRIPTION
-
-Produces schema output using a given Template Tookit template.
-
-It needs one additional producer_arg of C<ttfile> that is the file name of the
-template to use. This template has one var added to it called C<schema>, which
-is the SQL::Translator::Producer::Schema object so you can then template via
-its methods.
-
- database: [% schema.database %]
- tables:
- [% FOREACH table = schema.get_tables %]
- [% table.name %]
- ================
- [% FOREACH field = table.get_fields %]
- [% field.name %] [% field.datatype %]([% field.size %])
- [% END -%]
- [% END %]
+=head1 AUTHOR
-See F<t/data/template/basic.tt> for a more complete example.
-
-You can also set any of the options used to initiallize the Template object by
-adding them to your producer_args. See Template Toolkit docs for details of
-the options.
-
- $translator = SQL::Translator->new(
- to => "TT",
- producer_args => {
- ttfile => "foo_template.tt",
- INCLUDE_PATH => "/foo/templates/tt",
- INTERPOLATE => 1,
- },
- );
+Mark Addison E<lt>grommit@users.sourceforge.netE<gt>.
=head1 TODO
B<More template vars?> e.g. [% tables %] as a shortcut for
[% schema.get_tables %].
+=head1 SEE ALSO
+
+SQL::Translator.
+
=cut