2 class SQL::Translator {
4 use MooseX::Types::Moose qw(Bool HashRef Int Str Undef);
6 use SQL::Translator::Types qw(DBIHandle Parser Producer Schema);
7 use SQL::Translator::Object::Schema;
9 our $VERSION = '0.001';
10 $VERSION = eval $VERSION;
28 handles => [ qw(parse) ],
29 predicate => 'has_parser',
36 handles => [ qw(produce) ],
37 predicate => 'has_producer',
43 predicate => 'has_dbh',
50 clearer => '_clear_schema',
51 default => sub { SQL::Translator::Object::Schema->new },
54 has 'parser_args' => (
57 predicate => 'has_parser_args',
60 has 'producer_args' => (
63 predicate => 'has_producer_args',
71 has 'version' => (isa => Str, is => 'ro', default => $VERSION);
72 has 'add_drop_table' => (isa => Bool, is => 'rw', default => 0);
73 has 'no_comments' => (isa => Bool, is => 'rw', default => 0);
74 has 'show_warnings' => (isa => Bool, is => 'rw', default => 0);
75 has 'trace' => (isa => Bool, is => 'rw', default => 0);
76 has 'quote_table_names' => (isa => Bool, is => 'rw', default => 0);
77 has 'quote_field_names' => (isa => Bool, is => 'rw', default => 0);
78 has 'filename' => (isa => Str, is => 'rw');
80 has '_producer_mapping' => (
83 default => sub { { MySQL => 'SQL::MySQL', SQLite => 'SQL::SQLite', PostgreSQL => 'SQL::PostgreSQL', XML => 'XML', YAML => 'YAML' } }
86 method _build__parser {
87 my $class = 'SQL::Translator::Parser';
89 Class::MOP::load_class($class);
93 $parser = $class->new({ translator => $self, dbh => $self->dbh });
95 $parser = $class->new({ translator => $self, type => $self->parser || '' });
101 method _build__producer {
102 my $mapping = $self->_producer_mapping;
104 my $class = 'SQL::Translator::Producer';
105 my $role = $class . '::' . $mapping->{$self->producer};
107 Class::MOP::load_class($class);
108 Class::MOP::load_class($role);
110 my $producer = $class->new({ translator => $self });
111 $role->meta->apply($producer);
116 method translate(:$data, :$producer?, :$producer_args?, :$parser?, :$parser_args?) {
119 $self->_clear_schema if defined $parser;
120 $data ||= $self->data;
122 $parser ||= $self->parser unless $self->has_parser;
123 if (defined $parser) {
124 $self->_clear_parser;
125 $self->parser($parser);
127 $return = $self->schema;
130 $producer ||= $self->producer unless $self->has_producer;
131 if (defined $producer) {
132 $self->_clear_producer;
133 $self->producer($producer);
134 $return = $self->produce;
140 method parser_type { return $self->parser }
141 method producer_type { return $self->producer }
143 method engine_version(Int|Str|Undef $v, Str $target = 'perl') {
144 return undef unless $v;
149 if ( $v =~ / ^ (\d+) \. (\d{1,3}) (?: \. (\d{1,3}) )? $ /x ) {
150 push @vers, $1, $2, $3;
153 # XYYZZ (mysql) style
154 elsif ( $v =~ / ^ (\d) (\d{2}) (\d{2}) $ /x ) {
155 push @vers, $1, $2, $3;
158 # XX.YYYZZZ (perl) style or simply X
159 elsif ( $v =~ / ^ (\d+) (?: \. (\d{3}) (\d{3}) )? $ /x ) {
160 push @vers, $1, $2, $3;
163 #how do I croak sanely here?
164 die "Unparseable MySQL version '$v'";
167 if ($target eq 'perl') {
168 return sprintf ('%d.%03d%03d', map { $_ || 0 } (@vers) );
170 elsif ($target eq 'mysql') {
171 return sprintf ('%d%02d%02d', map { $_ || 0 } (@vers) );
174 #how do I croak sanely here?
175 die "Unknown version target '$target'";