---
name: "Parse::Dia::SQL::Output"
section: "3pm"
platform: "linux"
package: "libparse-dia-sql-perl"
version: "0.31-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Parse::Dia::SQL::Output"
---

# Parse::Dia::SQL::Output(3pm)

Create SQL base class.

## 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)
  ```