mwbmodelcommand Batch model class generation with relations from MySQL workbench mwb file

  1. Documentation
  2. Change Log

This is a Yii shell command to help generate model classes with relations descriptions.

If you use MySQL workbench for your database design, and have all the relationships defined on the diagram, this will help you to translated them into Yii model classes. So you can always maintain your database schema and relationships in the visual way, and not worry about create or update relations in model class files.

And it's a batch process, which read all the tables from the database connection, and parse the mwb file for corresponding relationships and create the model class file instantly.

It doesn't require innodb, so long as you've got relation on the ERD, it should work for you, and it can tell 1:1,1:M and M:M relationships.

Resources

Documentation

Requirements
  • Yii 1.0 or above
  • MySQL Workbench 5.0 or above
  • PHP 5 with zip and simplexml enabled
Installation
  • Extract the release file under 'framewok/cli'
  • It should not overwrite any original Yii Framework file

We have developed it under the framework purely because it's not project specific and should be available to any newly created projects.

Usage

At Yii shell, ~~~ > mwbmodel [mwb-file] ~~~ This command generates model classes with relationships parsed from MySQL workbench mwb file. * mwb-file: required, mwb file.

Change Log

February 17, 2009

R2404 Minor Bug Fix Release
Fixed file path with backslash problem on windows platform

February 6, 2009

R2402 Bug fix release, tested with 1.0.2
Works better with composite keys (PK with more than one field)

February 5, 2009

R2393 Initial beta release.

9 1
5 followers
2 547 downloads
Yii Version: 1.1
License: BSD-2-Clause
Category: Database
Tags:
Developed by: unikly
Created on: Feb 5, 2009
Last updated: 14 years ago

Downloads

show all