Andreas Faafeng > Parse-Dia-SQL-0.10_01 > Parse::Dia::SQL

Download:
Parse-Dia-SQL-0.10_01.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  1
View Bugs
Report a bug
Module Version: 0.10_01   Source   Latest Release: Parse-Dia-SQL-0.12

NAME ^

Parse::Dia::SQL - Convert Dia class diagrams into SQL.

SYNOPSIS ^

    use Parse::Dia::SQL;
    my $dia = Parse::Dia::SQL->new(
      file => 't/data/TestERD.dia',
      db   => 'db2'
    );
    print $dia->get_sql();

    # or command-line version
    perl parsediasql --file t/data/TestERD.dia --db db2

DESCRIPTION ^

Dia is a diagram creation program for Linux, Unix and Windows released under the GNU General Public License.

Parse::Dia::SQL converts Dia class diagrams into SQL.

Parse::Dia::SQL is the parser that interprets the .dia file(s) into an internal datastructure.

Parse::Dia::SQL::Output (or one of its sub classes) can take the datastructure and generate the SQL statements it represents.

MODELLING HOWTO ^

See http://tedia2sql.tigris.org/usingtedia2sql.html

Modelling differences from tedia2sql

DIA VERSIONS ^

Parse::Dia::SQL has been tested with Dia versions 0.93 - 0.96. Dia version 0.97 changed the way associations were stored, and support for this has been added as of Parse::Dia::SQL version 0.10_01.

DATABASE SUPPORT ^

The following databases are supported:

DB2
Informix
Ingres
Oracle
Postgres
Sas
SQLite3
Sybase
MySQL InnoDB
MySQL MyISAM

Adding support for additional databases means to create a subclass of Parse::Dia::SQL::Output.

Patches are welcome.

AUTHOR ^

Parse::Dia::SQL is based on tedia2sql by Tim Ellis and others. See the AUTHORS file for details.

Modified by Andreas Faafeng, <aff at cpan.org> for release on CPAN.

BUGS ^

Please report any bugs or feature requests to bug-parse-dia-sql at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Parse-Dia-SQL. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT ^

You can find documentation for this module with the perldoc command.

    perldoc Parse::Dia::SQL

You can also look for information at:

SEE ALSO ^

ACKNOWLEDGEMENTS ^

See the AUTHORS file.

LICENSE ^

This program is released under the GNU General Public License.

TERMINOLOGY ^

By database we mean relational database managment system (RDBMS).

METHODS ^

new()

The constructor. Mandatory arguments:

  file  - The .dia file to parse
  db    - The target database type

Dies if target database is unknown or unsupported.

get_sql()

Return sql for given db. Calls underlying methods that performs parsing and sql generation.