package SQL::Translator::Parser::Oracle;
# -------------------------------------------------------------------
-# $Id: Oracle.pm,v 1.27 2007-03-06 21:09:32 duality72 Exp $
-# -------------------------------------------------------------------
-# Copyright (C) 2002-4 SQLFairy Authors
+# 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
use strict;
use vars qw[ $DEBUG $VERSION $GRAMMAR @EXPORT_OK ];
-$VERSION = sprintf "%d.%02d", q$Revision: 1.27 $ =~ /(\d+)\.(\d+)/;
+$VERSION = '1.59';
$DEBUG = 0 unless defined $DEBUG;
use Data::Dumper;
$GRAMMAR = q`
-{ my ( %tables, %indices, %constraints, $table_order, @table_comments ) }
+{ my ( %tables, %indices, %constraints, $table_order, @table_comments, %views, $view_order, %procedures, $proc_order ) }
#
# The "eofile" rule makes the parser fail if any "statement" rule
tables => \%tables,
indices => \%indices,
constraints => \%constraints,
+ views => \%views,
+ procedures => \%procedures,
};
}
$return = "$item[2]($arg_list)";
}
+create : /create/i /or replace/i /procedure/i table_name not_end m#^/$#im
+ {
+ @table_comments = ();
+ my $proc_name = $item[4];
+ # Hack to strip owner from procedure name
+ $proc_name =~ s#.*\.##;
+ my $owner = '';
+ my $sql = "$item[1] $item[2] $item[3] $item[4] $item[5]";
+
+ $procedures{ $proc_name }{'order'} = ++$proc_order;
+ $procedures{ $proc_name }{'name'} = $proc_name;
+ $procedures{ $proc_name }{'owner'} = $owner;
+ $procedures{ $proc_name }{'sql'} = $sql;
+ }
+
+not_end: m#.*?(?=^/$)#ism
+
+create : /create/i /or replace/i /force/i /view/i table_name not_delimiter ';'
+ {
+ @table_comments = ();
+ my $view_name = $item[5];
+ # Hack to strip owner from view name
+ $view_name =~ s#.*\.##;
+ my $sql = "$item[1] $item[2] $item[3] $item[4] $item[5] $item[6] $item[7]";
+
+ $views{ $view_name }{'order'} = ++$view_order;
+ $views{ $view_name }{'name'} = $view_name;
+ $views{ $view_name }{'sql'} = $sql;
+ }
+
+not_delimiter: /.*?(?=;)/is
+
# Create anything else (e.g., domain, function, etc.)
create : ...!create_table ...!create_index /create/i WORD /[^;]+/ ';'
{ @table_comments = () }
| NAME
{ $item[1] }
-create_definition : field
- | table_constraint
+create_definition : table_constraint
+ | field
| <error>
table_comment : comment
name => $item{'constraint_name(?)'}[0] || '',
type => $type,
expression => $type eq 'check' ? $expression : '',
- deferrable => $item{'deferrable'},
- deferred => $item{'deferred'},
+ deferrable => $desc->{'deferrable'},
+ deferred => $desc->{'deferred'},
reference_table => $desc->{'reference_table'},
reference_fields => $desc->{'reference_fields'},
# match_type => $desc->{'match_type'},
{ $return = { type => 'unique' } }
| /primary\s+key/i
{ $return = { type => 'primary_key' } }
- | /check/i '(' /[^)]+/ ')'
- { $return = { type => 'check', expression => $item[3] } }
+ | /check/i check_expression
+ {
+ $return = {
+ type => 'check',
+ expression => $item[2],
+ };
+ }
| /references/i table_name parens_word_list(?) on_delete(?)
{
$return = {
}
}
+LPAREN : '('
+
+RPAREN : ')'
+
+check_condition_text : /.+\s+in\s+\([^)]+\)/i
+ | /[^)]+/
+
+check_expression : LPAREN check_condition_text RPAREN
+ { $return = join( ' ', map { $_ || () }
+ $item[1], $item[2], $item[3], $item[4][0] )
+ }
+
constraint_state : deferrable { $return = { type => $item[1] } }
| deferred { $return = { type => $item[1] } }
| /(no)?rely/i { $return = { type => $item[1] } }
|
/long\s+raw/i { $return = 'long raw' }
|
- /(long|date|timestamp|raw|rowid|urowid|mlslabel|clob|nclob|blob|bfile|float)/i { $item[1] }
+ /(long|date|timestamp|raw|rowid|urowid|mlslabel|clob|nclob|blob|bfile|float|double)/i { $item[1] }
parens_value_list : '(' VALUE(s /,/) ')'
{ $item[2] }
}
}
|
- /check/ '(' /(.+)/ ')'
+ /check/i check_expression /^(en|dis)able/i
{
$return = {
type => 'check',
- expression => $item[3],
+ expression => join(' ', $item[2], $item[3]),
}
}
|
@{ $constraints->{ $table_name } || [] };
for my $idata ( @{ $tdata->{'indices'} || [] } ) {
-open(OUT, ">>ACK");
-print OUT $idata->{name}, "\n";
my $index = $table->add_index(
name => $idata->{'name'},
type => uc $idata->{'type'},
name => $cdata->{'name'},
type => $cdata->{'type'},
fields => $cdata->{'fields'},
+ expression => $cdata->{'expression'},
reference_table => $cdata->{'reference_table'},
reference_fields => $cdata->{'reference_fields'},
match_type => $cdata->{'match_type'} || '',
- on_delete => $cdata->{'on_delete'} || $cdata->{'on_delete_do'},
- on_update => $cdata->{'on_update'} || $cdata->{'on_update_do'},
+ on_delete => $cdata->{'on_delete'}
+ || $cdata->{'on_delete_do'},
+ on_update => $cdata->{'on_update'}
+ || $cdata->{'on_update_do'},
) or die $table->error;
}
}
+
+ my @procedures = sort {
+ $result->{procedures}->{ $a }->{'order'} <=> $result->{procedures}->{ $b }->{'order'}
+ } keys %{ $result->{procedures} };
+ foreach my $proc_name (@procedures) {
+ $schema->add_procedure(
+ name => $proc_name,
+ owner => $result->{procedures}->{$proc_name}->{owner},
+ sql => $result->{procedures}->{$proc_name}->{sql},
+ );
+ }
+
+ my @views = sort {
+ $result->{views}->{ $a }->{'order'} <=> $result->{views}->{ $b }->{'order'}
+ } keys %{ $result->{views} };
+ foreach my $view_name (keys %{ $result->{views} }) {
+ $schema->add_view(
+ name => $view_name,
+ sql => $result->{views}->{$view_name}->{sql},
+ );
+ }
return 1;
}
=head1 AUTHOR
-Ken Y. Clark E<lt>kclark@cpan.orgE<gt>.
+Ken Youens-Clark E<lt>kclark@cpan.orgE<gt>.
=head1 SEE ALSO