1 package SQL::Translator::Parser::DBI::Oracle;
3 # -------------------------------------------------------------------
4 # Copyright (C) 2006-2009 SQLFairy Authors
6 # This program is free software; you can redistribute it and/or
7 # modify it under the terms of the GNU General Public License as
8 # published by the Free Software Foundation; version 2.
10 # This program is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13 # General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with this program; if not, write to the Free Software
17 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
19 # -------------------------------------------------------------------
23 SQL::Translator::Parser::DBI::Oracle - parser for DBD::Oracle
27 See SQL::Translator::Parser::DBI.
31 Uses DBI introspection methods to determine schema details.
38 use SQL::Translator::Schema::Constants;
39 use SQL::Translator::Schema::Table;
40 use SQL::Translator::Schema::Field;
41 use SQL::Translator::Schema::Constraint;
43 our $VERSION = '1.59';
46 my ( $tr, $dbh ) = @_;
48 my $schema = $tr->schema;
50 my $db_user = uc $tr->parser_args()->{db_user};
51 my $sth = $dbh->table_info(undef, $db_user, '%', 'TABLE');
53 while(my $table_info = $sth->fetchrow_hashref('NAME_uc')) {
54 next if ($table_info->{TABLE_NAME} =~ /\$/);
58 my $table = $schema->add_table(
59 name => $table_info->{TABLE_NAME},
60 type => $table_info->{TABLE_TYPE},
63 # add the fields (columns) for this table
67 $sth = $dbh->column_info(
69 $table_info->{TABLE_SCHEM},
70 $table_info->{TABLE_NAME},
74 while(my $column = $sth->fetchrow_hashref('NAME_uc')) {
75 my $f = $table->add_field(
76 name => $column->{COLUMN_NAME},
77 default_value => $column->{COLUMN_DEF},
78 data_type => $column->{TYPE_NAME},
79 order => $column->{ORDINAL_POSITION},
80 size => $column->{COLUMN_SIZE},
81 ) || die $table->error;
83 $f->is_nullable( $column->{NULLABLE} == 1 );
86 # add the primary key info
88 $sth = $dbh->primary_key_info(
90 $table_info->{TABLE_SCHEM},
91 $table_info->{TABLE_NAME},
94 while(my $primary_key = $sth->fetchrow_hashref('NAME_uc')) {
95 my $f = $table->get_field( $primary_key->{COLUMN_NAME} );
96 $f->is_primary_key(1);
99 # add the foreign key info (constraints)
101 $sth = $dbh->foreign_key_info(
106 $table_info->{TABLE_SCHEM},
107 $table_info->{TABLE_NAME},
111 while(my $foreign_key = $sth->fetchrow_hashref('NAME_uc')) {
112 my $name = $foreign_key->{FK_NAME};
113 $cons->{$name}->{reference_table} = $foreign_key->{UK_TABLE_NAME};
114 push @{ $cons->{$name}->{fields} },
115 $foreign_key->{FK_COLUMN_NAME};
116 push @{ $cons->{$name}->{reference_fields} },
117 $foreign_key->{UK_COLUMN_NAME};
120 for my $name ( keys %$cons ) {
121 my $c = $table->add_constraint(
124 fields => $cons->{$name}->{fields},
125 reference_fields => $cons->{$name}->{reference_fields},
126 reference_table => $cons->{$name}->{reference_table},
127 ) || die $table->error;
140 Earl Cahill E<lt>cpan@spack.netE<gt>.
142 =head1 ACKNOWLEDGEMENT
144 Initial revision of this module came almost entirely from work done by
145 Todd Hepler E<lt>thepler@freeshell.orgE<gt>. My changes were
146 quite minor (ensuring NAME_uc, changing a couple variable names,
147 skipping tables with a $ in them).
149 Todd claimed his work to be an almost verbatim copy of
150 SQL::Translator::Parser::DBI::PostgreSQL revision 1.7
152 For me, the real work happens in DBD::Oracle and DBI, which, also
153 for me, that is the beauty of having introspection methods in DBI.
157 SQL::Translator, DBD::Oracle.