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)