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

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

=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 warnings;

our $VERSION = '1.61';

our $DEBUG;
$DEBUG   = 0 unless defined $DEBUG;

use Data::Dumper;
use SQL::Translator::Utils qw/ddl_parser_instance/;

use base qw(Exporter);
our @EXPORT_OK = qw(parse);

our $GRAMMAR = <<'END_OF_GRAMMAR';

{
    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 : /'/

END_OF_GRAMMAR

sub parse {
    my ( $translator, $data ) = @_;

    # Enable warnings within the Parse::RecDescent module.
    local $::RD_ERRORS = 1 unless defined $::RD_ERRORS; # Make sure the parser dies when it encounters an error
    local $::RD_WARN   = 1 unless defined $::RD_WARN; # Enable warnings. This will warn on unused rules &c.
    local $::RD_HINT   = 1 unless defined $::RD_HINT; # Give out hints to help fix problems.

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

    my $parser = ddl_parser_instance('Sybase');

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