NAME

MySQL::Workbench::Parser::View - A view of the ER model

VERSION

version 1.11

METHODS

as_hash

return info about a view as a hash

my %info = $view->as_hash;

returns

(
    name       => 'view_name',
    definition => 'CREATE VIEW `view_name` AS SELECT ...',
    columns    => [
        name          => 'id',
        datatype      => 'INT',
        length        => '',
        precision     => '0',
        not_null      => '1',
        autoincrement => '1',
        default_value => '',
    ],
)

get_datatype

get datatype for a workbench column datatype

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

returns the MySQL name of the datatype

MEDIUMTEXT

ATTRIBUTES

  • comment

  • name

  • definition

  • node

  • parser

  • column_mapping

MISC

BUILD

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)