NAME

MySQL::Workbench::Parser - parse .mwb files created with MySQL Workbench

VERSION

version 1.05

SYNOPSIS

DESCRIPTION

The MySQL Workbench is a tool to design database entity relationship models. This parser parses .mwb files created with that tool and extracts all relevant information.

METHODS

new

Create a new parser object

    my $parser = MySQL::Workbench::Parser->new(
        file => '/path/to/file.mwb',
    );

dump

dump the database structure as YAML

    my $yaml = $parser->dump;

get_datatype

get datatype for a workbench column datatype

    my $datatype = $table->get_datatype( 'com.mysql.rdbms.mysql.datatype.mediumtext' );

returns the MySQL name of the datatype

    MEDIUMTEXT

ATTRIBUTES

WARNINGS

The ER model designed with Workbench is checked for:

  • duplicate indices

  • duplicate table names

  • duplicate column names in a table

AUTHOR

Renee Baecker <reneeb@cpan.org>

COPYRIGHT AND LICENSE

This software is Copyright (c) 2018 by Renee Baecker.

This is free software, licensed under:

  The Artistic License 2.0 (GPL Compatible)