NAME

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

VERSION

version 1.10

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

• 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)