SPOPS::Import::DBI::TableTransform::InterBase - Table transformations for InterBase/FirebirdSQL


SPOPS documentation  | view source Contained in the SPOPS distribution.

Index


NAME

Top

SPOPS::Import::DBI::TableTransform::InterBase - Table transformations for InterBase/FirebirdSQL

SYNOPSIS

Top

 my $table = qq/
   CREATE TABLE blah ( id %%INCREMENT%% primary key,
                       name varchar(50) )
 /;
 my $transformer = SPOPS::Import::DBI::TableTransform->new( 'interbase' );
 $transformer->increment( \$table );
 print $table;

 # Output:
 # CREATE TABLE blah ( id INT NOT NULL primary key,
 #                     name varchar(50) )

DESCRIPTION

Top

InterBase/FirebirdSQL-specific type conversions for the auto-increment and other field types.

METHODS

Top

increment

Returns 'INT NOT NULL'

increment_type

Returns 'INT'

datetime

Returns 'TIMESTAMP'

BUGS

Top

None known.

TO DO

Top

Add hook for extra statement

Since InterBase/FirebirdSQL supports a sequence-based increment type, think about adding a hook for an extra statement to be registered.

SEE ALSO

Top

SPOPS::Import::DBI::TableTransform

COPYRIGHT

Top

AUTHORS

Top

Chris Winters <chris@cwinters.com>


SPOPS documentation  | view source Contained in the SPOPS distribution.