Parse::Dia::SQL::Output.3pm

Langue: en

Version: 2010-05-21 (ubuntu - 24/10/10)

Section: 3 (Bibliothèques de fonctions)

Sommaire

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)