-package SQL::Translator;
-
+use inc::Module::Install 1.06;
use strict;
-use ExtUtils::MakeMaker;
-$|++;
-
-my %PREREQ_PM;
-my %missing = (
- optional => [ ],
- required => [ ],
-);
-
-print "Checking for required and recommended modules.\n";
-# Module Name Version Optional?
-check_version('Class::Base' => 0 => 0);
-check_version('File::Basename' => 0 => 0);
-check_version('File::Spec' => 0 => 0);
-check_version('GD' => 0 => 1);
-check_version('GraphViz' => 0 => 1);
-check_version('IO::Dir' => 0 => 0);
-check_version('IO::File' => 0 => 0);
-check_version('IO::Scalar' => 0 => 0);
-check_version('Parse::RecDescent' => 1.94 => 0);
-check_version('Pod::Usage' => 0 => 0);
-check_version('Spreadsheet::ParseExcel' => 0 => 1);
-check_version('Template' => 2.10 => 1);
-check_version('Test::More' => 0 => 0);
-check_version('Test::Exception' => 0 => 0);
-check_version('Test::Differences' => 0 => 0);
-check_version('Text::ParseWords' => 0 => 0);
-check_version('Text::RecordParser' => 0.02 => 0);
-check_version('XML::Writer' => 0 => 1);
-check_version('XML::XPath' => 1.13 => 1);
-check_version('YAML' => 0 => 1);
-
-print "\n";
-
-if (@{$missing{'optional'}} + @{$missing{'required'}}) {
- print "Some components might not work correctly:\n";
- my $count;
- if (@{$missing{'required'}}) {
- $count = scalar(@{$missing{'required'}});
- printf " You are missing %d required module%s: %s\n",
- $count,
- $count == 1 ? '' : 's',
- join ', ', @{$missing{'required'}};
- }
- if (@{$missing{'optional'}}) {
- $count = scalar(@{$missing{'optional'}});
- printf " You are missing %d optional module%s: %s\n",
- $count,
- $count == 1 ? '' : 's',
- join ', ', @{$missing{'optional'}};
- }
-
- print "\n";
+use warnings;
+
+# to deal wuth x.y.z versions properly
+configure_requires 'ExtUtils::MakeMaker' => '6.54';
+
+perl_version '5.008001';
+
+my $deps = {
+ requires => {
+ 'Digest::SHA' => '0',
+ 'Carp::Clan' => '0',
+ 'Parse::RecDescent' => '1.967009',
+ 'DBI' => '0',
+ 'File::ShareDir' => '1.0',
+ 'Moo' => '1.000003',
+ 'Package::Variant' => '1.001001',
+ 'Sub::Quote' => '0',
+ 'Try::Tiny' => '0.04',
+ 'List::MoreUtils' => '0.09',
+ },
+ recommends => {
+ 'Template' => '2.20',
+ 'GD' => '0',
+ 'GraphViz' => '0',
+ 'Graph::Directed' => '0',
+ 'Spreadsheet::ParseExcel' => '0.41',
+ 'Text::RecordParser' => '0.02',
+ 'XML::LibXML' => '1.69',
+ },
+ test_requires => {
+ 'YAML' => '0.66',
+ 'XML::Writer' => '0.500',
+ 'Test::More' => '0.88',
+ 'Test::Differences' => '0',
+ 'Test::Exception' => '0.31',
+ },
+};
+
+
+name 'SQL-Translator';
+author 'Ken Youens-Clark <kclark@cpan.org>';
+abstract 'SQL DDL transformations and more';
+license 'gpl';
+repository 'git://git.shadowcat.co.uk/dbsrgits/SQL-Translator.git';
+bugtracker 'http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Translator';
+
+resources Ratings => 'http://cpanratings.perl.org/d/SQL-Translator';
+
+Meta->{values}{x_authority} = 'cpan:JROBINSON';
+
+all_from 'lib/SQL/Translator.pm';
+
+for my $type (qw/requires recommends test_requires/) {
+ no strict qw/refs/;
+ my $f = \&$type;
+ for my $mod (keys %{$deps->{$type} || {} }) {
+ $f->($mod, $deps->{$type}{$mod});
+ }
}
-WriteMakefile(
- 'NAME' => __PACKAGE__,
- 'VERSION_FROM' => 'lib/SQL/Translator.pm',
- 'EXE_FILES' => [
- 'bin/sqlt-diagram',
- 'bin/sqlt-dumper',
- 'bin/sqlt-graph',
- 'bin/sqlt',
- ],
- 'PREREQ_PM' => \%PREREQ_PM,
- 'clean' => {
- FILES => '$(DISTVNAME).tar$(SUFFIX)',
- },
-);
-
-# ----------------------------------------------------------------------
-# check_version($module, $version, $optional)
-#
-# Takes a module name, optional version number, and a flag indicating
-# whether the module is optional (default is no).
-# ----------------------------------------------------------------------
-sub check_version {
- my ($module, $version, $optional) = @_;
- my ($dots, $load);
-
- if ($version) {
- $version = sprintf "%.02f", $version;
- $load = "$module $version";
- }
- else {
- $load = $module;
- }
-
- $dots = '.' x (36 - length($load));
-
- eval "use $load;";
- if ($@) {
- if ($optional) {
- push @{$missing{'optional'}}, $module;
- }
- else {
- push @{$missing{'required'}}, $module;
- }
- print "$load $dots not found!";
- if ($optional) {
- print optional('not found!'), "\n";
- return;
- }
- print required('not found!');
- print "\n";
- }
- else {
- no strict qw(refs);
- my $ver = sprintf "%.02f" => ${"$module\::VERSION"};
- print "$load $dots $ver";
- print $optional ? optional($ver) : required($ver);
- print "\n";
- $version = $ver;
- }
-
- $PREREQ_PM{$module} = $version;
+install_script (qw|
+ script/sqlt-diagram
+ script/sqlt-diff
+ script/sqlt-diff-old
+ script/sqlt-dumper
+ script/sqlt-graph
+ script/sqlt
+|);
+
+install_share();
+
+tests_recursive ();
+
+
+# temporary(?) until I get around to fix M::I wrt xt/
+# needs Module::Install::AuthorTests
+eval {
+ # this should not be necessary since the autoloader is supposed
+ # to work, but there were reports of it failing
+ require Module::Install::AuthorTests;
+ recursive_author_tests (qw/xt/);
+ 1;
+} || do {
+ if ($Module::Install::AUTHOR) {
+ my $err = $@;
+
+ # better error message in case of missing dep
+ eval { require Module::Install::AuthorTests }
+ || die "\nYou need Module::Install::AuthorTests installed to run this Makefile.PL in author mode:\n\n$@\n";
+
+ die $err;
+ }
+};
+
+auto_install();
+
+if ($Module::Install::AUTHOR) {
+ _recompile_grammars();
+ _recreate_rt_source();
}
-sub optional { return _message("[optional]", @_) }
-sub required { return _message("", @_) }
+WriteAll();
-sub _message {
- my ($message, $version) = @_;
- my $size = 24 - (length "$version");
- my $fmt = '%' . $size . 's';
- sprintf $fmt => $message;
-}
+sub _recompile_grammars {
+ return; # disabled until RT#74593 is resolved
+
+ require File::Spec;
+
+ my $compiled_parser_dir = File::Spec->catdir(qw/
+ share PrecompiledParsers Parse RecDescent DDL SQLT
+ /);
+
+ # Currently consider only single-name parsers containing a grammar marker
+ # This is somewhat fragile, but better than loading all kinds of parsers
+ # to some of which we may not even have the deps
+ my $parser_libdir = 'lib/SQL/Translator/Parser';
+ for my $parser_fn (glob "$parser_libdir/*.pm") {
+ die "$parser_fn does not look like a readable file\n"
+ unless ( -f $parser_fn and -r $parser_fn );
+
+ my ($type) = $parser_fn =~ /^\Q$parser_libdir\E\/(.+)\.pm$/i
+ or die "$parser_fn not named in expected format\n";
+
+ my $parser_source = do { local (@ARGV, $/) = $parser_fn; <> };
+ next unless $parser_source =~ /\$GRAMMAR.+?END_OF_GRAMMAR/s;
-package MY;
-use File::Basename qw(basename);
-sub libscan {
- my ($self, $file) = @_;
- my $bfile = basename($file);
+ my $precomp_parser_fn = File::Spec->catfile($compiled_parser_dir, "$type.pm");
- return if $bfile =~ /^\.(?:cvs)?ignore$/;
- return if $bfile =~ /\.swp$/;
+ next if (
+ -f $precomp_parser_fn
+ and
+ (stat($parser_fn))[9] <= (stat($precomp_parser_fn))[9]
+ );
+
+
+ print "Precompiling parser for $type\n";
+
+ require $parser_fn;
+ require Parse::RecDescent;
+
+ Parse::RecDescent->Precompile(
+ do {
+ no strict 'refs';
+ ${"SQL::Translator::Parser::${type}::GRAMMAR"}
+ || die "No \$GRAMMAR global found in SQL::Translator::Parser::$type ($parser_fn)\n"
+ },
+ "Parse::RecDescent::DDL::SQLT::$type"
+ );
+
+ rename( "$type.pm", $precomp_parser_fn )
+ or die "Unable to move $type.pm to $compiled_parser_dir: $!\n";
+ }
- return $self->SUPER::libscan($file);
}
+sub _recreate_rt_source {
+ my $base_xml = "t/data/roundtrip.xml";
+ my $autogen_yaml = "t/data/roundtrip_autogen.yaml";
+
+ print "Updating $autogen_yaml\n";
+
+ unlink $autogen_yaml;
+
+ eval {
+
+ use lib 'lib';
+
+ require SQL::Translator;
+ require SQL::Translator::Parser::XML;
+
+ open (my $fh, '>', $autogen_yaml) or die "$autogen_yaml: $!\n";
+
+ my $tr = SQL::Translator->new;
+ my $yaml = $tr->translate (
+ parser => 'XML',
+ file => $base_xml,
+ producer => 'YAML',
+ ) or die sprintf ("Unable to translate %s to YAML: %s\n",
+ $base_xml,
+ $tr->error || 'error unknown'
+ );
+
+ print $fh $yaml;
+ close $fh;
+ };
+
+ if ($@) {
+ warn <<EOE;
+
+=========================================================================
+=============== WARNING !!! =================
+=========================================================================
+
+Unable to update the roundtrip schema (attempt triggered by AUTHOR mode).
+We will still generate a Makefile, but be aware that if you build a dist
+this way, it *WILL* be broken.
+
+-------------------------------------------------------------------------
+$@
+
+Press Enter to continue.
+EOE
+ <>;
+ }
+}