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)