| SPOPS documentation | Contained in the SPOPS distribution. |
SPOPS::Import::DBI::TableTransform::InterBase - Table transformations for InterBase/FirebirdSQL
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) )
InterBase/FirebirdSQL-specific type conversions for the auto-increment and other field types.
increment
Returns 'INT NOT NULL'
increment_type
Returns 'INT'
datetime
Returns 'TIMESTAMP'
None known.
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.
Copyright (c) 2002-2004 intes.net, inc.. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Chris Winters <chris@cwinters.com>
| SPOPS documentation | Contained in the SPOPS distribution. |
package SPOPS::Import::DBI::TableTransform::InterBase; # $Id: InterBase.pm,v 3.3 2004/06/02 00:48:23 lachoy Exp $ use strict; use base qw( SPOPS::Import::DBI::TableTransform ); $SPOPS::Import::DBI::TableTransform::InterBase::VERSION = sprintf("%d.%02d", q$Revision: 3.3 $ =~ /(\d+)\.(\d+)/); sub increment { my ( $self, $sql ) = @_; $$sql =~ s/%%INCREMENT%%/INT NOT NULL/g; } sub increment_type { my ( $self, $sql ) = @_; $$sql =~ s/%%INCREMENT_TYPE%%/INT/g; } sub datetime { my ( $self, $sql ) = @_; $$sql =~ s/%%DATETIME%%/TIMESTAMP/g; } 1; __END__