[dbsrgits/SQL-Translator.git] / lib / SQL / Translator / Parser / Sybase.pm

package SQL::Translator::Parser::Sybase;

# -------------------------------------------------------------------
# $Id: Sybase.pm,v 1.8 2003-11-05 23:27:09 kycl4rk Exp $
# -------------------------------------------------------------------
# Copyright (C) 2003 Ken Y. Clark <kclark@cpan.org>,
#                    darren chamberlain <darren@cpan.org>,
#                    Chris Mungall <cjm@fruitfly.org>
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
# published by the Free Software Foundation; version 2.
#
# This program is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
# 02111-1307  USA
# -------------------------------------------------------------------

=head1 NAME

SQL::Translator::Parser::Sybase - parser for Sybase

=head1 SYNOPSIS

  use SQL::Translator::Parser::Sybase;

=head1 DESCRIPTION

Mostly parses the output of "dbschema.pl," a Perl script freely
available from http://www.midsomer.org.  The parsing is not complete,
however, and you would probably have much better luck using the
DBI-Sybase parser included with SQL::Translator.

=cut

use strict;

use vars qw[ $DEBUG $VERSION $GRAMMAR @EXPORT_OK ];
$VERSION = sprintf "%d.%02d", q$Revision: 1.8 $ =~ /(\d+)\.(\d+)/;
$DEBUG   = 0 unless defined $DEBUG;

use Data::Dumper;
use Parse::RecDescent;
use Exporter;
use base qw(Exporter);

@EXPORT_OK = qw(parse);

$::RD_ERRORS = 1;
$::RD_WARN   = 1;
$::RD_HINT   = 1;

$GRAMMAR = q{

{ 
    my ( %tables, @table_comments, $table_order );
}

startrule : statement(s) eofile { \%tables }

eofile : /^\Z/

statement : create_table
    | create_procedure
    | create_index
    | create_constraint
    | comment
    | use
    | setuser
    | if
    | print
    | grant
    | exec
    | <error>

use : /use/i WORD GO 
    { @table_comments = () }

setuser : /setuser/i NAME GO

if : /if/i object_not_null begin if_command end GO

if_command : grant
    | create_index
    | create_constraint

object_not_null : /object_id/i '(' ident ')' /is not null/i

print : /\s*/ /print/i /.*/

else : /else/i /.*/

begin : /begin/i

end : /end/i

grant : /grant/i /[^\n]*/

exec : exec_statement(s) GO

exec_statement : /exec/i /[^\n]+/

comment : comment_start comment_middle comment_end
    { 
        my $comment = $item[2];
        $comment =~ s/^\s*|\s*$//mg;
        $comment =~ s/^\**\s*//mg;
        push @table_comments, $comment;
    }

comment_start : /^\s*\/\*/

comment_end : /\s*\*\//

comment_middle : m{([^*]+|\*(?!/))*}

#
# Create table.
#
create_table : /create/i /table/i ident '(' create_def(s /,/) ')' lock(?) on_system(?) GO
    { 
        my $table_owner = $item[3]{'owner'};
        my $table_name  = $item[3]{'name'};

        if ( @table_comments ) {
            $tables{ $table_name }{'comments'} = [ @table_comments ];
            @table_comments = ();
        }

        $tables{ $table_name }{'order'}  = ++$table_order;
        $tables{ $table_name }{'name'}   = $table_name;
        $tables{ $table_name }{'owner'}  = $table_owner;
        $tables{ $table_name }{'system'} = $item[7];

        my $i = 0;
        for my $def ( @{ $item[5] } ) {
            if ( $def->{'supertype'} eq 'field' ) {
                my $field_name = $def->{'name'};
                $tables{ $table_name }{'fields'}{ $field_name } = 
                    { %$def, order => $i };
                $i++;
        
                if ( $def->{'is_primary_key'} ) {
                    push @{ $tables{ $table_name }{'constraints'} }, {
                        type   => 'primary_key',
                        fields => [ $field_name ],
                    };
                }
            }
            elsif ( $def->{'supertype'} eq 'constraint' ) {
                push @{ $tables{ $table_name }{'constraints'} }, $def;
            }
            else {
                push @{ $tables{ $table_name }{'indices'} }, $def;
            }
        }
    }

create_constraint : /create/i constraint 
    {
        @table_comments = ();
        push @{ $tables{ $item[2]{'table'} }{'constraints'} }, $item[2];
    }

create_index : /create/i index
    {
        @table_comments = ();
        push @{ $tables{ $item[2]{'table'} }{'indices'} }, $item[2];
    }

create_procedure : /create/i /procedure/i procedure_body GO
    {
        @table_comments = ();
    }

procedure_body : not_go(s)

not_go : /((?!go).)*/

create_def : field
    | index
    | constraint

blank : /\s*/

field : field_name data_type nullable(?) 
    { 
        $return = { 
            supertype      => 'field',
            name           => $item{'field_name'}, 
            data_type      => $item{'data_type'}{'type'},
            size           => $item{'data_type'}{'size'},
            nullable       => $item[3][0], 
#            default        => $item{'default_val'}[0], 
#            is_auto_inc    => $item{'auto_inc'}[0], 
#            is_primary_key => $item{'primary_key'}[0], 
        } 
    }

constraint : primary_key_constraint
    | unique_constraint

field_name : WORD

index_name : WORD

table_name : WORD

data_type : WORD field_size(?) 
    { 
        $return = { 
            type => $item[1], 
            size => $item[2][0]
        } 
    }

lock : /lock/i /datarows/i

field_type : WORD

field_size : '(' num_range ')' { $item{'num_range'} }

num_range : DIGITS ',' DIGITS
    { $return = $item[1].','.$item[3] }
               | DIGITS
    { $return = $item[1] }


nullable : /not/i /null/i
    { $return = 0 }
    | /null/i
    { $return = 1 }

default_val : /default/i /(?:')?[\w\d.-]*(?:')?/ 
    { $item[2]=~s/'//g; $return=$item[2] }

auto_inc : /auto_increment/i { 1 }

primary_key_constraint : /primary/i /key/i index_name(?) parens_field_list 
    { 
        $return = { 
            supertype => 'constraint',
            name      => $item{'index_name'}[0],
            type      => 'primary_key',
            fields    => $item[4],
        } 
    }

unique_constraint : /unique/i clustered(?) INDEX(?) index_name(?) on_table(?) parens_field_list
    { 
        $return = { 
            supertype => 'constraint',
            type      => 'unique',
            clustered => $item[2][0],
            name      => $item[4][0],
            table     => $item[5][0],
            fields    => $item[6],
        } 
    }

clustered : /clustered/i
    { $return = 1 }
    | /nonclustered/i
    { $return = 0 }

INDEX : /index/i

on_table : /on/i table_name
    { $return = $item[2] }

on_system : /on/i /system/i
    { $return = 1 }

index : clustered(?) INDEX index_name(?) on_table(?) parens_field_list
    { 
        $return = { 
            supertype => 'index',
            type      => 'normal',
            clustered => $item[1][0],
            name      => $item[3][0],
            table     => $item[4][0],
            fields    => $item[5],
        } 
    }

parens_field_list : '(' field_name(s /,/) ')'
    { $item[2] }

ident : QUOTE(?) WORD '.' WORD QUOTE(?)
    { $return = { owner => $item[2], name => $item[4] } }
    | WORD
    { $return = { name  => $item[2] } }

GO : /^go/i

NAME : QUOTE(?) /\w+/ QUOTE(?)
    { $item[2] }

WORD : /[\w#]+/

DIGITS : /\d+/

COMMA : ','

QUOTE : /'/

};

# -------------------------------------------------------------------
sub parse {
    my ( $translator, $data ) = @_;
    my $parser = Parse::RecDescent->new($GRAMMAR);

    local $::RD_TRACE  = $translator->trace ? 1 : undef;
    local $DEBUG       = $translator->debug;

    unless (defined $parser) {
        return $translator->error("Error instantiating Parse::RecDescent ".
            "instance: Bad grammer");
    }

    my $result = $parser->startrule($data);
    return $translator->error( "Parse failed." ) unless defined $result;
    warn Dumper( $result ) if $DEBUG;

    my $schema = $translator->schema;
    my @tables = sort { 
        $result->{ $a }->{'order'} <=> $result->{ $b }->{'order'}
    } keys %{ $result };

    for my $table_name ( @tables ) {
        my $tdata = $result->{ $table_name };
        my $table = $schema->add_table( name => $tdata->{'name'} ) 
                    or die "Can't create table '$table_name': ", $schema->error;

        $table->comments( $tdata->{'comments'} );

        my @fields = sort { 
            $tdata->{'fields'}->{$a}->{'order'} 
            <=>
            $tdata->{'fields'}->{$b}->{'order'}
        } keys %{ $tdata->{'fields'} };

        for my $fname ( @fields ) {
            my $fdata = $tdata->{'fields'}{ $fname };
            my $field = $table->add_field(
                name              => $fdata->{'name'},
                data_type         => $fdata->{'data_type'},
                size              => $fdata->{'size'},
                default_value     => $fdata->{'default'},
                is_auto_increment => $fdata->{'is_auto_inc'},
                is_nullable       => $fdata->{'nullable'},
                comments          => $fdata->{'comments'},
            ) or die $table->error;

            $table->primary_key( $field->name ) if $fdata->{'is_primary_key'};

            for my $qual ( qw[ binary unsigned zerofill list ] ) {
                if ( my $val = $fdata->{ $qual } || $fdata->{ uc $qual } ) {
                    next if ref $val eq 'ARRAY' && !@$val;
                    $field->extra( $qual, $val );
                }
            }

            if ( $field->data_type =~ /(set|enum)/i && !$field->size ) {
                my %extra = $field->extra;
                my $longest = 0;
                for my $len ( map { length } @{ $extra{'list'} || [] } ) {
                    $longest = $len if $len > $longest;
                }
                $field->size( $longest ) if $longest;
            }

            for my $cdata ( @{ $fdata->{'constraints'} } ) {
                next unless $cdata->{'type'} eq 'foreign_key';
                $cdata->{'fields'} ||= [ $field->name ];
                push @{ $tdata->{'constraints'} }, $cdata;
            }
        }

        for my $idata ( @{ $tdata->{'indices'} || [] } ) {
            my $index  =  $table->add_index(
                name   => $idata->{'name'},
                type   => uc $idata->{'type'},
                fields => $idata->{'fields'},
            ) or die $table->error;
        }

        for my $cdata ( @{ $tdata->{'constraints'} || [] } ) {
            my $constraint       =  $table->add_constraint(
                name             => $cdata->{'name'},
                type             => $cdata->{'type'},
                fields           => $cdata->{'fields'},
                reference_table  => $cdata->{'reference_table'},
                reference_fields => $cdata->{'reference_fields'},
                match_type       => $cdata->{'match_type'} || '',
                on_delete        => $cdata->{'on_delete_do'},
                on_update        => $cdata->{'on_update_do'},
            ) or die $table->error;
        }
    }

    return 1;
}

1;

# -------------------------------------------------------------------
# Every hero becomes a bore at last.
# Ralph Waldo Emerson
# -------------------------------------------------------------------

=pod

=head1 AUTHOR

Ken Y. Clark E<lt>kclark@cpan.orgE<gt>.

=head1 SEE ALSO

SQL::Translator, SQL::Translator::Parser::DBI, L<http://www.midsomer.org/>.

=cut
Commit	Line	Data
16dc9970	1	package SQL::Translator::Parser::Sybase;
16dc9970	2
d529894e	3	# -------------------------------------------------------------------
56746e2a	4	# $Id: Sybase.pm,v 1.8 2003-11-05 23:27:09 kycl4rk Exp $
d529894e	5	# -------------------------------------------------------------------
abfa405a	6	# Copyright (C) 2003 Ken Y. Clark <kclark@cpan.org>,
	7	# darren chamberlain <darren@cpan.org>,
	8	# Chris Mungall <cjm@fruitfly.org>
16dc9970	9	#
d529894e	10	# This program is free software; you can redistribute it and/or
	11	# modify it under the terms of the GNU General Public License as
	12	# published by the Free Software Foundation; version 2.
	13	#
	14	# This program is distributed in the hope that it will be useful, but
	15	# WITHOUT ANY WARRANTY; without even the implied warranty of
	16	# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
	17	# General Public License for more details.
	18	#
	19	# You should have received a copy of the GNU General Public License
	20	# along with this program; if not, write to the Free Software
	21	# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
	22	# 02111-1307 USA
	23	# -------------------------------------------------------------------
	24
	25	=head1 NAME
	26
	27	SQL::Translator::Parser::Sybase - parser for Sybase
	28
	29	=head1 SYNOPSIS
	30
	31	use SQL::Translator::Parser::Sybase;
	32
	33	=head1 DESCRIPTION
	34
0839c8a4	35	Mostly parses the output of "dbschema.pl," a Perl script freely
	36	available from http://www.midsomer.org. The parsing is not complete,
	37	however, and you would probably have much better luck using the
	38	DBI-Sybase parser included with SQL::Translator.
d529894e	39
d529894e	40	=cut
16dc9970	41
d9656bd5	42	use strict;
16dc9970	43
d9656bd5	44	use vars qw[ $DEBUG $VERSION $GRAMMAR @EXPORT_OK ];
56746e2a	45	$VERSION = sprintf "%d.%02d", q$Revision: 1.8 $ =~ /(\d+)\.(\d+)/;
d9656bd5	46	$DEBUG = 0 unless defined $DEBUG;
16dc9970	47
d9656bd5	48	use Data::Dumper;
	49	use Parse::RecDescent;
	50	use Exporter;
	51	use base qw(Exporter);
16dc9970	52
d9656bd5	53	@EXPORT_OK = qw(parse);
16dc9970	54
0839c8a4	55	$::RD_ERRORS = 1;
	56	$::RD_WARN = 1;
	57	$::RD_HINT = 1;
16dc9970	58
d9656bd5	59	$GRAMMAR = q{
16dc9970	60
d9656bd5	61	{
56746e2a	62	my ( %tables, @table_comments, $table_order );
d9656bd5	63	}
16dc9970	64
d9656bd5	65	startrule : statement(s) eofile { \%tables }
16dc9970	66
d9656bd5	67	eofile : /^\Z/
16dc9970	68
d9656bd5	69	statement : create_table
	70	\| create_procedure
	71	\| create_index
	72	\| create_constraint
	73	\| comment
	74	\| use
	75	\| setuser
	76	\| if
	77	\| print
	78	\| grant
	79	\| exec
	80	\| <error>
16dc9970	81
d9656bd5	82	use : /use/i WORD GO
d9656bd5	83	{ @table_comments = () }
16dc9970	84
d9656bd5	85	setuser : /setuser/i NAME GO
	86
	87	if : /if/i object_not_null begin if_command end GO
	88
	89	if_command : grant
	90	\| create_index
	91	\| create_constraint
	92
	93	object_not_null : /object_id/i '(' ident ')' /is not null/i
	94
	95	print : /\s/ /print/i /./
	96
	97	else : /else/i /.*/
	98
	99	begin : /begin/i
	100
	101	end : /end/i
	102
	103	grant : /grant/i /[^\n]*/
	104
	105	exec : exec_statement(s) GO
	106
	107	exec_statement : /exec/i /[^\n]+/
	108
	109	comment : comment_start comment_middle comment_end
	110	{
	111	my $comment = $item[2];
	112	$comment =~ s/^\s\|\s$//mg;
	113	$comment =~ s/^\*\s//mg;
	114	push @table_comments, $comment;
	115	}
16dc9970	116
d9656bd5	117	comment_start : /^\s\/\/
	118
	119	comment_end : /\s\\//
	120
	121	comment_middle : m{([^]+\|\(?!/))*}
	122
	123	#
	124	# Create table.
	125	#
	126	create_table : /create/i /table/i ident '(' create_def(s /,/) ')' lock(?) on_system(?) GO
	127	{
	128	my $table_owner = $item[3]{'owner'};
	129	my $table_name = $item[3]{'name'};
	130
	131	if ( @table_comments ) {
	132	$tables{ $table_name }{'comments'} = [ @table_comments ];
	133	@table_comments = ();
16dc9970	134	}
16dc9970	135
56746e2a	136	$tables{ $table_name }{'order'} = ++$table_order;
d9656bd5	137	$tables{ $table_name }{'name'} = $table_name;
	138	$tables{ $table_name }{'owner'} = $table_owner;
	139	$tables{ $table_name }{'system'} = $item[7];
	140
	141	my $i = 0;
	142	for my $def ( @{ $item[5] } ) {
	143	if ( $def->{'supertype'} eq 'field' ) {
	144	my $field_name = $def->{'name'};
	145	$tables{ $table_name }{'fields'}{ $field_name } =
	146	{ %$def, order => $i };
	147	$i++;
	148
	149	if ( $def->{'is_primary_key'} ) {
	150	push @{ $tables{ $table_name }{'constraints'} }, {
	151	type => 'primary_key',
	152	fields => [ $field_name ],
	153	};
	154	}
	155	}
	156	elsif ( $def->{'supertype'} eq 'constraint' ) {
	157	push @{ $tables{ $table_name }{'constraints'} }, $def;
	158	}
	159	else {
	160	push @{ $tables{ $table_name }{'indices'} }, $def;
	161	}
16dc9970	162	}
d9656bd5	163	}
	164
	165	create_constraint : /create/i constraint
	166	{
	167	@table_comments = ();
	168	push @{ $tables{ $item[2]{'table'} }{'constraints'} }, $item[2];
	169	}
	170
	171	create_index : /create/i index
	172	{
	173	@table_comments = ();
	174	push @{ $tables{ $item[2]{'table'} }{'indices'} }, $item[2];
	175	}
	176
	177	create_procedure : /create/i /procedure/i procedure_body GO
	178	{
	179	@table_comments = ();
	180	}
	181
	182	procedure_body : not_go(s)
	183
	184	not_go : /((?!go).)*/
	185
	186	create_def : field
	187	\| index
	188	\| constraint
	189
	190	blank : /\s*/
	191
	192	field : field_name data_type nullable(?)
	193	{
	194	$return = {
	195	supertype => 'field',
	196	name => $item{'field_name'},
	197	data_type => $item{'data_type'}{'type'},
	198	size => $item{'data_type'}{'size'},
	199	nullable => $item[3][0],
	200	# default => $item{'default_val'}[0],
	201	# is_auto_inc => $item{'auto_inc'}[0],
	202	# is_primary_key => $item{'primary_key'}[0],
	203	}
	204	}
	205
	206	constraint : primary_key_constraint
	207	\| unique_constraint
	208
	209	field_name : WORD
	210
	211	index_name : WORD
	212
	213	table_name : WORD
	214
	215	data_type : WORD field_size(?)
	216	{
	217	$return = {
	218	type => $item[1],
	219	size => $item[2][0]
	220	}
	221	}
	222
	223	lock : /lock/i /datarows/i
	224
	225	field_type : WORD
	226
227	field_size : '(' num_range ')' { $item{'num_range'} }
228
229	num_range : DIGITS ',' DIGITS
230	{ $return = $item[1].','.$item[3] }
231	\| DIGITS
232	{ $return = $item[1] }
233
16dc9970	234
d9656bd5	235	nullable : /not/i /null/i
	236	{ $return = 0 }
	237	\| /null/i
	238	{ $return = 1 }
16dc9970	239
d9656bd5	240	default_val : /default/i /(?:')?[\w\d.-]*(?:')?/
d9656bd5	241	{ $item[2]=~s/'//g; $return=$item[2] }
16dc9970	242
d9656bd5	243	auto_inc : /auto_increment/i { 1 }
16dc9970	244
d9656bd5	245	primary_key_constraint : /primary/i /key/i index_name(?) parens_field_list
	246	{
	247	$return = {
	248	supertype => 'constraint',
	249	name => $item{'index_name'}[0],
	250	type => 'primary_key',
	251	fields => $item[4],
	252	}
	253	}
16dc9970	254
d9656bd5	255	unique_constraint : /unique/i clustered(?) INDEX(?) index_name(?) on_table(?) parens_field_list
	256	{
	257	$return = {
	258	supertype => 'constraint',
	259	type => 'unique',
	260	clustered => $item[2][0],
	261	name => $item[4][0],
	262	table => $item[5][0],
	263	fields => $item[6],
	264	}
	265	}
	266
	267	clustered : /clustered/i
	268	{ $return = 1 }
	269	\| /nonclustered/i
	270	{ $return = 0 }
	271
	272	INDEX : /index/i
	273
	274	on_table : /on/i table_name
	275	{ $return = $item[2] }
	276
	277	on_system : /on/i /system/i
	278	{ $return = 1 }
	279
	280	index : clustered(?) INDEX index_name(?) on_table(?) parens_field_list
	281	{
	282	$return = {
	283	supertype => 'index',
	284	type => 'normal',
	285	clustered => $item[1][0],
	286	name => $item[3][0],
	287	table => $item[4][0],
	288	fields => $item[5],
	289	}
	290	}
	291
	292	parens_field_list : '(' field_name(s /,/) ')'
	293	{ $item[2] }
	294
	295	ident : QUOTE(?) WORD '.' WORD QUOTE(?)
	296	{ $return = { owner => $item[2], name => $item[4] } }
	297	\| WORD
	298	{ $return = { name => $item[2] } }
	299
	300	GO : /^go/i
	301
	302	NAME : QUOTE(?) /\w+/ QUOTE(?)
	303	{ $item[2] }
	304
	305	WORD : /[\w#]+/
	306
	307	DIGITS : /\d+/
	308
	309	COMMA : ','
	310
	311	QUOTE : /'/
16dc9970	312
	313	};
	314
d9656bd5	315	# -------------------------------------------------------------------
	316	sub parse {
	317	my ( $translator, $data ) = @_;
	318	my $parser = Parse::RecDescent->new($GRAMMAR);
	319
	320	local $::RD_TRACE = $translator->trace ? 1 : undef;
	321	local $DEBUG = $translator->debug;
	322
	323	unless (defined $parser) {
	324	return $translator->error("Error instantiating Parse::RecDescent ".
	325	"instance: Bad grammer");
	326	}
	327
	328	my $result = $parser->startrule($data);
	329	return $translator->error( "Parse failed." ) unless defined $result;
	330	warn Dumper( $result ) if $DEBUG;
	331
	332	my $schema = $translator->schema;
	333	my @tables = sort {
	334	$result->{ $a }->{'order'} <=> $result->{ $b }->{'order'}
	335	} keys %{ $result };
	336
	337	for my $table_name ( @tables ) {
	338	my $tdata = $result->{ $table_name };
	339	my $table = $schema->add_table( name => $tdata->{'name'} )
	340	or die "Can't create table '$table_name': ", $schema->error;
	341
	342	$table->comments( $tdata->{'comments'} );
	343
	344	my @fields = sort {
	345	$tdata->{'fields'}->{$a}->{'order'}
	346	<=>
	347	$tdata->{'fields'}->{$b}->{'order'}
	348	} keys %{ $tdata->{'fields'} };
	349
	350	for my $fname ( @fields ) {
	351	my $fdata = $tdata->{'fields'}{ $fname };
	352	my $field = $table->add_field(
	353	name => $fdata->{'name'},
	354	data_type => $fdata->{'data_type'},
	355	size => $fdata->{'size'},
	356	default_value => $fdata->{'default'},
	357	is_auto_increment => $fdata->{'is_auto_inc'},
	358	is_nullable => $fdata->{'nullable'},
	359	comments => $fdata->{'comments'},
	360	) or die $table->error;
	361
	362	$table->primary_key( $field->name ) if $fdata->{'is_primary_key'};
	363
	364	for my $qual ( qw[ binary unsigned zerofill list ] ) {
	365	if ( my $val = $fdata->{ $qual } \|\| $fdata->{ uc $qual } ) {
	366	next if ref $val eq 'ARRAY' && !@$val;
	367	$field->extra( $qual, $val );
	368	}
	369	}
	370
	371	if ( $field->data_type =~ /(set\|enum)/i && !$field->size ) {
	372	my %extra = $field->extra;
	373	my $longest = 0;
	374	for my $len ( map { length } @{ $extra{'list'} \|\| [] } ) {
	375	$longest = $len if $len > $longest;
	376	}
	377	$field->size( $longest ) if $longest;
	378	}
379
380	for my $cdata ( @{ $fdata->{'constraints'} } ) {
381	next unless $cdata->{'type'} eq 'foreign_key';
382	$cdata->{'fields'} \|\|= [ $field->name ];
383	push @{ $tdata->{'constraints'} }, $cdata;
384	}
385	}
386
387	for my $idata ( @{ $tdata->{'indices'} \|\| [] } ) {
388	my $index = $table->add_index(
389	name => $idata->{'name'},
390	type => uc $idata->{'type'},
391	fields => $idata->{'fields'},
392	) or die $table->error;
393	}
394
395	for my $cdata ( @{ $tdata->{'constraints'} \|\| [] } ) {
396	my $constraint = $table->add_constraint(
397	name => $cdata->{'name'},
398	type => $cdata->{'type'},
399	fields => $cdata->{'fields'},
400	reference_table => $cdata->{'reference_table'},
401	reference_fields => $cdata->{'reference_fields'},
402	match_type => $cdata->{'match_type'} \|\| '',
403	on_delete => $cdata->{'on_delete_do'},
404	on_update => $cdata->{'on_update_do'},
405	) or die $table->error;
406	}
407	}
408
409	return 1;
410	}
411
16dc9970	412	1;
16dc9970	413
d9656bd5	414	# -------------------------------------------------------------------
16dc9970	415	# Every hero becomes a bore at last.
16dc9970	416	# Ralph Waldo Emerson
d9656bd5	417	# -------------------------------------------------------------------
16dc9970	418
d529894e	419	=pod
16dc9970	420
	421	=head1 AUTHOR
	422
d9656bd5	423	Ken Y. Clark E<lt>kclark@cpan.orgE<gt>.
16dc9970	424
	425	=head1 SEE ALSO
	426
0839c8a4	427	SQL::Translator, SQL::Translator::Parser::DBI, L<http://www.midsomer.org/>.
16dc9970	428
16dc9970	429	=cut