NAME

Parse::Dia::SQL::Output - Create SQL base class.

SYNOPSIS

use Parse::Dia::SQL;
my $dia = Parse::Dia::SQL->new(...);
my $output = $dia->get_output_instance();
print $output->get_sql();

DESCRIPTION

This is the base sql formatter class for creating sql. It contains basic functionality, which can be overridden in subclasses, one for each RDBMS.

SEE ALSO

Parse::Dia::SQL::Output::DB2
Parse::Dia::SQL::Output::Oracle

METHODS

new()

The constructor. Arguments:

db    - the target database type

get_sql()

Return all sql. The sequence of statements is as follows:

constraints drop
permissions drop
view drop
schema drop
smallpackage pre sql
schema create
view create
permissions create
inserts
smallpackage post sql
associations create  (indices first, then foreign keys)