X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator.pm;h=f9083faaf7c3330cdca92c446335b7d42b4a3b35;hb=f48e6f551a4c6e9afdd8418d13f5a3bab1df72ab;hp=78a0041ca5363c9ad1c0702d25f630441232c9b2;hpb=94becd97bf42058871446890421b4a8e0d4a65c2;p=dbsrgits%2FSQL-Translator-2.0-ish.git diff --git a/lib/SQL/Translator.pm b/lib/SQL/Translator.pm index 78a0041..f9083fa 100644 --- a/lib/SQL/Translator.pm +++ b/lib/SQL/Translator.pm @@ -1,3 +1,151 @@ -package SQL::Translator; +use MooseX::Declare; +class SQL::Translator { + use TryCatch; + use MooseX::Types::Moose qw(Bool HashRef Str); + use SQL::Translator::Types qw(DBIHandle Parser Producer Schema); + use SQL::Translator::Object::Schema; -1; + has 'parser' => ( + isa => Str, + is => 'rw', + init_arg => 'from', + ); + + has 'producer' => ( + isa => Str, + is => 'rw', + init_arg => 'to', + ); + + has '_parser' => ( + isa => Parser, + is => 'rw', + lazy_build => 1, + handles => [ qw(parse) ], + ); + + has '_producer' => ( + isa => Producer, + is => 'rw', + lazy_build => 1, + handles => [ qw(produce) ], + ); + + has 'dbh' => ( + isa => DBIHandle, + is => 'ro', + predicate => 'has_dbh', + ); + + has 'schema' => ( + isa => Schema, + is => 'rw', + lazy => 1, + default => sub { SQL::Translator::Object::Schema->new }, + ); + + has 'parser_args' => ( + isa => HashRef, + is => 'rw', + predicate => 'has_parser_args', + ); + + has 'producer_args' => ( + isa => HashRef, + is => 'rw', + predicate => 'has_producer_args', + ); + + has 'add_drop_table' => (isa => Bool, is => 'rw', default => 0); + has 'no_comments' => (isa => Bool, is => 'rw', default => 0); + has 'show_warnings' => (isa => Bool, is => 'rw', default => 1); + has 'trace' => (isa => Bool, is => 'rw', default => 0); + has 'quote_table_names' => (isa => Bool, is => 'rw', default => 0); + has 'quote_field_names' => (isa => Bool, is => 'rw', default => 0); + has 'version' => (isa => Str, is => 'rw'); + has 'filename' => (isa => Str, is => 'rw'); + + method _build__parser { + my $class = 'SQL::Translator::Parser'; + + Class::MOP::load_class($class); + + my $parser; + if ($self->has_dbh) { + $parser = $class->new({ translator => $self, dbh => $self->dbh }); + } else { + $parser = $class->new({ translator => $self, type => $self->parser || '' }); + } + + return $parser; + } + + method _build__producer { + my $class = 'SQL::Translator::Producer'; + my $role = $class . '::' . $self->producer; + + Class::MOP::load_class($class); + try { + Class::MOP::load_class($role) + } catch ($e) { + $role = $class . '::SQL::' . $self->producer; + Class::MOP::load_class($role) + } + + my $producer = $class->new({ translator => $self }); + $role->meta->apply($producer); + + return $producer; + } + + method translate(:$data, :$producer?, :$producer_args?, :$parser?, :$parser_args?) { + if ($parser) { + $self->_clear_parser; + $self->parser($parser); + $self->parse($data); + $self->schema; + } elsif ($producer) { + $self->_clear_producer; + $self->parse($data) if $data; + $self->producer($producer); + $self->produce; + } + } + + method parser_type { return $self->parser } + method producer_type { return $self->producer } + + method engine_version(Int|Str $v, Str $target = 'perl') { + my @vers; + + # X.Y.Z style + if ( $v =~ / ^ (\d+) \. (\d{1,3}) (?: \. (\d{1,3}) )? $ /x ) { + push @vers, $1, $2, $3; + } + + # XYYZZ (mysql) style + elsif ( $v =~ / ^ (\d) (\d{2}) (\d{2}) $ /x ) { + push @vers, $1, $2, $3; + } + + # XX.YYYZZZ (perl) style or simply X + elsif ( $v =~ / ^ (\d+) (?: \. (\d{3}) (\d{3}) )? $ /x ) { + push @vers, $1, $2, $3; + } + else { + #how do I croak sanely here? + die "Unparseable MySQL version '$v'"; + } + + if ($target eq 'perl') { + return sprintf ('%d.%03d%03d', map { $_ || 0 } (@vers) ); + } + elsif ($target eq 'mysql') { + return sprintf ('%d%02d%02d', map { $_ || 0 } (@vers) ); + } + else { + #how do I croak sanely here? + die "Unknown version target '$target'"; + } + } +}