NAME

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

VERSION

version 1.11

SYNOPSIS

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

    # access tables of the workbench ER model
    my @tables = @{ $parser->tables };

    # access views of the workbench ER model
    my @views = @{ $parser->views };

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

• tables

  An array of MySQL::Workbench::Parser::Table objects

      my @tables = $parser->tables;

• views

  An array of MySQL::Workbench::Parser::View objects

      my @views = $parser->views;

• file

• datatypes

• dom

  The DOM created by XML::LibXML.

• lint

  If set to false, the linting isn't done (default: true)

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)

cpanm MySQL::Workbench::Parser

perl -MCPAN -e shell
install MySQL::Workbench::Parser