fi/mysql-workbench-schema-exporter

Monday, July 30, 2018
by manzolo
Repository
2 Watchers
0 Stars
703 Installations

PHP
1 Dependents
0 Suggesters
128 Forks
0 Open issues
14 Versions
0 % Grown

The README.md

README

What is MySQL Workbench Schema Exporter?

MySQL Workbench Schema Exporter is a library to transform the MySQL Workbench model (*.mwb) to useful another schemas., _(*1)

It is inspired by mysql-workbench-doctrine-plugin., _(*2)

Currently, MySQL Workbench Schema Exporter can export the model to various schemas using a formatter plugin:, _(*3)

Doctrine 1.0 YAML Schema.
Doctrine 2.0 YAML Schema, Annotation Classes or Annotation Classes with Zend Framework 2 Input Filter support.
Zend DbTable.
Zend Rest Controller.
Sencha ExtJS3 Model.
Sencha ExtJS4 Model.
Propel XML Schema and YAML Schema.
Node Sequelize.

The actual conversion to another schema is done using an exporter. These plugins are available in subprojects: * Doctrine1 Exporter * Doctrine2 Exporter * Propel1 Exporter * Zend Framework 1 Exporter * Node Exporter, _(*4)

Prerequisites

PHP 5.4+
Composer to install the dependencies

Installation

Using Composer

In your project directory issue:, _(*5)

php composer.phar require --dev mysql-workbench-schema-exporter/mysql-workbench-schema-exporter, _(*6)
You then can invoke the CLI script using vendor/bin/mysql-workbench-schema-export., _(*7)
You can directly require an exporter for your project:, _(*8)

php composer.phar require --dev mysql-workbench-schema-exporter/doctrine2-exporter, _(*9)

Stand alone

Get the source code using Git or download from Github.
Get composer.
Install dependencies:, _(*10)

php composer.phar install, _(*11)
You then can invoke the CLI script using bin/mysql-workbench-schema-export., _(*12)

Configuring MySQL Workbench Schema Exporter

MySQL Workbench Schema Exporter can be configured at runtime using methods:, _(*13)

Setup options.
Model comment, either applied to table, column, or foreign key object.

Both methods accept different options, and generally divided as common options and exporter (formatter) specific options., _(*14)

Common Setup Options

General options applied to all formatter., _(*15)

filename, _(*16)

The output filename format, use the following tag %schema%, %table%, %entity%, and %extension% to allow the filename to be replaced with contextual data., _(*17)

Default is %entity%.%extension%., _(*18)
indentation, _(*19)

The indentation size for generated code., _(*20)
useTabs, _(*21)

Use tabs for indentation instead of spaces. Setting this option will ignore the indentation-option., _(*22)
eolDelimeter, _(*23)

EOL type for generated code. Supported EOLs are win and unix., _(*24)
addGeneratorInfoAsComment, _(*25)

Add generator information to the generated code as a comment., _(*26)

Default is true., _(*27)
skipPluralNameChecking, _(*28)

Skip checking the plural name of model and leave as is, useful for non English table names., _(*29)

Default is false., _(*30)
backupExistingFile, _(*31)

If target already exists create a backup before replacing the content., _(*32)

Default is true., _(*33)
enhanceManyToManyDetection, _(*34)

If enabled, many to many relations between tables will be added to generated code., _(*35)

Default is true., _(*36)
sortTablesAndViews, _(*37)

If enabled, sorting of tables and views is performed prior to code generation for each table and view. For table, it sorted by table model name and for view sorted by view model name., _(*38)

Default is true., _(*39)
exportOnlyTableCategorized, _(*40)

If specified, only export the tables if its category matched., _(*41)
logToConsole, _(*42)

If enabled, output the log to console., _(*43)

Default is false., _(*44)
logFile, _(*45)

If specified, output the log to a file. If this option presence, option logToConsole will be ignored instead., _(*46)

Default is empty., _(*47)
stripMultipleUnderscores, _(*48)

If enabled, consider multiple underscores as single ones so for example, a table named user__group will still produce a UserGroup entity., _(*49)

Default is false., _(*50)
asIsUserDatatypePrefix, _(*51)

This option gives the ability to bypass user type convertion and forward user type to models, as is., _(*52)

For example, if defined to _, and a user type _BOOLEAN is defined in MySQL Workbench (resolving to TINYINT(1), for example, but no matter), then the model field will have BOOLEAN., _(*53)

It is usefull for non MySQL types like BOOLEAN or JSONB that certain ORMs can handle., _(*54)

Default is "" (disabled)., _(*55)

Common Model Comment Behavior

{MwbExporter:external}true{/MwbExporter:external} (applied to Table, View), _(*56)

Mark table/view as external to skip table/view code generation. For Doctrine use {d:external}true{/d:external} instead., _(*57)
{MwbExporter:category}mycategory{/MwbExporter:category} (applied to Table), _(*58)

Table category used to groups the table for sorting. This way, generated table output can be sorted as you need such as in Propel YAML schema (obviously useful for exporter which results in single file output)., _(*59)

Formatter Setup Options

Command Line Interface (CLI)

The mysql-workbench-schema-export command helps export a workbench schema model directly from command line. It has feature to customize export configuration before exporting. By default, it will use config file export.json located in the current directory to supply the parameter if it find it. To disable this behaviour, see the option below., _(*60)

Command usage:, _(*61)

php bin/mysql-workbench-schema-export [options] FILE [DEST]

Where:, _(*62)

FILE, _(*63)

The MySQL Workbench model file to export., _(*64)
DEST, _(*65)

The destination directory (optional), if not specified current directory assumed., _(*66)

Options:, _(*67)

--export=type, _(*68)

Choose the result of the export, supported type can be obtained using --list-exporter. If this option is omitted and no config file found, the CLI will prompt to choose which exporter to use., _(*69)
--config=file, _(*70)

Read export parameters from file (in JSON format)., _(*71)
--saveconfig, _(*72)

Save export parameters to file export.json, later can be used as value for --config=file., _(*73)
--list-exporter, _(*74)

Show all available exporter., _(*75)
--no-auto-config, _(*76)

Disable automatic config file lookup., _(*77)
--zip, _(*78)

Compress the result., _(*79)
--help, _(*80)

Show the usage (or suppress any parameters)., _(*81)

Sample usage:, _(*82)

php bin/mysql-workbench-schema-export --export=doctrine1-yaml example/data/test.mwb ./generated
php bin/mysql-workbench-schema-export --zip example/data/test.mwb

Sample export parameters (JSON) for doctrine2-annotation:, _(*83)

{
    "export": "doctrine2-annotation",
    "zip": false,
    "dir": "temp",
    "params": {
        "backupExistingFile": true,
        "skipPluralNameChecking": false,
        "enhanceManyToManyDetection": true,
        "bundleNamespace": "",
        "entityNamespace": "",
        "repositoryNamespace": "",
        "useAnnotationPrefix": "ORM\\",
        "useAutomaticRepository": true,
        "indentation": 4,
        "filename": "%entity%.%extension%",
        "quoteIdentifier": false
    }
}

Using MySQL Workbench Schema Exporter as Library

If you want to use MySQL Workbench Schema Exporter as a library for other project. See the included usage in the example folder., _(*84)

library mysql-workbench-schema-exporter

fi/mysql-workbench-schema-exporter

The README.md

README

What is MySQL Workbench Schema Exporter?

Prerequisites

Installation

Using Composer

Stand alone

Configuring MySQL Workbench Schema Exporter

Common Setup Options

Common Model Comment Behavior

Formatter Setup Options

Command Line Interface (CLI)

Using MySQL Workbench Schema Exporter as Library

Test Database

Links

The Versions

v1.0.0

dev-master

The Requires

by Johannes Mueller

by Toha

by Robert Vock

v3.0.3

The Requires

by Johannes Mueller

by Toha

by Robert Vock

v3.0.2

The Requires

by Johannes Mueller

by Toha

by Robert Vock

v3.0.1

The Requires

by Johannes Mueller

by Toha

by Robert Vock

v3.0.0

The Requires

by Johannes Mueller

by Toha

by Robert Vock

v2.1.6

The Requires

by Johannes Mueller

by Toha

v2.1.5

The Requires

by Johannes Mueller

by Toha

v2.1.4

The Requires

by Johannes Mueller

by Toha

v2.1.3

The Requires

by Johannes Mueller

by Toha

v2.1.2

The Requires

by Johannes Mueller

by Toha

v2.1.1

The Requires

by Johannes Mueller

by Toha

v2.1.0

The Requires

by Johannes Mueller

by Toha

v2.0.0

The Requires

by Johannes Mueller

by Toha