Parse::Dia::SQL::Output::Sybase - Create SQL for Sybase.

Parse-Dia-SQL documentation Contained in the Parse-Dia-SQL distribution.

Index

Code Index:

NAME

Top

Parse::Dia::SQL::Output::Sybase - Create SQL for Sybase.

SEE ALSO

Top

 Parse::Dia::SQL::Output

new

The constructor. Arguments:

_get_drop_index_sql

create drop index for index on table with given name.

Parse-Dia-SQL documentation Contained in the Parse-Dia-SQL distribution. 
package Parse::Dia::SQL::Output::Sybase;

# $Id: Sybase.pm,v 1.2 2009/03/02 13:41:39 aff Exp $


use warnings;
use strict;

use Data::Dumper;
use File::Spec::Functions qw(catfile);

use lib q{lib};
use base q{Parse::Dia::SQL::Output}; # extends

require Parse::Dia::SQL::Logger;
require Parse::Dia::SQL::Const;


sub new {
  my ( $class, %param ) = @_;
  my $self = {};

  # Set defaults for sybase
  $param{db}                     = q{sybase};
  $param{object_name_max_length} = $param{object_name_max_length} || 30;
  $param{end_of_statement}       = $param{end_of_statement} || "\ngo";

  $self = $class->SUPER::new(%param);
  bless( $self, $class );

	$self->{log}->warn(qq{Using object_name_max_length }. $param{object_name_max_length});

  return $self;
}


sub _get_drop_index_sql {
  my ( $self, $tablename, $indexname ) = @_;
  return qq{drop index $tablename.$indexname}
    . $self->{end_of_statement}
    . $self->{newline};
}




1;

__END__